About this Dataset

Patient Characteristics Survey (PCS): 2017

The number of persons described by survey year (2017)
reported in OMH Region‐specific totals (Region of Provider)
and three demographic characteristics of the client 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: 2020-11-12T03:59:37.842961

Tables

Table 1

@usgov.state_of_new_york_patient_characteristics_survey_pcs_2017.table_1

2.6 MB
175,926 rows
67 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,
  "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,
  "mobility_impairment_disorder" VARCHAR,
  "hearing_visual_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,
  "smokes" VARCHAR,
  "received_smoking_medication" VARCHAR,
  "received_smoking_counseling" VARCHAR,
  "serious_mental_illness" 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,
  "unknown_insurance_coverage" VARCHAR,
  "no_insurance" 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
);