France’s election results for 2012 are in – and amazingly quickly, compared to London’s much-smaller mayoral vote last week. So, how did France vote in round two of the presidential election?
The results show, writes Angelique Chrisafis
François Hollande has won the presidency of France, turning the tide on a rightward and xenophobic lurch in European politics and vowing to transform Europe‘s handling of the economic crisis by fighting back against German-led austerity measures.
We collected the results from the French Ministry of the Interior here, but there was also some brilliant work going on from groups like Regards Citoyens, which was running an open data hack on the election.
They also produced this graphic, which showed the votes coming in over the day.
Image of votes by commune from Regards Citoyens
The turnout was startlingly high, especially compared to the low numbers seen in the UK local elections last week. The median turnout was 82.3%,, and that umber would be higher, but for the lower figures in France’s overseas territories. Saint-Martin/Saint-Barthelemy, for instance, saw the lowest figure of any departments – only 43.68%. By contrast, the highest figure was in the Lot, where it was 86.62%.
France interactive results map. Click image to explore it
The highest votes for Hollande, besides the overseas territories, were in regions like Correze, Ariege and Haute Vienne, in the south west of France – and Paris, of course, which has been overwhelmingly Hollande in both rounds.
Sarkozy’s strongholds, were instead in the south and east of the country, places along the Rhine and on the Alps – there he consistently won over 60% of the vote.
Of the 43 départements where over 20% had voted for Marine Le Pen in round one, 26, perhaps unsurprisingly, went for Sarkozy. But the other 17 voted for Hollande and his ‘change’ theme. In Gard, which was the only place to give Marine Le Pen a majority in round one, Sarkozy won the popular vote this time, but it was tight: 51.2% to 48.8%.
We also looked at swing to each candidate, comparing their vote to the poll in round one. Obviously, with only two candidates in this round, the numbers are all big – but we thought it might be interesting to see where the biggest swings happened. Sarkozy’s biggest change was in Vaucluse, where his vote increased by 96.6%. However, Hollande saw his vote increase by over 90% in eight départements.
The full data is below. What can you do with it?
Data summary
France election results by departement, second round
Click heading to sort table. Download this data
SOURCE: Ministry of the Interior
France total
81
51.7
48.3
Hollande
Ain
82.92
42.78
79.7
57.22
79.8
Sarkozy
Aisne
80.32
52.4
82.4
47.60
85.6
Hollande
Allier
82.37
56.89
82.6
43.11
71.0
Hollande
Alpes De Haute Provence
83.6
51.06
101.6
48.94
84.8
Hollande
Hautes Alpes
83.65
50.91
100.6
49.09
81.4
Hollande
Alpes Maritimes
80.33
35.77
81.9
64.23
68.8
Sarkozy
Ardeche
83.83
53.45
94.7
46.55
85.4
Hollande
Ardennes
79.39
51.89
70.2
48.11
86.9
Hollande
Ariege
84.55
64.69
80.2
35.31
80.5
Hollande
Aube
81.13
42.63
76.8
57.37
78.8
Sarkozy
Aude
83.62
56.24
75.4
43.76
91.9
Hollande
Aveyron
85.79
54.42
78.2
45.58
72.2
Hollande
Bouche du Rhone
80.93
47.17
86.1
52.83
85.8
Sarkozy
Calvados
83.5
53.11
74.5
46.89
65.3
Hollande
Cantal
84.22
51.8
63.2
48.20
63.7
Hollande
Charente
82.31
58.83
71.9
41.17
71.1
Hollande
Charente Maritime
82.35
51.57
74.7
48.43
66.3
Hollande
Cher
80.18
54.04
91.0
45.96
74.2
Hollande
Correze
86.35
64.86
47.3
35.14
58.7
Hollande
Cote D’or
83.41
48.45
68.0
51.55
73.8
Sarkozy
Cotes D’Armor
86.13
59.19
73.6
40.81
65.7
Hollande
Creuse
83.39
61.02
73.5
38.98
69.6
Hollande
Dordogne
85.91
59.14
78.2
40.86
72.3
Hollande
Doubs
83.26
48.09
75.7
51.91
74.9
Sarkozy
Drome
82.97
49.18
86.9
50.82
85.2
Sarkozy
Eure
81.4
47.55
83.5
52.45
79.7
Sarkozy
Eure et Loire
81.28
46.53
73.6
53.47
74.5
Sarkozy
Finistere
84.51
58.87
69.2
41.13
62.9
Hollande
Gard
82.81
48.8
92.0
51.20
95.3
Sarkozy
Haute Garonne
82.84
58.78
70.8
41.22
72.1
Hollande
Gers
86.16
56.64
70.6
43.36
72.4
Hollande
Gironde
83.4
56.61
72.5
43.39
69.1
Hollande
Herault
82.34
51.31
84.2
48.69
84.3
Hollande
Ille et Villaine
84.14
55.71
68.4
44.29
63.5
Hollande
Indre
82.12
55.66
77.4
44.34
74.7
Hollande
Indre et Loire
82.92
51.23
75.4
48.77
66.2
Hollande
Isere
82.02
52.13
78.7
47.87
83.1
Hollande
Jura
83.36
49.42
90.8
50.58
85.9
Sarkozy
Landes
84.86
56.99
68.9
43.01
70.0
Hollande
Loir et Cher
82.66
47.58
80.7
52.42
75.7
Sarkozy
Loire
81.64
50.5
80.1
49.5
86.3
Hollande
Haute Loire
84.45
51.38
84.0
48.62
88.0
Hollande
Loire Atlantique
83.93
56.35
70.7
43.65
61.1
Hollande
Loiret
81.95
45.99
72.4
54.01
75.9
Sarkozy
Lot
86.62
61.89
72.7
38.11
71.2
Hollande
Lot et Garonne
84.18
51.35
82.9
48.65
84.2
Hollande
Lozere
86.01
49.95
90.7
50.05
73.1
Sarkozy
Maine et Loire
84.02
48.85
72.9
51.15
63.9
Sarkozy
Manche
83.27
49.9
77.6
50.10
67.3
Sarkozy
Marne
78.85
44.69
76.6
55.31
76.0
Sarkozy
Haute Marne
80.24
45.55
80.8
54.45
83.3
Sarkozy
Mayenne
84
46.93
73.8
53.07
65.6
Sarkozy
Meurthe et Moselle
79.72
53.06
80.6
46.94
84.2
Hollande
Meuse
81.57
46.2
85.7
53.80
90.5
Sarkozy
Morbihan
84.62
51.73
75.8
48.27
64.7
Hollande
Moselle
78.12
46.52
80.6
53.48
96.4
Sarkozy
Nievre
81.15
58.81
72.2
41.19
74.9
Hollande
Nord
77.89
52.87
80.6
47.13
82.3
Hollande
Oise
80.68
47.33
80.2
52.67
87.8
Sarkozy
Orne
83.3
47.11
83.9
52.89
69.0
Sarkozy
Pas de Calais
79.68
56.18
80.1
43.82
89.1
Hollande
Puy de Dome
83.76
60.46
73.9
39.54
75.9
Hollande
Pyrenees Atlantiques
83.67
57.12
85.5
42.88
76.2
Hollande
Hautes Pyrenees
83.53
62.42
80.8
37.58
76.9
Hollande
Pyrenees Orientales
82.2
50.59
86.1
49.41
86.4
Hollande
Bas Rhin
80.16
36.56
80.4
63.44
82.3
Sarkozy
Haut Rhin
80.07
36.67
86.4
63.33
90.6
Sarkozy
Rhone
81.19
47.99
72.0
52.01
63.0
Sarkozy
Haut Saone
83.52
49.64
77.6
50.36
88.4
Sarkozy
Saone et Loire
81.12
51.86
72.5
48.14
76.6
Hollande
Sarthe
81.64
52.67
77.7
47.33
70.0
Hollande
Savoie
82.41
47.07
89.1
52.93
75.8
Sarkozy
Haute Savoie
81.37
39.9
87.5
60.10
70.1
Sarkozy
Paris
83.03
55.6
62.2
44.4
40.1
Hollande
Seine Maritime
81.1
54.94
79.3
45.06
72.8
Hollande
Seine et Marne
80.64
49.25
76.7
50.75
84.6
Sarkozy
Yvelines
83.03
55.6
185.2
44.4
81.7
Hollande
Deux Sevres
84.19
57.31
66.1
42.69
65.2
Hollande
Somme
82.13
54.41
82.6
45.59
81.6
Hollande
Tarn
85.28
55.55
72.2
44.45
81.7
Hollande
Tarn Et Garonne
84.8
51.27
76.7
48.73
84.6
Hollande
Var
81.3
37.36
84.2
62.64
74.4
Sarkozy
Vaucluse
81.04
43.57
86.4
56.43
96.6
Sarkozy
Vendee
85.04
44.41
71.9
55.59
62.3
Sarkozy
Vienne
83.08
55.31
67.3
44.69
76.6
Hollande
Haute Vienne
84.58
63.99
69.7
36.01
73.1
Hollande
Vosges
81.97
49.06
86.5
50.94
88.7
Sarkozy
Yonne
80.88
46.88
85.6
53.12
82.7
Sarkozy
Territoire De Belfort
81.02
50.52
84.1
49.48
96.3
Hollande
Essonne
81.76
53.43
75.0
46.57
82.0
Hollande
Hauts De Seine
82.74
49.48
66.9
50.52
46.9
Sarkozy
Seine Saint-Denis
76.43
65.32
71.0
34.68
80.3
Hollande
Val De Marne
80.46
56.47
72.9
43.53
65.2
Hollande
Val D’oise
80.11
53.91
67.7
46.09
77.0
Hollande
Francais De L’etranger
Guadeloupe
62.19
71.93
49.6
28.07
42.2
Hollande
Martinique
59.77
68.43
50.6
31.57
37.4
Hollande
Guyane
57.21
62.05
62.3
37.95
55.6
Hollande
La Reunion
72.86
71.49
47.5
28.51
74.6
Hollande
Saint Pierre Et Miquelon
68.89
65.31
134.2
34.69
126.4
Hollande
Mayotte
52.17
49.06
44.1
50.94
12.1
Sarkozy
Wallis-Et-Futuna
76.47
56.06
22.7
43.94
23.2
Hollande
Polynesie Francaise
58.94
46.74
72.0
53.26
40.6
Sarkozy
Nouvelle Caledonie
61.2
36.96
62.9
63.04
39.4
Sarkozy
Corse Sud
75.73
42.4
86.2
57.60
77.1
Sarkozy
Haute Corse
76.84
45.59
75.0
54.41
74.8
Sarkozy
Saint-Martin/Saint-Barthelemy
43.68
40.57
79.0
59.43
61.0
Sarkozy
Download the data
• DATA: download the full spreadsheet
More data
More data journalism and data visualisations from the Guardian
World government data
• Search the world’s government data with our gateway
Development and aid data
• Search the world’s global development data with our gateway
Can you do something with this data?
• Flickr Please post your visualisations and mash-ups on our Flickr group
• Contact us at data@guardian.co.uk
• Get the A-Z of data
• More at the Datastore directory
• Follow us on Twitter
• Like us on Facebook