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/CBMipAFBVV95cUxOdFJtM3JHUjZTRlN1b1JyeHFZTHdnb1ViMUVZb1dBSU5rSzZ4TWw2RmpwUGpNWUJ0cnJzVW9RM2QyMmpNVTNNZVFXcWRMNHg1bkQzMk1UcUxRTmhUTnh5aThwNFRmaVFQdUpCYVFRT3FCcjZQLUF0OXZDcFMxNFZjQlBpV2dDdlVuQllhUDFaZnJzeXV6eTR3LWZvcUNCQ2NOLU82Rw?oc=5","as_of":"2026-04-09T18:00:21.993597+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/CBMipAFBVV95cUxOdFJtM3JHUjZTRlN1b1JyeHFZTHdnb1ViMUVZb1dBSU5rSzZ4TWw2RmpwUGpNWUJ0cnJzVW9RM2QyMmpNVTNNZVFXcWRMNHg1bkQzMk1UcUxRTmhUTnh5aThwNFRmaVFQdUpCYVFRT3FCcjZQLUF0OXZDcFMxNFZjQlBpV2dDdlVuQllhUDFaZnJzeXV6eTR3LWZvcUNCQ2NOLU82Rw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_72d03b1e39c39034","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:11:55.939889+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOdFJtM3JHUjZTRlN1b1JyeHFZTHdnb1ViMUVZb1dBSU5rSzZ4TWw2RmpwUGpNWUJ0cnJzVW9RM2QyMmpNVTNNZVFXcWRMNHg1bkQzMk1UcUxRTmhUTnh5aThwNFRmaVFQdUpCYVFRT3FCcjZQLUF0OXZDcFMxNFZjQlBpV2dDdlVuQllhUDFaZnJzeXV6eTR3LWZvcUNCQ2NOLU82Rw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOdFJtM3JHUjZTRlN1b1JyeHFZTHdnb1ViMUVZb1dBSU5rSzZ4TWw2RmpwUGpNWUJ0cnJzVW9RM2QyMmpNVTNNZVFXcWRMNHg1bkQzMk1UcUxRTmhUTnh5aThwNFRmaVFQdUpCYVFRT3FCcjZQLUF0OXZDcFMxNFZjQlBpV2dDdlVuQllhUDFaZnJzeXV6eTR3LWZvcUNCQ2NOLU82Rw?oc=5","source_event_id":"evt_64f567c44184","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e7793b5271f0e8ab","published_at":"2026-04-09T16:22:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Norway","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"high","symbol":"","type":"country"},{"asset_class":"military","name":"Russian submarines","relevance":"high","symbol":"","type":"military asset"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not actually the AP article content (it appears to be page styling/HTML), so specific operational details (dates, duration, assets used, exact actions taken) are not verifiable from the supplied text.","The signal does not specify whether the operation is ongoing or completed, nor the near-term catalyst timing (e.g., when the operation occurred or when further actions are expected).","The extent and nature of the alleged Russian submarine activity around cables/pipelines is not fully detailed in the provided text; only claims are referenced in the source summary.","No direct quotes, official statements, or named UK/Norwegian officials are present in the supplied content, limiting attribution precision."],"key_facts":["AP News reports that the UK and Norway led a military operation to deter Russian submarines in the North Atlantic.","Multiple referenced outlets (per provided source summary) state the UK said Russia conducted submarine activity related to undersea cables and pipelines.","The provided source summary indicates the UK navy \u201cfoiled\u201d Russian submarines surveying undersea cables (per The New York Times/Reuters references in the summary).","The provided source summary indicates the UK deployed military to deter Russian submarines from attacking undersea cables (per Reuters reference in the summary)."],"numeric_claims":[],"primary_claim":"UK and Norway led a military operation to deter Russian submarines in the North Atlantic.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The UK and Norway reportedly led a military operation in the North Atlantic aimed at deterring Russian submarines. The operation is linked to claims that Russia was conducting submarine activity near undersea cables and pipelines.","topics":["North Atlantic","submarines","deterrence","undersea cables","pipelines","UK defense","maritime security","Russia-UK/Norway tensions"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"UK and Norway led a military operation to deter Russian submarines in the North Atlantic AP News UK says Russia ran submarine operation over cables and pipelines BBC 3 Russian Submarines Detected Near Britain Were Spying, U.K. Says The New York Times UK navy foiled Russian submarines surveying undersea cables, defence minister says The Guardian UK says it deployed military to deter Russian submarines from attack on undersea cables Reuters","title":"UK and Norway led a military operation to deter Russian submarines in the North Atlantic - AP News","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_b00ac2a04a7c in signals