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/CBMigAFBVV95cUxQcDE5MmZrT25ZbEo3TzVXbFJMSnNqNmVGU2xkYy1zajBGQW1DZldBU0cwWjc0b3VxVlVCYWYweGlFelctaXJWUkJCNlBuYUZleHMteE8teld6bXhScWRSeFhKSE5qT0FqQWFXZllNajFJMHlQWTE3ZlNSOGRPSU5ubg?oc=5","as_of":"2026-04-08T01:58:44.254535+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/CBMigAFBVV95cUxQcDE5MmZrT25ZbEo3TzVXbFJMSnNqNmVGU2xkYy1zajBGQW1DZldBU0cwWjc0b3VxVlVCYWYweGlFelctaXJWUkJCNlBuYUZleHMteE8teld6bXhScWRSeFhKSE5qT0FqQWFXZllNajFJMHlQWTE3ZlNSOGRPSU5ubg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2fb3ff03627ba4e6","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-08T01:59:38.758473+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxQcDE5MmZrT25ZbEo3TzVXbFJMSnNqNmVGU2xkYy1zajBGQW1DZldBU0cwWjc0b3VxVlVCYWYweGlFelctaXJWUkJCNlBuYUZleHMteE8teld6bXhScWRSeFhKSE5qT0FqQWFXZllNajFJMHlQWTE3ZlNSOGRPSU5ubg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"kmbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxQcDE5MmZrT25ZbEo3TzVXbFJMSnNqNmVGU2xkYy1zajBGQW1DZldBU0cwWjc0b3VxVlVCYWYweGlFelctaXJWUkJCNlBuYUZleHMteE8teld6bXhScWRSeFhKSE5qT0FqQWFXZllNajFJMHlQWTE3ZlNSOGRPSU5ubg?oc=5","source_event_id":"evt_cdc01f522896","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9c4c0aa5f640ad7e","published_at":"2026-04-07T22:33:00+00:00","publisher_domain":"kmbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["1963","today"],"entities":[{"asset_class":"municipal/government","name":"Kansas City","relevance":"primary subject of the earnings tax history","symbol":"","type":"city"},{"asset_class":"media","name":"KMBC","relevance":"publisher of the article","symbol":"","type":"news_publisher"}],"event_type":"other","information_gaps":["No details are provided in the supplied text about what changed in the earnings tax over time (rates, eligibility, exemptions, or legal milestones).","No information is provided about any current policy action, timing of implementation, or near-term impact on taxpayers or businesses.","The provided article text appears to be page styling/HTML content rather than the article body; only the headline/summary are available for extraction."],"key_facts":["The headline states the article covers the history behind Kansas City\u2019s earnings tax.","The coverage is described as spanning from 1963 to today."],"numeric_claims":[],"primary_claim":"The article discusses the history behind Kansas City\u2019s earnings tax spanning from 1963 to today.","relevance_score":0.28,"sentiment":"neutral","source_quality":"high","summary":"KMBC published a piece tracing the history of Kansas City\u2019s earnings tax from 1963 to the present.","topics":["earnings tax","local taxation","Kansas City","history of tax policy"]},"source":"KMBC","source_domain":"kmbc.com","source_url":"https://www.kmbc.com","summary":"From 1963 to today: The history behind Kansas City\u2019s earnings tax KMBC","title":"From 1963 to today: The history behind Kansas City\u2019s earnings tax - KMBC","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_7439a392e59b in signals