SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTE9UZ3dEM3RLOHdTU21zclVWUG1US2FmZlh0SWI5RWZnVDBYdThBa3k0OXNoNzBUTVdudjRlSTJIRVQzdTByWkFCWHVTWGs0UHZvVWVtQ3pheVA3Q2ZGTlHSAWNBVV95cUxNUTVSMG1peFA0SUVXQ2xzZ204SnZhcW0xQUxlMmJxYTNvQVNGUmtqbGRiOUpuOHlyZ0pVZm1wa20xRGs2cHdsTVhicmJqWnhiSEMtd1o1SzRnMDRqa2VKVGFBUWc?oc=5","as_of":"2026-04-10T03:04:31.796915+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTE9UZ3dEM3RLOHdTU21zclVWUG1US2FmZlh0SWI5RWZnVDBYdThBa3k0OXNoNzBUTVdudjRlSTJIRVQzdTByWkFCWHVTWGs0UHZvVWVtQ3pheVA3Q2ZGTlHSAWNBVV95cUxNUTVSMG1peFA0SUVXQ2xzZ204SnZhcW0xQUxlMmJxYTNvQVNGUmtqbGRiOUpuOHlyZ0pVZm1wa20xRGs2cHdsTVhicmJqWnhiSEMtd1o1SzRnMDRqa2VKVGFBUWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0bdcabdf0bdb3041","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T03:41:05.101291+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTE9UZ3dEM3RLOHdTU21zclVWUG1US2FmZlh0SWI5RWZnVDBYdThBa3k0OXNoNzBUTVdudjRlSTJIRVQzdTByWkFCWHVTWGs0UHZvVWVtQ3pheVA3Q2ZGTlHSAWNBVV95cUxNUTVSMG1peFA0SUVXQ2xzZ204SnZhcW0xQUxlMmJxYTNvQVNGUmtqbGRiOUpuOHlyZ0pVZm1wa20xRGs2cHdsTVhicmJqWnhiSEMtd1o1SzRnMDRqa2VKVGFBUWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTE9UZ3dEM3RLOHdTU21zclVWUG1US2FmZlh0SWI5RWZnVDBYdThBa3k0OXNoNzBUTVdudjRlSTJIRVQzdTByWkFCWHVTWGs0UHZvVWVtQ3pheVA3Q2ZGTlHSAWNBVV95cUxNUTVSMG1peFA0SUVXQ2xzZ204SnZhcW0xQUxlMmJxYTNvQVNGUmtqbGRiOUpuOHlyZ0pVZm1wa20xRGs2cHdsTVhicmJqWnhiSEMtd1o1SzRnMDRqa2VKVGFBUWc?oc=5","source_event_id":"evt_3aa540dabef8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fc0d959a3bb5a46","kind":"sector_rotation","published_at":"2026-04-06T05:15:48+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"RTX","relevance":"high","symbol":"RTX","type":"company"}],"event_type":"listing","information_gaps":["No sector gainers/losers are explicitly listed in the provided text; only \u201cdefense sector rotation\u201d is mentioned.","No macro driver (e.g., rates, geopolitics, procurement policy) is described in the provided text.","No evidence is provided in the provided text to determine whether this is a regime shift versus short-term rebalancing.","The provided article text appears to be mostly HTML/CSS and does not include the substantive content beyond the headline/summary; therefore, details supporting the claims are missing."],"key_facts":["Headline states RTX has a \u201c$268 Billion Backlog.\u201d","Headline states the backlog \u201clocks in 2026 cash flow.\u201d","Headline frames the idea as a \u201cConviction Buy.\u201d","Headline references \u201cDefense Sector Rotation.\u201d"],"numeric_claims":[{"label":"Backlog size","value":"$268 Billion"},{"label":"Cash flow year referenced","value":"2026"}],"primary_claim":"RTX has a $268 billion backlog that is expected to lock in 2026 cash flow, supporting a \u201cconviction buy\u201d thesis tied to defense sector rotation.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The signal claims RTX\u2019s $268B backlog provides visibility into 2026 cash flow and frames RTX as a \u201cconviction buy\u201d amid a defense-sector rotation.","topics":["defense sector rotation","RTX backlog","2026 cash flow","investment thesis"]},"source":"Bitget","source_domain":"gstatic.com","summary":"RTX's $268 Billion Backlog Locks in 2026 Cash Flow\u2014A Conviction Buy Amid Defense Sector Rotation Bitget","tickers":[],"title":"RTX's $268 Billion Backlog Locks in 2026 Cash Flow\u2014A Conviction Buy Amid Defense Sector Rotation - Bitget","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_354170b6f1b4 in signals