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/CBMihAFBVV95cUxOZUFQaUppSElkZzRPVURLRDV3OGFWUDJYYlVpdkJlVmlkZzZnRVhvQ0JCNkZidzdsdmxQWXJZS1NzZXJsTEN0bjhQQ3EtdEI4MWFiRnF4TzZzMjJBcmFZQ2ZRYU1EMHlTZXo5S01fWW41OWFqVkF4ZmNzeEVtcHRpcXJMTm8?oc=5","as_of":"2026-04-18T23:11:10.876061+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOZUFQaUppSElkZzRPVURLRDV3OGFWUDJYYlVpdkJlVmlkZzZnRVhvQ0JCNkZidzdsdmxQWXJZS1NzZXJsTEN0bjhQQ3EtdEI4MWFiRnF4TzZzMjJBcmFZQ2ZRYU1EMHlTZXo5S01fWW41OWFqVkF4ZmNzeEVtcHRpcXJMTm8?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_54947319c8effaaa","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T23:11:18.939652+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOZUFQaUppSElkZzRPVURLRDV3OGFWUDJYYlVpdkJlVmlkZzZnRVhvQ0JCNkZidzdsdmxQWXJZS1NzZXJsTEN0bjhQQ3EtdEI4MWFiRnF4TzZzMjJBcmFZQ2ZRYU1EMHlTZXo5S01fWW41OWFqVkF4ZmNzeEVtcHRpcXJMTm8?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOZUFQaUppSElkZzRPVURLRDV3OGFWUDJYYlVpdkJlVmlkZzZnRVhvQ0JCNkZidzdsdmxQWXJZS1NzZXJsTEN0bjhQQ3EtdEI4MWFiRnF4TzZzMjJBcmFZQ2ZRYU1EMHlTZXo5S01fWW41OWFqVkF4ZmNzeEVtcHRpcXJMTm8?oc=5","source_event_id":"evt_9f14a1672ee6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ff0077af52b5a8e1","published_at":"2026-04-18T18:35:00+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home - The New York Times","Source summary: After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home The New York Times An abandoned car, a photo trail and a missing girl: What led up to the arrest of singer d4vd on suspicion of murder? CNN Celeste Rivas' father responds to D4vd arrest in connection to his daughter's disturbing murder New York Post Rapper Arrested in Sandra Bullock\u2019s Former Home, Charged With Murder in High-Profile Case Yahoo \u2018Celest"],"numeric_claims":[],"primary_claim":"After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home The New York Times An abandoned car, a photo trail and a missing girl: What led up to the arrest of singer d4vd on suspicion of murder? CNN Celeste Rivas' father responds to D4vd arrest in connection to his daughter's disturbing murder New York Post Rapper Arrested in Sandra Bullock\u2019s Former Home, Charged With Murder in High-Profil","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home The New York Times An abandoned car, a photo trail and a missing girl: What led up to the arrest of singer d4vd on suspicion of murder? CNN Celeste Rivas' father responds to D4vd arrest in connection to his daughter's disturbing murder New York Post Rapper Arrested in Sandra Bullock\u2019s Former Home, Charged With Murder in High-Profile Case Yahoo \u2018Celeste is a liar\u2019 message written in sky above Coachella KTLA","title":"After D4vd\u2019s Arrest, Many Still Mourn the Girl Who Never Came Home - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_b23edb6f0a60 in signals