About this Dataset

OTDA LIM - Lottery Intercept Match

This dataset from the Office of Temporary and Disability Assistance (OTDA) Audit public assistance (PA) recoveries through lottery intercept matches (LIM). The dataset provides information on intercepts of lottery winnings of PA recipients to repay PA benefits received, aggregated by month, year, district and total amount recovered for that district by assistance type.
Organization: State of New York
Last updated: 2020-11-12T04:00:38.056636

Tables

Table 1

@usgov.state_of_new_york_otda_lim_lottery_intercept_match.table_1

106.6 kB
7,482 rows
13 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "month" VARCHAR,
  "month_code" BIGINT,
  "district_code" BIGINT,
  "district" VARCHAR,
  "number_of_intercepts" BIGINT,
  "federally_participating_family_assistance_intercepts" DOUBLE,
  "federally_participating_safety_net_non_cash_intercepts" DOUBLE,
  "federally_non_participating_predetermined_grant_aid_to_1c78927a" DOUBLE  -- Federally Non-Participating Predetermined Grant/Aid To Dependent Children Intercepts,
  "federally_non_participating_safety_net_cash_intercepts" DOUBLE,
  "federally_non_participating_safety_net_non_cash_intercepts" DOUBLE,
  "emergency_assistance_for_families_intercepts" DOUBLE,
  "excess_intercepts" DOUBLE
);