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/CBMioAFBVV95cUxPQ29JRGxUQkgtbnpXT3BCUjVWVkhyZGZYUzFpS21MWWF0T1IyZkZ0MGRXdld4am1saGg1NGZlLTE0NVJqWTNXU05BWHdKc19lQ2hkY3RBT1RLVFNfWlhlSmV4cnh1OWJXMG9sTUNzeDlNN203TWRsRzFkMGNUU3BOTEFBWDJmSTVYUG1zT2UxUGFmME1IT0R1UEtqSTVMX1BH?oc=5","as_of":"2026-04-17T05:58:32.223725+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/CBMioAFBVV95cUxPQ29JRGxUQkgtbnpXT3BCUjVWVkhyZGZYUzFpS21MWWF0T1IyZkZ0MGRXdld4am1saGg1NGZlLTE0NVJqWTNXU05BWHdKc19lQ2hkY3RBT1RLVFNfWlhlSmV4cnh1OWJXMG9sTUNzeDlNN203TWRsRzFkMGNUU3BOTEFBWDJmSTVYUG1zT2UxUGFmME1IT0R1UEtqSTVMX1BH?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_47f4061eb7a3398a","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-17T11:12:05.247348+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxPQ29JRGxUQkgtbnpXT3BCUjVWVkhyZGZYUzFpS21MWWF0T1IyZkZ0MGRXdld4am1saGg1NGZlLTE0NVJqWTNXU05BWHdKc19lQ2hkY3RBT1RLVFNfWlhlSmV4cnh1OWJXMG9sTUNzeDlNN203TWRsRzFkMGNUU3BOTEFBWDJmSTVYUG1zT2UxUGFmME1IT0R1UEtqSTVMX1BH?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"latimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxPQ29JRGxUQkgtbnpXT3BCUjVWVkhyZGZYUzFpS21MWWF0T1IyZkZ0MGRXdld4am1saGg1NGZlLTE0NVJqWTNXU05BWHdKc19lQ2hkY3RBT1RLVFNfWlhlSmV4cnh1OWJXMG9sTUNzeDlNN203TWRsRzFkMGNUU3BOTEFBWDJmSTVYUG1zT2UxUGFmME1IT0R1UEtqSTVMX1BH?oc=5","source_event_id":"evt_7fa57b4a92ce","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"5b865a6ffa969d7a","published_at":"2026-04-17T01:21:00+00:00","publisher_domain":"latimes.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: Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration - Los Angeles Times","Source summary: Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration Los Angeles Times Dodgers fan awarded $11.8 million by jury after partial blinding by LAPD during World Series celebration Yahoo Sports Trial of LAPD officers accused of shooting Dodgers fan in the eye goes to jury Courthouse News Big LAPD settlement LAist Man Alleging LAPD Injury at Dodgers Event Awarded $11.8 Million Bloomberg "],"numeric_claims":[],"primary_claim":"Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration - Los Angeles Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration Los Angeles Times Dodgers fan awarded $11.8 million by jury after partial blinding by LAPD during World Series celebration Yahoo Sports Trial of LAPD officers accused of shooting Dodgers fan in the eye goes to jury Courthouse News Big LAPD settlement LAist Man Alleging LAPD Injury at Dodgers Event Awarded $11.","topics":["news headline"]},"source":"Los Angeles Times","source_domain":"latimes.com","source_url":"https://www.latimes.com","summary":"Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration Los Angeles Times Dodgers fan awarded $11.8 million by jury after partial blinding by LAPD during World Series celebration Yahoo Sports Trial of LAPD officers accused of shooting Dodgers fan in the eye goes to jury Courthouse News Big LAPD settlement LAist Man Alleging LAPD Injury at Dodgers Event Awarded $11.8 Million Bloomberg Law News","title":"Jury awards $11.8 million to Dodgers fan blinded by LAPD during World Series celebration - Los Angeles 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_9f27cd6eab84 in signals