{"main_topic":"health","sub_topic":"samhsa","topic":"treatment_facilities","key":"health/samhsa/treatment_facilities","version":"1.0.0","year_min":2021,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/treatment_facilities/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid","directory","service"],"title":"Behavioral Health Treatment Facilities (SAMHSA)","summary":"Substance use and mental health treatment facilities listed by SAMHSA in each Georgia county, by key service.","description":"How many behavioral health treatment facilities SAMHSA's National Directories list in each Georgia county and the state: facilities treating substance use, mental illness, or either, and those offering five key services (a federally certified opioid treatment program, buprenorphine, naltrexone, accepting Medicaid, telehealth), survey years 2021-2024. Each facility is placed in one county by its ZIP code.","explorer":true,"search_aliases":{"en":["rehab centers","drug rehab","treatment for drugs","addiction treatment","methadone clinics","suboxone providers","opioid treatment programs","mental health clinics","medicaid accepted treatment","SAMHSA directory"],"es":["centros de rehabilitación","tratamiento de adicciones","tratamiento para drogas","clínicas de metadona","buprenorfina","tratamiento de opioides","clínicas de salud mental","acepta medicaid","telemedicina","directorio SAMHSA"]},"source":"Substance Abuse and Mental Health Services Administration (SAMHSA), Center for Behavioral Health Statistics and Quality: National Directory of Drug and Alcohol Use Treatment Facilities and National Directory of Mental Health Treatment Facilities, Excel editions, directories 2022-2025 (N-SUMHSS 2021-2024). Public domain. ZIP-to-county placement: U.S. Census Bureau 2020 ZCTAs, ZCTA-to-county relationship file and 2020 Census populations; ZIPs that are not ZCTAs through HRSA's GeoCare Navigator ZIP Code to ZCTA Crosswalk, 2022-2024 editions (ZIP points: Esri, U.S. ZIP Code Points, via HRSA).","source_url":"https://www.samhsa.gov/data/data-we-collect/n-sumhss-national-substance-use-and-mental-health-services-survey/national-directories","endpoint":"/api/v1/health/treatment_facilities","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"N-SUMHSS survey year whose answers the directory lists: 2024 = SAMHSA's 2025 National Directories (published March 2026), back to 2021 = the 2022 directories. See year_meaning.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit FIPS code of the county the facility is placed in: the Georgia county holding most of the 2020 residents of its ZIP code's ZCTA (for a PO box or hospital ZIP, which is not a ZCTA, the ZCTA HRSA's ZIP Code to ZCTA crosswalk assigns it; ZIP points: Esri, via HRSA: 10 of 1,718 listings over the four years, 0.6%; every listing is placed). NULL on the Georgia (state) row. All 159 counties have rows, 0 where nothing is listed.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"Always NULL: facilities are counted by county. Kept for the health domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"directory","type":"string","role":"categorical","nullable":false,"label":"Directory","short_description":"Substance-use directory, mental-health directory, or either.","description":"Which SAMHSA National Directory lists the facility. substance_use = the National Directory of Drug and Alcohol Use Treatment Facilities (facilities approved by their State Substance Use Agency); mental_health = the National Directory of Mental Health Treatment Facilities; all = listed in either, a facility in both counted once (matched by us on name, program name, street and ZIP, plus a few pinned spelling variants; 136 in both in 2024). Not additive: substance_use + mental_health exceeds all by the facilities in both.","valid_values":["all","substance_use","mental_health"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"service","type":"string","role":"categorical","nullable":false,"label":"Service","short_description":"Every listed facility, or those offering a key service.","description":"all = every listed facility; otherwise the facilities whose listing shows the service: opioid_treatment_program = a federally certified opioid treatment program (OTP, code OTP: certified by SAMHSA; OTPs are the only facilities that may dispense methadone for opioid use disorder); buprenorphine = buprenorphine used in treatment (code BU); naltrexone = naltrexone used in treatment (code NU); accepts_medicaid = accepts Medicaid as payment (code MD); telehealth = offers telemedicine or telehealth therapy (code TELE). The three opioid services are recorded only in the substance-use directory, so mental_health has no rows for them. Under directory = 'all', a facility listed in both directories offers a service when either listing shows it. Not additive: one facility offers several services.","valid_values":["all","opioid_treatment_program","buprenorphine","naltrexone","accepts_medicaid","telehealth"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_facilities","type":"integer","role":"metric","nullable":true,"label":"Treatment Facilities Listed","short_description":"Behavioral health treatment facilities SAMHSA lists in the county.","description":"Number of treatment facilities SAMHSA's National Directories list in the county (or Georgia) for the directory and service: in 2024, Georgia 278 substance-use and 232 mental-health listings, 374 facilities in either. A facility counts once whatever its size. The Georgia row is the sum of the counties.","valid_values":null,"example":3,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Never NULL: the directories suppress nothing, so a county or cell with nothing listed is 0.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_facilities","numeric_filter_columns":["num_facilities"],"usage":"Star-schema fact table at state and county grain, one survey year per year. Join the counties dimension on county_fips (NULL on the Georgia row, which is the sum of the 159 counties); tract_geoid is always NULL. directory and service each have an all total, but neither adds up: a facility in both directories is counted in each (directory = 'all' counts it once), and one facility offers several services. Pin directory and service to one value each and never sum across their values. Every county has every served cell, 0 where nothing is listed. Counts add across counties, never across years. Read directly with DuckDB over Parquet.","limitations":"Directory listings, not a census of providers: counts are the facilities in SAMHSA's National Directories, which list only facilities that answered its annual N-SUMHSS survey and agreed to be listed, so a 0 means none listed. The 2024 mental-health count jumps (Georgia 138 to 232) because SAMHSA's 2025 directory lists about 70% more facilities nationally: a listing change, not real growth. Each facility is counted in one county, chosen by its ZIP code. The national mental-health directory grows from 8,319 to 14,103 listings (2023 to 2024) while the substance-use directory grows 10%, so compare mental_health counts (and directory = 'all') across 2023 and 2024 with care. Substance-use listings also need approval by the State Substance Use Agency. The placement: a facility's ZIP code is matched to the Census Bureau's 2020 ZIP Code Tabulation Area (ZCTA) and the facility is counted in the Georgia county holding most of that ZCTA's 2020 residents, never split, so a facility near a county line can be counted in the neighboring county. A facility whose ZIP is not a ZCTA (a PO box or hospital ZIP; 10 of 1,718 listings over the four years, 0.6%) is placed through HRSA's ZIP Code to ZCTA crosswalk, which assigns the ZIP the ZCTA around its ZIP point (the ZIP points are Esri's, via HRSA), from the edition of the survey year (2022-2024; 2021 uses the 2022 edition, the nearest on 2020 ZCTAs, since the 2021 edition is on 2010 ZCTAs): Extension Inc Womens Campus (a Marietta PO box), ZIP 30061, in Cobb County; Pineland BHDD Johns Place (Statesboro), ZIP 30459, in Bulloch County; Archbold Northside (Thomasville), ZIP 31799, in Thomas County. No listing stays unplaced. Each listing is one facility as SAMHSA lists it: programs at one address with different program names count separately. directory = 'all' counts a facility listed in both directories once, matched by us on name, program name, street and ZIP (plus a few pinned pairs whose two listings spell the name or street differently; 136 in both in 2024); a facility listed under different names or street spellings that we have not pinned counts twice there, and it offers a service there when either of its listings shows it (the two listings of a facility disagree on Medicaid or telehealth for 8 and 12 of them in 2024). Services come from the codes each facility reported: opioid_treatment_program, buprenorphine and naltrexone are recorded only in the substance-use directory, so mental_health has no rows for them and their directory = 'all' rows equal the substance-use rows. accepts_medicaid means Medicaid is among the payments accepted; telehealth that the facility offers telemedicine or telehealth therapy. Facilities are a count of places, not of capacity or patients. Counts are a stock as of each survey, so never add them across years. Nothing is suppressed; tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2021,2022,2023,2024],"schema_hash":"fdb125eb7e0d5ed127b4ccf7aa41ca88b7af777fca035c5c76ebb28791b5ed16","tags":["health","substance abuse and mental health services administration","treatment_facilities"],"granularity_description":"One row per year, county_fips, tract_geoid, directory, service (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM treatment_facilities WHERE year = 2024 LIMIT 100"},{"description":"Filter by directory = all","query":"SELECT * FROM treatment_facilities WHERE directory = 'all' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","states"],"default":"counties"},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"directory","kind":"categorical","column":"directory","type":"string","multi_value":true,"enum_enforced":true,"values":["all","substance_use","mental_health"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"service","kind":"categorical","column":"service","type":"string","multi_value":true,"enum_enforced":true,"values":["all","opioid_treatment_program","buprenorphine","naltrexone","accepts_medicaid","telehealth"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null}],"filter_hints":[],"non_additive":[{"column":"directory","reason":"A facility listed in both the substance-use and the mental-health directory is counted in each, so substance_use + mental_health exceeds the facilities in either; directory = 'all' counts each facility once."},{"column":"service","reason":"One facility offers several services (buprenorphine, Medicaid and telehealth, say) and is counted under each, so services never add up to the facilities; service = 'all' counts each facility once."}],"partitions":[],"value_implications":[],"year_meaning":"year is the N-SUMHSS survey year: each of SAMHSA's National Directories lists the facilities that answered SAMHSA's National Substance Use and Mental Health Services Survey of the year before, with the information they gave in it (2024 = the 2025 directories; 2023 = the 2024 directories; 2022 = the 2023 directories; 2021 = the 2022 directories; the 2025 directories were published in March 2026). Counts describe the listed facilities as of that survey, not every facility open during the year.","pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/health/treatment_facilities/values"}