About this Dataset

Patient Characteristics Survey (PCS): 2019

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, 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: 2021-08-06T15:26:20.079162
Tags: mental-health, planning, psychiatric

Tables

Table 1

@usgov.state_of_new_york_patient_characteristics_survey_pcs_2019.table_1

3.2 MB
196,102 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" BOOLEAN,
  "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" BOOLEAN,
  "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
);