Name: Local Mental Health Programs
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Local Mental Health Programs

Includes programs that are licensed by the Office of Mental Health (OMH) and programs that are funded by OMH but do not need a license to operate.
Organization: State of New York
Last updated: 2020-11-12T03:59:33.014131
Tags: emergency-services, inpatient-services, outpatient-services, support-programs

Tables

Table 1

@usgov.state_of_new_york_local_mental_health_programs.table_1

425.07 kB
6,484 rows
26 columns

CREATE TABLE table_1 (
  "row_created_date_time" VARCHAR,
  "n__sponsor_name" VARCHAR  -- Sponsor Name,
  "n__sponsor_code" BIGINT  -- Sponsor Code,
  "n__agency_name" VARCHAR  -- Agency Name,
  "n__agency_code" BIGINT  -- Agency Code,
  "facility_name" VARCHAR,
  "n__facility_code" BIGINT  -- Facility Code,
  "n__program_name" VARCHAR  -- Program Name,
  "n__program_code" BIGINT  -- Program Code,
  "n__populations_served" VARCHAR  -- Populations Served,
  "n__agency_phone" VARCHAR  -- Agency Phone,
  "n__program_phone" VARCHAR  -- Program Phone,
  "n__program_address_1" VARCHAR  -- Program Address 1,
  "n__program_address_2" VARCHAR  -- Program Address 2,
  "n__program_city" VARCHAR  -- Program City,
  "n__program_state" VARCHAR  -- Program State,
  "n__program_zip" VARCHAR  -- Program Zip,
  "n__operating_certificate_required" VARCHAR  -- Operating Certificate Required?,
  "n__program_tier" DOUBLE  -- Program Tier,
  "n__operating_certificate_duration" DOUBLE  -- Operating Certificate Duration,
  "n__program_county" VARCHAR  -- Program County,
  "n__program_region" VARCHAR  -- Program Region,
  "n__program_type_description" VARCHAR  -- Program Type Description,
  "n__program_category_description" VARCHAR  -- Program Category Description,
  "n__program_subcategory_description" VARCHAR  -- Program Subcategory Description,
  "georeference" VARCHAR
);