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/CBMikgFBVV95cUxPYU1JNlNMU0plZGVXUTJIbGZ5TFlvSEd0ck13MzlwRkFIOXhpRFdoU3pmTTNjRjBiMHE3ZEc3akg5U2l4eUptMHdHNERYY1h1cU1KVlhXTjJJTHY1S3pScmc4eWZWTUMtZjNBaWVFVFVISXFuVzBocjZybFNuQkRMTHBOcDhZYVF5aDZLM2Ztd3I4UQ?oc=5","as_of":"2026-04-10T04:47:24.727679+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/CBMikgFBVV95cUxPYU1JNlNMU0plZGVXUTJIbGZ5TFlvSEd0ck13MzlwRkFIOXhpRFdoU3pmTTNjRjBiMHE3ZEc3akg5U2l4eUptMHdHNERYY1h1cU1KVlhXTjJJTHY1S3pScmc4eWZWTUMtZjNBaWVFVFVISXFuVzBocjZybFNuQkRMTHBOcDhZYVF5aDZLM2Ztd3I4UQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7368b920ba01bea1","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-10T04:48:05.299289+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPYU1JNlNMU0plZGVXUTJIbGZ5TFlvSEd0ck13MzlwRkFIOXhpRFdoU3pmTTNjRjBiMHE3ZEc3akg5U2l4eUptMHdHNERYY1h1cU1KVlhXTjJJTHY1S3pScmc4eWZWTUMtZjNBaWVFVFVISXFuVzBocjZybFNuQkRMTHBOcDhZYVF5aDZLM2Ztd3I4UQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"rollingstone.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPYU1JNlNMU0plZGVXUTJIbGZ5TFlvSEd0ck13MzlwRkFIOXhpRFdoU3pmTTNjRjBiMHE3ZEc3akg5U2l4eUptMHdHNERYY1h1cU1KVlhXTjJJTHY1S3pScmc4eWZWTUMtZjNBaWVFVFVISXFuVzBocjZybFNuQkRMTHBOcDhZYVF5aDZLM2Ztd3I4UQ?oc=5","source_event_id":"evt_5a958cb0cdf8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"20e7e52658f20cf8","published_at":"2026-04-09T22:06:21+00:00","publisher_domain":"rollingstone.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity/none","name":"Afrika Bambaataa","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"media","name":"Rolling Stone","relevance":"source of headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only CSS/HTML styling and does not include the actual obituary content; therefore, details beyond the headline and the provided source summary cannot be verified from the article text.","Exact date/time of death is not present in the provided text.","Whether the age discrepancy (68 vs 67) is due to reporting differences or birthdate timing is not explained in the provided text.","No specific cause of death is included in the provided text."],"key_facts":["Rolling Stone headline states: \u201cHip-Hop Pioneer Afrika Bambaataa Dead at 68.\u201d","The provided source summary includes additional outlet snippets: \u201cHip-hop pioneer accused of sexual abuse dead at 67\u201d (BBC) and \u201cdies aged 67\u201d (The New York Times, Yahoo, The Guardian).","The provided source summary characterizes Afrika Bambaataa as the \u201cGodfather of Hip-Hop\u201d (per Rolling Stone snippet in the source summary)."],"numeric_claims":[{"label":"age_at_death_rolling_stone","value":"68"},{"label":"age_at_death_other_outlets","value":"67"}],"primary_claim":"Afrika Bambaataa has died (reported as age 68 by Rolling Stone; age 67 by other referenced outlets).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Rolling Stone reports hip-hop pioneer Afrika Bambaataa has died at age 68. Other referenced outlets in the provided source summary also report his death at age 67 and describe him as a major figure in hip-hop.","topics":["death","hip-hop","music history","obituary"]},"source":"Rolling Stone","source_domain":"rollingstone.com","source_url":"https://www.rollingstone.com","summary":"Hip-Hop Pioneer Afrika Bambaataa Dead at 68 Rolling Stone Afrika Bambaataa, Often Called the \u2018Godfather of Hip-Hop,\u2019 Is Dead The New York Times Hip-hop pioneer, Afrika Bambaataa, dies aged 67 BBC Hip-hop pioneer accused of sexual abuse dead at 67 Yahoo Afrika Bambaataa, hip-hop pioneer, dies aged 67 The Guardian","title":"Hip-Hop Pioneer Afrika Bambaataa Dead at 68 - Rolling Stone","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_4ebc06f28633 in signals