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/CBMif0FVX3lxTE5fYzBaaTd1RDMwUXJ3N0xpeVY4eDM5Q2I2cHY3eHBoZVpoaUJXNjlFS0RLOE83RHJ1U0NsSGVwelJ4M2Z6eWpEbldFYVRpVk9ESlRHTGpQYWk4ZVVvV1JDQkZvTEItVXJ3cWJUbGlqbV9tZVVvdFE4R0RpWEg3Vzg?oc=5","as_of":"2026-04-08T03:31:26.609662+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/CBMif0FVX3lxTE5fYzBaaTd1RDMwUXJ3N0xpeVY4eDM5Q2I2cHY3eHBoZVpoaUJXNjlFS0RLOE83RHJ1U0NsSGVwelJ4M2Z6eWpEbldFYVRpVk9ESlRHTGpQYWk4ZVVvV1JDQkZvTEItVXJ3cWJUbGlqbV9tZVVvdFE4R0RpWEg3Vzg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6a4b760870453346","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-08T03:49:42.262129+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE5fYzBaaTd1RDMwUXJ3N0xpeVY4eDM5Q2I2cHY3eHBoZVpoaUJXNjlFS0RLOE83RHJ1U0NsSGVwelJ4M2Z6eWpEbldFYVRpVk9ESlRHTGpQYWk4ZVVvV1JDQkZvTEItVXJ3cWJUbGlqbV9tZVVvdFE4R0RpWEg3Vzg?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/CBMif0FVX3lxTE5fYzBaaTd1RDMwUXJ3N0xpeVY4eDM5Q2I2cHY3eHBoZVpoaUJXNjlFS0RLOE83RHJ1U0NsSGVwelJ4M2Z6eWpEbldFYVRpVk9ESlRHTGpQYWk4ZVVvV1JDQkZvTEItVXJ3cWJUbGlqbV9tZVVvdFE4R0RpWEg3Vzg?oc=5","source_event_id":"evt_5c2674d66e48","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b01d62d38640caf8","published_at":"2026-04-07T22:52:02+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Michigan woman (missing)","relevance":"primary","symbol":"","type":"person"},{"asset_class":"person","name":"Husband of missing woman","relevance":"secondary","symbol":"","type":"person"},{"asset_class":"government","name":"Bahamas officials","relevance":"secondary","symbol":"","type":"organization"},{"asset_class":"media","name":"The New York Times","relevance":"source","symbol":"","type":"organization"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided contains no readable narrative details beyond page styling; only the headline and external source summary were available.","The woman\u2019s name, exact location (island/coordinates), date/time of the incident, and current status of the search/recovery are not present in the provided text.","No confirmation is provided here that the fall overboard account is independently verified by authorities (only attributed to the husband).","No details are provided on whether the boat was anchored or moving, weather/sea conditions, or whether any search assets (air/sea) were deployed."],"key_facts":["A Michigan woman is reported missing in the Bahamas.","The husband says she fell overboard from a boat during a Bahamas trip.","Officials are conducting search efforts and shifting toward recovery (per the provided source summary)."],"numeric_claims":[],"primary_claim":"A Michigan woman is missing in the Bahamas after falling off a boat, according to her husband\u2019s account, and officials are conducting search/recovery efforts.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"A Michigan woman is reported missing in the Bahamas after her husband says she fell overboard from a boat. Authorities are shifting toward recovery efforts as the search continues.","topics":["missing person","maritime incident","Bahamas","search and recovery","overboard"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Michigan Woman Missing in the Bahamas After Falling Off a Boat The New York Times Search turns to recovery for American woman whose husband says she fell overboard in Bahamas, officials say CNN American couple chasing retirement dream in Bahamas boating mystery were 'inexperienced': Friend Fox News American woman missing in Bahamas identified as Michigan mom NewsNation American woman missing after husband reports she fell overboard during Bahamas trip NBC News","title":"Michigan Woman Missing in the Bahamas After Falling Off a Boat - The New York Times","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_bfc3b423d817 in signals