Skip to content

Instantly share code, notes, and snippets.

@jbothma

jbothma/Employment Status by Age.md

Created March 8, 2018 10:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jbothma/b6aec0490dc57ff5ef99cbff4ed65def to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jbothma/b6aec0490dc57ff5ef99cbff4ed65def to your computer and use it in GitHub Desktop.
Download ZIP
How to get South African Census Data in Excel or CSV
Raw
Employment Status by Age.md

Find SuperWEB 2 http://interactive2.statssa.gov.za/webapi/jsf/login.xhtml via StatsSA Interactive Data http://www.statssa.gov.za/?page_id=1417

Use the Guest login

Find Census 2011 (2016 boundaries) via Community Profiles > Census 2011 (2016 boundaries)

Expand Labour Force and select the Labour Force database item.

Click on New Table

Then you can select the categories to add - either one by one under each category name, or add all using the arrow next to each category name and choosing Row or Column and so on to decide how it should structure the aggregation. For example, put Age in completed years as rows and Employment Status as columns.

It will show a small sample preview when you click Retrieve Data, then you can export everything to view in Excel using Download Table on the top right.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment