open Secondary menu

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



Introduction

This document describes the data files available for the poll-by-poll voting results of both the 1997 and 2000 general elections. The files were created from the same data used for the Official Voting Results (OVR) 2000, which can be obtained on CD-ROM from Elections Canada.

File Types Available

Name Description
EDSum Summarizes voting results by electoral district. There are two entries for each electoral district, one for the 1997 general election and one for the 2000 general election.
Cand This file provides the results for each candidate in each of the two general elections.
Polls This file contains information about polls, including the type of poll and the total votes cast at each poll. There is one entry for each poll held in each electoral district for each of the two general elections.
Results This file provides the results of each poll for each candidate. There is one entry for each candidate in each poll held in each electoral district for the two general elections.
EDDet This is a single file that contains all the information in the above four files. Since it has so much information, it is not as easy to use (or to load into a local database) as the separate files, but it is useful if you want all the data combined in a single file.

File Format & Organization

Files are set up in tab-delimited format, which can be read by most popular spreadsheet and personal computer database programs. The files are provided in compressed format as zip files (.ZIP files), which makes downloading faster and easier. When you have downloaded the information, simply open the archive and uncompress the files to a location of your choice.

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

The following archives are available:

Executable Name Description
TOTAL.ZIP All of the files available, in a single archive.
MAIN.ZIP The first four files (all but EDDet), compressed.
EDSUM.ZIP The EDSum file, compressed.
CAND.ZIP The Cand file, compressed.
POLLS.ZIP The Polls file, compressed.
RESULTS.ZIP The Results file, compressed.
EDDET.ZIP The EDDet file, compressed.

Files and Record Counts

The following are the text files available, as described earlier, and the number of records in each file.

File

Records (including header row)

CAND.TXT

3 481

DET00AB.TXT

5 866

DET00BC.TXT

7 653

DET00MA.TXT

2 483

DET00NB.TXT

1 843

DET00NF.TXT

1 441

DET00NS.TXT

2 250

DET00NT.TXT

100

DET00NU.TXT

60

DET00ON.TXT

22 067

DET00PE.TXT

333

DET00QC.TXT

15 683

DET00SK.TXT

2 336

DET00YT.TXT

99

DET97AB.TXT

5 687

DET97BC.TXT

7 436

DET97MA.TXT

2 460

DET97NB.TXT

1 792

DET97NF.TXT

1 421

DET97NS.TXT

2 231

DET97NT.TXT

158

DET97ON.TXT

21 354

DET97PE.TXT

329

DET97QC.TXT

15 297

DET97SK.TXT

2 297

DET97YT.TXT

94

EDSUM.TXT

603

POLLS00.TXT

63 827

POLLS97.TXT

62 170

RES00AB.TXT

32 317

RES00BC.TXT

55 718

RES00MA.TXT

13 618

RES00NB.TXT

8 243

RES00NF.TXT

6 639

RES00NS.TXT

11 400

RES00NT.TXT

385

RES00NU.TXT

193

RES00ON1.TXT

57 052

RES00ON2.TXT

55 855

RES00ON3.TXT

27 995

RES00PE.TXT

2 323

RES00QC1.TXT

57 617

RES00QC2.TXT

47 515

RES00SK.TXT

10 053

RES00YT.TXT

491

RES97AB.TXT

34 578

RES97BC.TXT

54 419

RES97MA.TXT

14 935

RES97NB.TXT

7 783

RES97NF.TXT

5 911

RES97NS.TXT

11 453

RES97NT.TXT

1 266

RES97ON1.TXT

48 919

RES97ON2.TXT

51 732

RES97ON3.TXT

27 935

RES97PE.TXT

1 332

RES97QC1.TXT

40 402

RES97QC2.TXT

34 759

RES97SK.TXT

11 865

RES97YT.TXT

1 051