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/CBMimAFBVV95cUxPTEx6aWszcktfV1pRYU5fdUQydEh2cndtQm9KbW1WZnVEY280NUxvcThNV2VJQVNiak5rX2hWVDVwdWJKVV9OUWROREt3dmFIQUxRbjhDb3N3eTdBRTNoRW14MFRBTEpyOUljZmpKQnE5QmNmZkxhckR3Y1VzQXNZVHdOVEFMWDcyV3lZSXZMOE4zeHNrcFE3cQ?oc=5","as_of":"2026-04-10T01:24:45.210850+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/CBMimAFBVV95cUxPTEx6aWszcktfV1pRYU5fdUQydEh2cndtQm9KbW1WZnVEY280NUxvcThNV2VJQVNiak5rX2hWVDVwdWJKVV9OUWROREt3dmFIQUxRbjhDb3N3eTdBRTNoRW14MFRBTEpyOUljZmpKQnE5QmNmZkxhckR3Y1VzQXNZVHdOVEFMWDcyV3lZSXZMOE4zeHNrcFE3cQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b44b5c2b2db85dff","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-10T01:26:09.511630+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPTEx6aWszcktfV1pRYU5fdUQydEh2cndtQm9KbW1WZnVEY280NUxvcThNV2VJQVNiak5rX2hWVDVwdWJKVV9OUWROREt3dmFIQUxRbjhDb3N3eTdBRTNoRW14MFRBTEpyOUljZmpKQnE5QmNmZkxhckR3Y1VzQXNZVHdOVEFMWDcyV3lZSXZMOE4zeHNrcFE3cQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPTEx6aWszcktfV1pRYU5fdUQydEh2cndtQm9KbW1WZnVEY280NUxvcThNV2VJQVNiak5rX2hWVDVwdWJKVV9OUWROREt3dmFIQUxRbjhDb3N3eTdBRTNoRW14MFRBTEpyOUljZmpKQnE5QmNmZkxhckR3Y1VzQXNZVHdOVEFMWDcyV3lZSXZMOE4zeHNrcFE3cQ?oc=5","source_event_id":"evt_735f1be55134","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"98c575195deb19d1","published_at":"2026-04-10T00:03:43+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Pete Hegseth","relevance":"high","symbol":"","type":"person"},{"asset_class":"government","name":"Pentagon","relevance":"high","symbol":"","type":"government_body"},{"asset_class":"","name":"reporters at the Pentagon","relevance":"high","symbol":"","type":"group"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Washington Post","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"CBS News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Hill","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"regulation","information_gaps":["The specific court name, judge name, and jurisdiction are not provided in the supplied text.","The exact nature/scope of the attempted reporter restrictions (e.g., specific rules, locations, or credentials) is not provided.","The timing of when press access must be restored (deadline) is not provided.","Whether the Pentagon or Hegseth is the direct party to the second attempt is not fully disambiguated from the provided snippets (headline frames Hegseth; summaries reference Pentagon\u2019s bid)."],"key_facts":["A judge rejected Hegseth\u2019s second attempt to restrict reporters at the Pentagon (per NYT headline).","The ruling ordered the Pentagon to restore press access (per NYT summary and other outlet summaries).","The ruling characterized the Pentagon\u2019s latest bid as violating a court order to restore press access (per Washington Post/CNN summary text)."],"numeric_claims":[],"primary_claim":"The judge blocked the Pentagon\u2019s (and/or Hegseth\u2019s) second attempt to limit press access and ordered Pentagon to restore reporter access.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"A judge rejected Pete Hegseth\u2019s second effort to restrict reporters\u2019 access at the Pentagon, ordering the Pentagon to restore press access. Multiple outlets report the ruling found the Pentagon violated a prior court order.","topics":["press access","Pentagon","court ruling","reporter restrictions","Hegseth","media rights"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"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 says Pentagon must restore press access CBS News Judge orders Pentagon to restore press access The Hill","title":"Judge Rejects Hegseth\u2019s Second Attempt to Restrict Reporters at Pentagon - The New York Times","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_2689eb9b319b in signals