Data table D7
Establishments, employment and payroll by NAICS sector and state, 2023
Employer establishments, mid-March employment and annual payroll for each of 19 NAICS sectors in every state, plus an all-sector row.
Download CSV (1,038 rows, 8 columns, 72 KB)
Reading the table
An establishment is a single physical location, so a firm with three shops contributes three. Payroll per employee is annual payroll divided by March employment. County Business Patterns leaves out crop and animal production, rail transportation, the Postal Service, private households and public administration. The Census Bureau perturbs each establishment's values with a noise multiplier before tabulating, to protect individual businesses, which is why small cells should be read as approximate.
The file has 1,038 data rows and a header row; percentages and rates are written as numbers out of 100 with two decimals, dollar columns marked ($1,000) are in thousands, and an empty cell means the source published no value.
Columns
- State
- Postal code
- NAICS
- Sector
- Establishments
- Employees
- Annual payroll ($1,000)
- Payroll per employee
Preview
| State | Postal code | NAICS | Sector | Establishments | Employees | Annual payroll ($1,000) | Payroll per employee |
|---|---|---|---|---|---|---|---|
| United States | US | 00 | All sectors | 8,361,342 | 139,831,742 | 9,556,351,319 | $68,342 |
| United States | US | 11 | Agriculture, forestry, fishing and hunting | 22,752 | 161,334 | 9,180,464 | $56,903 |
| United States | US | 21 | Mining, quarrying, and oil and gas extraction | 23,360 | 553,036 | 63,643,926 | $115,081 |
| United States | US | 22 | Utilities | 20,379 | 667,277 | 84,904,374 | $127,240 |
| United States | US | 23 | Construction | 814,557 | 7,659,459 | 586,559,516 | $76,580 |
| United States | US | 31-33 | Manufacturing | 284,452 | 12,335,234 | 902,962,951 | $73,202 |
| United States | US | 42 | Wholesale trade | 382,081 | 6,236,357 | 564,424,182 | $90,505 |
| United States | US | 44-45 | Retail trade | 1,043,373 | 16,046,207 | 605,675,581 | $37,746 |
| United States | US | 48-49 | Transportation and warehousing | 291,155 | 6,548,924 | 402,043,443 | $61,391 |
| United States | US | 51 | Information | 160,704 | 3,809,059 | 568,303,975 | $149,198 |
| United States | US | 52 | Finance and insurance | 469,382 | 6,991,623 | 876,925,090 | $125,425 |
| United States | US | 53 | Real estate and rental and leasing | 469,562 | 2,391,886 | 167,613,420 | $70,076 |
| United States | US | 54 | Professional, scientific, and technical services | 989,182 | 10,401,442 | 1,114,419,103 | $107,141 |
| United States | US | 55 | Management of companies and enterprises | 49,556 | 3,855,720 | 497,375,299 | $128,997 |
| United States | US | 56 | Administrative, support and waste services | 451,014 | 13,454,862 | 762,956,356 | $56,705 |
| United States | US | 61 | Educational services | 118,004 | 3,926,820 | 197,656,313 | $50,335 |
| United States | US | 62 | Health care and social assistance | 1,003,398 | 22,063,238 | 1,394,716,191 | $63,214 |
| United States | US | 71 | Arts, entertainment, and recreation | 166,356 | 2,491,408 | 119,013,881 | $47,770 |
| United States | US | 72 | Accommodation and food services | 784,882 | 14,608,170 | 393,166,035 | $26,914 |
| United States | US | 81 | Other services (except public administration) | 807,804 | 5,616,494 | 244,270,342 | $43,492 |
Source: CBP 2023. First 20 of 1,038 rows shown.
Suggested citation
Main Street Databook. "Establishments, employment and payroll by NAICS sector and state, 2023." Table D7, compiled November 2026 from U.S. Census Bureau, County Business Patterns (CBP), 2023 state and US files. https://mainstreetdatabook.com/tables/establishments-by-sector-and-state-2023
The underlying figures are works of the United States government and are in the public domain; cite the agency for the numbers and Table D7 as the compilation you used.
Sources
- U.S. Census Bureau, County Business Patterns (CBP), 2023 state and US files. www2.census.gov/programs-surveys/cbp/datasets/2023/. Retrieved November 2026.