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/CBMiYkFVX3lxTE45ZExlNkg0aG5RTVN6QlBFVkR1aGloWUhZckhGMzVLTVhkNUZTWi16enNUNHgxNVVsSmt0eVNMR3VLeExIRjZzYlJzOVVvUDNtNnRESDE3TGlIVXRGMUtxSkdB?oc=5","as_of":"2026-04-07T23:39:52.265648+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiYkFVX3lxTE45ZExlNkg0aG5RTVN6QlBFVkR1aGloWUhZckhGMzVLTVhkNUZTWi16enNUNHgxNVVsSmt0eVNMR3VLeExIRjZzYlJzOVVvUDNtNnRESDE3TGlIVXRGMUtxSkdB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4464d8d6011d0e6b","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:38:42.775074+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiYkFVX3lxTE45ZExlNkg0aG5RTVN6QlBFVkR1aGloWUhZckhGMzVLTVhkNUZTWi16enNUNHgxNVVsSmt0eVNMR3VLeExIRjZzYlJzOVVvUDNtNnRESDE3TGlIVXRGMUtxSkdB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiYkFVX3lxTE45ZExlNkg0aG5RTVN6QlBFVkR1aGloWUhZckhGMzVLTVhkNUZTWi16enNUNHgxNVVsSmt0eVNMR3VLeExIRjZzYlJzOVVvUDNtNnRESDE3TGlIVXRGMUtxSkdB?oc=5","source_event_id":"evt_e532d8901229","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ee363a117848f3fe","published_at":"2026-04-07T21:05:12+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["2025","2026"],"entities":[{"asset_class":"sports_person","name":"Rory McIlroy","relevance":"high","symbol":"","type":"person"},{"asset_class":"sports_event","name":"Masters Tournament (Augusta National)","relevance":"high","symbol":"","type":"event"},{"asset_class":"sports_award","name":"Green Jacket","relevance":"medium","symbol":"","type":"award"},{"asset_class":"media","name":"BBC","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so detailed supporting statements (e.g., exact quotes like \u201cmuch more relaxed\u201d) cannot be verified from the cleaned text.","No specific tournament dates, odds, or performance metrics are included in the provided content.","Whether McIlroy\u2019s 2025 win is explicitly stated as the basis for \u201cdefending champion\u201d is not directly verifiable from the provided cleaned article text."],"key_facts":["The signal is a BBC headline about the 2026 Masters and Rory McIlroy\u2019s potential to win back-to-back Green Jackets.","The framing indicates Rory McIlroy is the defending Masters champion going into 2026.","The headline\u2019s question implies a storyline of attempting consecutive Masters wins (back-to-back Green Jackets)."],"numeric_claims":[],"primary_claim":"Rory McIlroy is the defending champion at the 2026 Masters and BBC asks whether he can win back-to-back Green Jackets.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"BBC previews the 2026 Masters and frames Rory McIlroy\u2019s bid to win back-to-back Green Jackets as a chance to add to his Augusta history. The near-term catalyst is the upcoming 2026 Masters tournament, where he is positioned as the defending champion.","topics":["golf","Masters Tournament","Rory McIlroy","Augusta National","Green Jacket","sports preview"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Masters 2026: Can Rory McIlroy create more Augusta history by winning back-to-back Green Jackets BBC Rory McIlroy 'much more relaxed' ahead of Masters after '25 win ESPN Grand slam once his 'destination,' defending Masters champion Rory McIlroy returns hungry for much more CBS Sports Rory McIlroy tells us his 5 best shots from the 2025 Masters The New York Times Masters 2026: Rory McIlroy\u2019s full-circle moment, 364 days in the making sports.yahoo.com","title":"Masters 2026: Can Rory McIlroy create more Augusta history by winning back-to-back Green Jackets - BBC","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_2ff90ebf6c85 in signals