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-04T01:24:40.329623+00:00","dedupe_key":"signal_enriched:news_delta:4df0cb783e6fc4bb","evidence_event_ids":["evt_5328bfc6b92e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPQUh0alVXdWhWUEpFLTRNeGRzanR3bWJkMDl3aUxDTEZYdVJsM3l0MnRSSzBfdjdKWjlVT3JaWVhZVjh1SkI5ckZSVjR4aW02dWtZWFZXd1luaDJ1NlBZSTNMTDRWUkJheEdESmpMQlYtYVlSUndPU1ZZS1NJV0RLYW0wY0x4dkF0?oc=5","as_of":"2026-04-04T01:24:40.329623+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPQUh0alVXdWhWUEpFLTRNeGRzanR3bWJkMDl3aUxDTEZYdVJsM3l0MnRSSzBfdjdKWjlVT3JaWVhZVjh1SkI5ckZSVjR4aW02dWtZWFZXd1luaDJ1NlBZSTNMTDRWUkJheEdESmpMQlYtYVlSUndPU1ZZS1NJV0RLYW0wY0x4dkF0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c961804c5fa33372","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=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T01:25:09.809003+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPQUh0alVXdWhWUEpFLTRNeGRzanR3bWJkMDl3aUxDTEZYdVJsM3l0MnRSSzBfdjdKWjlVT3JaWVhZVjh1SkI5ckZSVjR4aW02dWtZWFZXd1luaDJ1NlBZSTNMTDRWUkJheEdESmpMQlYtYVlSUndPU1ZZS1NJV0RLYW0wY0x4dkF0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPQUh0alVXdWhWUEpFLTRNeGRzanR3bWJkMDl3aUxDTEZYdVJsM3l0MnRSSzBfdjdKWjlVT3JaWVhZVjh1SkI5ckZSVjR4aW02dWtZWFZXd1luaDJ1NlBZSTNMTDRWUkJheEdESmpMQlYtYVlSUndPU1ZZS1NJV0RLYW0wY0x4dkF0?oc=5","source_event_id":"evt_5328bfc6b92e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5292a8e82d49a92a","published_at":"2026-04-03T23:56:21+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"government","name":"Department of Justice","relevance":"high","symbol":"N/A","type":"government"}],"event_type":"regulation","information_gaps":["Uncertainty about the legal implications of this claim.","Potential reactions from other political entities or future presidents."],"key_facts":["Trump's DOJ states he can hold onto government documents after leaving office.","The law requiring turnover of records is claimed to be unconstitutional."],"numeric_claims":[],"primary_claim":"Trump's Department of Justice claims that the law requiring presidents to turn over records at the end of their administration is unconstitutional.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Trump's DOJ has indicated that he can retain government documents after leaving office, potentially setting a precedent for future presidents.","topics":["government records","Trump","Department of Justice","Presidential Records Act"]},"source":"politico.com","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump move to shield White House records could give other presidents the same cover politico.com Trump\u2019s DOJ tells Trump he can hold onto government docs when he leaves office, contrary to Watergate-era law CNN Justice Department says law requiring president to turn over records at end of administration is unconstitutional CBS News Justice Dept. says the Presidential Records Act is \u2018unconstitutional\u2019 The Washington Post Exclusive: Trump's DOJ says he's not required to turn over official records Axios","title":"Trump move to shield White House records could give other presidents the same cover - politico.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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 9699 in events