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/CBMihAFBVV95cUxQZkxBZUliWlpRUkdfNS1MdVE4LU42QlE5S0JUdERyR1VDUjFxVnRoVXNHMDZPNkhjcXNLZl9LdS1FaGREaFRsQktORlpwTkFvVHRLX0xHLXNaaG9NZTcyTjdoWEZESnVwOHlHX0dXU2VLQ0tkU2lSOEtxLUg0YUFvVy1USXk?oc=5","as_of":"2026-04-07T23:23:39.265915+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/CBMihAFBVV95cUxQZkxBZUliWlpRUkdfNS1MdVE4LU42QlE5S0JUdERyR1VDUjFxVnRoVXNHMDZPNkhjcXNLZl9LdS1FaGREaFRsQktORlpwTkFvVHRLX0xHLXNaaG9NZTcyTjdoWEZESnVwOHlHX0dXU2VLQ0tkU2lSOEtxLUg0YUFvVy1USXk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6a7691711a72ec41","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-08T00:36:43.605507+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQZkxBZUliWlpRUkdfNS1MdVE4LU42QlE5S0JUdERyR1VDUjFxVnRoVXNHMDZPNkhjcXNLZl9LdS1FaGREaFRsQktORlpwTkFvVHRLX0xHLXNaaG9NZTcyTjdoWEZESnVwOHlHX0dXU2VLQ0tkU2lSOEtxLUg0YUFvVy1USXk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQZkxBZUliWlpRUkdfNS1MdVE4LU42QlE5S0JUdERyR1VDUjFxVnRoVXNHMDZPNkhjcXNLZl9LdS1FaGREaFRsQktORlpwTkFvVHRLX0xHLXNaaG9NZTcyTjdoWEZESnVwOHlHX0dXU2VLQ0tkU2lSOEtxLUg0YUFvVy1USXk?oc=5","source_event_id":"evt_8d8408dcaf01","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9528c37ed7bc9344","published_at":"2026-04-07T15:28:47+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Financial Times","relevance":"source of the report","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Which specific state/government is involved is not stated in the provided text.","What the \u201cgamble\u201d entails (e.g., funding, regulation, platform, contracts) is not described.","No details are provided on affected markets, counterparties, or expected impact direction beyond the headline framing.","No near-term catalyst timing (dates/events) is included in the provided text.","The article body content is not available in the provided text (only page styling/HTML fragments), limiting extraction to the headline/summary only."],"key_facts":["Headline states: \u201cThe big state gamble on prediction markets\u201d (Financial Times)."],"numeric_claims":[],"primary_claim":"A state is making a major move (\u201cbig state gamble\u201d) related to prediction markets, as reported by the Financial Times.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"Financial Times reports on a \u201cbig state gamble\u201d involving prediction markets. The provided text does not include further details on which state, the mechanism, or timing.","topics":["prediction markets","state involvement","gamble"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"The big state gamble on prediction markets Financial Times","title":"The big state gamble on prediction markets - Financial Times","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_0207a51499c6 in signals