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/CBMixAFBVV95cUxPTlNndkFvNGFGR0JrQks1UFFfbXgwYnJiMUlSOVJRSUh6dFlVOU83SVlQTVppdml3U3ZjeXNkczNQS1dNWmFnM1g2MlhFM0tfMUhRMUV2c053c0x5cjhWVFhtMkROMkJreDJ0ME1PVGxhS19tSF80V3JlZk12RFljZ3pTY2ZqbC1BY3h4RVIzMDVRWTBLRko1QmgzcEljLWF6UGltelVtV0p5M1BsLWR1ZGxKVEY5Z3h6QzVaUEZuZEZpQVly?oc=5","as_of":"2026-04-09T03:57:12.021161+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/CBMixAFBVV95cUxPTlNndkFvNGFGR0JrQks1UFFfbXgwYnJiMUlSOVJRSUh6dFlVOU83SVlQTVppdml3U3ZjeXNkczNQS1dNWmFnM1g2MlhFM0tfMUhRMUV2c053c0x5cjhWVFhtMkROMkJreDJ0ME1PVGxhS19tSF80V3JlZk12RFljZ3pTY2ZqbC1BY3h4RVIzMDVRWTBLRko1QmgzcEljLWF6UGltelVtV0p5M1BsLWR1ZGxKVEY5Z3h6QzVaUEZuZEZpQVly?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1d829eed867e6d46","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-09T22:35:57.485601+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxPTlNndkFvNGFGR0JrQks1UFFfbXgwYnJiMUlSOVJRSUh6dFlVOU83SVlQTVppdml3U3ZjeXNkczNQS1dNWmFnM1g2MlhFM0tfMUhRMUV2c053c0x5cjhWVFhtMkROMkJreDJ0ME1PVGxhS19tSF80V3JlZk12RFljZ3pTY2ZqbC1BY3h4RVIzMDVRWTBLRko1QmgzcEljLWF6UGltelVtV0p5M1BsLWR1ZGxKVEY5Z3h6QzVaUEZuZEZpQVly?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mmafighting.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxPTlNndkFvNGFGR0JrQks1UFFfbXgwYnJiMUlSOVJRSUh6dFlVOU83SVlQTVppdml3U3ZjeXNkczNQS1dNWmFnM1g2MlhFM0tfMUhRMUV2c053c0x5cjhWVFhtMkROMkJreDJ0ME1PVGxhS19tSF80V3JlZk12RFljZ3pTY2ZqbC1BY3h4RVIzMDVRWTBLRko1QmgzcEljLWF6UGltelVtV0p5M1BsLWR1ZGxKVEY5Z3h6QzVaUEZuZEZpQVly?oc=5","source_event_id":"evt_9e3025a95e00","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b937caefee73cd8e","published_at":"2026-04-08T23:00:00+00:00","publisher_domain":"mmafighting.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Dana White","relevance":"primary source of the quote","symbol":"","type":"person"},{"asset_class":"sports_event","name":"UFC White House card","relevance":"event affected by the weather concern","symbol":"","type":"event"},{"asset_class":"","name":"MMA Fighting","relevance":"source of the headline and summary","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The specific weather problem Dana White referenced is not included in the provided headline/summary text.","The date, location, and timing of the UFC White House card are not provided.","The article\u2019s details on how the weather could affect the event (e.g., delays, cancellations, fighter safety) are not included.","No direct quote text beyond the phrase \u2018screw us\u2019 is provided."],"key_facts":["The headline states Dana White revealed the only weather problem that could \u2018screw us\u2019 at the UFC White House card.","The provided source summary repeats the same claim at a high level.","No specific weather problem is named in the provided text."],"numeric_claims":[],"primary_claim":"Dana White said the only weather problem that could \u2018screw us\u2019 at the UFC White House card is a particular weather concern (unspecified in the provided text).","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"MMA Fighting reports that Dana White identified a specific weather issue as the only potential problem that could disrupt the UFC White House card.","topics":["UFC","Dana White","weather","event operations","sports event risk"]},"source":"MMA Fighting","source_domain":"mmafighting.com","source_url":"https://www.mmafighting.com","summary":"Dana White reveals the only weather problem that could \u2018screw us\u2019 at UFC White House card MMA Fighting View Full Coverage on Google News","title":"Dana White reveals the only weather problem that could \u2018screw us\u2019 at UFC White House card - MMA Fighting","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_a801c13275fc in signals