naics_codes
NAICS 2022 code hierarchy, fully denormalized. One row per NAICS code at all hierarchy depths (2- through 6-digit), plus QCEW compound codes (31-33, 44-45, 48-49) and the synthetic 'Total all industries' code (10). Includes parent titles at each level and sector/goods-producing flags.
tier aTier A: official NAICS code list.
overview
overview
2,129 codes at all depths (2-6 digit) + QCEW compound codes + synthetic total.
current vintage — 2022
provenance
source & licensing
authority
U.S. Census Bureau
dataset
NAICS 2022
source url
license
Public domain (U.S. Federal Government work)
citation
U.S. Census Bureau, NAICS 2022.
schema
fields
| name | type | definition |
|---|---|---|
| hierarchy_depth | int64 · count | Number of significant digits in the code, indicating hierarchy level (2=sector, 3=subsector, 4=industry group, 5=industry, 6=national industry). QCEW compound codes use depth=2. |
| is_goods_producing | bool | True for goods-producing NAICS sectors (11, 21, 23, 31-33) per the BLS definition; false otherwise. |
| is_service_producing | bool | True for all sectors except goods-producing sectors and Government (92) per the BLS definition; false otherwise. |
| naics_2digit | string | 2-digit sector code that is the ancestor of this code. Null for codes added by QCEW. |
| naics_2digit_title | string | Official title of the 2-digit sector ancestor. |
| naics_3digit | string | 3-digit subsector code that is the ancestor of this code. Null for 2-digit codes. |
| naics_3digit_title | string | Official title of the 3-digit subsector ancestor. |
| naics_4digit | string | 4-digit industry group code that is the ancestor of this code. Null for codes with hierarchy depth less than 4. |
| naics_4digit_title | string | Official title of the 4-digit industry group ancestor. |
| naics_5digit | string | 5-digit industry code that is the ancestor of this code. Null for codes with hierarchy depth less than 5. |
| naics_5digit_title | string | Official title of the 5-digit industry ancestor. |
| naics_codekey | string | The NAICS 2022 code string (2- to 6-digit, or a QCEW compound code such as '31-33'). Primary key uniquely identifying each row across all hierarchy depths.Part of primary key. Joins dim.naics_codes on naics_code. |
| naics_title | string | Official NAICS 2022 title for this code. |
| sector_label | string | Human-readable sector label derived from the 2-digit prefix (e.g. 'Manufacturing', 'Healthcare'). |
| vintage | string | NAICS classification vintage year for this code (always '2022' for current data). |
relationships
joins
primary key
naics_code
common joins
not provided
usage
how to use this table
method
Denormalized NAICS 2022 hierarchy with parent titles per level.
do not use for
NAICS vintages other than 2022.
last updated · Jul 7, 2026