SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T15:51:37.379749+00:00","dedupe_key":"signal_enriched:news_delta:15e5dca927286f7a","evidence_event_ids":["evt_509d7d4a9be2"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 10368 in events