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/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

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_c49471b29d44 in signals