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/CBMiwwFBVV95cUxPc3pvbVhCMm56ZVRlbVk1NjgyZEFTeHItR0VTYmRhNklZdXh6WjcwN2R0TUpBOUthM0NRcmg2SmdlNldNVkxxZTZEbVE5dlpuQkxyZGpYVGY1SHRUVXpmajhyNWpJTWc3S2JxWUt6eWs1blllbFotQjhieGVGRTByRXhDME9oMW13TTk2S3o2ZVVLb2hFTncwZEFYMVllczFCbmxOSktzR0ZDYlNOLWVhRHdxRnRuSlBYREpWa3JEM2dENHc?oc=5","as_of":"2026-04-08T00:10:40.818248+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/CBMiwwFBVV95cUxPc3pvbVhCMm56ZVRlbVk1NjgyZEFTeHItR0VTYmRhNklZdXh6WjcwN2R0TUpBOUthM0NRcmg2SmdlNldNVkxxZTZEbVE5dlpuQkxyZGpYVGY1SHRUVXpmajhyNWpJTWc3S2JxWUt6eWs1blllbFotQjhieGVGRTByRXhDME9oMW13TTk2S3o2ZVVLb2hFTncwZEFYMVllczFCbmxOSktzR0ZDYlNOLWVhRHdxRnRuSlBYREpWa3JEM2dENHc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b9a68f3e10ef346f","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:41:51.796296+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxPc3pvbVhCMm56ZVRlbVk1NjgyZEFTeHItR0VTYmRhNklZdXh6WjcwN2R0TUpBOUthM0NRcmg2SmdlNldNVkxxZTZEbVE5dlpuQkxyZGpYVGY1SHRUVXpmajhyNWpJTWc3S2JxWUt6eWs1blllbFotQjhieGVGRTByRXhDME9oMW13TTk2S3o2ZVVLb2hFTncwZEFYMVllczFCbmxOSktzR0ZDYlNOLWVhRHdxRnRuSlBYREpWa3JEM2dENHc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxPc3pvbVhCMm56ZVRlbVk1NjgyZEFTeHItR0VTYmRhNklZdXh6WjcwN2R0TUpBOUthM0NRcmg2SmdlNldNVkxxZTZEbVE5dlpuQkxyZGpYVGY1SHRUVXpmajhyNWpJTWc3S2JxWUt6eWs1blllbFotQjhieGVGRTByRXhDME9oMW13TTk2S3o2ZVVLb2hFTncwZEFYMVllczFCbmxOSktzR0ZDYlNOLWVhRHdxRnRuSlBYREpWa3JEM2dENHc?oc=5","source_event_id":"evt_2296214944f1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"377d29237d19df50","published_at":"2026-04-07T21:10:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2026 (implied by source summary: \u201cESPN Masters 2026\u201d)"],"entities":[{"asset_class":"sports_person","name":"Rory McIlroy","relevance":"primary","symbol":"","type":"person"},{"asset_class":"sports_event","name":"The Masters","relevance":"high","symbol":"","type":"event"},{"asset_class":"sports_venue","name":"Augusta National Golf Club","relevance":"high","symbol":"","type":"location"},{"asset_class":"media","name":"ESPN","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"BBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"CBS Sports","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text appears to contain only page styling/HTML and not the actual Guardian article content; only the headline and the provided source summary were usable.","No specific performance metrics, rankings, injury status, or schedule details are included in the provided text.","The exact date of the Masters and the exact year of the \u201c25 win\u201d referenced in the source summary are not fully verifiable from the provided content."],"key_facts":["The Guardian headline states Rory McIlroy is returning to the Masters/\u201cscene of Masters glory.\u201d","The headline includes McIlroy\u2019s quote: \u201cbig weight off my shoulders.\u201d","The provided source summary also characterizes him as \u201cmuch more relaxed\u201d ahead of the Masters.","The near-term timing referenced is ahead of the upcoming Masters (implied 2026 by the source summary)."],"numeric_claims":[],"primary_claim":"Rory McIlroy says he is \u201cmuch more relaxed\u201d and feels a \u201cbig weight off my shoulders\u201d as he returns to Augusta ahead of the Masters.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"Rory McIlroy is returning to Augusta National (site of the Masters) feeling more relaxed and describing a \u201cbig weight off my shoulders\u201d ahead of the 2026 Masters. The near-term catalyst is his preparation and performance in the upcoming Masters tournament.","topics":["golf","Masters Tournament","Rory McIlroy","Augusta National","player form/mental state","pre-tournament outlook"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Rory McIlroy returns to scene of Masters glory with \u2018big weight off my shoulders\u2019 | Andy Bull The Guardian Rory McIlroy 'much more relaxed' ahead of Masters after '25 win ESPN Masters 2026: Can Rory McIlroy create more Augusta history by winning back-to-back Green Jackets BBC 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","title":"Rory McIlroy returns to scene of Masters glory with \u2018big weight off my shoulders\u2019 | Andy Bull - The Guardian","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_13429f8eff33 in signals