2022_PUDB_EXPORT_123122
This file includes the information regarding Federal Home Loan Bank Public Use Database for the year 2022
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 | 8af4033267c7bf87434f18d6cff4f698 |
| Id | ad41cc87-3ad0-42d8-a9f7-257528e1a333 |
| Ignore hash | False |
| Mimetype | text/csv |
| Original url | https://contentcdn-prod.youdata.ai/dataset/kashish/7938a6f5-407e-4812-add6-38f3b7142966/2022_PUDB_EXPORT_123122.csv |
| Package id | 1f7d53e5-f288-414a-831c-b9cf7872feaa |
| Position | 0 |
| Resource id | ad41cc87-3ad0-42d8-a9f7-257528e1a333 |
| Set url type | False |
| State | active |
| Task created | 2023-12-12 06:47:32.279194 |