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/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

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_459f2b80829e in signals