About this Dataset

Rural Development Obligations And Disbursements (non ARRA) - August 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 August 2016.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:05.506713
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_76738ad5.non_stimulus_obligations_and_disbursements

57.91 kB
375 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" VARCHAR,
  "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
);