- Database Table:
raw.cbp_2023_us
- Date Completed: 2026-06-05 (June 5, 2026)
- Table contains 81_715 entries
- Program ran on laptop
- Raw data:
data_downloader/raw_data/cbp_National_al_20260518_125253.json
- Validated data:
data_downloader/validation/cbp_2023/cbp_2023_us_validation_2026_05.csv
Generated Columns:
idunique_hash = naics2017 + lfo + emp_szesdate_uploaded: timestamp
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["71311","Amusement and theme parks","9111","S-corporations","209",null,"0","H","220","Establishments with 5 to 9 employees","31",null,"0100000US",null,"United States","7131","5","11515",null,"0","H","1385",null,"0","H","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| 65f6f946-8d1b-4ba9-822c-9aa3f9204d73 |
71311 |
Amusement and theme parks |
9111 |
S-corporations |
209 |
NULL |
0 |
H |
220 |
Establishments with 5 to 9 employees |
31 |
NULL |
0100000US |
NULL |
United States |
7131 |
5 |
11515 |
NULL |
0 |
H |
1385 |
NULL |
0 |
H |
2023 |
1 |
713119111220 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["113","Forestry and logging","9111","S-corporations","6617",null,"0","G","230","Establishments with 10 to 19 employees","508",null,"0100000US",null,"United States",null,"3","382862",null,"0","G","91492",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| 4c44a200-b47a-4b31-927e-cd9da155ca1a |
113 |
Forestry and logging |
9111 |
S-corporations |
6617 |
NULL |
0 |
G |
230 |
Establishments with 10 to 19 employees |
508 |
NULL |
0100000US |
NULL |
United States |
NULL |
3 |
382862 |
NULL |
0 |
G |
91492 |
NULL |
0 |
G |
2023 |
1 |
1139111230 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["2122","Metal ore mining","9111","S-corporations","48",null,"0","H","210","Establishments with less than 5 employees","42",null,"0100000US",null,"United States","2122","4","5046",null,"0","G","528",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| aaa1cd21-43fc-44a2-8faf-367dcf30bf16 |
2122 |
Metal ore mining |
9111 |
S-corporations |
48 |
NULL |
0 |
H |
210 |
Establishments with less than 5 employees |
42 |
NULL |
0100000US |
NULL |
United States |
2122 |
4 |
5046 |
NULL |
0 |
G |
528 |
NULL |
0 |
G |
2023 |
1 |
21229111210 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["22131","Water supply and irrigation systems","932","Non-profit","9126",null,"0","G","001","All establishments","1698",null,"0100000US",null,"United States","2213","5","450609",null,"0","G","108512",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| afd235c7-1cd9-46f6-a3f2-9fb37405a2f3 |
22131 |
Water supply and irrigation systems |
932 |
Non-profit |
9126 |
NULL |
0 |
G |
001 |
All establishments |
1698 |
NULL |
0100000US |
NULL |
United States |
2213 |
5 |
450609 |
NULL |
0 |
G |
108512 |
NULL |
0 |
G |
2023 |
1 |
22131932001 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["335991","Carbon and graphite product manufacturing","930","Partnerships","536",null,"0","H","001","All establishments","22",null,"0100000US",null,"United States","3359","6","39837",null,"0","H","9000",null,"0","H","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| 617527b4-f842-4017-8d1a-6843dca09618 |
335991 |
Carbon and graphite product manufacturing |
930 |
Partnerships |
536 |
NULL |
0 |
H |
001 |
All establishments |
22 |
NULL |
0100000US |
NULL |
United States |
3359 |
6 |
39837 |
NULL |
0 |
H |
9000 |
NULL |
0 |
H |
2023 |
1 |
335991930001 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL", "EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["339999","All other miscellaneous manufacturing","930","Partnerships","6101",null,"0","G","001","All establishments","410",null,"0100000US",null,"United States","3399","6","320660",null,"0","G","77381",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| bccf7382-3317-4971-ad0f-f597dde0a1b4 |
339999 |
All other miscellaneous manufacturing |
930 |
Partnerships |
6101 |
NULL |
0 |
G |
001 |
All establishments |
410 |
NULL |
0100000US |
NULL |
United States |
3399 |
6 |
320660 |
NULL |
0 |
G |
77381 |
NULL |
0 |
G |
2023 |
1 |
339999930001 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["5111","Newspaper, periodical, book, and directory publishers","001","All establishments","36495",null,"0","G","241","Establishments with 20 to 49 employees","1192",null,"0100000US",null,"United States","5111","4","2372849",null,"0","G","615687",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| 0195f926-0974-42ff-9f06-a74beee4636c |
5111 |
Newspaper, periodical, book, and directory publishers |
001 |
All establishments |
36495 |
NULL |
0 |
G |
241 |
Establishments with 20 to 49 employees |
1192 |
NULL |
0100000US |
NULL |
United States |
5111 |
4 |
2372849 |
NULL |
0 |
G |
615687 |
NULL |
0 |
G |
2023 |
1 |
5111001241 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["4931","Warehousing and storage","9101","C-corporations and other corporate legal forms of organization","23179",null,"0","G","230","Establishments with 10 to 19 employees","1690",null,"0100000US",null,"United States","4931","4","1522804",null,"0","G","392007",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| d22a81a9-e3e3-4ec7-86fa-737f5f0aec80 |
4931 |
Warehousing and storage |
9101 |
C-corporations and other corporate legal forms of organization |
23179 |
NULL |
0 |
G |
230 |
Establishments with 10 to 19 employees |
1690 |
NULL |
0100000US |
NULL |
United States |
4931 |
4 |
1522804 |
NULL |
0 |
G |
392007 |
NULL |
0 |
G |
2023 |
1 |
49319101230 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["485999","All other transit and ground passenger transportation","930","Partnerships","307",null,"0","G","230","Establishments with 10 to 19 employees","24",null,"0100000US",null,"United States","4859","6","10347",null,"0","G","2433",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| f1764e51-572d-4ee8-bd8f-79e28980463c |
485999 |
All other transit and ground passenger transportation |
930 |
Partnerships |
307 |
NULL |
0 |
G |
230 |
Establishments with 10 to 19 employees |
24 |
NULL |
0100000US |
NULL |
United States |
4859 |
6 |
10347 |
NULL |
0 |
G |
2433 |
NULL |
0 |
G |
2023 |
1 |
485999930230 |
2026-05-18 16:53:01.642825+00 |
[["NAICS2017","NAICS2017_LABEL","LFO","LFO_LABEL","EMP","EMP_F","EMP_N","EMP_N_F","EMPSZES","EMPSZES_LABEL","ESTAB","ESTAB_F","GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","PAYANN","PAYANN_F","PAYANN_N","PAYANN_N_F","PAYQTR1","PAYQTR1_F","PAYQTR1_N","PAYQTR1_N_F","YEAR","us"],
["541910","Marketing research and public opinion polling","930","Partnerships","1579",null,"0","G","242","Establishments with 50 to 99 employees","23",null,"0100000US",null,"United States","5419","6","166513",null,"0","G","42406",null,"0","G","2023","1"]]
| id |
naics_2017 |
naics_2017_label |
lfo |
lfo_label |
emp |
emp_f |
emp_noise |
emp_noise_f |
emp_sizes |
emp_sizes_label |
estab |
estab_f |
geo_id |
geo_id_f |
name |
industry_group |
industry_level |
payann |
paynn_f |
paynn_noise |
payann_noise_f |
payqtr1 |
payqtr1_f |
payqtr1_noise |
payqtr1_noise_f |
year |
us |
unique_hash |
date_uploaded |
| 4e04a10c-38db-4ea5-ac20-0d0f4a3c39c8 |
541910 |
Marketing research and public opinion polling |
930 |
Partnerships |
1579 |
NULL |
0 |
G |
242 |
Establishments with 50 to 99 employees |
23 |
NULL |
0100000US |
NULL |
United States |
5419 |
6 |
166513 |
NULL |
0 |
G |
42406 |
NULL |
0 |
G |
2023 |
1 |
541910930242 |
2026-05-18 16:53:01.642825+00 |