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/CBMiwgFBVV95cUxOQXRNbWRiRUF0QU1sZndUQjdudno2SnZhTFJkRFpVTnQ2a3N1RnU3TWxUZ0Y5d2VPanVKVTh2dXFlUjZHenNfY2J4RUZSVjd0RGpUNFJmTHlzdTVoSVFFM0d1c1I2M0p1TzdYTDRySEdHSERXa2RkTGpKMzZzWXZ3LXB3ZElDbERHR2pzOHkzcWRQd2ttX0hqX0lNY3loSGdwSmFzV1dCVlAyRHFyb1otQ2tYSnBERWV6eVlwNHVUSWxhUQ?oc=5","as_of":"2026-04-07T11:15:38.844333+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/CBMiwgFBVV95cUxOQXRNbWRiRUF0QU1sZndUQjdudno2SnZhTFJkRFpVTnQ2a3N1RnU3TWxUZ0Y5d2VPanVKVTh2dXFlUjZHenNfY2J4RUZSVjd0RGpUNFJmTHlzdTVoSVFFM0d1c1I2M0p1TzdYTDRySEdHSERXa2RkTGpKMzZzWXZ3LXB3ZElDbERHR2pzOHkzcWRQd2ttX0hqX0lNY3loSGdwSmFzV1dCVlAyRHFyb1otQ2tYSnBERWV6eVlwNHVUSWxhUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_893bc567cdc91def","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-07T19:25:04.335611+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxOQXRNbWRiRUF0QU1sZndUQjdudno2SnZhTFJkRFpVTnQ2a3N1RnU3TWxUZ0Y5d2VPanVKVTh2dXFlUjZHenNfY2J4RUZSVjd0RGpUNFJmTHlzdTVoSVFFM0d1c1I2M0p1TzdYTDRySEdHSERXa2RkTGpKMzZzWXZ3LXB3ZElDbERHR2pzOHkzcWRQd2ttX0hqX0lNY3loSGdwSmFzV1dCVlAyRHFyb1otQ2tYSnBERWV6eVlwNHVUSWxhUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxOQXRNbWRiRUF0QU1sZndUQjdudno2SnZhTFJkRFpVTnQ2a3N1RnU3TWxUZ0Y5d2VPanVKVTh2dXFlUjZHenNfY2J4RUZSVjd0RGpUNFJmTHlzdTVoSVFFM0d1c1I2M0p1TzdYTDRySEdHSERXa2RkTGpKMzZzWXZ3LXB3ZElDbERHR2pzOHkzcWRQd2ttX0hqX0lNY3loSGdwSmFzV1dCVlAyRHFyb1otQ2tYSnBERWV6eVlwNHVUSWxhUQ?oc=5","source_event_id":"evt_d251f34b3151","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2140bbef6ebbcc39","published_at":"2026-04-07T09:00:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Wisconsin Supreme Court","relevance":"high","symbol":"","type":"election"},{"asset_class":"political","name":"Marjorie Taylor Greene","relevance":"high","symbol":"MTG","type":"politician"},{"asset_class":"political","name":"Georgia 14th District","relevance":"high","symbol":"","type":"election"}],"event_type":"other","information_gaps":["Specific dates for the elections are not mentioned."],"key_facts":["Wisconsin Supreme Court race is ongoing.","Georgia runoff election for Marjorie Taylor Greene's seat is imminent."],"numeric_claims":[],"primary_claim":"Voters will decide on the Wisconsin Supreme Court race and a Georgia runoff election for Marjorie Taylor Greene's seat.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"Voters in Wisconsin and Georgia are preparing to cast ballots in significant elections, including a Supreme Court race and a runoff for Marjorie Taylor Greene's former seat.","topics":["elections","politics","Georgia","Wisconsin"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"Voters set to decide Wisconsin Supreme Court race and Georgia runoff for Marjorie Taylor Greene's seat NBC News The Democrat vying to replace Marjorie Taylor Greene faces a tall task, but Republicans are still watching closely cnn.com Georgia 14th District runoff election: What voters need to know before heading to the polls CBS News Democrats seek upset in Marjorie Taylor Greene's former Georgia seat USA Today Georgia runoff puts Trump influence to the test in MAGA stronghold Reuters","title":"Voters set to decide Wisconsin Supreme Court race and Georgia runoff for Marjorie Taylor Greene's seat - NBC News","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_e045ffafd33f in signals