2022_PUDB_EXPORT_123122 (5).csv
Dataset description:
The Federal Home Loan Bank (FHLBank) Public Use Database refers to a collection of data and information released by the Federal Housing Finance Agency (FHFA) related to the activities and...
Source: 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 7, 2023 |
| Metadata last updated | December 7, 2023 |
| Created | December 7, 2023 |
| Format | CSV |
| License | Other (Open) |
| Ckan url | https://sistarmortgage.sutra.ai |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | True |
| Hash | 8af4033267c7bf87434f18d6cff4f698 |
| Id | 94cb9141-424e-4e10-9fcd-755736a5d478 |
| Ignore hash | False |
| Mimetype | text/csv |
| Original url | https://sistarmortgage.sutra.ai/dataset/0cddbc4c-3508-4272-97a3-e6be361a0b91/resource/94cb9141-424e-4e10-9fcd-755736a5d478/download/2022_pudb_export_123122-5.csv |
| Package id | 0cddbc4c-3508-4272-97a3-e6be361a0b91 |
| Position | 0 |
| Resource id | 94cb9141-424e-4e10-9fcd-755736a5d478 |
| Set url type | False |
| Size | 6.5 MiB |
| State | active |
| Task created | 2023-12-07 10:20:53.314642 |
| Url type | upload |