Category Archives: Trends

Housing Price Index Updates & Trends

.. this past week we have updated Housing Price Index data and tools to examine patterns and trends for the U.S., states, metros and counties .. the Housing Price Index (HPI) is one of many measures useful to gain insights into the housing market. The HPI provides information on how housing value appreciation is changing for areas of interest. Use the interactive table to view, compare, sort metros/CBSAs based on annual HPI 2010-2017 and housing value appreciation during the period. These annual data, with a 2000 base index value of 100, provide insights into longer term patterns.  The HPI is alos updated quarterly for U.S./state/metro areas quarterly for analyses requiring more recent data.  These data are new as of February 2018.

Visual Analysis of Housing Price Appreciation
The following graphic shows housing value appreciation as of 2017 based on the HPI with 2000 base of 100 by county in the Charlotte, NC-SC metro area. See more about by HPI by county for the Charlotte metro.

– view developed using CV XE GIS and related GIS project.
– Click graphic for larger view and details.

See similar HPI 2017 patterns view for the Houston, TX metro.

Housing Price Appreciation 2010-2017 — Largest 10 Metros
This table, derived from the  interactive table, shows the largest 10 metros based on total population. the HPI 2010, HPI 2017, housing price appreciation 2010-2017 and total population are presented in the table. Click the CBSA code link to view HPI by county component for the metro and an extended series.

 Metro CBSA HPI2010 HPI2017 HPA1017 Pop2016
 New York   35620 159.53 172.76 8.29 20,153,634
 Los Angeles   31080 169.83 242.78 42.95 13,310,447
 Chicago   16980 117.48 124.58 6.04 9,512,999
 Dallas   19100 120.89 175.35 45.05 7,233,323
 Houston   26420 134.02 183.52 36.93 6,772,470
 Washington   47900 166.82 198.74 19.13 6,131,977
 PhiladelphiaA   37980 157.26 162.91 3.59 6,070,500
 Miami   33100 140.43 213.91 52.33 6,066,387
 Atlanta   12060 103.95 129.24 24.33 5,789,700
 Boston   14460 134.33 165.27 23.03 4,794,447

– Metro names abbreviated; use table to view full name and code.

Using the HPI Annual 2010-2017 Interactive Table
The following graphic illustrates use of the HPI Annual 2010-2017 interactive table. Click graphic for larger view. This view shows metros in the 250,000-300,000 population peer group. Set your own criteria using tools below the table. There are 23 metros in this group. The table has been sorted on housing price appreciation (HPA) from 2010-2017 (second column from right). It shows that the Merced, CA metro had the highest HPA — 82.13% di=uring this period.

Use the interactive table and examine areas of interest.

Data Analytics Web Sessions
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.

 

 

Examining Health Care Infrastructure by ZIP Code

.. small area data providing information on sub-county and sub-city/place geographies are challenging to locate and use — particularly in context of demand for healthcare services and demographic attributes of associated neighborhoods. Develop insights into the healthcare infrastructure by ZIP code using the two related resources reviewed here — 1) individual ZIP code demographic-economic profiles and 2) ZIP code demographic-economic interactive tables. One way to examine the healthcare infrastructure for an area is to view/analyze the number and attributes (employment, earnings) of healthcare establishments by types of business/industry (such as physicians office or hospitals). Data and tools reviewed here provide insights into characteristics and patterns of national scope ZIP code areas — examine your ZIP codes of interest.

Option 1 — ZIP Code Profiles
.. examining the healthcare infrastructure in context of the related demographic-economic situation … the following graphic shows ZIP code 10514 (Westchester County, NY) with a bold red boundary.  Census tracts are shown with black boundaries with tract codes as white labels. See more about ZIP-Tract relationships. Cities/places are shown with blue cross-hatch pattern.

– view created with CV XE GIS software and related GIS project.

The above map graphic is part of a ZIP Code 10514 profile (click link to view complete profile). Section 3.1. of the profile shows the number healthcare establishments in the ZIP Code as partly shown in this graphic:

The portion of the table shows the NAICS/type of business code at left, followed by type of business description and the number of establishments at the right.

Examine other characteristics of this ZIP code profile and in context of others via this related Web section. These profiles update in May 2018.

Option 2 — ZIP Code Health Care Sector comparative analysis
.. examining the healthcare infrastructure for a set of ZIP codes in a state, metro, county or peer group … use the interactive table located here to view/rank/compare health care business establishments by type of business for a selected set of ZIP codes. This table shows a query placed on the table to show the total number of offices of physicians for ZIP codes in the vicinity of ZIP 10514. It shows that there are 14 offices of physicians establishments and 13 have 1-4 employees.

About These and Related ZIP Code Data
Data used to develop the tools/resources described above are based in part on the Census Bureau County Business Patterns program. These establishment data update annually.

ZIP code demographic-economic interactive tables
Use the following tables to examine a wide range of ZIP code demographic-economic conditions:
  • General Demographics
  • Social Characteristics
  • Economic Chacteristics
  • Housing CHaracteristics

Data Analytics Web Sessions
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.

2018 U.S. & World Population

.. Welcome to 2018 .. how the U.S. and world are changing …

The Census Bureau estimates the U.S. population is 326,971,407 as of January 1, 2018. This represents an increase of 2,314,238, or 0.71 percent, from New Year’s Day 2017. Since Census Day (April 1) 2010, the population has grown by 18,225,587, or 5.90 percent.

In January 2018, the U.S. is expected to experience one birth every 8 seconds and one death every 10 seconds. Meanwhile, net international migration is expected to add one person to the U.S. population every 29 seconds. The combination of births, deaths and net international migration will increase the U.S. population by one person every 18 seconds.

The world population on January 1, 2018 is estimated to be 7,444,443,881. The world has experienced a population increase of 78,521,283, or 1.07 percent, from New Year’s Day 2017. During January 2018, 4.3 births and 1.8 deaths are expected worldwide every second.

Patterns of Population Change by State, 2010-2017
The following graphic shows patterns of percent population change from 2010 to 2017. Use the associated GIS project to examine different years or subject matter items. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

How the U.S. Population is Changing
The following graphic shows how the population of the U.S. has changed from 2010 to 2017 and how the population might change 2018 through 2020. Click graphic for large view. The population is as of July 1 for each year. The components of change (birth, deaths and migration) are for the period July 1 through June 30 for that year.

Population for each year is computed by the population identity equation:
  P[t]=P[t-1] + B[t,t-1] -D[t,t-1] + M[t,t-1]
Viewing the larger image, see how each of the components of change are impacting the total population and population change.
… see more detail about these data for the U.S. and by state at http://proximityone.com/states2017.htm.

More About Population Trends, Patterns and Characteristics
See more about how population dynamics; use the interactive tables in these sections:
  • School Districts — http://proximityone.com/sdtrends.htm
  • Cities — http://proximityone.com/places2016.htm
  • Counties — http://proximityone.com/countytrends2016.htm
  • Metros — http://proximityone.com/metrotrends2016.htm
  • States — http://proximityone.com/states2017.htm

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.

School District Demographic Trends: 2010-2016

.. while enrollment in many school districts is growing, for many it is declining — these include some of the largest districts. Declining enrollment in school districts can result in school closings that destabilize neighborhoods, cause layoffs of essential staff and concerns that the students who remain are some of the neediest and most difficult to educate. See related narrative.

Based on total population, the largest 10 school districts in 2016 (see table below), all experienced an increase in population over the period 2010-2016. Five of these districts had a decrease in school age population (ages 5-17 years). Five of these districts had a decrease in the number of related children in poverty in families ages 5-17 years.

See the related Web section that provides tools to analyze annual demographic data for each U.S. school district for the period 2010 through 2016. This post summarizes selected details. These data include Census Bureau official 2016 estimates available for all districts. Developed for use as inputs for the ESEA Title I allocation formula, the data have broader uses of interest to school district demographics stakeholders. The 2016 estimates were released in November 2016; 2017 estimates become available in late 2018. ProximityOne uses these data in combination with other data to develop school district current estimates and annual projections through 2022 with related drill-down demographic-economic subject matter. Use the interactive table in the Web section to view, rank, compare demographic characteristics of districts of interest.

Largest 10 School Districts based on 2016 Population Age 5-17

Patterns of 2016 School Age Population in Poverty by School District
The graphic below shows school districts with total 2016 population of 1,000 or more by poverty incidence. Markers show the population ages 5-17 in families in poverty as a percent of population ages 5-17. Salmon markers: 40-50%. Red markers: 50% or more.

– view developed with CVGIS software and related GIS project.

School District Demographic Trends Interactive Table
Use the interactive table to view, rank, compare demographic characteristics of districts of interest.

More About K-12 Education & Children’s Demographics
See the related section on School District Demographic Trends 2010-2016:
http://proximityone.com/sdtrends.htm.

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 L

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.

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.

Metro Population & Components of Change Trends 2010-2016

.. tools and data to examine how the U.S. by metro population is changing. Is the population moving away or into metros of interest? What are the trends; what is causing the change? What are the characteristics of the population moving in and out? How might this impact your living environment and business?

This section provides information on how and why the population is changing by metro from 2010 to 2016 in terms of components of change: births, deaths and migration. It provides a summary of tools, interactive table and GIS project, to analyze population change by metro using latest Census Bureau estimates through 2016. These data are used by ProximityOne to develop/update annual demographic-economic projections.  See related Web page to access full interactive table and more detail.

Patterns of Population Change by Metro, 2010-2016
The following graphic shows how metros (MSAs – Metropolitan Statisticsl Areas) changed from 2010 to 2016 based on percent population change. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Narrative Analysis of Metro Demographic Change in Context
A narrative summary and analysis of metro demographic characteristics and change, contextually with other data and geography, is provided for each metro in the Situation & Outlook Reports. See more about the wide-ranging subject matter that are knitted together in the schedule of updates. Examine metro dynamics in context of the U.S. overall and related states and counties.

The nation’s 382 Metropolitan Statistical Areas (MSAs) had a population of 277.1 million in 2016 (86% of the total population). MSAs increased by 2.3 million people from 2015. The nation’s 551 Micropolitan Statistical Areas (MISAs) had a population of 27.7 million in 2016 (9% of the total population). MISAs increased by 16,000 people from 2015. See more highlights below

MSAs and MISAs together, or metro areas, comprised the set of Core-Based Statistical Areas (CBSAs). Each metro/CBSA is defined as a set of one or more contiguous counties.

Related Sections
• Metros Main
• Situation & Outlook Reports
• City/Place Population Trends
• County Population Trends
• County Population Projections to 2060
• ProximityOne Data Service

Examining Population Components of Change
Population change can be examined in terms of components of change. There are three components of change: births, deaths, and migration. The change in the population from births and deaths is often combined and referred to as natural increase or natural change. Populations grow or shrink depending on if they gain people faster than they lose them. Examining a county’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

See more about these topics below:
• Natural Increase/Change; birth & deaths
• Migration; net international, net domestic, net migration

Using the Interactive Table – Peer Group Analysis
Use the full interactive table to examine U.S. national scope metros by population and components of change. Consider an application where you want to study metros having a 2016 population between 250,000 and 300,000. Use the tools below the interactive table to select these metros as illustrated in the graphic shown below. The graphic shows these metros ranked on the overall U.S. metro rank (percent population change 2010-2016). As shown in the graphic, the Greeley, CO metro was ranked 11th among all metros and the fastest growing metro in this group. Use the tools/buttons below the table to create custom views.

Click graphic for larger view.

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.