SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:37.701716+00:00","dedupe_key":"signal_enriched:news_delta:eb2987303e6b19c4","evidence_event_ids":["evt_041222f48488"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 2203 in events