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/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","as_of":"2026-04-08T00:41:56.447664+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/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_43968f37a723aeb7","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-08T00:43:43.790811+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?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/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","source_event_id":"evt_0120a7f52032","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0f634a9816d96980","published_at":"2026-04-07T23:34:28+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Pete Hegseth","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"The Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"U.S. officials (unnamed)","relevance":"medium","symbol":"","type":"group"}],"event_type":"geopolitical_risk","information_gaps":["What specific statements Hegseth made about the Iran war are disputed.","Which officials made the statements and what evidence they cited.","When the events/claims occurred (timeline) and whether they relate to a particular operation or period.","Whether the dispute has any policy or operational consequences near-term."],"key_facts":["The Washington Post headline states that officials say Hegseth\u2019s boastful claims about the Iran war contradict reality.","The provided text includes only the headline and a partial source summary; no specific claim details, dates, or evidence are included in the supplied content."],"numeric_claims":[],"primary_claim":"Officials told The Washington Post that Pete Hegseth\u2019s boastful claims about the Iran war contradict reality.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that officials say Pete Hegseth\u2019s public claims about U.S. actions in the Iran war are exaggerated or inconsistent with reality. The signal does not provide specific details of the disputed claims or the officials\u2019 evidence.","topics":["U.S. defense/politics","Iran war claims","official rebuttal","credibility/dispute"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Hegseth\u2019s boastful claims about Iran war contradict reality, officials say The Washington Post Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ The New York Times The HH-60W helped rescue a pilot in Iran. Here\u2019s why the Air Force might not buy more. breakingdefense.com DR MARC SIEGEL: Bleeding, alone and hunted -- a downed colonel\u2019s miracle survival Fox News The U.S. fighter jet was downed in Iran by a shoulder-fired missile NBC News","title":"Hegseth\u2019s boastful claims about Iran war contradict reality, officials say - 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_e741f648deff in signals