30 Year Mortgage Rate in the United States decreased to 6.85 percent in June 5 from 6.89 percent in the previous week. This dataset includes a chart with historical data for the United States 30 Year Mortgage Rate.

Fixed 30-year mortgage rates in the United States averaged 6.92 percent in the week ending May 30 of 2025. This dataset provides the latest reported value for - United States MBA 30-Yr Mortgage Rate - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

DESCRIPTION

Create a model that predicts whether or not a loan will be default using the historical data.

Problem Statement:

For companies like Lending Club correctly predicting whether or not a loan will be a default is very important. In this project, using the historical data from 2007 to 2015, you have to build a deep learning model to predict the chance of default for future loans. As you will see later this dataset is highly imbalanced and includes a lot of features that make this problem more challenging.

Domain: Finance

Analysis to be done: Perform data preprocessing and build a deep learning prediction model.

Content:

Dataset columns and definition:

credit.policy: 1 if the customer meets the credit underwriting criteria of LendingClub.com, and 0 otherwise.

purpose: The purpose of the loan (takes values "credit_card", "debt_consolidation", "educational", "major_purchase", "small_business", and "all_other").

int.rate: The interest rate of the loan, as a proportion (a rate of 11% would be stored as 0.11). Borrowers judged by LendingClub.com to be more risky are assigned higher interest rates.

installment: The monthly installments owed by the borrower if the loan is funded.

log.annual.inc: The natural log of the self-reported annual income of the borrower.

dti: The debt-to-income ratio of the borrower (amount of debt divided by annual income).

fico: The FICO credit score of the borrower.

days.with.cr.line: The number of days the borrower has had a credit line.

revol.bal: The borrower's revolving balance (amount unpaid at the end of the credit card billing cycle).

revol.util: The borrower's revolving line utilization rate (the amount of the credit line used relative to total credit available).

inq.last.6mths: The borrower's number of inquiries by creditors in the last 6 months.

delinq.2yrs: The number of times the borrower had been 30+ days past due on a payment in the past 2 years.

pub.rec: The borrower's number of derogatory public records (bankruptcy filings, tax liens, or judgments).

Steps to perform:

Perform exploratory data analysis and feature engineering and then apply feature engineering. Follow up with a deep learning model to predict whether or not the loan will be default using the historical data.

Tasks:

1. Feature Transformation

Transform categorical values into numerical values (discrete)

1. Exploratory data analysis of different factors of the dataset.

2. Additional Feature Engineering

You will check the correlation between features and will drop those features which have a strong correlation

This will help reduce the number of features and will leave you with the most relevant features

1. Modeling

After applying EDA and feature engineering, you are now ready to build the predictive models

In this part, you will create a deep learning model using Keras with Tensorflow backend

Brazil Lending Rate: per Month: Pre-Fixed: Individuals: Mortgages with Market Rates: Portoseg S.A. Credito Financiamento e Investimento data was reported at 0.000 % per Month in 03 Jul 2019. This stayed constant from the previous number of 0.000 % per Month for 02 Jul 2019. Brazil Lending Rate: per Month: Pre-Fixed: Individuals: Mortgages with Market Rates: Portoseg S.A. Credito Financiamento e Investimento data is updated daily, averaging 0.000 % per Month from Jan 2012 (Median) to 03 Jul 2019, with 1817 observations. The data reached an all-time high of 0.000 % per Month in 03 Jul 2019 and a record low of 0.000 % per Month in 03 Jul 2019. Brazil Lending Rate: per Month: Pre-Fixed: Individuals: Mortgages with Market Rates: Portoseg S.A. Credito Financiamento e Investimento data remains active status in CEIC and is reported by Central Bank of Brazil. The data is categorized under Brazil Premium Database’s Interest and Foreign Exchange Rates – Table BR.MB011: Lending Rate: per Month: by Banks: Pre-Fixed: Individuals: Mortgages with Market Rates. Lending Rate: Daily: Interest rates disclosed represent the total cost of the transaction to the client, also including taxes and operating. These rates correspond to the average fees in the period indicated in the tables. There are presented only institutions that had granted during the period determined. In general, institutions practicing different rates within the same type of credit. Thus, the rate charged to a customer may differ from the average. Several factors such as the time and volume of the transaction, as well as the guarantees offered, explain the differences between interest rates. Certain institutions grant allowance of the use of the term overdraft. However, this is not considered in the calculation of rates of this type. It should be noted that the overdraft is a modality that has high interest rates. Thus, its use should be restricted to short periods. If the customer needs resources for a longer period, should find ways to offer lower rates. The Brazilian Central Bank publishes these data with a delay about 20 days with relation to the reference period, thus allowing sufficient time for all Financial Institutions to deliver the relevant information. Interest rates presented in this set of tables correspond to averages weighted by the values of transactions conducted in the five working days specified in each table. These rates represent the average effective cost of loans to customers, consisting of the interest rates actually charged by financial institutions in their lending operations, increased tax burdens and operational incidents on the operations. The interest rates shown are the average of the rates charged in the various operations performed by financial institutions, in each modality. In one discipline, interest rates may differ between customers of the same financial institution. Interest rates vary according to several factors, such as the value and quality of collateral provided in the operation, the proportion of down payment operation, the history and the registration status of each client, the term of the transaction, among others . Institutions with “zero” did not operate on modalities for those periods or did not provide information to the Central Bank of Brazil. The Central Bank of Brazil assumes no responsibility for delay, error or other deficiency of information provided for purposes of calculating average rates presented in this

This dataset contains the customer's data from a loan company known as Prosper. This dataset comprises of 113,937 loans with 81 variables on each loan, including loan amount, borrower rate (or interest rate), current loan status, borrower income, and many others.

Definition of Variables:

ListingKey: Unique key for each listing, same value as the 'key' used in the listing object in the API. ListingNumber: The number that uniquely identifies the listing to the public as displayed on the website. ListingCreationDate: The date the listing was created. CreditGrade: The Credit rating that was assigned at the time the listing went live. Applicable for listings pre-2009 period and will only be populated for those listings. Term: The length of the loan expressed in months. LoanStatus: The current status of the loan: Cancelled, Chargedoff, Completed, Current, Defaulted, FinalPaymentInProgress, PastDue. The PastDue status will be accompanied by a delinquency bucket. ClosedDate: Closed date is applicable for Cancelled, Completed, Chargedoff and Defaulted loan statuses. BorrowerAPR: The Borrower's Annual Percentage Rate (APR) for the loan. BorrowerRate: The Borrower's interest rate for this loan. LenderYield: The Lender yield on the loan. Lender yield is equal to the interest rate on the loan less the servicing fee. EstimatedEffectiveYield: Effective yield is equal to the borrower interest rate (i) minus the servicing fee rate, (ii) minus estimated uncollected interest on charge-offs, (iii) plus estimated collected late fees. Applicable for loans originated after July 2009. EstimatedLoss: Estimated loss is the estimated principal loss on charge-offs. Applicable for loans originated after July 2009. EstimatedReturn: The estimated return assigned to the listing at the time it was created. Estimated return is the difference between the Estimated Effective Yield and the Estimated Loss Rate. Applicable for loans originated after July 2009. ProsperRating (numeric): The Prosper Rating assigned at the time the listing was created: 0 - N/A, 1 - HR, 2 - E, 3 - D, 4 - C, 5 - B, 6 - A, 7 - AA. Applicable for loans originated after July 2009. ProsperRating (Alpha): The Prosper Rating assigned at the time the listing was created between AA - HR. Applicable for loans originated after July 2009. ProsperScore: A custom risk score built using historical Prosper data. The score ranges from 1-10, with 10 being the best, or lowest risk score. Applicable for loans originated after July 2009. ListingCategory: The category of the listing that the borrower selected when posting their listing: 0 - Not Available, 1 - Debt Consolidation, 2 - Home Improvement, 3 - Business, 4 - Personal Loan, 5 - Student Use, 6 - Auto, 7- Other, 8 - Baby&Adoption, 9 - Boat, 10 - Cosmetic Procedure, 11 - Engagement Ring, 12 - Green Loans, 13 - Household Expenses, 14 - Large Purchases, 15 - Medical/Dental, 16 - Motorcycle, 17 - RV, 18 - Taxes, 19 - Vacation, 20 - Wedding Loans BorrowerState: The two letter abbreviation of the state of the address of the borrower at the time the Listing was created. Occupation: The Occupation selected by the Borrower at the time they created the listing. EmploymentStatus: The employment status of the borrower at the time they posted the listing. EmploymentStatusDuration: The length in months of the employment status at the time the listing was created. IsBorrowerHomeowner: A Borrower will be classified as a homowner if they have a mortgage on their credit profile or provide documentation confirming they are a homeowner. CurrentlyInGroup: Specifies whether or not the Borrower was in a group at the time the listing was created. GroupKey: The Key of the group in which the Borrower is a member of. Value will be null if the borrower does not have a group affiliation. DateCreditPulled: The date the credit profile was pulled. CreditScoreRangeLower: The lower value representing the range of the borrower's credit score as provided by a consumer credit rating agency. CreditScoreRangeUpper: The upper value representing the range of the borrower's credit score as provided by a consumer credit rating agency. FirstRecordedCreditLine: The date the first credit line was opened. CurrentCreditLines: Number of current credit lines at the time the credit profile was pulled. OpenCreditLines: Number of open credit lines at the time the credit profile was pulled. TotalCreditLinespast7years: Number of credit lines in the past seven years at the time the credit profile was pulled. OpenRevolvingAccounts: Number of open revolving accounts at the time the credit profile was pulled. OpenRevolvingMonthlyPayment: Monthly payment on revolving accounts at the time the credit profile was pulled. InquiriesLast6Months: Number of inquiries in the past six months at the time the cre...

The benchmark interest rate in Mexico was last recorded at 8.50 percent. This dataset provides - Mexico Interest Rate - actual values, historical data, forecast, chart, statistics, economic calendar and news.

This dataset provides information about people applying for loans, including details on their personal background, finances, and loan specifics. It's meant to help us better understand how different personal factors impact whether a loan gets approved. The data includes things like the applicant's age, income, home ownership status, job history, and credit score, along with loan details such as the loan amount, interest rate, and purpose. It also shows whether the loan was approved or denied.

Features in the dataset:

1. person_age: The applicant's age.
2. person_income: How much the applicant earns annually, in USD.
3. person_home_ownership: Whether the person owns, rents, or has a mortgage on their home.
4. person_emp_length: How long the person has been employed.
5. loan_intent: The reason for applying for the loan (e.g., EDUCATION, MEDICAL, VENTURE, DEBT CONSOLIDATION, PERSONAL).
6. loan_grade: The credit grade given to the loan (A, B, C, D, etc.).
7. loan_amnt: The amount of money the applicant is requesting for the loan, in USD.
8. loan_int_rate: The interest rate on the loan.
9. loan_percent_income: The percentage of the applicant’s income being requested as a loan.
10. cb_person_default_on_file: Whether the applicant has defaulted on any previous loans (Y/N).
11. cb_person_cred_hist_length: The length of the applicant's credit history, in years.
12. loan_status: The outcome of the loan application (0 = Rejected, 1 = Accepted).

Fannie Mae and Freddie Mac Loan-Level Dataset

Borrower Demographics, Loan-to-Value Ratios, and Census Tract Location

By Natarajan Krishnaswami [source]

About this dataset

The FHFA Public Use Databases provide an unprecedented look into the flow of mortgage credit and capital in America's communities. With detailed information about the income, race, gender and census tract location of borrowers, this database can help lenders, planners, researchers and housing advocates better understand how mortgages are acquired by Fannie Mae and Freddie Mac.

This data set includes 2009-2016 single-family property loan information from the Enterprises in combination with corresponding census tract information from the 2010 decennial census. It allows for greater granularity in examining mortgage acquisition patterns within each MSA or county by combining borrower/property characteristics, such as borrower's race/ethnicity; co-borrower demographics; occupancy type; Federal guarantee program (conventional/other versus FHA-insured); age of borrowers; loan purpose (purchase, refinance or home improvement); lien status; rate spread between annual percentage rate (APR) and average prime offer rate (APOR); HOEPA status; area median family income and more.

In addition to demographic data on borrowers and properties, this dataset also provides insight into affordability metrics such as median family incomes at both the MSA/county level as well as functional owner occupied bankrupt tracts using 2010 Census based geography while taking into account American Community Survey estimates available at January 1st 2016. This allows us to calculate metrics that are important for assessing inequality such as tract income ratios which measure what portion of an area’s median family income is made up by a single borrows earnings or the ratio between borrows annual income compared to an area’s average median family iincome for those year’s reporting period. Finally each record contains Enterprise Flags associated with whether loans were purchased my Fannie Mae or Freddie Mac indicating further insights regarding who is financing policies affecting undocumented immigrant labor access as well affordable housing legislation targeted towards first time home buyers

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This guide will provide you with all the information needed to use the Fannie Mae and Freddie Mac Loan-Level Dataset for 2016. The dataset contains loan-level data for both Fannie Mae and Freddie Mac, including loans acquired in 2016. It includes details such as homeowner demographics, loan-to-value ratio, census tract location, and affordability of mortgage.

The first step to using this dataset is understanding how it is organized. There are 38 fields that make up the loan level data set, making it easy to understand what is being looked at. For each field there is a description of what the field represents and potential values it can take on (i.e., if it’s an integer or float). Having an understanding of the different fields will help when querying certain data points or comparing/contrasting.

Once you understand what type of information is available in this dataset you can start to create queries or visualizations that compare trends across Fannie Mae & Freddie Mac loans made in 2016. Depending on your interest areas such as homeownership rates or income disparities certain statistics may be pulled from the dataset such as borrower’s Annual Income Ratio per area median family income by state code or a comparison between Race & Ethnicity breakdown between borrowers and co-borrowers from various states respective MSAs, among other possibilities based on your inquiries . Visualizations should then be created so that clear comparisons and contrasts could be seen more easily by other users who may look into this same dataset for additional insights as well .

After creating queries/visualization , you can dive deeper into research about corresponding trends & any biases seen within these datasets related within particular racial groupings compared against US Postal & MSA codes used within the 2010 Census Tract locations throughout the US respectively by further utilizing publicly available research material that looks at these subjects with regards housing policies implemented through out years one could further draw conclusions depending on their current inquiries

Research Ideas

• Use the dataset to analyze borrowing patterns based on race, nationality and gender, to better understand the links between minority groups and access to credit...

Lending Club offers peer-to-peer (P2P) loans through a technological platform for various personal finance purposes and is today one of the companies that dominate the US P2P lending market. The original dataset is publicly available on Kaggle and corresponds to all the loans issued by Lending Club between 2007 and 2018. The present version of the dataset is for constructing a granting model, that is, a model designed to make decisions on whether to grant a loan based on information available at the time of the loan application. Consequently, our dataset only has a selection of variables from the original one, which are the variables known at the moment the loan request is made. Furthermore, the target variable of a granting model represents the final status of the loan, that are "default" or "fully paid". Thus, we filtered out from the original dataset all the loans in transitory states. Our dataset comprises 1,347,681 records or obligations (approximately 60% of the original) and it was also cleaned for completeness and consistency (less than 1% of our dataset was filtered out).

TARGET VARIABLE

The dataset includes a target variable based on the final resolution of the credit: the default category corresponds to the event charged off and the non-default category to the event fully paid. It does not consider other values in the loan status variable since this variable represents the state of the loan at the end of the considered time window. Thus, there are no loans in transitory states. The original dataset includes the target variable “loan status”, which contains several categories ('Fully Paid', 'Current', 'Charged Off', 'In Grace Period', 'Late (31-120 days)', 'Late (16-30 days)', 'Default'). However, in our dataset, we just consider loans that are either “Fully Paid” or “Default” and transform this variable into a binary variable called “Default”, with a 0 for fully paid loans and a 1 for defaulted loans.

EXPLANATORY VARIABLES

The explanatory variables that we use correspond only to the information available at the time of the application. Variables such as the interest rate, grade, or subgrade are generated by the company as a result of a credit risk assessment process, so they were filtered out from the dataset as they must not be considered in risk models to predict the default in granting of credit.

FULL LIST OF VARIABLES

Loan identification variables:

id: Loan id (unique identifier).

issue_d: Month and year in which the loan was approved.

Quantitative variables:

revenue: Borrower's self-declared annual income during registration.

dti_n: Indebtedness ratio for obligations excluding mortgage. Monthly information. This ratio has been calculated considering the indebtedness of the whole group of applicants. It is estimated as the ratio calculated using the co-borrowers’ total payments on the total debt obligations divided by the co-borrowers’ combined monthly income.

loan_amnt: Amount of credit requested by the borrower.

fico_n: Defined between 300 and 850, reported by Fair Isaac Corporation as a risk measure based on historical credit information reported at the time of application. This value has been calculated as the average of the variables “fico_range_low” and “fico_range_high” in the original dataset.

experience_c: Binary variable that indicates whether the borrower is new to the entity. This variable is constructed from the credit date of the previous obligation in LC and the credit date of the current obligation; if the difference between dates is positive, it is not considered as a new experience with LC.

Categorical variables:

emp_length: Categorical variable with the employment length of the borrower (includes the no information category)

purpose: Credit purpose category for the loan request.

home_ownership_n: Homeownership status provided by the borrower in the registration process. Categories defined by LC: “mortgage”, “rent”, “own”, “other”, “any”, “none”. We merged the categories “other”, “any” and “none” as “other”.

addr_state: Borrower's residence state from the USA.

zip_code: Zip code of the borrower's residence.

Textual variables

title: Title of the credit request description provided by the borrower.

desc: Description of the credit request provided by the borrower.

We cleaned the textual variables. First, we removed all those descriptions that contained the default description provided by Lending Club on its web form (“Tell your story. What is your loan for?”). Moreover, we removed the prefix “Borrower added on DD/MM/YYYY >” from the descriptions to avoid any temporal background on them. Finally, as these descriptions came from a web form, we substituted all the HTML elements by their character (e.g. “&” was substituted by “&”, “<” was substituted by “<”, etc.).

RELATED WORKS

This dataset has been used in the following academic articles:

Sanz-Guerrero, M. Arroyo, J. (2024). Credit Risk Meets Large Language Models: Building a Risk Indicator from Loan Descriptions in P2P Lending. arXiv preprint arXiv:2401.16458. https://doi.org/10.48550/arXiv.2401.16458

Ariza-Garzón, M.J., Arroyo, J., Caparrini, A., Segovia-Vargas, M.J. (2020). Explainability of a machine learning granting scoring model in peer-to-peer lending. IEEE Access 8, 64873 - 64890. https://doi.org/10.1109/ACCESS.2020.2984412

Data Description

1 id : To uniquely identify every loan in the dataset.

2 member_id : To identify the borrower to who has applied for the loan. 3 loan_amnt : The listed amount of the loan applied for by the borrower. 4 funded_amnt : The amount that was sanctioned by the LC. 5 term : The number of payments on the loan. Values are in months and can be either 36 or 60. 6 int_rate : Interest Rate on the loan 7 installment : The monthly payment owed by the borrower if the loan originates. 8 grade : LC assigned loan grade which depends on the borrower’s credit score. 9 sub_grade : LC assigned loan subgrade 10 emp_title : The job title supplied by the Borrower when applying for the loan.* 11 emp_length : Employment length in years. Possible values are between 0 and 10 where 0 means less than one year and 10 means ten or more years. 12 home_ownership : The home ownership status provided by the borrower during registration or obtained from the credit report. Our values are: RENT, OWN, MORTGAGE, OTHER 13 annual_inc : The self-reported annual income provided by the borrower during registration. 14 verification_status : Indicates if income was verified by LC, not verified, or if the income source was verified 15 issue_d : The month which the loan was funded 16 loan_status : Current status of the loan 17 purpose : A category provided in the form of a code to indicate the purpose for the loan. 18 title : Explaining the ‘purpose’ of the loan. 19 dti : The debt to income ratio is the ratio of how much the borrower owes every month to the borrower’s income every month. 20 delinq_2yrs : The number of delinquencies(late installment payment) by the borrower in the past 2 years. 21 earliest_cr_line : The month-year the borrower's earliest reported credit line was opened 22 inq_last_6mths : Inquiries for loans made by the borrower over the past 6 months. 23 mths_since_last_delinq : Months that have passed since the borrower last missed the timely payment of installment. 24 open_acc : The number of open credit lines in the borrower’s credit file. 25 pub_rec Number of derogatory public records 26 revol_bal : Total credit revolving balance 27 revol_util : Revolving line utilization rate, or the amount of credit the borrower is using relative to all available revolving credit. 28 total_acc : The total number of credit lines currently in the borrower's credit file 29 initial_list_status : The initial listing status of the loan. Possible values are – W(whole), F(fractional) 30 out_prncp : Remaining outstanding principal for total amount funded 31 total_pymnt : Payments received to date for the total amount funded. 32 total_rec_prncp : Principal received till date. 33 total_rec_int Interest received till date. 34 total_rec_late_fee : Late fees received to date. 35 recoveries : Total recovery procedures initiated against the borrower. 36 collection_recovery_fee : The fees collected during the recovery procedures. 37 last_pymnt_d The last month when payment was received. 38 last_pymnt_amnt : The last payment amount received. 39 next_pymnt_d : Next scheduled payment date. 40 last_credit_pull_d : The most recent month LC pulled credit for this loan 41 collections_12_mths_ex_med : Number of collections in 12 months excluding medical collections 42 mths_since_last_major_derog : Months since most recent 90-day delinquency or worse rating 43 application_type Indicates whether the loan is an individual application or a joint application with two co-borrowers 44 annual_inc_joint : The combined self-reported annual income provided by the co-borrowers during registration 45 dti_joint : A ratio calculated using the co-borrowers' total monthly payments on the total debt obligations, excluding mortgages and the requested LC loan, divided by the co-borrowers' combined self-reported monthly income 46 acc_now_delinq : The number of accounts on which the borrower is now delinquent 47 tot_coll_amt : Total collection amounts ever owed by the borrower 48 tot_cur_bal : Total current balance of all accounts owned by the borrower 49 total_rev_hi_lim : Total high credit/credit limit

The benchmark interest rate in China was last recorded at 3 percent. This dataset provides the latest reported value for - China Interest Rate - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

This hosted feature layer has been published in RI State Plane Feet NAD 83.The RI Neighborhood Stabilization Program (NSP) Mapping analysis was performed to assist the Office of Housing and Community Development in identifying target areas with both a Foreclosure Rate (Block Group Level) >=6.5% and a Subprime Loan percentage rate >= 1.4% (Zip Code Level). Based on these criteria the following communities were identified as containing such target areas: Central Falls, Cranston, Cumberland, East Providence, Johnston, North Providence, Pawtucket, Providence, Warwick, West Warwick, and Woonsocket. Federal funding, under the Housing and Economic Recovery Act of 2008 (HERA), Neighborhood Stabilization Program (NSP), totaling $19.6 will be expended in these NSP Target Areas to assist in the rehabilitation and redevelopment of abandoned and foreclosed homes, stabilizing communities.The State of Rhode Island distributes funds allocated, giving priority emphasis and consideration to those areas with the greatest need, including those areas with - 1) Highest percentage of home foreclosures; 2) Highest percentage of homes financed by subprime mortgage loans; and 3) Anticipated increases in rate of foreclosure. The RI Office of Housing and Community Development, with the assistance of Rhode Island Housing, utilized the following sources to meet the above requirements. 1) U.S. Department of Housing & Urban Development (HUD) developed foreclosure data to assist grantees in identification of Target Areas. The State utilized HUD's predictive foreclosure rates to identify those areas which are likely to face a significant rise in the rate of home foreclosures. HUD's methodology factored in Home Mortgage Disclosure Act, income, unemployment, and other information in its calculation. The results were analyzed and revealed a high level of consistency with other needs data available. 2) The State obtained subprime mortgage loan information from the Federal Reserve Bank of Boston. Though the data does not include all mortgages, and was only available at the zip code level rather than Census Tract, findings were generally consistent with other need categories. This data was joined to the Foreclosure dataset in order to select areas with both a Foreclosure Rate >=6.5% and a Subprime Loan Rate >=1.4%. 3) The State also obtained, from the Warren Group, actual local foreclosure transaction records. The Warren Group is a source for real estate and banking news and transaction data throughout New England. This entity has analyzed local deed records in assembling information presented. The data set was normalized due to potential limitations. An analysis revealed a high level of consistency with HUD-predictive foreclosure rates.

Negative Equity in U.S. Housing Market

Measuring Home Values, Debt, and Credit Risk

By Zillow Data [source]

About this dataset

This dataset, Negative Equity in the US Housing Market, provides an in-depth look into the negative equity occurring across the United States during this single quarter. Included are metrics such as total amount of negative equity in millions of dollars, total number of homes in negative equity, percentage of homes with mortgages that are in negative equity and more. These data points provide helpful insights into both regional and national trends regarding the prevalence and rate of home mortgage delinquency stemming from a diminishment of value from peak levels.

Home types available for analysis include 'all homes', condos/co-ops, multifamily units containing five or more housing units as well as duplexes/triplexes. Additionally, Cash buyers rates for particular areas can also be determined by referencing this collection. Further metrics such as mortgage affordability rates and impacts on overall indebtedness are readily calculated using information related to Zillow's Home Value Index (ZHVI) forecast methodology and TransUnion data respectively.

Other variables featured within this dataset include characteristics like region type (i.e city, county ..etc), size rank based on population values , percentage change in ZHVI since peak levels as well as loan-to-value ratio greater than 200 across all regions constituted herein (NE). Moreover Zillow's own Secondary Mortgage Market Survey data is utilized to acquire average mortgage quote rates while correlative Census Bureau NCHS median household income figures represent typical assessable proportions between wages and debt obligations . So whether you're looking to assess effects along metro lines or detailed buffering through zip codes , this database should prove sufficient for insightful explorations! Nonetheless users must strictly adhere to all conditions encompassed within Terms Of Use commitments put forth by our lead provider before accessing any resources included herewith

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

Research Ideas

• Analyzing regional and state trends in negative equity: Analyze geographic differences in the percentage of mortgages “underwater”, total amount of negative equity, number of homes at least 90 days late, and other key indicators to provide insight into the factors influencing negative equity across regions, states and cities.
• Tracking the recovery rate over time: Track short-term changes in numbers related to negative equity (e.g., region or area ZHVI Change from Peak) to monitor recovery rates over time as well as how different policy interventions are affecting homeownership levels in affected areas.
• Exploring best practices for promoting housing affordability: Compare affordability metrics (e.g., mortgage payments, price-to-income ratios) across different geographic locations over time to identify best practices for empowering homeowners and promoting stability within the housing market while reducing local inequality impacts related to availability of affordable housing options and access to credit markets like mortgages/loans etc

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: NESummary_2017Q1_Public.csv | Column name | Description | |:------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------| | RegionType | The type of region (e.g., city, county, metro etc.) (String) | | City | Name of the city (String) | | County | Name of the county (String) | | State | Name of the state (String) | | Metro ...

This essential dataset is tailored for real estate investors, home service providers, and Proptech companies, offering in-depth information that drives strategic decision-making and market analysis for Property Owner Data.

The dataset includes detailed address data, owner data, and mailing address data, providing a thorough understanding of each property’s profile. Real estate investors can leverage this data to identify high-potential investment opportunities and analyze market trends with greater accuracy. Home service providers can utilize the mailing address data to target specific properties and optimize their outreach efforts. For Proptech companies, this dataset enhances the development of innovative solutions and data-driven platforms.

Powered by BatchData, a leader in high-quality, up-to-date property information, this dataset ensures you receive the most accurate and current data available. Explore BatchService’s USA Property Owner Data to gain a competitive edge and make informed decisions in the dynamic real estate market.

Basic Property Data Includes: - Property ID - Address City - Address County - Address County FIPS Code - Address Hash - Address House Number - Address Latitude - Address Longitude - Address State - Address Street - Address Zip - Address Zip+4 Code - APN (Assessor's Parcel Number) - Property Owner Full Name - Property Owner First Name - Property Owner Middle Name - Property Owner Last Name - Property Owner Mailing Address City - Property Owner Mailing Address County - Property Owner Mailing Address State - Property Owner Mailing Address Street - Property Owner Mailing Address Zip - Property Owner Mailing Address Zip+4 code

BatchService also has 700+ additional datapoints available ranging from listing information, property characteristics, mortgage data, contact information and more.

The dataset has the following columns: Age: Age of the client (numeric) Job: Type of job (categorical) Marital: Marital status (categorical) Education: Education level (categorical) Default: Has credit in default? (categorical) Housing: Has housing loan? (categorical) Loan: Has personal loan? (categorical) Contact: Contact communication type (categorical) Day: Last contact day of the month (numeric) Month: Last contact month of the year (categorical) Duration: Last contact duration in seconds (numeric) [Note: Highly influential on the output] Campaign: Number of contacts during this campaign for this client (numeric) pdays: Number of days since the client was last contacted from a previous campaign (numeric) Previous: Number of contacts performed before this campaign and for this client (numeric) Poutcome: Outcome of the previous marketing campaign (categorical) emp.var.rate: Employment variation rate - quarterly indicator (numeric) cons.price.idx: Consumer price index - monthly indicator (numeric) cons.conf.idx: Consumer confidence index - monthly indicator (numeric) euribor3m: Euribor 3-month rate - daily indicator (numeric) nr.employed: Number of employees - quarterly indicator (numeric)

The target variable is binary(yes/no) that helps in predicting whether the client is capable of subscribing for the services provided by the bank

The Federal Housing Finance Agency (FHFA) is an independent regulatory agency that is not part of the Department of Housing and Urban Development (HUD).

The FHFA was established by the Housing and Economic Recovery Act of 2008 (HERA) and is responsible for the effective supervision, regulation, and housing mission oversight of Fannie Mae, Freddie Mac (the Enterprises), Common Securitization Solutions, LLC (CSS), and the Federal Home Loan Bank System, which includes the 11 Federal Home Loan Banks (FHLBanks) and the Office of Finance. Since 2008, FHFA has also served as conservator of Fannie Mae and Freddie Mac.

Conforming Loan Limits are mortgage limits set annually (as required by HERA) by the FHFA. In order for a mortgage loan to be eligible to be insured by Freddie Mac or Fannie Mae, the loan amount must be less than the loan limit. Mortgage exceeding the Conforming Loan Limit are referred to as "non-conforming loans" or "jumbo loans." While most counties use a single set of Conforming Loan Limits based on the number of units, high cost of living counties use higher Conforming Loan Limits. The FHFA analyzes year-over-year change in average home prices in October of each year using the Monthly Interest Rate Survey (MIRS) to adjust the Conforming Loan Limits for the upcoming year.

Geospatial data in this feature service uses the Census 2010 County geographies.

To learn more about about the FHFA, please visit:https://www.fhfa.gov/AboutUs



For more information about FHFA Conforming Loan Limits, please visit:https://www.fhfa.gov/DataTools/Downloads/Pages/Conforming-Loan-Limits.aspx

Date of Coverage: 2022

Date Updated: Annually

Data Dictionary:DD_FHFA Conforming Loan Limits

The dataset "Guaranteed debt of the City of Paris" presents the breakdown of the debt guaranteed by the Parisian collectivity. The debt guaranteed by the Paris authority mainly includes loans taken out by guarantee beneficiaries for social housing operations. The other guarantees relate mainly to development operations and guarantees for the benefit of associations." Column name | Description ---|--- Year of publication | Year of the Administrative Account for which the data were published Community | In accounting, the term "nature" means the account in the accounting nomenclature (account number - Heading), expenditure or revenue. Nature | lending bank in the case of a bank loan; bank or group of banks that organised the issue in the case of a bond issue Year of mobilisation | Date of collection by the City of Paris Depreciation profile. of the loan | End of life date of the loan Beneficiary designation | Amount originally subscribed. Purpose of the guaranteed loan | Since almost all of the City's loans are of the "in fine" type, the capital remaining due is generally equal to the nominal amount, i.e. the amount of the loan (except in the case of depreciation in the year) Lender or lead organisation | Indexed rates are rates adjusted periodically according to market values Initial amount | The borrowings of the City of Paris are indexed to different interest rates: EURIBOR (Euro area interbank rate), TAG (Annual rolling rate) and T4M (Monthly average rate of the Monetary Market), TAG and T4M being derived from EONIA (day-to-day rate) Capital outstanding at 31/12 of the year of publication | Rate paid for the first instalment Residual period | Rate calculated over the term of the loan Periodicity of repayments | Method of amortization of the loan: almost all of the City's loans are of the "in fine" type, i.e. fully repaid on the last day of the contract Initial rate - Rate | Possibility left contractually to the City to get out of the loan by repaying it in advance Initial rate - Index | Index type (e.g. 3-month EURIBOR, DELIVERY A ...) Initial rate - Actuarial rate | Rate calculated over the term of the loan Rate on the date of the vote on the budget or average rate recorded over the year - Rate | Rates after any hedging operations. Type of interest rate: F: fixed; V: simple variable; C: complex variable Rate on the date of the vote on the budget or average rate recorded over the year - Index | Rates after any hedging operations. Index type (e.g. 3-month EURIBOR, etc.) Rate on the date of the vote on the budget or average rate recorded over the year - Rate level | Rates after any hedging operations. For variable rate borrowings, level at the date of vote of the budget. Guaranteed annuity during the year - Interest | Interest paid by the beneficiary organisation during the financial year for the guaranteed loan Guaranteed annuity during the year - Capital | Capital repaid by the beneficiary organisation during the financial year for the guaranteed loan **Codification of ** Amortization profile of the loan:**** Acronyms have followed the evolution of regulatory publishing CA 2014 to CA 2018: C constant depreciation, P progressive depreciation, F in fine, X others (please specify). CA 2012 to CA 2013 C constant annual depreciation, P progressive annual depreciation, F in fine, S half-yearly, M monthly, X others to be specified. CA 2007 to CA 2011 C constant annual depreciation, P progressive annual depreciation, F in fine, S half-yearly, Q quarterly, M monthly, X other (DCC loans with deferred interest or compensating interest).

The benchmark interest rate in Brazil was last recorded at 14.75 percent. This dataset provides - Brazil Interest Rate - actual values, historical data, forecast, chart, statistics, economic calendar and news.

The loan providing companies find it hard to give loans to the people due to their insufficient or non-existent credit history. Because of that, some consumers use it as their advantage by becoming a defaulter.

When the company receives a loan application, the company has to decide for loan approval based on the applicant’s profile. Two types of risks are associated with the bank’s decision:

a. If the applicant is likely to repay the loan, then not approving the loan results in a loss of business to the company

b. If the applicant is not likely to repay the loan, i.e. he/she is likely to default, then approving the loan may lead to a financial loss for the company.

When a client applies for a loan, there are four types of decisions that could be taken by the client/company:

Approved: The Company has approved loan Application

Cancelled: The client cancelled the application sometime during approval. Either the client changed her/his mind about the loan or in some cases due to a higher risk of the client he received worse pricing which he did not want.

Refused: The company had rejected the loan (because the client does not meet their requirements etc.).

Unused offer: Loan has been cancelled by the client but on different stages of the process.

The objective is to identify patterns which indicate if a client has difficulty paying their installments which may be used for taking actions such as denying the loan, reducing the amount of loan, lending (to risky applicants) at a higher interest rate, etc. This will ensure that the consumers capable of repaying the loan are not rejected.

The benchmark interest rate in Norway was last recorded at 4.50 percent. This dataset provides the latest reported value for - Norway Interest Rate - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.