SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

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_25aa0f13b2fc in signals