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-06T01:21:11.169516+00:00","dedupe_key":"signal_enriched:news_delta:155264f207a962f1","evidence_event_ids":["evt_95e0c7a49d35"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxQbHBzdTMwYjRSeVAybmFqN1BYd3VMc1dKWEpyS3V1ZzB4TnJoRE1zUFRYcTZQV2tkZGNHVXhpN3N0X2NnTXFlLWlnbDM3bXRZSmQ1NFM5T3RRYkNqOTNfWDJRX0xFSHFnWEdCcDd6NVlXTk5SWWV2ak5YS1lSVDh6UWlNZnZpaGRndjJ6NWJJcDlEWmRVSW1QM1VkaVhWdW1IQ1NCZdIBpAFBVV95cUxQeW84SjRHVjBKM1U5MGM1VnlocnhERGV0NkpoM3l6OG1sOVJPRlV6Z091QkFSbEc0TERoNURjU2stZU1RZ2hyeTN5QmltekgwMFJuZS1yMVF2a1FtRGFUc3NYbEJmc29MVzlwa3NMRU1qNGxBZnlRSDAwZ1JiXzZLeVhiMGpnVGJTUzh1SHBVUTVDZEVkSHNxNGpQNkRwMjBsemxXMg?oc=5","as_of":"2026-04-06T01:21:11.169516+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxQbHBzdTMwYjRSeVAybmFqN1BYd3VMc1dKWEpyS3V1ZzB4TnJoRE1zUFRYcTZQV2tkZGNHVXhpN3N0X2NnTXFlLWlnbDM3bXRZSmQ1NFM5T3RRYkNqOTNfWDJRX0xFSHFnWEdCcDd6NVlXTk5SWWV2ak5YS1lSVDh6UWlNZnZpaGRndjJ6NWJJcDlEWmRVSW1QM1VkaVhWdW1IQ1NCZdIBpAFBVV95cUxQeW84SjRHVjBKM1U5MGM1VnlocnhERGV0NkpoM3l6OG1sOVJPRlV6Z091QkFSbEc0TERoNURjU2stZU1RZ2hyeTN5QmltekgwMFJuZS1yMVF2a1FtRGFUc3NYbEJmc29MVzlwa3NMRU1qNGxBZnlRSDAwZ1JiXzZLeVhiMGpnVGJTUzh1SHBVUTVDZEVkSHNxNGpQNkRwMjBsemxXMg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e27895f47373f51f","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T01:21:59.315092+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxQbHBzdTMwYjRSeVAybmFqN1BYd3VMc1dKWEpyS3V1ZzB4TnJoRE1zUFRYcTZQV2tkZGNHVXhpN3N0X2NnTXFlLWlnbDM3bXRZSmQ1NFM5T3RRYkNqOTNfWDJRX0xFSHFnWEdCcDd6NVlXTk5SWWV2ak5YS1lSVDh6UWlNZnZpaGRndjJ6NWJJcDlEWmRVSW1QM1VkaVhWdW1IQ1NCZdIBpAFBVV95cUxQeW84SjRHVjBKM1U5MGM1VnlocnhERGV0NkpoM3l6OG1sOVJPRlV6Z091QkFSbEc0TERoNURjU2stZU1RZ2hyeTN5QmltekgwMFJuZS1yMVF2a1FtRGFUc3NYbEJmc29MVzlwa3NMRU1qNGxBZnlRSDAwZ1JiXzZLeVhiMGpnVGJTUzh1SHBVUTVDZEVkSHNxNGpQNkRwMjBsemxXMg?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/CBMipAFBVV95cUxQbHBzdTMwYjRSeVAybmFqN1BYd3VMc1dKWEpyS3V1ZzB4TnJoRE1zUFRYcTZQV2tkZGNHVXhpN3N0X2NnTXFlLWlnbDM3bXRZSmQ1NFM5T3RRYkNqOTNfWDJRX0xFSHFnWEdCcDd6NVlXTk5SWWV2ak5YS1lSVDh6UWlNZnZpaGRndjJ6NWJJcDlEWmRVSW1QM1VkaVhWdW1IQ1NCZdIBpAFBVV95cUxQeW84SjRHVjBKM1U5MGM1VnlocnhERGV0NkpoM3l6OG1sOVJPRlV6Z091QkFSbEc0TERoNURjU2stZU1RZ2hyeTN5QmltekgwMFJuZS1yMVF2a1FtRGFUc3NYbEJmc29MVzlwa3NMRU1qNGxBZnlRSDAwZ1JiXzZLeVhiMGpnVGJTUzh1SHBVUTVDZEVkSHNxNGpQNkRwMjBsemxXMg?oc=5","source_event_id":"evt_95e0c7a49d35","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8465abec841edbba","published_at":"2026-04-05T16:16:17+00:00","publisher_domain":"dw.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"humanitarian","name":"migrants","relevance":"directly affected","symbol":"","type":"human"},{"asset_class":"geopolitical","name":"Libya","relevance":"location of the incident","symbol":"LY","type":"country"}],"event_type":"supply_disruption","information_gaps":["Exact number of missing individuals is uncertain","Details on the cause of the capsizing are not provided"],"key_facts":["Dozens missing after boat capsized","Over 70 migrants feared dead","Rescue efforts ongoing by ships near Italy"],"numeric_claims":[{"label":"migrants feared dead","value":"70+"},{"label":"migrants rescued","value":"32"}],"primary_claim":"More than 70 migrants are feared dead after a boat capsized off the coast of Libya.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"A migrant boat capsized in the Mediterranean, resulting in dozens missing and over 70 feared dead, with ongoing rescue efforts by nearby ships.","topics":["migration","humanitarian crisis","Mediterranean","Libya"]},"source":"DW.com","source_domain":"dw.com","source_url":"https://www.dw.com","summary":"Dozens missing after migrant boat capsizes in Mediterranean DW.com More Than 70 Migrants Feared Dead After Boat Capsizes Off Libya The New York Times Ships near Italy rescue 32 migrants, 71 lost at sea, charities say reuters.com More than 70 people feared dead after migrant boat capsizes in the central Mediterranean Euronews.com Italian coastguard recovers 19 bodies from boat in sea near Lampedusa The Guardian","title":"Dozens missing after migrant boat capsizes in Mediterranean - DW.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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 26440 in events