economy_industry_establishments_county_year_naics
Census CBP establishments by county, year, and NAICS — long format (F2). Tier A-.
tier —admin_record
overview
overview
5,371,582 rows - county x NAICS-6 x year over 5 years. CBP near-census of paid-employee establishments.
current vintage — 2023 (released spring 2025)
history — CBP: 1986 to present; NAICS-based 1998 forward
provenance
source & licensing
authority
U.S. Census Bureau
dataset
County Business Patterns (CBP)
license
—
citation
U.S. Census Bureau. County Business Patterns (CBP), county x NAICS, 2019-2023.
schema
fields
| name | type | definition |
|---|---|---|
| annual_payroll_1000 | int64 · thousands of dollars | Total annual payroll paid to all employees during the calendar year, in thousands of nominal dollars. Higher values reflect greater total labor compensation in the industry-county cell. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| emp_nf | string | Noise flag for the employees field, as published by the Census Bureau County Business Patterns program. Common values include 'G' (noise infusion applied) and 'H' (withheld); blank indicates no noise applied. |
| employees | int64 · workers | Total number of paid employees for the pay period including March 12. May be suppressed or noise-infused for disclosure avoidance; see is_suppressed and emp_nf. |
| establishments | int64 · establishments | Total number of business establishments operating in this county, year, and NAICS industry. An establishment is a single physical location where business is conducted. Higher values indicate greater industry presence. |
| is_suppressed | bool | Indicates whether employee and payroll data have been withheld for this record to protect individual business confidentiality. When true, employees and annual_payroll_1000 should not be used. |
| n10_19 | int64 · establishments | Number of establishments in this industry-county cell with 10 to 19 paid employees. |
| n100_249 | int64 · establishments | Number of establishments in this industry-county cell with 100 to 249 paid employees. |
| n1000 | int64 · establishments | Number of establishments in this industry-county cell with 1,000 or more paid employees. |
| n20_49 | int64 · establishments | Number of establishments in this industry-county cell with 20 to 49 paid employees. |
| n250_499 | int64 · establishments | Number of establishments in this industry-county cell with 250 to 499 paid employees. |
| n5_9 | int64 · establishments | Number of establishments in this industry-county cell with 5 to 9 paid employees. |
| n50_99 | int64 · establishments | Number of establishments in this industry-county cell with 50 to 99 paid employees. |
| n500_999 | int64 · establishments | Number of establishments in this industry-county cell with 500 to 999 paid employees. |
| naics_codekey | string | North American Industry Classification System (NAICS) code identifying the industry sector. Values range from 2-digit (sector) to 6-digit (industry) granularity.Joins dim.naics_codes on naics_code. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| yearkey | int64 | Reference year of the observation. |
relationships
joins
primary key
county_id, naics_code, year
common joins
dim.geographies on county_id
economy_establishments_county_year on (county_id, year)
economy_industry_employment_county_year_naics on (county_id, naics_code, year)
usage
how to use this table
method
CBP Business Register extract aggregated by county x NAICS-6 x employment-size-class. Pipeline retains all NAICS levels (2-6 digit); use the digit count to filter granularity.
do not use for
Government establishments; non-employer firms (nonemployer statistics is separate); high-precision NAICS-6 cells in small counties (heavy suppression).
known issues
Heavy suppression at NAICS-6 in small counties. Establishment counts != firm counts.
← previousus_economy.economy_industry_employment_county_year_naicsnext →us_economy.economy_industry_group_employment_county_year
last updated · May 5, 2026