Category Archives: Situation & Outlook

State Population & Components of Change: 2010-2016

.. data and tools to examine how state demographics are changing 2010-2016 … using the new 2016 population and components of changes estimates. The U.S. population changed from 308,758,105 (2010) to 323,127,513 (2016), a change of 14,369,408 (4.7%). Only three states lost population. See the growth rates for DC and the remaining states in this table. Highest growth rates were in D.C., North Dakota, Texas, Utah and Colorado.

Patterns of Population Change, 2010-2016, by State
The following graphic shows the percent population change by state with labels showing the rank among all states based on the percent change in population, 2010-16.

View created with CVGIS and related GIS project. Click graphic for larger view.

Resources to Analyze these Data
Use our tools to view and analyze annual population estimates, 2010 to 2016, rankings and components of change for the U.S., regions and states. Use the interactive table below in this section to view, rank, compare these data. Use the GIS tools and ready-to use project described below in this section to create maps for states and regions of interest. Create thematic maps for any of the fields/measures shown in the interactive table. Change color patterns and labels. Integrate your own data.

Using Interactive Table
Use the interactive table to view, rank, compare, query states based on a selection of demographic measures. The following graphic illustrates how the table can be used. Click graphic for larger view.

The graphic shows the largest 10 states ranked in descending order based on 2016 population. The column “PopChg Rank 10b16” (second from right) shows the rank of this state, among all states, based on the population change from 2010 to 2016. The rightmost column shows the state’s rank for the period based on percent change in population over the period.

Largest 10 States based on 2016 Population

Try it yourself. Use the table to examine state patterns and characteristics based on your selected criteria.

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.

ZIP Codes with Highest & Lowest Economic Prosperity

.. the latest data for ZIP Code Areas show that eleven had a median household income of $250,000 or more during the period 2011-15. More than 20 ZIP code areas had a median housing value of $2,000,000 or more. Contrast these ZIP code areas with higher economic prosperity with the more than 150 ZIP codes that had a median housing value of less than $30,000.  Use the interactive table in this related Web section to see which ZIPs meet these and other criteria.

ZIP Codes with MHI $100,000 or More; Dallas, TX Metro
Analyzing economic prosperity patterns using combined types of small area geography … the following graphic shows ZIP code areas a red markers with the median household income or $100,000 or more in context of median household income by census tract thematic pattern. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view for your areas of interest. .

– view developed with CV XE GIS software.

This section reviews measures of economic prosperity for all ZIP code areas. These data were released in December 2016. This section updates with new data December 2017. See the list of all ZIP ccdes showing population, housing and economic characteristics in the interactive table shown below. Use the interactive table to view, rank, compare and query ZIP code attributes.

Examining demographic-economic characteristics by ZIP code is important for several reasons. We are familiar with our own ZIP codes as a geographic location. We tend to be interested in our area compared to other areas. ZIP codes provide an easy way to do that. Also, many secondary data resources are tabulated by ZIP code area; some important data are only available by ZIP code. See more about ZIP Code areas.

Resources & Methods to Examine Small Area Demographics
• See related ZIP Code Demographic-Economic Interactive Tables
  .. extended subject matter
• See related Census Tract Code Demographic-Economic Interactive Tables
• Examine ZIP Code Urban/Rural Characteristics
• Examine ZIP Code Business Establishment patterns
• Examine ZIP Code Housing Price Index patterns
• Join us in the weekly Data Analytics Lab Sessions
  .. reviewing applications using these and related data.

ZIP Code Areas with $MHI $100,000 or More
The following graphic shows ZIP code areas as red markers having median household income or $100,000 or more. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view; integrate other data; select alternative ACS 2015 subject matter.

– view developed with CV XE GIS software. Click graphic for larger view.

ZIP Code Areas with $MHV Less than $30,000
The following graphic shows ZIP code areas as orange markers having median housing value of less than $30,000. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view; integrate other data; select alternative ACS 2015 subject matter.

– view developed with CV XE GIS software. Click graphic for larger view.

ZIP Code Areas: Population & Economic Prosperity
  — Interactive Table –
Use the interactive table to view, rank, compare, query ZIP codes based on a selection of demographic-economic measures. The following graphic illustrates how the table can be used to examine patterns of the three digit ZIP code area (San Diego) by 5-digit ZIP code. Table operations are used to select ZIP codes in the 921 3-digit area (containing 39 5-digit ZIP codes). These 39 ZIP code are then ranked in descending order on median household income. See results in the table shown below. ZIP code 92145 has the highest $MHI in this group with $228.036.

– click graphic for larger view.

Try it yourself. Use the table to examine a set of ZIP codes on your selected criteria in for a state/area of interest.

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 by Metro: What $100 Buys

.. data and tools to examine the purchasing power of the incomes in different metros and states … this section reviews how you can access to data on what $100 buys by state and metro. Examine patterns of what $100 buys by year, 2008-2014, for all items and by type of goods & services category. Use the interactive table to view, rank, compare the Buying Power Index for each/all states and metros (MSAs). See the main Web page for more details.

What $100 Buys by Metro: 2014
The following graphic shows patterns of 2014 all items buying power of $100 by metro (MSAs). The color patterns/intervals are shown in the inset legend. Click graphic for larger view. Expand browser to full window for best quality view. Use GIS tools 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.

Varying prices by region can be normalized using Regional Price Parities (RPP). The RPP is a weighted average of the price level of goods and services for the average consumer in one geographic region compared to all other regions in the U.S. See more about RPP measures. Using the RPP data, what $100 will buy can be determined by state and metro for the categories of all goods and services, goods, services-rents and other services. See about RPP goods and services types.

In the Boston metro, $100 buys about 90.7 percent of all items goods and services due to the high prices there. $100 in Boston seems more like $90.70 compared to the national average. In the Jefferson City, MO metro, the opposite is true. $100 buys all items goods and services due to lower prices in that metro. $100 in the Jefferson City, MO metro is the equivalent of $121.65 of all items goods and services compared to the national price levels.
• the Boston metro all items buying power index is 90.70
• the Jefferson City, MO metro all items buying power index is 121.65

Interactive Table – Top 10 Metros
The following graphic illustrates use of the Buying Power Index interactive table. This graphic shows the 10 metros that have the all items highest Buying Power Index. Use the interactive table to view/examine areas of interest.

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

Navigating the U.S. Federal Statistical System

.. an overview of the Federal statistical system and how to access data  .. the U.S. Federal Statistical System offers a vast array of diverse data resources that are useful in wide-ranging planning and analytical applications. Many of these data resources, such as census block level demographics from the decennial census, are unique in scope and content; in many cases there are no alternative data resources.

But there are issues/challenges for the data user to navigate the Federal Statistical System. Examples … the Bureau of Labor Statistics releases total employment data by county quarterly and monthly through multiple programs. The data values differ, for methodological reasons, but the net result can be confusion. The Census Bureau releases total employment data from many statistical programs by county both annually and more frequently. Where are these alternative total employment data and how can they be accessed? How do these various measures differ and which data are right for my situation? This section provides basic statistical program information. Subsequent updates will provide more detail.

This section provides an overview of the U.S. Federal Statistical System (FSS) and information that can help stakeholders navigate access to selected types of data produced by the FSS. While the FSS is focused on agencies that collect, develop and make available statistical data, there is a broader set of data and resources that relate to accessing and using these data. As technology and related data analytics resources have evolved, access to and use of these data is closely associated with the development of geographic data by Federal statistical and other agencies and Geographic Information Systems (GIS).

The FSS is a decentralized set of agencies that collect, develop and make available statistical and geographic data. The OMB Office of Statistical Programs and Standards (SPS) provides a FSS coordinative role. The SPS establishes statistical policies and standards, identifies priorities for improving programs, evaluates statistical agency budgets, reviews and approves Federal agency information collections involving statistical methods, and coordinates U.S. participation in international statistical activities.

While the FSS spans more than 100 agencies, the 13 “principal statistical agencies” have statistical work as their principal mission. Excluding funding for the decennial census ($919.3 million requested for the Decennial Census for FY 2016), approximately 38 percent ($2,486.9 million of the $6,486.6 million total proposed for FY 2016 President’s budget request) of overall funding for Federal statistical activities (of the Executive Branch) provides resources for these 13 agencies. The principal statistical agencies include:
Census Bureau (Commerce)
Bureau of Economic Analysis (Commerce)
Bureau of Justice Statistics (Justice)
Bureau of Labor Statistics (Labor)
Bureau of Transportation Statistics (Transportation)
Economic Research Service (Agriculture)
Energy Information Administration (Energy)
National Agricultural Statistics Service (Agriculture)
National Center for Education Statistics (Education)
National Center for Health Statistics (CDC/HHS)
National Center for Science and Engineering Statistics NSF/Independent
Office of Research, Evaluation, and Statistics — SSA/Independent
Statistics of Income (IRS)

The remaining 62 percent of the FY 2016 budget involves more than 100 programs that conduct statistical activities in conjunction with another program mission. These statistical programs are components within a Federal department or other agency. They include a broad set of centers, institutes, and organizations in addition to the 13 principal statistical agencies.

There are also Federal agencies whose statistical activities are not part of the Executive Branch. These agencies include the Congressional Budget Office, which develops and applies projection models for the budgetary impact of current and proposed Federal programs; the Federal Reserve Board, which compiles the widely used Flow of Funds report and other statistical series and periodically conducts the Survey of Consumer Finances; and the U.S. Government Accountability Office, which uses statistical data in evaluations of government programs.

Guide to Navigating the Federal Statistical System
The following graphic is a snapshot of the Guide to Navigating the Federal Statistical System. See http://proximityone.com/fss.htm to access the entire guide.

– 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

Analyzing ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. 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.

Mapping Statistical Data Updates

.. statistical mapping & visual data analysis … ready-to-use GIS projects/datasets … Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. In our increasingly data rich environment, we often experience “drowning in data.” GIS tools can help harness disparate and voluminous data and assist with data linkage. This section provides links to other sections that provide information on no cost GIS software and “production” GIS projects and datasets that you can use.

• Recent Additions
– Real Gross Domestic Product by State & Area – 06/23/16 – details
– Housing Price Index by Metro; 2015Q1-2016Q1 – 07/02/16 – details
– Housing Price Index by 5-Digit ZIP Code; 2010-2015; 07/02/16; details

Example: Mapping Median Housing Value by ZIP Code;  Los Angeles Area
Make this type of view/map for any area. Click graphic for larger view. Larger view illustrates use of identify/select tool to show mini profile for a selected ZIP code (see at pointer). Expand browser window for best quality view. Using GIS resources described here.


View developed with CV XE GIS software.

Related Topics in Mapping Statistical Data section …
• K-12 Curriculum Program
Data Analytics & Mapping Statistical Data in the Classroom

• GIS Projects/Datasets/Applications
World by Country
U.S. by State
U.S. by Congressional District
State Legislative Districts
U.S. by Metropolitan Area
U.S. by County
U.S. by City/Place
U.S. by ZIP Code Area
State by Census Tract (each/all states)
State by Block Group
State by Census Block
K-12 Schools & School Districts
K-12 Schools & School District Data Analytics

Join in … participate in the weekly Data Analytics Lab sessions 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.

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive 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.