About this Dataset

USDA Rural Development Multifamily Section 515 Rural Rental Housing And Section 514 Farm Labor Housing Properties Transfers, Consolidations, And Sales

Transaction history of property transfers, consolidations, and sales within the USDA Rural Development Multifamily Direct Loan programs: Section 515 Rural Rental Housing and Section 514 Farm Labor Housing. Includes new property ID numbers and associated old property ID numbers, transaction type indicators, and effective dates. Requires merging with “USDA Rural Development Multifamily Section 515 Rural Rental Housing and Section 514 Farm Labor Housing Property Characteristics” to obtain property address and other characteristics based on new property ID number.
Organization: Department of Agriculture
Last updated: 2020-11-10T16:28:11.847079
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 Properties Transfers, Consolidations, And Sales

@usgov.usda_gov_usda_rural_development_multifamily_section_51_b0db396e.usda_rural_development_multifamily_section_515_rural_r_3ffaf322

79.6 kB
3,773 rows
8 columns

CREATE TABLE usda_rural_development_multifamily_section_515_rural_r_3ffaf322 (
  "n__new_borrower_id" BIGINT  -- #New Borrower ID,
  "new_project_id" BIGINT,
  "new_project_check_digit" BIGINT,
  "old_borrower_id" BIGINT,
  "old_project_id" BIGINT,
  "old_project_check_digit" BIGINT,
  "action_type_code" VARCHAR,
  "date_action_effective" TIMESTAMP
);