Skip to content

Instantly share code, notes, and snippets.

@gebelo
Created April 18, 2020 15:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gebelo/94dbc276882846175d74b0b1360d53d1 to your computer and use it in GitHub Desktop.
Save gebelo/94dbc276882846175d74b0b1360d53d1 to your computer and use it in GitHub Desktop.
These are industry and occupation codes used in a New York Times story about gender dynamics of the coronavirus pandemic "essential" workforce, https://www.nytimes.com/2020/04/18/us/coronavirus-women-essential-workers.html
"isHealth=ifelse((IND>=7970 & IND<=8290) | (OCC>=3000 & OCC<=3550),1,0),
isHealth=ifelse(OCC==3250 |OCC==3424, 0, isHealth)," "Offices of physicians
Offices of dentists
Offices of chiropractors
Offices of optometrists
Offices of other health practitioners
Outpatient care centers
Home health care services
Other health care services
General medical and surgical hospitals, and specialty (except psychiatric and substance abuse) hospitals
Psychiatric and substance abuse hospitals
Nursing care facilities (skilled nursing facilities)
Residential care facilities, except skilled nursing facilities
ALL OTHERS WITH HEALTH OCCUPATIONS minus Veterinary occupations"
isSocial=ifelse((IND==8370 | IND==8380) | (OCC>=2011 & OCC<=2014),1,0) "Individual and family services
Community food and housing, and emergency services 2011 Child, family, and school social workers
2012 Healthcare social workers
2013 Mental health and substance abuse social workers
2014 Social workers, all other"
isLe=ifelse(OCC>=3700 & OCC<=3870,1,0), "3700 First-line supervisors of correctional officers
3710 First-line supervisors of police and detectives
3720 First-line supervisors of firefighting and prevention workers
3725 Miscellaneous first-line supervisors, protective service workers
3740 Firefighters
3750 Fire inspectors
3801 Bailiffs
3802 Correctional officers and jailers
3820 Detectives and criminal investigators
3840 Fish and game wardens and parking enforcement officers
3870 Police officers"
isFoodMan=ifelse((IND>= 1070 & IND<=1370) | (OCC>=7800 & OCC<=7810) | (OCC>=7840 & OCC<=7855)),1,0), "Manufacturing:
Animal food, grain and oilseed milling
Sugar and confectionery products
Fruit and vegetable preserving and specialty food manufacturing
Dairy product manufacturing
Animal slaughtering and processing
Retail bakeries
Bakeries and tortilla manufacturing, except retail bakeries
Seafood and other miscellaneous foods, n.e.c.
Not specified food industries7800 Bakers
7810 Butchers and other meat, poultry, and fish processing workers7840 Food batchmakers
7850 Food cooking machine operators and tenders
7855 Food processing workers, all other
Beverage manufacturing"
isCritRetail=ifelse((IND>=4971 & IND<=5080) |IND %in% c(5391,5480,5680),1,0), "Supermarkets and other grocery (except convenience) stores
Convenience Stores
Specialty food stores
Beer, wine, and liquor stores
Pharmacies and drug stores
Health and personal care, except drug, stores"
isAg=ifelse((IND>=170 & IND<=290)|(OCC>=6005 & OCC<=6130)|OCC==205,1,0), "Crop production
Animal production and aquaculture
Forestry except logging
Logging
Fishing, hunting and trapping
Support activities for agriculture and forestry 6005 First-line supervisors of farming, fishing, and forestry workers
6010 Agricultural inspectors
6040 Graders and sorters, agricultural products
6050 Other agricultural workers
6115 Fishing and hunting workers
6120 Forest and conservation workers
6130 Logging workers"
isNatResource=ifelse((IND>=370 & IND<=380) |(OCC>=6800 & OCC<=6950),1,0), "Oil and gas extraction
Coal mining 6800 Derrick, rotary drill, and service unit operators, and roustabouts, oil, gas, and mining
6825 Surface mining machine operators and earth drillers
6835 Explosives workers, ordnance handling experts, and blasters
6850 Underground mining machine operators
6950 Other extraction workers"
isUtility=ifelse(((IND>=570 & IND<=690)|IND==6680 | (OCC>=7410 & OCC<=7420) | (OCC>=8600 & OCC<=8630),1,0), "Electric power generation, transmission and distribution
Natural gas distribution
Electric and gas, and other combinations
Water, steam, air-conditioning, and irrigation systems
Sewage treatment facilities
Not specified utilities
Wired telecommunications carriers 7410 Electrical power-line installers and repairers
7420 Telecommunications line installers and repairers8600 Power plant operators, distributors, and dispatchers
8610 Stationary engineers and boiler operators
8620 Water and wastewater treatment plant and system operators
8630 Miscellaneous plant and system operators"
isTransit=ifelse((IND>=6070&IND<=6270) | OCC==9130 | OCC=6730 | OCC=6740,1,0) "Air transportation
Rail transportation
Water transportation
Truck transportation
Bus service and urban transit
Taxi and limousine service
Pipeline transportation 9130 Driver/sales workers and truck drivers6730 Highway maintenance workers
6740 Rail-track laying and maintenance equipment operators"
isPostal=ifelse(IND==6370 | IND==5593 | IND==6380 | IND==6390 | (OCC>=5540 & OCC<=5560) | (OCC>=5500 & OCC<=5510), 1,0), "Postal Service
Electronic shopping and mail-order houses
Couriers and messengers adding Warehousing and storage 6390 5540 Postal service clerks
5550 Postal service mail carriers
5560 Postal service mail sorters, processors, and processing machine operators5500 Cargo and freight agents
5510 Couriers and messengers"
isMedManu=ifelse(IND==2190,1,0), Pharmaceutical and medicine manufacturing
isHazMat=ifelse(OCC==6720,1,0), 6720 Hazardous materials removal workers
isFinIT=ifelse(
(IND>=6870&IND<=6990) & "Industries: Banking and related activities
Savings institutions, including credit unions
Nondepository credit and related activities
Securities, commodities, funds, trusts, and other financial investments"
(OCC==110 | (OCC>=1005 & OCC<=1108)),1,0 ), "Occupations: 0110 /n Computer and information systems managers 1005 Computer and information research scientists
1006 Computer systems analysts
1007 Information security analysts
1010 Computer programmers
1021 Software developers
1022 Software quality assurance analysts and testers
1031 Web developers
1032 Web and digital interface designers
1050 Computer support specialists
1065 Database administrators and architects
1105 Network and computer systems administrators
1106 Computer network architects
1108 Computer occupations, all other"
isDefense=ifelse(IND>=9670&IND<=9870,1,0), "U. S. Army
U. S. Air Force
U. S. Navy
U. S. Marines
U. S. Coast Guard
Armed Forces, Branch not specified
Military Reserves or National Guard"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment