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/CBMipwFBVV95cUxOLWVVeTg0ajVqd2Q1enAwTU14d2pFZTVTRnZ6NHluelcwZmxLb3pqeFk5MnI0dEVNTXdvallMNHdMaE9fQXRmTFFtVURwUFBUbGZrTDRSVFBZM2hGeVdxbXIzY1FDNzlJZ1EyUDZDcmo2Z0ZQbXhucTdHVEMtMFdmc05JaEt1SjNTRnVzUnJlS2tfc1hBU0RQWTRabi1uYWNaTXJXZlktWQ?oc=5","as_of":"2026-04-07T23:23:37.701716+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/CBMipwFBVV95cUxOLWVVeTg0ajVqd2Q1enAwTU14d2pFZTVTRnZ6NHluelcwZmxLb3pqeFk5MnI0dEVNTXdvallMNHdMaE9fQXRmTFFtVURwUFBUbGZrTDRSVFBZM2hGeVdxbXIzY1FDNzlJZ1EyUDZDcmo2Z0ZQbXhucTdHVEMtMFdmc05JaEt1SjNTRnVzUnJlS2tfc1hBU0RQWTRabi1uYWNaTXJXZlktWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_032b165e35f7c1c2","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:32:15.828165+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxOLWVVeTg0ajVqd2Q1enAwTU14d2pFZTVTRnZ6NHluelcwZmxLb3pqeFk5MnI0dEVNTXdvallMNHdMaE9fQXRmTFFtVURwUFBUbGZrTDRSVFBZM2hGeVdxbXIzY1FDNzlJZ1EyUDZDcmo2Z0ZQbXhucTdHVEMtMFdmc05JaEt1SjNTRnVzUnJlS2tfc1hBU0RQWTRabi1uYWNaTXJXZlktWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxOLWVVeTg0ajVqd2Q1enAwTU14d2pFZTVTRnZ6NHluelcwZmxLb3pqeFk5MnI0dEVNTXdvallMNHdMaE9fQXRmTFFtVURwUFBUbGZrTDRSVFBZM2hGeVdxbXIzY1FDNzlJZ1EyUDZDcmo2Z0ZQbXhucTdHVEMtMFdmc05JaEt1SjNTRnVzUnJlS2tfc1hBU0RQWTRabi1uYWNaTXJXZlktWQ?oc=5","source_event_id":"evt_041222f48488","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c88ac45f7913fc1d","published_at":"2026-04-07T21:45:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Iranian public","relevance":"high","symbol":"","type":"population"},{"asset_class":"","name":"United States (Trump)","relevance":"high","symbol":"","type":"government"},{"asset_class":"","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The specific nature of \u201cTrump\u2019s deadline\u201d (date and what it refers to) is not provided in the provided text.","No concrete details are given here on who would carry out the \u201cfurther attacks\u201d or what targets are expected.","The article text content was not actually available beyond page styling; only the headline and provided source summary were usable for extraction.","No evidence is provided in the provided text about whether power outages are already occurring versus being feared as a risk."],"key_facts":["AP News headline states Iranians fear power outages as Trump\u2019s deadline nears.","AP News headline states Iranians fear further attacks as Trump\u2019s deadline nears.","The headline frames the approaching Trump deadline as the timing catalyst for these fears."],"numeric_claims":[],"primary_claim":"Iranians fear power outages and further attacks as Trump\u2019s deadline nears.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"AP News reports that Iranians are bracing for potential power outages and additional attacks as a Trump-related deadline approaches. The near-term catalyst implied by the headline is the looming deadline itself, which is driving heightened public fear and readiness.","topics":["Iran","United States","Trump deadline","power outages","security fears","attacks","civilian impact"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Iranians fear power outages and further attacks as Trump\u2019s deadline nears AP News Iranians Voice Shock and Defiance in Face of Trump\u2019s Looming Deadline The New York Times Iran Cuts Off Direct Diplomacy With U.S. WSJ Iranians brace for possible devastation as Trump\u2019s deadline looms Al Jazeera Iran Signals Long Multi-Front War as Trump Deadline Nears Yahoo Finance","title":"Iranians fear power outages and further attacks as Trump\u2019s deadline nears - AP News","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_1bed9b5c5f34 in signals