SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-16T13:30:15.578306+00:00","dedupe_key":"signal_enriched:news_delta:6a52700f37bf9874","evidence_event_ids":["evt_3fff97c2ff4c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgJBVV95cUxNNm1jY3FwdWtyS3ZXcDBrYlRwSDN4eFZiYmplRnduMkU2bXNFUkY4WWF5UzNJYi03RDVMbTJlcTB3R2pjdzQ5UU9sOGkyMUd2RzRZazExNm00MU90Qmk1b2Q3MXY2UGlVV0o2X29wanlRZS1vS3lHdDJRSmFtQkhhV3hGa1dUb0tZcjFid2QwLXZ2QXl4T3ltcjZoVHBGalIxNEwzUFh2bEZ4RlZzOWozWlg1YzROS2QwRmpEeVJwRE9Nb0lFUHIwSmozazhxd3VtUUVocy1GWEtYNHY1VDhQSWl5Yms2S0VrajhwTmsyNGRtMzYwbENQWjVNOXcxOHFIVk1ZWnBuekdqd2RucUlqcDJn?oc=5","as_of":"2026-04-16T13:30:15.578306+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/CBMikgJBVV95cUxNNm1jY3FwdWtyS3ZXcDBrYlRwSDN4eFZiYmplRnduMkU2bXNFUkY4WWF5UzNJYi03RDVMbTJlcTB3R2pjdzQ5UU9sOGkyMUd2RzRZazExNm00MU90Qmk1b2Q3MXY2UGlVV0o2X29wanlRZS1vS3lHdDJRSmFtQkhhV3hGa1dUb0tZcjFid2QwLXZ2QXl4T3ltcjZoVHBGalIxNEwzUFh2bEZ4RlZzOWozWlg1YzROS2QwRmpEeVJwRE9Nb0lFUHIwSmozazhxd3VtUUVocy1GWEtYNHY1VDhQSWl5Yms2S0VrajhwTmsyNGRtMzYwbENQWjVNOXcxOHFIVk1ZWnBuekdqd2RucUlqcDJn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7e501fbdc175e5e7","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-16T13:30:57.209990+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgJBVV95cUxNNm1jY3FwdWtyS3ZXcDBrYlRwSDN4eFZiYmplRnduMkU2bXNFUkY4WWF5UzNJYi03RDVMbTJlcTB3R2pjdzQ5UU9sOGkyMUd2RzRZazExNm00MU90Qmk1b2Q3MXY2UGlVV0o2X29wanlRZS1vS3lHdDJRSmFtQkhhV3hGa1dUb0tZcjFid2QwLXZ2QXl4T3ltcjZoVHBGalIxNEwzUFh2bEZ4RlZzOWozWlg1YzROS2QwRmpEeVJwRE9Nb0lFUHIwSmozazhxd3VtUUVocy1GWEtYNHY1VDhQSWl5Yms2S0VrajhwTmsyNGRtMzYwbENQWjVNOXcxOHFIVk1ZWnBuekdqd2RucUlqcDJn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgJBVV95cUxNNm1jY3FwdWtyS3ZXcDBrYlRwSDN4eFZiYmplRnduMkU2bXNFUkY4WWF5UzNJYi03RDVMbTJlcTB3R2pjdzQ5UU9sOGkyMUd2RzRZazExNm00MU90Qmk1b2Q3MXY2UGlVV0o2X29wanlRZS1vS3lHdDJRSmFtQkhhV3hGa1dUb0tZcjFid2QwLXZ2QXl4T3ltcjZoVHBGalIxNEwzUFh2bEZ4RlZzOWozWlg1YzROS2QwRmpEeVJwRE9Nb0lFUHIwSmozazhxd3VtUUVocy1GWEtYNHY1VDhQSWl5Yms2S0VrajhwTmsyNGRtMzYwbENQWjVNOXcxOHFIVk1ZWnBuekdqd2RucUlqcDJn?oc=5","source_event_id":"evt_3fff97c2ff4c","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"f6408172bbb1859b","published_at":"2026-04-16T12:51:32+00:00","publisher_domain":"yahoo.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: Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago - Yahoo","Source summary: Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago Yahoo Australian authorities launch investigation after Ruby Rose accuses Katy Perry of sexual assault CNN Australian police launch investigation into Ruby Rose allegations against Katy Perry ABC13 Houston Ex-Manager of Nightclub Where Ruby Rose Alleges Katy Perry Sexually Assaulted Her Speaks Out P"],"numeric_claims":[],"primary_claim":"Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago - Yahoo","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago Yahoo Australian authorities launch investigation after Ruby Rose accuses Katy Perry of sexual assault CNN Australian police launch investigation into Ruby Rose allegations against Katy Perry ABC13 Houston Ex-Manager of Nightclub Where Ruby Rose Alleges Katy Perry Sexually Assaul","topics":["news headline"]},"source":"Yahoo","source_domain":"yahoo.com","source_url":"https://www.yahoo.com","summary":"Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago Yahoo Australian authorities launch investigation after Ruby Rose accuses Katy Perry of sexual assault CNN Australian police launch investigation into Ruby Rose allegations against Katy Perry ABC13 Houston Ex-Manager of Nightclub Where Ruby Rose Alleges Katy Perry Sexually Assaulted Her Speaks Out People.com Anna Kendrick makes shocking claim about \u2018aggressive\u2019 Katy Perry touching her cleavage in resurfaced interview Page Six","title":"Katy Perry is under investigation by Australian police over Ruby Rose sexual assault allegations from over a decade ago - Yahoo","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 57503 in events