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/CBMipwFBVV95cUxQaUdKeHczSXdXS3dFQklGLWExdG5wRlQzSFJidGlDV0Noc0hZQmFvTXA0b2lJQ2x0c0sycjF4eUc1TXdpNV92M1pncnNKdWZyZDJ0V3JYVlpFWktYWGp6TWxXZXBEVWlGclBSRnp5R3EtRWN4alh4NW8wSTN4V1ctQ2JRZGxQQ1RFOHJ5d3VPZ1RNT1ktN2I0ME50SEJLMFhQcmdtSnZ4aw?oc=5","as_of":"2026-04-09T00:58:20.310984+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/CBMipwFBVV95cUxQaUdKeHczSXdXS3dFQklGLWExdG5wRlQzSFJidGlDV0Noc0hZQmFvTXA0b2lJQ2x0c0sycjF4eUc1TXdpNV92M1pncnNKdWZyZDJ0V3JYVlpFWktYWGp6TWxXZXBEVWlGclBSRnp5R3EtRWN4alh4NW8wSTN4V1ctQ2JRZGxQQ1RFOHJ5d3VPZ1RNT1ktN2I0ME50SEJLMFhQcmdtSnZ4aw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a48712d1951f9814","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:21:27.813508+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQaUdKeHczSXdXS3dFQklGLWExdG5wRlQzSFJidGlDV0Noc0hZQmFvTXA0b2lJQ2x0c0sycjF4eUc1TXdpNV92M1pncnNKdWZyZDJ0V3JYVlpFWktYWGp6TWxXZXBEVWlGclBSRnp5R3EtRWN4alh4NW8wSTN4V1ctQ2JRZGxQQ1RFOHJ5d3VPZ1RNT1ktN2I0ME50SEJLMFhQcmdtSnZ4aw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"golfchannel.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQaUdKeHczSXdXS3dFQklGLWExdG5wRlQzSFJidGlDV0Noc0hZQmFvTXA0b2lJQ2x0c0sycjF4eUc1TXdpNV92M1pncnNKdWZyZDJ0V3JYVlpFWktYWGp6TWxXZXBEVWlGclBSRnp5R3EtRWN4alh4NW8wSTN4V1ctQ2JRZGxQQ1RFOHJ5d3VPZ1RNT1ktN2I0ME50SEJLMFhQcmdtSnZ4aw?oc=5","source_event_id":"evt_8bcf1f93d2d2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e163dece86cec5dc","published_at":"2026-04-08T21:22:30+00:00","publisher_domain":"golfchannel.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"other","name":"Masters Par 3 Contest","relevance":"high","symbol":"","type":"event"},{"asset_class":"other","name":"Aaron Rai","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Golf Channel","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Augusta Chronicle","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"BBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"Yahoo Sports","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the actual narrative content, so the winner/ace details are only supported by the provided source summary, not by extracted article body text.","No specific number of aces, hole numbers, scores, or timing (e.g., when the contest occurred within 2026) are included in the provided text.","It is unclear whether all referenced publishers agree on the winner details beyond the mention of Aaron Rai in the source summary."],"key_facts":["The signal concerns coverage of the 2026 Masters Par 3 Contest.","The provided source summary indicates the winner was Aaron Rai.","The coverage includes highlights/best moments and mentions aces (holes-in-one).","Multiple publishers are referenced as producing recaps (Golf Channel, Augusta Chronicle, BBC, Yahoo Sports)."],"numeric_claims":[],"primary_claim":"The 2026 Masters Par 3 Contest recap highlights aces and identifies Aaron Rai as the winner (per the provided source summary).","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"Golf Channel and other outlets recap the 2026 Masters Par 3 Contest, highlighting best moments, aces, and the winner. The coverage specifically notes Aaron Rai as the winner in at least one recap.","topics":["golf","Masters","Par 3 Contest","tournament recap","aces","winner"]},"source":"Golf Channel","source_domain":"golfchannel.com","source_url":"https://www.golfchannel.com","summary":"Masters Par 3 Contest 2026: Best moments, highlights, aces and winner Golf Channel Masters Par 3 Contest: See aces, smile-worthy moments, first-time winner PGA Tour Masters Par 3 Contest: Unfortunately for Aaron Rai, he won Yahoo Sports 2026 Masters Par 3 Contest: Winner, aces and what the players said The Augusta Chronicle The Masters 2026: Family fun and holes in one - why par 3 contest crosses generations BBC","title":"Masters Par 3 Contest 2026: Best moments, highlights, aces and winner - Golf Channel","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_31b9d8e2a242 in signals