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-09T18:49:37.199677+00:00","dedupe_key":"signal_enriched:news_delta:805a1846f4138be4","evidence_event_ids":["evt_ea60b4a34895"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQbDFoeW1RSWxoMF9OdHV1MzVpRXRqMzJDZUM1RndCeTktWGNxZjVmUUVDd0ZNSjNtUXdoTkpoZWdseDk3aTlrd2haRDJmVHI2ZmNSSnhCNDhFd3JlUGhoZVhJbktJeUtzaTVVT0NLUzE0Z3R4UmZkZU54SkQ5U0dkSUtsTlUyOVk?oc=5","as_of":"2026-04-09T18:49:37.199677+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/CBMihwFBVV95cUxQbDFoeW1RSWxoMF9OdHV1MzVpRXRqMzJDZUM1RndCeTktWGNxZjVmUUVDd0ZNSjNtUXdoTkpoZWdseDk3aTlrd2haRDJmVHI2ZmNSSnhCNDhFd3JlUGhoZVhJbktJeUtzaTVVT0NLUzE0Z3R4UmZkZU54SkQ5U0dkSUtsTlUyOVk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_62cfa68230641b38","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:19:52.436624+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQbDFoeW1RSWxoMF9OdHV1MzVpRXRqMzJDZUM1RndCeTktWGNxZjVmUUVDd0ZNSjNtUXdoTkpoZWdseDk3aTlrd2haRDJmVHI2ZmNSSnhCNDhFd3JlUGhoZVhJbktJeUtzaTVVT0NLUzE0Z3R4UmZkZU54SkQ5U0dkSUtsTlUyOVk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQbDFoeW1RSWxoMF9OdHV1MzVpRXRqMzJDZUM1RndCeTktWGNxZjVmUUVDd0ZNSjNtUXdoTkpoZWdseDk3aTlrd2haRDJmVHI2ZmNSSnhCNDhFd3JlUGhoZVhJbktJeUtzaTVVT0NLUzE0Z3R4UmZkZU54SkQ5U0dkSUtsTlUyOVk?oc=5","source_event_id":"evt_ea60b4a34895","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"068ce1bc7ffcb59d","published_at":"2026-04-09T12:27:00+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom (U.K.)","relevance":"primary actor making the claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Russia","relevance":"alleged actor conducting the submarine operation","symbol":"","type":"country"},{"asset_class":"defense","name":"Royal Navy / U.K. navy","relevance":"reported to have tracked/foiled the submarines","symbol":"","type":"military branch"},{"asset_class":"military_platform","name":"Russian submarines (three)","relevance":"core subject of the detection/operation","symbol":"","type":"military assets"},{"asset_class":"infrastructure","name":"Undersea cables and pipelines","relevance":"alleged target of the covert operation","symbol":"","type":"infrastructure"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling; therefore, only the headline and the multi-outlet source summary can be used.","The exact location (e.g., specific waters/coordinates) and timing (date/time of detection) are not included in the provided text.","Whether the U.K. navy \u2018foiled\u2019 the operation is asserted in the summary, but the operational details (how, when, and what evidence) are not present.","No direct quotes or named officials are included in the provided text, so attribution details are uncertain.","The nature of the \u2018spying\u2019 (signals intelligence vs. mapping vs. other) is not specified in the provided text."],"key_facts":["The New York Times headline states that three Russian submarines detected near Britain were spying, according to the U.K.","The provided source summary says the U.K. alleges Russia ran a submarine operation over undersea cables and pipelines.","The provided source summary says the BBC tracked three Russian submarines during a \u2018covert\u2019 operation.","The provided source summary says Al Jazeera reports the U.K. navy foiled Russian submarines surveying undersea cables, citing the defence minister.","The provided source summary says The Guardian accuses Russia of a covert submarine operation threatening undersea cables."],"numeric_claims":[{"label":"Number of submarines detected","value":"3"}],"primary_claim":"The U.K. says three Russian submarines detected near Britain were spying and conducting a covert operation involving undersea cables and pipelines.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The U.K. says three Russian submarines were detected near Britain during a covert operation intended to spy and survey undersea infrastructure. Multiple outlets report the U.K. claims Russia targeted undersea cables and pipelines, with the U.K. navy intervening.","topics":["submarine detection","covert operations","undersea cables","pipelines","U.K.-Russia tensions","maritime security"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"3 Russian Submarines Detected Near Britain Were Spying, U.K. Says The New York Times 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 UK accuses Russia of covert submarine operation threatening undersea cables Breaking Defense","title":"3 Russian Submarines Detected Near Britain Were Spying, U.K. Says - The New York Times","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 11062 in events