About this Dataset

Cash Assistance And SNAP Cases Rejections

Cash Assistance and SNAP case rejections ordered by NYS Welfare Management System (WMS) rejection reason code. When a Cash Assistance or SNAP application is rejected, NYS Welfare Management System (WMS) records the reason for the rejection using a reason code. This file includes the count of all Cash Assistance and SNAP case rejections during the specified quarter and year, with the different NYS WMS rejection reason codes in the rows. Each record is one case which may include one or many recipients. NOTE: Because asterisks represent values between 1 and 10, users should not sum values across columns or rows to determine the total number of cases within a quarter. Accurate totals are represented in the rows and columns labeled “Total”.
Organization: City of New York
Last updated: 2023-07-16T03:09:13.178193
Tags: cash-assistance-case-rejections, snap-case-rejections

Tables

Table 1

@usgov.city_of_new_york_cash_assistance_and_snap_cases_rejections.table_1

262.66 kB
2,207 rows
75 columns

CREATE TABLE table_1 (
  "nys_wms_rejection_code" VARCHAR,
  "type_of_government_assistance" VARCHAR,
  "calendar_year" BIGINT,
  "date" VARCHAR,
  "total" VARCHAR,
  "n_18_24" VARCHAR  -- 18-24,
  "n_25_44" VARCHAR  -- 25-44,
  "n_45_64" VARCHAR  -- 45-64,
  "n_65" VARCHAR  -- 65+,
  "cd_01" VARCHAR,
  "cd_02" VARCHAR,
  "cd_03" VARCHAR,
  "cd_04" VARCHAR,
  "cd_05" VARCHAR,
  "cd_06" VARCHAR,
  "cd_07" VARCHAR,
  "cd_08" VARCHAR,
  "cd_09" VARCHAR,
  "cd_10" VARCHAR,
  "cd_11" VARCHAR,
  "cd_12" VARCHAR,
  "cd_13" VARCHAR,
  "cd_14" VARCHAR,
  "cd_15" VARCHAR,
  "cd_16" VARCHAR,
  "cd_17" VARCHAR,
  "cd_18" VARCHAR,
  "cd_19" VARCHAR,
  "cd_20" VARCHAR,
  "cd_21" VARCHAR,
  "cd_22" VARCHAR,
  "cd_23" VARCHAR,
  "cd_24" VARCHAR,
  "cd_25" VARCHAR,
  "cd_26" VARCHAR,
  "cd_27" VARCHAR,
  "cd_28" VARCHAR,
  "cd_29" VARCHAR,
  "cd_30" VARCHAR,
  "cd_31" VARCHAR,
  "cd_32" VARCHAR,
  "cd_33" VARCHAR,
  "cd_34" VARCHAR,
  "cd_35" VARCHAR,
  "cd_36" VARCHAR,
  "cd_37" VARCHAR,
  "cd_38" VARCHAR,
  "cd_39" VARCHAR,
  "cd_40" VARCHAR,
  "cd_41" VARCHAR,
  "cd_42" VARCHAR,
  "cd_43" VARCHAR,
  "cd_44" VARCHAR,
  "cd_45" VARCHAR,
  "cd_46" VARCHAR,
  "cd_47" VARCHAR,
  "cd_48" VARCHAR,
  "cd_49" VARCHAR,
  "cd_50" VARCHAR,
  "cd_51" VARCHAR,
  "unknown_cd" VARCHAR,
  "african_american" VARCHAR,
  "asian" VARCHAR,
  "caucasian" VARCHAR,
  "hispanic" VARCHAR,
  "multi_ethnic" VARCHAR,
  "native_american" VARCHAR,
  "pacific_islander" VARCHAR,
  "unknown_race" VARCHAR,
  "female" VARCHAR,
  "male" VARCHAR,
  "has_limited_english_proficiency_yes" VARCHAR  -- Has Limited English Proficiency (Yes),
  "has_limited_english_proficiency_no" VARCHAR  -- Has Limited English Proficiency (No),
  "has_reasonable_accommodation_yes" VARCHAR  -- Has Reasonable Accommodation (Yes),
  "has_reasonable_accommodation_no" VARCHAR  -- Has Reasonable Accommodation (No)
);