Mandate letter commitments - Results
Dmitry Gorodnichy
November 7, 2018
Quick visual analysis of “Mandate letter commitments - Results”" Dataset downloaded from https://open.canada.ca/data/en/dataset/8f6b5490-8684-4a0d-91a3-97ba28acc9cd.
Seehttps://www.canada.ca/en/privy-council/campaigns/mandate-tracker-results-canadians.html?utm_campaign=not-applicable&utm_medium=vanity-url&utm_source=canada-ca_results for more details
Inputs and Outputs
## Warning: package 'data.table' was built under R version 3.4.4## Warning: package 'stringr' was built under R version 3.4.4## [1] 2917 8## [1] "Updated as of" "ID" "Priority"
## [4] "Commitment" "Minister" "Status"
## [7] "Results.Statement" "Comment"## 1Updated as of[1] "11/1/2017" "12/1/2017" "1/31/2018" "2/28/2018" "3/31/2018" "4/30/2018"
## [7] "5/31/2018" "6/30/2018"
## 2ID [1] "122" "116" "117" "118" "121" "123" "124" "125"
## [9] "312" "231" "131" "126" "130" "127" "128" "16"
## [17] "81" "82" "83" "84" "87" "88" "227" "86"
## [25] "89" "80" "365" "366" "190" "363" "364" "198"
## [33] "199" "367" "368" "369" "370" "375" "191" "362"
## [41] "215" "355" "201" "200" "204" "202" "203" "250"
## [49] "329" "252" "257_2" "256" "235" "313" "144" "253"
## [57] "146" "148" "149" "150" "152" "153" "154" "155"
## [65] "157" "251" "307" "158" "145" "238" "305" "151"
## [73] "214" "223" "255" "159" "254" "14" "39" "41"
## [81] "42" "43" "45" "46" "47" "48" "50" "219"
## [89] "39_1" "51" "5" "49" "309" "139" "142" "143"
## [97] "315" "140" "141" "168" "237" "316" "317" "318"
## [105] "319" "320" "325" "326" "327" "331" "175_1" "169"
## [113] "239" "234" "240" "240_1" "170" "9" "177" "174"
## [121] "90" "90_1" "171" "173" "178" "179" "180" "181"
## [129] "328" "241" "236" "321" "322" "22" "37" "222"
## [137] "205" "207" "68" "73" "74" "75" "296" "76"
## [145] "220" "52" "7" "44" "17" "264" "162" "163"
## [153] "164" "167" "259" "263" "265" "166" "260" "261"
## [161] "161" "262" "85" "69" "160" "77" "79" "77_4"
## [169] "77_1" "78" "270" "271" "272" "334" "335" "336"
## [177] "337" "338" "339" "340" "341" "77_2" "77_3" "225"
## [185] "342" "217" "67" "276" "61" "63" "274" "62"
## [193] "64" "66" "72" "273" "275" "332" "70" "65"
## [201] "277" "311" "60" "373" "374" "192" "371" "372"
## [209] "197" "115" "196" "194" "175" "244" "189" "228"
## [217] "193" "245" "195" "18" "19" "23" "20" "299"
## [225] "26" "298" "21" "53" "55" "54" "56" "57"
## [233] "58" "59" "221" "280" "182" "186" "183" "184"
## [241] "187" "188" "278" "279" "281" "282" "283" "129"
## [249] "38" "32" "35" "31" "300" "36" "376" "216"
## [257] "232" "285" "137" "135" "133" "134" "136" "286"
## [265] "233" "132" "7_1" "230" "247" "248" "1" "246"
## [273] "249" "2" "3" "4" "206" "14_1" "226" "108"
## [281] "111" "112" "113" "109" "218" "110" "348" "349"
## [289] "350" "351" "352" "8" "6" "347" "353" "354"
## [297] "356" "357" "156" "324" "208" "24" "25" "27"
## [305] "29" "28" "30" "172" "91" "377" "92" "361"
## [313] "358" "359" "242" "224" "360" "94" "93" "114"
## [321] "287" "288" "289" "290" "291" "297" "257" "257_1"
## [329] "15" "213" "212" "101" "102" "95" "96" "97"
## [337] "98" "99" "100" "103" "104" "105" "106" "107"
## [345] "343" "344" "345" "346" "101_1" "95_1" "229" "10"
## [353] "11" "13" "120" "292" "293" "295" "294" "209"
## [361] "330" "211" "119" "12" "210" "308"
## 3Priority [1] "Fair and Open Government"
## [2] "Safety and Security"
## [3] "Environment and Climate Change"
## [4] "Exports and Investment"
## [5] "Government Services and Operations"
## [6] "Healthy Canadians"
## [7] "Jobs and Innovation"
## [8] "Diverse and Inclusive Canada"
## [9] "Indigenous peoples"
## [10] "Strong Middle Class"
## [11] "Canada in the World"
## [12] "Sustainable Infrastructure"
## 5Minister [1] "Leader of the Government in the House of Commons"
## [2] "Leader of the Government in the House of Commons;Minister of Public Safety and Emergency Preparedness"
## [3] "Minister of Agriculture and Agri-Food"
## [4] "Minister of Agriculture and Agri-Food;Minister of Transport"
## [5] "Minister of Canadian Heritage"
## [6] "Minister of Canadian Heritage;Minister of Justice and Attorney General of Canada"
## [7] "Minister of Canadian Heritage;Minister of Sport and Persons With Disabilities"
## [8] "Minister of Crown-Indigenous Relations and Northern Affairs"
## [9] "Minister of Crown-Indigenous Relations and Northern Affairs;Minister of Indigenous Services"
## [10] "Minister of Crown-Indigenous Relations and Northern Affairs;Minister of Justice and Attorney General of Canada;Minister of Status of Women"
## [11] "Minister of Crown-Indigenous Relations and Northern Affairs;Minister of Public Services and Procurement"
## [12] "Minister of Democratic Institutions"
## [13] "Minister of Employment, Workforce Development and Labour"
## [14] "Minister of Employment, Workforce Development and Labour;Minister of Families, Children and Social Development"
## [15] "Minister of Employment, Workforce Development and Labour;Minister of Immigration, Refugees and Citizenship"
## [16] "Minister of Employment, Workforce Development and Labour;Minister of Indigenous Services"
## [17] "Minister of Employment, Workforce Development and Labour;Minister of Indigenous Services;Minister of Innovation, Science and Economic Development"
## [18] "Minister of Employment, Workforce Development and Labour;Minister of International Development and La Francophonie"
## [19] "Minister of Employment, Workforce Development and Labour;Minister of Public Services and Procurement"
## [20] "Minister of Employment, Workforce Development and Labour;Minister of Science"
## [21] "Minister of Employment, Workforce Development and Labour;Minister of Status of Women"
## [22] "Minister of Employment, Workforce Development and Labour;President of the Treasury Board;Minister of Status of Women;Leader of the Government in the House of Commons"
## [23] "Minister of Environment and Climate Change"
## [24] "Minister of Environment and Climate Change;Minister of Finance"
## [25] "Minister of Environment and Climate Change;Minister of Finance;Minister of Crown-Indigenous Relations and Northern Affairs"
## [26] "Minister of Environment and Climate Change;Minister of Fisheries, Oceans and the Canadian Coast Guard"
## [27] "Minister of Environment and Climate Change;Minister of Foreign Affairs;Minister of Natural Resources"
## [28] "Minister of Environment and Climate Change;Minister of Small Business and Tourism"
## [29] "Minister of Families, Children and Social Development"
## [30] "Minister of Families, Children and Social Development;Minister of Employment, Workforce Development and Labour"
## [31] "Minister of Families, Children and Social Development;Minister of Finance"
## [32] "Minister of Families, Children and Social Development;Minister of Indigenous Services;Minister of Status of Women"
## [33] "Minister of Families, Children and Social Development;Minister of Infrastructure and Communities"
## [34] "Minister of Families, Children and Social Development;Minister of Status of Women"
## [35] "Minister of Families, Children and Social Development;President of the Treasury Board;Minister of Public Services and Procurement;Minister of Democratic Institutions"
## [36] "Minister of Finance"
## [37] "Minister of Finance;Minister of Crown-Indigenous Relations and Northern Affairs"
## [38] "Minister of Finance;Minister of Employment, Workforce Development and Labour"
## [39] "Minister of Finance;Minister of Families, Children and Social Development"
## [40] "Minister of Finance;Minister of Innovation, Science and Economic Development"
## [41] "Minister of Finance;Minister of International Development and La Francophonie;Minister of International Trade"
## [42] "Minister of Finance;Minister of Justice and Attorney General of Canada;Minister of National Revenue"
## [43] "Minister of Finance;Minister of Natural Resources"
## [44] "Minister of Fisheries, Oceans and the Canadian Coast Guard"
## [45] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Environment and Climate Change"
## [46] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Environment and Climate Change;Minister of Science"
## [47] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Innovation, Science and Economic Development;Minister of Public Services and Procurement;Minister of National Defence"
## [48] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Natural Resources;Minister of Environment and Climate Change;Minister of Science;Minister of Crown-Indigenous Relations and Northern Affairs"
## [49] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Public Services and Procurement;Minister of Innovation, Science and Economic Development"
## [50] "Minister of Fisheries, Oceans and the Canadian Coast Guard;Minister of Transport"
## [51] "Minister of Foreign Affairs"
## [52] "Minister of Foreign Affairs;Minister of Canadian Heritage;Minister of International Trade"
## [53] "Minister of Foreign Affairs;Minister of Immigration, Refugees and Citizenship"
## [54] "Minister of Foreign Affairs;Minister of International Trade"
## [55] "Minister of Health"
## [56] "Minister of Health;Minister of Crown-Indigenous Relations and Northern Affairs"
## [57] "Minister of Health;Minister of Crown-Indigenous Relations and Northern Affairs;Minister of Indigenous Services"
## [58] "Minister of Health;Minister of Public Safety and Emergency Preparedness;Minister of Justice and Attorney General of Canada"
## [59] "Minister of Immigration, Refugees and Citizenship"
## [60] "Minister of Immigration, Refugees and Citizenship;Minister of Employment, Workforce Development and Labour"
## [61] "Minister of Immigration, Refugees and Citizenship;Minister of International Development and La Francophonie"
## [62] "Minister of Indigenous Services"
## [63] "Minister of Infrastructure and Communities"
## [64] "Minister of Infrastructure and Communities;Minister of Agriculture and Agri-Food;Minister of Transport"
## [65] "Minister of Infrastructure and Communities;Minister of Canadian Heritage;Minister of Sport and Persons With Disabilities"
## [66] "Minister of Infrastructure and Communities;Minister of Finance"
## [67] "Minister of Infrastructure and Communities;Minister of Indigenous Services"
## [68] "Minister of Infrastructure and Communities;Minister of Indigenous Services;Minister of Status of Women"
## [69] "Minister of Infrastructure and Communities;Minister of Transport"
## [70] "Minister of Infrastructure and Communities;Minister of Transport;Minister of Environment and Climate Change"
## [71] "Minister of Innovation, Science and Economic Development"
## [72] "Minister of Innovation, Science and Economic Development;Minister of Science"
## [73] "Minister of Innovation, Science and Economic Development;Minister of Small Business and Tourism"
## [74] "Minister of Innovation, Science and Economic Development;Minister of Small Business and Tourism;Minister of International Trade"
## [75] "Minister of International Development and La Francophonie"
## [76] "Minister of International Development and La Francophonie;Minister of Foreign Affairs"
## [77] "Minister of International Trade"
## [78] "Minister of International Trade;Minister of Agriculture and Agri-Food"
## [79] "Minister of Justice and Attorney General of Canada"
## [80] "Minister of Justice and Attorney General of Canada;Minister of Public Safety and Emergency Preparedness"
## [81] "Minister of National Defence"
## [82] "Minister of National Defence;Minister of Foreign Affairs"
## [83] "Minister of National Defence;Minister of Public Services and Procurement"
## [84] "Minister of National Defence;Minister of Public Services and Procurement; Minister of Innovation, Science and Economic Development"
## [85] "Minister of National Defence;Minister of Veterans Affairs"
## [86] "Minister of National Revenue"
## [87] "Minister of Natural Resources"
## [88] "Minister of Natural Resources;Minister of Innovation, Science and Economic Development;Minister of Agriculture and Agri-Food;Minister of International Trade"
## [89] "Minister of Public Safety and Emergency Preparedness"
## [90] "Minister of Public Safety and Emergency Preparedness;Minister of Infrastructure and Communities;Minister of Innovation, Science and Economic Development;Minister of National Defence;Minister of Democratic Institutions"
## [91] "Minister of Public Safety and Emergency Preparedness;Minister of Justice and Attorney General of Canada"
## [92] "Minister of Public Services and Procurement"
## [93] "Minister of Public Services and Procurement;Minister of Employment, Workforce Development and Labour"
## [94] "Minister of Public Services and Procurement;Minister of Families, Children and Social Development"
## [95] "Minister of Public Services and Procurement;Minister of National Defence"
## [96] "Minister of Science"
## [97] "Minister of Small Business and Tourism"
## [98] "Minister of Sport and Persons With Disabilities"
## [99] "Minister of Sport and Persons With Disabilities;Minister of Families, Children and Social Development"
## [100] "Minister of Sport and Persons With Disabilities;Minister of Health"
## [101] "Minister of Sport and Persons With Disabilities;Minister of Indigenous Services"
## [102] "Minister of Status of Women"
## [103] "Minister of Status of Women;Minister of Employment, Workforce Development and Labour"
## [104] "Minister of Transport"
## [105] "Minister of Transport;Minister of Fisheries, Oceans and the Canadian Coast Guard"
## [106] "Minister of Veterans Affairs"
## [107] "Minister of Veterans Affairs;Minister of National Defence"
## [108] "President of the Treasury Board"
## [109] "President of the Treasury Board;Minister of Canadian Heritage"
## [110] "President of the Treasury Board;Minister of Finance"
## [111] "President of the Treasury Board;Minister of Finance;Leader of the Government in the House of Commons"
## [112] "President of the Treasury Board;Minister of Innovation, Science and Economic Development"
## [113] "President of the Treasury Board;Minister of Justice and Attorney General of Canada;Minister of Democratic Institutions"
## [114] "President of the Treasury Board;Minister of Public Services and Procurement;Minister of Democratic Institutions"## [1] "Fair and Open Government"
## [2] "Safety and Security"
## [3] "Environment and Climate Change"
## [4] "Exports and Investment"
## [5] "Government Services and Operations"
## [6] "Healthy Canadians"
## [7] "Jobs and Innovation"
## [8] "Diverse and Inclusive Canada"
## [9] "Indigenous peoples"
## [10] "Strong Middle Class"
## [11] "Canada in the World"
## [12] "Sustainable Infrastructure"## Classes 'data.table' and 'data.frame': 2917 obs. of 10 variables:
## $ Updated as of : chr "11/1/2017" "11/1/2017" "11/1/2017" "11/1/2017" ...
## $ ID : chr "122" "116" "117" "118" ...
## $ Priority : chr "Fair and Open Government" "Fair and Open Government" "Fair and Open Government" "Fair and Open Government" ...
## $ Commitment : chr "Ensure that the Parliamentary Budget Officer (PBO) is properly funded and independent of the Government." "Work with Parliamentarians to reform Question Period so that all ministers, including the Prime Minister, are h"| __truncated__ "Promote free votes and limit the circumstances in which Liberal Members of Parliament will be required to vote "| __truncated__ "End the improper use of omnibus bills and prorogation." ...
## $ Minister : chr "Leader of the Government in the House of Commons" "Leader of the Government in the House of Commons" "Leader of the Government in the House of Commons" "Leader of the Government in the House of Commons" ...
## $ Status : chr "Completed - fully met" "Completed - fully met" "Completed - fully met" "Completed - fully met" ...
## $ Results.Statement: chr "The Parliamentary Budget Officer is independent and properly funded to conduct analyses on behalf of Parliament." "Increased accountability of all ministers, including the Prime Minister, during Question Period." "Members of Parliament are strong voices for their communities and there is greater accountability within Parliament." "Measures are in place to end the improper use of omnibus bills and prorogation." ...
## $ Comment : chr "In June 2017, legislation was passed that established the Parliamentary Budget Officer (PBO) as an independent "| __truncated__ "Since April 2017, the Prime Minister has adopted the practice of taking all questions during Wednesday sittings"| __truncated__ "Since Fall 2015, all House of Commons votes have been free votes for Liberal Members of Parliament with the exc"| __truncated__ "In June 2017, the House of Commons adopted a Government motion that changed the Standing Orders to prevent the "| __truncated__ ...
## $ MinisterShort : chr "Leader of the G..." "Leader of the G..." "Leader of the G..." "Leader of the G..." ...
## $ GoC : int 1 1 1 1 1 1 1 1 1 1 ...
## - attr(*, ".internal.selfref")=<externalptr>
## - attr(*, "sorted")= chr "Minister" "Priority"
