Skip to content
Michael Bauer edited this page Aug 21, 2014 · 5 revisions

This project used Data supplied by the Bosnian Electoral Commission.

Raw Data

The Raw Data folder contains most of the raw data either obtained from the Electoral Commissions (Results for local and general elections) or Open Street Map for mapping data.

Cleaned Data

Raw data was cleaned using OpenRefine.

Mapping municipalities to Election Units

The only consistent low-aggregation unit in elections are municipalities: So most data is based on Municipalities. We're re-using the electoral commissions IDs for municipalities and associating them to the electoral units used in different election races.

File: municipality-ids-election-units.csv

Columns:

name description data format
municipality_ID ID of the municipality 0 padded 3 digit number
municipality_name Name of the Municipality String
election_type Name of the election an Election Race
election_unit_id ID of the election unit the municipality is part of 0 padded 3 digit number

Mapping election units to seats

Further we've gathered the number of seats in the various parliaments by election unit

File: parliament-seats-by-election-units.csv

Columns:

name description type
election_unit_ID The ID of the election unit for the respective race 0 padded 3 digit number
seats Direct seats in the parliament voted for integer
race The short string for the race see Election Race

Results

Election Results are in the Results folder

Columns follow the following structure

name description type
election_unit_ID id of the election unit 0 padded 3 digit number
election_type the election type see Election Race
year the year of the election Data formatted 'YYYY'
polling_station_ID the id of the polling station A multi character identifier unique to polling stations
municipality_ID the id of the municipality 0 padded 3 digit number
party the name of the party String (optional)
votes votes received by the party / the candidate Integer
candidate the name of the candidate String (optional)

Shape files for Municipalities

We unified data from Open Street Map into a shapefile of municipalities and added two municipalities missing on OSM.

Reuse

You are welcome to re-use the data and build your own projects and analysis.

Clone this wiki locally