sic_naics
SIC-to-NAICS concordance, enriched with the NAICS 2022 hierarchy. One row per (sic_code, naics_code) pair — the mapping is many-to-many, so one SIC code often maps to several NAICS codes. Built from the Census Bureau 2017–2022 NAICS to 1987 SIC concordance; covers ~1,005 of the ~1,300 4-digit SIC codes. Used to attach NAICS industry context to SEC filers that report a SIC code.
tier aTier A: official concordance.
overview
overview
2,193 (sic, naics) pairs; ~1,005 of ~1,300 4-digit SIC codes covered.
current vintage — 2022
provenance
source & licensing
authority
U.S. Census Bureau
dataset
Census 2017-2022 NAICS to 1987 SIC concordance
source url
license
Public domain (U.S. Federal Government work)
citation
U.S. Census Bureau, 2017-2022 NAICS to 1987 SIC concordance.
schema
fields
| name | type | definition |
|---|---|---|
| is_goods_producing | bool | Boolean flag; TRUE when the NAICS sector is goods-producing (e.g. agriculture, mining, construction, manufacturing). |
| is_service_producing | bool | Boolean flag; TRUE when the NAICS sector is service-producing (all sectors that are not goods-producing). |
| naics_2digit | string | 2-digit NAICS sector code that is the top-level ancestor of the 6-digit NAICS code. |
| naics_2digit_title | string | Title of the 2-digit NAICS sector ancestor. |
| naics_3digit | string | 3-digit NAICS subsector code that is an ancestor of the 6-digit NAICS code. |
| naics_3digit_title | string | Title of the 3-digit NAICS subsector ancestor. |
| naics_4digit | string | 4-digit NAICS industry group code that is an ancestor of the 6-digit NAICS code. |
| naics_4digit_title | string | Title of the 4-digit NAICS industry group ancestor. |
| naics_codekey | string | 6-digit 2022 North American Industry Classification System (NAICS) code that the SIC code maps to; part of the grain. The SIC-to-NAICS mapping is many-to-many, so one SIC code may appear in multiple rows.Part of primary key. Joins dim.naics_codes on naics_code. |
| naics_description | string | NAICS industry title corresponding to the 6-digit NAICS code. |
| naics_vintage | string | Vintage of the NAICS concordance used to build the mapping (the source_vintage of the crosswalk), e.g. the Census Bureau 2017–2022 NAICS to 1987 SIC concordance. |
| sector_label | string | Human-readable sector label derived from the NAICS code, providing plain-language industry context. |
| sic_codekey | string | 4-digit 1987 Standard Industrial Classification (SIC) code assigned to the filer; part of the grain.Part of primary key. |
| sic_description | string | SIC industry title corresponding to the 4-digit SIC code. |
relationships
joins
primary key
sic_code, naics_code
common joins
not provided
usage
how to use this table
method
Joined the Census SIC-NAICS concordance to NAICS 2022 (6-digit hierarchy).
do not use for
SIC major-group codes absent from the concordance; a single NAICS per SIC without filtering.
last updated · Jul 7, 2026