27:null 28:["$","title",null,{"children":"Legislator Score Card | Test - Jacob | Observable"}] 2d:T200e,// Table with just dems so it's easier to see? // TODO: Add this search to the top right so readers can find their district // https://projects.montanafreepress.org/capitol-tracker-2025/#find-district sponsorStatsTable = (sponsorStats) => { // put R - Locale on the same line // Add locale search // "Lookup lawmaker" link to cap tracker // onHover make text orange for the link to cap tracker const container = document.createElement('div'); const titleHeading = html`

2025 bill pass rate by Montana lawmakers

`; const dataNote = html`

Note: Excludes non-bill resolutions

`; const sourceNote = html`

Data: Montana Legislative Services

`; const creditNote = html`

Graphic: Jacob Olness/MTFP

`; const isMobileView = () => window.innerWidth <= 768; container.append(titleHeading); container.append(dataNote); container.id = 'sponsor-stats-container'; const searchInput = document.createElement('input'); searchInput.setAttribute('placeholder', 'Search by lawmaker or hometown'); searchInput.className = 'search-input'; const table = document.createElement('table'); const thead = document.createElement('thead'); const tbody = document.createElement('tbody'); const pagination = document.createElement('div'); pagination.className = 'pagination-div'; table.id = 'sponsor-stats-table'; table.style.width = '100%'; table.style.borderCollapse = 'separate'; table.style.borderSpacing = '0'; const tableWrapper = document.createElement('div'); tableWrapper.className = 'responsive-table-wrapper'; tableWrapper.appendChild(table); container.append(searchInput, tableWrapper, pagination, sourceNote, creditNote); table.append(thead, tbody); const rowsPerPage = 25; let currentPage = 1; let filteredData = sponsorStats; let isMobile = isMobileView(); const headersDesktop = [ { key: 'sponsor', name: 'Sponsor', sortable: true }, { key: 'billsSponsored', name: 'Sponsored', sortable: true }, { key: 'billsPassed', name: 'Passed', sortable: true }, { key: 'billsPassPercentage', name: 'Pass rate', sortable: true } ]; const headersMobile = [ { key: 'sponsor', name: 'Sponsor', sortable: true }, { key: 'combinedPass', name: 'Passed /
Sponsored', sortable: true, sortKey: 'billsSponsored' }, { key: 'billsPassPercentage', name: 'Pass rate', sortable: true } ]; let headers = isMobile ? headersMobile : headersDesktop; const isNumericColumn = (key) => { const numericKeys = [ 'billsSponsored', 'billsPassed', 'billsPassedPercentage', ]; return numericKeys.includes(key); }; const renderTableHeaders = () => { thead.innerHTML = ''; const tr = document.createElement('tr'); headers.forEach((header) => { const th = document.createElement('th'); th.innerHTML = header.name; th.className = `${header.key}-header`; if (header.sortable) { th.style.cursor = 'pointer'; const sortOn = header.sortKey ?? header.key; th.addEventListener('click', () => sortTable(sortOn)); const arrow = document.createElement('span'); arrow.textContent = ' ▲▼'; arrow.style.fontSize = isMobile ? '13px' : '14px'; arrow.style.marginTop = '2px'; th.appendChild(arrow); } // Optional: center all header content if this is the combined column if (header.key === 'combinedPass') { th.style.textAlign = 'center'; } tr.appendChild(th); }); thead.appendChild(tr); }; const renderTableRows = (dataSlice) => { tbody.innerHTML = ''; dataSlice.forEach((row) => { const tr = document.createElement('tr'); headers.forEach((header) => { const td = document.createElement('td'); let value = row[header.key]; if (header.key === 'sponsor') { const sponsorName = row.sponsor; const title = row.title ?? ''; const party = row.party ?? ''; const locale = row.locale ?? ''; const urlName = sponsorName.replace(/\s+/g, '-'); const url = `https://projects.montanafreepress.org/capitol-tracker-2025/lawmakers/${urlName}/#bills-sponsored`; // determine party color const partyColor = party === 'R' ? '#c62828' : party === 'D' ? '#1565c0' : '#666'; td.innerHTML = ` ${title} ${sponsorName}
${party}-${locale} `; } else { let value = ''; if (header.key === 'combinedPass') { const passed = row.billsPassed ?? 0; const sponsored = row.billsSponsored ?? 0; value = `${passed} / ${sponsored}`; } else { value = row[header.key]; if (typeof value === 'number' && value % 1 !== 0) { value = value.toFixed(2); } if (header.key === 'billsPassPercentage') { value = `${value}%`; } } // Styling if ( header.key === 'billsSponsored' || header.key === 'billsPassed' || header.key === 'billsPassPercentage' || header.key === 'combinedPass' ) { td.style.fontSize = '1.15em'; td.style.fontWeight = '500'; } td.textContent = value ?? ''; } td.className = `${header.key}-cell`; tr.appendChild(td); }); tbody.appendChild(tr); }); }; const updatePagination = (totalItems) => { pagination.innerHTML = ''; const totalPages = Math.ceil(totalItems / rowsPerPage); for (let i = 1; i <= totalPages; i++) { const btn = document.createElement('button'); btn.textContent = i; btn.className = i === currentPage ? 'active' : ''; btn.addEventListener('click', () => { currentPage = i; updateTable(); }); pagination.appendChild(btn); } }; const updateTable = () => { isMobile = isMobileView(); headers = isMobile ? headersMobile : headersDesktop; const start = (currentPage - 1) * rowsPerPage; const end = start + rowsPerPage; const pageData = filteredData.slice(start, end); renderTableHeaders(); tableWrapper.scrollIntoView({ behavior: 'smooth' }); renderTableRows(pageData); updatePagination(filteredData.length); }; const sortTable = (key) => { const order = (sortTable.lastOrder = sortTable.lastOrder === 'asc' ? 'desc' : 'asc'); filteredData.sort((a, b) => { let aVal = a[key] ?? ''; let bVal = b[key] ?? ''; if (isNumericColumn(key)) { aVal = parseFloat(String(aVal).replace(/,/g, '')) || 0; // Remove commas and convert to number bVal = parseFloat(String(bVal).replace(/,/g, '')) || 0; } return aVal < bVal ? (order === 'asc' ? -1 : 1) : aVal > bVal ? (order === 'asc' ? 1 : -1) : 0; }); currentPage = 1; updateTable(); }; searchInput.addEventListener('input', (e) => { const query = e.target.value.toLowerCase().trim(); filteredData = sponsorStats.filter((row) => row.sponsor?.toLowerCase().includes(query) || row.locale?.toLowerCase().includes(query) || row.chamber?.toLowerCase().includes(query) || row.district?.toLowerCase().includes(query) ); currentPage = 1; updateTable(); }); window.addEventListener('resize', () => { const wasMobile = isMobile; isMobile = isMobileView(); if (wasMobile !== isMobile) { updateTable(); } }); updateTable(); return container; }; 2e:T23c3,style = ``2f:T6cb,legislativeBattingAvgChartEmbed = html`

The 2025 session's 10 most prolific legislators

Note: Excludes non-bill resolutions

Bills Passed

Bills Sponsored

${chartStyle} ${await legislativeBattingAvgChart}

Data: Montana Legislative Services

Graphic: Jacob Olness/MTFP

` 30:T9b1,legislativeBattingAvgChart = { // narrow bars // add the (R) Billings like the table // add a few more legislators const isMobile = window.innerWidth < 768; const chartWidth = isMobile ? 500 : 800; const chartHeight = isMobile ? 500 : 800; const chartData = sponsorStats .map(d => { const fullName = `${d.title} ${d.sponsor}`; return { title: d.title, sponsor: fullName.length > 12 ? fullName.replace(/ (\S+)$/, "\n$1") // newline before last word (usually last name) : fullName, party: d.party, city: d.locale || '', billsSponsored: +d.billsSponsored, billsPassed: +d.billsPassed, billsPassPercentage: +d.billsPassPercentage }; }) .sort((a, b) => b.billsSponsored - a.billsSponsored) .slice(0, 10); console.log({ chartData }); return Plot.plot({ width: chartWidth, height: chartHeight, marginLeft: 140, marginBottom: 50, marginTop: 10, x: { grid: true, label: "Number of bills", nice: true, ticks: 7, tickPadding: 8, domain: [0, 60] }, y: { domain: chartData.map(d => d.sponsor), label: null, tickPadding: 10, padding: 0.4, }, marks: [ // background bar Plot.barX(chartData, { y: "sponsor", x: "billsSponsored", fill: "#d8d8d8", stroke: "#333", strokeWidth: 2, strokeDasharray: "4,4", opacity: 1 }), // overlay bar Plot.barX(chartData, { y: "sponsor", x: "billsPassed", fill: "#d73027", stroke: "black", strokeWidth: 3, title: d => `${d.billsPassed} bills passed`, }), Plot.ruleX([0], { stroke: "black", strokeWidth: 3 }), // pass percentage Plot.text(chartData, { y: "sponsor", x: d => d.billsSponsored + 2, text: d => `${d.billsPassPercentage.toFixed(1)}%`, fill: "black", fontSize: "1em", fontWeight: "bold", textAnchor: "start" }), Plot.text(chartData, { y: "sponsor", x: -5, dx: 35, dy: 27, text: d => `${d.party}-${d.city}`, fill: d => d.party === 'R' ? '#d73027' : d.party === 'D' ? '#4575b4' : '#666', fontSize: "0.9em", fontWeight: "bold", textAnchor: "end" }), ], style: { fontSize: "1.08em", fontFamily: "Arial, sans-serif" } }); }31:T6b8,topDemChartEmbed = html`

The 2025 session's 10 most prolific Democratic legislators

Note: Excludes non-bill resolutions

Bills Passed

Bills Sponsored

${chartStyle} ${await topDemChart}

Data: Montana Legislative Services

Graphic: Jacob Olness/MTFP

` 32:Tb2c,topDemChart = { const isMobile = window.innerWidth < 768; const chartWidth = isMobile ? 500 : 800; const chartHeight = isMobile ? 500 : 800; const chartData = sponsorStats .filter(d => d.party === 'D') .map(d => { const fullName = `${d.title} ${d.sponsor}`; return { title: d.title, sponsor: fullName.length > 12 ? fullName.replace(/ (\S+)$/, "\n$1") // newline before last word (usually last name) : fullName, party: d.party, city: d.locale || '', billsSponsored: +d.billsSponsored, billsPassed: +d.billsPassed, billsPassPercentage: +d.billsPassPercentage }; }) // const fullName = `${d.title} ${d.sponsor}`; // return { // title: d.title, // sponsor: fullName.length > 12 // ? fullName.replace(/ (\S+)$/, "\n$1") // newline before last word (usually last name) // : fullName, // party: d.party, // city: d.locale || '', // billsSponsored: +d.billsSponsored, // billsPassed: +d.billsPassed, // billsPassPercentage: +d.billsPassPercentage // }; // }) .sort((a, b) => b.billsSponsored - a.billsSponsored) .slice(0, 10); return Plot.plot({ width: chartWidth, height: chartHeight, marginLeft: 140, marginBottom: 50, marginTop: 10, x: { grid: true, label: "Number of bills", nice: true, ticks: 7, tickPadding: 8, domain: [0, 60] }, y: { domain: chartData.map(d => d.sponsor), label: null, tickPadding: 10, padding: 0.4, }, marks: [ // background bar Plot.barX(chartData, { y: "sponsor", x: "billsSponsored", fill: "#d8d8d8", stroke: "#333", strokeWidth: 2, strokeDasharray: "4,4", opacity: 1 }), // overlay bar Plot.barX(chartData, { y: "sponsor", x: "billsPassed", fill: "#4575b4", stroke: "black", strokeWidth: 3, title: d => `${d.billsPassed} bills passed` }), Plot.ruleX([0], { stroke: "black", strokeWidth: 3 }), // pass percentage Plot.text(chartData, { y: "sponsor", x: d => d.billsSponsored + 1, text: d => `${d.billsPassPercentage.toFixed(1)}%`, fill: "black", fontSize: "1em", fontWeight: "bold", textAnchor: "start" }), Plot.text(chartData, { y: "sponsor", x: -5, dx: 35, dy: 27, text: d => `${d.party}-${d.city}`, fill: d => d.party === 'R' ? '#d73027' : d.party === 'D' ? '#4575b4' : '#666', fontSize: "0.9em", fontFamily: "Arial, sans-serif", fontWeight: "bold", textAnchor: "end" }), ], style: { fontSize: "1.08em", fontFamily: "Arial, sans-serif" } }); } 33:[{"id":"61cfcd95ba5bd47f21a1c11b1674da7584c948e60679c7cd5991d39f091b3a139c2f6a057f51a9c7d6ee9b7e4658a834994a5c8954e26db3003866b9e0b72c31","href":"https://static.observableusercontent.com/files/61cfcd95ba5bd47f21a1c11b1674da7584c948e60679c7cd5991d39f091b3a139c2f6a057f51a9c7d6ee9b7e4658a834994a5c8954e26db3003866b9e0b72c31","name":"sponsor_stats_graphics@2.csv","type":"text/csv","lastModified":1751040842550.292,"size":6495},{"id":"c9e6cfa3755f018dc05b3c8db69dbb13c0239297a0ea96fde262e25695df5c2635ec0b7b6d4646b56e47546b08b1e613ff408cd4326f72e659f1074ee44f7667","href":"https://static.observableusercontent.com/files/c9e6cfa3755f018dc05b3c8db69dbb13c0239297a0ea96fde262e25695df5c2635ec0b7b6d4646b56e47546b08b1e613ff408cd4326f72e659f1074ee44f7667","name":"sponsor_stats_graphics@3.csv","type":"text/csv","lastModified":1751063177277.523,"size":6494},{"id":"bfab4b75d7b501892106fed3e5674ca0ed5ef5e1bb7fcb1d70e946c16f6c3a5f213215de9f41c5066284a875c0b812527eef2678781dae7ef4002146f9a2b778","href":"https://static.observableusercontent.com/files/bfab4b75d7b501892106fed3e5674ca0ed5ef5e1bb7fcb1d70e946c16f6c3a5f213215de9f41c5066284a875c0b812527eef2678781dae7ef4002146f9a2b778","name":"sponsor_stats_graphics@4.csv","type":"text/csv","lastModified":1751063447200.73,"size":6289},{"id":"1cb2b94375e68787597cef55d25847864f276b3b9b7162d8be2d7d48b1a59ed574fd649e5b4300ccfb655a70afec2e7aea1cd069e1d6048bf2b447f70f773ceb","href":"https://static.observableusercontent.com/files/1cb2b94375e68787597cef55d25847864f276b3b9b7162d8be2d7d48b1a59ed574fd649e5b4300ccfb655a70afec2e7aea1cd069e1d6048bf2b447f70f773ceb","name":"sponsor_stats_graphics@1.csv","type":"text/csv","lastModified":1748380136218.479,"size":6493}] 2b:{"id":"657643a6b96dcc09","slug":null,"title":"Legislator Score Card","thumbnail":"032cd684c627213644246eccc6c5cb2666d9e29c40a26fe36ddf51c1e7797fa4","access_level":"public","create_time":"$D2025-05-27T16:26:44.628Z","update_time":"$D2025-10-24T22:59:03.031Z","view_time":null,"first_public_time":"$D2025-06-03T18:33:31.134Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"4097a649455797ee","login":"jacob-test-mtfp","name":"Test - Jacob","avatar_url":"https://avatars-next.observableusercontent.com/286ea806712c4101f38678daa20ec893487774be0cb915d1ec1d72122a1654ea","tier":"starter_2024"},"version":517,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"524ba9658b83acf5","login":"jacob-olness2","name":"Jacob Olness","avatar_url":"https://avatars-next.observableusercontent.com/dfa74109c8f708d522fb4a9f595e7b21ff67039e8e2057c1dacde7875e3a05a0","tier":null}],"members":[{"type":"individual","id":"524ba9658b83acf5","login":"jacob-olness2","name":"Jacob Olness","avatar_url":"https://avatars-next.observableusercontent.com/dfa74109c8f708d522fb4a9f595e7b21ff67039e8e2057c1dacde7875e3a05a0","tier":null,"role":"editor"},{"type":"team","id":"4097a649455797ee","login":"jacob-test-mtfp","name":"Test - Jacob","avatar_url":"https://avatars-next.observableusercontent.com/286ea806712c4101f38678daa20ec893487774be0cb915d1ec1d72122a1654ea","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Legislator Score Card","cells":[{"id":0,"value":"# Legislator Score Card","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"sponsorStatsTableEmbed = html`\n ${sponsorStatsTable(sponsorStats)}\n ${style}\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$2d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"$2e","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"chartStyle = ` `","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"sponsorStats = FileAttachment(\"sponsor_stats_graphics@4.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2c:"$2b:body"