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/CBMiiwFBVV95cUxQSlRvNEJ6aXVGZ0VKakVsWG9PM21Gb1VTYVp4UThCYWtGTmJhMTBUS0VidlZNWVVmaXM3ODBxejIxMjR5RmxMQ0VLMEJubzlPdEtqbUZoMG92aEtSNjNJbTdPUW95RlBHRjVqa3ptc2llZEVLZDlBdzkzS3pGVHE2bkF1ZkZ0ckJhcHFJ0gGQAUFVX3lxTE9rRGcyUUxoTDc2LUNFcEthS3NqN3BSQzBTdjc2VVAyVWtYZENBWnJyRWE5MXptaWVMWUdQNWVOcmFIUUNFd2F5SGt3cnpqVHZlb0tEZWpiaWdVYVhNQXpFNXMzMDZ0dm1Fc2NpazRrNWxtcXRVdWFudFhpcGZ1VF9rdTlXdkFkc2JsMGVXNG9CWA?oc=5","as_of":"2026-04-11T10:31:21.688984+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/CBMiiwFBVV95cUxQSlRvNEJ6aXVGZ0VKakVsWG9PM21Gb1VTYVp4UThCYWtGTmJhMTBUS0VidlZNWVVmaXM3ODBxejIxMjR5RmxMQ0VLMEJubzlPdEtqbUZoMG92aEtSNjNJbTdPUW95RlBHRjVqa3ptc2llZEVLZDlBdzkzS3pGVHE2bkF1ZkZ0ckJhcHFJ0gGQAUFVX3lxTE9rRGcyUUxoTDc2LUNFcEthS3NqN3BSQzBTdjc2VVAyVWtYZENBWnJyRWE5MXptaWVMWUdQNWVOcmFIUUNFd2F5SGt3cnpqVHZlb0tEZWpiaWdVYVhNQXpFNXMzMDZ0dm1Fc2NpazRrNWxtcXRVdWFudFhpcGZ1VF9rdTlXdkFkc2JsMGVXNG9CWA?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f476b1a27775b92d","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-11T18:03:00.164742+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQSlRvNEJ6aXVGZ0VKakVsWG9PM21Gb1VTYVp4UThCYWtGTmJhMTBUS0VidlZNWVVmaXM3ODBxejIxMjR5RmxMQ0VLMEJubzlPdEtqbUZoMG92aEtSNjNJbTdPUW95RlBHRjVqa3ptc2llZEVLZDlBdzkzS3pGVHE2bkF1ZkZ0ckJhcHFJ0gGQAUFVX3lxTE9rRGcyUUxoTDc2LUNFcEthS3NqN3BSQzBTdjc2VVAyVWtYZENBWnJyRWE5MXptaWVMWUdQNWVOcmFIUUNFd2F5SGt3cnpqVHZlb0tEZWpiaWdVYVhNQXpFNXMzMDZ0dm1Fc2NpazRrNWxtcXRVdWFudFhpcGZ1VF9rdTlXdkFkc2JsMGVXNG9CWA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thehill.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQSlRvNEJ6aXVGZ0VKakVsWG9PM21Gb1VTYVp4UThCYWtGTmJhMTBUS0VidlZNWVVmaXM3ODBxejIxMjR5RmxMQ0VLMEJubzlPdEtqbUZoMG92aEtSNjNJbTdPUW95RlBHRjVqa3ptc2llZEVLZDlBdzkzS3pGVHE2bkF1ZkZ0ckJhcHFJ0gGQAUFVX3lxTE9rRGcyUUxoTDc2LUNFcEthS3NqN3BSQzBTdjc2VVAyVWtYZENBWnJyRWE5MXptaWVMWUdQNWVOcmFIUUNFd2F5SGt3cnpqVHZlb0tEZWpiaWdVYVhNQXpFNXMzMDZ0dm1Fc2NpazRrNWxtcXRVdWFudFhpcGZ1VF9rdTlXdkFkc2JsMGVXNG9CWA?oc=5","source_event_id":"evt_b6a27854a974","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"6db9e07606a56827","published_at":"2026-04-10T21:33:00+00:00","publisher_domain":"thehill.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Hill","relevance":"source of the headline/signal","symbol":"","type":"publisher"},{"asset_class":"","name":"Prediction markets","relevance":"subject of the headline","symbol":"","type":"market/sector"},{"asset_class":"","name":"Washington, DC","relevance":"focus of the messaging","symbol":"","type":"location"}],"event_type":"other","information_gaps":["No article body text is provided, so the specific content of the \"DC messaging\" is unknown.","No entities (companies, tickers, or specific prediction markets) are named.","No timing details (when the ramp-up occurred or near-term catalysts) are provided.","No stated market impact, direction, or measurable outcomes are included in the provided text."],"key_facts":["Headline states: \"Prediction markets ramp up DC messaging\".","Source summary repeats the same statement.","No additional details are provided in the provided text."],"numeric_claims":[],"primary_claim":"Prediction markets are ramping up DC messaging, according to The Hill.","relevance_score":0.25,"sentiment":"neutral","source_quality":"unknown","summary":"The Hill reports that prediction markets are increasing their messaging focused on Washington, DC.","topics":["prediction markets","Washington, DC messaging","media/political commentary"]},"source":"The Hill","source_domain":"thehill.com","source_url":"https://thehill.com","summary":"Prediction markets ramp up DC messaging The Hill","title":"Prediction markets ramp up DC messaging - The Hill","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_3f914b1ceb44 in signals