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-09T02:28:01.000135+00:00","dedupe_key":"signal_enriched:news_delta:d943513d7aef70fd","evidence_event_ids":["evt_9251c492f4ea"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQZHB3UXNtbHV4bHZyajJkcEZvaXcwVFV0d25LUWJfMDJqelVQaDh0MzFjdV9OSFRhWmJJcTY3dUtvZ2dheklWekdQcDItZDFKTkdPanRSVlVuR1UzVWlNX19oMDcxdnJEc3VpUkpiUC0xd2V4TDRmUWpacUY1M2NlYlFIOS1kcjNU?oc=5","as_of":"2026-04-09T02:28:01.000135+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/CBMiiAFBVV95cUxQZHB3UXNtbHV4bHZyajJkcEZvaXcwVFV0d25LUWJfMDJqelVQaDh0MzFjdV9OSFRhWmJJcTY3dUtvZ2dheklWekdQcDItZDFKTkdPanRSVlVuR1UzVWlNX19oMDcxdnJEc3VpUkpiUC0xd2V4TDRmUWpacUY1M2NlYlFIOS1kcjNU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_193df10796e1fc1c","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-09T22:26:58.591119+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQZHB3UXNtbHV4bHZyajJkcEZvaXcwVFV0d25LUWJfMDJqelVQaDh0MzFjdV9OSFRhWmJJcTY3dUtvZ2dheklWekdQcDItZDFKTkdPanRSVlVuR1UzVWlNX19oMDcxdnJEc3VpUkpiUC0xd2V4TDRmUWpacUY1M2NlYlFIOS1kcjNU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQZHB3UXNtbHV4bHZyajJkcEZvaXcwVFV0d25LUWJfMDJqelVQaDh0MzFjdV9OSFRhWmJJcTY3dUtvZ2dheklWekdQcDItZDFKTkdPanRSVlVuR1UzVWlNX19oMDcxdnJEc3VpUkpiUC0xd2V4TDRmUWpacUY1M2NlYlFIOS1kcjNU?oc=5","source_event_id":"evt_9251c492f4ea","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9a3fda55aa53d302","published_at":"2026-04-08T23:35:28+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Hasan Piker","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"The New York Times","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"other","name":"Bhaskar Sunkara","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Abdul El-Sayed","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Michigan State University (MSU)","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Bridge Michigan","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"CBS News","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned \u201cArticle Text\u201d appears to be mostly HTML/CSS and does not contain the NYT article\u2019s actual content; therefore, the specific arguments, quotes, and factual details from the NYT piece are not extractable from the provided text.","The source summary references other outlets (Guardian, CBS News) but does not provide their full details; specific claims about events, dates, locations, and outcomes are missing.","No concrete timing (e.g., election date, event date) is included in the provided material.","information_gaps_additional_note?"],"key_facts":["NYT headline: \u201cHasan Piker Can Stream, but Can He Stump?\u201d (headline-only information).","Source summary mentions: \u201cWhy do elite Democrats fear Hasan Piker?\u201d (Guardian) and multiple Michigan-related items including Abdul El-Sayed courting college voters and controversy involving a Michigan Senate stop with Hasan Piker (CBS News).","Source summary mentions MSU president and trustees issuing a statement on a speaker (details not provided in the supplied text)."],"numeric_claims":[],"primary_claim":"The New York Times headline poses the question of whether Hasan Piker can \u201cstream\u201d and also \u201cstump\u201d effectively in a political context.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The New York Times headline frames a question about whether Hasan Piker can both stream and \u201cstump\u201d (campaign) effectively, implying political concern among elite Democrats. The provided text does not include the article\u2019s substantive details, but the accompanying source summary references related political controversy and Michigan events involving Democratic candidates and a speaker at Michigan State University.","topics":["US politics","Democratic Party","political campaigning","streaming/political media","Michigan elections","campus speakers","intra-party rifts"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Hasan Piker Can Stream, but Can He Stump? The New York Times Why do elite Democrats fear Hasan Piker? | Bhaskar Sunkara The Guardian Abdul El-Sayed courts college voters, controversy in Michigan Senate stop Bridge Michigan Democratic Senate candidate's events with Hasan Piker exposes party rift in Michigan CBS News MSU president, trustees issue statement on speaker Michigan State University","title":"Hasan Piker Can Stream, but Can He Stump? - The New York Times","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 8734 in events