Canada's electoral history from 1867 to today

Welcome to PoliCan!

by Maurice Y. Michaud (he/him)

YVote!ou have reached what is without any doubt the largest and most complete database on all federal and provincial or territorial general elections, by-elections and referendums ever held in Canada. Whether you are an historian, a political or social scientist, a teacher, a student, a politician, a statistical "quant jock," or a citizen who like me admits to being a fan of Canadian or Quebec politics, this website is sure to engage you in hours of exploration — or will quickly give you the answer to that nagging question that brought you here in the first place, like: "When, where and for which party did Uncle Charlie run and didn't only get defeated but was completely humiliated ?" (True story, by the way...)

This project started in different forms decades ago when, like many other Canadians, I would ask myself all sorts of questions about our electoral system, like:

  • How can a party form a "majority" government when it only obtained about 37 percent of the popular vote?
  • Are deaths in office more or less frequent today?
  • Do we have more by-elections today or were they more frequent in the past?
  • Is winning an election by acclamation a common occurrence today and has it ever been?
  • Besides unopposed races, has anyone ever run for office and received precisely zero vote? (The answer is a qualified Yes.)
  • What maneuverings have led us to have a political party with the oximoron of a name like "Progressive Conservative"?
  • Why does Party A consistently win so few seats while Party B always gets so many more with roughly the same number of votes or sometimes even far fewer?
  • This Maurice guy certainly asks himself a lot of questions, doesn't he?
It is especially that second-to-last question that has led to the current version of this project that you see here today. It sparked in me a keen interest (to not say an obsession) in proportional electoral systems. Quickly understanding that any such system was not as simple as taking the percentage of votes and translating that same percentage into seats, I resolved to select a few recent elections and come up with a more sophisticated simulator that would take the actual riding-by-riding results to consider alternate outcomes had these elections been held using one of the successful proportional systems elsewhere in the world (that is, a system that is NOT like the one in Italy or Israel — the systems that are always cited as examples by opponents of proportional representation).

However, those who know me well also know how easily I can succumb to the idea of diving into a seemingly impossible big project. As I often joke, "Why make simple what can be made complicated?" Closer to the truth, though, is that I got absorbed in reading about more than 150 years of Canadian electoral history. In so doing, I discovered that how our electoral system works now is not how it has always worked. I met some fascinating political figures I had never heard about, from a mass murder to people out on their luck, or from people dying while in office or in unusual circumstances to others who are or were extremely unsuccessful perennial candidates. I had to concede that some politicians I considered ignoble had in fact several redeeming qualities while others I revered had nasty flaws I didn't suspect. And you know what? Switching party loyalties is not a phenomenon invented just yesterday.

But what really made this project take so much expansion is that I became frustrated with the need to consult so many sources presenting similar data but each in its own way, ranging from online databases with their own organization and navigational schemes (that are often clunky and assume either some prior knowledge of the dataset or that one is only interested in their own riding) and PDF documents bringing information together in every way imaginable, right up to those good old-fashioned hard copies obtained from legislative libraries. In fact, there are mostly two official sources for each province and territory plus two at the federal level — the independent non-partisan agency that runs elections in the jurisdiction, and the jurisdiction's legislative library — not to mention that today there are more unofficial yet reliable online sources than there were when I started this project. So I ask: Who exactly is the one who's making things complicated?

That is how I gradually went from a few selected elections, to all general elections federally and in selected provinces since Canada's centennial year, to every single electoral event since Canadian Confederation in 1867. While, on the back end, the data is organized by jurisdiction and event, they can be uncovered through a variety of points of entry. For instance, if many years ago your great-grandfather Murdoch ran in a federal or provincial election (not sure which level), knowing his name should be enough to find him.

If you are wondering what is the size of this database in technical terms, this short table sums it up.
Tables 20
Records 467,845
Result Records 132,157
Data Points 6,462,254
Weight 32.77 MB
Database (relational)
A collection of "data items" with relationships between them, where these items are organized in a set of tables. Think of a table as a spreadsheet: the intersections of the rows and columns form cells, and the cells in each column contain similar items. Two tables can then be joined during a database query if they have a column of items in common. Example: In the table listing all the elections, one row describes a specific by-election and one of the cells in that row indicates the number of the jurisdiction where the by-election was held ( J ). In another table listing the jurisdictions, the row numbered J describes that jurisdiction. Since the two tables can be joined on that common item, the row in the first table contains only items specific to that by-election and none about the jurisdiction.

Tables
As defined in "Database (relational)," a table is the equivalent of a spreadsheet designed to receive a set of related data items.

Records
For all practical purposes, a record is one row in a table.

Result Records
A record found specifically in the results table to take note of the number of votes a candidate received, the riding in which they ran, their political allegiance, if they won that race, etc. If a candidate ran seven times, they have a total of seven result records in this database.

Data Points
For all practical purposes, a data point is the content of one cell — in other words, at the intersection of a row and a column.

Weight
The number of megabytes that the data occupy. It should be noted that all these data are non-formatted plain text and thus very light on their own. This weight does not include that of the files developed to maintain and present the data.

It may seem astonishing to you that one person, alone and without pay, could have managed to cobble together all these data, and in two languages at that! Truth be told, it has taken me years in spurts and bursts, for I do have a full-time job aside from this project. That being said, the restrictions on activities imposed by the COVID-19 pandemic have certainly helped me push this project over the finish line — except it will never really be finished as long as Canada and its provinces and territories continue to have democratic elections. And while I'm optimistic by nature, what jumps out at me are the data that are missing.

For instance, it is often easier to find the birth and death dates of people elected 50 years ago or more than it is for those elected in the past decade or so. Given that the majority of the latter are still alive, I figure that it might just be a simple matter of contacting them (or people who know them) even though they are legion! On the other hand, there are those who got elected many years ago for one or two short terms in a legislature but who clearly must have been quiet backbenchers, for practically nothing seems to be known about them today. And, alas, along with life comes death: every day I check on those surviving former parliamentarians who are supposedly celebrating their birthday on that day to see if indeed they made it to another year. Even with that, during another routine check in early March 2022, I found that the sources on a member of parliament I thought was still alive had recently been updated to indicate that he had in fact been dead for more than 25 years!

That is why I will soon be inaugurating a members' area to the website — The Friends of PoliCan — to help me research those "elusives," to signal any mistake in the existing data, and to be on the lookout for sudden resignations or any changes of allegiance of sitting parliamentarians, or the passing of former ones. After all, I think I can safely say that I have already done (and will continue to do) more than my fair share, so I certainly wouldn't refuse some help at this point to make this resource even more complete and accurate.

So go on now! Go find what you came here to find. It shouldn't take you too long.



© 2021, 2022 Maurice Y. Michaud :: PoliCan.ca
Pub.: 23 Dec 2021 00:01
Rev.: 25 Jun 2022 09:41 (but data revised dynamically)