Detailed results of the second round of the 2017 presidential electionRésultats du second tour de l'élection présidentielle 2017 - version détaillée

Résultats du second tour de l'élection présidentielle 2017 - version détailléeDetailed results of the second round of the 2017 presidential election

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset provides detailed results of the second round of the 2017 French presidential election in Strasbourg, published via the city's open-data portal. Data come directly from polling-station counts and are fully reliable. Each row corresponds to one candidate's result in a single polling station. The dataset also includes the geographic mapping of voting sectors, allowing results to be linked to specific areas of the city for mapping or statistical analysis.Résultat à l'élection présidentielle de 2017 à Strasbourg. Les données sont issues des décomptes des bureaux de vote et fiables à 100%. Une ligne du tableau correspond au résultat d'un candidat sur un bureau de vote. Le jeu de données intégre la cartographie des secteurs de vote.

government

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (46 fields)

Filterable via the API (44)

cod_bureaucod_cantoncod_circonscod_communecod_lib_bureaucod_lieucod_particod_postalcod_scrutinlib_adr1lib_bureaulib_liste_afficheelibelle_secteurmillesimenb_blancnb_bureaux_depouilles_cantonnb_bureaux_depouilles_tournb_emargenb_enveloppenb_inscritnb_nulnb_procuratnb_sans_enveloppenb_suffrage_exprimenb_voixnb_votantnomnum_listenum_ordrenum_tourtotal_nb_blancs_cantontotal_nb_blancs_tourtotal_nb_inscrits_cantontotal_nb_inscrits_tourtotal_nb_nuls_cantontotal_nb_nuls_tourtotal_nb_suffrages_exprimes_cantontotal_nb_suffrages_exprimes_tourtotal_nb_votants_cantontotal_nb_votants_tourtraitement_datetraitement_heurenb_bureauxnb_bureaux_canton

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude/longitude) of the polling station.Geographic coordinates (latitude/longitude) of the polling station.
—	geo_shapeShape	geo_shape	Geometric shape outlining the voting sector's boundary.Geometric shape outlining the voting sector's boundary.
—	cod_bureauCod bureau	text	Code identifying the polling station.Code identifying the polling station.
—	cod_cantonCod canton	text	Code identifying the canton.Code identifying the canton.
—	cod_circonsCod circons	text	Code identifying the electoral constituency.Code identifying the electoral constituency.
—	cod_communeCod commune	text	Code identifying the municipality.Code identifying the municipality.
—	cod_lib_bureauCod lib bureau	text	Combined code and name of the polling station.Combined code and name of the polling station.
—	cod_lieuCod lieu	text	Code identifying the voting location.Code identifying the voting location.
—	cod_partiCod parti	text	Code identifying the candidate's political party.Code identifying the candidate's political party.
—	cod_postalCod postal	text	Postal code of the polling station.Postal code of the polling station.
100%	cod_scrutinCod scrutin	text	Code identifying the election/vote type.Code identifying the election/vote type.
100%	lib_adr1Lib adr1	text	Street address of the polling station.Street address of the polling station.
100%	lib_bureauLib bureau	text	Name of the polling station.Name of the polling station.
100%	lib_liste_afficheeLib liste affichee	text	Displayed name of the candidate and their party/list.Displayed name of the candidate and their party/list.
100%	libelle_secteurLibelle secteur	text	Label of the voting sector.Label of the voting sector.
100%	millesime	text	Year of the election.Year of the election.
100%	nb_blancNb blanc	int	Number of blank ballots at the polling station.Number of blank ballots at the polling station.
100%	nb_bureaux_depouilles_cantonNb bureaux depouilles canton	text	Number of polling stations counted within the canton.Number of polling stations counted within the canton.
100%	nb_bureaux_depouilles_tourNb bureaux depouilles tour	text	Number of polling stations counted for the round.Number of polling stations counted for the round.
100%	nb_emargeNb emarge	int	Number of voters who signed the register.Number of voters who signed the register.
0%	nb_enveloppeNb enveloppe	text	Number of ballot envelopes cast.Number of ballot envelopes cast.
100%	nb_inscritNb inscrit	int	Number of registered voters at the polling station.Number of registered voters at the polling station.
100%	nb_nulNb nul	int	Number of invalid (null) ballots at the polling station.Number of invalid (null) ballots at the polling station.
0%	nb_procuratNb procurat	int	Number of votes cast by proxy.Number of votes cast by proxy.
0%	nb_sans_enveloppeNb sans enveloppe	text	Number of ballots cast without an envelope.Number of ballots cast without an envelope.
100%	nb_suffrage_exprimeNb suffrage exprime	int	Number of valid votes cast at the polling station.Number of valid votes cast at the polling station.
100%	nb_voixNb voix	int	Number of votes received by the candidate.Number of votes received by the candidate.
100%	nb_votantNb votant	int	Number of voters who cast a ballot.Number of voters who cast a ballot.
99.3%	nom	text	Name of the polling location.Name of the polling location.
100%	num_listeNum liste	text	Number identifying the candidate's list.Number identifying the candidate's list.
100%	num_ordreNum ordre	int	Order number of the candidate on the ballot.Order number of the candidate on the ballot.
100%	num_tourNum tour	text	Number of the election round.Number of the election round.
100%	total_nb_blancs_cantonTotal nb blancs canton	text	Total number of blank ballots across the canton.Total number of blank ballots across the canton.
100%	total_nb_blancs_tourTotal nb blancs tour	text	Total number of blank ballots for the round.Total number of blank ballots for the round.
100%	total_nb_inscrits_cantonTotal nb inscrits canton	text	Total number of registered voters in the canton.Total number of registered voters in the canton.
100%	total_nb_inscrits_tourTotal nb inscrits tour	text	Total number of registered voters for the round.Total number of registered voters for the round.
100%	total_nb_nuls_cantonTotal nb nuls canton	text	Total number of invalid ballots in the canton.Total number of invalid ballots in the canton.
100%	total_nb_nuls_tourTotal nb nuls tour	text	Total number of invalid ballots for the round.Total number of invalid ballots for the round.
100%	total_nb_suffrages_exprimes_cantonTotal nb suffrages exprimes canton	text	Total number of valid votes cast in the canton.Total number of valid votes cast in the canton.
100%	total_nb_suffrages_exprimes_tourTotal nb suffrages exprimes tour	text	Total number of valid votes cast for the round.Total number of valid votes cast for the round.
100%	total_nb_votants_cantonTotal nb votants canton	text	Total number of voters who voted in the canton.Total number of voters who voted in the canton.
100%	total_nb_votants_tourTotal nb votants tour	text	Total number of voters who voted for the round.Total number of voters who voted for the round.
100%	traitement_dateTraitement date	text	Date the data was processed.Date the data was processed.
100%	traitement_heureTraitement heure	text	Time the data was processed.Time the data was processed.
100%	nb_bureauxNb bureaux	text	Total number of polling stations.Total number of polling stations.
100%	nb_bureaux_cantonNb bureaux canton	text	Number of polling stations in the canton.Number of polling stations in the canton.

Schema captured from opendatasoft 2 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1nom: Ecole maternelle du Schluthfeld · nb_nul: 18

{
  "nom": "Ecole maternelle du Schluthfeld",
  "nb_nul": 18,
  "nb_voix": 185,
  "cod_lieu": "001",
  "lib_adr1": "62 rue de Saint-Dié",
  "nb_blanc": 61,
  "num_tour": "2",
  "cod_parti": "FN",
  "geo_shape": "[large value omitted]",
  "millesime": "2017",
  "nb_emarge": 1005,
  "nb_votant": 1005,
  "num_liste": "01",
  "num_ordre": 1,
  "cod_bureau": "115",
  "cod_canton": "1",
  "cod_postal": "67100",
  "lib_bureau": "Ecole maternelle du Schluthfeld",
  "nb_bureaux": "143",
  "nb_inscrit": 1298,
  "cod_circons": "02",
  "cod_commune": "67482",
  "cod_scrutin": "P0417",
  "nb_procurat": null,
  "geo_point_2d": {
    "lat": 48.57070335278212,
    "lon": 7.746074064760013
  },
  "nb_enveloppe": null,
  "cod_lib_bureau": "115-Ecole maternelle du Schluthfeld",
  "libelle_secteur": "115 - Ecole maternelle du Schluthfeld",
  "traitement_date": "24 avril 2022",
  "traitement_heure": "08:21",
  "nb_bureaux_canton": "26",
  "nb_sans_enveloppe": null,
  "lib_liste_affichee": "LE PEN Marine  (Front National)",
  "total_nb_nuls_tour": "1972",
  "nb_suffrage_exprime": 926,
  "total_nb_blancs_tour": "6207",
  "total_nb_nuls_canton": "337",
  "total_nb_votants_tour": "101406",
  "total_nb_blancs_canton": "1226",
  "total_nb_inscrits_tour": "136820",
  "total_nb_votants_canton": "19014",
  "total_nb_inscrits_canton": "24536",
  "nb_bureaux_depouilles_tour": "143",
  "nb_bureaux_depouilles_canton": "26",
  "total_nb_suffrages_exprimes_tour": "93227",
  "total_nb_suffrages_exprimes_canton": "17451"
}

Record 2nom: Hôtel de Ville · nb_nul: 11

{
  "nom": "Hôtel de Ville",
  "nb_nul": 11,
  "nb_voix": 58,
  "cod_lieu": "001",
  "lib_adr1": "9 rue Brûlée",
  "nb_blanc": 41,
  "num_tour": "2",
  "cod_parti": "FN",
  "geo_shape": "[large value omitted]",
  "millesime": "2017",
  "nb_emarge": 669,
  "nb_votant": 669,
  "num_liste": "01",
  "num_ordre": 1,
  "cod_bureau": "103",
  "cod_canton": "1",
  "cod_postal": "67000",
  "lib_bureau": "Hôtel de Ville",
  "nb_bureaux": "143",
  "nb_inscrit": 819,
  "cod_circons": "01",
  "cod_commune": "67482",
  "cod_scrutin": "P0417",
  "nb_procurat": null,
  "geo_point_2d": {
    "lat": 48.58192974609512,
    "lon": 7.75008505773221
  },
  "nb_enveloppe": null,
  "cod_lib_bureau": "103-Hôtel de Ville",
  "libelle_secteur": "103 - Hôtel de Ville",
  "traitement_date": "24 avril 2022",
  "traitement_heure": "08:21",
  "nb_bureaux_canton": "26",
  "nb_sans_enveloppe": null,
  "lib_liste_affichee": "LE PEN Marine  (Front National)",
  "total_nb_nuls_tour": "1972",
  "nb_suffrage_exprime": 617,
  "total_nb_blancs_tour": "6207",
  "total_nb_nuls_canton": "337",
  "total_nb_votants_tour": "101406",
  "total_nb_blancs_canton": "1226",
  "total_nb_inscrits_tour": "136820",
  "total_nb_votants_canton": "19014",
  "total_nb_inscrits_canton": "24536",
  "nb_bureaux_depouilles_tour": "143",
  "nb_bureaux_depouilles_canton": "26",
  "total_nb_suffrages_exprimes_tour": "93227",
  "total_nb_suffrages_exprimes_canton": "17451"
}

Record 3nom: Ecole maternelle Oberlin · nb_nul: 16

{
  "nom": "Ecole maternelle Oberlin",
  "nb_nul": 16,
  "nb_voix": 533,
  "cod_lieu": "005",
  "lib_adr1": "5 rue du Jura",
  "nb_blanc": 47,
  "num_tour": "2",
  "cod_parti": "EM",
  "geo_shape": "[large value omitted]",
  "millesime": "2017",
  "nb_emarge": 744,
  "nb_votant": 744,
  "num_liste": "02",
  "num_ordre": 2,
  "cod_bureau": "515",
  "cod_canton": "5",
  "cod_postal": "67000",
  "lib_bureau": "Ecole maternelle Oberlin",
  "nb_bureaux": "143",
  "nb_inscrit": 1051,
  "cod_circons": "02",
  "cod_commune": "67482",
  "cod_scrutin": "P0417",
  "nb_procurat": null,
  "geo_point_2d": {
    "lat": 48.576696066611525,
    "lon": 7.7603990959812235
  },
  "nb_enveloppe": null,
  "cod_lib_bureau": "515-Ecole maternelle Oberlin",
  "libelle_secteur": "515 - Ecole maternelle Oberlin",
  "traitement_date": "24 avril 2022",
  "traitement_heure": "08:21",
  "nb_bureaux_canton": "23",
  "nb_sans_enveloppe": null,
  "lib_liste_affichee": "MACRON Emmanuel  (En Marche !)",
  "total_nb_nuls_tour": "1972",
  "nb_suffrage_exprime": 681,
  "total_nb_blancs_tour": "6207",
  "total_nb_nuls_canton": "252",
  "total_nb_votants_tour": "101406",
  "total_nb_blancs_canton": "954",
  "total_nb_inscrits_tour": "136820",
  "total_nb_votants_canton": "15415",
  "total_nb_inscrits_canton": "19684",
  "nb_bureaux_depouilles_tour": "143",
  "nb_bureaux_depouilles_canton": "23",
  "total_nb_suffrages_exprimes_tour": "93227",
  "total_nb_suffrages_exprimes_canton": "14209"
}

Record 4nom: Ecole élémentaire Gustave Doré · nb_nul: 13

{
  "nom": "Ecole élémentaire Gustave Doré",
  "nb_nul": 13,
  "nb_voix": 127,
  "cod_lieu": "003",
  "lib_adr1": "175 route de Mittelhausbergen",
  "nb_blanc": 55,
  "num_tour": "2",
  "cod_parti": "FN",
  "geo_shape": "[large value omitted]",
  "millesime": "2017",
  "nb_emarge": 646,
  "nb_votant": 646,
  "num_liste": "01",
  "num_ordre": 1,
  "cod_bureau": "310",
  "cod_canton": "3",
  "cod_postal": "67200",
  "lib_bureau": "Ecole élémentaire Gustave Doré",
  "nb_bureaux": "143",
  "nb_inscrit": 870,
  "cod_circons": "03",
  "cod_commune": "67482",
  "cod_scrutin": "P0417",
  "nb_procurat": null,
  "geo_point_2d": {
    "lat": 48.599091239445144,
    "lon": 7.707331768977074
  },
  "nb_enveloppe": null,
  "cod_lib_bureau": "310-Ecole élémentaire Gustave Doré",
  "libelle_secteur": "310 - Ecole élémentaire Gustave Doré",
  "traitement_date": "24 avril 2022",
  "traitement_heure": "08:21",
  "nb_bureaux_canton": "23",
  "nb_sans_enveloppe": null,
  "lib_liste_affichee": "LE PEN Marine  (Front National)",
  "total_nb_nuls_tour": "1972",
  "nb_suffrage_exprime": 578,
  "total_nb_blancs_tour": "6207",
  "total_nb_nuls_canton": "337",
  "total_nb_votants_tour": "101406",
  "total_nb_blancs_canton": "820",
  "total_nb_inscrits_tour": "136820",
  "total_nb_votants_canton": "14548",
  "total_nb_inscrits_canton": "21400",
  "nb_bureaux_depouilles_tour": "143",
  "nb_bureaux_depouilles_canton": "23",
  "total_nb_suffrages_exprimes_tour": "93227",
  "total_nb_suffrages_exprimes_canton": "13391"
}

Record 5nom: Ecole élémentaire Jacqueline · nb_nul: 2

{
  "nom": "Ecole élémentaire Jacqueline",
  "nb_nul": 2,
  "nb_voix": 135,
  "cod_lieu": "003",
  "lib_adr1": "3 allée Jack London",
  "nb_blanc": 44,
  "num_tour": "2",
  "cod_parti": "FN",
  "geo_shape": "[large value omitted]",
  "millesime": "2017",
  "nb_emarge": 649,
  "nb_votant": 649,
  "num_liste": "01",
  "num_ordre": 1,
  "cod_bureau": "315",
  "cod_canton": "3",
  "cod_postal": "67200",
  "lib_bureau": "Ecole élémentaire Jacqueline",
  "nb_bureaux": "143",
  "nb_inscrit": 1007,
  "cod_circons": "01",
  "cod_commune": "67482",
  "cod_scrutin": "P0417",
  "nb_procurat": null,
  "geo_point_2d": {
    "lat": 48.595168799553,
    "lon": 7.692965872658742
  },
  "nb_enveloppe": null,
  "cod_lib_bureau": "315-Ecole élémentaire Jacqueline",
  "libelle_secteur": "315 - Ecole élémentaire Jacqueline",
  "traitement_date": "24 avril 2022",
  "traitement_heure": "08:21",
  "nb_bureaux_canton": "23",
  "nb_sans_enveloppe": null,
  "lib_liste_affichee": "LE PEN Marine  (Front National)",
  "total_nb_nuls_tour": "1972",
  "nb_suffrage_exprime": 603,
  "total_nb_blancs_tour": "6207",
  "total_nb_nuls_canton": "337",
  "total_nb_votants_tour": "101406",
  "total_nb_blancs_canton": "820",
  "total_nb_inscrits_tour": "136820",
  "total_nb_votants_canton": "14548",
  "total_nb_inscrits_canton": "21400",
  "nb_bureaux_depouilles_tour": "143",
  "nb_bureaux_depouilles_canton": "23",
  "total_nb_suffrages_exprimes_tour": "93227",
  "total_nb_suffrages_exprimes_canton": "13391"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/resultats-du-second-tour-de-l-election-presidentielle-2017-version-detaillee

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/resultats-du-second-tour-de-l-election-presidentielle-2017-version-detaillee/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

2 000 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

286

Last upstream update

5 years ago

2022-04-24

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.