ANCIR/southafrica

Data warehouse for political data related to in South Africa # 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: ```sql SELECT mine_owner, COUNT(*) FROM sa_mines GROUP BY mine_owner ORDER BY COUNT(*) DESC LIMIT 20; ```