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-08T19:34:52.569167+00:00","dedupe_key":"signal_enriched:news_delta:cba323b8aa17b834","evidence_event_ids":["evt_539b55ce0ee9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQWllqWXJiYm53Y3R4NEtDSzRJMXRjMkxjQ3F3VzNCWjRSXzFWXzg5MHIxeVBrOVE2YjNsNDMzTTJMYXVuN1pEbVJ4bDc4bjFtaUxuYVk5Y19BckwwT0VMb1FqTy16Z0lXd0xNUy0yVDlUcGVkYUp5NS11bldibjdKVGNsTHM2STkyNE1SZjVmWlBLdThlQWNjUldEbmdwdHpNbWNBNFhWREJNTTN3QmZzUmE5dU82bjZoY1I0?oc=5","as_of":"2026-04-08T19:34:52.569167+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/CBMiuwFBVV95cUxQWllqWXJiYm53Y3R4NEtDSzRJMXRjMkxjQ3F3VzNCWjRSXzFWXzg5MHIxeVBrOVE2YjNsNDMzTTJMYXVuN1pEbVJ4bDc4bjFtaUxuYVk5Y19BckwwT0VMb1FqTy16Z0lXd0xNUy0yVDlUcGVkYUp5NS11bldibjdKVGNsTHM2STkyNE1SZjVmWlBLdThlQWNjUldEbmdwdHpNbWNBNFhWREJNTTN3QmZzUmE5dU82bjZoY1I0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_93e10dfa252ba5c9","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:09:19.304988+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQWllqWXJiYm53Y3R4NEtDSzRJMXRjMkxjQ3F3VzNCWjRSXzFWXzg5MHIxeVBrOVE2YjNsNDMzTTJMYXVuN1pEbVJ4bDc4bjFtaUxuYVk5Y19BckwwT0VMb1FqTy16Z0lXd0xNUy0yVDlUcGVkYUp5NS11bldibjdKVGNsTHM2STkyNE1SZjVmWlBLdThlQWNjUldEbmdwdHpNbWNBNFhWREJNTTN3QmZzUmE5dU82bjZoY1I0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxQWllqWXJiYm53Y3R4NEtDSzRJMXRjMkxjQ3F3VzNCWjRSXzFWXzg5MHIxeVBrOVE2YjNsNDMzTTJMYXVuN1pEbVJ4bDc4bjFtaUxuYVk5Y19BckwwT0VMb1FqTy16Z0lXd0xNUy0yVDlUcGVkYUp5NS11bldibjdKVGNsTHM2STkyNE1SZjVmWlBLdThlQWNjUldEbmdwdHpNbWNBNFhWREJNTTN3QmZzUmE5dU82bjZoY1I0?oc=5","source_event_id":"evt_539b55ce0ee9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ca300315af7f840e","published_at":"2026-04-08T11:00:07+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"regulatory_agency","name":"U.S. Food and Drug Administration (FDA)","relevance":"high","symbol":"","type":"regulator"},{"asset_class":"healthcare_drugs","name":"Hormone drugs / hormone therapy (HRT)","relevance":"high","symbol":"","type":"drug_category"},{"asset_class":"healthcare_drugs","name":"Estrogen patches","relevance":"medium","symbol":"","type":"drug_formulation"},{"asset_class":"population","name":"Women seeking hormone therapy","relevance":"medium","symbol":"","type":"patient_group"}],"event_type":"regulation","information_gaps":["Which specific hormone drugs/products are covered by the $6.3B figure is not stated in the provided text.","The timing/date of the FDA action (when the safety warnings were removed) is not provided.","The mechanism of the \u201ccomeback\u201d (e.g., stock price, sales, market size) is not specified in the provided text.","The source summary references multiple outlets (NYT, PBS, Pharmacy Magazine, KCLU), but the exact relationship between those items and the Bloomberg claim is not fully detailed here."],"key_facts":["Bloomberg headline states hormone drugs are making a $6.3 billion comeback after the FDA nixes safety warnings.","The provided source summary includes an additional claim that estrogen patches face shortage as more women seek hormone therapy.","The provided source summary includes an additional claim that many women relying on an estrogen patch are struggling to have prescriptions filled."],"numeric_claims":[{"label":"comeback_amount_usd","value":"$6.3 billion"}],"primary_claim":"The FDA removed safety warnings for hormone drugs, enabling a reported $6.3 billion comeback.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Bloomberg reports that hormone drugs are seeing a $6.3B \u201ccomeback\u201d after the FDA removed (nixed) safety warnings, improving the outlook for hormone therapy products. The signal also notes potential near-term supply/availability issues for estrogen patches as demand rises.","topics":["FDA safety warnings","hormone replacement therapy (HRT)","estrogen patches","drug safety communications","demand/supply dynamics"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Hormone Drugs Make $6.3 Billion Comeback After FDA Nixes Safety Warnings Bloomberg.com Opinion | Hormones Don\u2019t Need to Make You Live Longer to Be Worth It The New York Times Estrogen patches face shortage as more women seek hormone therapy PBS Hormone replacement therapy (HRT): risks, benefits and choices Pharmacy Magazine Many women who rely on an estrogen patch are struggling to have their prescriptions filled KCLU","title":"Hormone Drugs Make $6.3 Billion Comeback After FDA Nixes Safety Warnings - Bloomberg.com","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 8323 in events