31:T87a,{ const displayOrder = [ 'Filed with Secretary of State', 'Chapter Number Assigned', 'Veto Override Vote Mail Poll in Progress', 'Vetoed by Governor', 'Died in Process', 'Died in Standing Committee' ] const data = legislator.bills .sort((a,b) => displayOrder.indexOf(a.lastAction) < displayOrder.indexOf(b.lastAction) ? -1 : 1) .map(bill => { const billCode = bill.bill_id.slice(0,2) const billNum = d3.format('04')(bill.bill_id.slice(3)) const billUrl = `https://leg.mt.gov/bills/2017/billpdf/${billCode}${billNum}.pdf` return { 'Legislator': bill.sponsorName, 'Bill': bill.bill_id, 'Type': bill.type, 'Title': html`${bill.title}`, 'Status': bill.lastAction } }) // return legislator if (data.length > 0) { return table(data,{ style: 'compact', columns: { 'Status': { formatter(val) { let color = '#f8f8f8' if (['Filed with Secretary of State', 'Chapter Number Assigned'].includes(val)) { color = '#c8f4cb' } else if (['Vetoed by Governor','Died in Process','Died in Standing Committee'].includes(val)) { color = '#f4c8cf' } return html`${val}`; } } } }) } else { return md`No bills sponsored by **${legislator.full_name}** in 2017` } } // table(titanicData, { // sortable: true, // columns: { // Fare: { // formatter(val, i) { // // A formatter that changes its behavior based on the row index, // // so we don’t repeat the $ for every row. // return i === 0 ? d3.format('$.2f')(val) : d3.format('.2f')(val); // } // }, // Name: { // formatter(val) { // // Formatters can also return HTML values! Here’s // // one that highlights first names. // let parts = val.match(/([^,]*)\,(.*)/); // return html`${parts[1]}, ${parts[2]}`; // } // } // } // })32:Tc4c,// filtered and cleaned data = { // CLEANING const manualIds = [ {name: 'Frederick (Eric) Moore', id: 'MTL000027'}, {name: 'Carlie Boland', id: 'MTL000412'}, {name: 'Russel (Russ) Tempel', id: "MTL000359"}, {name: 'Jason D Small', id: "MTL000354"}, {name: 'Douglas (Doug) Kary', id: "MTL000093"}, {name: 'Margaret (Margie) MacDonald', id: "MTL000360"}, {name: 'Jeffrey W Welborn', id: "MTL000394"}, {name: 'Jon C Sesso', id: "MTL000133"}, {name: 'Edith (Edie) McClafferty', id: "MTL000401"}, {name: 'Daniel R Salomon', id: "MTL000385"}, {name: 'Denley M Loge', id: "MTL000410"}, {name: 'George G Kipp', id: "MTL000236"}, {name: 'Ross H Fitzgerald', id: "MTL000373"}, {name: 'Bradley Hamlett', id: "MTL000376"}, {name: 'Dan Bartel', id: "MTL000389"}, // 0 bills - TODO, handle exception {name: 'Kenneth L Holmlund', id: "MTL000304"}, {name: 'Donald W Jones', id: "MTL000193"}, {name: 'Dennis R Lenz', id: "MTL000404"}, {name: 'Jon A Knokey', id: "MTL000393"}, {name: 'Ray L Shaw', id: "MTL000217"}, {name: 'Jennifer Eck', id: "MTL000182"}, {name: 'Shane A Morigeau', id: "MTL000407"}, ] manualIds.forEach(d => { rawData.sponsors.filter(bill => bill.name === d.name) .forEach(bill => bill.leg_id = d.id) }) // AGGREGATING const actionsGrouped = d3.nest() .key(d => d.session) .key(d => d.bill_id) .entries(rawData.actions) const votesGrouped = d3.nest() .key(d => d.session) .key(d => d.bill_id) .entries(rawData.billVotes) const bills = rawData.bills .filter(bill => bill.session === '2017') .map(bill => { const sponsor = rawData.sponsors.find(d => (bill.session === d.session) && bill.bill_id === d.bill_id) // const actions = rawData.actions.filter(d => (bill.session === d.session) && bill.bill_id === d.bill_id) const actions = actionsGrouped .find(d => d.key === bill.session).values .find(d => d.key === bill.bill_id).values const votedBill = votesGrouped .find(d => d.key === bill.session).values .find(d => d.key === bill.bill_id) const votes = (votedBill && votedBill.values) || [] // screens for non-voted bills .sort((a,b) => b.date - a.date) return Object.assign(bill, { sponsorName: sponsor.name, sponsorId: sponsor.leg_id, actions: actions, actionCount: actions.length, lastAction: actions.slice(-1)[0].action, votes: votes, lastVote: votes[0], }) }) const legislators = rawData.legislators .filter(leg => leg.active === 'True') .map(leg => { const committees = rawData.roles .filter(d => d.type === 'committee member') .filter(d => d.term === '2017-2018') .filter(d => d.leg_id === leg.leg_id) .map(d => d.committee) return Object.assign(leg, { bills: bills.filter(bill => bill.sponsorId === leg.leg_id), committees: committees }) }) return { bills, legislators } } 33:[] 2f:{"title":"MT Legislative records","cells":[{"id":0,"value":"md`# MT Legislative records`","pinned":false,"hidden":false,"mode":"ojs"},{"id":185,"value":"viewof selectChamber = {\n const options = [\n {label: 'Montana House (2017)', value: 'lower'},\n {label: 'Montana Senate (2017)', value: 'upper'}\n ]\n return html``\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"viewof selectLegislator = {\n const chamberKey = {'lower': 'HD', 'upper': 'SD'}\n const options = data.legislators\n .filter(d => d.active === 'True')\n .filter(d => d.chamber === selectChamber)\n .sort((a,b) => +a.district - +b.district)\n .map(d => ({\n value: d.leg_id,\n label: `${chamberKey[d.chamber]} ${d.district}: ${d.full_name}` \n }))\n return html``\n}\n\n// viewof selectLegislator = {\n// const legNames = data.legislators\n// .filter(d => d.active === 'True')\n// .filter(d => d.chamber === selectChamber)\n// .map(d => d.leg_id)\n// return DOM.select(legNames)\n// }\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":106,"value":"{ \n const chamberKey = {'lower': 'House', 'upper': 'Senate'}\n const chamber = chamberKey[legislator.chamber]\n \n const numSponsored = legislator.bills.length\n const numPassed = legislator.bills\n .filter(d => d.lastAction.action === 'Chapter Number Assigned').length\n const numVetoed = legislator.bills\n .filter(d => d.lastAction.action === 'Vetoed by Governor').length\n let committees = 'XXX'\n if (legislator.committees.length > 0) {\n committees = md`Committees: **${legislator.committees.join(', ')}**`\n } else {\n committees = md`Committees: **None**`\n }\n \n return md`\n ## ${legislator.full_name}\n Representing: **${chamber} District ${legislator.district}**\n\n Party: **${legislator.party}**\n\n ${committees}\n\n Bills and resolutions sponsored in 2017: **${numSponsored}**\n\n Number of bills signed into law: **${numPassed}**\n\n Number of bills vetoed: **${'TK'}**\n\n etc. etc. etc.\n `\n}\n ","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"md`### Sponsored bills and outcomes`","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":87,"value":"md`TODOS: \n- Add District lookup (enter address, get which district it's in)\n- (Possibly) add map showing district boundaries\n- Add summary statistics (e.g. most vetos, most bills passed) -- Look at ways to compare how productive a specific is to their peers across parties\n- (Possibly) Visualize bill progression through systems\n- Add better labels (e.g. what \"died in process\" means)\n- Think about adding vote totals for died in process / died in committee bills --> both overall and by party\n- Write up scope/cost doc for building this out the rest of the way\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"md`## Data management`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"rawData = {\n return {\n bills: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_bills.csv'),\n actions: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_bill_actions.csv'),\n sponsors: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_bill_sponsors.csv'),\n legislators: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_legislators.csv'),\n legVotes: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_bill_legislator_votes.csv'),\n billVotes: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_bill_votes.csv'),\n roles: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_legislator_roles.csv'),\n committees: await d3.csv('https://raw.githubusercontent.com/eidietrich/mt-leg-record/master/data/mt_committees.csv'),\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"legislator = data.legislators.find(d => d.leg_id === selectLegislator)","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"md`## Libraries`","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"import {table} from \"@tmcw/tables@444\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}