Poll-by-poll Result Files, 1997 and 2000 General Elections
File Name: EDDET.ZIP (3.3 MB)
Description: This file provides an entry for each polling station in each electoral district for the 1997 and 2000 general elections. It combines the information found in the EDSum, Polls, and Results tables, but is a little harder to work with, since it has so many fields. However, if you want to work only with one file, use this one.
MAC users: For MS Excel users, remember to change your "File origin" to Windows [ANSI].
Fields:
Field Name | Description |
Event_Number | A four-digit number representing the electoral event. 3600 is the 36th general election, and 3700 is the 37th general election. |
ED_Code | Electoral district code, in the format EDXX-YYY, where the fixed literal ‘ED’ prevents spreadsheets from trying to convert the code into a date, XX is a code for each province/area, and YYY is a number within that province or area. |
ED_English_Name | The name of the electoral district, in English. |
ED_French_Name | The name of the electoral district, in French. |
Province_Name_English | The name of the province, in English. |
Province_Name_French | The name of the province, in French. |
ED_Rejected_Ballot_Count | The number of rejected ballots in this electoral district for this general election. |
ED_Valid_Vote_Count | The number of valid votes in this electoral district for this general election. |
ED_Electors_On_List_Count | The number of electors on the voters lists in this electoral district for this general election. |
Total_Poll_Count | The number of polls in this electoral district for this general election. Includes all poll types. |
Advance_Poll_Count | The number of advance polls in this electoral district for this general election. |
Mobile_Poll_Count | The number of mobile polls in this electoral district for this general election. |
SVR_Group1_Ballot_Count | Special Voting Rules (SVR) Group 1 comprises electors who voted by special ballot and are either Canadian electors temporarily residing outside Canada, Canadian Forces electors or incarcerated electors serving sentences of less than two years. |
SVR_Group2_Ballot_Count | Special Voting Rules (SVR) Group 2 comprises Canadian citizens residing in Canada who voted by special ballot, within or outside their electoral districts. |
SVR_Total_Ballot_Count | The total number of special ballots received for this electoral district. |
Population_Cnt | The population of the electoral district, as recorded during the last census before the general election. |
Census_Year | The year the census was taken. |
Judicial_Recount_Indicator | Indicates whether a judicial recount was carried out in this electoral district after this general election. |
Majority_Count | The margin of win – the difference between the number of valid votes cast for the winning candidate and the number of valid votes cast for the second-place candidate. |
Majority_Percentage | The percentage of win – the difference between the percentage of valid votes cast for the winning candidate and the percentage of valid votes cast for the second-place candidate. |
Voter_Participation_Percentage | The percentage of voter participation, based on the number of votes cast and the number of electors on the voters lists. |
Elected_Last_Name | The winning candidate’s last name. |
Elected_Middle_Name | The winning candidate’s middle name. |
Elected_First_Name | The winning candidate’s first name. |
Elected_Party_English_Name | The English name of the winning candidate’s party. |
Elected_Party_French_Name | The French name of the winning candidate’s party. |
Event_English_Name | The name of the general election, in English. |
Event_French_Name | The name of the general election, in French. |
Returning_Officer | The name of the returning officer for the electoral district at the time of the general election. |
Poll_Number | The number assigned to the polling station. Examples: 3, 601, 45A, 48-3. |
Polling_Station_Name | A name that generally represents either the location of the polling station or the area where the voters lived. |
Poll_Type | Indicates the type of polling station, as follows: 10 = ordinary, 2A = advance, 3S and 4S = SVR polls. |
Urban_Rural Indicator | Urban/rural indicator (not used in reporting 2000 results). |
Void_Indicator | Indicates that a polling station had been planned for the area, but the returning officer determined there was no need for it. |
No_Poll_Indicator | Indicates that the returning officer intended to hold this poll, but extreme circumstances prevented it. |
Split_Indicator | Indicates that this polling division was split into two or more polls, due to the number of electors or location issues. |
Merge_Indicator | Indicates that this poll was amalgamated (merged or combined) with another poll. |
Merged_With_Poll_Number | Gives the identification number of the polling station with which this poll was merged. |
Advance_Poll_Indicator | Indicates if this was an advance polling station. |
Mobile_Poll_Indicator | Indicates if this was a mobile polling station. |
SVR_Poll_Indicator | Indicates if this polling station was used for Special Voting Rules (SVR) results, where voting was done by special ballot. |
Poll_Rejected_Ballot_Count | The number of rejected ballots at this polling station. |
Poll_Valid_Vote_Count | The number of valid votes at this polling station. |
Poll_Total_Ballot_Count | The total number of ballots counted at this polling station. |
Poll_Electors_On_List_Count | The number of electors on the voters list for this polling station. |
Cand_1_Last_Name | The last name of the first candidate appearing on the ballot. |
Cand_1_Middle_Name | The middle name of the first candidate appearing on the ballot. |
Cand_1_First_Name | The first name of the first candidate appearing on the ballot. |
Cand_1_Party_English_Name | The English name of the party of the first candidate on the ballot. |
Cand_1_Party_French_Name | The French name of the party of the first candidate on the ballot. |
Cand_1_Gender_Code | The gender of the first candidate on the ballot. |
Cand_1_Elected_Indicator | ‘Y’ if the first candidate on the ballot was elected. |
Cand_1_Incumbent_Indicator | ‘Y’ if the first candidate on the ballot was the incumbent. |
Cand_1_Poll_Vote | The number of valid votes for the first candidate on the ballot, at this polling station only. |
Cand_2_Last_Name | The last name of the second candidate appearing on the ballot. |
Cand_2_Middle_Name | The middle name of the second candidate appearing on the ballot. |
Cand_2_First_Name | The first name of the second candidate appearing on the ballot. |
Cand_2_Party_English_Name | The English name of the party of the second candidate on the ballot. |
Cand_2_Party_French_Name | The French name of the party of the second candidate on the ballot. |
Cand_2_Gender_Code | The gender of the second candidate on the ballot. |
Cand_2_Elected_Indicator | ‘Y’ if the second candidate on the ballot was elected. |
Cand_2_Incumbent_Indicator | ‘Y’ if the second candidate on the ballot was the incumbent. |
Cand_2_Poll_Vote | The number of valid votes for the second candidate on the ballot, at this polling station only. |
Cand_3_Last_Name | The last name of the third candidate appearing on the ballot. |
Cand_3_Middle_Name | The middle name of the third candidate appearing on the ballot. |
Cand_3_First_Name | The first name of the third candidate appearing on the ballot. |
Cand_3_Party_English_Name | The English name of the party of the third candidate on the ballot. |
Cand_3_Party_French_Name | The French name of the party of the third candidate on the ballot. |
Cand_3_Gender_Code | The gender of the third candidate on the ballot. |
Cand_3_Elected_Indicator | ‘Y’ if the third candidate on the ballot was elected. |
Cand_3_Incumbent_Indicator | ‘Y’ if the third candidate on the ballot was the incumbent. |
Cand_3_Poll_Vote | The number of valid votes for the third candidate on the ballot, at this polling station only. |
Cand_4_Last_Name | The last name of the fourth candidate appearing on the ballot. |
Cand_4_Middle_Name | The middle name of the fourth candidate appearing on the ballot. |
Cand_4_First_Name | The first name of the fourth candidate appearing on the ballot. |
Cand_4_Party_English_Name | The English name of the party of the fourth candidate on the ballot. |
Cand_4_Party_French_Name | The French name of the party of the fourth candidate on the ballot. |
Cand_4_Gender_Code | The gender of the fourth candidate on the ballot. |
Cand_4_Elected_Indicator | ‘Y’ if the fourth candidate on the ballot was elected. |
Cand_4_Incumbent_Indicator | ‘Y’ if the fourth candidate on the ballot was the incumbent. |
Cand_4_Poll_Vote | The number of valid votes for the fourth candidate on the ballot, at this polling station only. |
Cand_5_Last_Name | The last name of the fifth candidate appearing on the ballot. |
Cand_5_Middle_Name | The middle name of the fifth candidate appearing on the ballot. |
Cand_5_First_Name | The first name of the fifth candidate appearing on the ballot. |
Cand_5_Party_English_Name | The English name of the party of the fifth candidate on the ballot. |
Cand_5_Party_French_Name | The French name of the party of the fifth candidate on the ballot. |
Cand_5_Gender_Code | The gender of the fifth candidate on the ballot. |
Cand_5_Elected_Indicator | ‘Y’ if the fifth candidate on the ballot was elected. |
Cand_5_Incumbent_Indicator | ‘Y’ if the fifth candidate on the ballot was the incumbent. |
Cand_5_Poll_Vote | The number of valid votes for the fifth candidate on the ballot, at this polling station only. |
Cand_6_Last_Name | The last name of the sixth candidate appearing on the ballot. |
Cand_6_Middle_Name | The middle name of the sixth candidate appearing on the ballot. |
Cand_6_First_Name | The first name of the sixth candidate appearing on the ballot. |
Cand_6_Party_English_Name | The English name of the party of the sixth candidate on the ballot. |
Cand_6_Party_French_Name | The French name of the party of the sixth candidate on the ballot. |
Cand_6_Gender_Code | The gender of the sixth candidate on the ballot. |
Cand_6_Elected_Indicator | ‘Y’ if the sixth candidate on the ballot was elected. |
Cand_6_Incumbent_Indicator | ‘Y’ if the sixth candidate on the ballot was the incumbent. |
Cand_6_Poll_Vote | The number of valid votes for the sixth candidate on the ballot, at this polling station only. |
Cand_7_Last_Name | The last name of the seventh candidate appearing on the ballot. |
Cand_7_Middle_Name | The middle name of the seventh candidate appearing on the ballot. |
Cand_7_First_Name | The first name of the seventh candidate appearing on the ballot. |
Cand_7_Party_English_Name | The English name of the party of the seventh candidate on the ballot. |
Cand_7_Party_French_Name | The French name of the party of the seventh candidate on the ballot. |
Cand_7_Gender_Code | The gender of the seventh candidate on the ballot. |
Cand_7_Elected_Indicator | ‘Y’ if the seventh candidate on the ballot was elected. |
Cand_7_Incumbent_Indicator | ‘Y’ if the seventh candidate on the ballot was the incumbent. |
Cand_7_Poll_Vote | The number of valid votes for the seventh candidate on the ballot, at this polling station only. |
Cand_8_Last_Name | The last name of the eighth candidate appearing on the ballot. |
Cand_8_Middle_Name | The middle name of the eighth candidate appearing on the ballot. |
Cand_8_First_Name | The first name of the eighth candidate appearing on the ballot. |
Cand_8_Party_English_Name | The English name of the party of the eighth candidate on the ballot. |
Cand_8_Party_French_Name | The French name of the party of the eighth candidate on the ballot. |
Cand_8_Gender_Code | The gender of the eighth candidate on the ballot. |
Cand_8_Elected_Indicator | ‘Y’ if the eighth candidate on the ballot was elected. |
Cand_8_Incumbent_Indicator | ‘Y’ if the eighth candidate on the ballot was the incumbent. |
Cand_8_Poll_Vote | The number of valid votes for the eighth candidate on the ballot, at this polling station only. |
Cand_9_Last_Name | The last name of the ninth candidate appearing on the ballot. |
Cand_9_Middle_Name | The middle name of the ninth candidate appearing on the ballot. |
Cand_9_First_Name | The first name of the ninth candidate appearing on the ballot. |
Cand_9_Party_English_Name | The English name of the party of the ninth candidate on the ballot. |
Cand_9_Party_French_Name | The French name of the party of the ninth candidate on the ballot. |
Cand_9_Gender_Code | The gender of the ninth candidate on the ballot. |
Cand_9_Elected_Indicator | ‘Y’ if the ninth candidate on the ballot was elected. |
Cand_9_Incumbent_Indicator | ‘Y’ if the ninth candidate on the ballot was the incumbent. |
Cand_9_Poll_Vote | The number of valid votes for the ninth candidate on the ballot, at this polling station only. |
Cand_10_Last_Name | The last name of the tenth candidate appearing on the ballot. |
Cand_10_Middle_Name | The middle name of the tenth candidate appearing on the ballot. |
Cand_10_First_Name | The first name of the tenth candidate appearing on the ballot. |
Cand_10_Party_English_Name | The English name of the party of the tenth candidate on the ballot. |
Cand_10_Party_French_Name | The French name of the party of the tenth candidate on the ballot. |
Cand_10_Gender_Code | The gender of the tenth candidate on the ballot. |
Cand_10_Elected_Indicator | ‘Y’ if the tenth candidate on the ballot was elected. |
Cand_10_Incumbent_Indicator | ‘Y’ if the tenth candidate on the ballot was the incumbent. |
Cand_10_Poll_Vote | The number of valid votes for the tenth candidate on the ballot, at this polling station only. |
Cand_11_Last_Name | The last name of the eleventh candidate appearing on the ballot. |
Cand_11_Middle_Name | The middle name of the eleventh candidate appearing on the ballot. |
Cand_11_First_Name | The first name of the eleventh candidate appearing on the ballot. |
Cand_11_Party_English_Name | The English name of the party of the eleventh candidate on the ballot. |
Cand_11_Party_French_Name | The French name of the party of the eleventh candidate on the ballot. |
Cand_11_Gender_Code | The gender of the eleventh candidate on the ballot. |
Cand_11_Elected_Indicator | ‘Y’ if the eleventh candidate on the ballot was elected. |
Cand_11_Incumbent_Indicator | ‘Y’ if the eleventh candidate on the ballot was the incumbent. |
Cand_11_Poll_Vote | The number of valid votes for the eleventh candidate on the ballot, at this polling station only. |
Cand_12_Last_Name | The last name of the twelfth candidate appearing on the ballot. |
Cand_12_Middle_Name | The middle name of the twelfth candidate appearing on the ballot. |
Cand_12_First_Name | The first name of the twelfth candidate appearing on the ballot. |
Cand_12_Party_English_Name | The English name of the party of the twelfth candidate on the ballot. |
Cand_12_Party_French_Name | The French name of the party of the twelfth candidate on the ballot. |
Cand_12_Gender_Code | The gender of the twelfth candidate on the ballot. |
Cand_12_Elected_Indicator | ‘Y’ if the twelfth candidate on the ballot was elected. |
Cand_12_Incumbent_Indicator | ‘Y’ if the twelfth candidate on the ballot was the incumbent. |
Cand_12_Poll_Vote | The number of valid votes for the twelfth candidate on the ballot, at this polling station only. |
Cand_13_Last_Name | The last name of the thirteenth candidate appearing on the ballot. |
Cand_13_Middle_Name |
The middle name of the thirteenth candidate appearing on the ballot. |
Cand_13_First_Name | The first name of the thirteenth candidate appearing on the ballot. |
Cand_13_Party_English_Name | The English name of the party of the thirteenth candidate on the ballot. |
Cand_13_Party_French_Name | The French name of the party of the thirteenth candidate on the ballot. |
Cand_13_Gender_Code | The gender of the thirteenth candidate on the ballot. |
Cand_13_Elected_Indicator | ‘Y’ if the thirteenth candidate on the ballot was elected. |
Cand_13_Incumbent_Indicator | ‘Y’ if the thirteenth candidate on the ballot was the incumbent. |
Cand_13_Poll_Vote | The number of valid votes for the thirteenth candidate on the ballot, at this polling station only. |
[ Return to Table of Contents ]