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/CBMiWkFVX3lxTFBhOERsd2pOZ0F6S3RXOFpBQktvLWNDbnRfeXBfYTJMd2RQUDhUb2pvX1lNQnluak85RmZJZDdqSXZGd19USjR6ZlJ5VElxS2JseEpRbms3UUtwUQ?oc=5","as_of":"2026-04-08T03:15:56.426724+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/CBMiWkFVX3lxTFBhOERsd2pOZ0F6S3RXOFpBQktvLWNDbnRfeXBfYTJMd2RQUDhUb2pvX1lNQnluak85RmZJZDdqSXZGd19USjR6ZlJ5VElxS2JseEpRbms3UUtwUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_aaf76b748d532c24","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-08T03:52:43.491013+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBhOERsd2pOZ0F6S3RXOFpBQktvLWNDbnRfeXBfYTJMd2RQUDhUb2pvX1lNQnluak85RmZJZDdqSXZGd19USjR6ZlJ5VElxS2JseEpRbms3UUtwUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBhOERsd2pOZ0F6S3RXOFpBQktvLWNDbnRfeXBfYTJMd2RQUDhUb2pvX1lNQnluak85RmZJZDdqSXZGd19USjR6ZlJ5VElxS2JseEpRbms3UUtwUQ?oc=5","source_event_id":"evt_120cb7a8b90c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fb7f4872f836db3","published_at":"2026-04-08T01:44:26+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["about a week after kidnapping (relative timing; exact date not provided in the provided text)"],"entities":[{"asset_class":"other","name":"Shelly Kittleson","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Pro-Iran militia in Iraq","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Marco Rubio","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"CNN","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"BBC","relevance":"medium","symbol":"","type":"organization"}],"event_type":"conflict","information_gaps":["Exact date/time of the kidnapping and release are not provided in the supplied text.","The specific name of the militia is not included in the provided excerpt.","No details are provided on the conditions of release or whether any negotiations/payments occurred.","The provided text does not specify where in Iraq she was held or released from."],"key_facts":["BBC reports that a pro-Iran militia in Iraq says it has decided to release American journalist Shelly Kittleson.","The release is reported as happening about a week after her kidnapping in Iraq.","The signal text also cites Rubio as saying Kittleson has been released."],"numeric_claims":[],"primary_claim":"Pro-Iran militia in Iraq says it has decided to release American journalist Shelly Kittleson after she was kidnapped.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"A pro-Iran militia in Iraq says it has decided to release American journalist Shelly Kittleson after her kidnapping. The release is reported as occurring about a week after the kidnapping, with Rubio also cited as confirming her release.","topics":["kidnapping","journalism","Iraq","pro-Iran militias","hostage release","US-Iraq relations"]},"source":"bbc.com","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"US journalist Shelly Kittleson to be released after kidnap in Iraq, militia says bbc.com Pro-Iran militia in Iraq says they have decided to release American journalist CNN American journalist Shelly Kittleson has been released week after kidnapping in Iraq, Rubio says ABC15 Arizona Reporter who was kidnapped in Baghdad is known for pursuing gutsy, low-budget assignments AP News Shelly Kittleson, American Journalist Abducted in Iraq, Is Freed The New York Times","title":"US journalist Shelly Kittleson to be released after kidnap in Iraq, militia says - bbc.com","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_d83e3eae7483 in signals