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/CBMinAFBVV95cUxQc2JTV2ItcmpaMTVrM0lDZkVkS05pQTRFdTZwdV90TDVQNk1JbTBzcTBuZVpBSEl1UmJWRDVIdGFCUVVaRXBZLXUwMmFNTER0RkRGSlRVeFMtdzZ6Yk9QNWpSTWw4UDg3cXlDNGxXbE00QXdHOFlYcFJQb3RndURJdWEtSGM4cktIcms0RVY5Q1pTQ3BCbVhWV0c1NEQ?oc=5","as_of":"2026-04-09T15:51:37.379749+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/CBMinAFBVV95cUxQc2JTV2ItcmpaMTVrM0lDZkVkS05pQTRFdTZwdV90TDVQNk1JbTBzcTBuZVpBSEl1UmJWRDVIdGFCUVVaRXBZLXUwMmFNTER0RkRGSlRVeFMtdzZ6Yk9QNWpSTWw4UDg3cXlDNGxXbE00QXdHOFlYcFJQb3RndURJdWEtSGM4cktIcms0RVY5Q1pTQ3BCbVhWV0c1NEQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7189ca497af5ccfd","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-09T23:42:56.180518+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQc2JTV2ItcmpaMTVrM0lDZkVkS05pQTRFdTZwdV90TDVQNk1JbTBzcTBuZVpBSEl1UmJWRDVIdGFCUVVaRXBZLXUwMmFNTER0RkRGSlRVeFMtdzZ6Yk9QNWpSTWw4UDg3cXlDNGxXbE00QXdHOFlYcFJQb3RndURJdWEtSGM4cktIcms0RVY5Q1pTQ3BCbVhWV0c1NEQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQc2JTV2ItcmpaMTVrM0lDZkVkS05pQTRFdTZwdV90TDVQNk1JbTBzcTBuZVpBSEl1UmJWRDVIdGFCUVVaRXBZLXUwMmFNTER0RkRGSlRVeFMtdzZ6Yk9QNWpSTWw4UDg3cXlDNGxXbE00QXdHOFlYcFJQb3RndURJdWEtSGM4cktIcms0RVY5Q1pTQ3BCbVhWV0c1NEQ?oc=5","source_event_id":"evt_509d7d4a9be2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ce53fc8c70713766","published_at":"2026-04-09T15:28:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"House Democrats","relevance":"directly driving the measure","symbol":"","type":"political_group"},{"asset_class":"political","name":"Republicans","relevance":"blocking the measure","symbol":"","type":"political_group"},{"asset_class":"political","name":"President Donald Trump","relevance":"whose war powers are targeted","symbol":"","type":"person"},{"asset_class":"government","name":"U.S. House of Representatives","relevance":"site of the Democrats\u2019 push and GOP blocking","symbol":"","type":"government_body"},{"asset_class":"government","name":"U.S. Senate","relevance":"expected to vote on a resolution to curb war powers","symbol":"","type":"government_body"},{"asset_class":"political","name":"Chuck Schumer","relevance":"criticized Trump\u2019s Iran war and moved to rein in war powers","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"subject of the war-powers dispute","symbol":"","type":"country"}],"event_type":"regulation","information_gaps":["The specific text/requirements of the proposed measure or resolution are not provided in the supplied content.","The exact timing/date of the Senate vote is not included.","The current status/outcome of the House effort (e.g., whether a vote occurred) is not specified beyond \u201cpush\u201d and \u201cblocked.\u201d","How the measure would practically change executive authority (e.g., funding, authorization thresholds, timelines) is not detailed in the provided text."],"key_facts":["House Democrats are pushing to pass a measure curbing Trump\u2019s war powers over Iran (The Guardian).","Republicans are blocking the effort to halt/limit Trump\u2019s war powers regarding Iran (NBC News; The Hill).","The U.S. Senate is expected to vote on a resolution to curb Trump\u2019s Iran war powers (Reuters).","Chuck Schumer criticized Trump\u2019s Iran war as a failure and moved to rein in his war powers amid a ceasefire (Fox News)."],"numeric_claims":[],"primary_claim":"House Democrats are attempting to pass legislation curbing Trump\u2019s war powers over Iran, while Republicans are blocking it and a Senate vote is expected soon.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"House Democrats are pushing to pass a measure that would curb President Trump\u2019s war powers regarding Iran, but Republicans are blocking the effort. The dispute is moving through Congress with a near-term Senate vote on a resolution to limit Trump\u2019s Iran war powers.","topics":["U.S. war powers","Iran conflict","Congressional action","House vote/blocking","Senate resolution","ceasefire context (mentioned)"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"House Democrats push to pass measure curbing Trump\u2019s war powers over Iran The Guardian Republicans block effort to halt Trump's war with Iran after 'civilization' threat NBC News GOP blocks Democrats\u2019 attempt to limit Trump\u2019s Iran war powers The Hill US Senate to vote on resolution to curb Trump's Iran war powers Reuters Schumer blasts Trump\u2019s Iran war as failure, moves to rein in his war powers amid ceasefire Fox News","title":"House Democrats push to pass measure curbing Trump\u2019s war powers over Iran - The Guardian","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_124eb6fbc17e in signals