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-08T00:41:56.609496+00:00","dedupe_key":"signal_enriched:news_delta:6ec124e11c1f4254","evidence_event_ids":["evt_ebb08e71342c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONE9zZV9CRDR1SUpYb3VUTEFzdGdMN1hNOHRjQXpLdERjNGM5eGFacWpUN1Y3Mzl0SjRjOFFZWUdLdEw0dktoaTBMTEliNk5LZmVSdkpuT0xuQ3FwN2NLQzBrak5pSTA5QUtKbXBnUmlfekozM3BqWDA1M0c1VDREN3ZDY0NoVHUwTXBJd3FSc00xNDlGR19GSEVPOUk1UlRlZnNEb0hQUE5KMUxI?oc=5","as_of":"2026-04-08T00:41:56.609496+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONE9zZV9CRDR1SUpYb3VUTEFzdGdMN1hNOHRjQXpLdERjNGM5eGFacWpUN1Y3Mzl0SjRjOFFZWUdLdEw0dktoaTBMTEliNk5LZmVSdkpuT0xuQ3FwN2NLQzBrak5pSTA5QUtKbXBnUmlfekozM3BqWDA1M0c1VDREN3ZDY0NoVHUwTXBJd3FSc00xNDlGR19GSEVPOUk1UlRlZnNEb0hQUE5KMUxI?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_94dcdb0e03d0cca9","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:44:00.132949+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONE9zZV9CRDR1SUpYb3VUTEFzdGdMN1hNOHRjQXpLdERjNGM5eGFacWpUN1Y3Mzl0SjRjOFFZWUdLdEw0dktoaTBMTEliNk5LZmVSdkpuT0xuQ3FwN2NLQzBrak5pSTA5QUtKbXBnUmlfekozM3BqWDA1M0c1VDREN3ZDY0NoVHUwTXBJd3FSc00xNDlGR19GSEVPOUk1UlRlZnNEb0hQUE5KMUxI?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fortune.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONE9zZV9CRDR1SUpYb3VUTEFzdGdMN1hNOHRjQXpLdERjNGM5eGFacWpUN1Y3Mzl0SjRjOFFZWUdLdEw0dktoaTBMTEliNk5LZmVSdkpuT0xuQ3FwN2NLQzBrak5pSTA5QUtKbXBnUmlfekozM3BqWDA1M0c1VDREN3ZDY0NoVHUwTXBJd3FSc00xNDlGR19GSEVPOUk1UlRlZnNEb0hQUE5KMUxI?oc=5","source_event_id":"evt_ebb08e71342c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0b6ea1fabe204b66","published_at":"2026-04-07T16:02:00+00:00","publisher_domain":"fortune.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Iranian people (civilians/young people called to participate)","relevance":"direct participants","symbol":"","type":"group"},{"asset_class":"","name":"Iranian officials","relevance":"urging participation","symbol":"","type":"group"},{"asset_class":"","name":"Trump (U.S. President)","relevance":"deadline reference/catalyst","symbol":"","type":"person"},{"asset_class":"infrastructure","name":"Power plants (Iran)","relevance":"location of human chains","symbol":"","type":"infrastructure"},{"asset_class":"infrastructure","name":"Bridges (Iran)","relevance":"additional location mentioned","symbol":"","type":"infrastructure"}],"event_type":"geopolitical_risk","information_gaps":["The exact date/time of \u201cTrump\u2019s deadline\u201d is not specified in the provided text.","The specific power plants/regions in Iran are not identified.","The scale (number of participants) and duration of the human-chain actions are not provided.","Whether the actions are directly tied to a particular policy action (e.g., sanctions/strike threat) is not detailed in the excerpt.","No direct quotes or verification details beyond \u201csocial media videos\u201d are included in the provided text."],"key_facts":["Fortune.com reports Iranians have begun forming human chains around power plants ahead of a Trump deadline, based on social media videos.","BBC Iran calls on young people to form human chains around power plants as the Trump deadline looms.","The Guardian reports an Iranian official called for human chains around bridges and power plants.","WSJ frames the effort as an Iranian regime attempt to create a human shield ahead of the Trump deadline.","NewsNation also reports refugee fears and links them to the regime\u2019s human-shield strategy ahead of the Trump deadline."],"numeric_claims":[],"primary_claim":"Iranians have started forming human chains around power plants ahead of a Trump-related deadline, as shown in social media videos.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Multiple outlets report that Iranians have begun forming human chains around power plants (and also bridges) as a U.S. deadline associated with Trump approaches, with social media videos cited. The stated purpose is to mobilize people to protect critical infrastructure ahead of that deadline.","topics":["Iran","protests/mobilization","critical infrastructure","U.S.-Iran tensions","social media videos","deadline/catalyst"]},"source":"fortune.com","source_domain":"fortune.com","source_url":"https://fortune.com","summary":"Iranians begin forming human chains around power plants ahead of Trump\u2019s deadline, social media videos show fortune.com Iranians form human chains at bridges and power plants BBC Iran calls on young people to form human chains around power plants as Trump deadline looms The Guardian Iranian Official Calls for Human Chain Around Bridges, Power Plants WSJ Iranian refugee fears regime wants to create a human shield ahead of Trump\u2019s deadline NewsNation","title":"Iranians begin forming human chains around power plants ahead of Trump\u2019s deadline, social media videos show - fortune.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 2508 in events