Tag Archives: NAICS

Examining Health Care Infrastructure by ZIP Code

.. small area data providing information on sub-county and sub-city/place geographies are challenging to locate and use — particularly in context of demand for healthcare services and demographic attributes of associated neighborhoods. Develop insights into the healthcare infrastructure by ZIP code using the two related resources reviewed here — 1) individual ZIP code demographic-economic profiles and 2) ZIP code demographic-economic interactive tables. One way to examine the healthcare infrastructure for an area is to view/analyze the number and attributes (employment, earnings) of healthcare establishments by types of business/industry (such as physicians office or hospitals). Data and tools reviewed here provide insights into characteristics and patterns of national scope ZIP code areas — examine your ZIP codes of interest.

Option 1 — ZIP Code Profiles
.. examining the healthcare infrastructure in context of the related demographic-economic situation … the following graphic shows ZIP code 10514 (Westchester County, NY) with a bold red boundary.  Census tracts are shown with black boundaries with tract codes as white labels. See more about ZIP-Tract relationships. Cities/places are shown with blue cross-hatch pattern.

– view created with CV XE GIS software and related GIS project.

The above map graphic is part of a ZIP Code 10514 profile (click link to view complete profile). Section 3.1. of the profile shows the number healthcare establishments in the ZIP Code as partly shown in this graphic:

The portion of the table shows the NAICS/type of business code at left, followed by type of business description and the number of establishments at the right.

Examine other characteristics of this ZIP code profile and in context of others via this related Web section. These profiles update in May 2018.

Option 2 — ZIP Code Health Care Sector comparative analysis
.. examining the healthcare infrastructure for a set of ZIP codes in a state, metro, county or peer group … use the interactive table located here to view/rank/compare health care business establishments by type of business for a selected set of ZIP codes. This table shows a query placed on the table to show the total number of offices of physicians for ZIP codes in the vicinity of ZIP 10514. It shows that there are 14 offices of physicians establishments and 13 have 1-4 employees.

About These and Related ZIP Code Data
Data used to develop the tools/resources described above are based in part on the Census Bureau County Business Patterns program. These establishment data update annually.

ZIP code demographic-economic interactive tables
Use the following tables to examine a wide range of ZIP code demographic-economic conditions:
  • General Demographics
  • Social Characteristics
  • Economic Chacteristics
  • Housing CHaracteristics

Data Analytics Web Sessions
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 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.

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

Retail Trade Sales by ZIP Code

.. what is the meaning of few or no retail stores with sales over $1 million in a neighborhood or ZIP code? Residential tranquility might be accompanied by limited shopping conveniences. What about adjacent ZIP codes? Absence of larger retail stores suggests lower economic activity. ZIP code 89109 in Las Vegas has 478 retail establishments with sales over $1 million — the largest among all ZIP codes. There are more than 4,700 ZIP codes with no (and more than 10,200 with 1 or none) retail establishments with sales over $1 million. See the interactive table below to examine each/all ZIP codes. Use data and tools reviewed in this section to analyze retail sales patterns by ZIP code. See more detail in related Web section.

Patterns of Retail Trade by ZIP Code
The following map graphic shows patterns of retail trade establishments in Texas and adjacent states with more than $1 million in annual sales by ZIP code. Four Texas metros (Austin, Dallas, Houston, San Antonio) are highlighted with bold boundary. Click graphic for national scope, larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.

As of 2012, there were 30,177 ZIP codes with more than 1.06 million retail trade business establishments. Of these, almost 500,000 establishments had more than $1 million in annual sales. Find out which ZIP codes and the characteristics of businesses in those ZIP codes using tools reviewed here. These are the most recent establishment sales data by ZIP code. They are not available from other national scope sources.

These data supplement the annual ZIP code business patterns data that provide data on the number of establishments, employment and payroll by type of business (NAICS codes) — but provide no data on sales. This section provides interactive access to the retail trade establishments by sales group for all ZIP codes. This section illustrates how these data can be used in GIS applications to examines patterns and associate these with other data. ZIP code and multi-ZIP code area profiles are also shown in this section. Examine market characteristics using profiles from ProximityOne for any combination of ZIP oode areas. ProximityOne uses the sales data to develop custom estimates of retail trade characteristics by additional categories linked with data from other sources.

Examining Retail Trade by Individual ZIP Codes and ZIP Code Groups
The following graphic shows ZIP codes (ZIP code shown by yellow label) in the New York city area. The total number of retail establishments (white label) and the number of retail establishments with annual sales in excess of $1 million (blue label). These ZIP codes are used in profile reviewed below. The interactive table below can be used to show that ZIP code 10036 is among the ZIP codes having the largest number of retail establishments in the U.S.

– View developed using CV XE GIS and related GIS project.

ZIP Code 10036 Retail Trade Establishments & Sales Profiles
View ZIP Code 10036 Retail Trade Establishments & Sales Profile
ZIP Code 10036 Group Supermarket Establishments & Sales Profile

Interactive Table
Use the interactive table in this related section to view, query, rank, compare characteristics of retail trade establishments by ZIP code.

The following graphic illustrates use of the interactive table. All ZIP codes are ranked in descending order based on total retail trade establishments. Click graphic for larger view. ZIP code 10013 in New York city has the largest number of retail establishments.

Use the interactive table to examine ZIP codes and establishment patterns of interest.

Retail Trade Business Categories
• Motor Vehicle and Parts Dealers: NAICS 441
• Furniture & Home Furnishings Stores: NAICS 442
• Electronics & Appliance Stores: NAICS 443
• Building Material & Garden Equipment & Supplies: NAICS 444
• Food & Beverage Stores: NAICS 445
• Health & Personal Care Stores: NAICS 446
• Gasoline Stations: NAICS 447
• Clothing & Clothing Accessories Stores: NAICS 448
• Sporting Goods, Hobby, Book & Music Stores: NAICS 451

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.

Analyzing Business Establishment Change by County/ZIP & Industry

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