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.


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)
  ?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


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