Tag Archives: FHFA

Important Upcoming Data Releases: September 2017

.. monthly updates on recent & upcoming data analytics tools & resources .. this section provides a monthly update on important new data developments and applications/developments to further their use in data analytics. A focus of this section is on new or revised geographic, demographic and economic data. Most of these data are used to develop and update ProximityOne census tract-level up demographic-economic projections to 2022 and county-level up population by single year of age projections to 2060. See about September projection updates below on this page. This section is organized into recent past data updates and upcoming (month ahead) data releases and may be updated to reflect new or extended details. See related news and updates:
• What’s New daily updates
• Situation & Outlook Calendar

See related Web section.

Recent Past Data Releases/Access

U.S. by Census Tract 2017 HMDA Low & Moderate Income (FFIEC)
• Release date — 8/17; next update — mid 2018
• 2017 annual HMDA data — covers all income levels not only LMI
• New 2017 HMDA data
• See more information – access data.

U.S. by County Population by Single Year of Age (NCHS)
• Release date — 8/22/17; next update — mid 2018
• 2010 through 2016 annual population by single year of age
• New 2016 data extending annual series 2010 forward
• See more information – access updates.

Housing Price Index (FHFA)
• Release date — 8/22/17; next update — 11/28/17
• Quarterly HPI
• New 2017Q2 data extending quarterly time series.
• See more information – access updates.

Quarterly Gross Domestic Product by State (BEA)
• Release date — 9/20/17; next update — 11/21/17
• Quarterly GDP by Industry
• New 2017Q1 data extending quarterly time series.
• See more information – access data.

Upcoming Data Releases/Access 

2017 TIGER Digital Map Database (Census)
• Expected ~ 9/7/17
• Topologically Integrated Geographic Encoding & Referencing (TIGER) data.
• Geographic data; predominately shapefiles.
.. intersection to intersection road segment geography and attributes.
• New 2017 GIS/mapping shapefiles for use with wide-ranging data
.. including with Census 2010, ACS 2016 & other subject matter.
• See more information – updates to access summarized in that section.

Census of Employment and Wages (BLS/CEW)
• Release date — 9/6/17; next update — 12/5/17
• AKA ES-202 data — establishments, employment & wages by NAICS code/type of business
• U.S. by county.
• New 2017Q1 data extending quarterly time series.
• See more information.

2016 American Community Survey 1-year estimates (Census/ACS)
• Release date — 9/14/17
• Wide-ranging demographic-economic data for areas having population 65,000+
.. all states, CDs, PUMAs, MSAs and larger cities/CBSAs/school districts/counties (817 of 3142)
• New 2016 estimates.
• See more information – updates to access summarized in that section.

SY 2015-16 Annual School & School District Characteristics (NCES)
• Expected ~ 9/14/17
• National school school & school district characteristics.
• New 2015-16 school year administratively reported data.
• Schools … see more information – access updates.
• School District … see more information – access updates.

2016 Annual Gross Domestic Product by Metro (BEA)
• Release date — 9/20/17
• GDP by Industry by Metro
• New 2016 data extending time series
• See more information – access updates.

Census Tract Estimates and Projections to 2022 — ProximityOne
• Release data ~ 9/27/17
• National census tract and higher level geography demographic-economic updates
• Annual estimates & projections; 2010 through 2022
• Updated to reflect/integrate data released through 9/2017 as summarized above   • See more information.

County Population by Single Year of Age Projections to 2060 — ProximityOne
• Release data ~ 9/27/17
• National county and higher level geography demographic updates
• Annual estimates & projections; 2010 through 2060
• Updated to reflect/integrate data released through 9/2017 as summarized above.   • See more information.

Notes [goto top]
– BEA – Bureau of Economic Analysis
– BLS – Bureau of Labor Statistics
– Census – Census Bureau
– FFIEC – Federal Financial Institutions Examination Council
– FHFA – Federal Housing Finance Agency
– NCES – National Center for Education Statistics
– NCHS – National Center for Health Statistics

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Housing Price Index by 5-Digit ZIP Code

.. tools to examine housing prices by 5-digit ZIP code and how they are changing .. of the 17,931 5-digit ZIP codes tabulated, 8,074 experienced a decrease in housing value during the period 2010 to 2015. At the same time, 8,672 ZIP code areas experienced an increase in housing value. Housing prices increased for most ZIP codes from 2014 to 2014.  Find out more about housing prices and trends for ZIP codes of interest using tools described here. These data are based on experimental estimates of the Housing Price Index (HPI) by 5-digit ZIP code based in part on home sales price data from Fannie Mae- and Freddie Mac-acquired mortgages. See more about these data.

• Use the interactive table to view, rank, compare the HPI for all 5-digit ZIP code areas tabulated.
• Use GIS tools described here to develop thematic pattern maps; add your own data & geography, select different HPI measures or criteria; zoom to different geographic extents, label and modify colors as desired.

Gaining Insights in Housing Prices, Conditions & Markets
  .. Characteristics, Patterns & Trends
  .. join in .. one hour web session — overview & connectivity details

Patterns of Housing Value Change by ZIP Code: 2010-15
The following graphic shows patterns of housing value appreciation by ZIP Code: 2010-15 for the Houston metro (bold brown boundary). The color patterns/intervals are shown in the inset legend. Data are not available, using the criteria applied (2000 base year), for areas not colored In the larger view (click graphic), ZIP codes are labeled with HPI percent change from 2010 to 2015. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional views:
Atlanta area
New York City area
Washington, DC area
Los Angeles area

Examining Recent Trends; Current Estimates & Projections
The interactive table presents annual HPI data 2010 through 2015. A much larger set of these ZIP codes show a negative change between 2010 and 2015 compared to the one year change 2014-2015; The data generally show more ZIP codes experiencing housing value appreciation 2014-2015 compared to the longer period 2010 to 2015. These trends underscore the importance of having more recent data for use in analysis, planning and decision-making. The next update based on transaction data will be May 2017 or later.

ProximityOne uses the HPI transaction data with other data to develop HPI current estimates (2016) and annual projections to 2021 with quarterly updates as a part of the Regional Demographic-Economic Modeling System (RDEMS). Experimental county-up (metro, state, U.S.) and sub-county estimates and projections are planned for the fall 2016 quarterly update. The model based estimates and projections include the number of units by type and value that are added to the housing stock used to compute a variation of the HPI.

Housing Price Index by 5-Digit ZIP Code: 2010-2015
  — Interactive Table
Use the interactive table to examine the Housing Price Index (HPI) by 5-digit ZIP code. The following graphic illustrates use of the table to show the 10 ZIP codes experiencing the largest percentage increase in the HPI from 2014 to 2015. Click graphic for larger view. Examine cities or ZIP code ranges of interest using tools below the table.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

2015 Housing Price Appreciation by ZIP Code

.. housing value appreciated by 6.77% in the Houston 3-digit ZIP code 770 from the third quarter 2014 through the third quarter 2015 .. how has housing value appreciated in areas of interest during 2015?  Use the  Housing Price Index (HPI) to examine quarterly or annual housing value appreciation by 3-digit ZIP code, metro or state.  The HPI is calculated in part using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. The U.S. HPI all transactions, non-seasonally adjusted, value increased by 5.5 percent from 2014Q3 to 2015Q3. Use the interactive table in this section to compare and contrast HPI quarterly data for/among all metropolitan statistical areas, states and the U.S. Use the GIS tools and data resources reviewed in the related Web section to visually examine and map these data. Install the GIS project on your computer; add your own data.

Housing Value Appreciation 2014Q3-2015Q3 by 3-Digit ZIP Code
The following graphic shows housing value appreciation 2014Q3-2015Q3 by 3-digit ZIP code based on the HPI. Click graphic for larger view and details.

• View developed using CV XE GIS and related GIS project.
• Interactive table coming in December.
• Click to view Houston metro area .. with counties
.. Houston area view with counties shows mini-profile
for 3-digit ZIP code 770; housing appreciation 6.77% 2014Q3-2015Q3.

Related Housing Market Data & Analytical Resources
The HPI alone provides only partial insights. Evaluation of housing markets, and the regional economy, trends and patterns need to use the HPI in combination with many other measures.
2010-2014 annual population estimates: county, metro, state, U.S.
ACS 2014 1-year demographic-economic tables: county, metro, state, U.S.
Housing Unit Time Series, Trends & Patterns
Housing market conditions
ProximityOne Data Services: access/integrate these with other data
• Each data resource section has associated GIS project & datasets.
CV XE GIS software: data analytics, maps, geospatial analysis
• See related Interactive Ranking Tables

Using Tools & Data Resources in this Section
Use tools in this section to examine the quarterly HPI from 2014Q3 to 2015Q3. View/rank/compare HPI trends using the interactive table (see below). Use the GIS tools to visually and geospatially analyze patterns and characteristics of interest. Members of the ProximityOne User Group may download the HPI GIS project and use this project and datasets with the CV XE GIS software. Develop variations on maps shown in this section; add your own data.

Metro Housing Market Reports
Register for information on Metro Housing Market Reports. Updated quarterly, these reports provide a comprehensive housing market assessment and outlook for the U.S. by metro with geographic drill-down (tract and ZIP code) within individual metros.

Visual Analysis of 2014Q3-2015Q3 HPI Patterns by Metro
The following graphic shows housing value appreciation 2014Q3-2015Q3 by metro (MSA) based on the HPI. Click graphic for larger view and details.

– view developed using CV XE GIS and related GIS project.
User Group (join now) members: use HPI GIS project with CV XE GIS.

Interactive Table
The graphic shown below illustrates use of the interactive table to rank metros on the 2014Q3 to 2015Q3 quarter-to-quarter housing appreciation. Two Florida metros, Port St. Lucie and Palm Bay-Melbourne-Titusville, FL, led the nation.

– click graphic for larger view.

Use the interactive table to examine areas of interest. Join me in a Data Analytics Lab session to discuss use of these data using analytical tools and methods applied to your situation.

HPI Updates
The HPI updates quarterly for 3-digit ZIP codes, metropolitan statistical areas and other geography. The next update is scheduled for revisions and the new 2015Q4 on February 25, 2016. See in calendar and set a reminder.

Upcoming Topics
Follow my blog (click button in upper right column) where I will review related market topics, using other data resources and analytical tools available to you at no fee. Upcoming topics include an update on Low & Moderate Income by Census Tract and the Rental Vacancy Rate access, interpretation and role as a leading economic indicator.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Housing Price Index Metro & State Trends

.. HPI quarterly update … use the Housing Price Index (HPI) to examine quarterly or annual housing value appreciation by metro or state. How is housing value appreciation changing among metros of interest? The HPI is calculated in part using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. The U.S. HPI all transactions, non-seasonally adjusted, value increased by 5.25 percent from 2014Q2 to 2015Q2. During this period the Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

Use the interactive table to compare and contrast HPI quarterly data for/among all metropolitan statistical areas, states and the U.S. Use the GIS tools and data resources reviewed below to visually examine and map these data. See related Web section for more detail.

Visual Analysis of 2014Q2-2015Q2 HPI Patterns
The following graphic shows housing value appreciation 2014Q2-2015Q2 by metro based on the HPI.

– click graphic for larger view and details; view developed using CV XE GIS.
Use the HPI GIS project with CV XE GIS software; create different views.
– view/analyze different HPI measures; zoom-in; add labels.
– apply queries; add other geography/data.
– create views/graphics for reports and stories.

HPI Metro & State Patterns Interactive Table
Use the interactive table to view/rank/compare the non-seasonally adjusted “all transactions” HPI for the most recent 5 quarters for all Metropolitan Statistical Areas (MSAs), states and the U.S. The graphic shown below illustrates the start-up view of the table. The blue highlighted value shows the U.S. national annual change 2014Q2 to 2015Q2.

– click graphic for larger view

Ranking Metros
The following graphic illustrates how the table can be used to 1) select only metros and 2) rank metros in descending order based on annual change 2014Q2-2015Q2. The Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

– click graphic for larger view

Data Analytics Lab Web Sessions
The HPI provides one part of a larger picture of demographic-economic conditions and trends. Join me in Data Analytics Lab sessions where we explore the mechanics of making the HPI thematic pattern view shown above. Examine the process of integrating other data. Create variations of this view or entirely different visual analysis GIS projects.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.

Housing Price Index 2013Q3-2014Q3

The Housing Price Index (HPI) is a popular economic measure available by state and metro in a timely manner with quarterly updates.  It fits into many decision-making applications where insights are needed into how housing prices are changing by state, region and metro. This section provides an update on the HPI 2014Q3 and quarterly data for the past year. See the related Web page for more detailed data and access to the HPI data via interactive table.

Visual Analysis of 2013Q3-2014Q3 HPI Patterns
The following graphic shows housing value appreciation 2013Q3-2014Q3 by metro based on the HPI.

Click graphic for larger view and details. This view developed using CV XE GIS and related GIS project. Members of the ProximityOne User Group (join now, no fee) may used the CV XE GIS software and GIS project to create similar views with different HPI measures. Zoom-in. Add labels. Add other geography/data. Create views/graphics for reports and stories.

The Larger Picture
By itself, the HPI provides limited insights into the broader picture of “the why” and “how otherwise” states and metros are changing. The MetroDynamics Metro Profiles provide an integrated view of the HPI measure in combination with other economic, demographic and business activity measure. View the HPI integrated with other subject matter in these examples … HoustonCharlotte. Metro Profiles are updated continuously and are available for each of the 917 metropolitan areas

About the HPI
The HPI is calculated using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages, continued upward momentum in U.S. house prices remained strong in the third quarter 2014, as prices rose 0.9 percent from the previous quarter. This is the thirteenth consecutive quarterly price increase in the purchase-only, seasonally adjusted index.

As measured with purchase-only indexes for the 100 most populated metropolitan areas in the U.S., third quarter price increases were greatest in the San Jose-Sunnyvale-Santa Clara, CA MSA where prices increased by 6.6 percent. Prices were weakest in the Greensboro-High Point, NC MSA, where they fell 4.4 percent. Eleven of the 20 metropolitan areas with the highest annual appreciation rates were in California.

HPI Interactive Table
Use the HPI interactive table to view/rank/compare the non-seasonally adjusted “all transactions” HPI for the most recent 5 quarters for all Metropolitan Statistical Areas (MSAs), states and the U.S. The graphic shown below illustrates use of the interactive table to rank all metros in descending order on the percent change over the past year.

Updates
Quarterly HPI measures are used to updated the interactive table, GIS project and Metro Profiles. Use the calender to view the year-ahead HPI release and integration schedule.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.