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/CBMi1gFBVV95cUxNMzc0TGQzeXlXYlNCNjRaNHplVG5vNjBMRm90TGJySFlQeXgwenYzdWgzZkl5VDB2OWs0enBMQWR2d3cxaG0xeVU3ai1mXzhBeWNwM0g5c2ZfT0ZGOHhzeWFmVHZ3cDdCamN1T1RVSXVTWUhPWHA1S1V3ZW1GaHlTYkJ6SEJfRE5wNkN0SHhsWUd3Wkg0bXc0UGVCUzBVa1o4V0ZMSDlXU0dvQ1BFMkRaNjhmd1NqZXBYdjE3WXBmSmZhUVpvaERZNVoxSGdod2xsbnQ2RUFn?oc=5","as_of":"2026-04-18T03:42:55.555531+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNMzc0TGQzeXlXYlNCNjRaNHplVG5vNjBMRm90TGJySFlQeXgwenYzdWgzZkl5VDB2OWs0enBMQWR2d3cxaG0xeVU3ai1mXzhBeWNwM0g5c2ZfT0ZGOHhzeWFmVHZ3cDdCamN1T1RVSXVTWUhPWHA1S1V3ZW1GaHlTYkJ6SEJfRE5wNkN0SHhsWUd3Wkg0bXc0UGVCUzBVa1o4V0ZMSDlXU0dvQ1BFMkRaNjhmd1NqZXBYdjE3WXBmSmZhUVpvaERZNVoxSGdod2xsbnQ2RUFn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b25f3f23014f5856","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T03:43:24.726740+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNMzc0TGQzeXlXYlNCNjRaNHplVG5vNjBMRm90TGJySFlQeXgwenYzdWgzZkl5VDB2OWs0enBMQWR2d3cxaG0xeVU3ai1mXzhBeWNwM0g5c2ZfT0ZGOHhzeWFmVHZ3cDdCamN1T1RVSXVTWUhPWHA1S1V3ZW1GaHlTYkJ6SEJfRE5wNkN0SHhsWUd3Wkg0bXc0UGVCUzBVa1o4V0ZMSDlXU0dvQ1BFMkRaNjhmd1NqZXBYdjE3WXBmSmZhUVpvaERZNVoxSGdod2xsbnQ2RUFn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nypost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNMzc0TGQzeXlXYlNCNjRaNHplVG5vNjBMRm90TGJySFlQeXgwenYzdWgzZkl5VDB2OWs0enBMQWR2d3cxaG0xeVU3ai1mXzhBeWNwM0g5c2ZfT0ZGOHhzeWFmVHZ3cDdCamN1T1RVSXVTWUhPWHA1S1V3ZW1GaHlTYkJ6SEJfRE5wNkN0SHhsWUd3Wkg0bXc0UGVCUzBVa1o4V0ZMSDlXU0dvQ1BFMkRaNjhmd1NqZXBYdjE3WXBmSmZhUVpvaERZNVoxSGdod2xsbnQ2RUFn?oc=5","source_event_id":"evt_288eed665f95","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"be8342b4cbe0c90f","published_at":"2026-04-17T14:38:00+00:00","publisher_domain":"nypost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 - New York Post","Source summary: CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 New York Post \u2018He's destroying New York': Trump bashes Mamdani over proposed tax on ultrarich NBC New York Zohran Mamdani responds after President Trump rips NYC mayor over tax the rich announcement ABC7 New York How Hochul and Mamdani forged a compromise over taxing the rich Gothamist Tax fight heats up as Ne"],"numeric_claims":[],"primary_claim":"CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 - New York Post","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 New York Post \u2018He's destroying New York': Trump bashes Mamdani over proposed tax on ultrarich NBC New York Zohran Mamdani responds after President Trump rips NYC mayor over tax the rich announcement ABC7 New York How Hochul and Mamdani forged a compromise over taxing the rich Gothamist Tax ","topics":["news headline"]},"source":"New York Post","source_domain":"nypost.com","source_url":"https://nypost.com","summary":"CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 New York Post \u2018He's destroying New York': Trump bashes Mamdani over proposed tax on ultrarich NBC New York Zohran Mamdani responds after President Trump rips NYC mayor over tax the rich announcement ABC7 New York How Hochul and Mamdani forged a compromise over taxing the rich Gothamist Tax fight heats up as New York targets wealthy homeowners Fox Business","title":"CNBC anchor rips Mamdani for filming video outside billionaire Ken Griffin\u2019s NYC penthouse: \u2018Demonizing him\u2019 - New York Post","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_b9bdaa07f442 in signals