Tag Archives: CBP

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

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.

.. Harris County, TX (Houston) gained 1,658 business establishments between 2012 and 2013. How did the number and characteristics of business establishments in your counties or region of interest change? These data are available by county (and ZIP code) and can be used to determine which counties (ZIP codes) are experiencing business growth or decline and by how much. See more about this topic in the related Web section.

These data are based on a annual count of business establishments by physical location that have at least one paid employee. A single company may have multiple business establishments. Attributes of individual establishments, including payroll and employment, are summarized/aggregated by county and ZIP code area. The establishment data are also summarized by the NAICS type of business code. See more about these data.

Examine a specific industry such as construction. Among all counties, Harris County, TX had the highest 2013 employment in the construction industry (see more below). Where do your counties/ZIP code areas rank (in this or any other industry)?

The following views illustrate how Geographic Information System (GIS) tools can be used to visually examine change in business patterns. Use the CV XE GIS and associated GIS project to examine establishments, payroll and employment by detailed type of business. These applications shown change for one year; choose a different set of years. Integrate your own data such as market territories or customer/prospect data to examine how business opportunities match up with existing and changing patterns.

Change in Business Establishments, 2012-2013 — Texas by County
The following graphic shows the change in the number of business establishments by county in Texas and adjacent areas. Metros are shown with bold black outlines. Color patterns show change in the number of establishments between 2012 and 2013. It is easy to see which counties have business establishment growth (blue/green) or decline (orange/red). Use the GIS resources to develop similar business patterns views for any state/area in the U.S. The legend at left of map (click graphic for larger view with legend) shows establishment change intervals by color. — view created using CV XE GIS and associated GIS Project
— click graphic for larger view showing details.

Change in Business Establishments, 2012-2013 — Houston Area
The following graphic shows the change in the number of business establishments by county with a zoom-in view of the Houston area. Use the GIS resources to zoom in to any county/region of the U.S. The legend at left of map (click graphic for larger view with legend) shows establishment change intervals by color. Counties are labeled with county name and percent change in the number of establishments between 2012 and 2013. — view created using CV XE GIS and associated GIS Project
— click graphic for larger view showing details.

Profile of County Business Establishment Change
The following table shows a basic overview of the change. There is much more detail available. The GIS project enables mixing demographic with economic and business data.

Database Queries: Counties with Highest Employment in Construction Industry
Consider a requirement to determine the list of 10 counties having the highest employment in the construction industry. The 2.1 million record database with county by type of business is opened with the CV XE GIS dBrowse operation/feature. Note that this database size exceeds the Excel limit. A query is placed on the database to show on NAICS (type of business) code “23—-” having number of 2013 employment of 10,000 or more. The query could have been any NAICS code in combination with another attribute or none. The table is then sorted in descending order on 2013 employment (by clicking the sort button). The resulting records/counties are displayed as shown. The county FIPS code 201 in state FIPS code 48 (Harris County) has the highest total construction industry employment in the U.S. It is easy to see the other top 10 (or some group) that are also highly ranked. The Count operation is used to shown how many counties meet this criteria; there are 118. Other selected attributes are shown in the table/graphic. This selection could optionally be exported to a file in a different format (e.g., CSV).

An upcoming section will review linking business establishment data with demographic data.

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.