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-09T08:24:00.970048+00:00","dedupe_key":"signal_enriched:news_delta:ff8aa3587bff3e7a","evidence_event_ids":["evt_4ed1a429e3d5"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxQZTVzSDRHSUlBQmMwbGdHSFppYVQ4cEdvUjhtZjBuQk1pdG41T0RydDRWZlhMTkszNkdWRUVadzJ6SFk3Z2pJUVhNWjJzeFhXR3NhNmZuUEpqcUIybXgweVpIeUc2enhqdF9aTTMwWldtdWxLWjhyWEVqWWpVMmdMRjUtazFQWjRrbmxRQkc4MFh6UEF3akI1ZzFB?oc=5","as_of":"2026-04-09T08:24:00.970048+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/CBMimgFBVV95cUxQZTVzSDRHSUlBQmMwbGdHSFppYVQ4cEdvUjhtZjBuQk1pdG41T0RydDRWZlhMTkszNkdWRUVadzJ6SFk3Z2pJUVhNWjJzeFhXR3NhNmZuUEpqcUIybXgweVpIeUc2enhqdF9aTTMwWldtdWxLWjhyWEVqWWpVMmdMRjUtazFQWjRrbmxRQkc4MFh6UEF3akI1ZzFB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4038d9024e821376","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:53:26.097501+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxQZTVzSDRHSUlBQmMwbGdHSFppYVQ4cEdvUjhtZjBuQk1pdG41T0RydDRWZlhMTkszNkdWRUVadzJ6SFk3Z2pJUVhNWjJzeFhXR3NhNmZuUEpqcUIybXgweVpIeUc2enhqdF9aTTMwWldtdWxLWjhyWEVqWWpVMmdMRjUtazFQWjRrbmxRQkc4MFh6UEF3akI1ZzFB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxQZTVzSDRHSUlBQmMwbGdHSFppYVQ4cEdvUjhtZjBuQk1pdG41T0RydDRWZlhMTkszNkdWRUVadzJ6SFk3Z2pJUVhNWjJzeFhXR3NhNmZuUEpqcUIybXgweVpIeUc2enhqdF9aTTMwWldtdWxLWjhyWEVqWWpVMmdMRjUtazFQWjRrbmxRQkc4MFh6UEF3akI1ZzFB?oc=5","source_event_id":"evt_4ed1a429e3d5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"49942161129c564d","published_at":"2026-04-09T04:28:33+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Michigan woman (missing)","relevance":"high","symbol":"","type":"person"},{"asset_class":"person","name":"Man arrested","relevance":"high","symbol":"","type":"person"},{"asset_class":"location","name":"Bahamas","relevance":"high","symbol":"","type":"location"},{"asset_class":"government","name":"U.S. Coast Guard","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"person","name":"Lynette Hooker","relevance":"medium","symbol":"","type":"person"}],"event_type":"conflict","information_gaps":["The article text provided is not actually the news content (it appears to be page styling/HTML), so details like the arrest date, the arrested man\u2019s identity, and the specific charges are not available here.","The exact timeline (\u201cdays after\u201d) is not quantified with a specific date in the provided material.","The cause of the disappearance (e.g., circumstances of going overboard) is not described in the provided text beyond the summary phrasing.","Whether the arrest is directly tied to the Coast Guard investigation or to police findings is not explicitly stated in the provided content."],"key_facts":["A man was arrested in the Bahamas in connection with a missing-person case involving a Michigan woman.","The Michigan woman was reported missing days earlier after an incident described as going overboard in the Bahamas.","The U.S. Coast Guard launched a criminal investigation into the disappearance (named in the provided source summary as Lynette Hooker)."],"numeric_claims":[],"primary_claim":"A man was arrested in the Bahamas days after a Michigan woman went missing at sea after reportedly going overboard.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"A man has been arrested in the Bahamas days after a Michigan woman was reported missing at sea following an incident described as going overboard. The arrest follows a police response and a U.S. Coast Guard criminal investigation into the disappearance.","topics":["arrest","missing person","maritime incident","Bahamas","criminal investigation","U.S. Coast Guard"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Man Is Arrested in Bahamas Days After Michigan Woman Goes Missing The New York Times Husband arrested after woman reported missing, went overboard in Bahamas: Police Yahoo What we know about the recovery mission for American woman who reportedly fell overboard in the Bahamas WVTM American woman missing at sea after going overboard on dinghy in the Bahamas: Police ABC News U.S. Coast Guard Launches Criminal Investigation Into Disappearance of Lynette Hooker in the Bahamas People.com","title":"Man Is Arrested in Bahamas Days After Michigan Woman Goes Missing - The New York Times","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 9350 in events