About this Dataset

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

Property locations and characteristics for USDA Rural Development Multifamily Direct Loan programs: Section 515 Rural Rental Housing and Section 514 Farm Labor Housing. Includes latitude and longitude coordinates, property address, type of development, date of operation, profit type, management agent, loan program identifier, Low Income Housing Tax Credit identifier and expiration date, Multifamily Preservation and Revitalization program identifier, total units, USDA Section 521 rental assistance units, units by bedroom size, and vacant units.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:12.370661
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 Property Characteristics

@usgov.usda_gov_usda_rural_development_multifamily_section_51_a5468141.usda_rural_development_multifamily_section_515_rural_r_83ad87fa

1.29 MB
13,550 rows
32 columns

CREATE TABLE usda_rural_development_multifamily_section_515_rural_r_83ad87fa (
  "n__borrower_id" BIGINT  -- #Borrower ID,
  "project_id" BIGINT,
  "project_check_digit" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "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,
  "project_size" BIGINT,
  "rental_code" VARCHAR,
  "labor_housing_type" BIGINT,
  "revitilization_indicator" DOUBLE,
  "tax_status_indicator" VARCHAR,
  "date_tax_credit_expires" TIMESTAMP,
  "profit_type_code" BIGINT,
  "management_name" VARCHAR,
  "date_of_operation" TIMESTAMP,
  "date_restrictive_clause_expires" TIMESTAMP,
  "total_1_bedroom_units" BIGINT,
  "total_2_bedroom_units" BIGINT,
  "total_3_bedroom_units" BIGINT,
  "total_4_bedroom_units" BIGINT,
  "total_5_bedroom_units" BIGINT,
  "total_6_bedroom_units" BIGINT,
  "total_handicapped_units" BIGINT,
  "vacant_units" BIGINT,
  "rental_assistance_units" BIGINT
);