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-09T19:28:46.110299+00:00","dedupe_key":"signal_enriched:news_delta:a48f04a1ee197b12","evidence_event_ids":["evt_f81383768c9e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxQSDE1MG1odVlrSTlhZmZ5cDM3ckRrUUhJSWg3UWxBUEtTZ3dtSXlIQnQtVkI1RDlYWVRVUjJ5XzFSZHliY0NWekk1VG5mY01PUnFvd1hObGI1Q3JXTjRGdGJPSnF5bXdXemNwRUhEMVY3aEJINGVBRmtaZVo3MmdxcGFqR19xZW1ET3pvU1ZZS0JOTklxdGh6Qlk0WHYyMmhYZ1BhcHdqVDVxN052Q1FJN2NYMktTUQ?oc=5","as_of":"2026-04-09T19:28:46.110299+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/CBMitgFBVV95cUxQSDE1MG1odVlrSTlhZmZ5cDM3ckRrUUhJSWg3UWxBUEtTZ3dtSXlIQnQtVkI1RDlYWVRVUjJ5XzFSZHliY0NWekk1VG5mY01PUnFvd1hObGI1Q3JXTjRGdGJPSnF5bXdXemNwRUhEMVY3aEJINGVBRmtaZVo3MmdxcGFqR19xZW1ET3pvU1ZZS0JOTklxdGh6Qlk0WHYyMmhYZ1BhcHdqVDVxN052Q1FJN2NYMktTUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8a99f5b44e7d0d66","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-10T00:24:35.474764+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxQSDE1MG1odVlrSTlhZmZ5cDM3ckRrUUhJSWg3UWxBUEtTZ3dtSXlIQnQtVkI1RDlYWVRVUjJ5XzFSZHliY0NWekk1VG5mY01PUnFvd1hObGI1Q3JXTjRGdGJPSnF5bXdXemNwRUhEMVY3aEJINGVBRmtaZVo3MmdxcGFqR19xZW1ET3pvU1ZZS0JOTklxdGh6Qlk0WHYyMmhYZ1BhcHdqVDVxN052Q1FJN2NYMktTUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"navalnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxQSDE1MG1odVlrSTlhZmZ5cDM3ckRrUUhJSWg3UWxBUEtTZ3dtSXlIQnQtVkI1RDlYWVRVUjJ5XzFSZHliY0NWekk1VG5mY01PUnFvd1hObGI1Q3JXTjRGdGJPSnF5bXdXemNwRUhEMVY3aEJINGVBRmtaZVo3MmdxcGFqR19xZW1ET3pvU1ZZS0JOTklxdGh6Qlk0WHYyMmhYZ1BhcHdqVDVxN052Q1FJN2NYMktTUQ?oc=5","source_event_id":"evt_f81383768c9e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2435f2b04c2d0607","published_at":"2026-04-09T12:10:49+00:00","publisher_domain":"navalnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom (UK)","relevance":"primary actor making the claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"alleged operator of the covert submarine activity","symbol":"","type":"country"},{"asset_class":"defense","name":"Royal Navy / UK Navy","relevance":"forces involved in tracking/foiling submarines (per reports)","symbol":"","type":"military"},{"asset_class":"naval_vessel","name":"Russian submarines","relevance":"the platforms allegedly conducting the covert operation","symbol":"","type":"military asset"},{"asset_class":"infrastructure","name":"Undersea cables and pipelines","relevance":"targets/areas reportedly surveyed during the operation","symbol":"","type":"infrastructure"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling; extracted facts rely on the provided source summary/headline only.","Exact dates/timing of the operation are not included in the provided text.","Whether any specific cables/pipelines were named or the geographic locations were specified is not included.","No details are provided on the UK\u2019s specific countermeasures or outcomes beyond 'foiled'/'exposed'.","The claim that submarines were 'surveying' is attributed to reported statements; the underlying evidence is not included in the provided text."],"key_facts":["UK authorities (via defence minister statements reported by outlets) say Russia ran a covert submarine operation in and around UK waters.","The operation is described as involving activity over/near undersea cables and pipelines.","Three Russian submarines were reportedly tracked during the covert operation (as reported by multiple outlets).","UK navy action is described as foiling the submarines\u2019 surveying activity (per outlet summaries)."],"numeric_claims":[{"label":"Number of Russian submarines tracked","value":"3"}],"primary_claim":"The UK exposed and says it foiled a covert Russian submarine operation in and around UK waters, with submarines tracked near undersea cables and pipelines.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The UK says it has uncovered and disrupted a covert Russian submarine operation in and around UK waters, including activity near undersea cables and pipelines. Multiple outlets report that three Russian submarines were tracked during the operation.","topics":["covert submarine operations","UK-Russia tensions","undersea infrastructure security","maritime surveillance","naval tracking"]},"source":"navalnews.com","source_domain":"navalnews.com","source_url":"https://www.navalnews.com","summary":"UK exposes covert Russian submarine operation in and around UK waters navalnews.com UK says Russia ran submarine operation over cables and pipelines BBC UK says three Russian submarines tracked during \u2018covert\u2019 operation Al Jazeera UK navy foiled Russian submarines surveying undersea cables, defence minister says The Guardian 3 Russian Submarines Detected Near Britain Were Spying, U.K. Says The New York Times","title":"UK exposes covert Russian submarine operation in and around UK waters - navalnews.com","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 11137 in events