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/CBMikgFBVV95cUxNbmllbkE3bG9fTWNVaWIzUkxGb0cxY2dxQ0xucWNGbTlvcFZmZVJuaERZeG0xQk5LaDdCSkJYVHFlMzlBa0ZCa3lCY0NVby1aVzVQbjhmQWw1bWZtdFR2MHBCcnNQbG8wTUVQMGdtZm15eXpYeE95RTh6U3hTRTJBRC1pRzIwMFYzMmhHWkNKTXNEZ9IBkgFBVV95cUxOaGhZS0RPWFFGZzRyZ0tiOWdvZGE1RzJLRXdlNFo2RkcwNzBZVUViNkFhRlBrWW1NTGx5Ni1RUmc1UzFCTkFnTEx5R0M3SDFJbXVQc25xV0JDMmFCTHNMd0QwVWpPenZDUm1BZjJFdlN5V29xSXB3b0FvYjNSZ3hLbEJsdHpZTDgtWlFSNGpCR0lZUQ?oc=5","as_of":"2026-04-06T22:29:23.981990+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/CBMikgFBVV95cUxNbmllbkE3bG9fTWNVaWIzUkxGb0cxY2dxQ0xucWNGbTlvcFZmZVJuaERZeG0xQk5LaDdCSkJYVHFlMzlBa0ZCa3lCY0NVby1aVzVQbjhmQWw1bWZtdFR2MHBCcnNQbG8wTUVQMGdtZm15eXpYeE95RTh6U3hTRTJBRC1pRzIwMFYzMmhHWkNKTXNEZ9IBkgFBVV95cUxOaGhZS0RPWFFGZzRyZ0tiOWdvZGE1RzJLRXdlNFo2RkcwNzBZVUViNkFhRlBrWW1NTGx5Ni1RUmc1UzFCTkFnTEx5R0M3SDFJbXVQc25xV0JDMmFCTHNMd0QwVWpPenZDUm1BZjJFdlN5V29xSXB3b0FvYjNSZ3hLbEJsdHpZTDgtWlFSNGpCR0lZUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_93685444b72fa949","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-07T12:48:55.905180+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxNbmllbkE3bG9fTWNVaWIzUkxGb0cxY2dxQ0xucWNGbTlvcFZmZVJuaERZeG0xQk5LaDdCSkJYVHFlMzlBa0ZCa3lCY0NVby1aVzVQbjhmQWw1bWZtdFR2MHBCcnNQbG8wTUVQMGdtZm15eXpYeE95RTh6U3hTRTJBRC1pRzIwMFYzMmhHWkNKTXNEZ9IBkgFBVV95cUxOaGhZS0RPWFFGZzRyZ0tiOWdvZGE1RzJLRXdlNFo2RkcwNzBZVUViNkFhRlBrWW1NTGx5Ni1RUmc1UzFCTkFnTEx5R0M3SDFJbXVQc25xV0JDMmFCTHNMd0QwVWpPenZDUm1BZjJFdlN5V29xSXB3b0FvYjNSZ3hLbEJsdHpZTDgtWlFSNGpCR0lZUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"dw.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxNbmllbkE3bG9fTWNVaWIzUkxGb0cxY2dxQ0xucWNGbTlvcFZmZVJuaERZeG0xQk5LaDdCSkJYVHFlMzlBa0ZCa3lCY0NVby1aVzVQbjhmQWw1bWZtdFR2MHBCcnNQbG8wTUVQMGdtZm15eXpYeE95RTh6U3hTRTJBRC1pRzIwMFYzMmhHWkNKTXNEZ9IBkgFBVV95cUxOaGhZS0RPWFFGZzRyZ0tiOWdvZGE1RzJLRXdlNFo2RkcwNzBZVUViNkFhRlBrWW1NTGx5Ni1RUmc1UzFCTkFnTEx5R0M3SDFJbXVQc25xV0JDMmFCTHNMd0QwVWpPenZDUm1BZjJFdlN5V29xSXB3b0FvYjNSZ3hLbEJsdHpZTDgtWlFSNGpCR0lZUQ?oc=5","source_event_id":"evt_2355b892e831","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3517e44cac267457","published_at":"2026-04-06T16:11:08+00:00","publisher_domain":"dw.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Kim Jong Un","relevance":"leader of North Korea","symbol":"N/A","type":"individual"},{"asset_class":"political","name":"North Korea","relevance":"nation under Kim's leadership","symbol":"N/A","type":"country"},{"asset_class":"political","name":"South Korea","relevance":"source of intelligence","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the daughter's qualifications or role in governance are not provided.","The timing of any potential leadership transition is unclear."],"key_facts":["Kim's daughter is a teenager.","South Korea's intelligence agency provided the assessment.","This development could impact North Korea's political landscape."],"numeric_claims":[],"primary_claim":"Kim Jong Un's daughter is now considered a likely heir to his leadership according to South Korea's intelligence agency.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"North Korea's intelligence agency suggests that Kim Jong Un's teenage daughter is likely to be his successor, indicating a potential shift in leadership dynamics.","topics":["North Korea","leadership succession","Kim Jong Un","geopolitical dynamics"]},"source":"DW.com","source_domain":"dw.com","source_url":"https://www.dw.com","summary":"North Korea: Kim's daughter now seen as likely heir \u2014 South DW.com Seoul spy agency says it\u2019s fair to view teen daughter of North Korean leader Kim as his heir AP News What We Know About Kim Jong Un\u2019s Teenage Daughter and Possible Heir Time Magazine North Korea: Kim Jong Un's teenage daughter could be considered his successor, Seoul's spy agency reportedly says Sky News 'Credible intelligence' reveals North Korea's successor to Kim Jong Un, South Korea says Fox News","title":"North Korea: Kim's daughter now seen as likely heir \u2014 South - DW.com","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_58e20de20e79 in signals