asiripanich/australias-essential-workers

Australia’s Essential Workers

The goal of this repository is to identify essential workers by their ANZSIC and ANZSCO codes. Pull requests are welcome. Note that, this is by no means perfect.

Data sources

The original data sources of the spreadsheets in ‘data’ folder are as stated below.

• ANZSIC: https://www.fwc.gov.au/awards-and-agreements/minimum-wages-conditions/annual-wage-reviews/previous-wage-reviews/annual-wa-0
• ANZSCO: https://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/1220.02013,%20Version%201.3?OpenDocument

References

Sources of information I used to identify essential workers.

• https://www.theaustralian.com.au/world/coronavirus-the-essential-workers-wholl-keep-australia-ticking-along/news-story/cb7992b6ae722afd0838f17e61338e01
• https://www.betterteam.com/what-is-an-essential-worker-in-australia
• https://en.wikipedia.org/wiki/Essential_services
• https://manofmany.com/lifestyle/advice/what-are-non-essential-services-australia
• https://coronavirus.nt.gov.au/__data/assets/pdf_file/0006/809853/approved-remote-essential-worker-application.pdf

Process tables

ANZSIC

Merge ANZSIC tables together. data/processed-data/cleaned_anzsic_2006.csv

ANZSIC 2006 table

anzsic_division	anzsic_code	anzsic_class_title	anzsic_division_title
A	A0111	Nursery Production (Under Cover)	Agriculture, Forestry and Fishing
A	A0112	Nursery Production (Outdoors)	Agriculture, Forestry and Fishing
A	A0113	Turf Growing	Agriculture, Forestry and Fishing
A	A0114	Floriculture Production (Under Cover)	Agriculture, Forestry and Fishing
A	A0115	Floriculture Production (Outdoors)	Agriculture, Forestry and Fishing
A	A0121	Mushroom Growing	Agriculture, Forestry and Fishing
A	A0122	Vegetable Growing (Under Cover)	Agriculture, Forestry and Fishing
A	A0123	Vegetable Growing (Outdoors)	Agriculture, Forestry and Fishing
A	A0131	Grape Growing	Agriculture, Forestry and Fishing
A	A0132	Kiwifruit Growing	Agriculture, Forestry and Fishing

ANZSOC

Merge ANZSOC tables together. See in data/processed-data/cleaned_anzsoc_2013.csv

ANZSOC 2013 table

major_code	major_group	submajor_code	submajor_group	minor_code	minor_group	unit_code	unit_group	occupation_code	occupation_group	skill_level
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1111	Chief Executives and Managing Directors	111111	Chief Executive or Managing Director	1
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1112	General Managers	111211	Corporate General Manager	1
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1112	General Managers	111212	Defence Force Senior Officer	1
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1113	Legislators	111311	Local Government Legislator	1
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1113	Legislators	111312	Member of Parliament	1
1	MANAGERS	11	Chief Executives, General Managers and Legislators	111	Chief Executives, General Managers and Legislators	1113	Legislators	111399	Legislators nec	1
1	MANAGERS	12	Farmers and Farm Managers	121	Farmers and Farm Managers	1211	Aquaculture Farmers	121111	Aquaculture Farmer	1
1	MANAGERS	12	Farmers and Farm Managers	121	Farmers and Farm Managers	1212	Crop Farmers	121211	Cotton Grower	1
1	MANAGERS	12	Farmers and Farm Managers	121	Farmers and Farm Managers	1212	Crop Farmers	121212	Flower Grower	1
1	MANAGERS	12	Farmers and Farm Managers	121	Farmers and Farm Managers	1212	Crop Farmers	121213	Fruit or Nut Grower	1

Identify essential workers