2b:null 2c:["$","title",null,{"children":"Member contacts and how to keep them updated with the Oireachtas open data API | David Cass | Observable"}] 31:T5af,viewof reptable = Inputs.search(table, { width: "100%", placeholder: "Search name, party or constituency", label: "Filter by keyword", datalist: true, autocomplete: true, spellcheck: true, oninput: () => { const form = document.querySelector("form.inputs-3a86ea"); if (form) { form.style.cssText += ` display: flex !important; flex-direction: column !important; align-items: stretch !important; max-width: 400px !important; width: 100% !important; margin: auto !important; `; const inputContainer = form.querySelector(".inputs-3a86ea-input"); if (inputContainer) { inputContainer.style.cssText += ` display: flex !important; flex-direction: column !important; gap: 8px !important; width: 100% !important; `; } const inputField = form.querySelector('input[name="input"]'); if (inputField) { inputField.style.cssText += ` width: 100% !important; padding: 8px !important; box-sizing: border-box !important; font-size: 16px !important; `; } const outputField = form.querySelector('output[name="output"]'); if (outputField) { outputField.style.cssText += ` margin-top: 8px !important; font-size: 14px !important; color: #666 !important; `; } } } })32:T6de,dodgePlot = Plot.plot({ width: 1200, //title: "Deputies of the 34th Dáil by party and constituency", marginBottom: 20, style: { fontFamily: "IBM Plex Sans", fontSize: 14 }, marginTop: 10, color: { legend: true, swatchWidth: 15, marginLeft: 10, columns: 4, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, marginRight: 150, // Adjusted for more space on the left x: { axis: null }, // Remove x-axis to simplify the layout y: { axis: "right", grid: true, fontVariant: "bold", label: "Constituency", tickSize: 0 }, // Use y-axis on the left marks: [ Plot.dot( reptable, Plot.dodgeX({ y: "constituency", x: "name", padding: 10, r: 25, // Slightly larger than the image radius to create a border effect fill: "none", // No fill inside the dot stroke: (d) => d.party, // Use the party color as the stroke strokeWidth: 10 // Define the thickness of the stroke }) ), Plot.image( reptable, Plot.dodgeX({ y: "constituency", x: "name", padding: 10, href: (d) => `https://www.oireachtas.ie/en/members/member/${d.webpage.slice(44)}`, target: "_blank", src: (d) => `https://data.oireachtas.ie/ie/oireachtas/member/id/${d.webpage.slice( 44 )}/image/thumb`, r: 25, // Image radius fill: "party", title: (d) => `Deputy ${d.name}, ${d.party}, is a Member for the constituency of ${d.constituency}`, preserveAspectRatio: "xMidYMin slice" // Ensures images are not clipped }) ) ] })33:T58e,Plot.plot({ width: 1100, height: 400, title: "Deputies of the 34th Dáil by party", marginBottom: 20, marginTop: 20, marginLeft: 100, marginRight: 5, y: { axis: "left", label: null, tickRotate: -45 }, x: { axis: null, tickRotate: 15 }, marks: [ Plot.image( reptable, Plot.dodgeX({ sort: { y: "-x", x: "-y" }, y: "party", dy: -20, anchor: "left", x: "name", href: (d) => `https://www.oireachtas.ie/en/members/member/${d.webpage.slice(44)}`, target: "_blank", src: (d) => `https://data.oireachtas.ie/ie/oireachtas/member/id/${d.webpage.slice( 44 )}/image/thumb`, r: 10, title: (d) => `Deputy ${d.name}, ${d.party}, is a Member for the constituency of ${d.constituency}`, preserveAspectRatio: "xMidYMin slice", href: (d) => `https://www.oireachtas.ie/en/members/member/${d.webpage.slice(44)}`, target: "_blank", src: (d) => `https://data.oireachtas.ie/ie/oireachtas/member/id/${d.webpage.slice( 44 )}/image/large`, r: 10, title: (d) => `Deputy ${d.name}, ${d.party}, is a Member for the constituency of ${d.constituency}`, preserveAspectRatio: "xMidYMin slice" // Ensures images are not clipped// Ensures images are not clipped }) ) ] })34:T574,seatsPlot = Plot.plot({ style: { fontFamily: "IBM Plex Sans", fontSize: 12, padding: "5px" }, color: { legend: true, columns: 6, swatchWidth: 25, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, width: 1000, ariaLabel: "Visual representation of Dáil seats filled by party", ariaDescription: "Visual representation of Dáil seats filled by party", subtitle: "Dáil Éireann | Seats filled by party", label: "Seats filled by party", y: { tickPadding: 6, grid: false, label: "Parties", nice: true }, x: { tickPadding: 6, fontVariant: "bold", grid: true, label: "Number of seats in the 34th Dáil", nice: true }, height: 400, marginTop: 20, marginLeft: 230, marginBottom: 100, marks: [ Plot.waffleX( data, Plot.groupY( { x: "count" }, { y: "Party", sort: { y: "-x" }, fill: "Party", gap: 1.5, fillOpacity: 1, rx: "100%", ry: "100%", ariaHidden: true, tip: { ariaHidden: true, channels: { Name: (d) => d.Deputy }, format: { x: true, Name: false, y: false } } } ) ) ] })35:T745,seatsPlotAriaFix = { const chart = Plot.plot({ style: { fontFamily: "IBM Plex Sans", fontSize: 12, padding: "5px" }, color: { legend: true, columns: 6, swatchWidth: 25, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, width: 1000, ariaLabel: "Visual representation of Dáil seats filled by party", ariaDescription: "Visual representation of Dáil seats filled by party", subtitle: "Dáil Éireann | Seats filled by party", label: "Seats filled by party", y: { tickPadding: 6, grid: false, label: "Parties", nice: true }, x: { tickPadding: 6, fontVariant: "bold", grid: true, label: "Number of seats in the 34th Dáil", nice: true }, height: 400, marginTop: 20, marginLeft: 230, marginBottom: 100, marks: [ Plot.waffleX( data, Plot.groupY( { x: "count" }, { y: "Party", sort: { y: "-x" }, fill: "Party", gap: 1.5, fillOpacity: 1, rx: "100%", ry: "100%", tip: { channels: { Name: (d) => d.Deputy }, format: { x: true, Name: false, y: false } } } ) ) ] }); const root = chart instanceof SVGElement ? chart : chart?.querySelector?.("svg"); if (root) { root.querySelectorAll("g[aria-label]").forEach((node) => { const role = node.getAttribute("role"); const labelledBy = node.getAttribute("aria-labelledby"); if (!role && !labelledBy) node.removeAttribute("aria-label"); }); } return chart; }36:T631,dodgePlotDáil = Plot.plot({ width: 1000, label: "Seats filled by constituency", ariaDescription: "Member information", ariaLabel: "Member information", subtitle: "Dáil Éireann | Seats filled by constituency", style: { fontFamily: "IBM Plex Sans", fontSize: 12, padding: 5 }, color: { legend: false, swatchWidth: 15, marginLeft: 10, columns: 4, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, height: 280, marginTop: 5, marginLeft: 75, marginBottom: 150, x: { label: "Constituency", nice: true, tickRotate: -45, tickPadding: 10, tickSpacing: 10 }, y: { ticks: false, axis: null }, marks: [ Plot.dot( data, Plot.dodgeY({ x: "Constituency", y: "Deputy", padding: 5, r: 7, fill: (d) => d.Party, stroke: (d) => d.Party, strokeWidth: null, ariaHidden: true, format: { fill: false, stroke: false, y: false } }) ), Plot.image( data, Plot.dodgeY({ x: "Constituency", y: "Deputy", padding: 5, r: 7, fill: (d) => d.Party, title: { Name: (d) => d.Deputy, Party: (d) => d.Party }, stroke: (d) => d.Party, strokeWidth: null, ariaHidden: true, tip: { ariaHidden: true, channels: { Name: (d) => d.Deputy, Party: (d) => d.Party } } }) ) ] })37:T4d2,seatsPlotHalf = Plot.plot({ style: { fontFamily: "IBM Plex Sans", fontSize: 15 }, color: { legend: true, columns: 3, swatchWidth: 25, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, subtitle: "Seats filled by party", label: null, y: { ticks: 0, tickSize: 0, tickPadding: 6, grid: false, label: "Parties", nice: true }, x: { tickPadding: 6, //ticks: 0, fontVariant: "bold", grid: true, label: "Number of seats in the 34th Dáil", nice: true }, height: 400, marginTop: 50, marginLeft: 230, marginRight: 30, marginBottom: 50, marks: [ Plot.axisY({ label: null, labelAnchor: "center", tickSize: 0 }), Plot.waffleX( data, Plot.groupY( { x: "count" }, { y: "Party", sort: { y: "-x" }, fill: "Party", gap: 1.5, fillOpacity: 1, multiple: 2, rx: "100%", ry: "100%", tip: { format: { x: true, y: false, name: true } } } ) ) ] })38:T5cb,constituenciesPlot = Plot.plot({ style: { fontFamily: "IBM Plex Sans", fontSize: 14, padding: "5px" }, color: { legend: true, insetLeft: 50, swatchWidth: 25, columns: 6, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, width: 1000, ariaLabel: "Visual representation of Dáil seats filled by constituency", ariaDescription: "Visual representation of Dáil seats filled by constituency", subtitle: "Dáil Éireann | Seats filled by constituency", label: null, y: { grid: true, label: "Number of seats", nice: true, ticks: false }, x: { grid: true, label: "Constituency", nice: true, tickRotate: -45, tickPadding: 10, tickSpacing: 10 }, height: 280, marginTop: 50, marginLeft: 90, marginBottom: 150, marks: [ //Plot.axisFy({ lineWidth: 1, anchor: "left", dy: 30, fontWeight: "bold" }), Plot.waffleY( data, Plot.groupX( { y: "count" }, { x: "Constituency", fill: "Party", gap: 2, fillOpacity: 1, href: (d) => `https://www.oireachtas.ie/en/members/member/${d.Code.slice(51)}`, target: "_blank", //multiple: 2, rx: "100%", tip: { format: { x: true, y: false } } } ) ) ] })39:T7ce,dodgePlotSeanad = Plot.plot({ width: 1100, height: 400, ariaDescription: "Visual chart of Senators in the 27th Seanad", ariaLabel: "Visual chart of Senators in the 27th Seanad", subtitle: "Senators of the 27th Seanad by panel and party", marginBottom: 20, style: { fontFamily: "IBM Plex Sans", fontSize: 14 }, marginTop: 20, color: { legend: true, swatchWidth: 15, marginLeft: 10, columns: 4, domain: filteredParties.map((d) => d.name), order: filteredParties.map((d) => d.name), range: filteredParties.map((d) => d.value) }, marginLeft: 220, // Adjusted for more space on the left x: { axis: null }, // Remove x-axis to simplify the layout y: { axis: "left", grid: true, label: null, tickSize: 0 }, // Use y-axis on the left marks: [ Plot.dot( seanadtable, Plot.dodgeX({ x: "name", y: "panel", ariaDescription: "Visual chart of Senators in the 27th Seanad", ariaLabel: "img", padding: 10, r: 22, // Slightly larger than the image radius to create a border effect fill: "none", // No fill inside the dot stroke: (d) => d.party, // Use the party color as the stroke strokeWidth: 12 // Define the thickness of the stroke }) ), Plot.image( seanadtable, Plot.dodgeX({ x: "name", y: "panel", ariaDescription: "Click on the images to go to a Member's profile page", padding: 10, href: (d) => `https://www.oireachtas.ie/en/members/member/${d.webpage.slice(44)}`, target: "_blank", src: (d) => `https://data.oireachtas.ie/ie/oireachtas/member/id/${d.webpage.slice( 44 )}/image/thumb`, r: 22, // Image radius fill: "party", title: (d) => `Senator ${d.name}, ${d.party}, is a Member for the ${d.panel}.`, preserveAspectRatio: "xMidYMin slice" // Ensures images are not clipped }) ) ] })3a:T768,dodgePlotSeanad1 = Plot.plot({ width: 800, height: 300, label: "Seanad Éireann | Senators by panel and party", ariaDescription: "Click through to view Member page", ariaLabel: "Click through to view Member page", subtitle: "Seanad Éireann | Senators by panel and party", marginBottom: 20, style: { fontFamily: "IBM Plex Sans", fontSize: 12, padding: 5 }, marginTop: 20, color: { legend: true, swatchWidth: 15, marginLeft: 10, columns: 4, domain: filteredParties.map((d) => d.name), order: filteredParties.map((d) => d.name), range: filteredParties.map((d) => d.value) }, marginLeft: 250, x: { axis: null }, y: { axis: "left", grid: true, label: null, tickSize: 0 }, marks: [ Plot.dot( seanadtable, Plot.dodgeX({ x: "name", y: "panel", padding: 5, r: 7, fill: (d) => d.party, stroke: (d) => d.party, strokeWidth: null, ariaHidden: true, tip: { ariaHidden: true, channels: { Name: (d) => d.name, Panel: (d) => d.panel, Party: (d) => d.party }, format: { fill: false, stroke: false, y: false, Panel: true } } }) ), Plot.image( seanadtable, Plot.dodgeX({ x: "name", y: "panel", padding: 5, r: 7, fill: (d) => d.party, stroke: (d) => d.party, strokeWidth: null, ariaHidden: true, tip: { ariaHidden: true, channels: { Name: (d) => d.name, Panel: (d) => d.panel, Party: (d) => d.party }, format: { fill: false, stroke: false, y: false, Panel: true } } }) ) ] })3b:T659,data = { const activeMembers = membersFromAPI.results.filter((d) => { const memberships = d.member.memberships ?? []; if (!memberships.length) return false; const lastMembership = memberships[memberships.length - 1].membership; const house = lastMembership.house?.showAs; const hasEnd = !!lastMembership?.dateRange?.end; // Drop only 34th Dáil with an end date return !(house === "34th Dáil" && hasEnd); }); return Array.from( d3.flatGroup( activeMembers, (d) => d.member.memberships.at(-1).membership.house.showAs, (d) => d.member.fullName, (d) => d.member.memberships.at(-1).membership.represents?.[0]?.represent ?.representCode, (d) => d.member.memberships.at(-1).membership.parties.at(-1).party.showAs, (d) => d.member.memberships.at(-1).membership.parties.at(-1).party.partyCode, (d) => d.member.memberships.at(-1).membership.represents?.[0]?.represent ?.showAs, (d) => d.member.memberships.at(-1).membership.committees ?? [], (d) => d.member.memberCode ), ([ House, Deputy, ConCode, Party, PartyCode, Constituency, Committees, Code ]) => ({ House, Deputy, ConCode, Party, PartyCode, Constituency, Code, Committees: Committees.map((c) => { const name = c.committeeName?.[0]?.nameEn ?? "Unnamed Committee"; const role = c.role?.title; return role ? `${name} (${role})` : name; }) }) ).sort((a, b) => d3.ascending(a.Deputy, b.Deputy)); }3c:T464,//data = Array.from( d3.flatGroup( membersFromAPI.results, (d) => d.member.memberships[d.member.memberships.length - 1].membership.house .showAs, (d) => d.member.fullName, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.representCode, (d) => d.member.memberships[d.member.memberships.length - 1].membership .parties[0].party.showAs, (d) => d.member.memberships[d.member.memberships.length - 1].membership .parties[0].party.partyCode, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.showAs, (d) => d.member.memberCode //(d) => // d.member.memberships[0].membership.offices[0]?.office.dateRange.end === //null // ? d.member.memberships[0].membership.offices[0].office.officeName.showAs //: null ), ([House, Deputy, ConCode, Party, PartyCode, Constituency, Code]) => ({ House, Deputy, ConCode, Party, PartyCode, Constituency, Code }) ).sort((a, b) => d3.ascending(a, b))3d:T511,//Construct an array of Deputy info containing Deputy name, party and constituency //data = Array.from( d3.flatGroup( membersFromAPI.results.filter( (d) => d.member.memberships[0].membership.dateRange.end === null ), (d) => d.member.memberships[0].membership.house.showAs, (d) => d.member.fullName, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.representCode, (d) => d.member.memberships[0].membership.parties[ d.member.memberships[0].membership.parties.length - 1 ].party.showAs, (d) => d.member.memberships[0].membership.parties[ d.member.memberships[0].membership.parties.length - 1 ].party.partyCode, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.showAs, (d) => d.member.uri //(d) => // d.member.memberships[0].membership.offices[0]?.office.dateRange.end === //null // ? d.member.memberships[0].membership.offices[0].office.officeName.showAs //: null ), ([House, Deputy, ConCode, Party, PartyCode, Constituency, Code]) => ({ House, Deputy, ConCode, Party, PartyCode, Constituency, Code }) ).sort((a, b) => d3.ascending(a, b))3e:T442,//Construct an array of Senator info containing Deputy name, party and constituency data2 = Array.from( d3.flatGroup( senatorsFromAPI.results, (d) => d.member.memberships[d.member.memberships.length - 1].membership.house .showAs, (d) => d.member.fullName, (d) => d.member.memberships[d.member.memberships.length - 1].membership.parties[ d.member.memberships[d.member.memberships.length - 1].membership.parties .length - 1 ].party.showAs, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.showAs, (d) => d.member.memberships.at(-1).membership.committees ?? [], (d) => d.member.uri ), ([House, Senator, Party, Constituency, Committees, Code]) => ({ House, Senator, Party, Constituency, Code, Committees: Committees.map((c) => { const name = c.committeeName?.[0]?.nameEn ?? "Unnamed Committee"; const role = c.role.title; return role ? `${name} (${role})` : name; }) }) ).sort((a, b) => d3.ascending(a, b))3f:T43a,Plot.plot({ style: { fontFamily: "IBM Plex Sans", fontSize: 14, padding: "5px" }, color: { legend: true, domain: partiesPalette.map((d) => d.name), order: partiesPalette.map((d) => d.name), range: partiesPalette.map((d) => d.value) }, width: 790, title: "Seats filled in 34th Dáil", label: null, y: { grid: true, ticks: false, label: "Number of seats", nice: true }, x: { grid: true, //label: "Constituencies", nice: true, tickRotate: -45, tickPadding: 10, tickSpacing: 10 }, height: 580, marginTop: 50, marginLeft: 10, marginBottom: 30, marks: [ //Plot.axisFy({ lineWidth: 1, anchor: "left", dy: 30, fontWeight: "bold" }), Plot.waffleY( data, Plot.groupY( { y: "count" }, { x: "Constituency", fill: "Party", fillOpacity: 1, //multiple: 2, rx: "100%", tip: { format: { x: false, y: false } } } ) ) ] })40:[{"id":"865fe93eeb8a1d3f6a875e59c79de9e3c200a07ffd2e04c90e36fa6fe4f9688bcff5470794eac0caba751f15fbb3426541805fe8839800cd1b825c1058c90621","href":"https://static.observableusercontent.com/files/865fe93eeb8a1d3f6a875e59c79de9e3c200a07ffd2e04c90e36fa6fe4f9688bcff5470794eac0caba751f15fbb3426541805fe8839800cd1b825c1058c90621","name":"2022-12-19_contact-details-senators_en.csv","type":"text/csv","lastModified":1729241819637.453,"size":8771},{"id":"536eed5f59293db5ba047fbbb31a8fe8b5cdc8089bb745feb8338002fba73da41a2674f4e4af68be3d58654f0c43007e3a5180f6d4a5c1b71356b7629409b5ac","href":"https://static.observableusercontent.com/files/536eed5f59293db5ba047fbbb31a8fe8b5cdc8089bb745feb8338002fba73da41a2674f4e4af68be3d58654f0c43007e3a5180f6d4a5c1b71356b7629409b5ac","name":"2021-07-15_contact-details-tds_en.csv","type":"text/csv","lastModified":1729241838155.892,"size":20795}] 2f:{"id":"e6d4a1e76a251e8e","slug":null,"title":"Member contacts and how to keep them updated with the Oireachtas open data API","thumbnail":"aa782310d79defdc0ca2b48dbd2c0938fb12a419f1a38b369e4beb71842a7b16","access_level":"public","create_time":"$D2023-11-08T17:33:54.559Z","update_time":"$D2026-06-12T07:43:36.319Z","view_time":null,"first_public_time":"$D2023-11-08T17:33:54.559Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1cc7c51c4e129cc6","login":"cassdavid","name":"David Cass","avatar_url":"https://avatars-next.observableusercontent.com/23f715262d714df76a73099e52ee40739329c8543d97eb613e222d55e7fc738b","tier":"starter_2024"},"version":2083,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8ed953af6b3ea3ca","login":"cassdavid","name":"David Cass","avatar_url":"https://avatars-next.observableusercontent.com/23f715262d714df76a73099e52ee40739329c8543d97eb613e222d55e7fc738b","tier":null}],"members":[{"type":"individual","id":"8ed953af6b3ea3ca","login":"cassdavid","name":"David Cass","avatar_url":"https://avatars-next.observableusercontent.com/23f715262d714df76a73099e52ee40739329c8543d97eb613e222d55e7fc738b","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Member contacts and how to keep them updated with the Oireachtas open data API","cells":[{"id":0,"value":"# Member contacts and how to keep them updated with the Oireachtas open data API","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1638,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1692,"value":"intro = md`Members of the new Dáil by constituency, name and party. Click through images to view profiles.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2051,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1811,"value":"$36","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1469,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":476,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1475,"value":"chamberChart = chart","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1473,"value":"import { chart } from \"08ab8c17a4c5079c\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"TDIntro = md`## Search TD contact details\nFilter by keyword, including name, party and constituency, and download a file of the results.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"downloadButton = button(reptable, `selected contact details for TDs.csv`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":413,"value":"viewof tableAlternative = Inputs.table(reptable, {\n columns: [\n \"name\",\n \"email\",\n \"constituency\",\n \"party\",\n \"webpage\"\n //\"office\"\n ],\n header: {\n name: \"Name\",\n email: \"Email\",\n constituency: \"Constituency\",\n party: \"Party\",\n webpage: \"Webpage\"\n //office: \"Office\"\n },\n format: {\n email: (email) => html`${email}`,\n webpage: (webpage) =>\n html`Member page`\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"SeanadIntro = md`## Search Senator contact details\nFilter by keyword, including name, party or electoral panel and download a file of the results.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1012,"value":"viewof radios = Inputs.radio([\"Name\", \"Party\", \"Panel\"], {\n label: \"Select one\",\n value: \"Party\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1016,"value":"viewof selection = Inputs.select(new Set(seanadtable.map((d) => d.panel)), {\n label: \"Select one\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"viewof seanadtable = Inputs.search(tableSeanad, {\n width: \"100%\",\n placeholder: \"Search name, party or panel\",\n label: \"Filter by keyword\",\n datalist: true,\n spellcheck: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":961,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1775,"value":"$3a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":388,"value":"seanadDownloadButton = button(\n seanadtable,\n `selected contact details for Senators.csv`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"viewof tableAlternativeSeanad = Inputs.table(seanadtable, {\n columns: [\"name\", \"email\", \"panel\", \"party\", \"webpage\"],\n header: {\n name: \"Name\",\n email: \"Email\",\n panel: \"Panel\",\n party: \"Party\",\n webpage: \"Webpage\"\n },\n format: {\n email: (email) => html`${email}`,\n webpage: (webpage) =>\n html`Member page`\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"//Get list of Deputies from open data API\nmembersFromAPI = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=2024-11-15&chamber=dail&house_no=34&skip=0&limit=500\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2025,"value":"//Get list of Deputies from open data API\nmembersFromAPI33 = fetch(\n \"https://api.oireachtas.ie/v1/members?chamber=dail&house_no=33&skip=0&limit=5000\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2028,"value":"//Get list of Deputies from open data API\nmembersFromAPI32 = fetch(\n \"https://api.oireachtas.ie/v1/members?chamber=dail&house_no=32&skip=0&limit=5000\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2030,"value":"//Get list of Deputies from open data API\nmembersFromAPI31 = fetch(\n \"https://api.oireachtas.ie/v1/members?chamber=dail&house_no=31&skip=0&limit=5000\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"//Get list of Senators from open data API\nsenatorsFromAPI = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=2025-01-01&chamber=seanad&house_no=27&skip=0&limit=500\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1991,"value":"$3b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2045,"value":"endedMembers = membersFromAPI.results\n .filter((d) => {\n const memberships = d.member.memberships ?? [];\n if (!memberships.length) return false;\n\n const lastMembership = memberships[memberships.length - 1].membership;\n // These are the ones currently being filtered OUT\n return lastMembership?.dateRange?.end;\n })\n .map((d) => {\n const memberships = d.member.memberships ?? [];\n const last = memberships[memberships.length - 1].membership;\n\n return {\n name: d.member.fullName,\n memberCode: d.member.memberCode,\n house: last.house?.showAs,\n latestStart: last.dateRange?.start,\n latestEnd: last.dateRange?.end,\n // Optional: see ALL their memberships for debugging\n allMemberships: memberships.map((m) => ({\n house: m.membership.house?.showAs,\n start: m.membership.dateRange?.start,\n end: m.membership.dateRange?.end\n }))\n };\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2036,"value":"data4 = {\n return Array.from(\n d3.flatGroup(\n membersFromAPI33.results,\n (d) => d.member.fullName,\n (d) => d.member.memberCode,\n (d) =>\n d.member.memberships[0].membership.parties[\n d.member.memberships[0].membership.parties.length - 1\n ].party.showAs\n ),\n ([Deputy, Code, Party]) => ({\n Deputy,\n Code,\n Party\n })\n ).sort((a, b) => d3.ascending(a, b));\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1952,"value":"$3c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"$3d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"$3e","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2072,"value":"function latestParty(member) {\n const parties = member.memberships.flatMap((m) =>\n (m.membership.parties ?? []).map((p) => ({\n showAs: p.party.showAs,\n start: new Date(p.party.dateRange.start)\n }))\n );\n\n parties.sort((a, b) => b.start - a.start);\n return parties[0]?.showAs ?? \"Unknown\";\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2014,"value":"//Construct an array of Senator info containing Deputy name, party and constituency\ndata3 = Array.from(\n d3.flatGroup(\n senatorsFromAPI.results,\n (d) => d.member.memberships[0].membership.house.showAs,\n (d) => d.member.fullName,\n (d) => latestParty(d.member), // <-- FIXED PARTY LOGIC HERE\n (d) =>\n d.member.memberships.at(-1).membership.represents[0].represent.showAs,\n (d) => d.member.memberships.at(-1).membership.committees ?? [],\n (d) => d.member.uri.slice(51)\n ),\n ([House, Senator, Party, Constituency, Committees, Code]) => ({\n House,\n Senator,\n Party,\n Constituency,\n Code,\n Committees: Committees.map((c) => {\n const name = c.committeeName?.[0]?.nameEn ?? \"Unnamed Committee\";\n const role = c.role.title;\n return role ? `${name} (${role})` : name;\n })\n })\n).sort((a, b) => d3.ascending(a, b))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"//Mapping the combined data to an array to populate a table\ntable = combined.map((d) => ({\n house: d.House,\n name: d.Deputy,\n email: d.Email,\n party: d.Party,\n constituency: d.Constituency,\n webpage: \"https://www.oireachtas.ie/en/members/member/\" + d.Code.slice(),\n committees: d.Committees\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2076,"value":"//Mapping the combined data to an array to populate a table\nmembers = combined.map((d) => ({\n deputy: d.Deputy,\n party: d.Party,\n constituency: d.Constituency,\n memberCode: d.Code.slice()\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"tableSeanad = combinedSeanad.map((d) => ({\n house: d.House,\n name: d.Senator,\n email: d.Email,\n party: d.Party,\n panel: d.Constituency,\n webpage: \"https://www.oireachtas.ie/en/members/member/\" + d.Code.slice(51)\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1742,"value":"seanadParties = Array.from(new Set(tableSeanad.map((d) => d.party)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"button = (data, filename = \"data.csv\") => {\n if (!data) throw new Error(\"Array of data required as first argument\");\n\n let downloadData;\n if (filename.includes(\".csv\")) {\n downloadData = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n } else {\n downloadData = new Blob([JSON.stringify(data, null, 2)], {\n type: \"application/json\"\n });\n }\n\n const size = (downloadData.size / 1024).toFixed(0);\n const button = DOM.download(\n downloadData,\n filename,\n `Download ${filename} (~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"//CSV from website has been replicated on Google sheets. This is a query for the latest dataset from the array.\nmemberCSVData = d3.csv(getCsvUrl(\"https://docs.google.com/spreadsheets/d/1qADMCsrGCn4w0SX-NJ8nChuOdj85WHpNcnJsDRZ4fws/edit#gid=602403477\"), d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"//CSV from website has been replicated on Google sheets. This is a query for the latest dataset from the array.\nsenatorCSVData = d3.csv(\n getCsvUrl(\n \"https://docs.google.com/spreadsheets/d/1jsJnrO8JEosE0jW3WzNYyImbuYx41be1_8Yx3wtj9KA/edit?gid=1504980700#gid=1504980700\"\n ),\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"combined = {\n const index = d3.index(memberCSVData, (d) => d.Name);\n\n return data.map(({ Deputy, ...values }) => {\n const memberData = index.get(Deputy);\n const email =\n memberData?.email ||\n `${Deputy.toLowerCase().replace(/\\s+/g, \".\")}@oireachtas.ie`;\n\n return {\n Title: memberData?.Title,\n Deputy,\n ...values,\n Email: email,\n Address: memberData?.[\"LH address\"]\n };\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"//Combine both datasets using d3.index. This creates an index from the Deputy name in the CSV dataset and aligns data to that indexed name in the dataset from the Oireachtas API.\ncombinedSeanad = {\n const index = d3.index(senatorCSVData, (d) => d.Name);\n return data3.map(({ Senator, ...values }) => ({\n Title: index.get(Senator)?.Title,\n Senator,\n ...values,\n Email: index.get(Senator)?.email,\n Address: index.get(Senator)?.[\"LH address\"]\n }));\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"import {getCsvUrl} from \"@observablehq/google-sheets-starter\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"//We could also add ministerial offices and even committee membership when its available?\ndata1 = Array.from(d3.flatGroup(membersFromAPI.results, d => d.member.fullName, d => d.member.memberships[0].membership.parties[0].party.showAs, d => d.member.memberships[0].membership.represents[0].represent.showAs, d => d.member.memberships.committees?.committeeName[0].nameEn, d => d.member.memberships[0].membership.offices[0]?.office.officeName.showAs, d => d.member.memberships[0].membership.offices[0]?.office.dateRange.end),\n ([Deputy, Party, Constituency, Committee, Office, OfficeEnd]) => ({Deputy, Party, Constituency, Committee, Office, OfficeEnd}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"//Not sure the officeholders' data are \ndata1.filter(d => d.Office != null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"TDTable = htl.html`\n \n \n \n \n \n \n \n \n \n \n ${reptable.map(\n (reptable) => htl.html`\n \n \n \n \n \n `\n )}\n \n

Name	email	Party	Constituency	Web page
${reptable[\"name\"]}	${reptable[\"email\"]}	${reptable[\"party\"]}	${reptable[\"constituency\"]}	Member page

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":941,"value":"css = htl.html` `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"ns = Inputs.text().classList[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"SenatorsTable = htl.html`\n \n \n \n \n \n \n \n \n \n \n ${seanadtable.map(\n (seanadtable) => htl.html`\n \n \n \n \n \n `\n )}\n \n

Name	email	Party	Panel	Web page
${seanadtable[\"name\"]}	${seanadtable[\"email\"]}	${seanadtable[\"party\"]}	${seanadtable[\"panel\"]}	Member page

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":920,"value":"import { text } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1746,"value":"filteredParties = partiesPalette.filter((d) => seanadParties.includes(d.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1073,"value":"partiesPalette = [\n { name: \"Fianna Fáil\", value: \"#2c8737\" },\n { name: \"Sinn Féin\", value: \"#088460\" },\n { name: \"Fine Gael\", value: \"#303591\" },\n { name: \"Independent\", value: \"#666666\" },\n { name: \"Labour Party\", value: \"#c82832\" },\n { name: \"Social Democrats\", value: \"#782b81\" },\n { name: \"Independent Ireland\", value: \"#087b87\" },\n { name: \"People Before Profit-Solidarity\", value: \"#be417d\" },\n { name: \"Aontú\", value: \"#b35400\" },\n { name: \"100% RDR\", value: \"#985564\" },\n { name: \"Green Party\", value: \"#6c7e26\" }\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1075,"value":"partyColours = partiesPalette.map((d) => d.value)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1050,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1436,"value":"import {autoSelect} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"//viewof reptable = Inputs.search(table, {\n width: 400,\n placeholder: \"Search name, party or constituency\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1754,"value":"seatData = d3.csv(\n getCsvUrl(\n \"https://docs.google.com/spreadsheets/d/1L1RjZ2Db-9CYbxObUGHP8uDR9o2PoH-_RP-86ZHOhQs/edit?gid=732141076#gid=732141076\"\n ),\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1756,"value":"chamberSeatAssignment = d3.csv(\n getCsvUrl(\n \"https://docs.google.com/spreadsheets/d/1RrzKfnWBKhM_kC0Pg7tT58nXS7m-f-kkuAPRw2F1L-c/edit?gid=163458937#gid=163458937\"\n ),\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1","titling":"auto"}} 30:"$2f:body"