An analysis of how often parties in Canadian Parliament work together, and how often members from a party vote against their own party
Copyable Google Sheet: https://docs.google.com/spreadsheets/d/16l74_p13UGMySpOqMXUJG-KDwtz5gGEoXiXVFyZqTLA/edit?usp=sharing
The headers of the Google Sheet are the following: Date,Parliament Number,Session Number,Decision Number,Result,Decision Type,Decision Subject,Num Yeas,Num Nays,Num Paired,Conservative Yeas,Conservative Nays,Liberal Yeas,Liberal Nays,NDP Yeas,NDP Nays,Green Yeas,Green Nays,Bloc Yeas,Bloc Nays,URL,Conservative Defections,Liberal Defections,Ndp Defections,Green Defections,Bloc Defections,Conservative-Liberal Coalition,Conservative-Ndp Coalition,Conservative-Green Coalition,Conservative-Bloc Coalition,Liberal-Ndp Coalition,Liberal-Green Coalition,Liberal-Bloc Coalition,Ndp-Green Coalition,Ndp-Bloc Coalition,Green-Bloc Coalition,Conservative-Liberal-Ndp Coalition,Conservative-Liberal-Green Coalition,Conservative-Liberal-Bloc Coalition,Conservative-Ndp-Green Coalition,Conservative-Ndp-Bloc Coalition,Conservative-Green-Bloc Coalition,Liberal-Ndp-Green Coalition,Liberal-Ndp-Bloc Coalition,Liberal-Green-Bloc Coalition,Ndp-Green-Bloc Coalition
A defection is described as the case where the members of one party were split on a decision. For example, it 170 Liberals vote Yea and 7 vote Nay then the column Liberal Defections will have a "1" indicating that there was a defection
A coalition is described as when the majority of two or more parties all vote Yea. For example, if the Conservatives vote Yea 50-49 and the Bloc votes Yea 20-10 then there will be a 1 in the Conservative-Bloc Coalition column. If the Greens also voted Yea 5-4 then the Green-Bloc Coalition and Conservative-Green Coalition columns will also have a 1. If the Liberals in this same vote voted Nay 85-84, then they would not count as a member of the coalition.
