About this Dataset

Cash Assistance And SNAP Cases Closed

Cash Assistance and SNAP case closings ordered by NYS Welfare Management System (WMS) closing reason code. When an active Cash Assistance or SNAP case is closed, NYS Welfare Management System (WMS) records the reason for the closure using a reason code. This file includes the count of all Cash Assistance and SNAP case closings during the specified quarter and year, with the different NYS WMS closing 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-16T02:41:21.835593
Tags: cash-assistance-case-closings, snap-case-closings

Tables

Table 1

@usgov.city_of_new_york_cash_assistance_and_snap_cases_closed.table_1

306.77 kB
2,871 rows
75 columns

CREATE TABLE table_1 (
  "nys_wms_closing_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)
);