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-09T17:20:48.647766+00:00","dedupe_key":"signal_enriched:news_delta:ea0dd5f4590cfa3c","evidence_event_ids":["evt_b5aaf658d60c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPdkNHUEU3OVNQdkFGT2ZselVOTkdMZEEydy12RDA3UVpQUmJ0a0NhZFdSSUJNRkQydEpCOHJxU3g5NXVBU1ZvTURDczlueGFUY3VxZ211VlloWC16dVgxbGliSjhRZzNQUjNrMUdPVnJtX2M4NnlRM0c4WlVjSk1PTGlPYS1zVlhZQ0pDT2FpdXR2MHlDZjlSLUd1WlplbGFub2hjcEhZQVFwUEZscF94SjFMcGpRWlVmb1Q5V1JR?oc=5","as_of":"2026-04-09T17:20:48.647766+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/CBMivgFBVV95cUxPdkNHUEU3OVNQdkFGT2ZselVOTkdMZEEydy12RDA3UVpQUmJ0a0NhZFdSSUJNRkQydEpCOHJxU3g5NXVBU1ZvTURDczlueGFUY3VxZ211VlloWC16dVgxbGliSjhRZzNQUjNrMUdPVnJtX2M4NnlRM0c4WlVjSk1PTGlPYS1zVlhZQ0pDT2FpdXR2MHlDZjlSLUd1WlplbGFub2hjcEhZQVFwUEZscF94SjFMcGpRWlVmb1Q5V1JR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_afb337edac3a978b","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:09:53.320845+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPdkNHUEU3OVNQdkFGT2ZselVOTkdMZEEydy12RDA3UVpQUmJ0a0NhZFdSSUJNRkQydEpCOHJxU3g5NXVBU1ZvTURDczlueGFUY3VxZ211VlloWC16dVgxbGliSjhRZzNQUjNrMUdPVnJtX2M4NnlRM0c4WlVjSk1PTGlPYS1zVlhZQ0pDT2FpdXR2MHlDZjlSLUd1WlplbGFub2hjcEhZQVFwUEZscF94SjFMcGpRWlVmb1Q5V1JR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"euronews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxPdkNHUEU3OVNQdkFGT2ZselVOTkdMZEEydy12RDA3UVpQUmJ0a0NhZFdSSUJNRkQydEpCOHJxU3g5NXVBU1ZvTURDczlueGFUY3VxZ211VlloWC16dVgxbGliSjhRZzNQUjNrMUdPVnJtX2M4NnlRM0c4WlVjSk1PTGlPYS1zVlhZQ0pDT2FpdXR2MHlDZjlSLUd1WlplbGFub2hjcEhZQVFwUEZscF94SjFMcGpRWlVmb1Q5V1JR?oc=5","source_event_id":"evt_b5aaf658d60c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4af20d328dcb7fe0","published_at":"2026-04-09T11:06:15+00:00","publisher_domain":"euronews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom","relevance":"primary actor making the claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Norway","relevance":"co-led military operation","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"alleged actor running the submarine operation","symbol":"","type":"country"},{"asset_class":"military","name":"Russian submarines","relevance":"reported platform involved in the operation","symbol":"","type":"military asset"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is largely non-content (CSS/HTML), so detailed specifics (date/time, location coordinates, operational details, and official statements) are not present in the supplied text.","The exact number of Russian submarines and the precise timing of detection/foiling are not fully verifiable from the provided excerpt.","Whether the operation was fully prevented or only deterred (and what evidence supports the claim) is not specified in the provided text.","No direct market/financial impact details are included; any near-term economic implications for telecom/energy infrastructure are not stated."],"key_facts":["Euronews headline states that the UK and Norway foiled a Russian submarine plot to survey undersea cables in the North Atlantic.","The provided source summary indicates the UK says Russia ran a submarine operation over undersea cables and pipelines.","The source summary also indicates the UK and Norway led a military operation to deter Russian submarines in the North Atlantic.","The source summary (via other outlets) suggests multiple Russian submarines were detected near Britain and were described as spying by the UK (exact count/timing not fully specified in the provided text)."],"numeric_claims":[],"primary_claim":"UK and Norway foiled a Russian submarine plot to survey undersea cables (and pipelines) in the North Atlantic.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"The UK and Norway say they disrupted a Russian submarine operation intended to survey undersea cables and pipelines in the North Atlantic. The reported near-term catalyst is the immediate military deterrence action that prevented the activity from proceeding.","topics":["North Atlantic security","submarine operations","undersea cables","critical infrastructure","UK-Norway defense cooperation","deterrence/foiling operations"]},"source":"Euronews.com","source_domain":"euronews.com","source_url":"https://www.euronews.com","summary":"UK and Norway foil Russian submarine plot to survey undersea cables in north Atlantic Euronews.com UK says Russia ran submarine operation over cables and pipelines BBC U.K. and Norway led a military operation to deter Russian submarines in the North Atlantic Los Angeles Times 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 and Norway foil Russian submarine plot to survey undersea cables in north Atlantic - Euronews.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 10905 in events