About this Dataset

USDA Rural Development Multifamily Section 515 Rural Rental Housing And Section 514 Farm Labor Housing Tenant Characteristics

Aggregated tenant characteristics for USDA Rural Development Multifamily Direct Loan programs: Section 515 Rural Rental Housing and Section 514 Farm Labor Housing. Includes property address and aggregated demographic information including female headed-households, elderly aged 62 or older, minors, disability status, race, and ethnicity. Also includes average annual income, average annual income by source of income, cost-burden indicator, zero income indicator, and rental assistance subsidy counts by type of assistance. Can be merged with “USDA Rural Development Multifamily Section 515 Rural Rental Housing and Section 514 Farm Labor Housing Property Characteristics” to link to property characteristics, as well as “USDA Rural Development Multifamily Section 515 Rural Rental Housing and Section 514 Farm Labor Housing Properties Transfers, Consolidations, and Sales” to link with property transaction histories.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:12.384015
Tags: agriculture, agriculture-and-rural-development, data, disaster-assistance, dwelling, farm-labor-housing, farmworker, housing, multifamily, property, rental, rental-assistance, rural-development, section-514, section-515, united-states-department-of-agriculture, usda

Tables

USDA Rural Development Multifamily Section 515 Rural Rental Housing And Section 514 Farm Labor Housing Tenant Characteristics

@usgov.usda_gov_usda_rural_development_multifamily_section_51_9216fb3f.usda_rural_development_multifamily_section_515_rural_r_6e46b9bd

1.17 MB
13,550 rows
39 columns

CREATE TABLE usda_rural_development_multifamily_section_515_rural_r_6e46b9bd (
  "n__borrower_id" BIGINT  -- #Borrower ID,
  "project_id" BIGINT,
  "project_check_digit" BIGINT,
  "state_county_fips_code" BIGINT,
  "project_name" VARCHAR,
  "main_address_line1" VARCHAR,
  "main_address_line2" VARCHAR,
  "main_address_line3" VARCHAR,
  "city" VARCHAR,
  "state_abbreviation" VARCHAR,
  "zip_code" VARCHAR,
  "household_count" BIGINT,
  "over_30_percent_income_count" BIGINT,
  "no_income_tenants_count" BIGINT,
  "head_of_household_female_count" DOUBLE,
  "elderly_count" BIGINT,
  "disabled_count" BIGINT,
  "handicapped_count" BIGINT,
  "ethnicity_hispanic_count" BIGINT,
  "designated_minors_count" BIGINT,
  "race_code_a_count" BIGINT,
  "race_code_b_count" BIGINT,
  "race_code_i_count" BIGINT,
  "race_code_m_count" BIGINT,
  "race_code_p_count" BIGINT,
  "race_code_w_count" BIGINT,
  "race_code_x_count" BIGINT,
  "subsidy_0_count" BIGINT,
  "subsidy_1_count" BIGINT,
  "subsidy_2_count" BIGINT,
  "subsidy_4_count" BIGINT,
  "subsidy_5_count" BIGINT,
  "subsidy_6_count" BIGINT,
  "subsidy_7_count" BIGINT,
  "subsidy_8_count" BIGINT,
  "annual_income_average" DOUBLE,
  "other_income_average" DOUBLE,
  "public_assistant_income_average" DOUBLE,
  "social_security_income_average" DOUBLE
);