- Database Table:
raw.ecn_prdind_us
- Date Completed: 2026-09-09 (Sep 9, 2026)
- Table contains 32_024 entries
- Program ran on server
- Raw data:
data_downloader/raw_data/ecn_prdind/ecn_prdind_National_us.json
- Validated data:
data_downloader/validation/ecn_prdind/ecn_prdind_us_2026_09_09.csv
Generated Columns:
id: uuidunique_hash = geo_id + naics2022 + napcs2022 + taxstat + typop + year + indleveldate_uploaded: timestamp (with time zone)
SELECT * FROM "raw".ecn_napcs_indprd_us
WHERE unique_hash in ('0100000US_00_2002675000_00_00_2022_2', '0100000US_339999_2023100000_00_00_2022_6',
'0100000US_00_2036250000_00_00_2022_2', '0100000US_337110_3000700000_00_00_2022_6',
'0100000US_333993_4002450000_00_00_2022_6', '0100000US_423730_4004850000_00_00_2022_6',
'0100000US_713120_5000950000_00_00_2022_6', '0100000US_513130_7001275000_00_00_2022_6',
'0100000US_424410_7011900000_00_00_2022_6', '0100000US_712190_9000000000_00_00_2022_6')
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["153",null,"7.0",null,"0100000US",null,"United States","2","00",null,"Total for all sectors","100.0",null,"0.0",null,"2002675000",null,"Manufacturing of canned vegetables","3770530",null,"4.6",null,"0","1","00","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| c95a4c1d-4e0c-4e18-8c3f-8a59c520324c |
153 |
NULL |
7.0 |
NULL |
0100000US |
NULL |
United States |
2 |
00 |
NULL |
Total for all sectors |
100.0 |
NULL |
0.0 |
NULL |
2002675000 |
NULL |
Manufacturing of canned vegetables |
3770530 |
NULL |
4.6 |
NULL |
0 |
1 |
00 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_00_2002675000_00_00_2022_2 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["0","S","0.0","S","0100000US",null,"United States","6","339999",null,"All Other Miscellaneous Manufacturing","0.0","D","0.0","D","2023100000",null,"Manufacturing of machined furniture parts, plastic and metal, including frames and sleeper mechanisms and other types (excluding metal furniture hardware)","0","D","0.0","D","0","D","31","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| defd331c-8042-42fa-ab91-53385f353658 |
0 |
S |
0.0 |
S |
0100000US |
NULL |
United States |
6 |
339999 |
NULL |
All Other Miscellaneous Manufacturing |
0.0 |
D |
0.0 |
D |
2023100000 |
NULL |
Manufacturing of machined furniture parts, plastic and metal, including frames and sleeper mechanisms and other types (excluding metal furniture hardware) |
0 |
D |
0.0 |
D |
0 |
D |
31 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_339999_2023100000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["54",null,"1.2",null,"0100000US",null,"United States","2","00",null,"Total for all sectors","100.0",null,"0.0",null,"2036250000",null,"Manufacturing of laminated or multilayered asphalt strip shingles, and individual shingles","8617605",null,"0.1",null,"0","0","00","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| 9abf2bfb-33ae-4727-a1c8-25f11a12353a |
54 |
NULL |
1.2 |
NULL |
0100000US |
NULL |
United States |
2 |
00 |
NULL |
Total for all sectors |
100.0 |
NULL |
0.0 |
NULL |
2036250000 |
NULL |
Manufacturing of laminated or multilayered asphalt strip shingles, and individual shingles |
8617605 |
NULL |
0.1 |
NULL |
0 |
0 |
00 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_00_2036250000_00_00_2022_2 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["0","D","0.0","D","0100000US",null,"United States","6","337110",null,"Wood Kitchen Cabinet and Countertop Manufacturing","0.0","D","0.0","D","3000700000",null,"Factory, assembly plant, industrial research laboratory, and other manufacturing and industrial building constructions","0","D","0.0","D","0","D","31","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| 01851dfe-7480-425a-87ea-852cdc4637bd |
0 |
D |
0.0 |
D |
0100000US |
NULL |
United States |
6 |
337110 |
NULL |
Wood Kitchen Cabinet and Countertop Manufacturing |
0.0 |
D |
0.0 |
D |
3000700000 |
NULL |
Factory, assembly plant, industrial research laboratory, and other manufacturing and industrial building constructions |
0 |
D |
0.0 |
D |
0 |
D |
31 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_337110_3000700000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["19",null,"11.7",null,"0100000US",null,"United States","6","333993",null,"Packaging machinery manufacturing","0.1",null,"23.4",null,"4002450000",null,"Wholesale sales of used industrial machinery and equipment","17890",null,"16.8",null,"0","2","31","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| ba650a3e-db9c-4e19-b765-057fd845c9d1 |
19 |
NULL |
11.7 |
NULL |
0100000US |
NULL |
United States |
6 |
333993 |
NULL |
Packaging machinery manufacturing |
0.1 |
NULL |
23.4 |
NULL |
4002450000 |
NULL |
Wholesale sales of used industrial machinery and equipment |
17890 |
NULL |
16.8 |
NULL |
0 |
2 |
31 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_333993_4002450000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["162",null,"9.6",null,"0100000US",null,"United States","6","423730",null,"Warm Air Heating and Air-Conditioning Equipment and Supplies Merchant Wholesalers","0.1",null,"63.5",null,"4004850000",null,"Wholesale sales of electrical, communication, and lighting system products, including garage door openers, wiring, and cables","244636","s","63.5",null,"0","7","42","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| ffbc1ba0-4ed0-4133-acf4-5e1bf918c957 |
162 |
NULL |
9.6 |
NULL |
0100000US |
NULL |
United States |
6 |
423730 |
NULL |
Warm Air Heating and Air-Conditioning Equipment and Supplies Merchant Wholesalers |
0.1 |
NULL |
63.5 |
NULL |
4004850000 |
NULL |
Wholesale sales of electrical, communication, and lighting system products, including garage door openers, wiring, and cables |
244636 |
s |
63.5 |
NULL |
0 |
7 |
42 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_423730_4004850000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["0","D","0.0","D","0100000US",null,"United States","6","713120",null,"Amusement Arcades","0.0","D","0.0","D","5000950000",null,"Retail sales of magazines and newspapers, including issue format comic books","0","D","0.0","D","0","D","71","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| 89127785-fd00-4804-b302-2630ffda84c9 |
0 |
D |
0.0 |
D |
0100000US |
NULL |
United States |
6 |
713120 |
NULL |
Amusement Arcades |
0.0 |
D |
0.0 |
D |
5000950000 |
NULL |
Retail sales of magazines and newspapers, including issue format comic books |
0 |
D |
0.0 |
D |
0 |
D |
71 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_713120_5000950000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["0","S","0.0","S","0100000US",null,"United States","6","513130",null,"Book Publishers","0.0","S","0.0","S","7001275000",null,"Periodicals, not elsewhere classified","0","A","0.0","S","0","S","51","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| fd6fe6d2-f645-4960-869b-a3ed411420fb |
0 |
S |
0.0 |
S |
0100000US |
NULL |
United States |
6 |
513130 |
NULL |
Book Publishers |
0.0 |
S |
0.0 |
S |
7001275000 |
NULL |
Periodicals, not elsewhere classified |
0 |
A |
0.0 |
S |
0 |
S |
51 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_513130_7001275000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["0","S","0.0","S","0100000US",null,"United States","6","424410",null,"General Line Grocery Merchant Wholesalers","0.0","Z","139.4",null,"7011900000",null,"Warehousing and storage services","0","A","0.0","S","0","S","42","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| ff237d4b-4b83-4a97-9bf7-157c07752786 |
0 |
S |
0.0 |
S |
0100000US |
NULL |
United States |
6 |
424410 |
NULL |
General Line Grocery Merchant Wholesalers |
0.0 |
Z |
139.4 |
NULL |
7011900000 |
NULL |
Warehousing and storage services |
0 |
A |
0.0 |
S |
0 |
S |
42 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_424410_7011900000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |
[["ESTAB","ESTAB_F","ESTAB_CV","ESTAB_CV_F","GEO_ID","GEO_ID_F","NAME","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","NAICSALL_PCT","NAICSALL_PCT_F","NAICSALL_PCT_SE","NAICSALL_PCT_SE_F","NAPCS2022","NAPCS2022_F","NAPCS2022_LABEL","NAPCSDOL","NAPCSDOL_F","NAPCSDOL_CV","NAPCSDOL_CV_F","NAPCSDOL_IMP","NAPCSDOL_IMP_F","SECTOR","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","us"],
["39",null,"17.8",null,"0100000US",null,"United States","6","712190",null,"Nature Parks and Other Similar Institutions","0.0","D","0.0","D","9000000000",null,"All other products and services, not elsewhere classified","0","D","0.0","D","0","D","71","00","All establishments","00","All establishments","2022","1"]]
| id |
estab |
estab_f |
estab_rse |
estab_rse_f |
geo_id |
geo_id_f |
name |
indlevel |
naics2022 |
naics2022_f |
naics2022_label |
naicsall_pct |
naicsall_pct_f |
naicsall_pct_se |
naicsall_pct_se_f |
napcs2022 |
napcs2022_f |
napcs2022_label |
napcsdol |
napcsdol_f |
napcsdol_rse |
napcsdol_rse_f |
napcsdol_imp |
napcsdol_imp_f |
sector |
taxstat |
taxstat_label |
typop |
typop_label |
year |
us |
unique_hash |
date_uploaded |
| 6d1a3b28-c8ad-42b0-9bfe-c2106197dc40 |
39 |
NULL |
17.8 |
NULL |
0100000US |
NULL |
United States |
6 |
712190 |
NULL |
Nature Parks and Other Similar Institutions |
0.0 |
D |
0.0 |
D |
9000000000 |
NULL |
All other products and services, not elsewhere classified |
0 |
D |
0.0 |
D |
0 |
D |
71 |
00 |
All establishments |
00 |
All establishments |
2022 |
1 |
0100000US_712190_9000000000_00_00_2022_6 |
2026-09-09 15:17:20.568854+00 |