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-09T09:02:14.767393+00:00","dedupe_key":"signal_enriched:news_delta:01bcfb6696b31d4b","evidence_event_ids":["evt_c54ae69a8f50"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMivAFBVV95cUxNVHVTa203ZUNqbTMyNUxHVlV6dVNSbDBfRWVhX2tsZnJHcHVyTEo1dVFtN29aR2dMU0RIY3U3cDZMNUpSSHMtRlhaWXo4dnB4NGJ6dEI4dkNkZzJpdXZnUHZLR0ppejg5Z0ZiVTAwbFFZQzFYaDVXUlJBOWtRRl8yRl92UmhNTFFGX0Q3clRmWS0wRFRsLWtwaTRWcVB2NHdkNVJ0OXlCbUVEOEdLRXlNZTJwUGw1dXYtbi1SaQ?oc=5","as_of":"2026-04-09T09:02:14.767393+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/CBMivAFBVV95cUxNVHVTa203ZUNqbTMyNUxHVlV6dVNSbDBfRWVhX2tsZnJHcHVyTEo1dVFtN29aR2dMU0RIY3U3cDZMNUpSSHMtRlhaWXo4dnB4NGJ6dEI4dkNkZzJpdXZnUHZLR0ppejg5Z0ZiVTAwbFFZQzFYaDVXUlJBOWtRRl8yRl92UmhNTFFGX0Q3clRmWS0wRFRsLWtwaTRWcVB2NHdkNVJ0OXlCbUVEOEdLRXlNZTJwUGw1dXYtbi1SaQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b8358253f20eaec1","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-09T22:57:53.452261+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivAFBVV95cUxNVHVTa203ZUNqbTMyNUxHVlV6dVNSbDBfRWVhX2tsZnJHcHVyTEo1dVFtN29aR2dMU0RIY3U3cDZMNUpSSHMtRlhaWXo4dnB4NGJ6dEI4dkNkZzJpdXZnUHZLR0ppejg5Z0ZiVTAwbFFZQzFYaDVXUlJBOWtRRl8yRl92UmhNTFFGX0Q3clRmWS0wRFRsLWtwaTRWcVB2NHdkNVJ0OXlCbUVEOEdLRXlNZTJwUGw1dXYtbi1SaQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivAFBVV95cUxNVHVTa203ZUNqbTMyNUxHVlV6dVNSbDBfRWVhX2tsZnJHcHVyTEo1dVFtN29aR2dMU0RIY3U3cDZMNUpSSHMtRlhaWXo4dnB4NGJ6dEI4dkNkZzJpdXZnUHZLR0ppejg5Z0ZiVTAwbFFZQzFYaDVXUlJBOWtRRl8yRl92UmhNTFFGX0Q3clRmWS0wRFRsLWtwaTRWcVB2NHdkNVJ0OXlCbUVEOEdLRXlNZTJwUGw1dXYtbi1SaQ?oc=5","source_event_id":"evt_c54ae69a8f50","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1fd3f6d68d3593cc","published_at":"2026-04-09T02:37:00+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"North Korea","relevance":"primary actor","symbol":"","type":"country"},{"asset_class":"sovereign","name":"South Korea","relevance":"regional counterpart likely to respond","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Seoul","relevance":"South Korea reference in reporting","symbol":"","type":"city/government reference"},{"asset_class":"media","name":"Bloomberg","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNN","relevance":"reported additional details on warheads","symbol":"","type":"publisher"},{"asset_class":"media","name":"Reuters","relevance":"reported additional details on cluster-bomb missile and electronic warfare capability","symbol":"","type":"publisher"},{"asset_class":"media","name":"Politico","relevance":"reported second projectile timing","symbol":"","type":"publisher"},{"asset_class":"media","name":"AP News","relevance":"reported missile launch toward sea after ridiculing hopes for better ties","symbol":"","type":"publisher"}],"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 and headline delta, not on the full article body.","The electromagnetic weapons system\u2019s specific type, target, and test outcome (e.g., effectiveness, range, success/failure) are not stated in the provided summary.","Whether the cluster-bomb warheads and electronic warfare capability are definitively part of the same test event versus separate launches is not fully disambiguated.","No specific dates/times of the tests are included in the provided summary."],"key_facts":["Bloomberg reports that North Korea said it tested an electromagnetic weapons system.","Other cited reporting indicates the tests involved missiles armed with cluster-bomb warheads (CNN).","Other cited reporting indicates North Korea unveiled a cluster-bomb missile and an electronic warfare capability (Reuters).","Politico reports North Korea launched a second projectile within two days, according to Seoul.","AP News reports North Korea fired missiles toward the sea after ridiculing South Korea\u2019s hopes for better ties."],"numeric_claims":[{"label":"Second projectile timing","value":"within 2 days"}],"primary_claim":"North Korea stated that it tested an electromagnetic weapons system as part of its latest weapons tests.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"North Korea says it tested an electromagnetic weapons system, alongside missile tests that reportedly included cluster-bomb warheads and an electronic warfare capability. The reported launches add near-term escalation risk for the Korean Peninsula and likely prompt continued monitoring and responses from South Korea.","topics":["North Korea","electromagnetic weapons","missile testing","cluster-bomb warheads","electronic warfare capability","Korean Peninsula tensions","Seoul response","maritime missile launches"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"North Korea Says It Tested an Electromagnetic Weapons System Bloomberg.com North Korea says its latest tests included missiles armed with cluster-bomb warheads CNN North Korea unveils cluster-bomb missile, electronic warfare capability Reuters North Korea launches a second projectile in 2 days, Seoul says Politico North Korea fires missiles toward sea after ridiculing South\u2019s hopes for better ties AP News","title":"North Korea Says It Tested an Electromagnetic Weapons System - Bloomberg.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 9431 in events