Category Archives: Regional Economic Information System

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.

Regional Economic Information System: Annual Updates

.. which counties are experiencing the fastest economic growth? by what economic component? what does this look like on a per capita level?

.. access & analyze economic characteristics and patterns by county and state .. annual time series 1969 through 2015 with projections.  Personal income is the income available to persons for consumption expenditures, taxes, interest payments, transfer payments to governments and the rest of the world, or for saving. Use the interactive table to examine characteristics of counties and regions of interest. The table provides access to 31 personal income related summary measures. These data are a selection of a broader set of annual time series data from the Regional Economic Information System (REIS). REIS is a part of the ProximityOne State & Regional Income & Product Accounts (SRIPA) and Situation & Outlook (S&O) featuring current (2016) estimates and demographic-economic projections. Go to table.

Visual Analysis of Per Capita Personal Income Patterns
The following map shows the Houston metro (view profile) with bold brown boundary. Counties are labeled with county name and 2014 per capita personal income.

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

Per Capita Personal Income Change 2008-2014 by County
.. relative to U.S 2008-2014 change

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

Interactive Analysis – County or State Profiles
The following graphic illustrate use of the interactive table to view an economic profile for Harris County, TX. Use the table to examine characteristics of any county or state. Click graphic for larger view.

Interactive Analysis
– comparing per capita personal income across counties
The next graphics illustrates use of the interactive table to rank/compare per capita personal income across counties. Rank/compare states. Choose any of the economic profile items. 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.

Metropolitan Area Gross Domestic Product: Trends & Updates

… data and analytical tools to examine Metro GDP patterns and trends.  As a policy-maker, investor, business, advisor or stakeholder, it is important to know how and where the metro economy is changing … and how one or selected metros relate to the U.S. and other metros. Is metro X changing in a different direction than metro Y? By how much, why and is there a pattern? What does the healthcare sector, for example, contribute to a metro’s gross domestic product (GDP)? How does it compare to peer metros? How is the healthcare industry trending? Metro GDP data can provide insights and answers to these important questions. Developing insights using metro GDP data — an example. See related Web section for more detail.

Change in Per Capita Real GDP by Metro, 2010-2015
The following graphic shows patterns of change in per capita real GDP by metro from 2010 to 2015. The orange and red fill patterns show metros experiencing a decrease in per capita real GDP over the period. Click graphic for larger view that shows the 2015 rank of the metro among all 382 MSAs based on 2015 per capita real GDP.

— view created using CV XE GIS and associated MetroGDP GIS Project

282 metropolitan statistical areas, of the total 382, experienced an increase in real Gross Domestic Product (GDP) between 2010 and 2015. Growth was led by growth in professional and business services; wholesale and retail trade; and finance, insurance, real estate, rental and leasing, Collectively, real GDP for U. S. metropolitan areas increased 2.5 percent in 2015 after increasing 2.3 percent in 2014. Use the interactive table and GIS project/datasets described in this section to view/analyze patterns and characteristics in metros of interest.

Illustrative GDP by Sector Trend Profiles
Real GDP by sector profiles are available for the U.S. and each state and MSA. The Metro GDP data are part of the State & Regional Income & Product Accounts (SRIPA). The following profiles illustrate these data for metros, states and the U.S.

Atlanta, GA MSA
Charlotte, NC-SC MSA
Chicago, IL MSA
Columbia, MO MSA
Houston, TX MSA
Phoenix, AZ MSA
United States
Missouri
Texas

Metro Situation & Outlook Reports
View Metro GDP Characteristics section in the Metropolitan Area Situation & Outlook Reports, providing the same scope of data as in the table below integrated with other data. See example for the Dallas, TX MSA. GDP tells an important but small part of the broader metro demographic-economic characteristics. Most metros have sub-county areas experiencing growth or activity sometimes masked when looking at the entire metro. Click a metro (metro GDP estimated for MSAs only) link in the table at upper right to view the GDP estimate in context of related subject matter.

Interactive Analysis
The following graphic shows an illustrative view of the interactive MetroGDP table. This view shows California MSAs ranked in descending order on percent change in per capita real GDP from 2010 to 2015 (ranked on far right column). Use the table to examine characteristics of metros in regions 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.

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.

Real Purchasing Power by State & Metro

.. how does the real purchasing power in metros of interest compare to other metros? Use data and tools reviewed here to examine the purchasing power of the incomes in different metros and states … this section provides access to regional price parities (RPPs) estimates developed compare regions within the U.S. RPPs are regional price levels expressed as a percentage of the overall national price level for a given year. The price level is determined by the average prices paid by consumers for the mix of goods and services consumed in each region. See about these data. See example about using RPPs below in this section.

• Use the interactive table to view, rank, compare the RPPs
.. for all states and metropolitan statistical areas (MSAs).
• Use GIS tools described here to develop RPP thematic pattern maps.
.. add your own data & geography, select different HPI measures or criteria.
.. zoom to different geographic extents, label and modify colors as desired.

Patterns of Regional Price Parities by Metro: 2014
The following graphic shows patterns of 2014 all items Regional Price Parities by metro (MSAs). The color patterns/intervals are shown in the inset legend. In additional views (below this graphic) metros are labeled with the 2014 all items RPP. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here 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.

Additional Views — install GIS project (see steps here) and create your own custom maps
Georgia & Region
Missouri & Region
Texas & Region

Using the RPP — Illustrative Examples
1. Comparing real purchasing power:
  — Houston, TX metro compared to Waco, TX metro.
The the all items RPP for the Houston metro in 2014 was 100.3 while the all items RPP for the Waco, TX metro in 2014 was 91.5. (from RPP table). On average, prices are 0.3 percent higher and 8.5 percent lower than the U.S. average for the Houston metro and the Waco metro, respectively. The per capita personal income (PCPI) for the Houston metro in 2014 was $54,820 and the per capita personal income for the Waco metro was $35,340 (get from the table at http://proximityone.com/reis.htm). The RPP-adjusted PCPI values are $53,223 ($54,820/1.03) and $38,622 ($35,340/0.915), respectively. The gap between the purchasing power of the two metro PCPIs is reduced when adjusted by their respective RPPs.

2. Comparing real purchasing power:
  — Washington, DC metro compared to Columbia, MO metro.
• Washington, DC metro 2014 all items RPP: is 119.4 (from RPP table); 2014 PCPI: $62,975 (from this table)
• Columbia, MO metro 2014 all items RPP: 93.0 (from RPP table); 2014 PCPI: $41,418 (from this table)
• The RPP-adjusted PCPI values are $52,742 ($62,975/1.194) and $44,535 ($41,418/0.93), respectively.

Using the RPP Interactive Table
Use the interactive table to examine the RPP by state and metro. The following graphic illustrates use of the table to show the 10 metros having the highest 2014 all items RPP. Click graphic for larger view. Examine metros and states of interest with more detail using tools below the 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.

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.

State Demographic-Economic Briefing Notes

.. with the ever increasing availability of demographic and economic data, it can be difficult to access key up-to-date data for the U.S. and individual states, metros and counties … among other geography.

Here we look at the “tip of the iceberg” — intentionally. This section provides links to access State Demographic-Economic Briefing Notes. A summary of selected key demographic-economic measures and trends for each state are presented in comparison with the U.S. Use the Briefing Notes to facilitate briefings to others, collaboration and to obtain a snapshot of current and trending conditions. These data are mostly taken from the more detailed tables available as links at the bottom of each Briefing Notes section.

The Briefing Notes have been developed using the Regional Demographic-Economic Modeling System (RDEMS). The Briefing Notes sections and related detailed tables update frequently.

The per capita real Gross Domestic Product (GDP) estimates, new this past week from the Bureau of Economic Analysis, for 2010 and 2015 were added today. See how this comprehensive measure of economic well-being is trending and compares to the U.S. overall in states of interest.

Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi

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.