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/CBMiyAFBVV95cUxNRVNsSXlYRmtKd1BtdTF4cWdCYkFIVmpmSklTWTNHLTItRm0xT3VaRFpVS1VheE1iTG9pRWdvYWRRTGJsNm9JSjV5NUhCZFhsWFhGOUk3c0pDNEZUM2pLSnNQQk5LS2JqZ1poWXJBTFFLX3dmNG9XQ0pzT2JaT252TXhGb2JvNFlZZG5XZjBXbWVUamh4UTBxb25ZNUREOHY5NlJrdmdOemxxcDhiVHNEM1BsUDE3ZVNDOHg4ZXdKMDdOT2hTcmJvdw?oc=5","as_of":"2026-04-09T15:01:34.254248+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/CBMiyAFBVV95cUxNRVNsSXlYRmtKd1BtdTF4cWdCYkFIVmpmSklTWTNHLTItRm0xT3VaRFpVS1VheE1iTG9pRWdvYWRRTGJsNm9JSjV5NUhCZFhsWFhGOUk3c0pDNEZUM2pLSnNQQk5LS2JqZ1poWXJBTFFLX3dmNG9XQ0pzT2JaT252TXhGb2JvNFlZZG5XZjBXbWVUamh4UTBxb25ZNUREOHY5NlJrdmdOemxxcDhiVHNEM1BsUDE3ZVNDOHg4ZXdKMDdOT2hTcmJvdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0def793571c95c99","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-09T23:40:28.948839+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNRVNsSXlYRmtKd1BtdTF4cWdCYkFIVmpmSklTWTNHLTItRm0xT3VaRFpVS1VheE1iTG9pRWdvYWRRTGJsNm9JSjV5NUhCZFhsWFhGOUk3c0pDNEZUM2pLSnNQQk5LS2JqZ1poWXJBTFFLX3dmNG9XQ0pzT2JaT252TXhGb2JvNFlZZG5XZjBXbWVUamh4UTBxb25ZNUREOHY5NlJrdmdOemxxcDhiVHNEM1BsUDE3ZVNDOHg4ZXdKMDdOT2hTcmJvdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNRVNsSXlYRmtKd1BtdTF4cWdCYkFIVmpmSklTWTNHLTItRm0xT3VaRFpVS1VheE1iTG9pRWdvYWRRTGJsNm9JSjV5NUhCZFhsWFhGOUk3c0pDNEZUM2pLSnNQQk5LS2JqZ1poWXJBTFFLX3dmNG9XQ0pzT2JaT252TXhGb2JvNFlZZG5XZjBXbWVUamh4UTBxb25ZNUREOHY5NlJrdmdOemxxcDhiVHNEM1BsUDE3ZVNDOHg4ZXdKMDdOT2hTcmJvdw?oc=5","source_event_id":"evt_a015e3df60e4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"783d52e8d984fabb","published_at":"2026-04-09T05:19:03+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"North Korea","relevance":"high","symbol":"","type":"state"},{"asset_class":"media","name":"NPR","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"sovereign","name":"South Korea","relevance":"medium","symbol":"","type":"state"},{"asset_class":"military","name":"U.S. Indo-Pacific Command (USINDOPACOM)","relevance":"medium","symbol":"","type":"military_command"},{"asset_class":"media","name":"Reuters","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"AP News","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided appears to be unrelated page markup/CSS rather than the NPR article content; therefore, only the headline and the supplied source summary can be treated as grounded.","No test date, missile type/model, number of missiles, or confirmation details (e.g., independent verification) are included in the provided material.","The near-term catalyst timing (e.g., when USINDOPACOM will respond, when additional tests are expected) is not specified in the provided text.","Whether the cluster-bomb warheads were newly developed vs. previously tested is not stated in the provided material."],"key_facts":["NPR headline indicates North Korea said its latest weapons tests included missiles with cluster-bomb warheads.","The provided source summary also references reporting that North Korea unveiled a cluster-bomb missile capability and electronic warfare capability (attributed to Reuters in the summary).","The provided source summary references a U.S. Indo-Pacific Command statement on DPRK missile launches (pacom.mil), but the specific content is not included in the provided text."],"numeric_claims":[],"primary_claim":"North Korea stated that its latest weapons tests included missiles with cluster-bomb warheads.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"NPR reports that North Korea says its latest weapons tests involved missiles equipped with cluster-bomb warheads. The disclosure adds to reporting that North Korea has unveiled cluster-bomb missile and electronic warfare capabilities, likely increasing regional security concerns in the near term.","topics":["North Korea weapons tests","cluster munitions","missile capabilities","electronic warfare","U.S.-South Korea regional security","USINDOPACOM statements"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"North Korea says its latest weapons tests included missiles with cluster-bomb warheads NPR North Korea fires missiles toward sea after ridiculing South\u2019s hopes for better ties AP News North Korea Tests New Weapons, Drawing Lessons from Iran War The New York Times North Korea unveils cluster-bomb missile, electronic warfare capability Reuters USINDOPACOM Statement on DPRK Missile Launches > U.S. Indo-Pacific Command > News Articles pacom.mil","title":"North Korea says its latest weapons tests included missiles with cluster-bomb warheads - NPR","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_b304d06b17d5 in signals