Home › Sources › datasf_behavioral_health_service_directory_context
DataSF Behavioral Health and Substance Use Service Directory Context
Source ID datasf_behavioral_health_service_directory_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_behavioral_health_service_directory_context |
| Name | DataSF Behavioral Health and Substance Use Service Directory Context |
| Owner | DataSF / San Francisco Department of Public Health |
| Layer | behavioral_health_sud_service_context |
| Coverage | Two DataSF DPH behavioral-health/SUD provider-directory datasets profiled: 164 service-site source rows collapsing to 157 distinct API place rows, and 1,557 individual provider rows. The prototype loads the distinct public service sites into places as behavioral_health_service_site context and promotes 41 aggregate directory metrics; individual provider rows remain sample/aggregate-only and are not loaded into API tables. |
| Formats | JSON API, CSV |
| Join keys | provider_directory, site_id, npi, program_name, legal_entity, address_line_1, zip, provider_type |
| Caveats | Service-site rows are treatment/diversion/service-capacity context, not proof that a named party used or was referred to a service., Provider-list rows include clinician names and license numbers; keep individual provider rows out of the default API and use aggregate counts for service-capacity context., Production should geocode and normalize addresses offline before neighborhood/block joins. |
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_behavioral_health_service_directory_context | socrata_service_directory_profile_and_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | nightly API updates with monthly review per source metadata; latest observed data_loaded_at values 2026-05-30 |
| Coverage | Two DataSF DPH behavioral-health/SUD provider-directory datasets profiled: 164 service-site source rows collapsing to 157 distinct API place rows, and 1,557 individual provider rows. The prototype loads the distinct public service sites into places as behavioral_health_service_site context and promotes 41 aggregate directory metrics; individual provider rows remain sample/aggregate-only and are not loaded into API tables. |
| Government Level | local_public_health |
| ID | datasf_behavioral_health_service_directory_context |
| Layer | behavioral_health_sud_service_context |
| Name | DataSF Behavioral Health and Substance Use Service Directory Context |
| Owner | DataSF / San Francisco Department of Public Health |
| Profile Status | implemented_complete_socrata_sync_worker |
| Canonical Records | place_context, court_metric, source_record |
| Caveats | Service-site rows are treatment/diversion/service-capacity context, not proof that a named party used or was referred to a service., Provider-list rows include clinician names and license numbers; keep individual provider rows out of the default API and use aggregate counts for service-capacity context., Production should geocode and normalize addresses offline before neighborhood/block joins. |
| Evidence | artifacts/source-discovery/datasf-behavioral-health-service-directory.profile.json, artifacts/source-discovery/datasf-behavioral-health-provider-sites-p6m6-pkpk.rows.json, artifacts/source-discovery/datasf-behavioral-health-provider-sites-p6m6-pkpk.profile-query.json, artifacts/source-discovery/datasf-behavioral-health-providers-msn5-73h7.sample.json, artifacts/source-discovery/datasf-behavioral-health-providers-msn5-73h7.provider-type-counts.json, data/court_metrics_raw/datasf-behavioral-health-provider-directory-metrics.json, data/court_metrics_raw/datasf-behavioral-health-provider-directory-metrics.manifest.json, scripts/profile_datasf_behavioral_health_directory_context.py, scripts/sync_datasf_behavioral_health_directory_context.py |
| Formats | JSON API, CSV |
| Join Keys | provider_directory, site_id, npi, program_name, legal_entity, address_line_1, zip, provider_type |
| Known Endpoints | Socrata /resource/p6m6-pkpk.json, Socrata /resource/msn5-73h7.json |
| Rate Limit Notes | The public site list is small enough for scheduled complete Socrata refreshes., Do not fetch or expose the complete individual provider roster by default; use aggregate provider-type counts unless policy review approves person-level display. |
| Source Urls | https://data.sfgov.org/Health-and-Social-Services/Mental-Health-MH-and-Substance-Use-Disorder-SUD-Pr/p6m6-pkpk, https://data.sfgov.org/Health-and-Social-Services/Mental-Health-MH-and-Substance-Use-Disorder-SUD-Pr/msn5-73h7 |
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_behavioral_health_service_directory_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_behavioral_health_service_directory_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON