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/CBMitwFBVV95cUxPLXZYbzBOaEdkNFVVVDl5OEdXREVjQnEzMks5QTZqcnNmb013c3RNQ1hBVHIyZmhzRjRhd2dGTkZxSjgweWduLW9Rc21JTWxiWnJxajhBaklzV3VqOFpoSWpBVjhPQ0VhTWdHRXlYODBjdE56NE0xenpQM3BIUU0xdEVhYThzLW15RWpsRmFXUnloY09rOHUza3BsUEdmQTdRNVd6cHFLekQ5ZlZqLW9RNEgtWkNmVFXSAbwBQVVfeXFMUDlzZnV0cTBIU0lJVXdLOWFrSWZFWHk0SXNjTTlWdTZ0OWI1VEo3dnpMNDZRcjYxNHpKSFhkYVZfVElJejJSdzdpTHVvanhNeDBtR29SN1FQbVppLXBUU0FPd2ZaWjB0TVNYZlgxRFl4eEFnT1gxSEdlR0hYSV9tc3UzaElRenZDOUNrQ2E4U3dIV0pibHB6VW00X3lybjhMODU5YjIzQlB2NUJMY3J2dEEzVmJ3NWVuVmd2VUQ?oc=5","as_of":"2026-04-10T13:08:04.633736+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/CBMitwFBVV95cUxPLXZYbzBOaEdkNFVVVDl5OEdXREVjQnEzMks5QTZqcnNmb013c3RNQ1hBVHIyZmhzRjRhd2dGTkZxSjgweWduLW9Rc21JTWxiWnJxajhBaklzV3VqOFpoSWpBVjhPQ0VhTWdHRXlYODBjdE56NE0xenpQM3BIUU0xdEVhYThzLW15RWpsRmFXUnloY09rOHUza3BsUEdmQTdRNVd6cHFLekQ5ZlZqLW9RNEgtWkNmVFXSAbwBQVVfeXFMUDlzZnV0cTBIU0lJVXdLOWFrSWZFWHk0SXNjTTlWdTZ0OWI1VEo3dnpMNDZRcjYxNHpKSFhkYVZfVElJejJSdzdpTHVvanhNeDBtR29SN1FQbVppLXBUU0FPd2ZaWjB0TVNYZlgxRFl4eEFnT1gxSEdlR0hYSV9tc3UzaElRenZDOUNrQ2E4U3dIV0pibHB6VW00X3lybjhMODU5YjIzQlB2NUJMY3J2dEEzVmJ3NWVuVmd2VUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_87344de55e63d71c","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-10T13:08:52.666114+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxPLXZYbzBOaEdkNFVVVDl5OEdXREVjQnEzMks5QTZqcnNmb013c3RNQ1hBVHIyZmhzRjRhd2dGTkZxSjgweWduLW9Rc21JTWxiWnJxajhBaklzV3VqOFpoSWpBVjhPQ0VhTWdHRXlYODBjdE56NE0xenpQM3BIUU0xdEVhYThzLW15RWpsRmFXUnloY09rOHUza3BsUEdmQTdRNVd6cHFLekQ5ZlZqLW9RNEgtWkNmVFXSAbwBQVVfeXFMUDlzZnV0cTBIU0lJVXdLOWFrSWZFWHk0SXNjTTlWdTZ0OWI1VEo3dnpMNDZRcjYxNHpKSFhkYVZfVElJejJSdzdpTHVvanhNeDBtR29SN1FQbVppLXBUU0FPd2ZaWjB0TVNYZlgxRFl4eEFnT1gxSEdlR0hYSV9tc3UzaElRenZDOUNrQ2E4U3dIV0pibHB6VW00X3lybjhMODU5YjIzQlB2NUJMY3J2dEEzVmJ3NWVuVmd2VUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"timesofisrael.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxPLXZYbzBOaEdkNFVVVDl5OEdXREVjQnEzMks5QTZqcnNmb013c3RNQ1hBVHIyZmhzRjRhd2dGTkZxSjgweWduLW9Rc21JTWxiWnJxajhBaklzV3VqOFpoSWpBVjhPQ0VhTWdHRXlYODBjdE56NE0xenpQM3BIUU0xdEVhYThzLW15RWpsRmFXUnloY09rOHUza3BsUEdmQTdRNVd6cHFLekQ5ZlZqLW9RNEgtWkNmVFXSAbwBQVVfeXFMUDlzZnV0cTBIU0lJVXdLOWFrSWZFWHk0SXNjTTlWdTZ0OWI1VEo3dnpMNDZRcjYxNHpKSFhkYVZfVElJejJSdzdpTHVvanhNeDBtR29SN1FQbVppLXBUU0FPd2ZaWjB0TVNYZlgxRFl4eEFnT1gxSEdlR0hYSV9tc3UzaElRenZDOUNrQ2E4U3dIV0pibHB6VW00X3lybjhMODU5YjIzQlB2NUJMY3J2dEEzVmJ3NWVuVmd2VUQ?oc=5","source_event_id":"evt_b2a07b4f8fcb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"28d7ba1981cf02f5","published_at":"2026-04-10T06:57:21+00:00","publisher_domain":"timesofisrael.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Khawaja Asif","relevance":"primary source of the remark","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Pakistan","relevance":"government actor; defense ministry spokesperson/minister","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"target of the remark; issued a response","symbol":"","type":"country"},{"asset_class":"","name":"US-Iran talks in Islamabad","relevance":"near-term catalyst timing referenced in the headline","symbol":"","type":"event"},{"asset_class":"sovereign","name":"United States","relevance":"participant in the referenced talks","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"participant in the referenced talks","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the substantive content needed to verify exact quotes beyond the headline/source summary.","The exact date/time of the US-Iran talks in Islamabad is not present in the provided text.","The specific wording of Israel\u2019s response (beyond the snippet references) is not fully verifiable from the provided content.","Whether Pakistan issued an official clarification beyond deleting the post is not confirmed in the provided material."],"key_facts":["The Times of Israel headline reports Pakistan\u2019s defense minister Khawaja Asif called Israel \u201ccancerous.\u201d","The remark is described as occurring ahead of US-Iran talks in Islamabad.","Multiple source snippets indicate Israel criticized/responded to the remark (e.g., \u201cblood libels\u201d framing is mentioned in the provided source summary).","The provided source summary states that Khawaja Asif deleted an X post containing the remark (as reported by The Times of Israel)."],"numeric_claims":[],"primary_claim":"Khawaja Asif called Israel \u201ccancerous\u201d ahead of US-Iran talks in Islamabad, and the remark triggered an Israel backlash and subsequent deletion/cleanup of the post by Pakistan.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Pakistan\u2019s defense minister, Khawaja Asif, used highly inflammatory language toward Israel (\u201ccancerous\u201d) ahead of US-Iran talks in Islamabad, prompting Israel to respond and Pakistan to delete/adjust the remark on social media. The episode escalates Israel\u2013Pakistan diplomatic rhetoric in the immediate lead-up to the scheduled talks.","topics":["Israel\u2013Pakistan diplomatic tensions","US\u2013Iran negotiations","political rhetoric/escalation","Islamabad talks","social media remark deletion"]},"source":"The Times of Israel","source_domain":"timesofisrael.com","source_url":"https://www.timesofisrael.com","summary":"Pakistan\u2019s defense minister calls Israel \u2018cancerous\u2019 ahead of US-Iran talks in Islamabad The Times of Israel \"Blood Libels\": Israel Slams Pak Over Khawaja Asif's 'Cancerous' Remark 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\u2019s defense minister calls Israel \u2018cancerous\u2019 ahead of US-Iran talks in Islamabad - The Times of Israel","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_1cda893c5825 in signals