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/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

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