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/CBMinAFBVV95cUxPUE1KOEVtUzk3Tk9yWnNsT0Nud19Qa1lXV29PNVVlTjk1eXp0NFYwc09nS0ZwRHlDYTJLZlBIM1RzRHVqQm01VnBnQXJjUmJuRkl0Z3pYUVRvMHlPRDJVOGlfb2JFcXl0RkRldVNsek84RXlTd095Y2piUHBtTl9XX1E5NWJ5b1hRMmNOemJNb3M1cjdENnBwZDNCeVY?oc=5","as_of":"2026-04-09T09:54:21.363261+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/CBMinAFBVV95cUxPUE1KOEVtUzk3Tk9yWnNsT0Nud19Qa1lXV29PNVVlTjk1eXp0NFYwc09nS0ZwRHlDYTJLZlBIM1RzRHVqQm01VnBnQXJjUmJuRkl0Z3pYUVRvMHlPRDJVOGlfb2JFcXl0RkRldVNsek84RXlTd095Y2piUHBtTl9XX1E5NWJ5b1hRMmNOemJNb3M1cjdENnBwZDNCeVY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_33d601cd1e9db841","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-09T23:02:52.398268+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPUE1KOEVtUzk3Tk9yWnNsT0Nud19Qa1lXV29PNVVlTjk1eXp0NFYwc09nS0ZwRHlDYTJLZlBIM1RzRHVqQm01VnBnQXJjUmJuRkl0Z3pYUVRvMHlPRDJVOGlfb2JFcXl0RkRldVNsek84RXlTd095Y2piUHBtTl9XX1E5NWJ5b1hRMmNOemJNb3M1cjdENnBwZDNCeVY?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/CBMinAFBVV95cUxPUE1KOEVtUzk3Tk9yWnNsT0Nud19Qa1lXV29PNVVlTjk1eXp0NFYwc09nS0ZwRHlDYTJLZlBIM1RzRHVqQm01VnBnQXJjUmJuRkl0Z3pYUVRvMHlPRDJVOGlfb2JFcXl0RkRldVNsek84RXlTd095Y2piUHBtTl9XX1E5NWJ5b1hRMmNOemJNb3M1cjdENnBwZDNCeVY?oc=5","source_event_id":"evt_7da1298486ce","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fff942407b32afb2","published_at":"2026-04-09T09:00:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"media","name":"The Guardian","relevance":"primary source of the headline","symbol":"","type":"publisher"},{"asset_class":"media_awards","name":"World Press Photo 2026","relevance":"subject of the winners list/gallery","symbol":"","type":"award_program"},{"asset_class":"geopolitical_event","name":"Bondi terror attack","relevance":"specific recognized image mentioned in the provided source summary","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only CSS/HTML styling and no readable article content, so specific winner names, categories, photographers, and image descriptions cannot be extracted.","It is unclear from the provided summary whether the Bondi terror attack image is a confirmed winner or only part of a shortlist; the wording suggests recognition but not the exact status.","No concrete timing beyond \u201c2026\u201d is available for when the winners were announced or when the gallery was published."],"key_facts":["The Guardian published an article/gallery titled along the lines of \u201cWorld Press Photo 2026 winners \u2013 in pictures.\u201d","The provided source summary indicates that a Bondi terror attack image was recognized among the 2026 World Press Photo winners/shortlist (exact category and whether winner vs shortlist is not fully specified in the provided text).","The provided source summary also mentions an \u201cobvious gear trend\u201d in the 2026 World Press Photo awards (details not present in the cleaned article text)."],"numeric_claims":[],"primary_claim":"The Guardian\u2019s gallery presents the 2026 World Press Photo winners (in pictures).","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The Guardian published a photo gallery highlighting the winners of the 2026 World Press Photo contest. The coverage emphasizes notable award-winning images, including recognition of a Bondi terror attack photograph.","topics":["photojournalism","awards","World Press Photo","gallery coverage","terror attack imagery"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"World Press Photo 2026 winners \u2013 in pictures The Guardian World Press Photo 2026 winners reveal unforgettable moments USA Today 17 compelling winners from the 2026 World Press Photo Contest Popular Science The 2026 World Press Photo Awards Have an Obvious Gear Trend The Phoblographer Harrowing Bondi terror attack image recognised in 2026 World Press Photo winners shortlist Australian Photography magazine","title":"World Press Photo 2026 winners \u2013 in pictures - The Guardian","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_94e1fa894bca in signals