Tag Archives: Missouri

Metro Quarterly Establishments, Employment & Earnings by Industry

.. data, tools and methods to analyze metro business  patterns and trends .. the most current and comprehensive measures of business activity by county, metro and higher level geography are provided by the Establishments, Employment & Earnings (EEE) database. Use the resources described here to analyze establishments, employment and wages by metro for the most recent quarter and over-the-year change — by quarter 2013 through 2015.  Updated quarterly, the 2016Q1 data become available September 7, 2016. See the related Web section for more details.

These metro by metro EEE datasets are  closely integrated with the metros Situation & Outlook reports. Click a CBSA code in the “Code” column in that table then select related section 6.6. to access/download quarterly data for a metro.

Where Does America Make Things?
The graphic below shows percent employment in the manufacturing sector (employment in the private manufacturing sector as a percent of total private sector employment by county). This view illustrates how the EEE data can be used to develop insights.  Click graphic for larger view providing more detail. Use the GIS tools to analyze similar patterns for any industry. Interpreting this map graphic and alternative data resources … join us in a Data Analytics Lab session where we discuss making and interpreting this map view and alternatives.

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

Two Key Data Resources
1) Use the interactive table in the Web section to example total establishments, employment and wages for any selected MSA and/or in comparison with other MSAs.

2) Download metro quarterly Establishments, Employment & Earnings (EEE) by type of business data. Click a quarterly download link in Section 6.6 for a selected metro (see above note) and download the full 6-digit NAICS detail data for any/all quarters starting with 2013Q1 (CSV structure). These files provide 6-digit NAICS type of business code detail and included columns for :
for the most recent quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient
for over-the-year change (previous year, same quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient

Using the Interactive Table
Updated quarterly, use the interactive table in the Web section to view, rank, compare individual metros with other metro. The following graphic shows metros ranked in descending order by 2015Q4 average weekly wages. Columns to the right show over-the-year (2014Q4-2015Q4 in this case) characteristics.

– click graphic for larger view.

Using the Downloaded Data
Access/download quarterly establishments, employment & earnings data by detailed NAICS category using theSituation & Outlook Metro Reports. Select a metro from the interactive table by click a link in the “Code” column. The S&O metro report opens in a new page. In the table of contents, select section 6.6. from the table of contents (Establishments, Employment & Earnings by Detailed Type of Business). See this example for the Chicago metro.  See the related Web section for more details on using the download data files. .

Location Quotients
Pre-computed location quotients are included in the downloadable files. Location quotients (LQ) are ratios (indicators) that measure the concentration of an industry within a specific area (metro in this case) to the concentration of that industry nationwide.

If an employment LQ is equal to 1, then the industry has the same share of its area employment as it does in the nation. An employment LQ greater than 1 indicates an industry with a greater share of the local area employment than is the case nationwide. For example, Las Vegas will have an LQ greater than 1 in the Leisure and Hospitality industry because this industry makes up a larger share of the Las Vegas employment total than it does for the nation as a whole.

Employment LQs are calculated by first, dividing local industry employment by the all industry total of local employment. Second, national industry employment is divided by the all industry total for the nation. Finally, the local ratio is divided by the national ratio.

LQs are provided in the downloadable file for:
a) the reference quarter for each of establishments, employment and wages, and
b) over-the-year change for each of establishments, employment and wages.

Location Quotients will be reviewed in more detail in an upcoming blog post.

Important features of these data
• Tabulated for all counties, metros, states and the U.S.
• Tabulated for detailed types of business (6-digit NAICS).
• Tabulated quarterly and annually, the data enable time-series modeling.
• Employer-based administratively collected data; not estimates.
• Short lag (5 months) between reporting date and date of data accessibility
– data for first quarter 2016 (2016Q1) are available mid-September 2016.

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 Updates

Goto ProximityOne  Are we better off? … How is our per capita measure of economic prosperity trending?  Answers to these questions, helping us determine where we are and how things might change in the future are partly provided by the REIS economic data updated in November 2013. This section provides an overview of the latest  Regional Economic Information System (REIS) data and how these data compare to other data in related analyses and decision-making applications.  The REIS county-level data are annually updated by the U.S. Bureau of Economic Analysis.

The change in per capita personal income, 2008-2012, by county is shown in the map below (second map shows percent change, same period).  Per capita personal income (PCPI) is the most comprehensive measure of economic activity available at the county level for all counties in the U.S.


PCPI Percent Change 2008-12 almost mirrors dollar change shown above.

Our work with the REIS data dates to the 1970s where these data were used in state forecasting models by the State of Missouri.  Today, we integrate the REIS data into Situation&Outlook.  The REIS annual time series is an indispensable part of any continuing county and regional comprehensive modeling and analysis.

Relation to ACS
REIS and the Census Bureau American Community Survey (ACS) 5-year data provide an annual, but different, characterization of the county level economy.  The two sources should be used in combination; one is not better than the other.  Some selected comparisons … REIS most current data are for 2012; the ACS 2012 5-year data (December 2013) are centric to 2010.  REIS data are developed from employer reported data supplemented with other wide-ranging measures for one year; ACS 5-year estimates are based on a sample survey over a 5 year period. REIS data provide a 20+ year annual time series; ACS 5-year data are available for four years on a comparable basis.  REIS data are available for counties, metros and states; ACS 5 year data go down to block group level and cover many other types of geography.  REIS is predominantly economic; ACS data are predominately demographic. REIS metro data use the 2013 vintage metros; all available ACS 5-year data are based on the 2009/Census 2010 vintage metros.

Relation to CEW
REIS data are based substantially on employment and payroll data from the Bureau of Labor Statistics Census of Employment and Wages (CEW).  Analyses should make use of both sources.  Some comparisons … REIS data are annual only; CEW data are quarterly and annual.  REIS most current data are for 2012; CEW data are available for 1st quarter 2013; CEW will be almost two years more recent when the REIS data are released in 2014.  REIS data go to the 2-digit NAICS level; CEW data go to the 6-digit NAICS level. County is the low level geography for REIS and CEW.

Scope of REIS Data
As a generalization, the REIS data are annual time series starting in 1970 and continue to 2012.  The series are developed for many types of subject matter by county, metro and state.  The series are organized as shown below.  Click a link to view a sample profile for Harris County, TX for 2011 and 2012.

• Personal income, per capita personal income, and population (CA1-3)
• Personal income summary (CA04)
• Personal income and earnings by industry (CA05, CA05N)
• Compensation of employees by industry (CA06, CA06N)
• Economic profiles (CA30)
• Gross flow of earnings (CA91)

Access and Interactive Analysis
Use the interactive table at http://proximityone.com/reis13.htm to view, rank compare annual estimates, and change, of per capita personal income for selected years by county, metro and state.  See related maps and about mapping tools using the REIS data in that section.  The more detailed data shown in above examples are available via Situation & Outlook integrated with multi-sourced data.