Tag Archives: establishments by type of business

Insights into County/Metro Business Establishment Patterns

.. new data, released this past week, enable us to better assess county and metro business establishment patterns .. these data help businesses understand how sales of their products and services align with markets .. what counties might be underserved? .. where should marketing and sales operations be ramped up or reduced in scope/reallocated? .. what do these tell us us about organization of market territories? how are these characteristics trending by county? Use the this interactive table to examine business establishments characteristics by county and metro by type of business. See more detail in the related Web section about topics covered in this post. 

• U.S. establishments rose 1.2% from 7,663,938 in 2015 to 7,759,807 in 2016.
• First quarter employment was up 2.1% from 124,085,947 to 126,752,238
• Annual payroll was up 2.9% from $6.3 trillion in 2015 to $6.4 trillion in 2016.

Based on the 2016 data (new April 2018), there are 7.3 million establishments in Metropolitan Statistical Areas (MSAs). In these MSAs ..
• 5.3 million establishments have fewer than 10 employees.
• 6,522 of these establishments have 1,000 or more employees.
• 374 of these establishments have 5,000 or more employees.

MSAs by Number of Establishments with 1,000 or more Employees
The following graphic shows Metropolitan Statistical Areas (MSAs) by number of establishments with 1,000 or more employees. Click graphic for larger view view showing metros labeled with number of these establishments. Expand brower to full window for best quality view.
.. View developed with CV XE GIS software and related GIS project.

Business Establishment Characteristics Updated in Metro Reports
Examine 2014, 2015, 2016 mini trend profiles for establishments by 2-digit sector in Metro Situation & Outlook Reports Choose any MSA by clicking column 3 in this table .. then view section 6.3. Examples:
New York .. Los Angeles .. Miami .. Chicago .. Dallas .. Houston .. Denver .. Seattle

Gaining Insights
Gain insights into these types of patterns by county by detailed type of business (NAICS). Use the interactive table below to examine business establishment characteristics for counties and metros of interest. Data reviewed in this section are based on the Census-sourced County Business Patterns released in April 2018. We have integrated current population estimates with the establishment data in the interactive table.

Tools You Can Use
• create maps and geospatially analyze business establishments at 6-digit industry detail with ready-to-use GIS project/tools .. see related section for details.
• Use the APIGateway tools to build custom business establishment datasets.
• Use the interactive table to query/view sort business establishment characteristics by county and metro.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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

Analyzing County Business Patterns by Type of Business

.. mapping and analyzing county business patterns by type of business … this section reviews use of tools and methods to develop custom U.S. by county business patterns data by type of business and develop mapping and related GIS applications. Steps illustrate how to develop a U.S. by county business patterns dataset for the supermarket  industry — NAICS type of business code 445100. Use the interactive table in this related section to examine supermarket business characteristics by county. Create map views such as shown below and perform wide-ranging business patterns data analytics using the tools. Develop similar applications for any type of business – see full list of NAICS/type of business categories. This section is focused on Census-sourced County Business Patterns released April 2016. There are additional data resources that can be used in a similar manner reviewed in main Web section.

Patterns of Supermarket Establishments by County
The following graphic shows patterns of the number of supermarket establishments by county for the Houston metro (bold boundary) region. Counties are labeled with the number of supermarkets and county name. Number of supermarkets shown by intervals/colors as depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest depicting establishments, employment or payroll for your type of business selection(s). Click graphic for larger view with more detail; expand browser window for best quality view.

View developed with CV XE GIS software using GIS project.

See full Web section to access data, tools and more detail.

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.

Establishments, Employment & Earnings Trends: 2015Q1

.. county & metro Establishment, Employment & Earnings (EEE) monthly-quarterly-annual time series by detailed type of business .. financial sector employment in Manhattan (New York County, NY) led the nation in average weekly wages at $8,932 during the first quarter 2015.  Use the interactive table to examine characteristics of establishments (number, employment, earnings) for counties and metros by type of business of interest. See the related Web section for more detail.  Follow that section for quarterly and interim data establishments by sector updates and use of tools to analyze 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 interactive table to view, rank, query, compare data on establishments, employment and wages by county, metro and state for high level industries. Subscribers to the ProximityOne Data Service (PDS) database can use the more detailed (6-digit NAICS coverage) with data structured for time-series analysis supported with modeling and data analytics tools.

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 January 2015 by county). 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.

The EEE quarterly data are based on employer reported data and provide EEE characteristics by detailed type of business collected and tabulated by the Bureau of Labor Statistics (BLS). Derived from reports submitted by every employer subject to unemployment insurance (UI) laws, the data cover 9.5 million employers and 136.2 million full- and part-time workers.

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 second quarter 2015 (2015Q2) are available mid-December 2015.
Limitations of these data.

Use these data to examine how a detailed type of business is changing in a county or metro … or how that type of business in one county/metro compares to another county or metro. Answer questions like how much of the healthcare sector in a particular metro is comprised by offices of physicians. Or, are the number of establishments in a business sector growing or declining? How are the characteristics of establishments in one metro changing relative to another metro?

Establishments, Employment, Earnings — Interactive Table
The following graphic illustrate use of the interactive table to examine characteristics of construction industry for California by county. The rows/counties are ranked on the rightnost column AWW15Q1 (average weekly wages, 1st quarter 2015) in descending order. It is easy to see that California was led by San Francisco county with $1,661 AWW reflecting activity of 1,564 establishments and January employment of 16,850. Click graphic for larger view.

Updates
These data update quarterly. The next update includes data for 2015Q2 and becomes available December 17, 2015 (set reminder).

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.