Category Archives: Patterns

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.

Census Tract Demographic-Economic Characteristics & Trends

..  Census tract demographics are used in wide-ranging public and private sector applications to examine patterns and characteristics of sub-county areas. Tract level data from Census 2000Census 2010 and the American Community Survey (ACS) can be used to analyze trade/market areas, neighborhoods and other small area study areas. But what about more current data and trends since 2010? What about business establishment data and other subject matter not included in either the census or ACS data?

There are no current demographic-economic census tract data available from the Census Bureau or other Federal statistical programs. Annually released ACS 5-year estimates are available by census tract but are for 5-year periods and dated. The most recent census tract level ACS data are based on the ACS 2017 5-year estimates (ACS 1317). Those data are not for the year 2017 but estimates for ACS survey respondents for the 5 year period 2013-2017; centric to mid-2015.

Patterns of Median Household Income %Change by Census Tract
The graphic below shows patterns of economic prosperity change based on median household income percent change ACS 2012 to ACS 2017 by tract in the Dallas metro area.

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

Using the Interactive Table
Use the interactive table .. click this link .. to view, query, rank, compare selected characteristics of the population, housing, educational attainment and income for census tracts based on ACS 2012 5-year, and ACS 2017 5-year data. Hundreds of additional items are available. See about related census tract data resources and applications.

Try it yourself ..
Tracts with ACS 2017 population 3,500-4,500 ranked on change in $MHI:
Replicate the following graphic using the interactive table. This view was produced by clicking the Pop17 button below the table to select only tracts with a ACS 2017 population between 3,500 and 4,500. Then the $MHI columns button was clicked to view only selected columns. Finally the qualifying tracts were sorted in descending order by clicking the $MHI Change column header cell.

Based on these estimates, tract 04013105004 in Maricopa County, AZ is top ranked, where the $MHI increased by $97,723 from the ACS 2012 5-year period to the ACS 2017 5-year period.

Corresponding API calls to access the $MHI for this tract (click links to access data):
ACS 2012 $MHIACS 2017 $MHI
Join us in an upcoming Data Analytics Web Session (see below) to learn more about using APIs to access these data and similar data.

Access more detailed ACS 2017 tract interactive tables:
  General demographics .. Social .. Economic .. Housing

Demographic 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.

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.

State of the States: 2018 Population & Components of Change

.. Welcome to 2019 .. how the U.S., states and world population are changing … the Census Bureau estimates the U.S. population is 328,231,337 as of January 1, 2019. This represents an increase of 2,013,241, or 0.62 percent, from New Year’s Day 2018 (326,218,096). The population as of Census Day (April 1) 2010, was 308,745,538 and has grown by 19,485,799, or 6.31 percent.

This section updates January 2020, with corresponding 2019 updates and additional details. Follow (click follow button at upper right) to receive updates on this and geographic, demographic and economic change with drill-down to the street intersection level.

In January 2019, the U.S. is expected to experience one birth every 8 seconds and one death every 11 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 19 seconds … one net international migrant every 34 seconds.

The world population on January 1, 2019 is estimated to be 7,541,221,651. The world has experienced a population increase of 96,777,770, or 1.3 percent, from New Year’s Day 2018 (population 7,444,443,881). During January 2019, 4.8 births and 1.9 deaths are expected worldwide every second.

Patterns of Population Change by State, 2010-2018
The following graphic shows patterns of percent population change from 2010 to 2018. 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 2018 and how the population might change 2019 through 2020. Click graphic for larger view; opens in new page. 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/states2018.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/places2017.htm
  • Counties — http://proximityone.com/countytrends2017.htm
  • Metros — http://proximityone.com/metros.htm
  • States — http://proximityone.com/states2018.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.

Housing Price Index 2017Q3-2018Q3

.. this past week the 3rd quarter 2018 (2018Q3) Housing Price Index (HPI) was released for the U.S., states and metros. As a leading economic indicator, the HPI often gives insights into how the housing market and economy might be changing in the months ahead. The fact that the HPI data are quarterly and become available with a short lag time makes the measure even more valuable. This section provides an update on the HPI 2018Q3 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 2017Q3-2018Q3 HPI Patterns
The following graphic shows housing value appreciation 2017Q3-2018Q3 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
The HPI is calculated using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. By itself, the HPI provides limited insights into the broader picture of “the why” and “how otherwise” states and metros are changing. The Situation & Outlook 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 … choose a metro. Metro Profiles are updated continuously and are available for each of the metropolitan area.

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 & Related Measures
Quarterly HPI measures are used to updated the interactive table, GIS project and Metro Profiles. HPI by county, ZIP Code and census tract are updated annually. The 2018 county, ZIP Code and census tract HPI data are scheduled for release in February 2019.

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.