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/CBMigwFBVV95cUxQN0xkSU1tTDUzaUZ0UUNtOC1GbW5kQ091Nzdab1Q1dGFvUDZveC1EdW5EM3dZX3BtVE1CaGpRNU9OTlVzZ1Y4X094TF9PNTNxM2tZSDE3Qnc5cU1LQVJRY0djUzlWYnpXUnN1Y2ZtNEFlTGtRdXJwSDRKS05UdDFVLURRaw?oc=5","as_of":"2026-04-09T18:00:21.966738+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/CBMigwFBVV95cUxQN0xkSU1tTDUzaUZ0UUNtOC1GbW5kQ091Nzdab1Q1dGFvUDZveC1EdW5EM3dZX3BtVE1CaGpRNU9OTlVzZ1Y4X094TF9PNTNxM2tZSDE3Qnc5cU1LQVJRY0djUzlWYnpXUnN1Y2ZtNEFlTGtRdXJwSDRKS05UdDFVLURRaw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_24f8aa77ed05a7b0","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-10T00:11:49.584025+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQN0xkSU1tTDUzaUZ0UUNtOC1GbW5kQ091Nzdab1Q1dGFvUDZveC1EdW5EM3dZX3BtVE1CaGpRNU9OTlVzZ1Y4X094TF9PNTNxM2tZSDE3Qnc5cU1LQVJRY0djUzlWYnpXUnN1Y2ZtNEFlTGtRdXJwSDRKS05UdDFVLURRaw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQN0xkSU1tTDUzaUZ0UUNtOC1GbW5kQ091Nzdab1Q1dGFvUDZveC1EdW5EM3dZX3BtVE1CaGpRNU9OTlVzZ1Y4X094TF9PNTNxM2tZSDE3Qnc5cU1LQVJRY0djUzlWYnpXUnN1Y2ZtNEFlTGtRdXJwSDRKS05UdDFVLURRaw?oc=5","source_event_id":"evt_47dbd958218f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f3d46ba7ff569e9","published_at":"2026-04-09T16:43:59+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"House Republicans","relevance":"high","symbol":"","type":"political_party_group"},{"asset_class":"political","name":"House Democrats","relevance":"high","symbol":"","type":"political_party_group"},{"asset_class":"political","name":"Chuck Schumer","relevance":"medium","symbol":"","type":"person"},{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling; the extracted claims rely on the headline and the provided source summary rather than the full article body.","The specific legislative vehicle (bill/resolution number) and the exact provisions Republicans used to block the effort are not stated in the provided text.","Near-term timing/catalyst details (e.g., when the vote occurred or next procedural steps) are not included in the provided material."],"key_facts":["Axios reports House Republicans blocked Democrats\u2019 long-shot attempt to hamstring Trump on Iran.","Other cited outlets in the provided source summary similarly describe Democrats failing to pass a symbolic war-powers resolution after Republicans thwarted the effort.","The dispute is framed around reinining Trump\u2019s Iran war effort/war powers."],"numeric_claims":[],"primary_claim":"House Republicans quashed Democrats\u2019 long-shot attempt to rein in Trump\u2019s Iran war powers/war effort.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"House Republicans blocked a Democratic effort to limit or \u201chamstring\u201d President Trump\u2019s Iran-related war powers, according to Axios. The immediate political outcome is Democrats failing to pass a symbolic war-powers curbing measure.","topics":["US Congress","war powers","Iran","Trump","symbolic resolution","party-line opposition"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"House Republicans quash Democrats' long-shot attempt to hamstring Trump on Iran Axios Live updates: GOP rebuffs Dems' push to rein in Trump's war effort NBC News Schumer blasts Trump\u2019s Iran war as failure, moves to rein in his war powers amid ceasefire Fox News Democratic lawmakers fail in symbolic bid to curb Trump\u2019s Iran war powers The Times of Israel House Democrats fail to pass symbolic war powers resolution after Republicans thwart effort \u2013 US politics live The Guardian","title":"House Republicans quash Democrats' long-shot attempt to hamstring Trump on Iran - Axios","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_464916d05e9b in signals