Info page FSO data set on opendata.swiss

Info page with updates on the Federal Statistical Office’s data set for the Federal Elections 2023


Productive data set:https://opendata.swiss/dataset/eidg-wahlen-2023

Testing data set: https://ogdch-abnahme.clients.liip.ch/de/dataset/eidg-wahlen-2023 (deactivated)



20240524: Minor corrections in the context of data archiving

Corrections have no influence on the final result.

  • Modification of candidate numbers for liste_nummer_bfs=12 (liste_nummer_kanton=12) in canton GR (Correction in data supplied by the canton)
  • Modification of the list positions of candidates in GR and AG


NEW:

Canton liste_nummer_bfs liste_bezeichnung kandidat_nummer name vorname kandidat_listenplatz_1 kandidat_listenplatz_2
18/GR 12 FDP-die Erste 1 Giacometti Anna 1 2
18/GR 12 FDP-die Erste 2 Rathgeb Christian Karl 3 (null)
18/GR 12 FDP-die Erste 3 Lebrument Susanne 4 (null)
18/GR 12 FDP-die Erste 4 Kuoni Christof 5 (null)
19/AG 50 MuPa – Musikpartei 1 Zurfluh Stephan 1 2


OLD:
Canton liste_nummer_bfs liste_bezeichnung kandidat_nummer name vorname kandidat_listenplatz_1 kandidat_listenplatz_2
18/GR 12 FDP-die Erste 1 Giacometti Anna 1 2
18/GR 12 FDP-die Erste 3 Rathgeb Christian Karl 4 (null)
18/GR 12 FDP-die Erste 4 Lebrument Susanne 5 (null)
18/GR 12 FDP-die Erste 5 Kuoni Christof 5 (null)
19/AG 50 MuPa – Musikpartei 1 Zurfluh Stephan 1 (null)


  • FSO municipality number of the place of residence added (best effort)
    JSON-file: sd-t-17.02-NRW2023-kandidierende.json
    Variable: “wohnort_gemeinde_nummer”

  • With the data upload of 30 November, the variables indicating the number of municipalities with a result were no longer filled correctly.
    JSON-files: multiple
    Variable: gemeinden_abgeschlossen



20231130: Upload of the final results

The final results have been uploaded. The published data includes the corrections provided by the cantons after election day.



20231031: New Data Resource sd-t-17.02-SRW2023-kandidierende_zweiter-wahlgang.json

New resource on 2nd rounds of elections to the Council of States. Results are updated only once, on Monday after the election round.



20231025: National Council elections: Error in published party strengths at national level

For further information, see press release. The following resources are affected by the correction:

  • sd-t-17.02-NRW2023-wahlbeteiligung.json
  • sd-t-17.02-NRW2023-wahlbeteiligung-appendix.csv
  • sd-t-17.02-NRW2023-parteien.json
  • sd-t-17.02-NRW2023-parteien-appendix.csv
  • sd-t-17.02-NRW2023-zeitreihen-parteien.json
  • sd-t-17.02-NRW2023-zeitreihen-parteien-appendix.csv

The corrections include the rectification of the aggregation error made by the FSO. The corrections received from the cantons are being collected and will be released in the course of the publication of the final results end of November.



20231019: Last minor changes (structure of the files is not affected)

  1. Files with municipality level: In the canton BE, the municipality “Rüti bei Lyssach” (BFS-Nr. 422) now has its own ballot box and is therefore included in the files.

  2. Based on the consultation with all the general secretariats of the parties regarding the attribution of the submitted electoral lists to national parties, the following change has been made:

Canton liste_nummer_bfs liste_nummer_kanton liste_bezeichnung Party old Party new
3 / LU 23 26 Aktive Senioren Luzern SVP Others



20230925: New Data Resource sd-t-17.02-SRW2023-kandidierende_erster-wahlgang.json

JSON file for the results of the Council of States added to the test environment. This file already includes the candidates for the first round of voting on October 22. Results for the Council of States are updated per completed canton.
Data description: https://bfspoku.github.io/wd-poku/codebook_elections2023.html#JSON_SR_-_Kandidierende_




20230925: New Data Ressource sd-t-17.02-NRW2023-listen-gde.json

Due to corresponding demand (and after extensive internal testing), we offer a new JSON with list results at municipality level. This JSON will be continuously updated on election Sunday.
There are some special aspects to be taken into account with this file. Please read the data description, which has been extended accordingly to include this file: https://bfspoku.github.io/wd-poku/codebook_elections2023.html#JSON_Listen_



20230925: Test day on 28 September 2023

Planned schedule for the test day on 28 September 2023

On 28 September 2023 from 10.00 - 12.00 test files will be continuously uploaded on the DEV environment (https://ogdch-abnahme.clients.liip.ch/de/dataset/eidg-wahlen-2023) Below is a brief overview of the schedule and test dates offered.
1. The test only includes the JSON files provided on election Sunday.
2. All files will already contain the official lists and candidates.(Exceptions are possible for cantons with a majoritarian electoral system without compulsory registration).
3. A first set of test data will already be uploaded to the DEV environment on 25 September. This should facilitate the preparation for the test day.
4. There will be intermediate results uploaded for several cantons, and for some there will also be a cantonal final result. The complete election results at the Swiss level will not be simulated. (Work on such a complete data set is underway, but it is still unclear whether this can be offered until election day. Corresponding information on further testing possibilities would be published here.)

Overview test data
(May be changed at short notice.)

National Council:

  • Intermediate results for the following cantons (FSO canton number): 1, 3, 9, 11, 13, 18, 20, 24, 26
  • Final results for the following cantons: 1, 9, 11, 12, 20, 26

Council of States:

  • Results for the first round in the following cantons: 1, 6, 16


20230925: Cantonal delivery intervals on election Sunday

(Indication of the cantons, without guarantee)
Nr. Kanton Lieferintervall Intervalle de transfert
1 Zürich Lieferintervall: alle ca. 15-20 Minuten Intervalle de transfert: toutes les 15-20 minutes
2 Bern Lieferintervall: stündlich Intervalle de transfert: toutes les heures
3 Luzern Lieferintervall: alle 20 Minuten Intervalle de transfert: toutes les 20 minutes
4 Uri Schlussresultat Résultat final uniquement
5 Schwyz Lieferintervall: mehrfach, manuell ausgelöst Intervalle de transfert: transfert multiple, manuellement
6 Obwalden Mehrfachlieferung: 1-2 Zwischenlieferungen, danach Schlussresultat Transfert multiple: 1-2 transferts intermédiaires, puis résultat final
7 Nidwalden Schlussresultat Résultat final uniquement
8 Glarus Schlussresultat Résultat final uniquement
9 Zug Mehrfachlieferung: vorgesehen 15.00, 16.00, 17.00 Uhr Transfert multiple: prévu pour 15.00, 16.00, 17.00 h
10 Fribourg Lieferintervall: ca. alle 30 Minuten Intervalle de transfert: toutes les 30 minutes environ
11 Solothurn Lieferintervall: alle 5 Minuten, sofern neue Gemeindeergebnisse vorhanden sind Intervalle de transfert: toutes les 5 minutes, si de nouveaux résultats communales sont disponibles
12 Basel-Stadt Schlussresultat Résultat final uniquement
13 Basel-Landschaft Lieferintervall: alle 15 Minuten Intervalle de transfert: toutes les 15 minutes
14 Schaffhausen Mehrfachlieferung: vorgesehen 15.00, 16.00, 17.00 Uhr Transfert multiple: prévu pour 15.00, 16.00, 17.00 h
15 Appenzell A.Rh. Schlussresultat Résultat final uniquement
16 Appenzell I.Rh. Schlussresultat Résultat final uniquement
17 St. Gallen Lieferintervall: ca. alle 30 Minuten Intervalle de transfert: toutes les 30 minutes environ
18 Graubünden Lieferintervall: ca. alle 30 Minuten (manuell ausgelöst) Intervalle de transfert: toutes les 30 minutes environ, manuellement
19 Aargau Mehrfachlieferung: erste Lieferung: ca. 12.30/13.00 Uhr. Danach folgen voraussichtlich zwei bis drei weitere Lieferungen in Abständen von plus/minus einer Stunde. Transfert multiple: première livraison à 12.30/13.00 h. Puis 2-3 livraisons prévus toutes les heures environ.
20 Thurgau Lieferintervall: alle 30 Minuten Intervalle de transfert: toutes les 30 minutes
21 Ticino Lieferintervall: alle 30 Minuten ab 12.30 h Intervalle de transfert: toutes les 30 minutes après 12.30 h
22 Vaud Lieferintervall: alle 5 Minuten, sofern neue Gemeindeergebnisse vorhanden sind Intervalle de transfert: toutes les 5 minutes, si de nouveaux résultats communales sont disponibles
23 Valais Lieferintervall: ca. stündlich Intervalle de transfert: toutes les heures environ
24 Neuchâtel Lieferintervall: ca. stündlich Intervalle de transfert: toutes les heures environ
25 Genève Schlussresultat Résultat final uniquement
26 Jura Lieferintervall: alle 15 Minuten Intervalle de transfert: toutes les 15 minutes