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-09T12:08:05.625638+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:cf653705ec9f8cee","evidence_event_ids":["evt_1e6bf0d1d68a"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/you-might-regret-ignoring-social-security-strategy-especially-if-youre-married","as_of":"2026-04-09T12:08:05.625638+00:00","canonical_url":"https://www.fool.com/retirement/2026/04/09/you-might-regret-ignoring-this-social-security-str/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/you-might-regret-ignoring-social-security-strategy-especially-if-youre-married","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1db998261a819dab","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/retirement/2026/04/09/you-might-regret-ignoring-this-social-security-str/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:25:23.048573+00:00","extraction_method":"heuristic","fetched_description":"Key PointsYou get a choice when it comes to claiming Social Security.","fetched_title":"You Might Regret Ignoring This Social Security Strategy -- Especially If You're Married | Nasdaq","final_url":"https://www.nasdaq.com/articles/you-might-regret-ignoring-social-security-strategy-especially-if-youre-married","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/you-might-regret-ignoring-social-security-strategy-especially-if-youre-married","source_event_id":"evt_1e6bf0d1d68a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6b718d16b6ab518b","kind":"unusual_volume","published_at":"2026-04-09T10:56:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 09, 2026 \u2014 06:56 am EDT"],"entities":[{"asset_class":"government_benefit","name":"Social Security","relevance":"primary topic","symbol":"","type":"program"},{"asset_class":"media","name":"The Motley Fool","relevance":"source","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No unusual trading/market volume data is provided in the text (no ticker, no volume ratio vs average, no direction).","The signal type 'discovery_unusual_volume_delta' is not supported by the provided article content; the article appears to be personal finance/retirement advice rather than market-volume reporting.","No explicit catalyst is described for any market/asset; the only 'catalyst' discussed is a retirement-claiming decision (behavioral/financial strategy), not a market event."],"key_facts":["Earliest age to claim Social Security is 62.","Full retirement age is 67 for people born in 1960 or later (per article).","If you delay claiming past full retirement age, benefits increase by 8% for each year you wait until age 70 (per article).","The article states that survivor benefits for a spouse should equal the amount the higher earner received while alive (per article).","The article claims a delayed claim until 70 could leave a spouse with larger survivor benefits if the higher earner dies first (per article).","The article references a '$23,760 Social Security bonus' most retirees overlook (per article), described as potentially payable 'each year' (per article)."],"numeric_claims":[{"label":"Delayed benefit increase","value":"8% per year for each year delayed past full retirement age until age 70 (per article)"},{"label":"Full retirement age (born 1960+)","value":"67 (per article)"},{"label":"Potential bonus figure mentioned","value":"$23,760 (per article)"}],"primary_claim":"Delaying Social Security benefits past full retirement age provides an 8% boost per year for each year delayed until age 70, and can increase survivor benefits for a spouse.","relevance_score":0.15,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article argues that delaying Social Security claiming past full retirement age (up to age 70) increases monthly benefits for life, and that this can also increase survivor benefits for a spouse.","topics":["Social Security claiming strategy","full retirement age","delayed retirement credits","survivor benefits","retirement planning"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsYou get a choice when it comes to claiming Social Security.","tickers":[],"title":"You Might Regret Ignoring This Social Security Strategy -- Especially If You're Married","url":"https://www.fool.com/retirement/2026/04/09/you-might-regret-ignoring-this-social-security-str/"}}

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 11154 in events