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/CBMizwFBVV95cUxPZzJ3Mmd4NkY4MWUyZTdfekpYekpVa3Z0NWlNNllKX2E1c3dWVVplY3BfR25jS0Rrc0VaZlBEV1ZDSlY1c2p1alY4QzNFUjAzaHpUdFhSaUhSVnpkU0M3bHEwYmVfTGp1X1loSHR4Q1FMd2pVVjZjOE1NaEZnTVBaby1jOHMybHJtUl9BQU1QRTFuYXNFNHhJUXFlQ0tWdm5Sa2kxaHBURnRGdHZYaXZ2LW4wTk94eGQyeXZRdG9URUZaUFRBT2NJNlhqRDJ2TVk?oc=5","as_of":"2026-04-09T02:28:02.129168+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/CBMizwFBVV95cUxPZzJ3Mmd4NkY4MWUyZTdfekpYekpVa3Z0NWlNNllKX2E1c3dWVVplY3BfR25jS0Rrc0VaZlBEV1ZDSlY1c2p1alY4QzNFUjAzaHpUdFhSaUhSVnpkU0M3bHEwYmVfTGp1X1loSHR4Q1FMd2pVVjZjOE1NaEZnTVBaby1jOHMybHJtUl9BQU1QRTFuYXNFNHhJUXFlQ0tWdm5Sa2kxaHBURnRGdHZYaXZ2LW4wTk94eGQyeXZRdG9URUZaUFRBT2NJNlhqRDJ2TVk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7a38f3742a4c1d32","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:28:16.092496+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxPZzJ3Mmd4NkY4MWUyZTdfekpYekpVa3Z0NWlNNllKX2E1c3dWVVplY3BfR25jS0Rrc0VaZlBEV1ZDSlY1c2p1alY4QzNFUjAzaHpUdFhSaUhSVnpkU0M3bHEwYmVfTGp1X1loSHR4Q1FMd2pVVjZjOE1NaEZnTVBaby1jOHMybHJtUl9BQU1QRTFuYXNFNHhJUXFlQ0tWdm5Sa2kxaHBURnRGdHZYaXZ2LW4wTk94eGQyeXZRdG9URUZaUFRBT2NJNlhqRDJ2TVk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thedailybeast.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxPZzJ3Mmd4NkY4MWUyZTdfekpYekpVa3Z0NWlNNllKX2E1c3dWVVplY3BfR25jS0Rrc0VaZlBEV1ZDSlY1c2p1alY4QzNFUjAzaHpUdFhSaUhSVnpkU0M3bHEwYmVfTGp1X1loSHR4Q1FMd2pVVjZjOE1NaEZnTVBaby1jOHMybHJtUl9BQU1QRTFuYXNFNHhJUXFlQ0tWdm5Sa2kxaHBURnRGdHZYaXZ2LW4wTk94eGQyeXZRdG9URUZaUFRBT2NJNlhqRDJ2TVk?oc=5","source_event_id":"evt_5b84bb358184","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"326676fcb127ddf7","published_at":"2026-04-08T18:14:00+00:00","publisher_domain":"thedailybeast.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"media","name":"CNN data guru (unnamed in provided text)","relevance":"medium","symbol":"","type":"media_personality"},{"asset_class":"media","name":"The Daily Beast","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"political_geography","name":"Wisconsin","relevance":"high","symbol":"","type":"state"},{"asset_class":"political_geography","name":"Georgia","relevance":"high","symbol":"","type":"state"},{"asset_class":"political","name":"Republicans","relevance":"medium","symbol":"","type":"political_party"}],"event_type":"price_action","information_gaps":["The cleaned article text is not actually present (only CSS/HTML boilerplate), so the specific details of the Daily Beast article (who the CNN \u201cdata guru\u201d is, which races, vote margins, and timing) are not verifiable from the provided content.","No explicit dates for the election results or the momentum surge are included in the provided text.","The signal does not specify whether the Wisconsin/Georgia results are final or preliminary, nor the exact margin figures."],"key_facts":["The Daily Beast headline states that a CNN data guru is \u201cstunned\u201d by Democrats\u2019 momentum surge.","The provided source summary includes claims that Democrats are performing strongly in Wisconsin and narrowing margins in Georgia.","The provided source summary also indicates Republicans have \u201cnew reasons to reach for the panic button,\u201d implying increased concern following the results."],"numeric_claims":[],"primary_claim":"Democrats\u2019 election momentum surge is surprising CNN\u2019s data-focused commentator, as reflected in recent election hot streak results.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Daily Beast reports that Democrats are gaining momentum in recent election results, surprising a CNN data-focused commentator. The broader coverage cited suggests Democrats are performing strongly in key state races (e.g., Wisconsin and Georgia), tightening margins and increasing Republican concern.","topics":["US elections","Democratic momentum","state-level election results","Wisconsin","Georgia","media commentary"]},"source":"The Daily Beast","source_domain":"thedailybeast.com","source_url":"https://www.thedailybeast.com","summary":"CNN Data Guru Stunned by Dems\u2019 Momentum Surge The Daily Beast \u2018A wow moment\u2019: Democrats\u2019 election hot streak goes scorching Politico Georgia, Wisconsin Elections Show Declining Appetite for Republican Candidates The New York Times Latest election results give Republicans new reasons to reach for the panic button MS NOW Democrats romp in Wisconsin Supreme Court race, narrow margins in Georgia CNBC","title":"CNN Data Guru Stunned by Dems\u2019 Momentum Surge - The Daily Beast","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_3d8b8ccb0a55 in signals