About this Dataset

Patient Characteristics Survey (PCS) 2022: Persons Served By Survey Year, Region Of Provider, Gender, Age Group And Race/Ethnicity

The data are organized by OMH Region‐specific (Region of Provider), program type, and by the following demographic characteristics of the clients served during the week of the survey: sex (Male, Female, X (Non-binary), and Unknown), Transgender (No, Not Transgender; Yes, Transgender and Unknown), age (below 17 (Child), 18 and above(Adult) and unknown age) and race (White only, Black Only, Multi‐racial, Other and Unknown race) and ethnicity (Non‐Hispanic, Hispanic, Client Did Not Answer and Unknown). Persons with Hispanic ethnicity are grouped as “Hispanic,” regardless of race or races reported.
Organization: State of New York
Last updated: 2022-10-06T21:30:06.070148
Tags: mental-health, planning, psychiatric

Tables

Table 1

@usgov.state_of_new_york_patient_characteristics_survey_pcs_2_c55171d3.table_1

3.35 MB
206,612 rows
76 columns

CREATE TABLE table_1 (
  "survey_year" BIGINT,
  "program_category" VARCHAR,
  "region_served" VARCHAR,
  "age_group" VARCHAR,
  "sex" VARCHAR,
  "transgender" VARCHAR,
  "sexual_orientation" VARCHAR,
  "hispanic_ethnicity" VARCHAR,
  "race" VARCHAR,
  "living_situation" VARCHAR,
  "household_composition" VARCHAR,
  "preferred_language" VARCHAR,
  "religious_preference" VARCHAR,
  "veteran_status" VARCHAR,
  "employment_status" VARCHAR,
  "number_of_hours_worked_each_week" VARCHAR,
  "education_status" VARCHAR,
  "special_education_services" VARCHAR,
  "mental_illness" VARCHAR,
  "intellectual_disability" VARCHAR,
  "autism_spectrum" VARCHAR,
  "other_developmental_disability" VARCHAR,
  "alcohol_related_disorder" VARCHAR,
  "drug_substance_disorder" VARCHAR,
  "opioid_related_disorder" VARCHAR,
  "mobility_impairment_disorder" VARCHAR,
  "hearing_impairment" VARCHAR,
  "visual_impairment" VARCHAR,
  "speech_impairment" VARCHAR,
  "hyperlipidemia" VARCHAR,
  "high_blood_pressure" VARCHAR,
  "diabetes" VARCHAR,
  "obesity" VARCHAR,
  "heart_attack" VARCHAR,
  "stroke" VARCHAR,
  "other_cardiac" VARCHAR,
  "pulmonary_asthma" VARCHAR,
  "alzheimer_or_dementia" VARCHAR,
  "kidney_disease" VARCHAR,
  "liver_disease" VARCHAR,
  "endocrine_condition" VARCHAR,
  "neurological_condition" VARCHAR,
  "traumatic_brain_injury" VARCHAR,
  "joint_disease" VARCHAR,
  "cancer" VARCHAR,
  "other_chronic_med_condition" VARCHAR,
  "no_chronic_med_condition" VARCHAR,
  "unknown_chronic_med_condition" VARCHAR,
  "cannabis_recreational_use" VARCHAR,
  "cannabis_medicinal_use" VARCHAR,
  "smokes" VARCHAR,
  "received_smoking_medication" VARCHAR,
  "received_smoking_counseling" VARCHAR,
  "serious_mental_illness" VARCHAR,
  "alcohol_12m_service" VARCHAR,
  "opioid_12m_service" VARCHAR,
  "drug_substance_12m_service" VARCHAR,
  "principal_diagnosis_class" VARCHAR,
  "additional_diagnosis_class" VARCHAR,
  "ssi_cash_assistance" VARCHAR,
  "ssdi_cash_assistance" VARCHAR,
  "veterans_disability_benefits" VARCHAR,
  "veterans_cash_assistance" VARCHAR,
  "public_assistance_cash_program" VARCHAR,
  "other_cash_benefits" VARCHAR,
  "medicaid_and_medicare_insurance" VARCHAR,
  "no_insurance" VARCHAR,
  "unknown_insurance_coverage" VARCHAR,
  "medicaid_insurance" VARCHAR,
  "medicaid_managed_insurance" VARCHAR,
  "medicare_insurance" VARCHAR,
  "private_insurance" VARCHAR,
  "child_health_plus_insurance" VARCHAR,
  "other_insurance" VARCHAR,
  "criminal_justice_status" VARCHAR,
  "three_digit_residence_zip_code" BIGINT
);