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-10T08:49:48.186339+00:00","dedupe_key":"signal_enriched:news_delta:4e3f0a18f291da4f","evidence_event_ids":["evt_5837d2adf474"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPMHlGQThnOENIVEQ5U3BXV2RwOHlILXRCeEtvR0VRNlhpRi16ZXUxY19DYkJZc1BjNXlFandYOWk1U1F1Uzk2dHQzOWZUY1dtY3lOLXJtVlpoNEdCaGxqOFdTMUdLN0JRd3p4aDA0MGJYMS10Q2hvLWxTWXNzUEd3eDNrd1dCUmhmTU5sSVdPY2dyMmE1YzNPWnZLc0g?oc=5","as_of":"2026-04-10T08:49:48.186339+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/CBMinAFBVV95cUxPMHlGQThnOENIVEQ5U3BXV2RwOHlILXRCeEtvR0VRNlhpRi16ZXUxY19DYkJZc1BjNXlFandYOWk1U1F1Uzk2dHQzOWZUY1dtY3lOLXJtVlpoNEdCaGxqOFdTMUdLN0JRd3p4aDA0MGJYMS10Q2hvLWxTWXNzUEd3eDNrd1dCUmhmTU5sSVdPY2dyMmE1YzNPWnZLc0g?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c52fd139862cc352","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-10T08:50:31.439058+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPMHlGQThnOENIVEQ5U3BXV2RwOHlILXRCeEtvR0VRNlhpRi16ZXUxY19DYkJZc1BjNXlFandYOWk1U1F1Uzk2dHQzOWZUY1dtY3lOLXJtVlpoNEdCaGxqOFdTMUdLN0JRd3p4aDA0MGJYMS10Q2hvLWxTWXNzUEd3eDNrd1dCUmhmTU5sSVdPY2dyMmE1YzNPWnZLc0g?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/CBMinAFBVV95cUxPMHlGQThnOENIVEQ5U3BXV2RwOHlILXRCeEtvR0VRNlhpRi16ZXUxY19DYkJZc1BjNXlFandYOWk1U1F1Uzk2dHQzOWZUY1dtY3lOLXJtVlpoNEdCaGxqOFdTMUdLN0JRd3p4aDA0MGJYMS10Q2hvLWxTWXNzUEd3eDNrd1dCUmhmTU5sSVdPY2dyMmE1YzNPWnZLc0g?oc=5","source_event_id":"evt_5837d2adf474","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bd2f3059fd366e6b","published_at":"2026-04-10T00:41:46+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Pentagon","relevance":"directly affected by the ruling","symbol":"","type":"government_body"},{"asset_class":"court","name":"Judge (unnamed in provided text)","relevance":"issued the ruling voiding restrictions and ordering restoration","symbol":"","type":"judicial_officer"},{"asset_class":"government_official","name":"Hegseth (Pete Hegseth)","relevance":"referenced as attempting a second restriction of reporters","symbol":"","type":"person"},{"asset_class":"media","name":"Reporters / press","relevance":"the access restrictions were aimed at limiting their access","symbol":"","type":"group"}],"event_type":"regulation","information_gaps":["The specific court name/jurisdiction and the exact date of the ruling are not provided in the supplied text.","The precise nature/scope of the \u201clatest press restrictions\u201d (e.g., which procedures, locations, or rules) is not detailed.","Whether the Pentagon plans to appeal or how quickly restoration must occur is not stated in the provided text.","The identity of the judge is not included in the provided excerpt."],"key_facts":["Politico reports a court voided the Pentagon\u2019s latest press restrictions.","The New York Times summary states the judge rejected Hegseth\u2019s second attempt to restrict reporters at the Pentagon.","CNN summary states the judge ruled the Pentagon violated a court order to restore press access.","The Washington Post summary states the judge ordered the Pentagon to restore press access."],"numeric_claims":[],"primary_claim":"A court voided the Pentagon\u2019s latest press restrictions and ordered the Pentagon to restore press access after finding it violated a court order.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"A judge has voided the Pentagon\u2019s latest attempt to restrict press access, ruling that the Pentagon violated a court order to restore access. The decision blocks further enforcement of the press restrictions and orders restoration of press access.","topics":["press access","Pentagon","court ruling","reporters","compliance with court orders"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Court voids latest Pentagon press restrictions Politico Judge Rejects Hegseth\u2019s Second Attempt to Restrict Reporters at Pentagon The New York Times Judge blocks Pentagon\u2019s latest bid to limit press access in scathing ruling CNN Pentagon violated court order to restore press access, judge rules The Washington Post Judge orders Pentagon to restore press access The Hill","title":"Court voids latest Pentagon press restrictions - Politico","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 15058 in events