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/CBMiwgFBVV95cUxQY0ZBX3RMdDlkZlNQcjJJVkJoTjhQSTA4Tnl2WTM2WXdBWGhsMkl4WGZmNzFvTklZT0Y2UVEzSGZPVXNnOXBnNVhTU2VtYmNEQXJjZUstVTlteWZIWG5VSF93NkdEY1V2T2E5RzNtOTlvWFFmUU1MekRyREU1Vk5vZ2tlanJveVRZTjlqclc2aV9iS05NaHBuYW1LMTZZNW9Xd2dGNlpubW9rNW5wSUxMTWswQUM0V3NZM1hSYnZIVzFiUQ?oc=5","as_of":"2026-04-10T18:06:52.309947+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/CBMiwgFBVV95cUxQY0ZBX3RMdDlkZlNQcjJJVkJoTjhQSTA4Tnl2WTM2WXdBWGhsMkl4WGZmNzFvTklZT0Y2UVEzSGZPVXNnOXBnNVhTU2VtYmNEQXJjZUstVTlteWZIWG5VSF93NkdEY1V2T2E5RzNtOTlvWFFmUU1MekRyREU1Vk5vZ2tlanJveVRZTjlqclc2aV9iS05NaHBuYW1LMTZZNW9Xd2dGNlpubW9rNW5wSUxMTWswQUM0V3NZM1hSYnZIVzFiUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_da1966d5ada7af71","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-10T18:46:45.941975+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxQY0ZBX3RMdDlkZlNQcjJJVkJoTjhQSTA4Tnl2WTM2WXdBWGhsMkl4WGZmNzFvTklZT0Y2UVEzSGZPVXNnOXBnNVhTU2VtYmNEQXJjZUstVTlteWZIWG5VSF93NkdEY1V2T2E5RzNtOTlvWFFmUU1MekRyREU1Vk5vZ2tlanJveVRZTjlqclc2aV9iS05NaHBuYW1LMTZZNW9Xd2dGNlpubW9rNW5wSUxMTWswQUM0V3NZM1hSYnZIVzFiUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"middleeasteye.net","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxQY0ZBX3RMdDlkZlNQcjJJVkJoTjhQSTA4Tnl2WTM2WXdBWGhsMkl4WGZmNzFvTklZT0Y2UVEzSGZPVXNnOXBnNVhTU2VtYmNEQXJjZUstVTlteWZIWG5VSF93NkdEY1V2T2E5RzNtOTlvWFFmUU1MekRyREU1Vk5vZ2tlanJveVRZTjlqclc2aV9iS05NaHBuYW1LMTZZNW9Xd2dGNlpubW9rNW5wSUxMTWswQUM0V3NZM1hSYnZIVzFiUQ?oc=5","source_event_id":"evt_394cca2d7ee5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c9dc91dde45693d8","published_at":"2026-04-10T12:35:00+00:00","publisher_domain":"middleeasteye.net","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Khawaja Asif","relevance":"primary actor; made and then deleted the post","symbol":"","type":"person"},{"asset_class":"country","name":"Israel","relevance":"target of the remarks","symbol":"","type":"country"},{"asset_class":"","name":"Benjamin Netanyahu","relevance":"issued a warning referenced as the trigger for deletion","symbol":"","type":"person"},{"asset_class":"country","name":"Pakistan","relevance":"country whose defence minister made the remarks","symbol":"","type":"country"},{"asset_class":"","name":"Middle East Eye","relevance":"reported the deleted-post incident","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual article content; extraction is therefore based on the provided headline delta and source summary rather than verbatim article text.","Exact timestamp/date of the X post and deletion are not provided in the signal.","The specific content of Netanyahu\u2019s warning (exact wording and medium) is not included in the provided text.","Whether Pakistan\u2019s government issued any formal clarification or response beyond the deletion is not provided."],"key_facts":["Middle East Eye reports that Pakistan\u2019s defence minister Khawaja Asif made remarks about Israel on X and later deleted the post.","The reported wording includes calling Israel a \u201ccurse for humanity\u201d (and related negative characterizations).","The post deletion is described as occurring after Netanyahu issued a warning (timing trigger referenced in the signal)."],"numeric_claims":[],"primary_claim":"Khawaja Asif called Israel a \u201ccurse for humanity\u201d (and related derogatory terms) in a post that was later deleted after Netanyahu\u2019s warning.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Pakistan\u2019s defence minister Khawaja Asif posted highly inflammatory remarks about Israel on X, then deleted the post after Israeli Prime Minister Benjamin Netanyahu issued a warning, according to Middle East Eye. The incident escalates Pakistan\u2013Israel rhetoric in the near term.","topics":["Pakistan-Israel war of words","social media post deleted","diplomatic rhetoric escalation","Middle East geopolitical risk"]},"source":"Middle East Eye","source_domain":"middleeasteye.net","source_url":"https://www.middleeasteye.net","summary":"Pakistan's defence minister calls Israel 'curse for humanity' in deleted post Middle East Eye Pak's Khawaja Asif Calls Israel \"Evil\", Deletes Post After Netanyahu's Warning NDTV Israel News: Pakistan, Israel war of words: Khawaja Asif\u2019s 'burn in hell' remark triggers an 'outrageous' response The Times of India Pakistani defense minister deletes X post calling \u2018cancerous\u2019 Israel \u2018a curse for humanity\u2019 The Times of Israel Live Updates: Latest from Israel, Iran, and the Middle East The Jerusalem Post","title":"Pakistan's defence minister calls Israel 'curse for humanity' in deleted post - Middle East Eye","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_9d4a73995f1a in signals