SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_a4031ad54ca9 in signals