Voted yes

2d:null 2e:["$","title",null,{"children":"Chicago City Council Budget Votes | Patrick Sier | Observable"}] 33:T5d3,table = html` ${styles}

${voteCols.map(vote => { const yesVotes = officials.filter(o => o[vote] === "Y").length; const totalVotes = officials.length; return html` ${officials.map(({ name, lastName, ward, ...official }) => { const yesVotes = voteCols.filter(vote => official[vote] === "Y").length; const totalVotes = voteCols.filter(vote => vote in official).length; return html` ${voteCols.map( (vote, idx) => html`` )} `; })}

	${vote.replace("vote", "")} ${ officials.filter(o => o[vote] === "Y").length }/${officials.filter(o => vote in o).length} `; })}
${lastName} ${name} ${ward}${nth(+ward)} Ward ${yesVotes}/${totalVotes}	${ vote in official ? voteSymbol({ vote: official[vote] }) : `` }

`34:Taef,styles = html``35:T71b,voteSymbol = ({ vote, attrs = {} }) => { let symbolEl = html``; if (vote === "Y") { symbolEl = html``; } else if (vote === "N") { symbolEl = html``; } else if (vote === "D" || vote === "" || vote === "A") { symbolEl = html``; } else { return html``; } Object.keys(attrs).forEach(key => { const val = attrs[key]; if (val != null) symbolEl.setAttribute(key, val); }); return symbolEl; }36:T2b38,officials = [ { ward: "1", name: "Daniel La Spata", lastName: "La Spata", vote2021: "N", vote2020: "N" }, { ward: "2", name: "Brian Hopkins", lastName: "Hopkins", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N" }, { ward: "3", name: "Pat Dowell", lastName: "Dowell", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "N" }, { ward: "4", name: "Sophia King", lastName: "King", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y" }, { ward: "5", name: "Leslie A. Hairston", lastName: "Hairston", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "N", vote2010: "Y" }, { ward: "6", name: "Roderick Sawyer", lastName: "Sawyer", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "7", name: "Gregory I. Mitchell", lastName: "Mitchell", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "8", name: "Michelle A. Harris", lastName: "Harris", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "9", name: "Anthony Beale", lastName: "Beale", vote2021: "N", vote2020: "N", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "10", name: "Susan Sadlowski Garza", lastName: "Sadlowski Garza", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "A" }, { ward: "11", name: "Patrick D. Thompson", lastName: "Thompson", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "12", name: "George A. Cardenas", lastName: "Cardenas", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "13", name: "Marty Quinn", lastName: "Quinn", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "14", name: "Edward M. Burke", lastName: "Burke", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "15", name: "Raymond A. Lopez", lastName: "Lopez", vote2021: "N", vote2020: "N", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "16", name: "Stephanie D. Coleman", lastName: "Coleman", vote2021: "Y", vote2020: "Y" }, { ward: "17", name: "David Moore", lastName: "Moore", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "18", name: "Derrick G. Curtis", lastName: "Curtis", vote2021: "Y", vote2020: "Y", vote2019: "A", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "19", name: "Matthew O'Shea", lastName: "O'Shea", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "20", name: "Jeanette B. Taylor", lastName: "Taylor", vote2021: "N", vote2020: "N" }, { ward: "21", name: "Howard Brookins Jr.", lastName: "Brookins", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "A", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "22", name: "Michael D. Rodriguez", lastName: "Rodriguez", vote2021: "Y", vote2020: "N" }, { ward: "23", name: "Silvana Tabares", lastName: "Tabares", vote2021: "N", vote2020: "Y", vote2019: "Y" }, { ward: "24", name: "Michael Scott Jr.", lastName: "Scott", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "25", name: "Byron Sigcho Lopez", lastName: "Sigcho Lopez", vote2021: "N", vote2020: "N" }, { ward: "26", name: "Roberto Maldonado", lastName: "Maldonado", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "27", name: "Walter Burnett, Jr.", lastName: "Burnett", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "28", name: "Jason Ervin", lastName: "Ervin", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "29", name: "Christopher Taliaferro", lastName: "Taliaferro", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N" }, { ward: "30", name: "Ariel E. Reboyras", lastName: "Reboyras", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "31", name: "Felix Cardona, Jr.", lastName: "Cardona", vote2021: "Y", vote2020: "Y" }, { ward: "32", name: "Scott Waguespack", lastName: "Waguespack", vote2021: "Y", vote2020: "Y", vote2019: "N", vote2018: "N", vote2017: "Y", vote2016: "N", vote2015: "N", vote2014: "N", vote2013: "N", vote2012: "Y", vote2011: "N", vote2010: "N" }, { ward: "33", name: "Rossana Rodriguez Sanchez", lastName: "Rodriguez Sanchez", vote2021: "N", vote2020: "N" }, { ward: "34", name: "Carrie M. Austin", lastName: "Austin", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "A", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "35", name: "Carlos Ramirez-Rosa", lastName: "Ramirez-Rosa", vote2021: "N", vote2020: "N", vote2019: "Y", vote2018: "N", vote2017: "Y", vote2016: "N" }, { ward: "36", name: "Gilbert Villegas", lastName: "Villegas", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "Y", vote2014: "N" }, { ward: "37", name: "Emma Mitts", lastName: "Mitts", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "Y" }, { ward: "38", name: "Nicholas Sposato", lastName: "Sposato", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y" }, { ward: "39", name: "Samantha Nugent", lastName: "Nugent", vote2021: "Y", vote2020: "Y" }, { ward: "40", name: "André Vasquez, Jr.", lastName: "Vasquez", vote2021: "Y", vote2020: "N" }, { ward: "41", name: "Anthony V. Napolitano", lastName: "Napolitano", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N" }, { ward: "42", name: "Brendan Reilly", lastName: "Reilly", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "N", vote2010: "N" }, { ward: "43", name: "Michele Smith", lastName: "Smith", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "44", name: "Thomas M. Tunney", lastName: "Tunney", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y", vote2011: "Y", vote2010: "N" }, { ward: "45", name: "James M. Gardiner", lastName: "Gardiner", vote2021: "N", vote2020: "Y" }, { ward: "46", name: "James Cappleman", lastName: "Cappleman", vote2021: "Y", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "Y", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "47", name: "Matthew J. Martin", lastName: "Martin", vote2021: "N", vote2020: "N" }, { ward: "48", name: "Harry Osterman", lastName: "Osterman", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "Y", vote2014: "Y", vote2013: "Y", vote2012: "Y" }, { ward: "49", name: "Maria E. Hadden", lastName: "Hadden", vote2021: "Y", vote2020: "N" }, { ward: "50", name: "Debra Silverstein", lastName: "Silverstein", vote2021: "N", vote2020: "Y", vote2019: "Y", vote2018: "Y", vote2017: "Y", vote2016: "N", vote2015: "N", vote2014: "Y", vote2013: "Y", vote2012: "Y" } ]37:Tcef,councilData = [ { name: "Daniel La Spata", lastName: "La Spata", ward: "1" }, { name: "Brian Hopkins", lastName: "Hopkins", ward: "2" }, { name: "Pat Dowell", lastName: "Dowell", ward: "3" }, { name: "Sophia King", lastName: "King", ward: "4" }, { name: "Leslie A. Hairston", lastName: "Hairston", ward: "5" }, { name: "Roderick Sawyer", lastName: "Sawyer", ward: "6" }, { name: "Gregory I. Mitchell", lastName: "Mitchell", ward: "7" }, { name: "Michelle A. Harris", lastName: "Harris", ward: "8" }, { name: "Anthony Beale", lastName: "Beale", ward: "9" }, { name: "Susan Sadlowski Garza", lastName: "Sadlowski Garza", ward: "10" }, { name: "Patrick D. Thompson", lastName: "Thompson", ward: "11" }, { name: "George A. Cardenas", lastName: "Cardenas", ward: "12" }, { name: "Marty Quinn", lastName: "Quinn", ward: "13" }, { name: "Edward M. Burke", lastName: "Burke", ward: "14" }, { name: "Raymond A. Lopez", lastName: "Lopez", ward: "15" }, { name: "Stephanie D. Coleman", lastName: "Coleman", ward: "16" }, { name: "David Moore", lastName: "Moore", ward: "17" }, { name: "Derrick G. Curtis", lastName: "Curtis", ward: "18" }, { name: "Matthew O'Shea", lastName: "O'Shea", ward: "19" }, { name: "Jeanette B. Taylor", lastName: "Taylor", ward: "20" }, { name: "Howard Brookins Jr.", lastName: "Brookins", ward: "21" }, { name: "Michael D. Rodriguez", lastName: "Rodriguez", ward: "22" }, { name: "Silvana Tabares", lastName: "Tabares", ward: "23" }, { name: "Michael Scott Jr.", lastName: "Scott", ward: "24" }, { name: "Byron Sigcho Lopez", lastName: "Sigcho Lopez", ward: "25" }, { name: "Roberto Maldonado", lastName: "Maldonado", ward: "26" }, { name: "Walter Burnett, Jr.", lastName: "Burnett", ward: "27" }, { name: "Jason Ervin", lastName: "Ervin", ward: "28" }, { name: "Christopher Taliaferro", lastName: "Taliaferro", ward: "29" }, { name: "Ariel E. Reboyras", lastName: "Reboyras", ward: "30" }, { name: "Felix Cardona, Jr.", lastName: "Cardona", ward: "31" }, { name: "Scott Waguespack", lastName: "Waguespack", ward: "32" }, { name: "Rossana Rodriguez Sanchez", lastName: "Rodriguez Sanchez", ward: "33" }, { name: "Carrie M. Austin", lastName: "Austin", ward: "34" }, { name: "Carlos Ramirez-Rosa", lastName: "Ramirez-Rosa", ward: "35" }, { name: "Gilbert Villegas", lastName: "Villegas", ward: "36" }, { name: "Emma Mitts", lastName: "Mitts", ward: "37" }, { name: "Nicholas Sposato", lastName: "Sposato", ward: "38" }, { name: "Samantha Nugent", lastName: "Nugent", ward: "39" }, { name: "André Vasquez, Jr.", lastName: "Vasquez", ward: "40" }, { name: "Anthony V. Napolitano", lastName: "Napolitano", ward: "41" }, { name: "Brendan Reilly", lastName: "Reilly", ward: "42" }, { name: "Michele Smith", lastName: "Smith", ward: "43" }, { name: "Thomas M. Tunney", lastName: "Tunney", ward: "44" }, { name: "James M. Gardiner", lastName: "Gardiner", ward: "45" }, { name: "James Cappleman", lastName: "Cappleman", ward: "46" }, { name: "Matthew J. Martin", lastName: "Martin", ward: "47" }, { name: "Harry Osterman", lastName: "Osterman", ward: "48" }, { name: "Maria E. Hadden", lastName: "Hadden", ward: "49" }, { name: "Debra Silverstein", lastName: "Silverstein", ward: "50" } ]38:[] 31:{"id":"38c39df5b38c0883","slug":"chicago-city-council-budget-votes","title":"Chicago City Council Budget Votes","thumbnail":"44806b805d97137604f17c26a990bc4d03bec554fb48237f52e21a2ba9642b65","access_level":"public","create_time":"$D2020-10-20T16:07:30.979Z","update_time":"$D2020-11-24T20:18:28.469Z","view_time":null,"first_public_time":"$D2020-10-29T21:27:30.030Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"131ebbed378efb4e","login":"pjsier","name":"Patrick Sier","avatar_url":"https://avatars-next.observableusercontent.com/1b88cd4161cba2dad3bf87cbb75ae3bed18489a962e046eb6b5c3d920631b97f","tier":"starter_2024"},"version":534,"publish_version":534,"role":null,"authored":false,"authors":[{"type":"individual","id":"9b8fd2b6e2488e83","login":"pjsier","name":"Patrick Sier","avatar_url":"https://avatars-next.observableusercontent.com/1b88cd4161cba2dad3bf87cbb75ae3bed18489a962e046eb6b5c3d920631b97f","tier":null}],"members":[{"type":"individual","id":"9b8fd2b6e2488e83","login":"pjsier","name":"Patrick Sier","avatar_url":"https://avatars-next.observableusercontent.com/1b88cd4161cba2dad3bf87cbb75ae3bed18489a962e046eb6b5c3d920631b97f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"fa9f97d3be3cc07d","slug":"city-bureau","title":"City Bureau","owner":{"id":"131ebbed378efb4e","login":"pjsier","name":"Patrick Sier"}},"type":"notebook","body":{"title":"Chicago City Council Budget Votes","cells":[{"id":0,"value":"md`# Chicago City Council Budget Votes`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"nth = function(n) {\n return [\"st\", \"nd\", \"rd\"][((((n + 90) % 100) - 10) % 10) - 1] || \"th\";\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"voteCols = [...new Set(officials.map(official => Object.keys(official)).flat())]\n .filter(key => key.includes(\"vote\"))\n .sort()\n .reverse()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 32:"$31:body"