Data: Historical and Forecast Databases
Historical Data
Comparison With Other Data Sources
Forecast Data
Consumer Credit Data Series
Geographic Levels
Economic Data Series
Blended Variables
Historical Data
The historical credit data are made available from the Equifax National Consumer Database, which contains information collected from over 12,000 contributors who furnish data on tradelines, collections, public records and demographics across a broad range of industries, with updates on a daily basis.
Within a month, the database experiences on the order of 1.7 billion tradeline updates, 120 million collection updates, 350,000 public record updates, 185,000 bankruptcy updates and 12 million address changes. Information being added to the database goes through a rigorous quality assurance process, including automated and manual reviews, to ensure the highest accuracy possible.
The credit data are sourced from the full Equifax credit database and include consumers with >=1 active trade. This results in approximately 226 million consumer records in a given month. Selection always occurs at the end of the month, so that the results are not affected by any in-month reporting fluctuations. Monthly historical files starting with June 2005 were used. Therefore, full “open-to-close” vintage data are available starting with July 2005, while information on trades in older vintages – when available from the consumer credit files – is also included.
Equifax developed special credit trend attributes that aggregate the consumer file into attributes specifically intended for monthly trending. These attributes consider only trades with activity in the last three months and only look at current delinquency statuses in order to focus on the true state of credit (balances, high credit, delinquencies, etc.) in a given month. These attributes were calculated for each consumer file and then aggregated to the ZIP code, county, MSA and state levels. This will allow CreditForecast.com to quickly adapt to any future changes in county or MSA definitions.
Origination and current risk score level classification are done at the consumer level, based on ERS 3.0 – Odds Scale (score range 280-850). There are four score bands, allowing the user flexibility in identifying consumer risk profiles of interest. Forecasting is done separately for each of the score bands; the total forecast is additive.
| Score Bands |
| <=620 |
| 620-659 |
| 660-699 |
| 700+ |
| Missing Score |
Comparison With Other Data Sources
The historical CreditForecast.com data have a number of significant advantages over publicly available sources of credit data. These other sources include data on consumer loan delinquencies from the American Bankers Association, mortgage loan delinquency and foreclosures available from the Mortgage Bankers Association, and consumer and mortgage delinquency and charge-off data available from the Federal Reserve Board and FDIC.
The most significant advantage of the CreditForecast.com data is that they are available for the nation, states, and metropolitan areas. The ABA and MBA data is available only for the nation and states, and the Federal Reserve Board and FDIC data is only available for the nation.
The CreditForecast.com data are also timelier than the other sources of credit data. They are made available within four weeks of the end of the month, compared to two to three months after the end of the quarter for the other sources.
The CreditForecast.com data is also based on where the borrower resides. The ABA data, by contrast, are based on the branch or operating location of the lending institutions participating in the survey. This may or may not coincide with where the borrower lives. This is of particular importance for the ABA’s data on bankcards, given that many of the cards are originated by lenders with operations in New York, Delaware and South Dakota to borrowers that live all over the country. The MBA does ask lenders to report by the state where the property is located.
Since the CreditForecast.com data are based on borrower information, they are not affected by changes affecting lenders. The ABA and MBA data can be significantly affected by any change in the lenders included in their surveys. For example, the MBA has previously expanded the number of subprime mortgage loans in its survey, resulting in a substantial increase in measured credit problems. The Federal Reserve and FDIC data, which are based in part on call reports provided by lending institutions, can also be affected by changes in the status of lenders. Historically, the acquisition by a large commercial bank of a retailers’ credit card portfolio and the resolution of failing lending institutions have affected measured credit quality.
Forecast Data
Projections of the credit, economic and demographic variables are available with a quarterly periodicity and a five-year forecast horizon.
Forecasting is done for the origination and current risk score bands separately; the total forecast is additive. The forecast database includes a baseline, most probable, forecast and four alternative scenarios. The alternative scenarios vary according to where we are in the business cycle. The forecasts are updated with new history and forecasts four times per year.
The economic and demographic forecasts are produced using the detailed econometric model system of Moody’s Analytics. A description of this system is available upon request. The credit forecasts are produced with a model developed using a recursive pooled time series, cross-sectional specification. Each equation is estimated for all metro areas using the available historical data. The equations are log-linear in form, meaning the terms (unless otherwise indicated) are specified as the natural logarithm and the coefficients can be interpreted as elasticities. All the equations contain metro area-specific constant terms to capture the metro area-specific fixed effects. Finally, all of the equations contain an autoregressive term to capture the inertia in the series.
Consumer Credit Data Series
For each of the categories, historical data and forecasts are available at the national, Census region, Census division, state, and Metropolitan Statistical Area (MSA) levels for the following variables:
- Total Trades
- Total Trades with >$0 Balance
- Total Balances
- High Credit/Loan Amount
- Utilization/Balance Outstanding
- Payment Amount
- Delinquency counts, dollars and rates (percent of counts and percent of dollars)
Total, Current, 30 DPD, 60 DPD, 90 DPD, 120+ DPD and Collections, Foreclosure Started, Other Status
- Final Disposition counts and dollars
Default (Closed Negative), Bankruptcy, Closed Positive
Historical and forecast data are available for several consumer credit risk and bankruptcy scores. Mean Credit Scores for the nation, regions, divisions, states, and MSAs are provided.
| Score |
Range |
Performance Period |
| Equifax Risk Score 3.0 – Odds Scale |
280-850, higher score=lower risk |
90+ Days Past Due or Worse in 24 Months on Consumer Credit |
| VantageScore |
501-990, higher score=lower risk |
90+ Days Past Due or Worse in 24 Months on Consumer Credit |
| Bankruptcy Navigator Index 3.0 |
1-300, higher score=lower risk |
Bankruptcy in 24 Months |
| Telco Risk Score – Odds Scale |
0-999, higher score=lower risk |
Non-pay disconnect or write-off in 12 Months on Telecommunications |
| Advanced Energy Risk Score |
1-999, higher score=lower risk |
90+ Days Past Due or Worse in 12 Months on Energy |
Range distributions for ERS 3.0 are also included, as number and percent of consumers:
| 740 to 850 |
| 720 to 739 |
| 700 to 719 |
| 680 to 699 |
| 660 to 679 |
| 640 to 659 |
| 620 to 639 |
| 600 to 619 |
| 580 to 599 |
| 280 to 579 |
Trades are also classified according to their account holder’s ERS 3.0 score at loan origination and at the current period, according to the following score bands:
|
<=620 |
| 620-659 |
| 660-699 |
| 700+ |
| Missing Score |
Geographic Levels
- U.S.
- 4 Census Regions
- 9 Census Divisions
- 50 States
- 200 standard MSAs and 50, non-urban, rest-of-state areas
Economic Data Series
Forecasts and historical trends (economic series availability varies based on category purchased) include:
- Employment, unemployment
- Population, households
- Income (median household, personal, disposable personal)
- Personal savings rate, real net worth
- Debt service ratio, consumer credit debt outstanding (revolving, non-revolving), household financial obligations ratio (homeowners, renters)
- Bankruptcies by chapter (7 and 13)
- CPI (overall, new/used vehicles, trucks, gasoline, housing, etc.)
- Sales (car, truck, house, retail, etc.)
- Home prices (median, FHFA), housing affordability
- Interest rates (federal funds, prime rate, credit card, commercial bank new car loan, etc.)
- GDP
- Vehicle price (Manheim Index)
- Population by age (large groupings)
Historic trends only:
- Homeownership rate by race
- Homeownership rate by age
- Total international migration
- Population breakouts by age (finer groupings), Hispanic status, gender, race, and cross products
Blended Variables
CreditForecast.com includes unique blended series created by merging economic data with credit data. These blended series are available for historic data and forecasts, and for all geographies.
- Loan-to-Value Ratio (First Mortgage, Total Mortgage)
- Equity per Household (Total Mortgage)
- Equity Extraction to Income Ratio (Total Mortgage)
- Debt Service Burden (Total)
The Loan to Value Ratio (LTV) is the measurement of aggregate mortgage balances outstanding to the value of the housing stock. Homeowners’ Equity per Household is the difference between the home value and mortgage debt for an average household. These series provide information on homeowners’ real estate wealth, the equity cushion against a housing downturn, and the size of real estate debt.
The Equity Extraction to Income Ratio measures the extraction of equity on existing homes as a percentage of disposable income. This series is calculated using a similar methodology developed by former Chairman Alan Greenspan and Fed economist James Kennedy. Equity extraction is the amount homeowners are withdrawing from their housing wealth, potentially to be used for home improvements, consumption and debt restructuring.
The Debt Service Burden is the minimum amount households must pay to service their debt as a share of their disposable income. The regional series is constructed using a methodology similar to that used by the Federal Reserve in constructing national estimates and is benchmarked to be consistent with that series nationally. The debt service ratio is an accurate measure for households’ financial burden, although it is sensitive to changes in homeownership rates.