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/CBMipAFBVV95cUxPUGc5WDlvTWR6M2xmbUUteGFKLTJWV0l2S2hMOExncXhJTFN3bktnVkJfZ19Qb3BqaHUtRkt0bjdsLTIyRzJVY1ZqT2g3LThVNzk0eDlMU0FWSkYzTF9ybjdaZ1FmRnBsSnlrSUZzckk0VERrckFhUk5GVGppTkhjNS1ueEpLUW1hQlkyTHpxcHJnOFhhMExoaXFlaGJSNlhHLWJqbg?oc=5","as_of":"2026-04-07T00:26:15.697278+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPUGc5WDlvTWR6M2xmbUUteGFKLTJWV0l2S2hMOExncXhJTFN3bktnVkJfZ19Qb3BqaHUtRkt0bjdsLTIyRzJVY1ZqT2g3LThVNzk0eDlMU0FWSkYzTF9ybjdaZ1FmRnBsSnlrSUZzckk0VERrckFhUk5GVGppTkhjNS1ueEpLUW1hQlkyTHpxcHJnOFhhMExoaXFlaGJSNlhHLWJqbg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f046ebd546c2c2b1","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T14:20:52.517903+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPUGc5WDlvTWR6M2xmbUUteGFKLTJWV0l2S2hMOExncXhJTFN3bktnVkJfZ19Qb3BqaHUtRkt0bjdsLTIyRzJVY1ZqT2g3LThVNzk0eDlMU0FWSkYzTF9ybjdaZ1FmRnBsSnlrSUZzckk0VERrckFhUk5GVGppTkhjNS1ueEpLUW1hQlkyTHpxcHJnOFhhMExoaXFlaGJSNlhHLWJqbg?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/CBMipAFBVV95cUxPUGc5WDlvTWR6M2xmbUUteGFKLTJWV0l2S2hMOExncXhJTFN3bktnVkJfZ19Qb3BqaHUtRkt0bjdsLTIyRzJVY1ZqT2g3LThVNzk0eDlMU0FWSkYzTF9ybjdaZ1FmRnBsSnlrSUZzckk0VERrckFhUk5GVGppTkhjNS1ueEpLUW1hQlkyTHpxcHJnOFhhMExoaXFlaGJSNlhHLWJqbg?oc=5","source_event_id":"evt_492eb3ac8b77","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"85ec829ee23f8b59","published_at":"2026-04-06T20:23:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2023-04-10"],"entities":[{"asset_class":"politics","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"other","information_gaps":["Details on the specific comments made by Trump about Iran are not provided."],"key_facts":["Trump made comments about Iran during the Easter Egg Roll.","He mimicked a sniper in the press room.","Melania Trump made a fashion statement at the event."],"numeric_claims":[],"primary_claim":"Trump discussed Iran at the Easter Egg Roll event.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"Trump's recent public appearances included comments on Iran during the Easter Egg Roll, where he also engaged in playful interactions with children.","topics":["politics","Iran","Trump","Easter Egg Roll"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Photos of Trump's Monday, talking Iran at Easter Egg Roll and mimicking a sniper in the press room AP News Melania Trump\u2019s Unexpected Easter Look The New York Times Melania Trump made a statement in Ralph Lauren at the White House Easter Egg Roll, our chief fashion critic Vanessa Friedman writes. facebook.com Trump roasts Biden over autopen use in viral interaction with kids at White House Easter Egg Roll Fox News With the Easter Bunny at his side, Trump won\u2019t stop talking about Iran CNN","title":"Photos of Trump's Monday, talking Iran at Easter Egg Roll and mimicking a sniper in the press room - AP News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_e50713e9ea9a in signals