About

This visualization shows the voting behaviour of the EU28 Members States along the Councils' 21 Policy Areas visualized on a map of Europe. In this example the average of the votes is calculated and as follows a colour code (along the given legend) is assigned along the percentage of the voting behaviour of a country (Abstained - Not participating - Voted against - Voted in favour). Users can select the Policy Area they are interested in to compare the voting behaviour of EU28 countries.

Data

The data visualised in this graph gets fetched from a SPARQL-endpoint provided by the Council of the European Union, which can be found here: http://data.consilium.europa.eu/sparql.

This graph shows the number of posivite votes for each country eligible to vote for a selected policy area.

To calculate the percentage of positive votes, votes with vote-type "voted in favour" = http://data.consilium.europa.eu/data/public_voting/consilium/vote/votedinfavour were contrasted with votes of any other type, which include "voted against" = http://data.consilium.europa.eu/data/public_voting/consilium/vote/votedagainst, "abstained" = http://data.consilium.europa.eu/data/public_voting/consilium/vote/abstained and "not participating" = http://data.consilium.europa.eu/data/public_voting/consilium/vote/notparticipating.

Example query to get data for all policy areas:

PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dim: <http://data.consilium.europa.eu/data/public_voting/qb/dimensionproperty/>
SELECT ?policyarea ?country ?vote (COUNT(DISTINCT ?observation) AS ?votes)
WHERE {
  ?observation dim:policyarea/skos:prefLabel ?policyarea .
  ?observation dim:country ?country.
  ?observation <http://data.consilium.europa.eu/data/public_voting/qb/measureproperty/vote> ?vote
}
GROUP BY (str(?policyarea) AS ?policyarea) ?country ?vote
ORDER BY ?policyarea ?country ?vote

Resources

The basic code for the Choropleth map comes from „Mike Bostock“, 2012, „Choropleth“, accessed on [05/2015], https://gist.github.com/mbostock/4060606

The TopoJSON file of europe comes from „Mila Frerichs“, 2015, accessed on [05/2015], https://gist.github.com/milafrerichs/69035da4707ea51886eb