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-09T23:19:20.992681+00:00","dedupe_key":"signal_enriched:news_delta:a577b91e2afe23ed","evidence_event_ids":["evt_39cb5e47047f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOcDJBNS1ldXBpYnB5dG9ZRnVqRklvdk1FZjdFWGRDYUo4VGZHN0hVb1dDWTNRYVFZa2Z5VkZpejZaX0pyNDlibzRLbVZJaGE2TFlIenIwVXBEZFFid2tMZHQwN05Zb2tRNEkzT0RmdkNKeFlTb2MwMHRUaGV4MHpGMmNDNXY1QQ?oc=5","as_of":"2026-04-09T23:19:20.992681+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/CBMihgFBVV95cUxOcDJBNS1ldXBpYnB5dG9ZRnVqRklvdk1FZjdFWGRDYUo4VGZHN0hVb1dDWTNRYVFZa2Z5VkZpejZaX0pyNDlibzRLbVZJaGE2TFlIenIwVXBEZFFid2tMZHQwN05Zb2tRNEkzT0RmdkNKeFlTb2MwMHRUaGV4MHpGMmNDNXY1QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_041a39b459ed0d92","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-10T00:51:14.732704+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOcDJBNS1ldXBpYnB5dG9ZRnVqRklvdk1FZjdFWGRDYUo4VGZHN0hVb1dDWTNRYVFZa2Z5VkZpejZaX0pyNDlibzRLbVZJaGE2TFlIenIwVXBEZFFid2tMZHQwN05Zb2tRNEkzT0RmdkNKeFlTb2MwMHRUaGV4MHpGMmNDNXY1QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOcDJBNS1ldXBpYnB5dG9ZRnVqRklvdk1FZjdFWGRDYUo4VGZHN0hVb1dDWTNRYVFZa2Z5VkZpejZaX0pyNDlibzRLbVZJaGE2TFlIenIwVXBEZFFid2tMZHQwN05Zb2tRNEkzT0RmdkNKeFlTb2MwMHRUaGV4MHpGMmNDNXY1QQ?oc=5","source_event_id":"evt_39cb5e47047f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f761791e46e4d77","published_at":"2026-04-09T22:43:19+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Pentagon","relevance":"high","symbol":"","type":"government_agency"},{"asset_class":"legal","name":"Federal judge","relevance":"high","symbol":"","type":"judicial_body"},{"asset_class":"media","name":"The Washington Post","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"CBS News","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"AP News","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"Yahoo","relevance":"low","symbol":"","type":"news_outlet"}],"event_type":"regulation","information_gaps":["The specific court name/jurisdiction and the original case details are not provided in the supplied text.","The exact scope of \u201cpress access\u201d (which events/locations/credentials) is not specified.","No timing details (e.g., deadline for compliance) are included in the provided excerpt.","The nature of the Pentagon\u2019s \u201clatest bid\u201d (what mechanism or policy change) is not described beyond \u201climit press access.\u201d","The headline delta does not include the prior headline or what changed between versions."],"key_facts":["A judge ruled the Pentagon violated a court order related to restoring press access.","The judge ordered the Pentagon to restore press access to reporters.","The Pentagon attempted to limit press access again, and a judge blocked that latest bid.","Multiple outlets (Washington Post, CBS News, CNN, AP News, Yahoo) reported the ruling and the compliance requirement."],"numeric_claims":[],"primary_claim":"The Pentagon violated a court order to restore press access, and the judge ruled it must restore access to reporters.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"A federal judge ruled that the Pentagon violated a court order requiring restoration of press access, and blocked the Pentagon\u2019s latest attempt to further limit that access. The ruling implies the Pentagon must comply with restoring reporter access on a near-term basis.","topics":["press access","court order compliance","Pentagon","federal court ruling","media access to government","journalism"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Pentagon violated court order to restore press access, judge rules The Washington Post Judge says Pentagon must restore press access CBS News Judge blocks Pentagon\u2019s latest bid to limit press access CNN Federal judge finds Pentagon is violating court order to restore access to reporters AP News US judge orders Pentagon to restore press access Yahoo","title":"Pentagon violated court order to restore press access, judge rules - The Washington Post","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 11588 in events