By Riding

Each CSV file contains one row for each riding. There is one file for each of the elections since 1867. Each CSV file contains the following columns.

  1. election_id: See above.
  2. prov_code: See above.
  3. ed_id: See above.
  4. ed_name: See above.
  5. more: See below.

The above are followed by a variable number of columns, one for each “mainstream” party in that particular election, which contains the votes cast for that party. A mainstream party is defined, somewhat arbitrarily, as a party who has won at least 5% of the vote in any election. Votes for parties that are not mainstream are collected in an additional column labelled “Other”.

For example, the CSV file for the 43rd (2019) election contains columns for each of “Bloc”, “Con”, “Grn”, “Lib”, “NDP”, and “Other”. Meanwhile, the file for the 1867 election contains columns for “AntiConfed”, “Con”, “Lib”, “Other”, and “PC”.

The names used as column headers is the party_short_name found in party_summary.csv.

The columns for each party are followed by three more headed “1st”, “2nd”, and “3rd”. The give the party short name of the party with the most votes, the second most votes, and the third most votes.

  1. by_riding_1867.csv
  2. by_riding_1872.csv
  3. by_riding_1874.csv
  4. by_riding_1878.csv
  5. by_riding_1882.csv
  6. by_riding_1887.csv
  7. by_riding_1891.csv
  8. by_riding_1896.csv
  9. by_riding_1900.csv
  10. by_riding_1904.csv
  11. by_riding_1908.csv
  12. by_riding_1911.csv
  13. by_riding_1917.csv
  14. by_riding_1921.csv
  15. by_riding_1925.csv
  16. by_riding_1926.csv
  17. by_riding_1930.csv
  18. by_riding_1935.csv
  19. by_riding_1940.csv
  20. by_riding_1945.csv
  21. by_riding_1949.csv
  22. by_riding_1953.csv
  23. by_riding_1957.csv
  24. by_riding_1958.csv
  25. by_riding_1962.csv
  26. by_riding_1963.csv
  27. by_riding_1965.csv
  28. by_riding_1968.csv
  29. by_riding_1972.csv
  30. by_riding_1974.csv
  31. by_riding_1979.csv
  32. by_riding_1980.csv
  33. by_riding_1984.csv
  34. by_riding_1988.csv
  35. by_riding_1993.csv
  36. by_riding_1997.csv
  37. by_riding_2000.csv
  38. by_riding_2004.csv
  39. by_riding_2006.csv
  40. by_riding_2008.csv
  41. by_riding_2011.csv
  42. by_riding_2015.csv
  43. by_riding_2019.csv