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/CBMiiwFBVV95cUxQaUlxWlZuZUZ5cEw3M1g3eDUxR0YxYV9WREFBR2t0RGFfdExURmxoSHNwZGlaOGRqWlotRDdfMkdEemoyYU9xc1JHQ056U0p3VXFYalFhVG8zUFhZUl9MQ015SnFNTEFsdTItdFZKd1RRVF9UQ2NYX0hhdEFFXzBGcDV1QS1fa2ZoNHpF?oc=5","as_of":"2026-04-19T13:31:32.388929+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/CBMiiwFBVV95cUxQaUlxWlZuZUZ5cEw3M1g3eDUxR0YxYV9WREFBR2t0RGFfdExURmxoSHNwZGlaOGRqWlotRDdfMkdEemoyYU9xc1JHQ056U0p3VXFYalFhVG8zUFhZUl9MQ015SnFNTEFsdTItdFZKd1RRVF9UQ2NYX0hhdEFFXzBGcDV1QS1fa2ZoNHpF?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_384a5376408aab80","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-19T13:54:52.799338+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQaUlxWlZuZUZ5cEw3M1g3eDUxR0YxYV9WREFBR2t0RGFfdExURmxoSHNwZGlaOGRqWlotRDdfMkdEemoyYU9xc1JHQ056U0p3VXFYalFhVG8zUFhZUl9MQ015SnFNTEFsdTItdFZKd1RRVF9UQ2NYX0hhdEFFXzBGcDV1QS1fa2ZoNHpF?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/CBMiiwFBVV95cUxQaUlxWlZuZUZ5cEw3M1g3eDUxR0YxYV9WREFBR2t0RGFfdExURmxoSHNwZGlaOGRqWlotRDdfMkdEemoyYU9xc1JHQ056U0p3VXFYalFhVG8zUFhZUl9MQ015SnFNTEFsdTItdFZKd1RRVF9UQ2NYX0hhdEFFXzBGcDV1QS1fa2ZoNHpF?oc=5","source_event_id":"evt_515d6993a62d","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"99e030460a5a1144","published_at":"2026-04-19T11:01:00+00:00","publisher_domain":"theguardian.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: \u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? - The Guardian","Source summary: \u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? The Guardian New details emerge about the arrest of singer D4vd in the killing of teenage girl Yahoo Details on investigation leading up to D4vd's arrest in death of Celeste Rivas Hernandez ABC7 Los Angeles After D4vd Arrest, Lake Elsinore Residents Mourn Celeste Rivas Hernandez The New York Times Sing"],"numeric_claims":[],"primary_claim":"\u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? - The Guardian","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"\u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? The Guardian New details emerge about the arrest of singer D4vd in the killing of teenage girl Yahoo Details on investigation leading up to D4vd's arrest in death of Celeste Rivas Hernandez ABC7 Los Angeles After D4vd Arrest, Lake Elsinore Residents Mourn Celeste Rivas Hernandez The","topics":["news headline"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"\u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? The Guardian New details emerge about the arrest of singer D4vd in the killing of teenage girl Yahoo Details on investigation leading up to D4vd's arrest in death of Celeste Rivas Hernandez ABC7 Los Angeles After D4vd Arrest, Lake Elsinore Residents Mourn Celeste Rivas Hernandez The New York Times Singer known for song \u2018Romantic Homicide\u2019 arrested after teen girl\u2019s remains found in his car NJ.com","title":"\u2018Beloved daughter, sister, cousin, friend\u2019: will D4vd\u2019s arrest for murder bring justice for Celeste Rivas Hernandez? - The Guardian","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_9f25e23e93ac in signals