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/CBMiuwFBVV95cUxPb1ZmVmlWZ2VNeEFETFFUelNXVV8zckxFX0llNFZNTjZJUk1WWVFGNUdvd1AzcklzR1AxUklnVkxnVms2MkN2U0ROcjNHNG1COWNyb01BOGtjNkdhUmRaNEZFelFzQjVaUkh2ZU1aQlpQVVNpN1FzZVZrRHJwRXBOaEZtbVhKZmM1NUhTNGpZN1NfOFZ5RV9JSUEzLURUQVhSMkIwUnJYbGtaRjNiMTg5Tm9ZeWZ6Q0tveFhr?oc=5","as_of":"2026-04-13T11:10:14.385911+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/CBMiuwFBVV95cUxPb1ZmVmlWZ2VNeEFETFFUelNXVV8zckxFX0llNFZNTjZJUk1WWVFGNUdvd1AzcklzR1AxUklnVkxnVms2MkN2U0ROcjNHNG1COWNyb01BOGtjNkdhUmRaNEZFelFzQjVaUkh2ZU1aQlpQVVNpN1FzZVZrRHJwRXBOaEZtbVhKZmM1NUhTNGpZN1NfOFZ5RV9JSUEzLURUQVhSMkIwUnJYbGtaRjNiMTg5Tm9ZeWZ6Q0tveFhr?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ecc4280b14cbdc95","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-13T13:22:07.813390+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxPb1ZmVmlWZ2VNeEFETFFUelNXVV8zckxFX0llNFZNTjZJUk1WWVFGNUdvd1AzcklzR1AxUklnVkxnVms2MkN2U0ROcjNHNG1COWNyb01BOGtjNkdhUmRaNEZFelFzQjVaUkh2ZU1aQlpQVVNpN1FzZVZrRHJwRXBOaEZtbVhKZmM1NUhTNGpZN1NfOFZ5RV9JSUEzLURUQVhSMkIwUnJYbGtaRjNiMTg5Tm9ZeWZ6Q0tveFhr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxPb1ZmVmlWZ2VNeEFETFFUelNXVV8zckxFX0llNFZNTjZJUk1WWVFGNUdvd1AzcklzR1AxUklnVkxnVms2MkN2U0ROcjNHNG1COWNyb01BOGtjNkdhUmRaNEZFelFzQjVaUkh2ZU1aQlpQVVNpN1FzZVZrRHJwRXBOaEZtbVhKZmM1NUhTNGpZN1NfOFZ5RV9JSUEzLURUQVhSMkIwUnJYbGtaRjNiMTg5Tm9ZeWZ6Q0tveFhr?oc=5","source_event_id":"evt_cb1d1e8504a0","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"71d489ee1230e9b1","published_at":"2026-04-13T04:18:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Eric Swalwell","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"","name":"California governor race","relevance":"context","symbol":"","type":"political_race"}],"event_type":"conflict","information_gaps":["No article text is provided, so the specific allegations, timing, and reasons for exit are not detailed.","No names of the rivals/candidates seeking Swalwell\u2019s supporters are provided in the supplied text.","No direct information is provided about any official findings, investigations, or legal outcomes."],"key_facts":["The headline states Swalwell exits California governor's race after assault allegations.","The headline states rivals seek his supporters following his exit."],"numeric_claims":[],"primary_claim":"Swalwell exited the California governor race after assault allegations, and rivals are seeking his supporters.","relevance_score":0.35,"sentiment":"negative","source_quality":"unknown","summary":"Eric Swalwell has exited California\u2019s governor race following assault/sexual misconduct allegations, as other candidates/rivals attempt to attract his supporters.","topics":["US politics","California governor race","assault/sexual misconduct allegations","campaign exit","rivals seeking supporters"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Swalwell exits California governor's race after assault allegations as rivals seek his supporters AP News Eric Swalwell quits California governor race amid sexual misconduct claims BBC Calls grow for Eric Swalwell to resign from House amid sexual assault allegations \u2013 US politics live The Guardian Eric Swalwell Suspends Campaign for California Governor After Sexual Assault Allegations The New York Times Swalwell staffers in unsigned statement: \u2018We\u2019re horrified\u2019 by accusations Politico","title":"Swalwell exits California governor's race after assault allegations as rivals seek his supporters - AP News","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_e68681760f6c in signals