How to compare the voting records of incumbent Toronto city councillor candidates

The sudden reorganization of Toronto City Council from 47 wards into only 25 creates a situation where there are multiple incumbents running in some wards.

We are accustomed to the situation of one incumbent running in a ward. We keep an eye on the world of our incumbent councillor over their term and get a sense of their work and their voting patterns, especially on issues that are important to us.  We keep in mind what works and where there's room for improvement and compare all this with the platforms of the challengers running in our ward, as well as using it to evaluate the incumbent's re-election platform.

Having two incumbent candidates in a ward complicates things. Now two of the candidates have a voting patterns and a record of constituency work, but one of them we haven't been paying nearly as much attention to, since, up until now, they were irrelevant to our everyday issues and our voting decisions.

It would be foolish to disregard the record of the incumbent with whom we're less familiar, but it also takes a lot of work to familiarize ourselves with their years and years of council votes.

However, a more efficient way to do so is to compare the voting records of the two incumbent candidates and see where they differ. After all,  there's no point in focusing your time and energy on areas where they're in agreement - your existing assessment of whether your incumbent should be voted for or against will do the job there.

Here's a quick and easy way to make this comparison*:

Go to Matt Elliott's City Council Scorecard. This spreadsheet has one row for each councillor, and as your scroll rightwards you can see how they've voted on every vote, colour-coded for your convenience.

When you find a column where your two incumbents voted differently, simply look at the top row to see what the issue was.

This way you can quickly and easily scroll through years of votes to see where there are areas of difference requiring further examination.

(Here is a link to primary source data about councillor's voting records, which is far less user-friendly, but can be downloaded in .csv format if you prefer to do your own data manipulations.)

*Credit for this idea goes to the author of this comparison of Ward 12 candidates Josh Matlow and Joe Mihevic, which reached me via a tweet from Adam Chaleff. I'm under the impression that the author of this comparison wishes to remain anonymous, but if you are the author and you want credit, let me know in the comments.  And, of course, Matt Elliott gets credit for the mindblowingly helpful scorecard spreadsheet.