SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-10T16:36:01.663363+00:00","dedupe_key":"signal_enriched:news_delta:2e141d1ae422105f","evidence_event_ids":["evt_4c5959b0a5db"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxPVVJ4M2hVUm9OWFBabUw4bFA0RHVvT1FmME9oSjAzOFBnczlVMGNMcGJya2ZqUHFXeTV5WkNSRFJCdDl2c1FFZnNDOGJpRHlBWWwyTGNSNV9wMzhNOEFNZGRPeTdTR0h5ejZZNi1vTVNacHVVTWN4aVVmcjRFQ1FHdGRhWHVLVHFGVVZnQ0tKdFpqa3J2WC04QmlLSmdwWVVIS0U5SVNTVURmdw?oc=5","as_of":"2026-04-10T16:36:01.663363+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/CBMiqgFBVV95cUxPVVJ4M2hVUm9OWFBabUw4bFA0RHVvT1FmME9oSjAzOFBnczlVMGNMcGJya2ZqUHFXeTV5WkNSRFJCdDl2c1FFZnNDOGJpRHlBWWwyTGNSNV9wMzhNOEFNZGRPeTdTR0h5ejZZNi1vTVNacHVVTWN4aVVmcjRFQ1FHdGRhWHVLVHFGVVZnQ0tKdFpqa3J2WC04QmlLSmdwWVVIS0U5SVNTVURmdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_072c8610e5a21068","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-10T17:17:00.538205+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxPVVJ4M2hVUm9OWFBabUw4bFA0RHVvT1FmME9oSjAzOFBnczlVMGNMcGJya2ZqUHFXeTV5WkNSRFJCdDl2c1FFZnNDOGJpRHlBWWwyTGNSNV9wMzhNOEFNZGRPeTdTR0h5ejZZNi1vTVNacHVVTWN4aVVmcjRFQ1FHdGRhWHVLVHFGVVZnQ0tKdFpqa3J2WC04QmlLSmdwWVVIS0U5SVNTVURmdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxPVVJ4M2hVUm9OWFBabUw4bFA0RHVvT1FmME9oSjAzOFBnczlVMGNMcGJya2ZqUHFXeTV5WkNSRFJCdDl2c1FFZnNDOGJpRHlBWWwyTGNSNV9wMzhNOEFNZGRPeTdTR0h5ejZZNi1vTVNacHVVTWN4aVVmcjRFQ1FHdGRhWHVLVHFGVVZnQ0tKdFpqa3J2WC04QmlLSmdwWVVIS0U5SVNTVURmdw?oc=5","source_event_id":"evt_4c5959b0a5db","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eef1a02d5bf4bf6b","published_at":"2026-04-10T09:55:00+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Zohran Mamdani","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"NYC Mayor Zohran Mamdani","relevance":"high","symbol":"","type":"role"},{"asset_class":"other","name":"Politico","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The provided article text is not available (only page styling/HTML is present), so details beyond the headline and the provided source summary cannot be verified.","No specific policy actions, metrics, or campaign promises fulfilled are included in the extracted content, despite being mentioned in the provided source summary list.","The exact timing/date of the 100-day mark and the context for the quote are not present in the provided text."],"key_facts":["The Politico headline references Mamdani\u2019s 100 days in office.","The headline includes a quoted statement attributed to Mamdani: \u201cWe don\u2019t have enough time to complain.\u201d","Politico characterizes Mamdani as \u201calready a different kind of mayor.\u201d"],"numeric_claims":[{"label":"tenure milestone","value":"100 days"}],"primary_claim":"At 100 days in office, NYC Mayor Zohran Mamdani said, \u201cWe don\u2019t have enough time to complain,\u201d and Politico describes him as already a different kind of mayor.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Politico reports that NYC Mayor Zohran Mamdani, at 100 days in office, is framing the early period as too short to focus on complaints. The coverage positions him as having already shifted into a different governing mode.","topics":["local government","mayoral performance","public statements","NYC politics","early tenure (100 days)"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Mamdani at 100 days: \u2018We don\u2019t have enough time to complain\u2019 Politico At 100 days, Mamdani is already a different kind of mayor Politico Tracking 7 of Mamdani\u2019s Biggest Campaign Promises The New York Times New poll reveals what New Yorkers think of NYC Mayor Mamdani The Journal News | lohud.com Zohran Mamdani, Perpetual Student of the City The New Yorker","title":"Mamdani at 100 days: \u2018We don\u2019t have enough time to complain\u2019 - Politico","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 18469 in events