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/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

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