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

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