About this Dataset

Rural Development Obligations And Disbursements (non ARRA) - January 2017

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 January 2017.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:06.227305
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_333dc9db.non_stimulus_obligations_and_disbursements

1.37 MB
27,586 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" VARCHAR,
  "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" DOUBLE,
  "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
);