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

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