Poll-by-poll Result Files, 1997 and 2000 General Elections

File Name: TOTAL.ZIP  (8.9 MB)
Description: All of the files available, in a single archive.

MAC users: For MS Excel users, remember to change your "File origin" to Windows [ANSI].

• File Layout Description
  • File Type: EDSum (summary)
  • File Type: Cand (candidates)
  • File Type: Polls
  • File Type: Results
  • File Type: EDDet (detail)

FILE LAYOUT DESCRIPTION

File Type: EDSum (summary)

Description: This file has one entry for each electoral district for each of the two general elections. It provides electoral district information, such as province, name, ED (electoral district) code, and a summary of the voting results.

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 if 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 for the winning candidate and the number of valid votes for the candidate who came second.
Majority_Percentage	The winning percentage – the difference between the percentage of valid votes cast for the winning candidate and the percentage of valid votes cast for the candidate who came second.
Voter_Participation_Percentage	The percentage of voter participation, based on the number of votes cast and the number of electors on the lists.
Elected_First_Name	The winning candidate’s first name.
Elected_Middle_Name	The winning candidate’s middle name.
Elected_Last_Name	The winning candidate’s last name.
Elected_Party_English_Name	The English name of the party of the winning candidate.
Elected_Party_French_Name	The French name of the party of the winning candidate.
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.

File Type: Cand (candidates)

Description: This file provides an entry for each candidate who ran in the 1997 and 2000 general elections. It includes the name of the candidate, the name of the political party, the number and percentage of votes, and other related information.

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.
Ballot_Sequence_Number	The list of candidates on the ballot paper is arranged in alphabetical order by surname.This number indicates the placement of the candidate on the ballot for the electoral district. The combination of event number, ED code, and ballot sequence number is unique for each candidate.
Candidate_First_Name	The candidate’s first name.
Candidate_Middle_Name	The candidate’s middle name.
Candidate_Last_Name	The candidate’s last name.
Candidate_Gender_Code	The gender of the candidate: ‘M’ for male, ‘F’ for female.
Candidate_Occupation_English	The candidate’s occupation, given in English.
Candidate_Occupation_French	The candidate’s occupation, given in French.
Elected_Indicator	‘Y’ if candidate was elected, ‘N’ otherwise.
Incumbent_Indicator	‘Y’ if candidate was the incumbent, ‘N’ otherwise.
Candidate_Vote	The number of valid votes the candidate obtained.
Candidate_Vote_Percentage	The percentage of valid votes the candidate obtained.
Candidate_Residence	The place the candidate recorded as his/her residence.
Candidate_Province_English	The province of the candidate’s residence, in English.
Candidate_Province_French	The province of the candidate’s residence, in French.
Candidate_Party_English_Name	The English name of the candidate’s political party.
Candidate_Party_French_Name	The French name of the candidate’s political party.

File Type: Polls

Description: This file has an entry for each polling station in each electoral district for the 1997 and 2000 general elections. It provides information on the polling station, including the type of poll, and gives the overall vote counts for the poll.

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.
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 poll, 2A = advance poll, 3S and 4S = SVR polls.
Urban_Rural Indicator	Urban/rural indicator (not used in reporting 2000 results).
Void_Indicator	Indicates that a polling station was 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.
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.

File Type: Results

Description: This file provides an entry for each candidate by polling station in each electoral district for the 1997 and 2000 general elections. It includes information on who the candidate is, the candidate’s political party, and the voting results for that candidate at a particular poll.

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.
Ballot_Sequence_Number	The placement of the candidate in the list of candidates on the ballot for the electoral district (candidates are listed in alphabetical order by surname). The combination of event number, ED code, and ballot sequence number is unique for each candidate.
Candidate_First_Name	The candidate’s first name.
Candidate_Middle_Name	The candidate’s middle name.
Candidate_Last_Name	The candidate’s last name.
Candidate_Gender_Code	The gender of the candidate: ‘M’ for male, ‘F’ for female.
Elected_Indicator	‘Y’ if candidate was elected, ‘N’ otherwise.
Incumbent_Indicator	‘Y’ if candidate was the incumbent, ‘N’ otherwise.
Candidate_ED_Vote_Count	The total number of valid votes the candidate received in the electoral district.
Candidate_Party_English_Name	The English name of the candidate’s party.
Candidate_Party_French_Name	The French name of the candidate’s party.
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.
Candidate_Poll_Vote_Count	The number of valid votes for the candidate at this polling station only.

File Type: EDDet (detail)

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.

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 ]