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-17T11:14:13.026874+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:f219dfc207af3dfc","evidence_event_ids":["evt_a64e931e24d3"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/3-things-you-must-know-about-social-security-if-you-plan-retire-next-10-years","as_of":"2026-04-17T11:14:13.026874+00:00","canonical_url":"https://www.fool.com/retirement/2026/04/17/3-things-you-must-know-about-social-security-if-yo/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-things-you-must-know-about-social-security-if-you-plan-retire-next-10-years","article_chars":3850,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0e33e0956efa291c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/retirement/2026/04/17/3-things-you-must-know-about-social-security-if-yo/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T22:22:29.929792+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsSocial Security was only intended to replace about 40% of pre-retirement income.","fetched_title":"3 Things You Must Know About Social Security If You Plan to Retire in the Next 10 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-things-you-must-know-about-social-security-if-you-plan-retire-next-10-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-things-you-must-know-about-social-security-if-you-plan-retire-next-10-years","source_event_id":"evt_a64e931e24d3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0936b1293abf52ce","kind":"unusual_volume","published_at":"2026-04-17T10:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"government_program","name":"Social Security","relevance":"high","symbol":"","type":"program"},{"asset_class":"government_agency","name":"Social Security Administration","relevance":"medium","symbol":"","type":"agency"}],"event_type":"macro_policy","information_gaps":["No unusual trading volume data is provided in the signal text (baseline volume, current volume, volume ratio, ticker, and direction are missing).","No explicit confirmation is provided that the claims are based on specific news events; the text presents general statements and projections without citing sources in the excerpt.","The article\u2019s catalyst hypothesis for any market/volume move cannot be determined because no ticker or volume metrics are included.","The $23,760 figure is mentioned without the underlying strategy or calculation details in the provided text."],"key_facts":["Social Security was intended to replace about 40% of pre-retirement income for average earners.","High earners might receive a bit less, while low earners might receive a bit more.","The article states that Social Security benefits are based on average monthly earnings indexed for inflation over a person\u2019s 35 highest-earning years.","Benefits are then plugged into a formula that applies to the person\u2019s birth year.","The benefit amount is adjusted up or down based on when the person decides to claim.","The article states Social Security is a few years away from insolvency and that the program may look different in a decade.","The article says possible future changes could include increasing Social Security taxes on workers and/or benefit taxes on seniors, and/or reducing available benefits.","The article states the $23,760 Social Security bonus most retirees overlook, but does not provide the calculation details in the provided text."],"numeric_claims":[{"label":"income replacement target (average earners)","value":"~40% of pre-retirement income"},{"label":"earnings years used for benefit calculation","value":"35 highest-earning years"},{"label":"example bonus amount mentioned","value":"$23,760"}],"primary_claim":"Social Security was only intended to replace about 40% of pre-retirement income for average earners.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article explains how Social Security is intended to replace about 40% of pre-retirement income, how benefits are calculated from a worker\u2019s 35 highest earnings years, and that Social Security is projected to face insolvency within a few years, potentially changing benefits in the future.","topics":["retirement planning","Social Security benefits","benefit calculation","insolvency risk","claiming age"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSocial Security was only intended to replace about 40% of pre-retirement income.","tickers":[],"title":"3 Things You Must Know About Social Security If You Plan to Retire in the Next 10 Years","url":"https://www.fool.com/retirement/2026/04/17/3-things-you-must-know-about-social-security-if-yo/"}}

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