Category Archives: Patterns

How & Why County Demographics are Changing

.. the pandemic impact on population change remains in flux. For many counties it will impact each component of population change: births, deaths and migration. The magnitude and duration of the impact on each component will vary by county and become more measurable in the months ahead. The “How & Why County Demographics are Changing” will be updated later in 2020.

Here we look at population and components of change by county for the period 2010 to 2019 .. tools and data to examine how the U.S. by county population is changing. These latest 2019 estimates were released this spring. See more in the related web section.

Top 25 Counties with Largest Population Change 2010-2019
Create a table similar to the one shown below using the interactive table. Sort on selected criteria and within a selected state or metro.

Patterns of Population Change by County, 2010-2019
The following graphic shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2019. Click graphic for larger view; expand browser window for best quality view.

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

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. The above graphic shows these relationships.

County Population & Components of Change 2010-2019 – Interactive Table
View/analyze county population and components of change characteristics and trends in a tabular manner using the interactive table. The following static graphic shows net migration 2010-2019 by year for Houston, TX metro component counties. Rows have been ranked in descending order based on 2010 population. It is easy to see how the net migration in Harris County has been decreasing annually since 2015.

Try it yourself. Use the interactive table to examine counties/areas of interest.

Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

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.

Relating ZIP Codes and Census Tracts

.. what census tracts intersect with a ZIP code of interest? There are many reasons for the underlying the need to convert/equivalence ZIP codes to/from census tracts. Some organizations have to provide census tract codes for addresses/ZIP codes of clients to be in compliance with a law or regulation. Some organizations have addresses/ZIP codes of clients/locations for which they would like to determine the corresponding census tract codes to analyze census tract demographics. This post reviews tools and options for these operations. See related Web section to access interactive table and learn more about mapping and geospatially relating these two geographies.

Phoenix/Scottsdale, AZ ZIP Code-Census Tract Relationship
The following graphic illustrates the relationship between ZIP code area 85258 (orange fill pattern) with census tracts (green boundaries and geocode labels).
(StCtyTract=04013216813).
.. view created with ProximityOne CV XE GIS software and related GIS project.

Create your own maps of areas relating ZIP codes and census tract, in context of other geography. Use the CV XE GIS with shapefiles.

Using the Interactive Table
Use the ZIP code to census tract interactive table (opens new page) to answer questions such as:
• Which census tracts intersect with a ZIP code of interest?
• Which ZIP code(s) intersect with census tract(s) of interest?
• What is the Census 2010 population for a census tract and ZIP code combination?

The interactive equivalence/look-up table shows a row for each unique combination of a Census 2010 ZIP code area and Census 2010 census tract. The start-up view is sorted on the State-County-Tract column (StCtyTract). View ZIP codes in one state using the State selection button. To locate a ZIP code of interest, either use the Find ZIP query or sort on the ZIP code column and then scroll down the table until the ZIP of interest is located.

Example. Click Find ZIP button using the interactive table (opens new page) to view only the tracts intersecting with ZIP code 85258 (as shown in map view above). The Location 1 marker (see pointer in map) is located in the area intersecting ZIP code 85258 and census tract 2168.13. The refreshed table view is shown by the graphic below. There are nine tracts intersecting with this ZIP code; see the tract codes in the table.

Try this for a ZIP of interest:
• View the interactive table (opens new page).
• Click the Showall button below table.
• Key in your 5-digit ZIP code in edit box where 85258 now shows.
• Click Find ZIP button.
• Table refreshes showing only tracts intersecting with this ZIP code.

Scope of Tracts and ZIPs in Table
There are 150,806 rows in the table, each showing a unique combination of a census tract (73,057 Census 2010 tracts) and ZIP code area (33,120 Census 2010 ZCTAs). Each row represents an intersection of the specified census tract and ZIP code area and corresponds to a geographic area of one census block or more. The total population and housing units values have been derived by summing component census block values. The sum of the population column is 308,745,538, the United States Census 2010 total population.

Situation & Outlook Weekly Web Sessions
Join me in a Situation & Outlook web session to discuss more details about demographic-economic estimates and projections.

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.

116th Congressional Districts & Patterns of Economic Prosperity

.. Congressional District Analysis and Insights .. tools to examine patterns of median household income .. median household income is one measure of economic prosperity. This section reviews patterns of median household income (MHI) by 116th Congressional Districts based on the 2018 American Community Survey 1-year estimates (ACS 2018). View, rank, compare the MHI by congressional district, among related demographic attributes using the interactive table on the main Congressional Districts page.

116th Congressional District Analysis & Insights
.. patterns of household income & economic prosperity:
Based on the ACS 2018 median household income (MHI):
• the MHI among all districts was $60,291
• the U.S. overall MHI was $61,937
As of November 2019:
• the 19 districts with highest MHI have Democrat incumbents
• the 10 districts with the highest Gini Index have Democrat incumbents
• there are 69 Republican incumbent districts above the all districts MHI
• there are 149 Democrat incumbent districts above the all districts MHI
• the MHI of the 236 Democrat incumbent districts is $66,829
• the MHI of the 199 Republican incumbent districts is $56,505
Median household income is only one measure of economic prosperity.
See more at http://proximityone.com/cd.htm.

Patterns of Economic Prosperity 116th Congressional District
The following graphic shows patterns of 2018 median household income by 116th Congressional District. Use GIS tools/data to generate similar views for any state and/or drill-down. Click graphic for larger view with more detail. Expand browser window for best quality view.

– view developed using ProximityOne CV XE GIS and related GIS project.

Using the Interactive Table
— view, rank, compare districts based on your criteria.
— example,which districts have the highest median household income?
Use the interactive table to examine incumbency and and demographic characteristics of the 116th Congressional Districts (CDs). The following view illustrates use of the table. This view shows use a query to show the ten CDs having highest 2018 median household income.

Try using the interactive table to existing districts and categories of interest.

Congressional District/State Legislative District Group
Join in .. be a part of the Congressional Districts/State Legislative District (CDSLD) group. Access analytical tools and data. Learn about CDSLD analytics, patterns and trends. Share insights with like-minded stakeholders.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.

Personal Consumption Expenditures by Type & State

.. using Personal Consumption Expenditures (PCE) measures to monitor/examine the strength of a regional economy and consumer buying trends in that region and compare among regions … PCE estimates released in October 2019, show that state personal consumption expenditures increased 5.1 percent in 2018, an acceleration from the 4.4 percent increase in 2017. The percent change in PCE across all states ranged from 7.3 percent in Utah to 3.6 percent in West Virginia.

In 2018, across all states and D.C., per capita PCE was $42,757. Per capita PCE by state ranged from a high of $55,095 (MA) to a low of $31,083 (MS). Per capita PCE in D.C. $63,151. Use the interactive table to example per capita and total PCE by state for 24 categories annually 2010 to 2018.

Per Capita Personal Consumption Expenditures by Category; U.S. 2018
— how does your situation and areas of interest compare to U.S. overall?
— view, sort, query by state and year in the interactive table

Goods and services purchased by people are personal consumption expenditures (PCE). These data provide insights into the strength of a state economy and consumer buying trends. As a major component of GDP, PCE growth has recently accounted for much of the GDP growth. The data reviewed in this section are developed by the Bureau of Economic Analysis (BEA, released each October). ProximityOne develops regional PCE estimates by metro and county. More about PCE.

See related sections:
• State Real Median Household Income
• State Annual Gross Domestic Product by Industry

Per Capita Consumption Expenditures by State, 2018
The following graphic shows patterns of 2018 per capita personal income expenditures (PCE). Intervals show distribution in quintiles, equal number of states per interval. The 2018 U.S. per capita PCE was $42,757. Use CV XE GIS project to examine PCE by types, per cpaita vs total, different years and change. Integrate additional subject matter and types of geography. Click graphic for larger view with details. Expand browser window for bets quality view.

– view developed with ProximityOne CV XE GIS and related GIS project & datasets.

Using the Interactive Table
— which areas have the highest health care expenditures?
Use the interactive table to examine personal consumption expenditures by type and state annually for the period 2010-2018. The following view illustrates use of the table. This view shows use a query to examine only health care expenditures. The table was then sorted in descending order to show the areas with the highest per capita health care expenditures in 2018.

Try using the interactive table to existing states or categories of interest.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.

American Community Survey 2018: Geography & Access

.. there are 519 core-Based Statistical Areas (metros & micros) included as American Community Survey (ACS) 2018 tabulation areas. 2018 demographic-economic estimates are included for these and many other types of political/statistical areas — the subject of this section. This is the first in a series of posts about accessing, integrating and using the ACS 2018 data. Learn more about effective ways to use these and related data. See the main web section for more detail and access to the interactive table. The release date for the ACS 2018 data is September 26, 2019.

ACS 2018 1-year Tabulation Areas: 519 Core-Based Statistical Areas
— MSAs and MISAs

– view developed using ProximityOne CV XE GIS and related GIS project.
– geospatial analyze ACS 2018 1 year estimates integrated with your data to examine patterns; gain insights.

The 2018 American Community Survey (ACS 2018 main) is a nationwide survey designed to provide annually updated demographic-economic data for national and sub-national geography. ACS provides a wide range of important data about people and housing for every community across the nation. The results are used by everyone from planners to retailers to homebuilders and issue stakeholders like you. ACS is a primary source of local data for most of the 40 topics it covers, such as income, education, occupation, language and housing.

Determining What Data are Tabulated
The graphics below illustrate 1) the scroll section that lists the types of tabulation areas (summary levels) and 2) use of the interactive table to display a selection of CBSAs/metros (summary level 310).

ACS 2018 1-Year Summary Levels
The scroll section (see in web page) shows the summary level code (left column), part or component if applicable and summary level name.

ACS 2018 1-Year Estimates — Areas Published — Interactive Table
The interactive table (click link to view actual interactive table) enables you to list the geographic areas tabulated. This graphic shows CBSAs (MSAs and MISAs) tabulated. GeoID1 shows the unique tabulation area geocode for an area among all areas. GeoID1 inlcudes the summary level (first 3 characters), followed by state FIPS code where applicable, ‘US’ and finally the geocode for the specific area.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.

Combined Statistical Area Demographic Trends

.. a Combined Statistical Area (CSA) is a group of two or more adjacent metropolitan areas; they include contiguous metro counties that have demographic-economic affinity. These 172 areas (September 2018 vintage) are important in wide-ranging geographic and demographic analysis. Based on the 2018 population estimate, these areas include 256.2 million population of the total U.S. population of 327.2 million (78.3 percent). CSAs are at least two adjacent metropolitan areas — reflecting a larger and broader market/service/impact assessment area. Due to their size (of many), it is often possible to develop more detailed custom demographic-economic estimates and projections than at the county or metropolitan area level. See more about CSAs in this related Web section.

Patterns of 2018 Population by 2018 CSA
The following graphic shows the September 2018 vintage CSAs based on the 2018 official population estimates. The intervals/colors are depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest. Use the GIS project/datasets to examine alternative patterns such as percent change for different time periods. Set queries to include CSAs by peer group. Click graphic for larger view with more detail; expand browser window for best quality view. Larger view shows CSAs labeled with percent population chnage 2010-2018.

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

Use the GISproject and datasets to examine CSAs in a mapping and geospatial analysis context. The database includes all CSAs and the subject matter described below.

Using the Interactive Table
Use the interactive table (opens new page) to examine patterns and relationships among CSAs of interest. The following static graphic illustrates how the table can be used to rank or query CSAs and display selected columns. Selecting population change columns and ranking in descending order on population change 2010-2018, shows that the Dallas CSA had the largest population … it also shows this CSA was the 7th largest CSA based on 2018 population and 9th on percent population change 2010-2018 … use the table to determine which CSA ranked first on percent population change 2010-2018.

– click graphic 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.

The Local Area Monthly Employment Situation

.. in June 2019, the local area unemployment rate ranged from 1.3% (Lyon County, IA) to 19.6% (Yuma County, AZ) among the lower 48 states. 133 counties had an unemployment rate of 7% or more during June 2018 through June 2019. Over the past year, as shown in the this interactive table, the unemployment rate has generally decreased among all counties. We track the local area employment situation historically and develop alternative scenario projections. See the related Web page for more information.

Patterns of Unemployment Rate by County
The following graphic shows patterns of the estimated June 2019 unemployment rate by county. Use the GIS tools and data to develop variations of this view optionally integrated with other data. Click graphic for larger view. Expand browser window for best quality view.

— view created using the ProximityOne CV XE GIS and associated GIS Project

Examine Areas of Interest
This graphic illustrates the monthly over the year employment situation for the Houston, TX metro using the interactive table.

Click graphic for larger view.

Create a similar table for any metro:
Open the interactive table (green and white table midway down).
Click ShowAll button below table.
Key in a 5-character metro code in edit box at right of FindCBSACode.
    … get from scroll list at upper right of table.
    … e.g., 19100 for Dallas, TX metro.
Click FindCBSACode; table refreshes showing only counties in this metro.
Click Current Situation button below table; table refreshes with selected columns.
Click the Pop2018 column header cell twice to rank-order the columns.
Done .. try these steps for an area of interest.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.