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/CBMihwFBVV95cUxNZVZzVldwOGk4bnlTZG1LYVVQNXNfYVJtSEpiekQxSzI1WHB4VWtOVGlqaWFvckRCWW9tVDU0dktGaXFSMGdiZk1NaTNSdUxYNnlFVmJFaEtaWVFGb2k5RUJXMjQ2N053RE5WRDhBX2k4WFNYUG9FWDlxTFVPckdtV0ZodWNZdms?oc=5","as_of":"2026-04-10T17:15:05.605727+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/CBMihwFBVV95cUxNZVZzVldwOGk4bnlTZG1LYVVQNXNfYVJtSEpiekQxSzI1WHB4VWtOVGlqaWFvckRCWW9tVDU0dktGaXFSMGdiZk1NaTNSdUxYNnlFVmJFaEtaWVFGb2k5RUJXMjQ2N053RE5WRDhBX2k4WFNYUG9FWDlxTFVPckdtV0ZodWNZdms?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_35225cf044430764","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-10T17:17:28.024403+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxNZVZzVldwOGk4bnlTZG1LYVVQNXNfYVJtSEpiekQxSzI1WHB4VWtOVGlqaWFvckRCWW9tVDU0dktGaXFSMGdiZk1NaTNSdUxYNnlFVmJFaEtaWVFGb2k5RUJXMjQ2N053RE5WRDhBX2k4WFNYUG9FWDlxTFVPckdtV0ZodWNZdms?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/CBMihwFBVV95cUxNZVZzVldwOGk4bnlTZG1LYVVQNXNfYVJtSEpiekQxSzI1WHB4VWtOVGlqaWFvckRCWW9tVDU0dktGaXFSMGdiZk1NaTNSdUxYNnlFVmJFaEtaWVFGb2k5RUJXMjQ2N053RE5WRDhBX2k4WFNYUG9FWDlxTFVPckdtV0ZodWNZdms?oc=5","source_event_id":"evt_2492f3b1a946","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2bd2a6258cb1ed2e","published_at":"2026-04-10T16:19:55+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2028"],"entities":[{"asset_class":"political_person","name":"Kamala Harris","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"media","name":"Politico","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"10TV","relevance":"corroborating outlet","symbol":"","type":"publisher"},{"asset_class":"media","name":"The New York Times","relevance":"corroborating outlet","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNN","relevance":"corroborating outlet","symbol":"","type":"publisher"},{"asset_class":"media","name":"NBC News","relevance":"corroborating outlet","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The provided text does not include the full Politico article or the exact quote(s) and context beyond the headline/summary references.","No details are provided on timing of any formal campaign launch, fundraising, or organizational steps.","No information is provided on whether Harris has set specific conditions or milestones for a 2028 run."],"key_facts":["Politico headline states Harris gave her clearest signal she is mounting a 2028 presidential bid.","Other cited coverage reports Harris said she \u201cmight\u201d run for president in 2028.","Other cited coverage reports Harris said she is \u201cthinking about\u201d running in the 2028 presidential election.","The described statements are framed as consideration rather than a definitive announcement (uncertainty remains)."],"numeric_claims":[],"primary_claim":"Kamala Harris signaled she is considering a 2028 presidential run, with Politico characterizing it as her clearest signal yet.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Politico reports that Vice President Kamala Harris has given what it describes as her clearest signal that she may mount a 2028 presidential bid. Multiple outlets cite her saying she is \u201cthinking about\u201d running and using \u201cmight\u201d language.","topics":["2028 presidential election","U.S. politics","presidential campaign signaling","Vice President Kamala Harris"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Harris gives her clearest signal she is mounting a 2028 presidential bid Politico Kamala Harris says she 'might' run for president in 2028 10TV Harris Says She Is \u2018Thinking About\u2019 Running for President Again in 2028 The New York Times Kamala Harris says she is \u2018thinking about\u2019 running in 2028 presidential election CNN Kamala Harris confirms she might run for president again: 'I'm thinking about it' NBC News","title":"Harris gives her clearest signal she is mounting a 2028 presidential bid - 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_3d20f7f833f9 in signals