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-15T15:19:27.404688+00:00","dedupe_key":"signal_enriched:news_delta:43f7e240fad4f0f6","evidence_event_ids":["evt_70a7c0e850dd"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPcV9PNFJfcEhNS3FOaTdhVVNfcUdGTXdzOVRQTTVYcUMwMXlrS2lZV044UEhONEVOMzdfS25GZEI5MERwMHNnOG9uRUtFQW5NN3YwdGJ0cXFxbWtlRnJTTGdONHJ2c21BYjM0eUVYQUg1TFRaY1YzeHdWUmdUeDBDYnMwODlucE1OQVNiTmtpdGVHaGFyanY0dm4zZTh6TV9hLW9ZMHBlbmlIQVlVQTFfb0JfUQ?oc=5","as_of":"2026-04-15T15:19:27.404688+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/CBMiswFBVV95cUxPcV9PNFJfcEhNS3FOaTdhVVNfcUdGTXdzOVRQTTVYcUMwMXlrS2lZV044UEhONEVOMzdfS25GZEI5MERwMHNnOG9uRUtFQW5NN3YwdGJ0cXFxbWtlRnJTTGdONHJ2c21BYjM0eUVYQUg1TFRaY1YzeHdWUmdUeDBDYnMwODlucE1OQVNiTmtpdGVHaGFyanY0dm4zZTh6TV9hLW9ZMHBlbmlIQVlVQTFfb0JfUQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4c57290a59abe0e4","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-15T22:15:24.225362+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPcV9PNFJfcEhNS3FOaTdhVVNfcUdGTXdzOVRQTTVYcUMwMXlrS2lZV044UEhONEVOMzdfS25GZEI5MERwMHNnOG9uRUtFQW5NN3YwdGJ0cXFxbWtlRnJTTGdONHJ2c21BYjM0eUVYQUg1TFRaY1YzeHdWUmdUeDBDYnMwODlucE1OQVNiTmtpdGVHaGFyanY0dm4zZTh6TV9hLW9ZMHBlbmlIQVlVQTFfb0JfUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"rollingstone.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPcV9PNFJfcEhNS3FOaTdhVVNfcUdGTXdzOVRQTTVYcUMwMXlrS2lZV044UEhONEVOMzdfS25GZEI5MERwMHNnOG9uRUtFQW5NN3YwdGJ0cXFxbWtlRnJTTGdONHJ2c21BYjM0eUVYQUg1TFRaY1YzeHdWUmdUeDBDYnMwODlucE1OQVNiTmtpdGVHaGFyanY0dm4zZTh6TV9hLW9ZMHBlbmlIQVlVQTFfb0JfUQ?oc=5","source_event_id":"evt_70a7c0e850dd","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"cd48860af388a062","published_at":"2026-04-15T13:28:55+00:00","publisher_domain":"rollingstone.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 Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims - Rolling Stone","Source summary: Katy Perry Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims Rolling Stone Australian Authorities Are Investigating Katy Perry After Ruby Rose Allegations Yahoo Katy Perry Under Police Investigation for Alleged Sexual Assault of Ruby Rose Pitchfork Ruby Rose Alleges Katy Perry Sexually Assaulted Her at an Australian Nightclub (UPDATE) Complex Anna Kendrick makes shocking claim about \u2018aggressive\u2019 Katy "],"numeric_claims":[],"primary_claim":"Katy Perry Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims - Rolling Stone","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Katy Perry Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims Rolling Stone Australian Authorities Are Investigating Katy Perry After Ruby Rose Allegations Yahoo Katy Perry Under Police Investigation for Alleged Sexual Assault of Ruby Rose Pitchfork Ruby Rose Alleges Katy Perry Sexually Assaulted Her at an Australian Nightclub (UPDATE) Complex Anna Kendrick makes shocking claim abou","topics":["news headline"]},"source":"Rolling Stone","source_domain":"rollingstone.com","source_url":"https://www.rollingstone.com","summary":"Katy Perry Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims Rolling Stone Australian Authorities Are Investigating Katy Perry After Ruby Rose Allegations Yahoo Katy Perry Under Police Investigation for Alleged Sexual Assault of Ruby Rose Pitchfork Ruby Rose Alleges Katy Perry Sexually Assaulted Her at an Australian Nightclub (UPDATE) Complex Anna Kendrick makes shocking claim about \u2018aggressive\u2019 Katy Perry touching her cleavage in resurfaced interview Page Six","title":"Katy Perry Under Police Investigation Over Ruby Rose\u2019s Sexual-Assault Claims - Rolling Stone","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 51052 in events