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/CBMiWkFVX3lxTFBKRW0wQTRCRUROTFZoUlBheHBvYUR4OHg5Qy14bUx6UnU0UUdjZzFyOWhPYUtSZWdqTFJZZWpmYTZJNVpiV3JGZmNhWm9KU0lYTFI5YzJsQTN3dw?oc=5","as_of":"2026-04-10T03:30:53.175944+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/CBMiWkFVX3lxTFBKRW0wQTRCRUROTFZoUlBheHBvYUR4OHg5Qy14bUx6UnU0UUdjZzFyOWhPYUtSZWdqTFJZZWpmYTZJNVpiV3JGZmNhWm9KU0lYTFI5YzJsQTN3dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_625cebd69ee0eb76","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-10T03:39:20.919581+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBKRW0wQTRCRUROTFZoUlBheHBvYUR4OHg5Qy14bUx6UnU0UUdjZzFyOWhPYUtSZWdqTFJZZWpmYTZJNVpiV3JGZmNhWm9KU0lYTFI5YzJsQTN3dw?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/CBMiWkFVX3lxTFBKRW0wQTRCRUROTFZoUlBheHBvYUR4OHg5Qy14bUx6UnU0UUdjZzFyOWhPYUtSZWdqTFJZZWpmYTZJNVpiV3JGZmNhWm9KU0lYTFI5YzJsQTN3dw?oc=5","source_event_id":"evt_842d47334d65","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a5680ee0f641ebea","published_at":"2026-04-10T00:50:21+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Afrika Bambaataa","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"","name":"BBC","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"","name":"Universal Zulu Nation","relevance":"affiliation/role attributed to subject","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no readable body content beyond page styling; details such as date/time and location of death are not present in the provided text.","No information is provided here about cause of death.","Other outlets mention allegations of sexual abuse in the source summary, but the provided text does not specify details or timing of those allegations."],"key_facts":["BBC reports that hip-hop pioneer Afrika Bambaataa has died.","BBC headline states he was aged 67.","The provided source summary describes him as the \u201cGodfather of Hip-Hop.\u201d","The provided source summary describes him as the founder of Universal Zulu Nation."],"numeric_claims":[{"label":"age_at_death","value":"67"}],"primary_claim":"Afrika Bambaataa died at age 67.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"Hip-hop pioneer Afrika Bambaataa has died at age 67, according to BBC. He is widely described as the \u201cGodfather of Hip-Hop\u201d and founder of the Universal Zulu Nation.","topics":["death","hip-hop","music history","Universal Zulu Nation"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Hip-hop pioneer, Afrika Bambaataa, dies aged 67 BBC Afrika Bambaataa, Often Called the \u2018Godfather of Hip-Hop,\u2019 Is Dead The New York Times Afrika Bambaataa, hip-hop pioneer and founder of Universal Zulu Nation, has died Yahoo Hip-hop pioneer accused of sexual abuse dead at 67 AL.com Afrika Bambaataa, hip-hop pioneer, dies aged 67 The Guardian","title":"Hip-hop pioneer, Afrika Bambaataa, dies aged 67 - BBC","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_be61690d0b6c in signals