Category Archives: Housing Costs

State of the States: Demographic Economic Update

.. tools and resources to examine the demographic-economic state of the states .. in 2016, the U.S. median housing value was $205,000 while states ranged from $113,900 (Mississippi) to $592,000 (Hawaii). See item/column H089 in the interactive table to view, rank, compare, analyze state based on this measure … in context of related housing characteristics. These data uniquely provide insights into many of the most important housing characteristics.

Use new tools, data and methods to access, integrate and analyze demographic-economic conditions for the U.S. and states. These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

GIS, Data Integration & Visual Data Analysis
Use data extracted from these tables in a ready-to-use GIS project. These ACS sourced data (from the four tables listed above) have been integrated with population estimates trend data, components of change and personal income quarterly trend data. See details in this section.

Examining Characteristics & Trends
Below are four thematic pattern maps extracted from the main sections listed above. Click a map graphic for a larger view. Use the GIS project to create variations of these views.

Patterns of Median Age by State
Yellow label shows the state USPS abbreviation; white label shows median age. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column D017 in the interactive table to view, rank, compare, analyze state based on median age.

Patterns of Educational Attainment by State
Yellow label shows the state USPS abbreviation; white label shows % college graduates. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column S067 in the interactive table to view, rank, compare, analyze state based on percent college graduates.

Patterns of Economic Prosperity by State
Yellow label shows the state USPS abbreviation; white label shows $MHI. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column E062 in the interactive table to view, rank, compare, analyze state based on median household income.

Patterns of Median Housing Value by State
Yellow label shows the state USPS abbreviation; white label shows $MHV. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column H089 in the interactive table to view, rank, compare, analyze state based on median housing value.

Examining Characteristics & Trends; Using Data Analytics
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.

America’s Cities: Demographic-Economic Characteristics Annual Update

.. tools and data to interactively examine demographic-economic characteristics of America’s 29,321 cities/places .. understanding demographic-economic characteristics of cities and places is essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine characteristics of all cities/places in the U.S. This annual update includes data for 29,321 cities/places based on ACS 2015 data.

Accessing the Data; Using Interactive Tables
Each of the four links below opens a new page providing access to U.S. by city/place interactive tables — by type of subject matter. Use tools and usage notes below table to select operations to perform queries, sort and select columns.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

How the the Tables/Data Can be Used
The following table shows data derived from the Economic Characteristics table. The top 10 cities/places having the highest median household income ($MHI) are shown. The table also shows population, median family income ($MFI) and per capita income ($PCI). The $250,000 value is a cap; the actual value is $250,000 or higher. Use the interactive tables to create similar views for states of interest. Use the button below the table to select/view cities within a selected metro. Compare attributes of cities of interest to a peer group based on population size.

Visual Analysis of City/Place Population Patterns
Use GIS resources to visually examine city/place demographic-economic patterns. The following view shows patterns of population percent change by city in the Charlotte, NC-SC metro area.

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

Related Data
Cities/Places Main Section
Citie Population Estimates & Trends, 2010-15

More About Using These Data
Using ACS 1-year and 5-year data

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.

Tip of the Day – Median Housing Value by ZIP Code

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

.. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. based on the American Community Survey (ACS1014) 5-year estimates. See related Web section.

Option 1. View the data as a thematic pattern map; use the GIS tools:
— Median Housing Value by ZIP Code Area; Los Angeles Area
Click graphic for larger view with more detail.

View developed with CV XE GIS software. Click graphic for larger view.
Use the Mapping ZIP Code Demographics resources to develop similar views anywhere in U.S.

Option 2. Use the interactive table:
– go to http://proximityone.com/zip14dp4.htm (5-year estimates)
– median housing value is item H088; see item list above interactive table.
– scroll left on the table until H088 appears in the header column.
– that column shows the 2014 ACS H088 estimate for for all ZIP codes.
– click column header to sort; click again to sort other direction.
– see usage notes below table.

Option 3. Use the API operation:
– develop file containing $MHV for all ZIP code areas in U.S.
– load into Excel, other software; link with other data.
– median housing value ($MHV) is item B25077_001E.
click this link to get B25077_001E ($MHV) using the API tool.
– this API call retrieves U.S. national scope data.
– a new page displays showing a line/row for each ZIP code.
– median housing value appears on the left, then ZIP code.
– optionally save this file and import the data into a preferred program.
– more about API tools.
Extending option 3 … accessing race, origin and $MHV for each ZIP code …
click on these example APIs to access data for all ZIP codes
.. get extended subject matter for all ZIP codes
.. get extended subject matter for two selected ZIP codes (64112 and 65201)

Items used in these API calls:
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_023E — Housing units value $500,000 to $749,999
.. B25075_024E — Housing units with value $750,000 to $999,999
.. B25075_025E — Housing units with value $1,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

View additional subject matter options.

Option 4. View the $MHV in context of other attributes for a ZIP code.
click this link to select a ZIP code of interest.
– for example, this link shows a profile for 80204 (Denver area).
– when the report displays, scroll down in table to housing value section.

Option 5. View 5- and 10-mile circular area profile from ZIP center.
– profile for ZIP 80204 dynamically made using SiteReport tool.
– with SiteReport running, enter the ZIP code, radii and click Run.
– comparative analysis report is generated in HTML and Excel structure.
Click this link to view resulting profile.
– from the profile, site 2 is 1.9 times the population of site 1.
– Site 1 $MHV is $296,998 compared to Site 2 $MHV $269,734.
– GIS view with integrated radius shown below.

This section is focused on median housing value and ZIP code areas. Many other subject matter items will be apparent when these methods are used. Optionally adjust above details to view different subject matter for ZIP codes.

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.

Congressional District Incumbents by Location; Income & Housing Value

.. examining patterns/characteristics of 114th Congress incumbents and congressional districts … in 2014, the median family income among all 114th Congressional Districts ranged from $27,410 (NY15) to $136,376 (CA33). How do districts of interest compare? How are income and housing value among these districts changing? Use the interactive table in this section to query, view, rank, compare demographic-economic attributes among the 114th Congressional Districts. Where are incumbents located within their district? View incumbent locations and attributes in context patterns/characteristics of congressional districts using GIS tools and data. See details below. See related Web section with interactive ranking table by incumbent with district attributes.

2014 Median Household Income by 114th Congressional District
The following graphic illustrates use of the ACS 2014 data to develop a thematic pattern map of median household income by 114th Congressional District. This graphic makes use of one subject matter item among hundreds of ACS subject matter items tabulated. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about the data used to develop the above view.
— click graphic for larger view with county overlay.
    … larger view illustrates mini-profile for CD Missouri 04 (see pointer in map).

114th Congressional District Members by Location & Party
— showing incumbents as markers by party
Republicans as blue square markers; Democrats as red circular markers.
114th Congressional Districts with patterns of 2014 median family income.

— view developed using CV XE GIS software and related GIS project.

Hard Line Republicans
Incumbents are shown as hard line republicans (red square markers) and other incumbents (yellow circle markers). Incumbent locations (city-state) were geocoded enabling the view of incumbents by their city-state location. It is easy to see in the map view that there are no Hard Line Republican Incumbents (HLRIs) in California. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about data used to develop the above view.
— click above graphic for larger view with county overlay.
    … larger view illustrates mini-profile for Houston district (see pointer in map).

See main Congressional Districts page and Analyzing Characteristics of 113th/114th Congressional Districts section.

Join us in a Data Analytics Lab session to explore use of these resources and how to link/analyze these data in context of other data.

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.