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/CBMitwFBVV95cUxNZHBoMWYxdGtfWm8zeS1WME5wSzU1eXduaEhDSUhmbjl3M0drYUxxb21tUXhrQVBfSHRnd0Rrd3hPejdfM2w1b0phRHpSVHZrWTRmRFNtZXNwYldTeFBWaUJCOUlqeG5pTWdFYnZFb2lsTVJkazFTak1WS3k1XzFiQUI2eERCU293VzJQdy13UGpCTkpkTncyNzlDdVQza21aY3ppMHVZV0p1d3JUNHdndUM5T0NidXc?oc=5","as_of":"2026-04-08T23:28:56.313025+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/CBMitwFBVV95cUxNZHBoMWYxdGtfWm8zeS1WME5wSzU1eXduaEhDSUhmbjl3M0drYUxxb21tUXhrQVBfSHRnd0Rrd3hPejdfM2w1b0phRHpSVHZrWTRmRFNtZXNwYldTeFBWaUJCOUlqeG5pTWdFYnZFb2lsTVJkazFTak1WS3k1XzFiQUI2eERCU293VzJQdy13UGpCTkpkTncyNzlDdVQza21aY3ppMHVZV0p1d3JUNHdndUM5T0NidXc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0f92cf85c9b341b6","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:18:02.867266+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxNZHBoMWYxdGtfWm8zeS1WME5wSzU1eXduaEhDSUhmbjl3M0drYUxxb21tUXhrQVBfSHRnd0Rrd3hPejdfM2w1b0phRHpSVHZrWTRmRFNtZXNwYldTeFBWaUJCOUlqeG5pTWdFYnZFb2lsTVJkazFTak1WS3k1XzFiQUI2eERCU293VzJQdy13UGpCTkpkTncyNzlDdVQza21aY3ppMHVZV0p1d3JUNHdndUM5T0NidXc?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/CBMitwFBVV95cUxNZHBoMWYxdGtfWm8zeS1WME5wSzU1eXduaEhDSUhmbjl3M0drYUxxb21tUXhrQVBfSHRnd0Rrd3hPejdfM2w1b0phRHpSVHZrWTRmRFNtZXNwYldTeFBWaUJCOUlqeG5pTWdFYnZFb2lsTVJkazFTak1WS3k1XzFiQUI2eERCU293VzJQdy13UGpCTkpkTncyNzlDdVQza21aY3ppMHVZV0p1d3JUNHdndUM5T0NidXc?oc=5","source_event_id":"evt_f8dfe85c7ada","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7dcdea906bc359a3","published_at":"2026-04-08T21:23:50+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["midterms","Week 6 (of the Iran War)"],"entities":[{"asset_class":"political","name":"Republicans","relevance":"directly affected","symbol":"","type":"political_party"},{"asset_class":"political","name":"Democrats","relevance":"contextual counterpart","symbol":"","type":"political_party"},{"asset_class":"sovereign","name":"Iran","relevance":"geopolitical driver of the political concern","symbol":"","type":"country"},{"asset_class":"political_person","name":"Trump","relevance":"referenced in source summary as part of credibility framing","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["No specific evidence is included in the provided text (e.g., polling numbers, district-level impacts, or which Iran event is being referenced).","Unclear whether the \u201calready cost them Congress\u201d claim is based on polling, internal GOP assessments, or specific legislative/electoral events.","No timing details are provided beyond the general \u201cmidterms\u201d and \u201cWeek 6\u201d reference; exact election date and near-term catalysts are not specified in the supplied content."],"key_facts":["Politico headline states Republicans worry Iran might have already cost them Congress in the midterms.","The provided source summary includes framing that \u201cTrump\u2019s credibility gap widens\u201d in connection with the Iran war.","The provided source summary includes \u201cIran war rejected\u201d and references to clashes between Democrats and Republicans in \u201cWeek 6 of the Iran War.\u201d"],"numeric_claims":[],"primary_claim":"Republicans worry that Iran-related developments may have already cost them control of Congress in the midterms.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Politico reports that Republicans fear the Iran war may already have harmed their chances in the upcoming midterm elections, framing it as a credibility/political cost to the GOP.","topics":["U.S. midterm elections","Iran war","U.S. domestic politics","Trump credibility","partisan polling/electoral risk"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"\u2018We lose the midterms\u2019: Republicans worry Iran might have already cost them Congress Politico Iran war rejected: Trump\u2019s credibility gap widens The Hill James Carville Reveals Telling Sign Trump\u2019s GOP Is Going Down The Daily Beast \"Not Our Responsibility\": How Young MAGA Voters Are Reacting to Trump\u2019s War in Iran Time Magazine How Democrats and Republicans Are Clashing in Week 6 of the Iran War The New York Times","title":"\u2018We lose the midterms\u2019: Republicans worry Iran might have already cost them Congress - 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

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