Mental Health (MH) And Substance Use Disorder (SUD) Provider Directory - Provider List by US Government | Healthcare

About this Dataset

Mental Health (MH) And Substance Use Disorder (SUD) Provider Directory - Provider List

A. SUMMARY This dataset contains information of Mental Health (MH) and Substance Use Disorder (SUD) programs / sites. It serves as provider directory for the general public to know and search for MH and SUD programs / sites contracted with the City and County of San Francisco. B. HOW THE DATASET IS CREATED The dataset is pulled from our electronic systems. C. UPDATE PROCESS The dataset is updated nightly through sf.gov through Application Programming Interface (API) whenever there are changes. There is monthly review and tracking. D. HOW TO USE THIS DATASET There are filters for some data fields for quick search. For example, if we want to search all MH and SUD programs that serve women, we would use the Gender filter and select “Women” and “All”. E. RELATED DATASETS
Organization: City of San Francisco
Last updated: 2025-03-29T17:04:48.927482

Tables

Table 1

@usgov.city_of_san_francisco_mental_health_mh_and_substance_u_30d425ad.table_1

48.15 KB
1500 rows
12 columns


CREATE TABLE table_1 (
  "provider_directory" VARCHAR,
  "site_id" BIGINT,
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "provider_type" VARCHAR,
  "state_license_number" VARCHAR,
  "languages" VARCHAR,
  "cultural_competency_training" VARCHAR,
  "data_as_of" VARCHAR,
  "data_updated_at" VARCHAR,
  "data_loaded_at" VARCHAR
);