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/CBMi-wFBVV95cUxNZFFCRlBwWHNqMUpxQWFwUTVHS3Jld3BVY2ExUFNJRDNUWUx2X3FpM1dtX3dfQ1hzaEhVejlGcDZSa2hVRjZuZnNOTXFudEM4dUFlRHJWWE1PV2lfTFpoMlVCVl91ZWdEZHZPY2E4V3h3dEh6UzhoQ1JRd01DM3BsYjZLbTVDWmM5YmU0eFB0LWNINTVlenFMS0wxZ1RnZFF3U25XdlZqeGlhbzlmN3Y1c3hoYzctcHVGV05zN2hCLUJZcFBFazJzLWNkemt5d0dzdE50amU3M3NobllWTjVlTkd3UXpBbENOM3lPajMwN0xocGxPcDlEMXp0QQ?oc=5","as_of":"2026-04-06T17:07:35.452625+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/CBMi-wFBVV95cUxNZFFCRlBwWHNqMUpxQWFwUTVHS3Jld3BVY2ExUFNJRDNUWUx2X3FpM1dtX3dfQ1hzaEhVejlGcDZSa2hVRjZuZnNOTXFudEM4dUFlRHJWWE1PV2lfTFpoMlVCVl91ZWdEZHZPY2E4V3h3dEh6UzhoQ1JRd01DM3BsYjZLbTVDWmM5YmU0eFB0LWNINTVlenFMS0wxZ1RnZFF3U25XdlZqeGlhbzlmN3Y1c3hoYzctcHVGV05zN2hCLUJZcFBFazJzLWNkemt5d0dzdE50amU3M3NobllWTjVlTkd3UXpBbENOM3lPajMwN0xocGxPcDlEMXp0QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_71b8a069313471ae","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-06T17:12:05.555991+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi-wFBVV95cUxNZFFCRlBwWHNqMUpxQWFwUTVHS3Jld3BVY2ExUFNJRDNUWUx2X3FpM1dtX3dfQ1hzaEhVejlGcDZSa2hVRjZuZnNOTXFudEM4dUFlRHJWWE1PV2lfTFpoMlVCVl91ZWdEZHZPY2E4V3h3dEh6UzhoQ1JRd01DM3BsYjZLbTVDWmM5YmU0eFB0LWNINTVlenFMS0wxZ1RnZFF3U25XdlZqeGlhbzlmN3Y1c3hoYzctcHVGV05zN2hCLUJZcFBFazJzLWNkemt5d0dzdE50amU3M3NobllWTjVlTkd3UXpBbENOM3lPajMwN0xocGxPcDlEMXp0QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi-wFBVV95cUxNZFFCRlBwWHNqMUpxQWFwUTVHS3Jld3BVY2ExUFNJRDNUWUx2X3FpM1dtX3dfQ1hzaEhVejlGcDZSa2hVRjZuZnNOTXFudEM4dUFlRHJWWE1PV2lfTFpoMlVCVl91ZWdEZHZPY2E4V3h3dEh6UzhoQ1JRd01DM3BsYjZLbTVDWmM5YmU0eFB0LWNINTVlenFMS0wxZ1RnZFF3U25XdlZqeGlhbzlmN3Y1c3hoYzctcHVGV05zN2hCLUJZcFBFazJzLWNkemt5d0dzdE50amU3M3NobllWTjVlTkd3UXpBbENOM3lPajMwN0xocGxPcDlEMXp0QQ?oc=5","source_event_id":"evt_a5bbbc714924","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7259b29e8f1cb7ae","published_at":"2026-04-06T14:42:49+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical","name":"Israel","relevance":"directly involved","symbol":"ISR","type":"country"},{"asset_class":"geopolitical","name":"Iran","relevance":"directly affected","symbol":"IR","type":"country"},{"asset_class":"energy","name":"South Pars natural gas complex","relevance":"targeted site","symbol":"","type":"facility"}],"event_type":"conflict","information_gaps":["Details on the extent of damage caused by the strike are unclear.","The timeline for potential Iranian retaliation is not specified."],"key_facts":["The strike targeted the South Pars natural gas complex, vital for Iran's energy supply.","Iran has warned of 'devastating' retaliation following the strike."],"numeric_claims":[],"primary_claim":"Israel struck Iran's largest petrochemical facility, impacting Iran's energy lifeline.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"Israel has conducted a strike on Iran's largest petrochemical facility, which is crucial for its energy supply, leading to warnings of severe retaliation from Iran.","topics":["Middle East conflict","geopolitical tensions","energy security"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Israel Strikes Iran\u2019s Largest Petrochemical Facility, Defense Minister Says WSJ The South Pars natural gas complex is an energy lifeline for Iran AP News Israel says it hit Iranian petrochemical site being used to make missiles The Times of Israel Middle East war live: Israeli strikes shut down key Iranian petrochemical plants Financial Times Middle East crisis live: Iran warns of \u2018devastating\u2019 retaliation after Trump\u2019s expletive-laden threats over strait of Hormuz The Guardian","title":"Israel Strikes Iran\u2019s Largest Petrochemical Facility, Defense Minister Says - WSJ","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_9c1cde969f66 in signals