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/CBMikAFBVV95cUxOcHh6YzZjUUViTVdKRU1SRlNLWmdrYnVqQUQwMmoxSXg2MW0yblBLay1rbU9iMV9xTnZ3OWRpWUhNalV2bnExdl8xWmlJWmJqVUw2QVg5RUZCZU8wdndCYjJfZURKY29RZ2ozeGl6UHR1dVU0WDlsOG55Y0ZKV290WklDTnM1S2VldG1VT1RjNWw?oc=5","as_of":"2026-04-09T23:34:26.725795+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/CBMikAFBVV95cUxOcHh6YzZjUUViTVdKRU1SRlNLWmdrYnVqQUQwMmoxSXg2MW0yblBLay1rbU9iMV9xTnZ3OWRpWUhNalV2bnExdl8xWmlJWmJqVUw2QVg5RUZCZU8wdndCYjJfZURKY29RZ2ozeGl6UHR1dVU0WDlsOG55Y0ZKV290WklDTnM1S2VldG1VT1RjNWw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2b60b18de84f6b60","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:52:56.079689+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOcHh6YzZjUUViTVdKRU1SRlNLWmdrYnVqQUQwMmoxSXg2MW0yblBLay1rbU9iMV9xTnZ3OWRpWUhNalV2bnExdl8xWmlJWmJqVUw2QVg5RUZCZU8wdndCYjJfZURKY29RZ2ozeGl6UHR1dVU0WDlsOG55Y0ZKV290WklDTnM1S2VldG1VT1RjNWw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOcHh6YzZjUUViTVdKRU1SRlNLWmdrYnVqQUQwMmoxSXg2MW0yblBLay1rbU9iMV9xTnZ3OWRpWUhNalV2bnExdl8xWmlJWmJqVUw2QVg5RUZCZU8wdndCYjJfZURKY29RZ2ozeGl6UHR1dVU0WDlsOG55Y0ZKV290WklDTnM1S2VldG1VT1RjNWw?oc=5","source_event_id":"evt_92e5489769db","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3cf76433e90c5f5","published_at":"2026-04-09T21:54:23+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Pentagon","relevance":"directly affected by the court order","symbol":"","type":"government_body"},{"asset_class":"government","name":"US judge (federal judge)","relevance":"issued the order and found a violation","symbol":"","type":"judicial_authority"},{"asset_class":"media","name":"Press / reporters (CNN, CBS, AP, The Washington Post, Reuters)","relevance":"beneficiaries of restored access; referenced in the provided summary","symbol":"","type":"media_outlets"}],"event_type":"regulation","information_gaps":["The specific court name, judge name, and the date of the ruling are not provided in the supplied text.","The exact scope/conditions of \u201cpress access\u201d (which events, facilities, or procedures) are not specified in the provided text.","The timeline for when the Pentagon must restore access (immediate vs. by a deadline) is not stated in the provided text.","The nature of the Pentagon\u2019s \u201clatest bid\u201d (what limitation was attempted) is not detailed in the provided text."],"key_facts":["A US judge ordered the Pentagon to restore press access.","The judge ruled the Pentagon violated a court order to restore press access.","The judge blocked the Pentagon\u2019s latest bid to limit press access.","Multiple outlets (Reuters, The Washington Post, CNN, CBS News, AP News) are referenced as reporting the ruling."],"numeric_claims":[],"primary_claim":"A US judge ruled the Pentagon violated a court order and ordered it to restore press access to reporters.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"A US federal judge ordered the Pentagon to restore press access, ruling the Pentagon violated a prior court order. The decision blocks the Pentagon\u2019s latest attempt to limit reporter access.","topics":["press access","court order compliance","Pentagon","US federal judiciary","media access"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"US judge orders Pentagon to restore press access Reuters Pentagon violated court order to restore press access, judge rules The Washington Post Judge blocks Pentagon\u2019s latest bid to limit press access CNN Judge says Pentagon must restore press access CBS News Federal judge finds Pentagon is violating court order to restore access to reporters AP News","title":"US judge orders Pentagon to restore press access - Reuters","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_eaf060a04412 in signals