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/CBMimwFBVV95cUxQV3p1LTdmOWxXWXZCZDl5SnJmalVub0ZpNS1KSjA5MkYzbC1CaFR1TXFDc2VJUDd5Rm8wWjBFTWJjLWQ1ZVZFLWxQVjBtM0tOd1hfYThLZ3JLT2xaRGZhZzd5a2J4WldrYnNkZGVVNWNiVm45OThoWll6eXd5dUdDeV9xOFJlandaVnJwT3QweGZKOVJSSzd0YmJ3Zw?oc=5","as_of":"2026-04-06T15:00:06.804020+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxQV3p1LTdmOWxXWXZCZDl5SnJmalVub0ZpNS1KSjA5MkYzbC1CaFR1TXFDc2VJUDd5Rm8wWjBFTWJjLWQ1ZVZFLWxQVjBtM0tOd1hfYThLZ3JLT2xaRGZhZzd5a2J4WldrYnNkZGVVNWNiVm45OThoWll6eXd5dUdDeV9xOFJlandaVnJwT3QweGZKOVJSSzd0YmJ3Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1d9275e614d249b3","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T15:41:08.497304+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxQV3p1LTdmOWxXWXZCZDl5SnJmalVub0ZpNS1KSjA5MkYzbC1CaFR1TXFDc2VJUDd5Rm8wWjBFTWJjLWQ1ZVZFLWxQVjBtM0tOd1hfYThLZ3JLT2xaRGZhZzd5a2J4WldrYnNkZGVVNWNiVm45OThoWll6eXd5dUdDeV9xOFJlandaVnJwT3QweGZKOVJSSzd0YmJ3Zw?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/CBMimwFBVV95cUxQV3p1LTdmOWxXWXZCZDl5SnJmalVub0ZpNS1KSjA5MkYzbC1CaFR1TXFDc2VJUDd5Rm8wWjBFTWJjLWQ1ZVZFLWxQVjBtM0tOd1hfYThLZ3JLT2xaRGZhZzd5a2J4WldrYnNkZGVVNWNiVm45OThoWll6eXd5dUdDeV9xOFJlandaVnJwT3QweGZKOVJSSzd0YmJ3Zw?oc=5","source_event_id":"evt_693cc9924cff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4a6a9e55f8b7f258","published_at":"2026-04-06T11:40:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Kim Jong Un","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"political","name":"North Korea","relevance":"high","symbol":"N/A","type":"country"},{"asset_class":"political","name":"South Korea","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the specific intelligence that supports this claim are not provided."],"key_facts":["Seoul's spy agency claims credible intelligence supports the view of Kim's daughter as a successor.","This development could impact regional stability and international relations."],"numeric_claims":[],"primary_claim":"The Seoul spy agency believes it is fair to consider Kim Jong Un's daughter as his heir.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"South Korea's spy agency has indicated that Kim Jong Un's teenage daughter could be viewed as his successor, based on credible intelligence.","topics":["North Korea","succession","geopolitics"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Seoul spy agency says it\u2019s fair to view teen daughter of North Korean leader Kim as his heir AP News South Korea says 'credible intelligence' indicates North Korean leader's daughter is successor Reuters It's fair to view Kim Jong Un's teen daughter as his heir, Seoul spy agency says NBC News North Korea: Kim Jong Un's teenage daughter could be considered his successor, Seoul's spy agency reportedly says Sky News Seoul spy agency says it's fair to view teen daughter of N. Korean leader as his heir livingstonenterprise.net","title":"Seoul spy agency says it\u2019s fair to view teen daughter of North Korean leader Kim as his heir - AP News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_aec100a73f4d in signals