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/CBMizAFBVV95cUxNaGw2U1F3OWJhN1RnQ1JoSXlqcVZvMnRsNmtScXlMc2pudDd5Y3diOFpfSFQ1dEZQNHVXRWpQYkoxMGM4YTFsbEd6M3dLSHdmdEhuZm5GaXA2M1lDVTItd3lBS1ZhaE9JS2h2U2JRMVJKSkh5TjJsUzhqdG5PUXNORU9IQ3V3R3JwY2FQMEwxbTJTY0lNNDZxRl9fWmYxS3VtOHFvOXlzZU1PaWRDV0hQNTNKazVDTlFXSmE3Uk40R1N5NHEtWGU5d2E0QXE?oc=5","as_of":"2026-04-09T12:52:05.951981+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/CBMizAFBVV95cUxNaGw2U1F3OWJhN1RnQ1JoSXlqcVZvMnRsNmtScXlMc2pudDd5Y3diOFpfSFQ1dEZQNHVXRWpQYkoxMGM4YTFsbEd6M3dLSHdmdEhuZm5GaXA2M1lDVTItd3lBS1ZhaE9JS2h2U2JRMVJKSkh5TjJsUzhqdG5PUXNORU9IQ3V3R3JwY2FQMEwxbTJTY0lNNDZxRl9fWmYxS3VtOHFvOXlzZU1PaWRDV0hQNTNKazVDTlFXSmE3Uk40R1N5NHEtWGU5d2E0QXE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_75fabfec09bce846","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-09T23:23:17.689272+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNaGw2U1F3OWJhN1RnQ1JoSXlqcVZvMnRsNmtScXlMc2pudDd5Y3diOFpfSFQ1dEZQNHVXRWpQYkoxMGM4YTFsbEd6M3dLSHdmdEhuZm5GaXA2M1lDVTItd3lBS1ZhaE9JS2h2U2JRMVJKSkh5TjJsUzhqdG5PUXNORU9IQ3V3R3JwY2FQMEwxbTJTY0lNNDZxRl9fWmYxS3VtOHFvOXlzZU1PaWRDV0hQNTNKazVDTlFXSmE3Uk40R1N5NHEtWGU5d2E0QXE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNaGw2U1F3OWJhN1RnQ1JoSXlqcVZvMnRsNmtScXlMc2pudDd5Y3diOFpfSFQ1dEZQNHVXRWpQYkoxMGM4YTFsbEd6M3dLSHdmdEhuZm5GaXA2M1lDVTItd3lBS1ZhaE9JS2h2U2JRMVJKSkh5TjJsUzhqdG5PUXNORU9IQ3V3R3JwY2FQMEwxbTJTY0lNNDZxRl9fWmYxS3VtOHFvOXlzZU1PaWRDV0hQNTNKazVDTlFXSmE3Uk40R1N5NHEtWGU5d2E0QXE?oc=5","source_event_id":"evt_71a3303927b4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7b1fdaf45cbdff34","published_at":"2026-04-09T10:30:14+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"regulation","name":"US FDA","relevance":"high","symbol":"","type":"regulator"},{"asset_class":"healthcare_drug","name":"Estrogen patches","relevance":"high","symbol":"","type":"drug_formulation"},{"asset_class":"healthcare","name":"Patients seeking hormone therapy","relevance":"high","symbol":"","type":"patient_group"}],"event_type":"supply_disruption","information_gaps":["The provided article text is not actually present (only page CSS/boilerplate), so details from the Reuters article body are missing.","\u201cUS FDA champions use\u201d is unclear: it is not specified whether this refers to FDA approval, endorsement, safety-warning changes, or another policy/action.","No quantitative shortage metrics (duration, affected manufacturers, fill rates, or geographic scope) are included in the provided content.","No near-term timing (e.g., weeks/months until improvement) is provided in the excerpt."],"key_facts":["Reuters headline states patients are scrambling to find estrogen patches as the shortage worsens.","The headline attributes the worsening shortage to US FDA \u201cchampions use,\u201d but the exact FDA action and causal pathway are not specified in the provided excerpt."],"numeric_claims":[],"primary_claim":"Estrogen patches are in worsening shortage, causing patients to scramble to find them.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Reuters reports that estrogen patch shortages are worsening, prompting patients to scramble to find supplies. The shortage is linked in the headline to US FDA actions described as \u201cchampions use,\u201d though the specific mechanism is not fully provided in the provided text.","topics":["estrogen patches","hormone therapy","drug shortages","FDA","women's health"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Patients scramble to find estrogen patches as shortage worsens after US FDA champions use Reuters 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 Opinion | My pharmacy ran out of estrogen gel. Then things really got heated Toronto Star","title":"Patients scramble to find estrogen patches as shortage worsens after US FDA champions use - Reuters","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_9e9daea31b02 in signals