2b:null 2c:["$","title",null,{"children":"PQs by Deputy (34th Dáil) | David Cass | Observable"}] 31:Tb55,chart = { // Build your hierarchy root const root = packWithMapChildren(hierarchyWithMapChildren); const svg = d3 .create("svg") .attr("title", "Packed circle chart") .attr("viewBox", [0, 0, width, height]) .style("font", "400 16px/1.4 'IBM Plex Sans', 'IBM Plex Sans', sans-serif") .attr("text-anchor", "middle"); // -------- Circles & leaf labels -------- const node = svg .selectAll("g") .data(d3.group(root.descendants(), (d) => d.height)) .join("g") .selectAll("g") .data((d) => d[1]) .join("g") .attr("transform", (d) => `translate(${d.x + 1},${d.y + 1})`); node .append("circle") .attr("r", (d) => d.r) .attr("fill", (d) => color(d.height)) .style("stroke", "black"); const leaf = node.filter((d) => !d.children); leaf .select("circle") .attr("id", (d) => (d.leafUid = DOM.uid("leaf")).id) .style("stroke", "black"); leaf .append("clipPath") .attr("id", (d) => (d.clipUid = DOM.uid("clip")).id) .append("use") .attr("xlink:href", (d) => d.leafUid.href); leaf .append("text") .attr("clip-path", (d) => d.clipUid) .attr("display", (d) => (d.r < 90 ? "none" : "inherit")) .selectAll("tspan") .data((d) => (d.data[0] || d.data["name"]).split(/(?=[A-Z][a-z])|\s+/g)) .join("tspan") .attr("x", 0) .attr("y", (d, i, nodes) => `${i - nodes.length / 2 + 0.8}em`) .attr("fill", "#444444") .text((d) => d); node.append("title").text( (d) => `${d .ancestors() .map((d) => d.data[0] || d.data["name"]) .reverse() .join(" / ")}\nTotal: ${format(d.value)}` ); // -------- Department labels (inside circles) -------- const deptNodes = root.descendants().filter((d) => d.height === 1); const labelLayer = svg .append("g") .attr("pointer-events", "none") .attr("text-anchor", "middle") .style("font-family", "'IBM Plex Sans', 'IBM Plex Sans', sans-serif") .style("font-size", "16px") .style("font-weight", "700"); const labelG = labelLayer .selectAll("g.dept-label") .data(deptNodes, (d) => d.data.id || d.data[0] || d.data.name) .join("g") .attr("class", "dept-label") .attr("transform", (d) => `translate(${d.x}, ${d.y})`); // center of circle // Main text in white const mainText = labelG .append("text") .attr("dy", "0.35em") .attr("fill", "white") .text((d) => d.data[0] || d.data.name); // Grey halo behind it mainText .clone(true) .lower() .attr("fill", "none") .attr("stroke", "#444444") .attr("stroke-width", 6) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round"); // -------- Byline -------- svg .append("text") .attr("id", "byline") .attr("x", width) .attr("y", height) .attr("dy", "-2em") .attr("text-anchor", "end"); return svg.node(); }32:T13f6,treemapChart1 = { // --- bring in IBM Plex Sans font inline --- document.head.insertAdjacentHTML( "beforeend", `` ); 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-size", "16px") .style( "font-family", "'IBM Plex Sans', system-ui, -apple-system, 'Segoe UI', Roboto, Arial, sans-serif" ) .attr("fill", "white"); let group = svg.append("g").call(render, treemap(experimental)); 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 .filter((d) => !d.children) .on("click", (event, d) => { if (d.data.url) window.open(d.data.url, "_blank"); // keep original behaviour event.stopPropagation(); }); 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)) .attr("font-family", "inherit") // inherit Plex Sans .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); // ========================= // NEW: Leaf affordance only // (doesn't touch click logic) // ========================= const leaf = node.filter((d) => !d.children); // Cursor changes leaf.select("rect").attr("cursor", "pointer"); leaf.select("text").attr("cursor", "pointer"); // Underline the label on hover (purely visual) leaf .on("mouseenter.afford", function () { d3.select(this).select("text").style("text-decoration", "underline"); }) .on("mouseleave.afford", function () { d3.select(this).select("text").style("text-decoration", null); }); // Optional: tiny ↗ glyph as link indicator (does not capture clicks) // If you don't want it, delete this block. leaf .append("text") .attr("class", "ext-icon") .attr("y", 14) .attr("text-anchor", "end") .attr("font-size", 14) .attr("fill-opacity", 0.75) .attr("font-family", "inherit") .style("pointer-events", "none") // crucial: never intercept clicks .text("↗"); group.call(position, root); // Place ↗ at top-right inside each leaf rect after positioning leaf.select(".ext-icon").attr("x", (d) => x(d.x1) - x(d.x0) - 6); } 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))); } 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) ); } 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:Tc98,//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(data)); 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(); }34:T94c,chart2 = { const root = packWithMapChildren(hierarchyWithMapChildren); let focus = root; let view; const svg = d3.create("svg") .attr("viewBox", `-${width / 2} -${height / 2} ${width} ${height}`) .style("display", "block") .style("margin", "0 -14px") .style("background", color1(1)) .style("cursor", "pointer") .on("click", (event) => zoom(event, root)); const node = svg.append("g") .selectAll("circle") .data(root.descendants().slice(1)) .join("circle") .attr("fill", d => d.children ? color1(d.depth) : ("#444444")) .attr("pointer-events", d => !d.children ? "none" : null) .on("mouseover", function() { d3.select(this).attr("stroke", "#000"); }) .on("mouseout", function() { d3.select(this).attr("stroke", null); }) .on("click", (event, d) => focus !== d && (zoom(event, d), event.stopPropagation())); const label = svg.append("g") .attr("fill", "white") .style("font", "400 16px/1 'Source Sans Pro', 'Noto Sans', sans-serif") .attr("pointer-events", "none") .attr("text-anchor", "middle") .selectAll("text") .data(root.descendants()) .join("text") .style("fill-opacity", d => d.parent === root ? 1 : 0) .style("display", d => d.parent === root ? "inline" : "none") .text(d => d.data[0]); zoomTo([root.x, root.y, root.r * 2]); function zoomTo(v) { const k = width / v[2]; view = v; label.attr("transform", d => `translate(${(d.x - v[0]) * k},${(d.y - v[1]) * k})`); node.attr("transform", d => `translate(${(d.x - v[0]) * k},${(d.y - v[1]) * k})`); node.attr("r", d => d.r * k); } function zoom(event, d) { const focus0 = focus; focus = d; const transition = svg.transition() .duration(event.altKey ? 7500 : 750) .tween("zoom", d => { const i = d3.interpolateZoom(view, [focus.x, focus.y, focus.r * 2]); return t => zoomTo(i(t)); }); label .filter(function(d) { return d.parent === focus || this.style.display === "inline"; }) .transition(transition) .style("fill-opacity", d => d.parent === focus ? 1 : 0) .on("start", function(d) { if (d.parent === focus) this.style.display = "inline"; }) .on("end", function(d) { if (d.parent !== focus) this.style.display = "none"; }); } return svg.node(); }35:T100d,// Copyright 2021-2023 Observable, Inc. // Released under the ISC license. // https://observablehq.com/@d3/bubble-chart function BubbleChart( data, { name = ([x]) => x, // alias for label label = name, // given d in data, returns text to display on the bubble value = ([, y]) => y, // given d in data, returns a quantitative size group, // given d in data, returns a categorical value for color title, // given d in data, returns text to show on hover link, // given a node d, its link (if any) linkTarget = "_blank", // the target attribute for links, if any width = 800, // outer width, in pixels height = width, // outer height, in pixels padding = 3, // padding between circles margin = 1, // default margins marginTop = margin, // top margin, in pixels marginRight = margin, // right margin, in pixels marginBottom = margin, // bottom margin, in pixels marginLeft = margin, // left margin, in pixels groups, // array of group names (the domain of the color scale) colors = d3.schemeCategory10, //["#1f77b4","#ff7f0e","#2ca02c","#d62728","#9467bd","#8c564b","#e377c2", "#17becf","#bcbd22"], // an array of colors (for groups) fill = "#ccc", // a static fill color, if no group channel is specified fillOpacity = 1, // the fill opacity of the bubbles stroke, // a static stroke around the bubbles strokeWidth, // the stroke width around the bubbles, if any strokeOpacity // the stroke opacity around the bubbles, if any } = {} ) { // Compute the values. const D = d3.map(data, (d) => d); const V = d3.map(data, value); const G = group == null ? null : d3.map(data, group); const I = d3.range(V.length).filter((i) => V[i] > 0); // Unique the groups. if (G && groups === undefined) groups = I.map((i) => G[i]); groups = G && new d3.InternSet(groups); // Construct scales. const color = G && d3.scaleOrdinal(groups, colors); // Compute labels and titles. const L = label == null ? null : d3.map(data, label); const T = title === undefined ? L : title == null ? null : d3.map(data, title); // Compute layout: create a 1-deep hierarchy, and pack it. const root = d3 .pack() .size([width - marginLeft - marginRight, height - marginTop - marginBottom]) .padding(padding)(d3.hierarchy({ children: I }).sum((i) => V[i])); const svg = d3 .create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [-marginLeft, -marginTop, width, height]) .attr("style", "max-width: 100%; height: auto; height: intrinsic") // background-color: #7f7f7f") .attr("font-size", 12) .attr("font-family", "IBM Plex Sans") .attr("text-anchor", "middle"); const leaf = svg .selectAll("a") .data(root.leaves()) .join("a") .attr( "xlink:href", link == null ? null : (d, i) => link(D[d.data], i, data) ) .attr("target", link == null ? null : linkTarget) .attr("transform", (d) => `translate(${d.x},${d.y})`); leaf .append("circle") .attr("stroke", stroke) .attr("stroke-width", strokeWidth) .attr("stroke-opacity", strokeOpacity) .attr("fill", (d) => color(d.data)) .attr("fill-opacity", fillOpacity) .attr("r", (d) => d.r); if (T) leaf.append("title").text((d) => T[d.data]); if (L) { // A unique identifier for clip paths (to avoid conflicts). const uid = `O-${Math.random().toString(16).slice(2)}`; leaf .append("clipPath") .attr("id", (d) => `${uid}-clip-${d.data}`) .append("circle") .attr("r", (d) => d.r); leaf .append("text") .attr( "clip-path", (d) => `url(${new URL(`#${uid}-clip-${d.data}`, location)})` ) .selectAll("tspan") .data((d) => `${L[d.data]}`.split(/\n/g)) .join("tspan") .attr("x", 0) .attr("y", (d, i, D) => `${i - D.length / 2 + 0.85}em`) .attr("fill", "white") .attr("fill-opacity", (d, i, D) => (i === D.length - 1 ? 0.7 : null)) .text((d) => d); } return Object.assign(svg.node(), { scales: { color } }); }36:[{"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":1695055040342.087,"size":4685240},{"id":"a769f3420e0b32ce27fe0b9d41dc2dd027922ce77d9509afe366e690aa69523097634eb3c735ae806f011f36e6fc998c7179ca4c5a1defe151af6fb2ac17edd4","href":"https://static.observableusercontent.com/files/a769f3420e0b32ce27fe0b9d41dc2dd027922ce77d9509afe366e690aa69523097634eb3c735ae806f011f36e6fc998c7179ca4c5a1defe151af6fb2ac17edd4","name":"choroplethData.json","type":"application/json","lastModified":1695055040342.087,"size":849}] 2f:{"id":"eaded965f0865b13","slug":null,"title":"PQs by Deputy (34th Dáil)","thumbnail":"f0ea4f0d0f4be6eba5e241ab03f38147fa42726f9104c58fa5403f3f44a895c0","access_level":"public","create_time":"$D2023-09-18T16:37:20.342Z","update_time":"$D2026-06-12T08:28:50.391Z","view_time":null,"first_public_time":"$D2023-09-18T16:37:20.342Z","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":3073,"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":"PQs by Deputy (34th Dáil)","cells":[{"id":0,"value":"# **PQs by Deputy (34th Dáil)**\n\n***experimental***","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":620,"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, {\n label: \"Select a year:\",\n format: (x) => x.year,\n value: chooseAYear.find((t) => t.year === \"2026\"),\n width: 800\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2441,"value":"

The number of questions asked by Deputies may vary considerably. Take a look at the range below by hovering over circles, sized by question count. You can also click through to Member profiles.

Members have asked ${format(rolld1.length)} parliamentary questions so far this year.

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"overview","database":"$undefined"},{"id":2420,"value":"deputiesChart = BubbleChart(PQRollupDeputies, {\n label: (d) =>\n [\n d.id.split(\".\")[0].split(\"-\").join(\" \"),\n d.value.toLocaleString(\"en\")\n ].join(\"\\n\"),\n value: (d) => d.value,\n group: (d) => d.id.split(\".\")[1],\n title: (d) =>\n `${d.id.split(\".\")[0].split(\"-\").join(\" \")} has asked ${format(\n d.value\n )} ${groupByPriority} in the period ${year.year}`,\n link: (d) => `https://www.oireachtas.ie/en/members/member/${d.id}`,\n src: (d) =>\n `https://data.oireachtas.ie/ie/oireachtas/member/id/${d.id}/image/thumb`\n //width: 800\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2143,"value":"viewof selectYourTD = Inputs.select(TDAlphabetically, {label: \"Select a TD\", value: TDAlphabetically.find(t => t.name === \"Aengus Ó Snodaigh\"), width: 800})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2170,"value":"viewof groupByPriority = Inputs.select([\"oral and written questions\", \"oral questions\"], {label: \"Question type\", width: 800})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2240,"value":"instructions = md`**Large circles denote Departments and smaller circles denote question topics, sized by number of questions.**\n\nHover to reveal information.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2525,"value":" $\"Deputy$ ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2250,"value":"questionInfo = htl.html`

Deputy ${selectYourTD} asked ${format(\n filterTD.length\n)} ${groupByPriority} in this annual period, which covers ${\n year.year\n}.

The Deputy asked questions coming under the heading ${\n topHeadingByTD[0][0]\n} the most, asking ${\n topHeadingByTD[0][1]\n} questions about the topic. Take a look at the breakdown of these questions with these interactive charts.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1054,"value":"drillDown = md`**Click through** to drill down to the **Department to which the question is directed, the question topic, date, the text of the question and the reply as published.** \n\nClick on the top panel to **zoom out** again.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2864,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":501,"value":"//viewof search = Inputs.search(rolld, {label: html`

`, width: 800})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2379,"value":"viewof search","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2377,"value":"viewof search = Inputs.select(new Set(rolld.map(d => d[1]).sort((a, b) => d3.ascending(a, b))) , {\n label: \"Question topic\",\n placeholder: \"Start typing to search\",\n width: 800\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2398,"value":"filteredHeadingsTable = rolld.filter(d => d[1] == `${search}`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2374,"value":"search","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2315,"value":"keywordSearch = htl.html`

Further refine your search by question topic. Check the results in the table below and read the questions and replies in the Official Report.

The Deputy has asked ${filteredHeadingsTable.length} question(s) about ${search}

.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2291,"value":"\n\n\n\n\n \n \n \n \n \n \n \n \n \n ${filteredHeadingsTable.slice(0, 100).map(filteredHeadingsTable => htl.html`\n \n \n \n \n `)}\n \n

Date	Department	Question	Reply
${new Date(filteredHeadingsTable[\"2\"]).toLocaleString(\"en-IE\", {\n dateStyle: 'full'\n })}	${filteredHeadingsTable[\"0\"]}	${filteredHeadingsTable[\"4\"]}	${'Read reply'}

\n ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"HTML_Table","database":"$undefined"},{"id":1232,"value":"**Zoomable circle-packing. Drill down to the Department to which the question is directed, the question topic, date, Deputy and text of the question.**\n\nClick outside circles to zoom out again.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":204,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","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 = [...Jan1.results, ...Jan2.results, ...Jan3.results, ...Jan4.results]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2973,"value":"Jan1 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-01-01&date_end=${year.value}-01-08&limit=4000&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2975,"value":"Jan2 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-01-09&date_end=${year.value}-01-17&limit=9999&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2977,"value":"Jan3 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-01-18&date_end=${year.value}-01-23&limit=9999&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2979,"value":"Jan4 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-01-24&date_end=${year.value}-01-31&limit=9999&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"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":2989,"value":"Feb = [...Feb1.results, ...Feb2.results, ...Feb3.results, ...Feb4.results]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"Feb1 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-02-01&date_end=${year.value}-02-08&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2983,"value":"Feb2 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-02-09&date_end=${year.value}-02-16&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2985,"value":"Feb3 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-02-17&date_end=${year.value}-02-23&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2987,"value":"Feb4 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-02-24&date_end=${year.value}-02-28&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2562,"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":2564,"value":"leapYearDateCheck = year.value + \"-02-29\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2566,"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 = [...Mar1.results, ...Mar2.results, ...Mar3.results, ...Mar4.results]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2991,"value":"Mar1 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-03-01&date_end=${year.value}-03-08&limit=9999&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2993,"value":"Mar2 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-03-09&date_end=${year.value}-03-16&limit=4000&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2995,"value":"Mar3 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-03-17&date_end=${year.value}-03-23&limit=4000&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2997,"value":"Mar4 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-03-24&date_end=${year.value}-03-31&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"Apr = [...Apr1.results, ...Apr2.results, ...Apr3.results, ...Apr4.results]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3000,"value":"Apr1 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-04-01&date_end=${year.value}-04-08&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3002,"value":"Apr2 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-04-09&date_end=${year.value}-04-16&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3004,"value":"Apr3 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-04-17&date_end=${year.value}-04-23&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3006,"value":"Apr4 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-04-24&date_end=${year.value}-04-30&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"May = [...May1.results, ...May2.results, ...May3.results, ...May4.results]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3009,"value":"May1 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-05-01&date_end=${year.value}-05-08&limit=4000&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3011,"value":"May2 = fetch(`https://api.oireachtas.ie/v1/questions?date_start=${year.value}-05-08&date_end=${year.value}-05-16&limit=4000&qtype=oral,written`).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3013,"value":"May3 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-05-17&date_end=${year.value}-05-23&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3015,"value":"May4 = fetch(\n `https://api.oireachtas.ie/v1/questions?date_start=${year.value}-05-24&date_end=${year.value}-05-31&limit=4000&qtype=oral,written`\n).then((response) => response.json())","pinned":true,"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),\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":true,"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":3029,"value":"joinedPQs = fetch(\n `https://raw.githubusercontent.com/bubcass/PQs/refs/heads/main/PQs_${year.value}_paginated.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]).filter(d => d.question.by.showAs != null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2479,"value":"problemPQs = ([...Jan.results, ...Feb.results, ...Mar.results, ...Apr.results, ...May.results, ...Jun.results, ...Jul.results, ...Aug.results, ...Sep.results, ...Oct.results, ...Nov.results, ...Dec.results]).filter(d => d.question.by.showAs == null).length","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, value]) => ({name, value})\n )}) )}))})) \n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2830,"value":"experimental = ({\n name: \"Parliamentary Questions\",\n children: Array.from(\n d3.rollup(\n dataWithURL,\n (v) => v, // Preserve all entries at the final level\n ...keysToGroupBy1\n ),\n ([name, children]) => ({\n name,\n children: Array.from(children, ([name, children]) => ({\n name,\n children: Array.from(children, ([name, children]) => ({\n name,\n children: Array.from(children, ([key, values]) => ({\n name: values[0].question, // Make sure `name` aligns with your structure\n value: values.length, // Use values length if counting\n url: values[0].url // Ensure this maps directly to the URL field\n }))\n }))\n }))\n })\n )\n})","pinned":true,"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 => new Date(d.contextDate).toLocaleString(undefined, {\n \"weekday\": \"long\",\n \"day\": \"numeric\",\n \"month\": \"long\"\n}), d => d.question.showAs] ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2833,"value":"keysToGroupBy1 = [\n (d) => d.department,\n (d) => d.heading,\n (d) =>\n new Date(d.date).toLocaleString(undefined, {\n weekday: \"long\",\n day: \"numeric\",\n month: \"long\"\n }),\n (d) => d.question\n]","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([\"#7f7f7f\", \"#1f77b4\", \"#ff7f0e\"]); \n//color = d3.scaleOrdinal().range([\"#B2BEB5\", \"#7393B3\", \"#808080\"]);","pinned":true,"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([\"#17becf\", \"#1f77b4\", \"#7f7f7f\"]);","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 = groupByPriority === \"oral and written questions\" ? [...joinedPQs] : [...joinedOralPQs];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"members = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=1900-01-01&chamber_id=&chamber=dail&house_no=34&date_end=2099-01-01&limit=500\"\n).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2964,"value":"members34 = fetch(\n \"https://api.oireachtas.ie/v1/members?date_start=1900-01-01&chamber_id=&chamber=dail&house_no=34&date_end=2099-01-01&limit=5000\"\n).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2609,"value":"members.results.map((d) => ([d.member.memberships[0].membership.represents[0].represent.showAs, d.member.lastName, d.member.fullName, (\"https://www.oireachtas.ie/en/members/member/\"+d.member.memberCode), ])).slice().sort((a, b) => d3.ascending(a, b))","pinned":true,"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":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":908,"value":"PQsFilteredByTD = questionType.filter(d => d.question.by.showAs == `${selectYourTD}`).filter(d => d.question.by.showAs != null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":906,"value":"filterTD = [...PQsFilteredByTD];","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2941,"value":"dataWithURL = filterTD.flatMap((d) => ({\n department: d.question.to.showAs,\n heading: d.question.debateSection.showAs,\n question: d.question.showAs,\n url:\n \"https://www.oireachtas.ie/en/debates/question/\" +\n d.contextDate +\n \"/\" +\n d.question.questionNumber +\n \"/\",\n date: d.contextDate\n}))","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: \"2026\", value: 2026 },\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":2970,"value":"deputyRollupDescending = d3\n .flatRollup(\n questionType,\n (v) => v.length,\n (d) => d.question.by.showAs\n )\n .sort(([, a], [, b]) => d3.descending(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":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":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}) => ({memberCode, constituency: index.get(memberCode)?.constituency, party: index.get(memberCode)?.party, ...values}))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2273,"value":"topHeadingByTD = Array.from(d3.rollup(rolledWithConstituencyMemberCode, v => v.length, d => d.heading)).slice().sort((a, b) => d3.descending(a[1], b[1]))","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\"\n\nconstituencyGroup = Array.from(\n d3.flatGroup(\n members.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 (d) =>\n d.member.memberships[0].membership.parties[\n d.member.memberships[0].membership.parties.length - 1\n ].party.partyCode,\n (d) => d.member.memberships[0].membership.represents[0].represent.showAs\n ),\n ([name, memberCode, party, partyCode, constituency]) => ({\n name,\n memberCode,\n party,\n partyCode,\n constituency\n })\n)","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":true,"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.party, d => d.name, d => d.heading), \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":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":true,"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":2109,"value":"choroplethdata = FileAttachment(\"choroplethData.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":900,"value":"//viewof selectYourTD = Inputs.text({\n //label: \"Select a TD\",\n //value: TDAlphabetically[0],\n //required: true,\n //placeholder: \"Enter a TD name to search\",\n //datalist: TDAlphabetically.map(d => d)\n//})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2192,"value":"questionSelect = groupByPriority === \"Oral and written questions\" ? [...joinedPQs] : [...joinedOralPQs]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":696,"value":"//viewof groupByPriority = select({\n title: \"Choose Question Type\",\n description: \"Choose to see questions designated as priority for oral answer or the entire set of questions, which includes both oral and written questions. You can explore the results in the searchable table.\",\n options: [\"Oral and written questions\", \"Oral questions only\"],\n value: \"Oral and written questions\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2422,"value":"PQRollupDeputies = \n Array.from(\n d3.flatRollup(questionType, v => v.length, d => d.question.by.memberCode), \n ([id, value]) => ({id, value})\n );","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2512,"value":"filteredPQRollupDeputiesForImage = \n Array.from(\n d3.flatRollup(filterTD, v => v.length, d => d.question.by.memberCode), \n ([id, value]) => ({id, value})\n );","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2417,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 30:"$2f:body"