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-09T04:35:26.157864+00:00","dedupe_key":"signal_enriched:news_delta:9fe532c439711ce6","evidence_event_ids":["evt_17ec1649bc2b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQd2kyZk1iMUh5X1N2WE8yUzRFR2dJN1hYUkV2bXhiMzE0VDVrVXUxN0RySmxnVHJPb3YxUDVQRmoxUHJ0MGV6empCM1JfRGhhSTBJdHlzRjRySFkzNnhQSEw4YjhsQzVQS0NiZkhzTUJyVUZTb0V2QTd2WVdaRVV3RTBRSlk4NjBfbzFidGdWOWxLUdIBmgFBVV95cUxOU3NKR1M3d05McHJ5b3hYeXh3V21hU2YtZ3UyVC1PeS1SNWVqM0wyX0Mxc1BOa1FGX2hFWXdJUUNhanZtRzVhcXNPeEF4aGZaREYxeHdpaVFtM2ZoV2syYXNsR0ZQRHB5M1hZX3Z3SHJnNFRRWkc2RjFDV1Jhd2JaT291amtkRnJMWlZFZ2FHMGs4RlRQdTBkSzJ3?oc=5","as_of":"2026-04-09T04:35:26.157864+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/CBMikgFBVV95cUxQd2kyZk1iMUh5X1N2WE8yUzRFR2dJN1hYUkV2bXhiMzE0VDVrVXUxN0RySmxnVHJPb3YxUDVQRmoxUHJ0MGV6empCM1JfRGhhSTBJdHlzRjRySFkzNnhQSEw4YjhsQzVQS0NiZkhzTUJyVUZTb0V2QTd2WVdaRVV3RTBRSlk4NjBfbzFidGdWOWxLUdIBmgFBVV95cUxOU3NKR1M3d05McHJ5b3hYeXh3V21hU2YtZ3UyVC1PeS1SNWVqM0wyX0Mxc1BOa1FGX2hFWXdJUUNhanZtRzVhcXNPeEF4aGZaREYxeHdpaVFtM2ZoV2syYXNsR0ZQRHB5M1hZX3Z3SHJnNFRRWkc2RjFDV1Jhd2JaT291amtkRnJMWlZFZ2FHMGs4RlRQdTBkSzJ3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cd2590ad4ec2eded","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-09T22:38:00.218373+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQd2kyZk1iMUh5X1N2WE8yUzRFR2dJN1hYUkV2bXhiMzE0VDVrVXUxN0RySmxnVHJPb3YxUDVQRmoxUHJ0MGV6empCM1JfRGhhSTBJdHlzRjRySFkzNnhQSEw4YjhsQzVQS0NiZkhzTUJyVUZTb0V2QTd2WVdaRVV3RTBRSlk4NjBfbzFidGdWOWxLUdIBmgFBVV95cUxOU3NKR1M3d05McHJ5b3hYeXh3V21hU2YtZ3UyVC1PeS1SNWVqM0wyX0Mxc1BOa1FGX2hFWXdJUUNhanZtRzVhcXNPeEF4aGZaREYxeHdpaVFtM2ZoV2syYXNsR0ZQRHB5M1hZX3Z3SHJnNFRRWkc2RjFDV1Jhd2JaT291amtkRnJMWlZFZ2FHMGs4RlRQdTBkSzJ3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"liverpoolfc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQd2kyZk1iMUh5X1N2WE8yUzRFR2dJN1hYUkV2bXhiMzE0VDVrVXUxN0RySmxnVHJPb3YxUDVQRmoxUHJ0MGV6empCM1JfRGhhSTBJdHlzRjRySFkzNnhQSEw4YjhsQzVQS0NiZkhzTUJyVUZTb0V2QTd2WVdaRVV3RTBRSlk4NjBfbzFidGdWOWxLUdIBmgFBVV95cUxOU3NKR1M3d05McHJ5b3hYeXh3V21hU2YtZ3UyVC1PeS1SNWVqM0wyX0Mxc1BOa1FGX2hFWXdJUUNhanZtRzVhcXNPeEF4aGZaREYxeHdpaVFtM2ZoV2syYXNsR0ZQRHB5M1hZX3Z3SHJnNFRRWkc2RjFDV1Jhd2JaT291amtkRnJMWlZFZ2FHMGs4RlRQdTBkSzJ3?oc=5","source_event_id":"evt_17ec1649bc2b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e2144d2ba4d37831","published_at":"2026-04-08T22:48:36+00:00","publisher_domain":"liverpoolfc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sports_team_manager","name":"Arne Slot","relevance":"high","symbol":"","type":"person"},{"asset_class":"football_club","name":"Liverpool FC","relevance":"high","symbol":"LIV","type":"sports_team"},{"asset_class":"football_club","name":"PSG","relevance":"high","symbol":"PSG","type":"sports_team"},{"asset_class":"football_player","name":"Mohamed Salah","relevance":"medium","symbol":"Salah","type":"person"},{"asset_class":"football_player","name":"Howe Doue","relevance":"medium","symbol":"Doue","type":"person"},{"asset_class":"football_player","name":"Khvicha Kvaratskhelia","relevance":"medium","symbol":"Kvaratskhelia","type":"person"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the actual press-conference transcript or Slot\u2019s full statements; only the source summary/headline indicates the \u201csurvival mode\u201d quote.","No match date, venue, or quarter-final leg details (first vs second leg) are explicitly included in the provided text.","The \u201cHowe Doue\u201d name appears possibly misspelled/ambiguous; the source summary does not provide confirmation of the correct spelling.","The claim about Mohamed Salah being \u201ccompletely snubbed\u201d lacks context (who snubbed him and in what way).","No near-term catalyst timing (e.g., next match date) is included in the provided content."],"key_facts":["Liverpool lost 2-0 to PSG in a Champions League quarter-final (as referenced in the provided source summary/headline).","Arne Slot described Liverpool as being in \u201csurvival mode\u201d after the loss (quoted in the provided source summary).","The match outcome is attributed to goals by Doue and Kvaratskhelia (as referenced in the provided source summary).","The provided source summary indicates PSG took control of the Champions League quarter-final tie after the 2-0 win.","One of the referenced pieces mentions Mohamed Salah being \u201ccompletely snubbed\u201d (exact meaning/claim details are not present in the provided text)."],"numeric_claims":[{"label":"Match score","value":"PSG 2-0 Liverpool"}],"primary_claim":"Arne Slot said Liverpool were \u201cin survival mode\u201d after PSG beat them 2-0 in the Champions League quarter-final.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Arne Slot\u2019s press conference followed Liverpool\u2019s 2-0 Champions League quarter-final loss to PSG, with Slot describing the team as being in \u201csurvival mode.\u201d The defeat was driven by goals from Doue and Kvaratskhelia, giving PSG control of the tie.","topics":["Champions League","quarter-final","press conference","Liverpool vs PSG","match result","team mentality"]},"source":"Liverpool FC","source_domain":"liverpoolfc.com","source_url":"https://www.liverpoolfc.com","summary":"Arne Slot press conference: Every word on PSG 2-0 Liverpool Liverpool FC PSG 2-0 Liverpool: Arne Slot says Reds 'in survival mode' after Champions League loss BBC How Doue and Kvaratskhelia goals helped PSG ease past Liverpool to take control of Champions League quarter-final The New York Times Digging Deeper Into Liverpool\u2019s 2-0 Defeat at Paris Saint-Germain The Liverpool Offside Four Takeaways From Liverpool\u2019s Parisian Humbling As Mohamed Salah Completely Snubbed Sports Illustrated","title":"Arne Slot press conference: Every word on PSG 2-0 Liverpool - Liverpool FC","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

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 8927 in events