2020_PUDB_EXPORT_123120
This file includes the information regarding Federal Home Loan Bank Public Use Database for the year 2020
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Year | text | ||
| LoanCharacteristicsID | text | ||
| Bank | text | ||
| FIPSStateNumericCode | text | ||
| FIPSCountyCode | text | ||
| CoreBasedStatisticalAreaCode | text | ||
| CensusTractIdentifier | text | ||
| CensusTractMinorityRatioPercent | text | ||
| CensusTractMedFamIncomeAmount | text | ||
| LocalAreaMedianIncomeAmount | text | ||
| TotalMonthlyIncomeAmount | text | ||
| HUDMedianIncomeAmount | text | ||
| LoanAcquisitionActualUPBAmt | text | ||
| LTVRatioPercent | text | ||
| NoteDate | text | ||
| LoanAcquistionDate | text | ||
| LoanPurposeType | text | ||
| ProductCategoryName | text | ||
| MortgageType | text | ||
| ScheduledTotalPaymentCount | text | ||
| LoanAmortizationMaxTermMonths | text | ||
| MortgageLoanSellerInstType | text | ||
| BorrowerCount | text | ||
| BorrowerFirstTimeHomebuyer | text | ||
| Borrower1Race1Type | text | ||
| Borrower2Race1Type | text | ||
| Borrower1GenderType | text | ||
| Borrower2GenderType | text | ||
| Borrower1AgeAtApplicationYears | text | ||
| Borrower2AgeAtApplicationYears | text | ||
| PropertyUsageType | text | ||
| PropertyUnitCount | text | ||
| NoteRatePercent | text | ||
| NoteAmount | text | ||
| HousingExpenseRatioPercent | text | ||
| TotalDebtExpenseRatioPercent | text | ||
| Borrower1CreditScoreValue | text | ||
| Borrower2CreditScoreValue | text | ||
| PMICoveragePercent | text | ||
| EmploymentBorrowerSelfEmployed | text | ||
| PropertyType | text | ||
| IndexSourceType | text | ||
| MarginRatePercent | text | ||
| PrepaymentPenaltyExpirationDate | text | ||
| Borrower1EthnicityType | text | ||
| Borrower1Race2Type | text | ||
| Borrower1Race3Type | text | ||
| Borrower1Race4Type | text | ||
| Borrower1Race5Type | text | ||
| Borrower2EthnicityType | text | ||
| Borrower2Race2Type | text | ||
| Borrower2Race3Type | text | ||
| Borrower2Race4Type | text | ||
| Borrower2Race5Type | text | ||
| HOEPALoanStatusType | text | ||
| LienPriorityType | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | December 12, 2023 |
| Metadata last updated | December 12, 2023 |
| Created | December 12, 2023 |
| Format | CSV |
| License | No License Provided |
| Ckan url | https://sistarmortgage.sutra.ai |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | True |
| Hash | e0937b537b1d63aa996e2e3305fcb2f9 |
| Id | ffafa424-2e23-4803-91e6-ab0e6a78da8d |
| Ignore hash | False |
| Mimetype | text/csv |
| Original url | https://contentcdn-prod.youdata.ai/dataset/kashish/d6e767d5-e54c-45d7-a4ba-2babbcf6f50f/2020_PUDB_EXPORT_123120.csv |
| Package id | 497e8d44-7822-4e5f-8d94-5ba8ed035cc4 |
| Position | 0 |
| Resource id | ffafa424-2e23-4803-91e6-ab0e6a78da8d |
| Set url type | False |
| State | active |
| Task created | 2023-12-12 06:47:55.236415 |