Tag Archives: county demographics

County Housing Patterns & Trends

.. at a time when “housing costs are going through the roof” and “affordable housing” are topics widely in play, current housing data at the county level are essential for business and public policy planning. In this section, new Census Bureau U.S. by county 2018 housing unit estimates are viewed .. and tools to access and use these data.

Patterns of Housing Unit Percent Change by County: 2010-2018
The graphic below shows patterns of county housing unit percent change from 2010 to 2018. Click graphic for larger view showing more detail.

– view developed using CV XE GIS software and associated GIS project.
– create similar maps for counties/areas using CV XE GIS & associated GIS project.

This section reviews the new 2018 county housing unit estimates (released May 2019) and tools and applications to analyze them. See more about topics covered here in this related Web section.

The U.S. housing stock grew by more than 1.15 million from 2017 to 2018, reaching over 138.5 million units. The growth rate of 0.8 percent from 2017 to 2018. The national housing stock increased by 6.7 million units (5.1 percent) between 7/1/2010 and 7/1/2018. But housing stock change was far from even as shown in the graphic presented above.

Total housing units are the “tip of the iceberg” to examine housing market characteristics. Yet, there are no other Federal statistical data for any other housing attribute for every county more recent than circa mid-2015. Those data are from the American Community Survey 5-year estimates for the period 2013-2017 — data going on 4 years old. For example, there are no Federal statistical data for all counties for the 2018 number of households or vacant units … let alone measures that would enable computing the size and location of affordable housing, one of many important housing market attributes. Use related 2018 and projected housing market data developed by ProximityOne available as part of the Situation & Outlook demographic-economic estimates and projections. Examine these data in context with other geographic and market characteristics in the metro Situation & Outlook reports.

Using the Interactive Table
Use the interactive table to view, rank, compare states and counties based on number of units annually 2010 to 2018 and related measures. Compare counties among metros or states .. or peer groups based on size. Here are two examples of using the table.

Largest Counties based on 2018 Housing Units
.. ranked on 2018 housing units .. click for larger view

Counties with 10,000 or more 2018 Housing Units
.. ranked on percent change 2010-2018 .. click for larger view

Data Analytics Web Sessions
See these applications live/demoed. Run the applications on your own computer.
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.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are 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 these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

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.

County Population & Components of Change Trends

.. new/updated annual county population estimates … counties, and county equivalent areas such as independent cities, are the primary political subdivision of states.  The relative stable geography of counties, with good national scope geographic granularity, makes these areas appealing for use in tabulating data as well as analyzing data. This section provides information on tools and data related to accessing, integrating analyzing county demographic-economic patterns and trends focused on the latest official county population and components of change estimates (through 2014, released March 2015). See related Web page for more details.

Using GIS Tools to Examine Patterns of Population & Change
The following view illustrates use of Geographic Information System (GIS) tools to visually examine demographic characteristics of Charlotte-Concord-Gastonia, NC-SC MSA region by county. The thematic/color pattern shows percent population change 2010-2014. Labels show county 2014 population. Develop this type of view for any metro or region.

— view created using CV XE GIS and associated CountyTrends GIS Project
— click graphic for larger view showing details.

See the Metro Profile for this metro. See more about metros. Click on a metro link in the in the metro interactive table to view a similarly structured profile for any metro.

Population Components of Change
Annual population and components of change estimates for each county, 2010 though 2014, are included in the dataset used in the create the map shown above. Similar thematic pattern maps can be generated for any county/region for any of these items, or computed items such as birth rate.

Population components of change are shown in the population identity:
P[i,t] = P[i,t-1] + B[i,t] – D[i,t] + MD[i,t] +MI[i,t]
for the ith geographic area; t: year
where the components of population change are:
  – B[i,t] … births in area i in year t
  – D[i,t] … deaths in area i in year t
  – MD[i,t] … domestic migration in area i in year t
  – MI[i,t] … international migration in area i in year t

County Population & Components of Change Interactive Table
Use the interactive table in the related Web section to interactively view, rank, compare annual population and population components of change for all states and 3,143 counties. For counties that are part of a metropolitan area, the table includes the new and previous metro (CBSA) codes.

The following graphic illustrates use of the interactive table. A query is used to view only those counties in the Charlotte metro. These rows/records are then sorted (dbl-click column header) on the Census 2010 population. It can be seen from the table that Mecklendurg County has the largest Census 2010 population (919,628) and the metro Census 2010 total population is 2,217,012.

— click graphic for larger view showing details.

Examining Characteristics of Individual Counties
Click on the Mecklenburg County link in the interactive table to view an extended profile for the county (available for any county) as shown below.

— click graphic for larger view showing details.

Use the interactive table and click on a county link to view a similar profile for county(s) 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.