2b:null 2c:["$","title",null,{"children":"Constituencies for constituency dashboards | David Cass | Observable"}] 31:T6c3,choropleth = Plot.plot({ style: { fontSize: 12, fontFamily: "IBM Plex Sans" }, projection: { type: "albers", domain: circle, rotate: [1, 0], parallels: [50, 60], inset: "15" }, style: { backgroundColor: "#89CFF0" }, width: 800, height: 700, spacingRight: 10, spacingLeft: 10, color: { scheme: "Greens", type: "quantize", n: 5, //domain: [1, 5000], label: `Parliamentary Questions: ${year.year}`, legend: true }, marks: [ Plot.geo( constituencyFile, Plot.centroid({ //fill: d => filterByHeading.get(d.properties.CON_SEAT_), //fill: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), fill: (d) => choroplethData.get(d.properties.CON_SEAT_), href: (d) => uniqueMap.get(d.properties.CON_SEAT_), target: "_blank", tip: true, channels: { Constituency: (d) => constituencyMap.get(d.properties.CON_SEAT_).properties.CON_SEAT_, Questions: (d) => choroplethData.get(d.properties.CON_SEAT_) //Questions: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), //Questions: d => filterByHeading.get(d.properties.CON_SEAT_), } }) ), Plot.tip( constituencyFile, Plot.pointer({ title: (d) => choroplethData.get(d.properties.CON_SEAT_), fontSize: 30 }) ), Plot.geo(constituencyFile, { stroke: "black" }), Plot.text( constituencyFile //Plot.centroid({ //text: d => d.constituencyMap.get(d.properties.CON_SEAT_).properties.CON_SEAT_, //textAnchor: "middle", //stroke: "white", //fill: "black", //fontSize: 30, //}) ) ] })32:Tc97,treemapChart1 = { const x = d3.scaleLinear().rangeRound([0, width]); const y = d3.scaleLinear().rangeRound([0, height]); const svg = d3.create("svg") .attr("viewBox", [0.5, -30.5, width, height + 30]) .style("font", "16px IBM Plex Sans") .attr("fill", "white"); let group = svg.append("g") .call(render, treemap(data3)); function render(group, root) { const node = group .selectAll("g") .data(root.children.concat(root)) .join("g"); node.filter(d => d === root ? d.parent : d.children) .attr("cursor", "pointer") .on("click", (event, d) => d === root ? zoomout(root) : zoomin(d)); node.append("title") .text(d => `${name(d)}\n${format(d.value)}`); node.append("rect") .attr("id", d => (d.leafUid = DOM.uid("leaf")).id) .attr("fill", d => d === root ? "#1f77b4" : d.children ? "#1f77b4" : "#7f7f7f") .attr("stroke", "#ff7f0e") .attr("stroke-width", 2); node.append("clipPath") .attr("id", d => (d.clipUid = DOM.uid("clip")).id) .append("use") .attr("xlink:href", d => d.leafUid.href); node.append("text") .attr("clip-path", d => d.clipUid) .attr("font-weight", d => d === root ? "bold" : null) .selectAll("tspan") .data(d => (d === root ? name(d) : d.data.name).split(/(?=[A-Z][^A-Z])/g).concat(format(d.value))) .join("tspan") .attr("x", 3) .attr("y", (d, i, nodes) => `${(i === nodes.length - 1) * 0.3 + 1.1 + i * 0.9}em`) .attr("fill-opacity", (d, i, nodes) => i === nodes.length - 1 ? 0.7 : null) .attr("font-weight", (d, i, nodes) => i === nodes.length - 1 ? "normal" : null) .text(d => d); group.call(position, root); } function position(group, root) { group.selectAll("g") .attr("transform", d => d === root ? `translate(0,-30)` : `translate(${x(d.x0)},${y(d.y0)})`) .select("rect") .attr("width", d => d === root ? width : x(d.x1) - x(d.x0)) .attr("height", d => d === root ? 35 : y(d.y1) - y(d.y0)); } // When zooming in, draw the new nodes on top, and fade them in. function zoomin(d) { const group0 = group.attr("pointer-events", "none"); const group1 = group = svg.append("g").call(render, d); x.domain([d.x0, d.x1]); y.domain([d.y0, d.y1]); svg.transition() .duration(750) .call(t => group0.transition(t).remove() .call(position, d.parent)) .call(t => group1.transition(t) .attrTween("opacity", () => d3.interpolate(0, 1)) .call(position, d)); } // When zooming out, draw the old nodes on top, and fade them out. function zoomout(d) { const group0 = group.attr("pointer-events", "none"); const group1 = group = svg.insert("g", "*").call(render, d.parent); x.domain([d.parent.x0, d.parent.x1]); y.domain([d.parent.y0, d.parent.y1]); svg.transition() .duration(750) .call(t => group0.transition(t).remove() .attrTween("opacity", () => d3.interpolate(1, 0)) .call(position, d)) .call(t => group1.transition(t) .call(position, d.parent)); } return svg.node(); }33:T550,choropleth1 = Plot.plot({ projection: { type: "albers", domain: circle, rotate:([1, 0]), parallels: ([50, 60]), inset: "15" }, style: {backgroundColor: "#89CFF0",}, width: 900, height: 800, color: { scheme: "Greens", type: "quantize", n: 6, //domain: [1, 5000], label: `Parliamentary Questions asked ${year.year}`, legend: true }, marks: [ Plot.geo(constituencyFile, Plot.centroid({ //fill: d => filterByHeading.get(d.properties.CON_SEAT_), //fill: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), fill: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), tip: true, channels:{ Constituency: d => constituencyMap.get(d.properties.CON_SEAT_).properties.CON_SEAT_, Questions: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), //Questions: d => filteredChoroplethHeadings.get(d.properties.CON_SEAT_), //Questions: d => filterByHeading.get(d.properties.CON_SEAT_), } }) ), Plot.geo(constituencyFile, {stroke: "black"}), Plot.text( constituencyFile, //Plot.centroid({ //text: d => d.constituencyMap.get(d.properties.CON_SEAT_).properties.CON_SEAT_, //textAnchor: "middle", //stroke: "white", //fill: "black" //}) ) ] })34:T44e, ${filteredWithDeputy.slice(0, 10).map(PQsFilteredByConstituency => htl.html``)}

Date	Deputy	Heading	Question
${new Date(PQsFilteredByConstituency["date"]).toLocaleString("en-IE", { dateStyle: 'full' })}	${PQsFilteredByConstituency["name"]}	${PQsFilteredByConstituency["heading"]}	${PQsFilteredByConstituency["questionText"]}

35:T462, ${questionsFromHeadings.slice().map(PQsFilteredByConstituency => htl.html``)}

Date	Deputy	Heading	Question
${new Date(PQsFilteredByConstituency["date"]).toLocaleString("en-IE", { dateStyle: 'full' })}	${PQsFilteredByConstituency["name"]}	${PQsFilteredByConstituency["heading"]}	${PQsFilteredByConstituency["questionText"]}

36:T574,//Construct an array of Deputy info containing Deputy name, party and constituency constituencyGroup = Array.from( d3.flatGroup( membersFromAPI.results, (d) => d.member.fullName, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.representCode, (d) => "https://www.oireachtas.ie/en/members/tds/?tab=constituency&constituency=%2Fie%2Foireachtas%2Fhouse%2Fdail%2F33%2Fconstituency%2F" + 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.slice(51), (d) => "https://www.oireachtas.ie/en/members/member/" + d.member.uri.slice(51) ), ([ name, conCode, conURL, party, partyCode, constituency, memberCode, url ]) => ({ name, conCode, conURL, party, partyCode, constituency, memberCode, url }) ).sort((a, b) => d3.ascending(a, b))37:T578,//Construct an array of Deputy info containing Deputy name, party and constituency constituencyGroup34 = Array.from( d3.flatGroup( membersFromAPI34.results, (d) => d.member.fullName, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.representCode, (d) => "https://www.oireachtas.ie/en/members/tds/?tab=constituency&constituency=%2Fie%2Foireachtas%2Fhouse%2Fdail%2F33%2Fconstituency%2F" + 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.slice(51), (d) => "https://www.oireachtas.ie/en/members/member/" + d.member.uri.slice(51) ), ([ name, conCode, conURL, party, partyCode, constituency, memberCode, url ]) => ({ name, conCode, conURL, party, partyCode, constituency, memberCode, url }) ).sort((a, b) => d3.ascending(a, b))38:T45d,constituencyTDs = Array.from( //Construct an array of Deputy info containing Deputy name, party and constituency d3.flatGroup( members.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[0].membership.parties[ d.member.memberships[0].membership.parties.length - 1 ].party.showAs, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.showAs, (d) => d.member.memberships[d.member.memberships.length - 1].membership .represents[0].represent.representCode, (d) => d.member.memberships[0].membership.offices[0]?.office.dateRange.end === null ? d.member.memberships[0].membership.offices[0].office.officeName.showAs : null ), ([House, name, Party, constituency, representCode, Office]) => ({ House, name, Party, constituency, representCode, Office }) ).sort((a, b) => d3.ascending(a, b))39:[{"id":"0f1aeef533748087a38968a591f816ebd9e8f7c60f25ad4b0b06a843ec450369c3027167ea243b782711609c4f5a665a857a00a4b4c0d685c942f2dcd6cbf9d4","href":"https://static.observableusercontent.com/files/0f1aeef533748087a38968a591f816ebd9e8f7c60f25ad4b0b06a843ec450369c3027167ea243b782711609c4f5a665a857a00a4b4c0d685c942f2dcd6cbf9d4","name":"correctedConstituencyGroup@1.json","type":"application/json","lastModified":1728890120447.474,"size":23859},{"id":"b45be35061daf92aff2565e68d257fd932cfc51edb63988d513d6fcbf343e528616aaef076d6da2c20cbe84258f45b9f2d22c49e6ac09606fdc75f5c5c560448","href":"https://static.observableusercontent.com/files/b45be35061daf92aff2565e68d257fd932cfc51edb63988d513d6fcbf343e528616aaef076d6da2c20cbe84258f45b9f2d22c49e6ac09606fdc75f5c5c560448","name":"Constituency_Boundaries_-_Generalised_20m_-_National_Electoral_Boundaries_-_2017_no_seat_numbers.geojson","type":"application/geo+json","lastModified":1695071435364.399,"size":4685240},{"id":"a769f3420e0b32ce27fe0b9d41dc2dd027922ce77d9509afe366e690aa69523097634eb3c735ae806f011f36e6fc998c7179ca4c5a1defe151af6fb2ac17edd4","href":"https://static.observableusercontent.com/files/a769f3420e0b32ce27fe0b9d41dc2dd027922ce77d9509afe366e690aa69523097634eb3c735ae806f011f36e6fc998c7179ca4c5a1defe151af6fb2ac17edd4","name":"choroplethData.json","type":"application/json","lastModified":1695071435364.399,"size":849},{"id":"0a9192c75967ec0003328bf230a60d84d34e7dd828dfb1bdb76e98c930f39631c8a3a8d9fe32a89f5575503bff27baa7833580638f19f4c677d6b304bc119aef","href":"https://static.observableusercontent.com/files/0a9192c75967ec0003328bf230a60d84d34e7dd828dfb1bdb76e98c930f39631c8a3a8d9fe32a89f5575503bff27baa7833580638f19f4c677d6b304bc119aef","name":"correctedConstituencyGroup.json","type":"application/json","lastModified":1703096480160.503,"size":23855}] 2f:{"id":"4a09f5dffdde7d16","slug":null,"title":"Constituencies for constituency dashboards","thumbnail":"56206d2476754f62c0d10b4e3eb47ef5744a898f538c1f132f3f04c262e54eec","access_level":"public","create_time":"$D2023-09-18T21:10:35.364Z","update_time":"$D2025-05-25T20:10:33.588Z","view_time":null,"first_public_time":"$D2023-09-18T21:10:35.364Z","has_unpublished_edits":null,"fork":{"id":"34336da04790ac8e","slug":null,"title":"Explore Oireachtas parliamentary questions - Choose a year (33rd Dáil)","owner":{"id":"1cc7c51c4e129cc6","login":"cassdavid","name":"David Cass"}},"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":2735,"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":{"id":"a74acf2ee4baef95","slug":"pqs-on-oireachtas-ie","title":"PQs and other resources for Oireachtas.ie","owner":{"id":"1cc7c51c4e129cc6","login":"cassdavid","name":"David Cass"}},"type":"notebook","body":{"title":"Constituencies for constituency dashboards","cells":[{"id":0,"value":"# Constituencies for constituency dashboards\n\n***experimental***","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2121,"value":"intro = md `Select a year from the dropdown and explore parliamentary questions and replies below. It may take a few moments for the page to update while the PQ database is queried.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"viewof year = Inputs.select(chooseAYear, {label: \"Select a year:\", format: x => x.year, value: chooseAYear.find(t => t.year === \"2024\"), width: 800})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2173,"value":"instructions0 = md `**Choropleth, or map shaded by data value.**\n\nHover to view information on constituency and number of questions asked.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1480,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1882,"value":"instructions = md `**Zoomable treemap by constituency, party, Deputy, question heading.**\n\nClick to zoom in. Zoom out by clicking on the top bar.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1422,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1756,"value":"**Choropleth map demonstrating numbers of questions asked by constituency.**\n\nHover to reveal information. Alternatively, refine the number by question heading further down.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2176,"value":"instructions2 = md `**Interactive choropleth responsive to question topics.**\n\nSearch for a question topic to see how many times it has been asked about in each constituency.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1457,"value":"viewof selectHeading = Inputs.text({\n label: \"Question topic\",\n placeholder: \"Start typing to search topics\",\n datalist: headings.map(d => d),\n width: 800\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1876,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2180,"value":"instructions3 = md `**Select a constituency and year to return a table of its most popular question topics and recent questions.**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1921,"value":"viewof constituencyPicker = Inputs.select(Array.from(constituencyMap).map(d => d[0]).sort(d3.ascending), {label: \"Constituency\", width: 800})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2278,"value":"constituencyMapExperimentClickable = {\n const container = yield htl.html`

`;\n const map = L.map(container, { scrollWheelZoom: false }).setView(\n [43.342686, 25.267118],\n 4\n );\n const constituencylayer = L.geoJSON(filtered).addTo(map);\n function onEachFeature(feature, layer) {\n // does this feature have a property named popupContent?\n if (feature.properties && feature.properties.CON_SEAT_) {\n layer.bindTooltip(feature.properties.CON_SEAT_);\n }\n }\n L.geoJSON(filtered, {\n onEachFeature: onEachFeature,\n filter: function (feature, layer) {\n return feature.properties.CON_SEAT_;\n }\n }).addTo(map);\n map.fitBounds(constituencylayer.getBounds(), { maxZoom: 19 });\n L.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution:\n \"© OpenStreetMap contributors\"\n }).addTo(map);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2383,"value":"deputylist = md`The TDs for the 33rd Dáil in [**${constituencyPicker}**](https://www.oireachtas.ie/en/members/tds/?tab=constituency&constituency=%2Fie%2Foireachtas%2Fhouse%2Fdail%2F33%2Fconstituency%2F${\n TDs[0].representCode\n}) were **Deputies ${list1} ${list2} ${list3}** In ${\n year.year\n}, they asked **${format(\n PQsFilteredByConstituencyTotal\n)}** parliamentary questions.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2496,"value":"questionsChart = Plot.plot({\n marginLeft: 230,\n color: {scheme: \"Category10\"},\n subtitle: htl.html`

Top 30 parliamentary question topics in ${constituencyPicker}

`,\n x: {label: \"Number of questions\"},\n y: {label: \"Question topic\"},\n marks: [\n Plot.barX(topQuestions, {x: \"1\", y: \"0\", fill: \"#1f77b4\", tip: true, sort: {y: \"x\", reverse: true}}),\n Plot.ruleX([0]),\n Plot.axisX({fontSize: 12}),\n Plot.axisY({fontSize: 12})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2196,"value":" \n\n\n\n\n \n \n \n \n \n \n \n ${PQsFilteredByConstituency.slice(0, 10).map(PQsFilteredByConstituency => htl.html`\n \n \n `)}\n \n

Question Heading	Number of Questions
${PQsFilteredByConstituency[\"0\"]}	${PQsFilteredByConstituency[\"1\"]}

\n ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"HTML_table","database":"$undefined"},{"id":2266,"value":"instructions4 = md `Take a closer look at some of the most recent questions asked by representatives in **${constituencyPicker}**, or see all questions on our [dedicated page](https://www.oireachtas.ie/en/debates/questions/).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2245,"value":"$34","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"constituencyQuestions","database":"$undefined"},{"id":2526,"value":"viewof headingPicker = Inputs.select(Array.from(new Set((rolledWithConstituencyMemberCode.filter(d => d.constituency === `${constituencyPicker}`)).map(d => d.heading).sort(d3.ascending))), {label: \"Pick a topic\", width: 800})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2522,"value":"$35","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"constituencyQuestions1","database":"$undefined"},{"id":1063,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1065,"value":"**Appendix - code**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"Jan = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-01-01&date_end=${year.value}-01-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"orals = joinedPQs.filter(d => d.question.questionType == \"oral\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":814,"value":"oralPQs = orals.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"Feb = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-02-01&date_end=${year.value}-02-28&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2231,"value":"leap = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.year}-02-29&date_end=${year.year}-02-29&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2233,"value":"leapYearDateCheck = year.value + \"-02-29\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2235,"value":"leapData = leap.results.filter(d => d.contextDate == `${leapYearDateCheck}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"Mar = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-03-01&date_end=${year.value}-03-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"Apr = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-04-01&date_end=${year.value}-04-30&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"May = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-05-01&date_end=${year.value}-05-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"Jun = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-06-01&date_end=${year.value}-06-30&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"Jul = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-07-01&date_end=${year.value}-07-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":782,"value":"Aug = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-08-01&date_end=${year.value}-08-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"Sep = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-09-01&date_end=${year.value}-09-30&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"Oct = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-10-01&date_end=${year.value}-10-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"Nov = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-11-01&date_end=${year.value}-11-30&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"Dec = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-12-01&date_end=${year.value}-12-31&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"rolld = d3.flatRollup(filterTD, v => v.length,\n d => d.question.to.showAs,\n d => d.question.debateSection.showAs,\n d => (d.question.date).toLocaleString(undefined, {\n \"weekday\": \"long\",\n \"year\": \"numeric\",\n \"day\": \"numeric\",\n \"month\": \"long\"\n}), \n d => d.question.by.showAs,\n d => d.question.showAs,\n d => d.question.questionType,\n d => d.question.questionNumber,\n d => d.question.by.memberCode,\n)\n .sort((a, b) => d3.ascending(a, b))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"rolld1 = d3.flatRollup(joinedPQs, v => v.length,\n d => d.question.to.showAs,\n d => d.question.debateSection.showAs,\n d => (d.question.date).toLocaleString(undefined, {\n \"weekday\": \"long\",\n \"year\": \"numeric\",\n \"day\": \"numeric\",\n \"month\": \"long\"\n}), \n d => d.question.by.showAs,\n d => d.question.showAs,\n d => d.question.uri\n)\n .sort((a, b) => d3.ascending(a, b))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"hierarchyWithMapChildren = d3.hierarchy(d3.rollup(filterTD, d => d.length, d => d.question.to.showAs, d => d.question.debateSection.showAs))\n .sum(([, value]) => value)\n .sort((a, b) => b.value - a.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2734,"value":"joinedPQs = fetch(\n \"https://raw.githubusercontent.com/bubcass/PQs/main/data/PQs_2025.json\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"//joinedPQs = ([...Jan.results, ...Feb.results, ...leapData, ...Mar.results, ...Apr.results, ...May.results, ...Jun.results, ...Jul.results, ...Aug.results, ...Sep.results, ...Oct.results, ...Nov.results, ...Dec.results])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":691,"value":"joinedOralPQs = joinedPQs.filter(d => d.question.questionType == \"oral\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"rollup = d3.rollup(\n questionType,\n v => (v.length),\n d => d.question.to.showAs,\n d => d.question.debateSection.showAs,\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"rollupHierarchy = d3.hierarchy(rollup)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"PQhierarchy = d3.hierarchy(rollup)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"packWithMapChildren = data => d3.pack()\n .size([width - 2, height - 2])\n .padding(3)\n (hierarchyWithMapChildren)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"hierarchyWithMapChildren1 = d3.hierarchy(d3.rollup([...Jan.results, ...Feb.results, ...Mar.results, ...Apr.results, ...May.results, ...Jun.results, ...Jul.results, ...Sep.results, ...Oct.results, ...Nov.results, ...Dec.results], d => d.length, d => d.question.to.showAs, d => d.question.debateSection.showAs, d => d.question.by.showAs))\n .sum(([, value]) => value)\n .sort((a, b) => b.value - a.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"packWithMapChildren1 = data => d3.pack()\n .size([width - 2, height - 2])\n .padding(3)\n (hierarchyWithMapChildren1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"data = ({\n name: \"Parliamentary Questions\",\n children:\n Array.from(\n d3.rollup(filterTD, v => v.length, ...keysToGroupBy), \n ([name, children]) => ({name, children: Array.from(children, ([name, children]) => ({name, children: Array.from(children, ([name, children]) => ({name, children: Array.from(children, ([name, children]) => ({name, children: Array.from(children, ([name, value]) => ({name, value})\n )}) )}))})) })\n )\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"keysToGroupBy = [d => d.question.to.showAs, d => d.question.debateSection.showAs, d => (d.contextDate).toLocaleString(undefined, {\n \"weekday\": \"long\",\n \"day\": \"numeric\",\n \"month\": \"long\"\n}), d => d.question.by.showAs, d => d.question.showAs] ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"treemap = data => d3.treemap()\n .tile(tile)\n (d3.hierarchy(data)\n .sum(d => d.value)\n .sort((a, b) => b.value - a.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"function tile(node, x0, y0, x1, y1) {\n d3.treemapBinary(node, 0, 0, width, height);\n for (const child of node.children) {\n child.x0 = x0 + child.x0 / width * (x1 - x0);\n child.x1 = x0 + child.x1 / width * (x1 - x0);\n child.y0 = y0 + child.y0 / height * (y1 - y0);\n child.y1 = y0 + child.y1 / height * (y1 - y0);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"name = d => d.ancestors().reverse().map(d => d.data.name).join(\"/\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"height = 800","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"width = 900","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"color = d3.scaleOrdinal().range([\"#444444\", \"#7F6C2E\", \"#444444\"]); \n//color = d3.scaleOrdinal().range([\"#B2BEB5\", \"#7393B3\", \"#808080\"]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1290,"value":"//color1 = d3.scaleOrdinal().range([\"#444444\", \"#7F6C2E\", \"#444444\"]); \ncolor1 = d3.scaleOrdinal().range([\"#7F6C2E\", \"#444444\", \"#7F6C2E\"]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":643,"value":"allHeadings = rolld1.map(row => row[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"numberOfHeadings = Array.from(new Set(allHeadings))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"headingsTotal = numberOfHeadings.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"yearlyTotal = Jan.head.counts.questionCount + Feb.head.counts.questionCount + Mar.head.counts.questionCount +Apr.head.counts.questionCount + May.head.counts.questionCount + Jun.head.counts.questionCount + Jul.head.counts.questionCount + Sep.head.counts.questionCount + Oct.head.counts.questionCount + Nov.head.counts.questionCount + Dec.head.counts.questionCount","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":534,"value":"format = d3.format(\",d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"questionType = [...joinedPQs]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"members = fetch(\"https://api.oireachtas.ie/v1/members?date_start=1900-01-01&chamber_id=&chamber=dail&house_no=33&date_end=2099-01-01&limit=5000\").then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2717,"value":"members34 = fetch(\n \"https://api.oireachtas.ie/v1/members?chamber=dail&house_no=34&limit=5000\"\n).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1983,"value":"parties = Array.from(new Set((members.results).map(d => d.member.memberships[0].membership.parties[0].party.showAs))).sort(d3.ascending)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2719,"value":"parties34 = Array.from(\n new Set(\n members34.results.map(\n (d) => d.member.memberships[0].membership.parties[0].party.showAs\n )\n )\n).sort(d3.ascending)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":896,"value":"TD = Array.from(new Set(questionType.map(d => d.question.by.showAs)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1149,"value":"TDAlphabetically = TD.sort((a, b) => d3.ascending(a, b))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":906,"value":"filterTD = [...questionType];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":698,"value":"import {select} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":744,"value":"chooseAYear = [\n { year: \"2025\", value: 2025 },\n { year: \"2024\", value: 2024 },\n { year: \"2023\", value: 2023 },\n { year: \"2022\", value: 2022 },\n { year: \"2021\", value: 2021 },\n { year: \"2020\", value: 2020 }\n //{year: \"2019\", value: 2019},\n //{year: \"2018\", value: 2018},\n //{year: \"2017\", value: 2017},\n //{year: \"2016\", value: 2016},\n //{year: \"2015\", value: 2015},\n //{year: \"2014\", value: 2014},\n //{year: \"2013\", value: 2013},\n //{year: \"2012\", value: 2012},\n //{year: \"2011\", value: 2011},\n //{year: \"2010\", value: 2010},\n //{year: \"2009\", value: 2009},\n //{year: \"2008\", value: 2008}\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":874,"value":"function addColumn(tableData, newColumnName, newColumnFunction) {\n return tableData.map(row => {\n let returnObject = row;\n returnObject[newColumnName] = newColumnFunction(row)\n return returnObject\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":881,"value":"debateURL = addColumn(rolld, 'Question URL', row => ('https://www.oireachtas.ie/en/debates/question/'+ row[2]+ '/'+ row[6]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":926,"value":"deputyRollupForScatter = d3.flatRollup(\n questionType,\n v => (v.length),\n d => d.question.by.showAs\n) \n .sort(([, a], [, b]) => d3.ascending(a, b))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":960,"value":"mean = d3.mean(numbersOfPQs, d => d.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":962,"value":"numbersOfPQs = Array.from(d3.flatRollup(questionType, v => (v.length),\n d => d.question.by.showAs),\n ([name, value]) => ({name, value}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"median = d3.median(numbersOfPQs, d => d.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"deviation = d3.format(\"0.2f\")(d3.deviation(numbersOfPQs, d => d.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":980,"value":"PQArray = Array.from(d3.flatRollup(questionType, v => v.length, d => d.contextDate, d => d.question.to.showAs, d => d.question.questionType),\n ([date, department, type, value]) => ({date: new Date(date), department, type, value}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"PQsByDate = PQArray.slice().sort((a, b) => d3.ascending(a.date, b.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1114,"value":"departments = Array.from(new Set(PQsByDate.map(d => d.department).sort(d3.ascending)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1448,"value":"headings = Array.from(new Set(rolledWithConstituencyMemberCode.map(d => d.heading).sort(d3.ascending)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2519,"value":"headingsForFilteredConstituency = Array.from(new Set((rolledWithConstituencyMemberCode.filter(d => d.constituency === `${constituencyPicker}`)).map(d => d.heading).sort(d3.ascending)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2524,"value":"questionsFromHeadings = rolledWithConstituencyMemberCode.filter(d => d.constituency === `${constituencyPicker}`).filter(d => d.heading === `${headingPicker}`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1477,"value":"filteredChoroplethHeadings = d3.rollup(rolledWithConstituencyMemberCode.filter(d => d.heading == `${selectHeading}`), v => v.length, d => d.constituency)\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2248,"value":"filteredWithDeputy = rolledWithConstituencyMemberCode.filter(d => d.constituency == `${constituencyPicker}`).slice().sort((a, b) => d3.descending(a.date, b.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1769,"value":"filterQuestionHeadings = filterByHeading === \"Do not filter\" ? [...choroplethData] : [...filteredChoroplethHeadings]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1441,"value":"choroplethData = d3.rollup(rolledWithConstituencyMemberCode, v => v.length, d => d.constituency)\n // ([constituency, total]) => ({constituency, total}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1386,"value":"rolledWithConstituencyMemberCode = {\n const index = d3.index(constituencyGroup, (d) => d.memberCode);\n return flatRollMap.map(({ memberCode, ...values }) => ({\n memberCode,\n constituency: index.get(memberCode)?.constituency,\n constituencyURL: index.get(memberCode)?.conURL,\n party: index.get(memberCode)?.party,\n ...values\n }));\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2696,"value":"constituenciesWithURL = rolledWithConstituencyMemberCode.map((d) => ({\n constituency: d.constituency,\n constituencyURL: d.constituencyURL\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2701,"value":"uniqueMap = {\n const map = new Map();\n constituenciesWithURL.forEach((item) => {\n map.set(item.constituency, item.constituencyURL); // Sets only unique entries\n });\n return map;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1158,"value":"sittingDays = Array.from(d3.rollup(joinedPQs, v => v.length, d => d.contextDate))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1376,"value":"//import {constituencyGroup} from \"05e1988c11cde88e\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1393,"value":"constituencyGroup","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1384,"value":"indexed = d3.index(constituencyGroup, d => d.name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1398,"value":"flatRollMap = rolld.map(([department, heading, date, name, questionText, questionType, questionNumber, memberCode, questionCount, URL]) => ({department, heading, date, name, questionText, questionType, questionNumber, memberCode, questionCount, URL}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1408,"value":"//Without headings filter\nfilteredPQs = rolledWithConstituencyMemberCode.filter(d => d.name != null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1410,"value":"data3 = ({\n name: \"Parliamentary Questions\",\n children:\n Array.from(\n d3.rollup(filteredPQs, v => v.length, d => d.constituency, d => d.heading, d => d.party, d => d.name,), \n ([name, children]) => ({name, children: Array.from(children, ([name, children]) => ({name, children: Array.from(children, ([name, children]) => ({name, children: Array.from(children, ([name, value]) => ({name, value})\n )}) )}))})) \n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1413,"value":"PQRollup = ({\n name: \"Parliamentary Questions\",\n children:\n Array.from(\n d3.rollup(filteredPQs, v => v.length, d => d.party), \n ([name, size]) => ({name, size})\n )\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1417,"value":"import {Treemap} from \"@d3/treemap\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1420,"value":"import {treemapPQs}\nwith {data3 as data}\nfrom \"05e1988c11cde88e\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1482,"value":"constituencyFile = FileAttachment(\"Constituency_Boundaries_-_Generalised_20m_-_National_Electoral_Boundaries_-_2017_no_seat_numbers.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2658,"value":"constituencyFileWithURL = {\n constituencyFile.features.forEach((feature) => {\n feature.properties.url = `https://www.oireachtas.ie`;\n });\n return constituencyFile;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1546,"value":"constituencyMap = new Map(constituencyFile.features.map(d => [(d.properties.CON_SEAT_), d]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1484,"value":"circle = d3.geoCircle().center([-8, 53.4]).radius(1.9)()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1771,"value":"viewof filterByHeading = select({\n title: \"Choose whether to filter questions by heading.\",\n description: \"Questions are shown as totals by default. Alternatively, choose to see question totals refined by heading.\",\n options: [\"Do not filter\", \"Filter by headings\"],\n value: \"Do not filter\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1942,"value":"PQsFilteredByConstituency = Array.from(d3.rollup(filteredPQs.filter(d => d.constituency == `${constituencyPicker}`), v => v.length, d => d.heading)).slice().sort((a, b) => d3.descending(a[1], b[1]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2513,"value":"PQsFilteredByConstituencyTotal = (filteredPQs.filter(d => d.constituency == `${constituencyPicker}`)).length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2493,"value":"topQuestions = PQsFilteredByConstituency.slice(0,30)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2109,"value":"choroplethdata = FileAttachment(\"choroplethData.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2229,"value":"//constituencyGroup = FileAttachment(\"correctedConstituencyGroup@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2581,"value":"$36","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2715,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2585,"value":"//Get list of Deputies from open data API\nmembersFromAPI = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=2020-01-01&chamber_id=&chamber=dail&date_end=2024-10-01&limit=5000\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2712,"value":"//Get list of Deputies from open data API\nmembersFromAPI34 = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=2024-01-01&chamber_id=&chamber=dail&date_end=2030-12-31&limit=5000\"\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2281,"value":"filtered = constituencyFile.features.filter(d => d.properties.CON_SEAT_ == `${constituencyPicker}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1964,"value":"//constituencyTable = Inputs.table(PQsFilteredByConstituency, {\n columns: [\n \"0\",\n \"1\"\n ],\n header: {\n 0: \"Question Heading\",\n 1: \"Number of Questions Asked\"\n },\n layout: \"auto\",\n height: 500,\n rows: 10,\n sort: \"1\",\n reverse: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2369,"value":"PQsFilteredByConstituency1 = constituencyTDs.filter(d => d.constituency == `${constituencyPicker}`).slice().sort((a, b) => d3.descending(a.date, b.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2340,"value":"list1 = TDs.slice(0, -2).map(d =>d.name+\", \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2346,"value":"list3 = TDs.slice(-1).map(d =>d.name+\".\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2343,"value":"list2 = TDs.slice(-2, -1).map(d =>d.name+\" and \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2349,"value":"TDs = Array.from(d3.flatGroup(PQsFilteredByConstituency1, d => d.name, d => d.representCode),\n ([name, representCode]) => ({name, representCode}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2387,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2456,"value":"Plot.dot(constituencyFile, Plot.hexbin({r: (d => choroplethData.get(d.properties.CON_SEAT_))}), Plot.geoCentroid()).plot({projection: {\n type: \"albers\",\n domain: circle,\n rotate:([1, 0]),\n parallels: ([50, 60]),\n inset: \"15\"\n }})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1","titling":"auto"}} 30:"$2f:body"