About this Dataset

Cash Assistance And SNAP Cases Reopenings

Cash Assistance and SNAP case reopenings ordered by NYS Welfare Management System (WMS) closing reason code. The total number of instances during the specified quarter and year in which a case was reopened within three months of ongoing Cash Assistance or SNAP termination and was reopened for the same type of ongoing cash assistance or SNAP. This data is ordered by the NYS Welfare Management System (WMS) closing reason code that was used to close the case prior to the case reopening. 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:42:23.317654
Tags: cash-assistance-case-reopenings, snap-case-reopenings

Tables

Table 1

@usgov.city_of_new_york_cash_assistance_and_snap_cases_reopenings.table_1

196.07 kB
2,046 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)
);