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-04T10:47:14.034030+00:00","dedupe_key":"signal_enriched:news_delta:9168fdf6d6e6279f","evidence_event_ids":["evt_42f286e9f7ed"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQbUZZcDAtdTB1UUFtM0daVllrUTJKOG91V2VrREdFdy01d25EczRFTUlrcDZCQ2tlRFdxRjRWSEltR1FQelpscDN4aHBlOUR2U2w3bkJPR3JmQThUODYtMk0zN09YSXZPWkRBTE1obWF3U1FYQTNYOFYxRnBoaEFxcjIyVVlXd3R3d0V6MnV4UVp6WUNTa1V0eVJKSWxqai1BUHBRQm1R?oc=5","as_of":"2026-04-04T10:47:14.034030+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQbUZZcDAtdTB1UUFtM0daVllrUTJKOG91V2VrREdFdy01d25EczRFTUlrcDZCQ2tlRFdxRjRWSEltR1FQelpscDN4aHBlOUR2U2w3bkJPR3JmQThUODYtMk0zN09YSXZPWkRBTE1obWF3U1FYQTNYOFYxRnBoaEFxcjIyVVlXd3R3d0V6MnV4UVp6WUNTa1V0eVJKSWxqai1BUHBRQm1R?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_797497f2357a8d15","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T10:47:53.544354+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQbUZZcDAtdTB1UUFtM0daVllrUTJKOG91V2VrREdFdy01d25EczRFTUlrcDZCQ2tlRFdxRjRWSEltR1FQelpscDN4aHBlOUR2U2w3bkJPR3JmQThUODYtMk0zN09YSXZPWkRBTE1obWF3U1FYQTNYOFYxRnBoaEFxcjIyVVlXd3R3d0V6MnV4UVp6WUNTa1V0eVJKSWxqai1BUHBRQm1R?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wral.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQbUZZcDAtdTB1UUFtM0daVllrUTJKOG91V2VrREdFdy01d25EczRFTUlrcDZCQ2tlRFdxRjRWSEltR1FQelpscDN4aHBlOUR2U2w3bkJPR3JmQThUODYtMk0zN09YSXZPWkRBTE1obWF3U1FYQTNYOFYxRnBoaEFxcjIyVVlXd3R3d0V6MnV4UVp6WUNTa1V0eVJKSWxqai1BUHBRQm1R?oc=5","source_event_id":"evt_42f286e9f7ed","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"14edcc9b04170fa8","published_at":"2026-04-04T02:38:00+00:00","publisher_domain":"wral.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"North Carolina","relevance":"directly involved in the lawsuit","symbol":"NC","type":"state"},{"asset_class":"political","name":"Donald Trump","relevance":"subject of the lawsuit","symbol":"TRUMP","type":"individual"}],"event_type":"conflict","information_gaps":["Details on the specific legal arguments being made in the lawsuit are not provided.","The timeline for the lawsuit's progression is unclear."],"key_facts":["North Carolina joins a lawsuit against Trump's mail-in ballot order.","The lawsuit claims the order is unconstitutional.","Multiple Democrat-led states are involved in similar lawsuits."],"numeric_claims":[],"primary_claim":"North Carolina joins a lawsuit against Trump's mail-in ballot order, claiming it is unconstitutional.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"North Carolina has joined a lawsuit against Trump's mail-in ballot order, labeling it an unconstitutional power grab, amidst similar actions from other Democrat-led states.","topics":["lawsuit","mail-in voting","Trump administration","constitutional law"]},"source":"WRAL","source_domain":"wral.com","source_url":"https://www.wral.com","summary":"NC joins lawsuit over Trump\u2019s mail-in ballot order, calling it an unconstitutional power grab WRAL Two dozen Democrat-led states sue Trump over mail-in ballot limits Al Jazeera Trump\u2019s new role for USPS in mail balloting is unconstitutional, three lawsuits say CNN Democratic attorneys general sue Trump over order to restrict mail voting The Guardian Election clerks in Colorado react to Trump's executive order on voting by mail CBS News","title":"NC joins lawsuit over Trump\u2019s mail-in ballot order, calling it an unconstitutional power grab - WRAL","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/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 13433 in events