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/CBMioAFBVV95cUxOTXN2RGtIem1mNmFuYmE5cnlZZ3g3MGpRX1IzMFgwTEY1UTZCUzZ1eUw2d3hHUWVPNXRvcUdTRFRJSEE2aHRqeUlTbmF0cmZTeWJYcmRCcGRGTFJEb0FBaGNTZGlRYzB4VkNscmdhUW5RTWE3clpja2JFSnd2ZmdsbFpoYkpsZ0s0ODJNNGYwTjh3WjRDTXJ2TmlmZUhIOEdv?oc=5","as_of":"2026-04-07T23:39:52.388923+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/CBMioAFBVV95cUxOTXN2RGtIem1mNmFuYmE5cnlZZ3g3MGpRX1IzMFgwTEY1UTZCUzZ1eUw2d3hHUWVPNXRvcUdTRFRJSEE2aHRqeUlTbmF0cmZTeWJYcmRCcGRGTFJEb0FBaGNTZGlRYzB4VkNscmdhUW5RTWE3clpja2JFSnd2ZmdsbFpoYkpsZ0s0ODJNNGYwTjh3WjRDTXJ2TmlmZUhIOEdv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_58486fe8ba12772f","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:39:21.556643+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOTXN2RGtIem1mNmFuYmE5cnlZZ3g3MGpRX1IzMFgwTEY1UTZCUzZ1eUw2d3hHUWVPNXRvcUdTRFRJSEE2aHRqeUlTbmF0cmZTeWJYcmRCcGRGTFJEb0FBaGNTZGlRYzB4VkNscmdhUW5RTWE3clpja2JFSnd2ZmdsbFpoYkpsZ0s0ODJNNGYwTjh3WjRDTXJ2TmlmZUhIOEdv?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOTXN2RGtIem1mNmFuYmE5cnlZZ3g3MGpRX1IzMFgwTEY1UTZCUzZ1eUw2d3hHUWVPNXRvcUdTRFRJSEE2aHRqeUlTbmF0cmZTeWJYcmRCcGRGTFJEb0FBaGNTZGlRYzB4VkNscmdhUW5RTWE3clpja2JFSnd2ZmdsbFpoYkpsZ0s0ODJNNGYwTjh3WjRDTXJ2TmlmZUhIOEdv?oc=5","source_event_id":"evt_3ae1c68e2678","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a71eeb48aab3d0dd","published_at":"2026-04-07T16:20:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Israeli Consulate (Istanbul)","relevance":"direct target of attack","symbol":"","type":"diplomatic_mission"},{"asset_class":"other","name":"Istanbul","relevance":"location of incident","symbol":"","type":"city"},{"asset_class":"other","name":"Turkey","relevance":"jurisdiction/location context","symbol":"","type":"country"},{"asset_class":"other","name":"Gunmen/attackers","relevance":"perpetrators involved in shooting","symbol":"","type":"non_state_actors"},{"asset_class":"other","name":"AP News","relevance":"source of headline","symbol":"","type":"news_outlet"},{"asset_class":"other","name":"BBC","relevance":"additional cited reporting","symbol":"","type":"news_outlet"},{"asset_class":"other","name":"Al Jazeera","relevance":"additional cited reporting","symbol":"","type":"news_outlet"},{"asset_class":"other","name":"Reuters","relevance":"additional cited reporting","symbol":"","type":"news_outlet"},{"asset_class":"other","name":"The New York Times","relevance":"additional cited reporting","symbol":"","type":"news_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is not actually present (only page styling/HTML), so details beyond the headline-level summary cannot be verified from the supplied content.","No information is provided here on whether any consulate staff or civilians were injured or killed.","No timing (exact date/time) of the incident is included in the provided text.","No details are provided on claimed responsibility, motive, or whether the attack is linked to a specific group.","No information is provided on immediate diplomatic/official responses (e.g., travel advisories, retaliatory statements)."],"key_facts":["Gunmen attacked a building housing the Israeli Consulate in Istanbul.","A shootout occurred outside/at the Israeli consulate area in Istanbul (as described across cited headlines).","One gunman was killed.","Two other attackers were reportedly neutralized by officials/governor (wording varies by outlet)."],"numeric_claims":[{"label":"fatalities (attackers)","value":"1 killed"},{"label":"attackers neutralized","value":"2 neutralized"}],"primary_claim":"A terror attack/shooting occurred at a building housing the Israeli Consulate in Istanbul, resulting in one gunman dead and two others neutralized.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Gunmen attacked a building housing the Israeli Consulate in Istanbul, triggering a shootout. One attacker was killed and two others were reportedly neutralized, according to officials cited by multiple outlets.","topics":["Middle East","Israel","Turkey","Istanbul","terror attack","diplomatic security","shootout","geopolitical risk"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Gunmen attack building housing Israeli Consulate in Istanbul AP News One gunman killed, two others 'neutralised' in shooting at Israeli consulate in Istanbul, governor says BBC Shooting near Israeli consulate in Turkiye declared \u2018terror\u2019 attack Al Jazeera Gunfight outside Israeli consulate in Istanbul leaves one attacker dead Reuters Gunman Killed in Shootout Near Israeli Consulate in Istanbul, Officials Say The New York Times","title":"Gunmen attack building housing Israeli Consulate in Istanbul - AP News","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_86015ab95246 in signals