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/CBMiqgFBVV95cUxNX09Oa3hlR3A5aTVhMUNwc05yUlhQMGNwLUtXQ2pwaEg3Y0xncDNhSEFLeTB2T1MtWVFuN21GVlRCdVJyelJVdjd5WlFyXzU5WDFlTmVZQTFzUGdsY2l0Ylh6R0wzbmRSWHV2RW5VOVdCRVd3dVVCOXRpdzdaSWViOUFpcDJNY0lQbVZDdS1GeW1WNXZqOFNncU8ydTlJQmVXNEZpb1h4ZUNYZw?oc=5","as_of":"2026-04-14T02:27:43.466812+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNX09Oa3hlR3A5aTVhMUNwc05yUlhQMGNwLUtXQ2pwaEg3Y0xncDNhSEFLeTB2T1MtWVFuN21GVlRCdVJyelJVdjd5WlFyXzU5WDFlTmVZQTFzUGdsY2l0Ylh6R0wzbmRSWHV2RW5VOVdCRVd3dVVCOXRpdzdaSWViOUFpcDJNY0lQbVZDdS1GeW1WNXZqOFNncU8ydTlJQmVXNEZpb1h4ZUNYZw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ee118ceeea7c709b","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T02:41:15.814610+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNX09Oa3hlR3A5aTVhMUNwc05yUlhQMGNwLUtXQ2pwaEg3Y0xncDNhSEFLeTB2T1MtWVFuN21GVlRCdVJyelJVdjd5WlFyXzU5WDFlTmVZQTFzUGdsY2l0Ylh6R0wzbmRSWHV2RW5VOVdCRVd3dVVCOXRpdzdaSWViOUFpcDJNY0lQbVZDdS1GeW1WNXZqOFNncU8ydTlJQmVXNEZpb1h4ZUNYZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"alaskasnewssource.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNX09Oa3hlR3A5aTVhMUNwc05yUlhQMGNwLUtXQ2pwaEg3Y0xncDNhSEFLeTB2T1MtWVFuN21GVlRCdVJyelJVdjd5WlFyXzU5WDFlTmVZQTFzUGdsY2l0Ylh6R0wzbmRSWHV2RW5VOVdCRVd3dVVCOXRpdzdaSWViOUFpcDJNY0lQbVZDdS1GeW1WNXZqOFNncU8ydTlJQmVXNEZpb1h4ZUNYZw?oc=5","source_event_id":"evt_aa4420419018","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ca8bc7523e9579d2","published_at":"2026-04-14T02:08:00+00:00","publisher_domain":"alaskasnewssource.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Peltola campaign","relevance":"primary","symbol":"","type":"campaign"},{"asset_class":"other","name":"Sullivan campaign","relevance":"primary","symbol":"","type":"campaign"},{"asset_class":"other","name":"Alaska's News Source","relevance":"source","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No article text is available beyond the headline/source summary.","No specific earnings amounts are provided.","No time period for the earnings comparison is provided.","No context is provided for what \u201cearnings\u201d refers to (e.g., fundraising, revenue, or another metric).","No details on near-term catalyst timing are provided."],"key_facts":["Headline claims Peltola campaign earnings are four times Sullivan campaign earnings.","Source cited is Alaska's News Source."],"numeric_claims":[{"label":"earnings multiple","value":"4x"}],"primary_claim":"The Peltola campaign quadruples the Sullivan campaign earnings, as reported by Alaska's News Source.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"The headline states that the Peltola campaign has quadrupled the Sullivan campaign\u2019s earnings, according to Alaska's News Source. No additional details (timing, amounts, or context) are provided in the signal.","topics":["campaign earnings","political campaigns","Alaska"]},"source":"Alaska's News Source","source_domain":"alaskasnewssource.com","source_url":"https://www.alaskasnewssource.com","summary":"Peltola campaign quadruples Sullivan campaign earnings Alaska's News Source","title":"Peltola campaign quadruples Sullivan campaign earnings - Alaska's News Source","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_89762ab308c9 in signals