The data set contains the results of the elections to the German Bundestag on 24 September 2017 of the City of Düsseldorf.
An authority may set up different territorial levels to present the election results, from the lowest level (voting districts) to constituencies and districts to the level of the city or municipality, district and constituency. However, not all levels are necessary for each type of election. For each of the territorial levels that an authority has set up, there is a file containing the overview of those areas with fast messages already received.
Further data sets contain information on the division of electoral areas for the Bundestag election and the division of voting districts.
Information on terms in the field of ‘Elections’ can be found in the Election ABC of the interactive learning platform for election workers of the City of Düsseldorf.
The files are encoded in UTF-8. By default, Excel does not display the umlauts in the files correctly. You can avoid this as follows:
Excel 2003
Select from the menu ‘Data’ -> ‘Import external data’ from the menu item ‘Import data’. The ‘Select data source’ dialog opens. Select the file you want to open and press the ‘Open’ button. Then place the file origin to '65001 Unicode: (UTF-8)' fixed and continue with the ‘Next’ button. In the next dialog, set the separator to ‘Semicolon’ instead of ‘Tabstopp’ and continue with the ‘Next’ button again. They then select the ‘Text’ option as the data format of the columns and exit the wizard with the ‘Finish’ button. Use the ‘OK’ button to finish the procedure and the data is displayed UTF-8 encoded in Microsoft Excel.
Excel 2010
From the tab ‘Data’ in the section ‘Retrieve external data’, select the option ‘From text’. The dialog ‘Import text file’ opens. Select the file you want to open and press the ‘Open’ button. Then place the file origin to '65001 Unicode: (UTF-8)' fixed and continue with the ‘Next’ button. In the next dialog, set the separator to ‘Semicolon’ instead of ‘Tabstopp’ and continue with the ‘Next’ button again. They then select the ‘Text’ option as the data format of the columns and exit the wizard with the ‘Finish’ button. Use the ‘OK’ button to finish the procedure and the data is displayed UTF-8 encoded in Microsoft Excel.
The following fields are available in the file (fields for second votes, of course, only with appropriate options):
Number: Constituency number
Name: Name of the constituency
MaxQuick Messages: maximum number of quick messages
AnzQuick Messages: Number of fast messages already recorded
Eligible voters: Number of eligible voters
Filed under: Number of ballot papers submitted
Turnout: Voter turnouts at the respective view levels
valid Voting List: Number of valid ballot papers
valid: Number of valid first votes
invalid Voting List: Number of invalid ballot papers
invalid: Number of invalid first votes
valid2: Number of valid second votes
invalid2: Number of invalid second votes
In addition, the following fields are available for each party (example of one party called ‘A-Party’ — fields for second votes of course only in appropriate elections):
A Party: Number of total votes of the party
A-Party_Proz: Percentage of total votes of the party from the total result
Z_A Party: Number of total second votes of the party
Z_A-Partei_Proz: Percentage of the party’s total second votes from the total second-vote result
Build on reliable and scalable technology
FAQ
Frequently Asked Questions
Some basic informations about API Store ®.
Operation and development of APIs are currently fully funded by company Apitalks and its usage is for free.
Yes, you can.
All important information such as time of last update, license and other information are in response of each API call.
In case of major update that would not be compatible with previous version of API, we keep for 30 days both versions so you will have enough time to transfer to new version. We will inform you about the changes in advance by e-mail.