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:38.935155+00:00","dedupe_key":"signal_enriched:news_delta:d71becfee6b6c80e","evidence_event_ids":["evt_4c79878eab58"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPMnBFRjdaZ3JTazNkeERYd2FhdUdmSjJQSEtHdXdBOGZaQkJWY3hqUFdkZE80bk5Mclg4ZlJRUTQyYlNINjF5RklpRUh0MnJDS0JhQVAzb3ZsX1ZUUmhIMnJIMngwVm1kTk1FdVBqb0ZKVlJqQzhxNVBYUjhhbWNwSlVrRFFSRUc2aTVrV0ZsUUVrVnBSMUQ5RHZ1WUVWTUpEY0xKc2JpaktXSXpVdHJ5RVRRUnBERHpJ?oc=5","as_of":"2026-04-07T23:23:38.935155+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/CBMiuAFBVV95cUxPMnBFRjdaZ3JTazNkeERYd2FhdUdmSjJQSEtHdXdBOGZaQkJWY3hqUFdkZE80bk5Mclg4ZlJRUTQyYlNINjF5RklpRUh0MnJDS0JhQVAzb3ZsX1ZUUmhIMnJIMngwVm1kTk1FdVBqb0ZKVlJqQzhxNVBYUjhhbWNwSlVrRFFSRUc2aTVrV0ZsUUVrVnBSMUQ5RHZ1WUVWTUpEY0xKc2JpaktXSXpVdHJ5RVRRUnBERHpJ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_420190dc598e5255","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:35:36.723205+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPMnBFRjdaZ3JTazNkeERYd2FhdUdmSjJQSEtHdXdBOGZaQkJWY3hqUFdkZE80bk5Mclg4ZlJRUTQyYlNINjF5RklpRUh0MnJDS0JhQVAzb3ZsX1ZUUmhIMnJIMngwVm1kTk1FdVBqb0ZKVlJqQzhxNVBYUjhhbWNwSlVrRFFSRUc2aTVrV0ZsUUVrVnBSMUQ5RHZ1WUVWTUpEY0xKc2JpaktXSXpVdHJ5RVRRUnBERHpJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPMnBFRjdaZ3JTazNkeERYd2FhdUdmSjJQSEtHdXdBOGZaQkJWY3hqUFdkZE80bk5Mclg4ZlJRUTQyYlNINjF5RklpRUh0MnJDS0JhQVAzb3ZsX1ZUUmhIMnJIMngwVm1kTk1FdVBqb0ZKVlJqQzhxNVBYUjhhbWNwSlVrRFFSRUc2aTVrV0ZsUUVrVnBSMUQ5RHZ1WUVWTUpEY0xKc2JpaktXSXpVdHJ5RVRRUnBERHpJ?oc=5","source_event_id":"evt_4c79878eab58","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3809cf95138f85b8","published_at":"2026-04-07T17:51:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"population","name":"Young people (in Iran)","relevance":"high","symbol":"","type":"population_group"},{"asset_class":"infrastructure","name":"Power plants (in Iran)","relevance":"high","symbol":"","type":"infrastructure_target"},{"asset_class":"infrastructure","name":"Bridges (in Iran)","relevance":"medium","symbol":"","type":"infrastructure_target"},{"asset_class":"political","name":"Trump (U.S.)","relevance":"medium","symbol":"","type":"political_figure"}],"event_type":"geopolitical_risk","information_gaps":["The exact Trump-related deadline date/time is not stated in the provided content.","The specific Iranian official(s) or organization making the call is not identified in the provided text.","The stated purpose/effect (e.g., preventing sabotage, deterring attacks, or signaling support) is not detailed beyond the protective framing in the headline.","No confirmation is provided here of whether the human-chain actions have already occurred or are planned for a specific day/time."],"key_facts":["Iranian officials are calling for young people to form human chains around power plants.","The same call references human chains around bridges as well.","The timing is linked to a looming Trump-related deadline (exact date not provided in the provided text)."],"numeric_claims":[],"primary_claim":"Iran is calling on young people to form human chains around power plants (and bridges) as a Trump-related deadline nears.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Iranian officials are urging young people to form human chains around power plants and bridges as a U.S.-related deadline tied to Trump approaches. The move is framed as a protective measure for critical infrastructure ahead of the looming deadline.","topics":["Iran","protests/civil mobilization","critical infrastructure","power plants","U.S.-Iran negotiations/deadlines","geopolitical risk"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Iran calls on young people to form human chains around power plants as Trump deadline looms The Guardian Iranians form human chains at bridges and power plants BBC Iran Calls for Human Chains to Protect Power Plants as Trump's Deadline Nears Military.com Iran calls for human chains around power plants as Trump\u2019s deadline for deal nears MS NOW Iranian Official Calls for Human Chain Around Bridges, Power Plants WSJ","title":"Iran calls on young people to form human chains around power plants as Trump deadline looms - The Guardian","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 2289 in events