Wikidata:Dataset Imports/Swissvotes

From Wikidata
Jump to navigation Jump to search

You may find these related resources helpful:


Guidelines for using this page[edit]

Documenting the import[edit]

  • Guidelines on how to import a dataset into Wikidata are available at Wikidata:Data Import Guide.
  • Please include notes on all steps of the process.
  • Once a dataset has been imported into Wikidata please edit the page to change the progress status from in progress to complete.
  • It is strongly recommended to use Visual Editor when making changes to this page, particularly for editing any of the tables.

Creating a Wikidata item for the dataset[edit]

  • Please create a Wikidata item for the dataset, this will allow us to improve the coverage of datasets on Wikidata and understand what datasets are available on that topic and which of them have been added to Wikidata. DONE -> Q110919097
  • If you are working with very large dataset you can break it into smaller Mix n' Match catalogues, but only create one Wikidata item.
  • Link the dataset Wikidata item to this page using Wikidata Dataset Imports URL (P5195) DONE

Getting help[edit]

  • If your dataset import runs into issues please edit the page to change the progress status from in progress to help needed.
  • You can ask for help on Wikidata:Project chat.

Overview[edit]

Dataset name[edit]

Swissvotes

Source[edit]

Année Politique Suisse at the Institute of Political Science of the University of Bern

Link[edit]

https://swissvotes.ch/page/home

Dataset description[edit]

Swissvotes is the most encompassing database on Swiss popular votes that contain a wide range of in-depth information about all popular votes held on Switzerland’s federal level since 1848.

Additional information[edit]

Progress of import[edit]

The table below is used to track the progress of importing this dataset. The suggested column headings are most applicable to data being imported from a spreadsheet - you can change some column headings or add new columns as required to best describe the progress of this import.

Wikidata item for the datasetImport data into spreadsheetFormat the spreadsheet to import the dataStructure of data within WikidataMatch the dataset to WikidataImporting data into WikidataVisualisationsMaintainance queries and expected results
Q110919097Their is already a spreadsheet available on the data source page: https://swissvotes.ch/page/dataset/swissvotes_dataset.xlsx

and CSV: https://swissvotes.ch/page/dataset/swissvotes_dataset.csv

Not done yetNot done yet Not done yetNot done yetNot done yetNot done yet

Edit history[edit]

Use the table below to list batches of edits that have been completed for this dataset. Ideally each entry should have all applicable columns filled out, but at a minimum please make to add a date and description to give an idea of what was added to Wikidata and when.

DateDescriptionMethodPropertiesQualifiersReferencesStatements addedStatements removedLink to import sheet
Date 1Description 1Method 1Properties 1Qualifiers 1References 1Added Count 1Removed Count 1Link 1
Date 2Description 2Method 2Properties 2Qualifiers 2References 2Added Count 2Removed Count 2Link 2
Date 3Description 3Method 3Properties 3Qualifiers 3References 3Added Count 3Removed Count 3Link 3

Discussion of import[edit]

These headings are generally useful, please change this section to suit your needs.

Wikidata item for dataset[edit]

YesY Swissvotes (Q105604990)

Import data into spreadsheet[edit]

✓ Done Downloadable at [1]

Format the spreadsheet to import the data[edit]

Before we can format the spreadsheet I think we need to decide what data we are hoping to import from that spreadsheet into Wikidata, e.g. dates, numbers, URLs, etc. To help me understand, could you translate what each column in the spreadsheet means? — Martin (MSGJ · talk) 20:45, 15 February 2022 (UTC)[reply]

sorry, didn't see the reply button. Answer below. Gagarine (talk) 19:09, 2 March 2022 (UTC)[reply]

Sure @MSGJ, I can do that for next week. I will create a table below with the description of the original spreadsheet's column in English Gagarine (talk) 19:08, 2 March 2022 (UTC)[reply]

Swiss Vote CodeBook (translation)

This is based on the official codebook (German).

Short Label Excel Column ID (Deutsh) Column ID translated Description and Codes (Translated in English) !!! IN PROGRES!!! Source (needed?)
Reconciliation Number anr - Number (ID) of the vote according to the Federal Statistical Office Federal Statistical Office
Voting Date datum date Date of the voting day Swiss Federal Chancellery (online).
Short Title German titel_kurz_d title_short_d Short version of the official title of the proposal (German)
Short Title French titel_kurz_f title_short_f Short version of the official title of the proposal (French)
Official Title German titel_off_d title_off_d Official title of the proposal (German)
Official Title French titel_off_f title_off_f Official title of the proposal (French)
Common name stichwort keyword Colloquial common name of the proposal or additional content description
- swissvoteslink swissvoteslink Direct link to the detailed view of the proposal on Swissvotes
- anzahl number Number of federal bills on the same date

(Initiatives with counterproposal and run-off question are counted together as one submission).

Legal Form rechtsform legal_form Legal form of the voting template:

1 Mandatory referendum

2  Optional referendum

3  Popular initiative

4  Direct counter-proposal to a popular initiative

5 Deciding question (since 1987 in the case of a confrontation between popular initiatives and counter-proposals)

Short Description (SwissVote) kurzbetitel short_description Title of the short description of Swissvotes for the respective vote. Votes since 2008: Swissvotes (own compilation).

Votes 1848-2007: Linder et al. (2010).

anneepolitique anneepolitique Link to the description of the events surrounding the referendum bill at Année Politique Suisse.
bkchrono-de
bkchrono-fr
d1e1
d1e2
d1e3
d2e1
d2e2
d2e3
d3e1
d3e2
d3e3
dep
br-pos
legislatur
legisjahr
gesch_nr
curiavista-de
curiavista-fr
bv-pos
nr-pos
nrja
nrnein
sr-pos
srja
srnein
dat-preexam
dat-start
dat-limit
sammelfrist
unter-quorum
dat-submit
dat-success
dat-message
dat-parl
dat-force
dauer_bv
dauer_abst
i-dauer_tot
i-dauer_samm
i-dauer_br
fr-dauer_samm
fr-dauer_tot
unter_g
unter_u
urheber
info_br-de
info_br-fr
info_br-en
info_dep-de
info_dep-fr
info_dep-en
info_amt-de
info_amt-fr
info_amt-en
Party Voting Recommendations p-fdp - Voting recommendation (political parties, association and other organisations):

1 Vote Yes

2 Vote No

3 No recomendation

4 Blank ballot

5 Abstain voting

8 Vote for the counterproposal

9 Vote on preference for the popular iniative

66 Neutral no recommendation to insert blank or to abstain from voting (used only for votes 18481969)

9999 Organisation does not exist

. Unknown

The variable name is formed according to the scheme:

p-[organization abbreviation]

Breakdown of party, association and organization abbreviations:

  • fdp Freisinnig-demokratische Partei (FDP.Die Liberalen) sps Sozialdemokratische Partei
  • svp Schweizerische Volkspartei (bis 1936 Parolen der BGB
  • Bern) mitte Die Mitte
  • evp Evangelische Volkspartei
  • gps Grüne Partei der Schweiz
  • glp Grünliberale Partei
  • ucsp Christlichsoziale Partei der Schweiz (von der CVP unab-
  • hängige CSP) pda Partei der Arbeit
  • sd Schweizer Demokraten
  • edu Eidgenössisch-Demokratische Union
  • fps Autopartei
  • lega Lega dei Ticinesi
  • kvp Katholische Volkspartei
  • mcg Mouvement Citoyens Genevois
  • cvp Christlichdemokratische Volkspartei
  • bdp Bürgerlich-Demokratische Partei
  • lps Liberale Partei der Schweiz
  • ldu Landesring der Unabhängigen
  • poch Progressive Organisationen der Schweiz rep Schweizerische Republikanische Bewegung
  • eco Economiesuisse (bis 15.9.2000: Schweizerischer Handels- und Industrieverein SHIV (Vorort))
  • sgv Schweizerischer Gewerbeverband sbv Schweizer Bauernverband
  • sgb Schweizerischer Gewerkschaftsbund
  • travs Travail.Suisse (bis 2002: Parolen des Christlichnationalen Gewerkschaftsbunds (CNG); dieser fusionierte per 1.1.2003 mit der VSA zu Travail.Suisse)
  • sav Schweizerischer Arbeitgeberverband (bis 1996: Zentral- verband Schweizerischer Arbeitgeber-Organisationen ZSAO)
  • vsa Vereinigung schweizerischer Angestelltenverbände vpod Verband des Personals öffentlicher Dienste
  • voev Verband öffentlicher Verkehr
  • tcs Touring Club Schweiz
  • vcs Verkehrs-Club der Schweiz acs Automobil Club der Schweiz sbk Schweizer Bischofskonferenz
  • ssv Schweizerischer Städteverband
  • gem Schweizerischer Gemeindeverband
  • kdk Konferenz der Kantonsregierungen
  • kkjpd Konferenz der kantonalen Justiz- und Polizeidirektoren gdk Schweizerische Gesundheitsdirektorenkonferenz
  • ldk Konferenz der kantonalen Landwirtschaftsdirektoren vdk Konferenz kantonaler Volkswirtschaftsdirektorinnen und
  • Volkswirtschafsdirektoren
  • sodk Konferenz der kantonalen Sozialdirektorinnen und Sozialdirektoren
  • endk Konferenz kantonaler Energiedirektoren
  • fdk Konferenz der kantonalen Finanzdirektorinnen und Finanzdirektoren
  • edk Schweizerische Konferenz der kantonalen Erziehungsdirektoren
  • bpuk Schweizerische Bau-, Planungs- und Umweltdirektoren-Konferenz
 Parolenspiegel in der Presse;

Swiss Federal Statistical

Office; Année Politique

Suisse;

Websites of political parties, associations and organizations; Bolliger (2007);

Zürcher (2006);

Linder et al. (2010).

Party Voting Recommendations p-sps - same as above
Party Voting Recommendations p-svp - same as above
Party Voting Recommendations p-mitte - same as above
Party Voting Recommendations p-evp - same as above
Party Voting Recommendations p-gps - same as above
Party Voting Recommendations p-glp - same as above
Party Voting Recommendations p-ucsp - same as above
Party Voting Recommendations p-pda - same as above
Party Voting Recommendations p-sd - same as above
Party Voting Recommendations p-edu - same as above
Party Voting Recommendations p-fps - same as above
Party Voting Recommendations p-lega - same as above
Party Voting Recommendations p-kvp - same as above
Party Voting Recommendations p-mcg - same as above
Party Voting Recommendations p-cvp - same as above
Party Voting Recommendations p-bdp - same as above
Party Voting Recommendations p-lps - same as above
Party Voting Recommendations p-ldu - same as above
Party Voting Recommendations p-poch - same as above
Party Voting Recommendations p-rep - same as above
Party Voting Recommendations p-eco - same as above
Party Voting Recommendations p-sgv - same as above
Party Voting Recommendations p-sbv - same as above
Party Voting Recommendations p-sgb - same as above
Party Voting Recommendations p-travs - same as above
Party Voting Recommendations p-sav - same as above
Party Voting Recommendations p-vsa - same as above
Party Voting Recommendations p-vpod - same as above
Party Voting Recommendations p-voev - same as above
Party Voting Recommendations p-tcs - same as above
Party Voting Recommendations p-vcs - same as above
Party Voting Recommendations p-acs - same as above
Party Voting Recommendations p-sbk - same as above
Party Voting Recommendations p-ssv - same as above
Party Voting Recommendations p-gem - same as above
Party Voting Recommendations p-kdk - same as above
Party Voting Recommendations p-kkjpd - same as above
Party Voting Recommendations p-gdk - same as above
Party Voting Recommendations p-ldk - same as above
Party Voting Recommendations p-vdk - same as above
Party Voting Recommendations p-sodk - same as above
Party Voting Recommendations p-endk - same as above
Party Voting Recommendations p-fdk - same as above
Party Voting Recommendations p-edk - same as above
Party Voting Recommendations p-bpuk - same as above
p-others_yes Other organizations that recommended  "yes"
p-others_no Other organizations that recommended  "no"
p-others_free Other organizations that didn't provide a recommendation
p-others_counterp Other organizations that adopted a slogan in favor of the counter-proposal
p-others_init Other organizations that recommended  the popular initiative only
pdev-bdp_AG Voting recommendation of the cantonal section of a party or association diverging from the parent parent national party or association.

1 Party section recommended yes

2 Party section recommended No

3 Party section recommended not to issue a slogan

4 Party section recommended to submit ballots blank

5 Party section recommended to abstain from voting

8 Party section recommended to vote in favor of the counterproposal (in the case of key issues).

9 Party section recommended to vote in favor of the people's initiative (in the case of key issues).

The variable name is formed according to the scheme:

pdev-[organization abbreviation]_[canton abbreviation].

For a breakdown of the organization abbreviations, see variable p-fdp etc. above.

In the case of women's sections of national parties, the cantonal abbreviation is replaced by "_Frauen".

pdev-bdp_AI same as above
pdev-bdp_AR same as above
pdev-bdp_BE same as above
pdev-bdp_BL same as above
pdev-bdp_BS same as above
pdev-bdp_FR same as above
pdev-bdp_GE same as above
pdev-bdp_GL same as above
pdev-bdp_GR same as above
pdev-bdp_JU same as above
pdev-bdp_LU same as above
pdev-bdp_NE same as above
pdev-bdp_NW same as above
pdev-bdp_OW same as above
pdev-bdp_SG same as above
pdev-bdp_SH same as above
pdev-bdp_SO same as above
pdev-bdp_SZ same as above
pdev-bdp_TG same as above
pdev-bdp_TI same as above
pdev-bdp_UR same as above
pdev-bdp_VD same as above
pdev-bdp_VS same as above
pdev-bdp_VSr same as above
pdev-bdp_VSo same as above
pdev-bdp_ZG same as above
pdev-bdp_ZH same as above
pdev-jbdp_CH same as above
pdev-cvp_frauen same as above
pdev-cvp_AG same as above
pdev-cvp_AI same as above
pdev-cvp_AR same as above
pdev-cvp_BE same as above
pdev-cvp_BL same as above
pdev-cvp_BS same as above
pdev-cvp_FR same as above
pdev-cvp_GE same as above
pdev-cvp_GL same as above
pdev-cvp_GR same as above
pdev-cvp_JU same as above
pdev-cvp_LU same as above
pdev-cvp_NE same as above
pdev-cvp_NW same as above
pdev-cvp_OW same as above
pdev-cvp_SG same as above
pdev-cvp_SH same as above
pdev-cvp_SO same as above
pdev-cvp_SZ same as above
pdev-cvp_TG same as above
pdev-cvp_TI same as above
pdev-cvp_UR same as above
pdev-cvp_VD same as above
pdev-cvp_VS same as above
pdev-cvp_VSr same as above
pdev-cvp_VSo same as above
pdev-cvp_ZG same as above
pdev-cvp_ZH same as above
pdev-jcvp_CH same as above
pdev-jcvp_AG same as above
pdev-jcvp_BE same as above
pdev-jcvp_GR same as above
pdev-jcvp_LU same as above
pdev-jcvp_SO same as above
pdev-jcvp_ZH same as above
pdev-fdp_Frauen same as above
pdev-fdp_AG same as above
pdev-fdp_AI same as above
pdev-fdp_AR same as above
pdev-fdp_BE same as above
pdev-fdp_BL same as above
pdev-fdp_BS same as above
pdev-fdp_FR same as above
pdev-fdp_GE same as above
pdev-fdp_GL same as above
pdev-fdp_GR same as above
pdev-fdp_JU same as above
pdev-fdp_LU same as above
pdev-fdp_NE same as above
pdev-fdp_NW same as above
pdev-fdp_OW same as above
pdev-fdp_SG same as above
pdev-fdp_SH same as above
pdev-fdp_SO same as above
pdev-fdp_SZ same as above
pdev-fdp_TG same as above
pdev-fdp_TI same as above
pdev-fdp_UR same as above
pdev-fdp_VD same as above
pdev-fdp_VS same as above
pdev-fdp_VSr same as above
pdev-fdp_Vso same as above
pdev-fdp_ZG same as above
pdev-fdp_ZH same as above
pdev-jfdp_CH same as above
pdev-jfdp_AG same as above
pdev-jfdp_BL same as above
pdev-jfdp_FR same as above
pdev-jfdp_GR same as above
pdev-jfdp_JU same as above
pdev-jfdp_LU same as above
pdev-jfdp_SH same as above
pdev-jfdp_TI same as above
pdev-jfdp_VD same as above
pdev-jfdp_ZH same as above
pdev-glp_AG same as above
pdev-glp_AI same as above
pdev-glp_AR same as above
pdev-glp_BE same as above
pdev-glp_BL same as above
pdev-glp_BS same as above
pdev-glp_FR same as above
pdev-glp_GE same as above
pdev-glp_GL same as above
pdev-glp_GR same as above
pdev-glp_JU same as above
pdev-glp_LU same as above
pdev-glp_NE same as above
pdev-glp_NW same as above
pdev-glp_OW same as above
pdev-glp_SG same as above
pdev-glp_SH same as above
pdev-glp_SO same as above
pdev-glp_SZ same as above
pdev-glp_TG same as above
pdev-glp_TI same as above
pdev-glp_UR same as above
pdev-glp_VD same as above
pdev-glp_VS same as above
pdev-glp_VSr same as above
pdev-glp_VSo same as above
pdev-glp_ZG same as above
pdev-glp_ZH same as above
pdev-jglp_CH same as above
pdev-gps_AG same as above
pdev-gps_AI same as above
pdev-gps_AR same as above
pdev-gps_BE same as above
pdev-gps_BL same as above
pdev-gps_BS same as above
pdev-gps_FR same as above
pdev-gps_GE same as above
pdev-gps_GL same as above
pdev-gps_GR same as above
pdev-gps_JU same as above
pdev-gps_LU same as above
pdev-gps_NE same as above
pdev-gps_NW same as above
pdev-gps_OW same as above
pdev-gps_SG same as above
pdev-gps_SH same as above
pdev-gps_SO same as above
pdev-gps_SZ same as above
pdev-gps_TG same as above
pdev-gps_TI same as above
pdev-gps_UR same as above
pdev-gps_VD same as above
pdev-gps_VS same as above
pdev-gps_VSr same as above
pdev-gps_VSo same as above
pdev-gps_ZG same as above
pdev-gps_ZH same as above
pdev-jgps_CH same as above
pdev-mitte_frauen same as above
pdev-mitte_AG same as above
pdev-mitte_AI same as above
pdev-mitte_AR same as above
pdev-mitte_BE same as above
pdev-mitte_BL same as above
pdev-mitte_BS same as above
pdev-mitte_FR same as above
pdev-mitte_GE same as above
pdev-mitte_GL same as above
pdev-mitte_GR same as above
pdev-mitte_JU same as above
pdev-mitte_LU same as above
pdev-mitte_NE same as above
pdev-mitte_NW same as above
pdev-mitte_OW same as above
pdev-mitte_SG same as above
pdev-mitte_SH same as above
pdev-mitte_SO same as above
pdev-mitte_SZ same as above
pdev-mitte_TG same as above
pdev-mitte_TI same as above
pdev-mitte_UR same as above
pdev-mitte_VD same as above
pdev-mitte_VS same as above
pdev-mitte_VSr same as above
pdev-mitte_VSo same as above
pdev-mitte_ZG same as above
pdev-mitte_ZH same as above
pdev-jmitte_CH same as above
pdev-jmitte_AG same as above
pdev-jmitte_AI same as above
pdev-jmitte_AR same as above
pdev-jmitte_BE same as above
pdev-jmitte_BL same as above
pdev-jmitte_BS same as above
pdev-jmitte_FR same as above
pdev-jmitte_GE same as above
pdev-jmitte_GL same as above
pdev-jmitte_GR same as above
pdev-jmitte_JU same as above
pdev-jmitte_LU same as above
pdev-jmitte_NE same as above
pdev-jmitte_NW same as above
pdev-jmitte_OW same as above
pdev-jmitte_SG same as above
pdev-jmitte_SH same as above
pdev-jmitte_SO same as above
pdev-jmitte_SZ same as above
pdev-jmitte_TG same as above
pdev-jmitte_TI same as above
pdev-jmitte_UR same as above
pdev-jmitte_VD same as above
pdev-jmitte_VS same as above
pdev-jmitte_VSr same as above
pdev-jmitte_VSo same as above
pdev-jmitte_ZG same as above
pdev-jmitte_ZH same as above
pdev-sps_AG same as above
pdev-sps_AI same as above
pdev-sps_AR same as above
pdev-sps_BE same as above
pdev-sps_BL same as above
pdev-sps_BS same as above
pdev-sps_FR same as above
pdev-sps_GE same as above
pdev-sps_GL same as above
pdev-sps_GR same as above
pdev-sps_JU same as above
pdev-sps_LU same as above
pdev-sps_NE same as above
pdev-sps_NW same as above
pdev-sps_OW same as above
pdev-sps_SG same as above
pdev-sps_SH same as above
pdev-sps_SO same as above
pdev-sps_SZ same as above
pdev-sps_TG same as above
pdev-sps_TI same as above
pdev-sps_UR same as above
pdev-sps_VD same as above
pdev-sps_VS same as above
pdev-sps_VSr same as above
pdev-sps_VSo same as above
pdev-sps_ZG same as above
pdev-sps_ZH same as above
pdev-juso_CH same as above
pdev-juso_BE same as above
pdev-juso_GE same as above
pdev-juso_JU same as above
pdev-juso_TI same as above
pdev-juso_VS same as above
pdev-juso_ZH same as above
pdev-svp_AG same as above
pdev-svp_AI same as above
pdev-svp_AR same as above
pdev-svp_BE same as above
pdev-svp_BL same as above
pdev-svp_BS same as above
pdev-svp_FR same as above
pdev-svp_GE same as above
pdev-svp_GL same as above
pdev-svp_GR same as above
pdev-svp_JU same as above
pdev-svp_LU same as above
pdev-svp_NE same as above
pdev-svp_NW same as above
pdev-svp_OW same as above
pdev-svp_SG same as above
pdev-svp_SH same as above
pdev-svp_SO same as above
pdev-svp_SZ same as above
pdev-svp_TG same as above
pdev-svp_TI same as above
pdev-svp_UR same as above
pdev-svp_VD same as above
pdev-svp_VS same as above
pdev-svp_VSr same as above
pdev-svp_VSo same as above
pdev-svp_ZG same as above
pdev-svp_ZH same as above
pdev-jsvp_CH same as above
pdev-jsvp_AG same as above
pdev-jsvp_BE same as above
pdev-jsvp_GE same as above
pdev-jsvp_SH same as above
pdev-jsvp_UR same as above
pdev-jsvp_ZH same as above
pdev-csp_FR same as above
pdev-csp_GR same as above
pdev-csp_JU same as above
pdev-csp_LU same as above
pdev-csp_OW same as above
pdev-csp_SG same as above
pdev-csp_VS same as above
pdev-csp_VSr same as above
pdev-csp_VSo same as above
pdev-csp_ZH same as above
pdev-edu_AG same as above
pdev-edu_AI same as above
pdev-edu_AR same as above
pdev-edu_BE same as above
pdev-edu_BL same as above
pdev-edu_BS same as above
pdev-edu_FR same as above
pdev-edu_GE same as above
pdev-edu_GL same as above
pdev-edu_GR same as above
pdev-edu_JU same as above
pdev-edu_LU same as above
pdev-edu_NE same as above
pdev-edu_NW same as above
pdev-edu_OW same as above
pdev-edu_SG same as above
pdev-edu_SH same as above
pdev-edu_SO same as above
pdev-edu_SZ same as above
pdev-edu_TG same as above
pdev-edu_TI same as above
pdev-edu_UR same as above
pdev-edu_VD same as above
pdev-edu_VS same as above
pdev-edu_VSr same as above
pdev-edu_VSo same as above
pdev-edu_ZG same as above
pdev-edu_ZH same as above
pdev-evp_AG same as above
pdev-evp_AI same as above
pdev-evp_AR same as above
pdev-evp_BE same as above
pdev-evp_BL same as above
pdev-evp_BS same as above
pdev-evp_FR same as above
pdev-evp_GE same as above
pdev-evp_GL same as above
pdev-evp_GR same as above
pdev-evp_JU same as above
pdev-evp_LU same as above
pdev-evp_NE same as above
pdev-evp_NW same as above
pdev-evp_OW same as above
pdev-evp_SG same as above
pdev-evp_SH same as above
pdev-evp_SO same as above
pdev-evp_SZ same as above
pdev-evp_TG same as above
pdev-evp_TI same as above
pdev-evp_UR same as above
pdev-evp_VD same as above
pdev-evp_VS same as above
pdev-evp_ZG same as above
pdev-evp_ZH same as above
pdev-jevp_CH same as above
pdev-fps_AG same as above
pdev-fps_AI same as above
pdev-fps_BE same as above
pdev-fps_BL same as above
pdev-fps_BS same as above
pdev-fps_SG same as above
pdev-fps_SH same as above
pdev-fps_SO same as above
pdev-fps_TG same as above
pdev-fps_ZH same as above
pdev-kvp_SG same as above
pdev-lps_BE same as above
pdev-lps_BL same as above
pdev-lps_BS same as above
pdev-lps_FR same as above
pdev-lps_GE same as above
pdev-lps_JU same as above
pdev-lps_NE same as above
pdev-lps_SG same as above
pdev-lps_TI same as above
pdev-lps_VD same as above
pdev-lps_VS same as above
pdev-lps_ZH same as above
pdev-jlps_CH same as above
pdev-jlps_SO same as above
pdev-jlps_TI same as above
pdev-ldu_AG same as above
pdev-ldu_AR same as above
pdev-ldu_BE same as above
pdev-ldu_BL same as above
pdev-ldu_BS same as above
pdev-ldu_GR same as above
pdev-ldu_LU same as above
pdev-ldu_NE same as above
pdev-ldu_SG same as above
pdev-ldu_SH same as above
pdev-ldu_SO same as above
pdev-ldu_TG same as above
pdev-ldu_VD same as above
pdev-ldu_ZG same as above
pdev-ldu_ZH same as above
pdev-jldu_CH same as above
pdev-poch_SO same as above
pdev-poch_ZH same as above
pdev-pda_BE same as above
pdev-pda_BL same as above
pdev-pda_BS same as above
pdev-pda_GE same as above
pdev-pda_JU same as above
pdev-pda_NE same as above
pdev-pda_SG same as above
pdev-pda_TI same as above
pdev-pda_VD same as above
pdev-pda_ZH same as above
pdev-jpda_CH same as above
pdev-rep_AG same as above
pdev-rep_GE same as above
pdev-rep_NE same as above
pdev-rep_TG same as above
pdev-rep_VD same as above
pdev-rep_ZH same as above
pdev-sd_AG same as above
pdev-sd_BE same as above
pdev-sd_BL same as above
pdev-sd_BS same as above
pdev-sd_FR same as above
pdev-sd_GE same as above
pdev-sd_GR same as above
pdev-sd_LU same as above
pdev-sd_NE same as above
pdev-sd_SG same as above
pdev-sd_SO same as above
pdev-sd_TG same as above
pdev-sd_TI same as above
pdev-sd_VD same as above
pdev-sd_ZH same as above
pdev-jsd_CH same as above
pdev-sgb_AG same as above
pdev-sgb_JU same as above
pdev-sgb_VS same as above
pdev-sgv_AG same as above
pdev-sgv_BS same as above
pdev-sgv_SH same as above
pdev-vpod_GE same as above
pdev-vpod_VD same as above
nr-wahl
w-fdp
w-sp
w-svp
w-mitte
w-evp
w-gps
w-glp
w-csp
w-pda
w-sd
w-edu
w-fps
w-lega
w-kvp
w-mcg
w-cvp
w-bdp
w-lps
w-ldu
w-poch
w-rep
w-ubrige
ja-lager
nein-lager
keinepar-summe
leer-summe
freigabe-summe
unbekannt-summe
neutral-summe
poster_ja_mfg
poster_nein_mfg
poster_ja_sa
poster_nein_sa
inserate-total
inserate-je-ausgabe
inserate-ja
inserate-nein
inserate-neutral
inserate-jaanteil
mediares-tot
mediares-d
mediares-f
mediaton-tot
mediaton-d
mediaton-f
volk
stand
annahme
berecht
stimmen
bet
leer
ungultig
gultig
volkja
volknein
volkja-proz
kt-ja
kt-nein
ktjaproz
zh-berecht
zh-stimmen
zh-bet
zh-gultig
zh-ja
zh-nein
zh-japroz
zh-annahme
be-berecht
be-stimmen
be-bet
be-gultig
be-ja
be-nein
be-japroz
be-annahme
lu-berecht
lu-stimmen
lu-bet
lu-gultig
lu-ja
lu-nein
lu-japroz
lu-annahme
ur-berecht
ur-stimmen
ur-bet
ur-gultig
ur-ja
ur-nein
ur-japroz
ur-annahme
sz-berecht
sz-stimmen
sz-bet
sz-gultig
sz-ja
sz-nein
sz-japroz
sz-annahme
ow-berecht
ow-stimmen
ow-bet
ow-gultig
ow-ja
ow-nein
ow-japroz
ow-annahme
nw-berecht
nw-stimmen
nw-bet
nw-gultig
nw-ja
nw-nein
nw-japroz
nw-annahme
gl-berecht
gl-stimmen
gl-bet
gl-gultig
gl-ja
gl-nein
gl-japroz
gl-annahme
zg-berecht
zg-stimmen
zg-bet
zg-gultig
zg-ja
zg-nein
zg-japroz
zg-annahme
fr-berecht
fr-stimmen
fr-bet
fr-gultig
fr-ja
fr-nein
fr-japroz
fr-annahme
so-berecht
so-stimmen
so-bet
so-gultig
so-ja
so-nein
so-japroz
so-annahme
bs-berecht
bs-stimmen
bs-bet
bs-gultig
bs-ja
bs-nein
bs-japroz
bs-annahme
bl-berecht
bl-stimmen
bl-bet
bl-gultig
bl-ja
bl-nein
bl-japroz
bl-annahme
sh-berecht
sh-stimmen
sh-bet
sh-gultig
sh-ja
sh-nein
sh-japroz
sh-annahme
ar-berecht
ar-stimmen
ar-bet
ar-gultig
ar-ja
ar-nein
ar-japroz
ar-annahme
ai-berecht
ai-stimmen
ai-bet
ai-gultig
ai-ja
ai-nein
ai-japroz
ai-annahme
sg-berecht
sg-stimmen
sg-bet
sg-gultig
sg-ja
sg-nein
sg-japroz
sg-annahme
gr-berecht
gr-stimmen
gr-bet
gr-gultig
gr-ja
gr-nein
gr-japroz
gr-annahme
ag-berecht
ag-stimmen
ag-bet
ag-gultig
ag-ja
ag-nein
ag-japroz
ag-annahme
tg-berecht
tg-stimmen
tg-bet
tg-gultig
tg-ja
tg-nein
tg-japroz
tg-annahme
ti-berecht
ti-stimmen
ti-bet
ti-gultig
ti-ja
ti-nein
ti-japroz
ti-annahme
vd-berecht
vd-stimmen
vd-bet
vd-gultig
vd-ja
vd-nein
vd-japroz
vd-annahme
vs-berecht
vs-stimmen
vs-bet
vs-gultig
vs-ja
vs-nein
vs-japroz
vs-annahme
ne-berecht
ne-stimmen
ne-bet
ne-gultig
ne-ja
ne-nein
ne-japroz
ne-annahme
ge-berecht
ge-stimmen
ge-bet
ge-gultig
ge-ja
ge-nein
ge-japroz
ge-annahme
ju-berecht
ju-stimmen
ju-bet
ju-gultig
ju-ja
ju-nein
ju-japroz
ju-annahme
bkresults-de
bkresults-fr
bfsmap-de
bfsmap-fr
nach_cockpit_d
nach_cockpit_f
nach_cockpit_e

Structure of data within Wikidata[edit]

Field nameWikidata propertyNotes
IDSwissvote ID (P9206)Format [1-9]\d{0,3}(\.[123])?
Datepoint in time (P585)
Participationballots cast (P1868) and eligible voters (P1867)Integers

Match the dataset to Wikidata[edit]

The related property Swissvote ID (P9206) only has four uses currently [2]:

— Martin (MSGJ · talk) 20:53, 15 February 2022 (UTC)[reply]

I didn't now they was this property. My initial thinking was to importe the swissvote data directly in each votation property (that can be either a swiss popular initiative Q15078695 or a referendum Q43109.
The most complete list of all swiss votation is on https://de.wikipedia.org/wiki/Liste_der_eidgenössischen_Volksabstimmungen (DE, but automatic translation can give an ideas). There is a similar French page https://fr.wikipedia.org/wiki/Liste_des_initiatives_populaires_fédérales_en_Suisse yet it only list popular initiative, but their is a discussion to create only one page with all the type of votation like in the German one. The ideal seem to me that at the end we could automatise the creation of this list from the imported data from swissvote. Gagarine (talk) 19:36, 2 March 2022 (UTC)[reply]

Importing data into Wikidata[edit]

Import completion notes[edit]

Visualisations[edit]

Maintenance[edit]

Queries and expected results[edit]

Query linkDescriptionExpected results
Link1Property1Notes1
Link2Property2Notes2
Link3Property3Notes3

Schedule of new data released[edit]

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Dataset_Imports/Swissvotes&oldid=1619511716"