Home › Sources › datasf_public_health_overdose_substance_context
DataSF Public Health Overdose and Substance Use Context
Source ID datasf_public_health_overdose_substance_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_public_health_overdose_substance_context |
| Name | DataSF Public Health Overdose and Substance Use Context |
| Owner | DataSF / San Francisco Department of Public Health / Office of the Chief Medical Examiner |
| Layer | public_health_drug_overdose_context |
| Coverage | Four aggregate DataSF public-health datasets profiled and fully fetched because each table is small: 76 monthly preliminary overdose-death rows, 191 weekly overdose-related EMS/911 rows, 25 annual race/ethnicity overdose death-rate rows, and 74 substance-use service rows. The parser promotes 391 aggregate metric rows into court_metrics; latest observed data_as_of is 2026-05-20 for overdose deaths and substance-use services, 2026-04-10 for EMS/911 rows, and 2025-08-15 for race/ethnicity death-rate rows. |
| Formats | JSON API, CSV |
| Join keys | month_start_date, week_start_date, year, race_ethnicity, reporting_period_start_date, data_through_date, service_category, metric |
| Caveats | Rows are aggregate public-health context only, not court outcomes, individual case facts, medical examiner records, patient records, or proof of individual overdose involvement., The overdose-related EMS/911 source publishes an undercount warning for March 2026 onward; retain row-level errata in API responses., Use to normalize and contextualize drug-charge, diversion, treatment, and neighborhood/time-period searches without inferring facts about named parties. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | datasf_public_health_overdose_substance_context | socrata_public_health_metric_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | open-data refresh; profile probes observed data_loaded_at values through 2026-05-20 for most selected datasets |
| Coverage | Four aggregate DataSF public-health datasets profiled and fully fetched because each table is small: 76 monthly preliminary overdose-death rows, 191 weekly overdose-related EMS/911 rows, 25 annual race/ethnicity overdose death-rate rows, and 74 substance-use service rows. The parser promotes 391 aggregate metric rows into court_metrics; latest observed data_as_of is 2026-05-20 for overdose deaths and substance-use services, 2026-04-10 for EMS/911 rows, and 2025-08-15 for race/ethnicity death-rate rows. |
| Government Level | local_public_health |
| ID | datasf_public_health_overdose_substance_context |
| Layer | public_health_drug_overdose_context |
| Name | DataSF Public Health Overdose and Substance Use Context |
| Owner | DataSF / San Francisco Department of Public Health / Office of the Chief Medical Examiner |
| Profile Status | implemented_complete_socrata_sync_worker |
| Canonical Records | court_metric, source_record |
| Caveats | Rows are aggregate public-health context only, not court outcomes, individual case facts, medical examiner records, patient records, or proof of individual overdose involvement., The overdose-related EMS/911 source publishes an undercount warning for March 2026 onward; retain row-level errata in API responses., Use to normalize and contextualize drug-charge, diversion, treatment, and neighborhood/time-period searches without inferring facts about named parties. |
| Evidence | artifacts/source-discovery/datasf-public-health-overdose-context.profile.json, artifacts/source-discovery/datasf-preliminary-overdose-deaths-jxrr-bmra.sample.json, artifacts/source-discovery/datasf-overdose-related-911-ems-ed3a-sn39.sample.json, artifacts/source-discovery/datasf-overdose-death-rate-race-k4g8-b3sf.sample.json, artifacts/source-discovery/datasf-substance-use-services-ubf6-e57x.sample.json, data/court_metrics_raw/datasf-public-health-overdose-substance-metrics.json, data/court_metrics_raw/datasf-public-health-overdose-substance-metrics.manifest.json, scripts/profile_datasf_public_health_overdose_context.py, scripts/sync_datasf_public_health_overdose_context.py |
| Formats | JSON API, CSV |
| Join Keys | month_start_date, week_start_date, year, race_ethnicity, reporting_period_start_date, data_through_date, service_category, metric |
| Known Endpoints | Socrata /resource/jxrr-bmra.json, Socrata /resource/ed3a-sn39.json, Socrata /resource/k4g8-b3sf.json, Socrata /resource/ubf6-e57x.json |
| Rate Limit Notes | The four selected aggregate tables are small enough for scheduled complete Socrata refreshes with validation., Do not fetch or expose person-level medical examiner, patient, or EMS response records for this context lane. |
| Source Urls | https://data.sfgov.org/Health-and-Social-Services/Preliminary-Unintentional-Drug-Overdose-Deaths/jxrr-bmra, https://data.sfgov.org/Health-and-Social-Services/Overdose-Related-911-Responses-by-Emergency-Medica/ed3a-sn39, https://data.sfgov.org/Health-and-Social-Services/Unintentional-Drug-Overdose-Death-Rate-by-Race-Eth/k4g8-b3sf, https://data.sfgov.org/Health-and-Social-Services/San-Francisco-Department-of-Public-Health-Substan/ubf6-e57x |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/datasf_public_health_overdose_substance_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_public_health_overdose_substance_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON