This dataset shows the list of United States North American Industry Classification System (NAICS) Codes, Business Profiles by Sales and Employees. These codes are used by businesses and government authorities to differentiate types of business according to their process of production.

US Industry Data by State, by Industry

Number of Establishments, Sales, Payroll, and Employees

By Gary Hoover [source]

About this dataset

This data set provides a detailed look into the US economy. It includes information on establishments and nonemployer businesses, as well as sales revenue, payrolls, and the number of employees. Gleaned from the Economic Census done every five years, this data is a valuable resource to anyone curious about where the nation was economically at the time. With columns including geographic area name, North American Industry Classification System (NAICS) codes for industries, descriptions of those codes meaning of operation or tax status, and annual payroll, this information-rich dataset contains all you need to track economic trends over time. Whether you’re a researcher studying industry patterns or an entrepreneur looking for market insight — this dataset has what you’re looking for!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides detailed US industry data by state, including the number of establishments, value of sales, payroll, and number of employees. All the data is based on the North American Industry Classification System (NAICS) code for each specific industry. This will allow you to easily analyze and compare industries across different states or regions.

Research Ideas

• Analyzing the economic impact of a new business or industry trends in different states: Comparing the change in the number of establishments, payroll, and employees over time can give insight into how a state is affected by a new industry trend or introduction of a new service or product.
• Estimating customer sales potential for businesses: This dataset can be used to estimate the potential customer base for businesses in different geographic areas. By analyzing total business done by non-employers in an area along with its estimated population can help estimate how much overall sales potential exists for a given region.
• Tracking competitor performance: By looking at shipments, receipts, and value of business done across industries in different regions or even cities, companies can track their competitors’ performance and compare it to their own to better assess their strategies going forward

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: Dataset copyright by authors - You are free to: - Share - copy and redistribute the material in any medium or format for any purpose, even commercially. - Adapt - remix, transform, and build upon the material for any purpose, even commercially. - You must: - Give appropriate credit - Provide a link to the license, and indicate if changes were made. - ShareAlike - You must distribute your contributions under the same license as the original. - Keep intact - all notices that refer to this license, including copyright notices.

Columns

File: 2012 Industry Data by Industry and State.csv | Column name | Description | |:----------------------------------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------| | Geographic area name | The name of the geographic area the data is for. (String) | | NAICS code | The North American Industry Classification System (NAICS) code for the industry. (String) | | Meaning of NAICS code | The description of the NAICS code. (String) | | Meaning of Type of operation or tax status code | The description of the type of operation or tax status code. (String) ...

The Census data API provides access to the most comprehensive set of data on current month and cumulative year-to-date imports using the North American Industry Classification System (NAICS). The NAICS endpoint in the Census data API also provides value, shipping weight, and method of transportation totals at the district level for all U.S. trading partners. The Census data API will help users research new markets for their products, establish pricing structures for potential export markets, and conduct economic planning. If you have any questions regarding U.S. international trade data, please call us at 1(800)549-0595 option #4 or email us at eid.international.trade.data@census.gov.

Context

NAICS codes data

Content

The document contains NAICS codes ranging from 11 to 92 under the column named 'Sector'. The industry each NAICS code belongs to is contained the 'Name' column.

Note

NAICS code 99 which represents unclassified industries was not included in the document.

Statistical data about the industry represented by this NAICS code

Information on North American Industry Classification System (NAICS) Code Submission Requests

Listing of all active businesses currently registered with the Office of Finance. An "active" business is defined as a registered business whose owner has not notified the Office of Finance of a cease of business operations. Update Interval: Monthly.

This table replaces tables 36-10-0394 and 36-10-0395. Data in this table are not fully comparable with those previously published. Aggregate T001 combines the North American Industry Classification System (NAICS) codes 11-91. Aggregate T002 combines the North American Industry Classification System (NAICS) codes 11-33. Aggregate T003 combines the North American Industry Classification System (NAICS) codes 41-91. Aggregate T010 combines the North American Industry Classification System (NAICS) codes 21, 22, 31-33, 562. Aggregate T011 combines the North American Industry Classification System (NAICS) codes 311-316, 322-326. Aggregate T012 combines the North American Industry Classification System (NAICS) codes 321, 327-339. Aggregate T013 combines the North American Industry Classification System (NAICS) code 334, excluding 3345, 4173, 5112, 517, 518, 5415, 8112. Aggregate T014 combines the North American Industry Classification System (NAICS) code 334, excluding 3345. Aggregate T015 combines the North American Industry Classification System (NAICS) codes 4173, 5112, 517, 518, 5415, 8112. Aggregate T016 combines the North American Industry Classification System (NAICS) codes 211, 2121, 21229, 213111, 213118, 2211, 2212, 32411, 486. Aggregate 11A combines the North American Industry Classification System (NAICS) codes 111, 112. Industry 111A combines the North American Industry Classification System (NAICS) code 111, excluding 1114. Industry 115A combines the North American Industry Classification System (NAICS) codes 1151, 1152. Industry 21239A combines the North American Industry Classification System (NAICS) codes 212393, 212394, 212395, 212397, 212398. Industry 21311A combines the North American Industry Classification System (NAICS) codes 213111, 213118. Industry 21311B combines the North American Industry Classification System (NAICS) codes 213117, 213119. Aggregate 221A combines the North American Industry Classification System (NAICS) codes 2212, 2213. Industries in sector 23 are special hybrids that correspond to sections of the North American Industry Classification System (NAICS) code 23. Aggregate 311A combines the North American Industry Classification System (NAICS) codes 3112, 3118, 3119. Industry 3121A combines the North American Industry Classification System (NAICS) codes 31213, 31214. Industry 31A combines the North American Industry Classification System (NAICS) codes 313, 314. Industry 31B combines the North American Industry Classification System (NAICS) codes 315, 316. Industry 3241A combines the North American Industry Classification System (NAICS) code 324, excluding 32411. Aggregate 325A combines the North American Industry Classification System (NAICS) codes 3255, 3256, 3259. Industry 327A combines the North American Industry Classification System (NAICS) code 327, excluding 3273. Industry 332A combines the North American Industry Classification System (NAICS) codes 3322, 3329. Aggregate 333A combines the North American Industry Classification System (NAICS) codes 3332, 3333. Industry 334A combines the North American Industry Classification System (NAICS) codes 3343, 3345, 3346. Aggregate 48Z combines the North American Industry Classification System (NAICS) codes 485, 487. Industry 48A combines the North American Industry Classification System (NAICS) codes 4852, 4854, 4855, 4859, 487. Industry 486A combines the North American Industry Classification System (NAICS) codes 4861, 4869. Aggregate 49A combines the North American Industry Classification System (NAICS) codes 491, 492. Industry 5111A combines the North American Industry Classification System (NAICS) codes 51112, 51113, 51114, 51119. Industry 5121A combines the North American Industry Classification System (NAICS) codes 51211, 51212, 51219. Aggregate 52B combines the North American Industry Classification System (NAICS) codes 521, 5221. Industry 5221A combines the North American Industry Classification System (NAICS) codes 52211, 52219. Industry 52A combines the North American Industry Classification System (NAICS) codes 523, 526. Owner-occupied dwellings (industry 5311A) is defined as resident households who own the dwelling where they reside and who are considered for purpose of the National Accounts to receive an income in kind equivalent to the market rental value of their dwelling. Industry 531A combines the North American Industry Classification System (NAICS) codes 5312, 5313. Industry 532A combines the North American Industry Classification System (NAICS) code 532, excluding 5321. Aggregate 541A combines the North American Industry Classification System (NAICS) codes 5411, 5412. Aggregate 541B combines the North American Industry Classification System (NAICS) codes 5414, 5416, 5417, 5419. Industry 561A combines the North American Industry Classification System (NAICS) codes 5612, 5619. Aggregate 611B combines the North American Industry Classification System (NAICS) code 61, excluding 6113. Industry 611A combines the North American Industry Classification System (NAICS) codes 6114-6117. Aggregate 62X combines the North American Industry Classification System (NAICS) code 62, excluding 624. Industry 621A combines the North American Industry Classification System (NAICS) codes 6213, 6214, 6215, 6216, 6219. Industry 71A combines the North American Industry Classification System (NAICS) codes 711, 712. Industry 713A combines the North American Industry Classification System (NAICS) codes 7131, 7139. Industry 721A combines the North American Industry Classification System (NAICS) codes 7212, 7213. Industry 811A combines the North American Industry Classification System (NAICS) codes 8112, 8113, 8114. Aggregate 81A combines the North American Industry Classification System (NAICS) codes 812, 814. Industry 812A combines the North American Industry Classification System (NAICS) codes 8121, 8129. Industry 813A combines the North American Industry Classification System (NAICS) code 813, excluding 8131. Industry 911A combines the North American Industry Classification System (NAICS) code 911, excluding 9111. Aggregate 91A combines the North American Industry Classification System (NAICS) codes 913, 914. With the November 10, 2015 release, the industry structure shows the Aquaculture industry (NAICS 1125) and Animal production (excluding aquaculture) (Industry 112A) separately, which were previously combined under the Animal production industry (NAICS 112). Industry 112A combines the North American Industry Classification System (NAICS) code 112, excluding 1125. Aggregate T018 combines the North American Industry Classification System (NAICS) codes 61, 62, 91. Aggregate 23X combines industry codes 23C, 23E. Aggregate 325B combines the North American Industry Classification System (NAICS) codes 3252, 3255. Aggregate 336Y combines the North American Industry Classification System (NAICS) codes 3361, 3362, 3363. Aggregate 51A combines the North American Industry Classification System (NAICS) codes 5152, 517, 519. Aggregate 52X combines the North American Industry Classification System (NAICS) codes 521, 522. Aggregate 522A combines the North American Industry Classification System (NAICS) codes 5222, 5223. Industry 53A combines the North American Industry Classification System (NAICS) codes 533, 532, excluding 5321. Aggregate 561B combines the North American Industry Classification System (NAICS) codes 5611, 5612, 5613, 5614, 5619. The gross domestic product (GDP) estimates for the period 1997 to 2006 have been revised to improve the time series continuity of the GDP by industry measures. Aggregate 453X combines industry codes 453A, 453BL. Aggregate T020 combines the North American Industry Classification System (NAICS) codes 11-91, excluding codes 111412, 111995, 453993. Aggregate T021 combines the North American Industry Classification System (NAICS) codes 111412, 111995, 453993. With May 1, 2019 release, the gross domestic product (GDP) by industry adopted the North American Industry Classification System (NAICS) Canada 2017 version 3.0." Aggregate 453B is equivalent to the North American Industry Classification System (NAICS) code 453993. Aggregate 111X combines the North American Industry Classification System (NAICS) codes 111, excluding codes 111412, 111995. Aggregate 111C combines the North American Industry Classification System (NAICS) codes 111412, 111995. Aggregate 111Y combines the North American Industry Classification System (NAICS) codes 111, excluding industry code 111CU. Aggregate 4AA combines the North American Industry Classification System (NAICS) codes 44-45, excluding 453993. Aggregate 4AZ combines the North American Industry Classification System (NAICS) codes 44-45, excluding industry code 453BU. Since October 17, 2018, the sale of cannabis for non-medical purposes is legal in Canada. The gross domestic product (GDP) by industry estimates will begin to take into account this activity and the licensed production of cannabis, as well as the unlicensed production and sale of cannabis, in the release of May 1, 2019 data. For more information, please read the article "https://www150.statcan.gc.ca/n1/pub/13-605-x/2018001/article/54969-eng.htm">Integrating the production With May 1, 2019 release, the gross domestic product (GDP) by industry adopted the North American Industry Classification System (NAICS) Canada 2017 version 3.0. As a result the conventional oil and gas extraction industry was renamed "Oil and gas extraction (except oil sands)" and recoded from 211113 to 21111." With May 1, 2019 release, the gross domestic product (GDP) by industry adopted the North American Industry Classification System (NAICS) Canada 2017 version 3.0. As a result the non

VITAL SIGNS INDICATOR
Jobs by Industry (EC1)

FULL MEASURE NAME
Employment by place of work by industry sector

LAST UPDATED
December 2022

DESCRIPTION
Jobs by industry refers to both the change in employment levels by industry and the proportional mix of jobs by economic sector. This measure reflects the changing industry trends that affect our region’s workers.

DATA SOURCE
Bureau of Labor Statistics, Quarterly Census of Employment and Wages (QCEW) - https://www.bls.gov/cew/downloadable-data-files.htm
1990-2021

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Quarterly Census of Employment and Wages (QCEW) employment data is reported by the place of work and represent the number of covered workers who worked during, or received pay for, the pay period that included the 12th day of the month. Covered employees in the private-sector and in the state and local government include most corporate officials, all executives, all supervisory personnel, all professionals, all clerical workers, many farmworkers, all wage earners, all piece workers and all part-time workers. Workers on paid sick leave, paid holiday, paid vacation and the like are also covered.

Besides excluding the aforementioned national security agencies, QCEW excludes proprietors, the unincorporated self-employed, unpaid family members, certain farm and domestic workers exempted from having to report employment data and railroad workers covered by the railroad unemployment insurance system. Excluded as well are workers who earned no wages during the entire applicable pay period because of work stoppages, temporary layoffs, illness or unpaid vacations.

The location quotient (LQ) is used to evaluate level of concentration or clustering of an industry within the Bay Area and within each county of the region. A location quotient greater than 1 means there is a strong concentration for of jobs in an industry sector. For the Bay Area, the LQ is calculated as the share of the region’s employment in a particular sector divided by the share of California's employment in that same sector. For each county, the LQ is calculated as the share of the county’s employment in a particular sector divided by the share of the region’s employment in that same sector.

Data is mainly pulled from aggregation level 73, which is county-level summarized at the North American Industry Classification System (NAICS) supersector level (12 sectors). This aggregation level exhibits the least loss due to data suppression, in the magnitude of 1-2 percent for regional employment, and is therefore preferred. However, the supersectors group together NAICS 11 Agriculture, Forestry, Fishing and Hunting; NAICS 21 Mining and NAICS 23 Construction. To provide a separate tally of Agriculture, Forestry, Fishing and Hunting, the aggregation level 74 data was used for NAICS codes 11, 21 and 23.

QCEW reports on employment in Public Administration as NAICS 92. However, many government activities are reported with an industry specific code - such as transportation or utilities even if those may be public governmental entities. In 2021 for the Bay Area, the largest industry groupings under public ownership are Education and health services (58%); Public administration (29%) and Trade, transportation, and utilities (29%). With the exception of Education and health services, all other public activities were coded as government/public administration, regardless of industry group.

For the county data there were some industries that reported 0 jobs or did not report jobs at the desired aggregation/NAICS level for the following counties/years:

Farm:
(aggregation level: 74, NAICS code: 11) - Contra Costa: 2008-2010 - Marin: 1990-2006, 2008-2010, 2014-2020 - Napa: 1990-2004, 2013-2021 - San Francisco: 2019-2020 - San Mateo: 2013

Information:
(aggregation level: 73, NAICS code: 51) - Solano: 2001

Financial Activities:
(aggregation level: 73, NAICS codes: 52, 53) - Solano: 2001

Unclassified:
(aggregation level: 73, NAICS code: 99) - All nine Bay Area counties: 1990-2000 - Marin, Napa, San Mateo, and Solano: 2020 - Napa: 2019 - Solano: 2001

Release Date: N/A

Summary of annually reported gross receipts by NAICS Industry Code. Update Interval: Annually.

This dataset presents statistics on: the number of establishments; sales, value of shipments, or revenue; annual payroll; and number of employees whose NAICS classification has changed between the current and the previous economic censuses. Data are shown for 6-digit current economic census NAICS industries and their 8-digit previous economic census NAICS components for the U.S. Includes only establishments of firms with paid employees.

Introduction

The dataset contains the Monthly sales for retail trade and food services in USA, adjusted and unadjusted for seasonal variations for various categories. These categories shows various kind of Business categories operating in USA. These categories are based on North American Industry Classification System (NAICS).

Dataset Description

• The dataset contains the estimates of Monthly Retail and Food Services Sales by Kind of Business from the year 1992 - 2020. These estimates are shown in millions of dollars and are based on data from the Monthly Retail Trade Survey, Annual Retail Trade Survey, * Service Annual Survey, and administrative records.
• Their are another to files that contain the monthly data for the code NAICS code 44X72: Retail Trade and Food Services: U.S. Total for both Seasonally Adjusted Sales and non Seasonally Adjusted Sales in Millions of Dollars from 1992 to 2020.
• An helper file for NAICS code for retail and food industry is also provided for reference

Acknowledgements

The Dataset was published on U.S. Census Bureau website (https://www.census.gov)

Quarterly Census of Employment and Wages (QCEW) by NAICS (2 level) and Towns. Source: Connecticut Department of Labor Quarterly Census of Employment and Wages (QCEW). QCEW data is regularly reviewed to correct and/or update industry (NAICS) codes that no longer reflect the ongoing business activity of a firm. Because of these corrections, in some cases changes from year to year may over or understate the actual changes occurring within the industry sector. Any questions regarding this data may directed to dol.lmi@ct.gov

VITAL SIGNS INDICATOR
Jobs by Industry (EC1)

FULL MEASURE NAME
Employment by place of work by industry sector

LAST UPDATED
December 2022

DESCRIPTION
Jobs by industry refers to both the change in employment levels by industry and the proportional mix of jobs by economic sector. This measure reflects the changing industry trends that affect our region’s workers.

DATA SOURCE
Bureau of Labor Statistics, Quarterly Census of Employment and Wages (QCEW) - https://www.bls.gov/cew/downloadable-data-files.htm
1990-2021

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Quarterly Census of Employment and Wages (QCEW) employment data is reported by the place of work and represent the number of covered workers who worked during, or received pay for, the pay period that included the 12th day of the month. Covered employees in the private-sector and in the state and local government include most corporate officials, all executives, all supervisory personnel, all professionals, all clerical workers, many farmworkers, all wage earners, all piece workers and all part-time workers. Workers on paid sick leave, paid holiday, paid vacation and the like are also covered.

Besides excluding the aforementioned national security agencies, QCEW excludes proprietors, the unincorporated self-employed, unpaid family members, certain farm and domestic workers exempted from having to report employment data and railroad workers covered by the railroad unemployment insurance system. Excluded as well are workers who earned no wages during the entire applicable pay period because of work stoppages, temporary layoffs, illness or unpaid vacations.

The location quotient (LQ) is used to evaluate level of concentration or clustering of an industry within the Bay Area and within each county of the region. A location quotient greater than 1 means there is a strong concentration for of jobs in an industry sector. For the Bay Area, the LQ is calculated as the share of the region’s employment in a particular sector divided by the share of California's employment in that same sector. For each county, the LQ is calculated as the share of the county’s employment in a particular sector divided by the share of the region’s employment in that same sector.

Data is mainly pulled from aggregation level 73, which is county-level summarized at the North American Industry Classification System (NAICS) supersector level (12 sectors). This aggregation level exhibits the least loss due to data suppression, in the magnitude of 1-2 percent for regional employment, and is therefore preferred. However, the supersectors group together NAICS 11 Agriculture, Forestry, Fishing and Hunting; NAICS 21 Mining and NAICS 23 Construction. To provide a separate tally of Agriculture, Forestry, Fishing and Hunting, the aggregation level 74 data was used for NAICS codes 11, 21 and 23.

QCEW reports on employment in Public Administration as NAICS 92. However, many government activities are reported with an industry specific code - such as transportation or utilities even if those may be public governmental entities. In 2021 for the Bay Area, the largest industry groupings under public ownership are Education and health services (58%); Public administration (29%) and Trade, transportation, and utilities (29%). With the exception of Education and health services, all other public activities were coded as government/public administration, regardless of industry group.

For the county data there were some industries that reported 0 jobs or did not report jobs at the desired aggregation/NAICS level for the following counties/years:

Farm:
(aggregation level: 74, NAICS code: 11) - Contra Costa: 2008-2010 - Marin: 1990-2006, 2008-2010, 2014-2020 - Napa: 1990-2004, 2013-2021 - San Francisco: 2019-2020 - San Mateo: 2013

Information:
(aggregation level: 73, NAICS code: 51) - Solano: 2001

Financial Activities:
(aggregation level: 73, NAICS codes: 52, 53) - Solano: 2001

Unclassified:
(aggregation level: 73, NAICS code: 99) - All nine Bay Area counties: 1990-2000 - Marin, Napa, San Mateo, and Solano: 2020 - Napa: 2019 - Solano: 2001

The Census data API provides access to the most comprehensive set of data on current month and cumulative year-to-date imports using the North American Industry Classification System (NAICS). The NAICS endpoint in the Census data API also provides value, shipping weight, and method of transportation totals at the district level for all U.S. trading partners. The Census data API will help users research new markets for their products, establish pricing structures for potential export markets, and conduct economic planning. If you have any questions regarding U.S. international trade data, please call us at 1(800)549-0595 option #4 or email us at eid.international.trade.data@census.gov.

The North American Industry Classification System (NAICS) is an industry classification system developed by the statistical agencies of Canada, Mexico and the United States. Created against the background of the North American Free Trade Agreement, it is designed to provide common definitions of the industrial structure of the three countries and a common statistical framework to facilitate the analysis of the three economies. NAICS is based on supply side or production oriented principles, to ensure that industrial data, classified to NAICS, is suitable for the analysis of production related issues such as industrial performance.

The enclosed files are crosswalks between the 2012 editions of the Census industry and North American Industry Classification System (NAICS) codes, from 2- to 6-digit NAICS codes.

Dataset

This dataset was created by Abhiram Ashok

Contents

We provide weighted crosswalk files for the purpose of bridging Standard Industrial Classification (SIC) codes and North American Industry Classification System (NAICS) codes. SIC codes were the standard industry classification system for decades, but they eventually couldn’t keep up with the changing industrial structure of the 1990s. NAICS codes took over in 1997 and quickly became the reporting system for most government statistics in the US and elsewhere. This switch poses a problem for researchers since it imposes an artificial break in time series data. Unweighted crosswalk tables can help connect the two systems, but the many splits and merges create mappings that are not one-to-one. For situations that require one-to-one translations, researchers find themselves guessing as to the best match. And for situations where splitting and merging is acceptable, choosing weights sometimes feels arbitrary. The crosswalks included here contain weighting variables that make it possible to smoothly bridge between systems and construct consistent time series in a nonarbitrary way. Three different weighting schemes are included. The first based on employment, the second based on number of establishments, and the third based on total payroll.