About this Dataset

Rural Development Obligations And Disbursements (non ARRA) - September 2016

In accordance with the Federal Funding Accountability and Transparency Act of 2006 (FFATA) and the American Recovery and Reinvestment Act of 2009 (ARRA), this downloadable file identifies Rural Development non-ARRA program obligations for September 2016.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:08.133068
Tags: agriculture, agriculture-and-rural-development, american-recovery-and-reinvestment, arra, assistance, data, disbursement, faad, fain, federal-award-identifier-number, ffata, funding, obligations, recovery-act, rural, rural-development, usda

Tables

Non-Stimulus Obligations And Disbursements

@usgov.usda_gov_rural_development_obligations_and_disbursemen_423666d4.non_stimulus_obligations_and_disbursements

52.42 kB
156 rows
50 columns

CREATE TABLE non_stimulus_obligations_and_disbursements (
  "n__cfda" DOUBLE  -- #CFDA,
  "st_appl_id" VARCHAR,
  "rcpt_id" VARCHAR,
  "rcpt_prnt_id" VARCHAR,
  "rcpt_nm" VARCHAR,
  "rcpt_st_addr1" VARCHAR,
  "rcpt_st_addr2" VARCHAR,
  "rcpt_city_cd" BIGINT,
  "rcpt_city_nm" VARCHAR,
  "rcpt_cty_cd" BIGINT,
  "rcpt_cty_nm" VARCHAR,
  "rcpt_st_cd" BIGINT,
  "rcpt_st_abbr" VARCHAR,
  "rcpt_zip_cd" BIGINT,
  "rcpt_ctry_cd" VARCHAR,
  "rcpt_ctry_nm" VARCHAR,
  "rcpt_congr_distr" BIGINT,
  "strt_dt" VARCHAR,
  "end_dt" VARCHAR,
  "proj_awrd_descr" VARCHAR,
  "confidence_cd" VARCHAR,
  "rcpt_rec_type" BIGINT,
  "actn_type" VARCHAR,
  "faouc" DOUBLE,
  "fed_awrd_id" VARCHAR,
  "fed_amt" BIGINT,
  "sbsd_cst_amt" DOUBLE,
  "non_fed_amt" BIGINT,
  "awrd_obl_dt" BIGINT,
  "asst_trans_type" BIGINT,
  "rcpt_rcd_type" BIGINT,
  "corr_late_ind" VARCHAR,
  "fy_qtr_corr" VARCHAR,
  "pop_fips_cd" VARCHAR,
  "mnr_ind" VARCHAR,
  "perf_st_addr1" VARCHAR,
  "perf_st_addr2" VARCHAR,
  "perf_city_nm" VARCHAR,
  "perf_st_abbr" VARCHAR,
  "perf_ctry_nm" VARCHAR,
  "perf_zip_cd" VARCHAR,
  "perf_congr_distr" BIGINT,
  "pgm_src" VARCHAR,
  "sub_awrd_fai" VARCHAR,
  "trans_loc" BIGINT,
  "paid_disb" VARCHAR,
  "ftr" VARCHAR,
  "rec_ctry_cd3" VARCHAR,
  "perf_ctry_cd3" VARCHAR,
  "rcvr_ind" VARCHAR
);