raw.nes_2023_stThis table has 94,825 rows (or entries). I chose 15 random states/DC and selected a random line in each of those files to check (used Google Gemini for these pseudorandom selections).
Generated columns:
idunique_hash = state (fips code) + naics2022 + lfo + rcpszesdate_uploaded: timestampValidation data is stored in data_downloader/validation/nes_2023/nes_state_validation_2026_05.csv
File: nes_State_az_20260528_105928.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US04",null,"Arizona","7225","4","7225",null,"Restaurants and Other Eating Places","930","Partnerships","200",null,"42972",null,"0","G","001","All establishments","72","722","040","2023","04"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b9b74d19-f572-407d-a4bf-c1b973796594 | 0400000US04 | NULL | Arizona | 7225 | 4 | 7225 | NULL | Restaurants and Other Eating Places | 930 | Partnerships | 200 | NULL | 42972 | NULL | 0 | G | 001 | All establishments | 72 | 722 | 040 | 2023 | 04 | 047225930001 | 2026-05-28 14:59:29.943957+00 |
File: nes_State_co_20260528_105409.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US08",null,"Colorado","2373","5","23731",null,"Highway, Street, and Bridge Construction","930","Partnerships","6",null,"1345",null,"0","H","001","All establishments","23","237","040","2023","08"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29a6552f-ba85-44fe-b9e9-0f549001b319 | 0400000US08 | NULL | Colorado | 2373 | 5 | 23731 | NULL | Highway, Street, and Bridge Construction | 930 | Partnerships | 6 | NULL | 1345 | NULL | 0 | H | 001 | All establishments | 23 | 237 | 040 | 2023 | 08 | 0823731930001 | 2026-05-28 14:54:12.58613+00 |
File: nes_State_ct_20260528_105734.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US09",null,"Connecticut","7225","6","722511",null,"Full-Service Restaurants","9111","S-corporations","18",null,"2044",null,"0","G","001","All establishments","72","722","040","2023","09"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a14a2064-ee34-4aee-9b4c-8bfeae8a737e | 0400000US09 | NULL | Connecticut | 7225 | 6 | 722511 | NULL | Full-Service Restaurants | 9111 | S-corporations | 18 | NULL | 2044 | NULL | 0 | G | 001 | All establishments | 72 | 722 | 040 | 2023 | 09 | 097225119111001 | 2026-05-28 14:57:36.272536+00 |
File: nes_State_ia_20260528_110013.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US19",null,"Iowa","1141","5","11411",null,"Fishing","9111","S-corporations","5",null,"17",null,"0","J","001","All establishments","11","114","040","2023","19"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f0a25993-d291-4e59-8c91-d983d5ccb2a0 | 0400000US19 | NULL | Iowa | 1141 | 5 | 11411 | NULL | Fishing | 9111 | S-corporations | 5 | NULL | 17 | NULL | 0 | J | 001 | All establishments | 11 | 114 | 040 | 2023 | 19 | 19114119111001 | 2026-05-28 15:00:14.448052+00 |
File: nes_State_id_20260528_110016.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US16",null,"Idaho",null,"3","449",null,"Furniture, Home Furnishings, Electronics, and Appliance Retailers","9111","S-corporations","21",null,"1960",null,"0","H","001","All establishments","44","449","040","2023","16"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0cd99996-6aa4-401a-b9fb-0dc7ff270695 | 0400000US16 | NULL | Idaho | NULL | 3 | 449 | NULL | Furniture, Home Furnishings, Electronics, and Appliance Retailers | 9111 | S-corporations | 21 | NULL | 1960 | NULL | 0 | H | 001 | All establishments | 44 | 449 | 040 | 2023 | 16 | 164499111001 | 2026-05-28 15:00:17.730955+00 |
File: nes_State_in_20260528_105912.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US18",null,"Indiana","7131","4","7131",null,"Amusement parks and arcades","9111","S-corporations","9",null,"1680",null,"0","H","001","All establishments","71","713","040","2023","18"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ff736afa-cc91-41f8-b083-3c5ed91d8e2e | 0400000US18 | NULL | Indiana | 7131 | 4 | 7131 | NULL | Amusement parks and arcades | 9111 | S-corporations | 9 | NULL | 1680 | NULL | 0 | H | 001 | All establishments | 71 | 713 | 040 | 2023 | 18 | 1871319111001 | 2026-05-28 14:59:13.645985+00 |
File: nes_State_md_20260528_105711.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US24",null,"Maryland","6213","5","62132",null,"Offices of Optometrists","9101","C-corporations and other corporate legal forms of organization","3",null,"1234",null,"0","J","001","All establishments","62","621","040","2023","24"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e334dfdf-3f15-4bcf-b211-9dacfe0f6805 | 0400000US24 | NULL | Maryland | 6213 | 5 | 62132 | NULL | Offices of Optometrists | 9101 | C-corporations and other corporate legal forms of organization | 3 | NULL | 1234 | NULL | 0 | J | 001 | All establishments | 62 | 621 | 040 | 2023 | 24 | 24621329101001 | 2026-05-28 14:57:13.625241+00 |
File: nes_State_ms_20260528_105509.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US28",null,"Mississippi","6212","4","6212",null,"Offices of Dentists","930","Partnerships","3",null,"1824",null,"0","H","001","All establishments","62","621","040","2023","28"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ae001571-55a1-479f-8aa4-d70646188ec9 | 0400000US28 | NULL | Mississippi | 6212 | 4 | 6212 | NULL | Offices of Dentists | 930 | Partnerships | 3 | NULL | 1824 | NULL | 0 | H | 001 | All establishments | 62 | 621 | 040 | 2023 | 28 | 286212930001 | 2026-05-28 14:55:17.762741+00 |
File: nes_State_nd_20260528_105519.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US38",null,"North Dakota",null,"3","314",null,"Textile Product Mills","920","Individual proprietorships","13",null,"214",null,"0","H","001","All establishments","31","314","040","2023","38"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fbcd2256-a021-43ab-ae8f-be2f3423f0f0 | 0400000US38 | NULL | North Dakota | NULL | 3 | 314 | NULL | Textile Product Mills | 920 | Individual proprietorships | 13 | NULL | 214 | NULL | 0 | H | 001 | All establishments | 31 | 314 | 040 | 2023 | 38 | 38314920001 | 2026-05-28 14:55:50.118971+00 |
File: nes_State_nh_20260528_110039.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US33",null,"New Hampshire",null,"3","517",null,"Telecommunications","9111","S-corporations","9",null,"1532",null,"0","G","001","All establishments","51","517","040","2023","33"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 521b4a8a-aa38-4078-9026-1a79e59d9eec | 0400000US33 | NULL | New Hampshire | NULL | 3 | 517 | NULL | Telecommunications | 9111 | S-corporations | 9 | NULL | 1532 | NULL | 0 | G | 001 | All establishments | 51 | 517 | 040 | 2023 | 33 | 335179111001 | 2026-05-28 15:00:40.932237+00 |
File: nes_State_ok_20260528_105417.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US40",null,"Oklahoma","4239","5","42394",null,"Jewelry, Watch, Precious Stone, and Precious Metal Merchant Wholesalers","930","Partnerships","9",null,"858",null,"0","G","001","All establishments","42","423","040","2023","40"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3b6e1157-a834-47cf-8054-a2aaec3ef76f | 0400000US40 | NULL | Oklahoma | 4239 | 5 | 42394 | NULL | Jewelry, Watch, Precious Stone, and Precious Metal Merchant Wholesalers | 930 | Partnerships | 9 | NULL | 858 | NULL | 0 | G | 001 | All establishments | 42 | 423 | 040 | 2023 | 40 | 4042394930001 | 2026-05-28 14:54:36.184844+00 |
File: nes_State_sc_20260528_105842.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US45",null,"South Carolina","4249","4","4249",null,"Miscellaneous Nondurable Goods Merchant Wholesalers","9111","S-corporations","98",null,"20760",null,"0","G","001","All establishments","42","424","040","2023","45"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8cbe81fe-935e-4474-9dce-c7f918bb5a6e | 0400000US45 | NULL | South Carolina | 4249 | 4 | 4249 | NULL | Miscellaneous Nondurable Goods Merchant Wholesalers | 9111 | S-corporations | 98 | NULL | 20760 | NULL | 0 | G | 001 | All establishments | 42 | 424 | 040 | 2023 | 45 | 4542499111001 | 2026-05-28 14:58:44.043875+00 |
File: nes_State_sd_20260528_105633.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US46",null,"South Dakota",null,"3","456",null,"Health and Personal Care Retailers","920","Individual proprietorships","1304",null,"22373",null,"0","G","001","All establishments","44","456","040","2023","46"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57066e3d-72e4-4bd6-8446-99d3241f2c0e | 0400000US46 | NULL | South Dakota | NULL | 3 | 456 | NULL | Health and Personal Care Retailers | 920 | Individual proprietorships | 1304 | NULL | 22373 | NULL | 0 | G | 001 | All establishments | 44 | 456 | 040 | 2023 | 46 | 46456920001 | 2026-05-28 14:56:50.504931+00 |
File: nes_State_tx_20260528_105833.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US48",null,"Texas","8129","5","81299",null,"All Other Personal Services","001","All establishments","77314",null,"2663934",null,"0","G","001","All establishments","81","812","040","2023","48"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e3880ffb-d43f-4321-9b03-bd4b002b6f6e | 0400000US48 | NULL | Texas | 8129 | 5 | 81299 | NULL | All Other Personal Services | 001 | All establishments | 77314 | NULL | 2663934 | NULL | 0 | G | 001 | All establishments | 81 | 812 | 040 | 2023 | 48 | 4881299001001 | 2026-05-28 14:58:37.385895+00 |
File: nes_State_va_20260528_105938.json
[["GEO_ID","GEO_ID_F","NAME","INDGROUP","INDLEVEL","NAICS2022","NAICS2022_F","NAICS2022_LABEL","LFO","LFO_LABEL","NESTAB","NESTAB_F","NRCPTOT","NRCPTOT_F","NRCPTOT_N","NRCPTOT_N_F","RCPSZES","RCPSZES_LABEL","SECTOR","SUBSECTOR","SUMLEVEL","YEAR","state"],
["0400000US51",null,"Virginia",null,"3","238",null,"Specialty Trade Contractors","920","Individual proprietorships","41465",null,"2374365",null,"0","G","001","All establishments","23","238","040","2023","51"]]
| id | geo_id | geo_id_flag | name | industry_group | industry_level | naics2022 | naics2022_flag | naics2022_label | lfo | lfo_label | nestab | nestab_flag | nrcptot | nrcptot_flag | nrcptot_noise | nrcptot_noise_flag | rcpszes | rcpszes_label | sector | subsector | summary_level | year | state | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3dc2937e-535c-4514-8dd9-b97b03cca4dc | 0400000US51 | NULL | Virginia | NULL | 3 | 238 | NULL | Specialty Trade Contractors | 920 | Individual proprietorships | 41465 | NULL | 2374365 | NULL | 0 | G | 001 | All establishments | 23 | 238 | 040 | 2023 | 51 | 51238920001 | 2026-05-28 14:59:53.666796+00 |