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/CBMiiwFBVV95cUxQdlVfTjZ4dGZTY1RWZmVITDlreWtnUmJCUEFFUE1aMjJYWlQtdlFSYktvSGktalljZzJPVEVVcjlndm9uNTFhZWRPQW5rQlRVdEFXWURtTVpXLS1CMjhDeE9wcTBvanRoai1ZZENfeUdtZUpNTmpLSElzQzV1ZTNXaC1aYU45d2VtckNv?oc=5","as_of":"2026-04-08T12:48:25.825957+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/CBMiiwFBVV95cUxQdlVfTjZ4dGZTY1RWZmVITDlreWtnUmJCUEFFUE1aMjJYWlQtdlFSYktvSGktalljZzJPVEVVcjlndm9uNTFhZWRPQW5rQlRVdEFXWURtTVpXLS1CMjhDeE9wcTBvanRoai1ZZENfeUdtZUpNTmpLSElzQzV1ZTNXaC1aYU45d2VtckNv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_020d937e85bf42be","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-08T12:48:38.771419+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQdlVfTjZ4dGZTY1RWZmVITDlreWtnUmJCUEFFUE1aMjJYWlQtdlFSYktvSGktalljZzJPVEVVcjlndm9uNTFhZWRPQW5rQlRVdEFXWURtTVpXLS1CMjhDeE9wcTBvanRoai1ZZENfeUdtZUpNTmpLSElzQzV1ZTNXaC1aYU45d2VtckNv?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQdlVfTjZ4dGZTY1RWZmVITDlreWtnUmJCUEFFUE1aMjJYWlQtdlFSYktvSGktalljZzJPVEVVcjlndm9uNTFhZWRPQW5rQlRVdEFXWURtTVpXLS1CMjhDeE9wcTBvanRoai1ZZENfeUdtZUpNTmpLSElzQzV1ZTNXaC1aYU45d2VtckNv?oc=5","source_event_id":"evt_f2522136b506","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"84f7bd5c8869dcb0","published_at":"2026-04-08T12:28:48+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Hungary","relevance":"directly involved (offered help)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"directly involved (recipient of help)","symbol":"","type":"country"},{"asset_class":"non-state_actor","name":"Hezbollah","relevance":"attack target referenced in catalyst","symbol":"","type":"armed group"}],"event_type":"geopolitical_risk","information_gaps":["What specific form of help Hungary offered to Iran is not stated in the provided headline/signal.","When the pager attack occurred and when Hungary made the offer are not specified.","Whether the offer is diplomatic, intelligence, humanitarian, or energy-related is not provided.","No details are given on whether Iran accepted the offer or any resulting actions."],"key_facts":["A pager attack on Hezbollah occurred (referenced as the trigger).","Following that attack, Hungary offered help to Iran (reported by The Washington Post)."],"numeric_claims":[],"primary_claim":"After a pager attack on Hezbollah, Hungary offered help to Iran, according to The Washington Post.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"The Washington Post reports that after a pager attack on Hezbollah, Hungary offered help to Iran. The signal implies a near-term diplomatic/foreign-policy response by Hungary following the attack.","topics":["Hungary-Iran relations","Hezbollah pager attack","Middle East security","diplomatic assistance","foreign policy"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"After pager attack on Hezbollah, Hungary offered help to Iran The Washington Post Why Hungary\u2019s energy policy is less MAGA than JD Vance might think Politico Vance\u2019s Humiliation Deepens as New Leak Rocks Visit to Boost Trump Ally The Daily Beast Vance\u2019s whirlwind visit may not help Orb\u00e1n to the election victory he craves The Guardian Germany accuses JD Vance of hypocrisy over claim that EU meddled in Hungary\u2019s election politico.eu","title":"After pager attack on Hezbollah, Hungary offered help to Iran - The Washington Post","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_595b0cc4825b in signals