SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.facebook.com/frontlinestoriesfromreporters/posts/million-strong-demonstrations-swept-across-the-yemeni-capital-sanaa-and-dozens-o/1499881138593755/","as_of":"2026-04-03T11:17:56.444213+00:00","canonical_url":"https://www.facebook.com/reel/1578212479952005/","enrichment":{"aggregator_url":"https://www.facebook.com/frontlinestoriesfromreporters/posts/million-strong-demonstrations-swept-across-the-yemeni-capital-sanaa-and-dozens-o/1499881138593755/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4ca0051128d30401","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/reel/1578212479952005/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T00:34:29.562782+00:00","extraction_method":"heuristic","fetched_description":"Million-strong demonstrations swept across the Yemeni capital, Sana\u2019a, and dozens of northern provinces under the slogan \u201cSteadfast\u2026 and Ready for All...","fetched_title":"Million-strong demonstrations swept across the Yemeni capital, Sana\u2019a, and dozens of northern provinces under the slogan \u201cSteadfast\u2026 and Ready for All Options.\u201d The rallies voiced support for Iran, Lebanon, and Iraq, while effectively granting authorities in Sana\u2019a a mandate to take direct action in response to the ongoing US-Israeli campaign against Iran, now entering its fourth week. | CGTN Frontline","final_url":"https://www.facebook.com/frontlinestoriesfromreporters/videos/million-strong-demonstrations-swept-across-the-yemeni-capital-sanaa-and-dozens-o/1578212479952005/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/frontlinestoriesfromreporters/posts/million-strong-demonstrations-swept-across-the-yemeni-capital-sanaa-and-dozens-o/1499881138593755/","source_event_id":"evt_dd3e5465aeca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0e289182d49ad51a","published_at":"","publisher_domain":"facebook.com","query":"IDF official says latest developments IDF official says disarming Hezbollah unrealistic not corroboration","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Yemen","relevance":"high","symbol":"YEM","type":"country"},{"asset_class":"political","name":"Iran","relevance":"high","symbol":"IR","type":"country"}],"event_type":"other","information_gaps":["Details on the specific actions authorities may take in response to the demonstrations are unclear.","The exact reasons for the support of Iran, Lebanon, and Iraq are not detailed."],"key_facts":["Demonstrations involved over a million participants.","The slogan of the demonstrations was 'Steadfast\u2026 and Ready for All Options.'","The protests supported Iran, Lebanon, and Iraq."],"numeric_claims":[{"label":"Number of participants","value":"1,000,000"}],"primary_claim":"Million-strong demonstrations took place in Sana'a and northern provinces of Yemen.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"Massive demonstrations occurred in Sana'a, Yemen, with participants expressing support for Iran and a mandate for local authorities to respond to external pressures.","topics":["demonstrations","political unrest","Middle East relations"]},"snippet":"Million-strong demonstrations swept across the Yemeni capital, Sana'a, and dozens of northern provinces under the slogan \u201cSteadfast\u2026 and Ready for All...","source":"web_search","source_domain":"facebook.com","summary":"Million-strong demonstrations swept across the Yemeni capital, Sana'a, and dozens of northern provinces under the slogan \u201cSteadfast\u2026 and Ready for All...","title":"Million-strong demonstrations swept across the Yemeni capital ...","url":"https://www.facebook.com/reel/1578212479952005/"}

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_032dd37fe17f in signals