Rural Development Obligations And Disbursements (non ARRA) - January 2016
Department of Agriculture
@usgov.usda_gov_rural_development_obligations_and_disbursemen_22ec2cf6
Department of Agriculture
@usgov.usda_gov_rural_development_obligations_and_disbursemen_22ec2cf6
CREATE TABLE non_stimulus_obligations_and_disbursements (
"n__cfda" DOUBLE,
"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" 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" DOUBLE,
"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
);
Anyone who has the link will be able to view this.