raw.ecn_2022_coThe database generates the following columns:
id: unique identifier for each entryunique_hash: equals the state (fips id) + county (fips id) + naics2022 + taxstat + typop columnsdate_uploaded: timestamp with time zoneFor data validation, I randomly selected 20 states and then randomly selected which line in the file to check. (Here, random means I asked Google Gemini to randomly select the options.)
select * from "raw".ecn_2022_st
where unique_hash in ('170436211120000', ...)
The query results are saved in the file: data_downloader\validation\ecn_2022\ecn_2022_county_validation_2026_05.csv
File: ecnbasic_County_20260511_135341.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["418",null,"0","0","94",null,"94",null,"0500000US17043",null,"DuPage County, Illinois","621112",null,"Offices of Physicians, Mental Health Specialists","29229",null,"0","0","6366",null,"79677",null,"0","0","00","All establishments","00","All establishments","2022","17","043"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7e25960e-397d-4947-ac16-c15e8569ff83 | 418 | NULL | 0 | 0 | 94 | NULL | 94 | NULL | 0500000US17043 | NULL | DuPage County, Illinois | 621112 | NULL | Offices of Physicians, Mental Health Specialists | 29229 | NULL | 0 | 0 | 6366 | NULL | 79677 | NULL | 0 | 0 | 00 | All establishments | 00 | All establishments | 2022 | 17 | 043 | 170436211120000 | 2026-05-11 17:53:47.982588+00 |
File: ecnbasic_County_20260511_135209.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["722",null,"0","6","103",null,"86",null,"0500000US25017",null,"Middlesex County, Massachusetts","621112",null,"Offices of Physicians, Mental Health Specialists","47131",null,"0","4","10826",null,"163035",null,"0","1","T","Establishments subject to federal income tax","00","All establishments","2022","25","017"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 732deea1-4c88-4c4a-b4f2-2140d15e522f | 722 | NULL | 0 | 6 | 103 | NULL | 86 | NULL | 0500000US25017 | NULL | Middlesex County, Massachusetts | 621112 | NULL | Offices of Physicians, Mental Health Specialists | 47131 | NULL | 0 | 4 | 10826 | NULL | 163035 | NULL | 0 | 1 | T | Establishments subject to federal income tax | 00 | All establishments | 2022 | 25 | 017 | 25017621112T00 | 2026-05-11 17:52:13.017243+00 |
File: ecnbasic_County_20260511_135131.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["184",null,"0","0","23",null,"23",null,"0500000US41047",null,"Marion County, Oregon","81131",null,"Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance","9313",null,"0","0","0","D","46839",null,"0","0","00","All establishments","00","All establishments","2022","41","047"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ae8fe6bd-c5fc-459d-b23d-5647ed4b71a8 | 184 | NULL | 0 | 0 | 23 | NULL | 23 | NULL | 0500000US41047 | NULL | Marion County, Oregon | 81131 | NULL | Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance | 9313 | NULL | 0 | 0 | 0 | D | 46839 | NULL | 0 | 0 | 00 | All establishments | 00 | All establishments | 2022 | 41 | 047 | 41047811310000 | 2026-05-11 17:51:35.973694+00 |
File: ecnbasic_County_20260511_134945.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","a","0","D","0","D","0","D","0500000US37083",null,"Halifax County, North Carolina","4842202",null,"Local agricultural products trucking without storage","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","37","083"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| be1c4e87-fc2a-47b8-87d0-6a730857a516 | 0 | a | 0 | D | 0 | D | 0 | D | 0500000US37083 | NULL | Halifax County, North Carolina | 4842202 | NULL | Local agricultural products trucking without storage | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 37 | 083 | 3708348422020000 | 2026-05-11 17:49:53.430715+00 |
File: ecnbasic_County_20260511_134925.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","b","0","D","0","D","0","D","0500000US26081",null,"Kent County, Michigan","81292",null,"Photofinishing","0","D","0","D","0","D","0","D","0","D","T","Establishments subject to federal income tax","00","All establishments","2022","26","081"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7940b830-d4bb-4ce3-9938-f63e2918fc05 | 0 | b | 0 | D | 0 | D | 0 | D | 0500000US26081 | NULL | Kent County, Michigan | 81292 | NULL | Photofinishing | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | T | Establishments subject to federal income tax | 00 | All establishments | 2022 | 26 | 081 | 2608181292T00 | 2026-05-11 17:49:31.713659+00 |
File: ecnbasic_County_20260511_134910.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","b","0","D","0","D","0","D","0500000US29183",null,"St. Charles County, Missouri","611511",null,"Cosmetology and barber schools","0","D","0","D","0","D","4452",null,"0","1","T","Establishments subject to federal income tax","00","All establishments","2022","29","183"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ce478d9c-571c-42ab-b425-a0f76cafaf24 | 0 | b | 0 | D | 0 | D | 0 | D | 0500000US29183 | NULL | St. Charles County, Missouri | 611511 | NULL | Cosmetology and barber schools | 0 | D | 0 | D | 0 | D | 4452 | NULL | 0 | 1 | T | Establishments subject to federal income tax | 00 | All establishments | 2022 | 29 | 183 | 29183611511T00 | 2026-05-11 17:49:16.435868+00 |
File: ecnbasic_County_20260511_134849.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","b","0","D","16",null,"16",null,"0500000US04015",null,"Mohave County, Arizona","54151",null,"Computer Systems Design and Related Services","1681",null,"0","0","408",null,"5731",null,"0","2","T","Establishments subject to federal income tax","00","All establishments","2022","04","015"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2b803b22-6021-4637-9f8e-4d14cfd9f26a | 0 | b | 0 | D | 16 | NULL | 16 | NULL | 0500000US04015 | NULL | Mohave County, Arizona | 54151 | NULL | Computer Systems Design and Related Services | 1681 | NULL | 0 | 0 | 408 | NULL | 5731 | NULL | 0 | 2 | T | Establishments subject to federal income tax | 00 | All establishments | 2022 | 04 | 015 | 0401554151T00 | 2026-05-11 17:48:52.652131+00 |
File: ecnbasic_County_20260511_134651.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["17",null,"0","4","3",null,"3",null,"0500000US40003",null,"Alfalfa County, Oklahoma","444",null,"Building Material and Garden Equipment and Supplies Dealers","831",null,"0","0","195",null,"9051",null,"0","0","00","All establishments","00","All establishments","2022","40","003"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96b4168b-9ed3-4ddd-9b24-d18789a289f2 | 17 | NULL | 0 | 4 | 3 | NULL | 3 | NULL | 0500000US40003 | NULL | Alfalfa County, Oklahoma | 444 | NULL | Building Material and Garden Equipment and Supplies Dealers | 831 | NULL | 0 | 0 | 195 | NULL | 9051 | NULL | 0 | 0 | 00 | All establishments | 00 | All establishments | 2022 | 40 | 003 | 400034440000 | 2026-05-11 17:46:56.759424+00 |
File: ecnbasic_County_20260511_134601.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["95",null,"0","0","29",null,"29",null,"0500000US36091",null,"Saratoga County, New York","541211",null,"Offices of Certified Public Accountants","4758",null,"0","0","1149",null,"12743",null,"0","0","T","Establishments subject to federal income tax","00","All establishments","2022","36","091"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0494ffba-e9c8-4b46-974a-5e6273525703 | 95 | NULL | 0 | 0 | 29 | NULL | 29 | NULL | 0500000US36091 | NULL | Saratoga County, New York | 541211 | NULL | Offices of Certified Public Accountants | 4758 | NULL | 0 | 0 | 1149 | NULL | 12743 | NULL | 0 | 0 | T | Establishments subject to federal income tax | 00 | All establishments | 2022 | 36 | 091 | 36091541211T00 | 2026-05-11 17:46:09.211767+00 |
File: ecnbasic_County_20260511_134538.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["981",null,"0","1","81",null,"67",null,"0500000US48147",null,"Fannin County, Texas","44-45",null,"Retail trade","27198",null,"0","1","6823",null,"362966",null,"0","1","00","All establishments","00","All establishments","2022","48","147"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e3b785df-b1b9-48cd-a4e3-aa56b8a21f3c | 981 | NULL | 0 | 1 | 81 | NULL | 67 | NULL | 0500000US48147 | NULL | Fannin County, Texas | 44-45 | NULL | Retail trade | 27198 | NULL | 0 | 1 | 6823 | NULL | 362966 | NULL | 0 | 1 | 00 | All establishments | 00 | All establishments | 2022 | 48 | 147 | 4814744-450000 | 2026-05-11 17:45:51.130338+00 |
File: ecnbasic_County_20260511_134524.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["215",null,"0","0","43",null,"42",null,"0500000US02090",null,"Fairbanks North Star Borough, Alaska","813","120","Religious, Grantmaking, Civic, Professional, and Similar Organizations","10251",null,"0","0","2228",null,"39388",null,"0","1","Y","Establishments exempt from federal income tax","00","All establishments","2022","02","090"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4dd59e91-eec2-4dcb-a1b7-9ada13704feb | 215 | NULL | 0 | 0 | 43 | NULL | 42 | NULL | 0500000US02090 | NULL | Fairbanks North Star Borough, Alaska | 813 | 120 | Religious, Grantmaking, Civic, Professional, and Similar Organizations | 10251 | NULL | 0 | 0 | 2228 | NULL | 39388 | NULL | 0 | 1 | Y | Establishments exempt from federal income tax | 00 | All establishments | 2022 | 02 | 090 | 02090813Y00 | 2026-05-11 17:45:26.342923+00 |
File: ecnbasic_County_20260511_134458.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","b","0","D","0","D","0","D","0500000US20173",null,"Sedgwick County, Kansas","811490",null,"Other Personal and Household Goods Repair and Maintenance","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","20","173"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cf4a4aa7-d790-4dae-aa86-b55632416dc1 | 0 | b | 0 | D | 0 | D | 0 | D | 0500000US20173 | NULL | Sedgwick County, Kansas | 811490 | NULL | Other Personal and Household Goods Repair and Maintenance | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 20 | 173 | 201738114900000 | 2026-05-11 17:45:03.27905+00 |
File: ecnbasic_County_20260511_134438.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["67",null,"0","0","7",null,"7",null,"0500000US33015",null,"Rockingham County, New Hampshire","449122",null,"Window Treatment Retailers","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","33","015"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192ff27b-f85c-4acc-90bd-2158f950b550 | 67 | NULL | 0 | 0 | 7 | NULL | 7 | NULL | 0500000US33015 | NULL | Rockingham County, New Hampshire | 449122 | NULL | Window Treatment Retailers | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 33 | 015 | 330154491220000 | 2026-05-11 17:44:41.092924+00 |
File: ecnbasic_County_20260511_134414.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["50",null,"0","6","8",null,"8",null,"0500000US53035",null,"Kitsap County, Washington","54181",null,"Advertising Agencies","4464",null,"0","0","1053",null,"34132",null,"0","0","00","All establishments","00","All establishments","2022","53","035"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ec381c27-9ff3-4582-a25c-84378a3edd59 | 50 | NULL | 0 | 6 | 8 | NULL | 8 | NULL | 0500000US53035 | NULL | Kitsap County, Washington | 54181 | NULL | Advertising Agencies | 4464 | NULL | 0 | 0 | 1053 | NULL | 34132 | NULL | 0 | 0 | 00 | All establishments | 00 | All establishments | 2022 | 53 | 035 | 53035541810000 | 2026-05-11 17:44:19.588663+00 |
File: ecnbasic_County_20260511_134326.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","b","0","D","0","D","0","D","0500000US18183",null,"Whitley County, Indiana","5414",null,"Specialized design services","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","18","183"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8d632a5d-8643-4fc0-8202-c2f09444d481 | 0 | b | 0 | D | 0 | D | 0 | D | 0500000US18183 | NULL | Whitley County, Indiana | 5414 | NULL | Specialized design services | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 18 | 183 | 1818354140000 | 2026-05-11 17:43:32.369606+00 |
File: ecnbasic_County_20260511_134319.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","e","0","D","0","D","0","D","0500000US54033",null,"Harrison County, West Virginia","62142",null,"Outpatient Mental Health and Substance Abuse Centers","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","54","033"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5ba15b75-3083-4dd6-84bd-ade5d43eeef7 | 0 | e | 0 | D | 0 | D | 0 | D | 0500000US54033 | NULL | Harrison County, West Virginia | 62142 | NULL | Outpatient Mental Health and Substance Abuse Centers | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 54 | 033 | 54033621420000 | 2026-05-11 17:43:22.847702+00 |
File: ecnbasic_County_20260511_134315.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["32",null,"0","0","3",null,"3",null,"0500000US44009",null,"Washington County, Rhode Island","71391",null,"Golf Courses and Country Clubs","6123",null,"0","0","695",null,"16415",null,"0","0","Y","Establishments exempt from federal income tax","00","All establishments","2022","44","009"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51ff877c-c388-483e-9520-6663205e7efe | 32 | NULL | 0 | 0 | 3 | NULL | 3 | NULL | 0500000US44009 | NULL | Washington County, Rhode Island | 71391 | NULL | Golf Courses and Country Clubs | 6123 | NULL | 0 | 0 | 695 | NULL | 16415 | NULL | 0 | 0 | Y | Establishments exempt from federal income tax | 00 | All establishments | 2022 | 44 | 009 | 4400971391Y00 | 2026-05-11 17:43:16.965587+00 |
File: ecnbasic_County_20260511_134259.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","a","0","D","4",null,"4",null,"0500000US23019",null,"Penobscot County, Maine","721191",null,"Bed-and-breakfast inns","0","D","0","D","0","D","0","D","0","D","00","All establishments","00","All establishments","2022","23","019"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c55f9e2a-9ec5-4588-bf0b-8f51e8e089cc | 0 | a | 0 | D | 4 | NULL | 4 | NULL | 0500000US23019 | NULL | Penobscot County, Maine | 721191 | NULL | Bed-and-breakfast inns | 0 | D | 0 | D | 0 | D | 0 | D | 0 | D | 00 | All establishments | 00 | All establishments | 2022 | 23 | 019 | 230197211910000 | 2026-05-11 17:43:02.116282+00 |
File: ecnbasic_County_20260511_134223.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["0","c","0","D","26",null,"25",null,"0500000US45023",null,"Chester County, South Carolina","56",null,"Administrative and support and waste management and remediation services","0","D","0","D","0","D","12010",null,"0","1","00","All establishments","00","All establishments","2022","45","023"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4668ba34-a77b-408a-a027-229f0beff85a | 0 | c | 0 | D | 26 | NULL | 25 | NULL | 0500000US45023 | NULL | Chester County, South Carolina | 56 | NULL | Administrative and support and waste management and remediation services | 0 | D | 0 | D | 0 | D | 12010 | NULL | 0 | 1 | 00 | All establishments | 00 | All establishments | 2022 | 45 | 023 | 45023560000 | 2026-05-11 17:42:28.205703+00 |
File: ecnbasic_County_20260511_134425.json
[["EMP","EMP_F","EMP_IMP","EMP_IMP_F","ESTAB","ESTAB_F","FIRM","FIRM_F","GEO_ID","GEO_ID_F","NAME","NAICS2022","NAICS2022_F","NAICS2022_LABEL","PAYANN","PAYANN_F","PAYANN_IMP","PAYANN_IMP_F","PAYQTR1","PAYQTR1_F","RCPTOT","RCPTOT_F","RCPTOT_IMP","RCPTOT_IMP_F","TAXSTAT","TAXSTAT_LABEL","TYPOP","TYPOP_LABEL","YEAR","state","county"],
["512",null,"0","3","32",null,"25",null,"0500000US01033",null,"Colbert County, Alabama","6211",null,"Offices of Physicians","34573",null,"0","3","6608",null,"71119",null,"0","4","00","All establishments","00","All establishments","2022","01","033"]]
| id | emp | emp_f | emp_imp | emp_imp_f | estab | estab_f | firm | firm_f | geo_id | geo_id_f | name | naics2022 | naics2022_f | naics2022_label | payann | payann_f | payann_imp | payann_imp_f | payqtr1 | payqtr1_f | rcptot | rcptot_f | rcptot_imp | rcptot_imp_f | taxstat | taxstat_label | typop | typop_label | year | state | county | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5b52393b-1d70-42dc-8f28-4c1c95600516 | 512 | NULL | 0 | 3 | 32 | NULL | 25 | NULL | 0500000US01033 | NULL | Colbert County, Alabama | 6211 | NULL | Offices of Physicians | 34573 | NULL | 0 | 3 | 6608 | NULL | 71119 | NULL | 0 | 4 | 00 | All establishments | 00 | All establishments | 2022 | 01 | 033 | 0103362110000 | 2026-05-11 17:44:30.77938+00 |