South Africa Political Data

This repository contains a wide selection of public data from the RSA, as well as the necessary scripts to load it to a database and to analyze it.

Data Sources

The data is partially extracted from public sources, and from semi-public data sources.

NPO Registry Scraper

This is a scraper for the South African government's database of non-political organisations (NPOs). The code is extracted from the Siyazana project because it may be useful on its own.

People's Assembly

Information about all members of the national parliament, their financial declarations and data about political parties and committees. Sourced from the Pombola data provided by PA.

Department of Mineral Resources

Information about all mines and their owners in RSA, which is part of the directories published by the department.

Exploring the data

Let's check out the people owning the largest number of mines in South Africa:

SELECT mine_owner, COUNT(*) FROM sa_mines GROUP BY mine_owner  ORDER BY COUNT(*) DESC LIMIT 20;