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/CBMijAFBVV95cUxOX1k2UXhfTUNKdThDVW9jN1lWeGVaSTg0LVluT3pFakRVak5ZM1Z0MGNUVHJyVjNUUVBGRkZDMlB5VGw5WHV4bXdTZ1IwRW1CM3VKUzJJcXJOcmluaUNRSm5BNUtRZUU3SHpBeEpySjZmNmdWYXprbXQtWTJSUi1TbFdWc3dJdGEyUEt0atIBkgFBVV95cUxNTW1RNElwWk9GcDdqN3FwQ096YWllQ2dZMU9iM3ZvOWprQ2F1b1N5eFd0WXJxalVsczZZUHlSUXlGeVhNUXI4OGVqN0xYYmtfSThvaXd1NzExNWNfYnppTHFtQ05HNXdqSGxHNkNHX055VXc0WWxHOUczOFhGSGJLM3JGaUFIOGhJN3BxQUgyMzNGQQ?oc=5","as_of":"2026-04-08T02:13:53.608829+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/CBMijAFBVV95cUxOX1k2UXhfTUNKdThDVW9jN1lWeGVaSTg0LVluT3pFakRVak5ZM1Z0MGNUVHJyVjNUUVBGRkZDMlB5VGw5WHV4bXdTZ1IwRW1CM3VKUzJJcXJOcmluaUNRSm5BNUtRZUU3SHpBeEpySjZmNmdWYXprbXQtWTJSUi1TbFdWc3dJdGEyUEt0atIBkgFBVV95cUxNTW1RNElwWk9GcDdqN3FwQ096YWllQ2dZMU9iM3ZvOWprQ2F1b1N5eFd0WXJxalVsczZZUHlSUXlGeVhNUXI4OGVqN0xYYmtfSThvaXd1NzExNWNfYnppTHFtQ05HNXdqSGxHNkNHX055VXc0WWxHOUczOFhGSGJLM3JGaUFIOGhJN3BxQUgyMzNGQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_967641719745d95c","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-08T02:14:32.090170+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxOX1k2UXhfTUNKdThDVW9jN1lWeGVaSTg0LVluT3pFakRVak5ZM1Z0MGNUVHJyVjNUUVBGRkZDMlB5VGw5WHV4bXdTZ1IwRW1CM3VKUzJJcXJOcmluaUNRSm5BNUtRZUU3SHpBeEpySjZmNmdWYXprbXQtWTJSUi1TbFdWc3dJdGEyUEt0atIBkgFBVV95cUxNTW1RNElwWk9GcDdqN3FwQ096YWllQ2dZMU9iM3ZvOWprQ2F1b1N5eFd0WXJxalVsczZZUHlSUXlGeVhNUXI4OGVqN0xYYmtfSThvaXd1NzExNWNfYnppTHFtQ05HNXdqSGxHNkNHX055VXc0WWxHOUczOFhGSGJLM3JGaUFIOGhJN3BxQUgyMzNGQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fox2now.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxOX1k2UXhfTUNKdThDVW9jN1lWeGVaSTg0LVluT3pFakRVak5ZM1Z0MGNUVHJyVjNUUVBGRkZDMlB5VGw5WHV4bXdTZ1IwRW1CM3VKUzJJcXJOcmluaUNRSm5BNUtRZUU3SHpBeEpySjZmNmdWYXprbXQtWTJSUi1TbFdWc3dJdGEyUEt0atIBkgFBVV95cUxNTW1RNElwWk9GcDdqN3FwQ096YWllQ2dZMU9iM3ZvOWprQ2F1b1N5eFd0WXJxalVsczZZUHlSUXlGeVhNUXI4OGVqN0xYYmtfSThvaXd1NzExNWNfYnppTHFtQ05HNXdqSGxHNkNHX055VXc0WWxHOUczOFhGSGJLM3JGaUFIOGhJN3BxQUgyMzNGQQ?oc=5","source_event_id":"evt_838cd409f952","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6695f8f401bbcf31","published_at":"2026-04-08T01:52:17+00:00","publisher_domain":"fox2now.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"St. Louis","relevance":"affected jurisdiction","symbol":"","type":"place"},{"asset_class":"","name":"FOX 2","relevance":"source of the headline","symbol":"","type":"media_source"}],"event_type":"regulation","information_gaps":["The article text provided contains no additional details beyond the headline/summary.","No information on when the renewal takes effect or the duration of the renewed tax.","No details on which entities (individuals vs. businesses) are subject to the tax or how it impacts specific sectors.","No vote margin or turnout figures are included in the provided text."],"key_facts":["A 1% earnings tax renewal was approved by St. Louis voters (per FOX 2 headline)."],"numeric_claims":[{"label":"earnings tax rate","value":"1%"}],"primary_claim":"St. Louis voters approved the renewal of a 1% earnings tax.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"St. Louis voters approved renewing a 1% earnings tax, according to FOX 2.","topics":["tax","voter approval","municipal finance","earnings tax renewal"]},"source":"FOX 2","source_domain":"fox2now.com","source_url":"https://fox2now.com","summary":"St. Louis voters approve renewal of 1% earnings tax FOX 2","title":"St. Louis voters approve renewal of 1% earnings tax - FOX 2","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_cfa3a07f5ceb in signals