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-06T13:34:01.411249+00:00","dedupe_key":"signal_enriched:news_delta:8161f7000f3de8dd","evidence_event_ids":["evt_aa80ea9b846f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiakFVX3lxTE43bk96UVRaVWZEZ3dfcUlGU3RaZzlhZnAxMjRSR2hFRlRyemlLYUdMV0ZzME4wbU1yYnBDc29VQ1JkOXRwelA0N2ZMY01KRXJGUEZTNDVjeUZuWlJSNGNEeDhuSXk4OGxUUmc?oc=5","as_of":"2026-04-06T13:34:01.411249+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiakFVX3lxTE43bk96UVRaVWZEZ3dfcUlGU3RaZzlhZnAxMjRSR2hFRlRyemlLYUdMV0ZzME4wbU1yYnBDc29VQ1JkOXRwelA0N2ZMY01KRXJGUEZTNDVjeUZuWlJSNGNEeDhuSXk4OGxUUmc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_de682c5d3312b8d5","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T13:36:16.391929+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiakFVX3lxTE43bk96UVRaVWZEZ3dfcUlGU3RaZzlhZnAxMjRSR2hFRlRyemlLYUdMV0ZzME4wbU1yYnBDc29VQ1JkOXRwelA0N2ZMY01KRXJGUEZTNDVjeUZuWlJSNGNEeDhuSXk4OGxUUmc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiakFVX3lxTE43bk96UVRaVWZEZ3dfcUlGU3RaZzlhZnAxMjRSR2hFRlRyemlLYUdMV0ZzME4wbU1yYnBDc29VQ1JkOXRwelA0N2ZMY01KRXJGUEZTNDVjeUZuWlJSNGNEeDhuSXk4OGxUUmc?oc=5","source_event_id":"evt_aa80ea9b846f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5ac409929ac77b20","published_at":"2026-04-06T08:38:27+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-05"],"entities":[{"asset_class":"basketball","name":"Cooper Flagg","relevance":"high","symbol":"N/A","type":"player"},{"asset_class":"basketball","name":"Dallas Mavericks","relevance":"high","symbol":"DAL","type":"team"},{"asset_class":"basketball","name":"Los Angeles Lakers","relevance":"high","symbol":"LAL","type":"team"}],"event_type":"other","information_gaps":["No details on the overall game statistics or standings were provided."],"key_facts":["Cooper Flagg scored 45 points in the game.","The Mavericks defeated the Lakers.","This performance follows a previous game where Flagg scored 51 points."],"numeric_claims":[{"label":"points scored","value":"45"},{"label":"previous game points","value":"51"}],"primary_claim":"Cooper Flagg scored 45 points in the Mavericks' victory over the Lakers.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Cooper Flagg scored 45 points in a game where the Dallas Mavericks defeated the Los Angeles Lakers, marking a significant performance that bolsters his candidacy for NBA Rookie of the Year.","topics":["NBA","sports performance","rookie of the year"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Cooper Flagg scores 45 points as Dallas Mavericks beat Los Angeles Lakers BBC Los Angeles Lakers vs Dallas Mavericks Apr 5, 2026 Box Scores NBA Cooper Flagg follows up 51-point game with 45 to outduel LeBron James, send reeling Lakers to defeat Yahoo Sports Cooper Flagg makes latest 'statement' for NBA Rookie of the Year with 45 points in Mavs' win over Lakers Fox News YouTube Gold: Cooper Flagg Goes Off Again, This Time Against The Los Angeles Lakers Duke Basketball Report","title":"Cooper Flagg scores 45 points as Dallas Mavericks beat Los Angeles Lakers - BBC","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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 31423 in events