2b:null 2c:["$","title",null,{"children":"Constituency maps under Member page | David Cass | Observable"}] 31:T79a,population = constituency_population_age2.flatMap(d => ({constituency: d["NEW CONSTITUENCY"], district: d["GEOGDESC"], "M 0 to 9": d["Age 0 - Males"]+d["Age 1 - Males"]+d["Age 2 - Males"]+d["Age 3 - Males"]+d["Age 4 - Males"]+d["Age 5 - Males"]+d["Age 6 - Males"]+d["Age 7 - Males"]+d["Age 8 - Males"]+d["Age 9 - Males"], "M 10 to 19": d["Age 10 - Males"]+d["Age 11 - Males"]+d["Age 12 - Males"]+d["Age 13 - Males"]+d["Age 14 - Males"]+d["Age 15 - Males"]+d["Age 16 - Males"]+d["Age 17 - Males"]+d["Age 18 - Males"]+d["Age 19 - Males"], "M 20 to 29": d["Age 20 - 24 - Males"]+d["Age 25 - 29 - Males"], "M 30 to 39": d["Age 30 - 34 - Males"]+d["Age 35 - 39 - Males"], "M 40 to 49": d["Age 40 - 44 - Males"]+d["Age 45 - 49 - Males"], "M 50 to 59": d["Age 50 - 54 - Males"]+d["Age 55 - 59 - Males"], "M 60 to 69": d["Age 60 - 64 - Males"]+d["Age 65 - 69 - Males"], "M 70 to 79": d["Age 70 - 74 - Males"]+d["Age 75 - 79 - Males"], "M 80 and over": d["Age 80 - 84 - Males"]+d["Age 85 and over - Males"], "F 0 to 9": d["Age 0 - Females"]+d["Age 1 - Females"]+d["Age 2 - Females"]+d["Age 3 - Females"]+d["Age 4 - Females"]+d["Age 5 - Females"]+d["Age 6 - Females"]+d["Age 7 - Females"]+d["Age 8 - Females"]+d["Age 9 - Females"], "F 10 to 19": d["Age 10 - Females"]+d["Age 11 - Females"]+d["Age 12 - Females"]+d["Age 13 - Females"]+d["Age 14 - Females"]+d["Age 15 - Females"]+d["Age 16 - Females"]+d["Age 17 - Females"]+d["Age 18 - Females"]+d["Age 19 - Females"], "F 20 to 29": d["Age 20 - 24 - Females"]+d["Age 25 - 29 - Females"], "F 30 to 39": d["Age 30 - 34 - Females"]+d["Age 35 - 39 - Males"], "F 40 to 49": d["Age 40 - 44 - Females"]+d["Age 45 - 49 - Females"], "F 50 to 59": d["Age 50 - 54 - Females"]+d["Age 55 - 59 - Females"], "F 60 to 69": d["Age 60 - 64 - Females"]+d["Age 65 - 69 - Females"], "F 70 to 79": d["Age 70 - 74 - Females"]+d["Age 75 - 79 - Females"], "F 80 and over": d["Age 80 - 84 - Females"]+d["Age 85 and over - Females"]}))32:[{"id":"3a439971580ebc1f611ef54e3a15b1ea754571d35655337f53705f0d30fc29e3e3a02441e51a60b5eb5f34b29f276585d167b8e8a6ac245c90a2a5350eb678b0","href":"https://static.observableusercontent.com/files/3a439971580ebc1f611ef54e3a15b1ea754571d35655337f53705f0d30fc29e3e3a02441e51a60b5eb5f34b29f276585d167b8e8a6ac245c90a2a5350eb678b0","name":"constituency_population_age-2.csv","type":"text/csv","lastModified":1720434902653.924,"size":1280210},{"id":"2a34fdffc79472f12a32e50e22d434edebd57b81bfeca53944aa4d822a85d0a5b86a7c7779b38bae93c45b97e87f2a870e18026364a46cee142fdc4657038e74","href":"https://static.observableusercontent.com/files/2a34fdffc79472f12a32e50e22d434edebd57b81bfeca53944aa4d822a85d0a5b86a7c7779b38bae93c45b97e87f2a870e18026364a46cee142fdc4657038e74","name":"household_type.csv","type":"text/csv","lastModified":1720435032030.546,"size":404730},{"id":"efc2273b1feda05a1f7fb60a91fe222996942ef8fa31bccd976b93db59d7233c270c60ec6b0ec946d45a75b4f32fd57bbfb8885b2dda99a592658f48e5e2d690","href":"https://static.observableusercontent.com/files/efc2273b1feda05a1f7fb60a91fe222996942ef8fa31bccd976b93db59d7233c270c60ec6b0ec946d45a75b4f32fd57bbfb8885b2dda99a592658f48e5e2d690","name":"working_population.csv","type":"text/csv","lastModified":1720435379997.255,"size":456041},{"id":"b573c07f86897c2303fe14a50992b6e1f00646646bb8273e59dd66d17ee25aa44fe977f670a6bd82bc4aec7a81cafcc124a995908b8a9fba0448a5230e97bbd3","href":"https://static.observableusercontent.com/files/b573c07f86897c2303fe14a50992b6e1f00646646bb8273e59dd66d17ee25aa44fe977f670a6bd82bc4aec7a81cafcc124a995908b8a9fba0448a5230e97bbd3","name":"constituenciesWithProfiles - constituencyTDs@1.csv","type":"text/csv","lastModified":1717771776082.231,"size":36879},{"id":"413d33844b2d94c9c98fd67a7104cfd54a327dcace01a3ab0f4e0eb1917cfbfb439244e40a9cacdacb3175efbd7e96c0ea0833181b34ecf7880ab3ec9f946582","href":"https://static.observableusercontent.com/files/413d33844b2d94c9c98fd67a7104cfd54a327dcace01a3ab0f4e0eb1917cfbfb439244e40a9cacdacb3175efbd7e96c0ea0833181b34ecf7880ab3ec9f946582","name":"constituenciesFromAPI-3.json","type":"application/json","lastModified":1732972037693.037,"size":11123104}] 2f:{"id":"c9ddad0a18a04132","slug":null,"title":"Constituency maps under Member page","thumbnail":"434e80e45b4ac0961d50bb72186edb29cd36ead101115418904488926acc43db","access_level":"public","create_time":"$D2024-02-01T09:51:28.896Z","update_time":"$D2024-11-30T13:15:54.497Z","view_time":null,"first_public_time":"$D2024-02-01T09:51:28.896Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1cc7c51c4e129cc6","login":"cassdavid","name":"David Cass","avatar_url":"https://avatars-next.observableusercontent.com/23f715262d714df76a73099e52ee40739329c8543d97eb613e222d55e7fc738b","tier":"starter_2024"},"version":516,"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":1,"collection":null,"type":"notebook","body":{"title":"Constituency maps under Member page","cells":[{"id":0,"value":"# Constituency maps under Member page\n## linked with constituencies under PQ Explorer","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"intro = md`## Find your constituency\nConstituencies for this Dáil were set down in the [Electoral (Amendment) Act 2023](https://www.oireachtas.ie/en/bills/bill/2023/77/). The constituencies comprise smaller electoral districts, data from which were captured in the most recent census. Mapping of the constituencies is overseen by Táilte Éireann.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"viewof constituencyPicker = Inputs.select(\n Array.from(constituencyMap)\n .map((d) => d[0])\n .sort(d3.ascending),\n { label: \"Constituency\", width: 800 }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"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":51,"value":"deputylist = md`The TDs in [**${constituencyPicker}**](https://www.oireachtas.ie/en/members/tds/?tab=constituency&constituency=%2Fie%2Foireachtas%2Fhouse%2Fdail%2F33%2Fconstituency%2F${TDs[0].representCode}) are **Deputies ${list1} ${list2}** and **${list3}**\n
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"profileDoc = (Array.from(new Set(PQsFilteredByConstituency1.map(d => d.constProfile)))[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"constituencies = {\n \nconst container = yield htl.html`

`;\nconst map = L.map(container, {scrollWheelZoom: true}).setView([43.342686, 25.267118], 4);\nconst 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}\nL.geoJSON(filtered, {\n onEachFeature: onEachFeature,\n filter: function(feature, layer){return feature.properties.CON_SEAT_}\n}).addTo(map);\nmap.fitBounds(constituencylayer.getBounds(), {maxZoom: 19});\nL.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution: \"© OpenStreetMap contributors\"\n}).addTo(map);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":132,"value":"questionsChart = Plot.plot({\n width: 800,\n marginTop: -10,\n marginLeft: 230,\n marginRight: 40,\n subtitle: htl.html`

Constituency profiles

The [Houses of the Oireachtas Library & Research Service](https://www.oireachtas.ie/en/how-parliament-is-run/houses-of-the-oireachtas-service/library-and-research-service/) has compiled profiles of each Dáil Constituency, providing overviews of demographics, economic status, transport and education.

\n
\n

Take a look at the [constituency profile for ${constituencyPicker}](${profileDoc}).

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":434,"value":"constituencyProfileSplit2 = md `\n

Constituency profiles

\n
\n

Explore the headline findings or do a deep dive with our [constituency profile for ${constituencyPicker}](${profileDoc}).

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"PopulationChart = Plot.plot({\n style: {fontSize: 12, fontFamily: \"IBM Plex Sans\"},\n marginLeft: 50,\n marginBottom: 40,\n subtitle: htl.html`

Population profiles in ${constituencyPicker}

`,\n width: 800,\n x: {\n label: \"Age grouping\",\n },\n y: {grid: true, label: \"Population by age grouping\", nice: true},\n color: {scheme: \"Category10\"},\n marks: [\n Plot.barY(experiment, {x: \"group\", y: \"total\", fill: \"Gender\", tip: true\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":421,"value":"employmentChart = Plot.plot({\n style: {fontSize: 12, fontFamily: \"IBM Plex Sans\"},\n marginTop: 50,\n color: {scheme: \"Category10\"},\n marginLeft: 150,\n marginBottom: 95,\n subtitle: htl.html`

Employment types in ${constituencyPicker}

`,\n width: 800,\n x: {\n label: \"Employment sector\", tickRotate: 15,\n },\n y: {grid: true, label: \"Number of workers\", nice: true},\n marks: [\n Plot.barY(workingTotals, {x: \"sector\", y: \"total\", fill: \"#1f77b4\", tip: true,\n }),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":405,"value":"HousingChart = Plot.plot({\n style: {fontSize: 12, fontFamily: \"IBM Plex Sans\"},\n marginTop: 50,\n marginLeft: 150,\n marginBottom: 90,\n subtitle: htl.html`

Housing in ${constituencyPicker}

`,\n width: 800,\n x: {\n label: \"Housing type\", tickRotate: -10,\n },\n y: {grid: true, label: \"Number of properties\", nice: true},\n color: {scheme: \"Tableau10\", legend: false},\n marks: [\n Plot.barY(housingTotals, {x: \"housing\", y: \"total\", fill: \"#ff7f0e\", tip: true, sort:{x: \"y\", reverse: true}\n }),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"constituencyProfile2 = md `\n

Constituency profiles

\n
\n

Take a look at the [constituency profile for ${constituencyPicker}](${profileDoc}).

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"constituencyProfile1 = md `\n
\n

Constituency profiles

The [Library & Research Service](https://www.oireachtas.ie/en/how-parliament-is-run/houses-of-the-oireachtas-service/library-and-research-service/) has compiled profiles of constituencies.

\n
\n

Take a look at the [constituency profile for ${constituencyPicker1}](${profileDoc1}).

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import {constituencyFile} from \"4a09f5dffdde7d16\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"newconstituencies = FileAttachment(\"constituenciesFromAPI-3.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"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":503,"value":"newconstituencyMap = new Map(\n newconstituencies.features.map((d) => [d.properties.ENG_NAME_VALUE, d])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"import {members} from \"4a09f5dffdde7d16\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"PQsFilteredByConstituency1 = constituencyTDs\n .filter((d) => d.constituency == `${constituencyPicker}`)\n .slice()\n .sort((a, b) => d3.descending(a.date, b.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"PQsFilteredByConstituencyTest = constituencieswithprofilesConstituencytds.filter(d => d.constituency == `${constituencyPicker1}`).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":35,"value":"constituencyTDs = Array.from(\n //Construct an array of Deputy info containing Deputy name, party and constituency\n d3.flatGroup(\n members.results.filter(\n (d) => d.member.memberships[0].membership.dateRange.end === null\n ),\n (d) => d.member.memberships[0].membership.house.showAs,\n (d) => d.member.fullName,\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[d.member.memberships.length - 1].membership\n .represents[0].represent.representCode,\n (d) =>\n d.member.memberships[d.member.memberships.length - 1].membership\n .represents[0].represent.showAs,\n (d) => d.member.memberCode\n ),\n ([House, name, Party, representCode, constituency, uri]) => ({\n House,\n name,\n Party,\n representCode,\n constituency,\n uri\n })\n).sort((a, b) => d3.ascending(a, b))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"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":267,"value":"testList1 = TDsTest.slice(0, -2).map(d =>d.name+\", \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"list1Link = TDsTest.slice(0, -2).map(d =>d.memberProfile)[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"list3 = TDs.slice(-1).map(d => d.name+\".\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"membersWithProfile = Array.from(d3.flatGroup(TDsTest, d => d.name, d => d.memberProfile),\n ([name, profile]) => ({name, profile}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"membersWithProfile.slice(0,-1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"testList3 = TDsTest.slice(-1).map(d => d.name+\".\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"list3Link = TDsTest.slice(-1).map(d => d.memberProfile)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"listDeputy2 = TDs.slice(1,2).map(d => d.name+\", \")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"listDeputy3 = TDs.slice(2,3).map(d => d.name+\", \")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"listDeputy1 = TDs.slice(0,1).map(d => d.name+\" \")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"list2 = TDs.slice(-2, -1).map(d =>d.name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"testList2 = TDsTest.slice(-2, -1).map(d =>d.name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"list2Link = TDsTest.slice(-2, -1).map(d =>d.memberProfile)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"TDs = Array.from(d3.flatGroup(PQsFilteredByConstituency1, d => d.name, d => d.representCode, d => d.memberProfile),\n ([name, representCode, memberProfile]) => ({name, representCode, memberProfile}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"TDsTest = Array.from(d3.flatGroup(PQsFilteredByConstituencyTest, d => d.name, d => d.representCode, d => d.memberProfile),\n ([name, representCode, memberProfile]) => ({name, representCode, memberProfile}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"import {rolledWithConstituencyMemberCode} from \"4a09f5dffdde7d16\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"rolledWithConstituencyMemberCode","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"thisYear = new Date(filteredPQs[0].date).toLocaleString(undefined, {\n \"year\": \"numeric\",\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"filteredPQs = rolledWithConstituencyMemberCode.filter(d => d.name != null)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"topQuestions = 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])).slice(0,20)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"constituencieswithprofilesConstituencytds = await FileAttachment(\"constituenciesWithProfiles - constituencyTDs@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"constituencieswithprofilesConstituencytds","database":"$undefined"},{"id":60,"value":"Array.from(new Set(constituencieswithprofilesConstituencytds.map(d => d.constituency)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"format = d3.format(\",d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":393,"value":"household_type = await FileAttachment(\"household_type.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"household_type","database":"$undefined"},{"id":387,"value":"constituency_population_age2 = await FileAttachment(\"constituency_population_age-2.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"constituency_population_age2","database":"$undefined"},{"id":394,"value":"householdTypeData = FileAttachment(\"household_type.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"households = householdTypeData.flatMap(d => ({constituency: d[\"NEW CONSTITUENCY\"], district: d[\"GEOGDESC\"], \"Owned with mortgage or loan\": d[\"Owned with mortgage or loan (No. of households)\"], \"Owned outright\": d[\"Owned outright (No. of households)\"], \"Rented from private landlord\": d[\"Rented from private landlord (No. of households) \"], \"Rented from local authority\": d[\"Rented from Local Authority (No. of households)\"], \"Rented from voluntary or cooperative housing body\": d[\"Rented from voluntary/co-operative housing body (No. of households)\"], \"Occupied free of rent\": d[\"Occupied free of rent (No. of households)\"], \"Not stated\": d[\"Not stated (No. of households)\"]}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"tidyDataforHouseholds = (Object.getOwnPropertyNames(households[0]).slice(2)).flatMap((housing) => households.map(d => ({constituency: d.constituency, district: d.district, housing, total: d[housing]})))\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":400,"value":"oneConstituencyforHouseholds = tidyDataforHouseholds.filter(d => d.constituency === `${constituencyPicker}`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":402,"value":"housingTotals = Array.from(d3.flatRollup(oneConstituencyforHouseholds, v => d3.sum(v, d => d.total), d => d.housing), ([housing, total]) => ({housing, total}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"workingData = FileAttachment(\"working_population.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"workingPopulation = workingData.flatMap(d => ({constituency: d[\"NEW CONSTITUENCY\"], district: d[\"GEOGDESC\"], \"Employers and managers\": d[\"Employers and managers (No. of persons)\"], \"Higher professionals\": d[\"Higher professional (No. of persons)\"], \"Lower professionals\": d[\"Lower professional (No. of persons)\"], \"Non-manual\": d[\"Non-manual (No. of persons)\"], \"Manual skilled\": d[\"Manual skilled (No. of persons)\"], \"Semi-skilled\": d[\"Semi-skilled (No. of persons)\"], \"Unskilled\": d[\"Unskilled (No. of persons)\"], \"Own account workers\": d[\"Own account workers (No. of persons)\"], \"Farmers\": d[\"Farmers (No. of persons)\"], \"Agricultural workers\": d[\"Agricultural workers (No. of persons)\"], \"All others gainfully occupied and unknown\": d[\"All others gainfully occupied and unknown (No. of persons)\"] }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":413,"value":"tidyWorkingData = (Object.getOwnPropertyNames(workingPopulation[0]).slice(2)).flatMap((sector) => workingPopulation.map(d => ({constituency: d.constituency, district: d.district, sector, total: d[sector]})))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":415,"value":"oneConstituencyforWork = tidyWorkingData.filter(d => d.constituency === `${constituencyPicker}`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"workingTotals = Array.from(d3.flatRollup(oneConstituencyforWork, v => d3.sum(v, d => d.total), d => d.sector), ([sector, total]) => ({sector, total}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":"viewof newconstituencyPicker = Inputs.select(\n Array.from(newconstituencyMap)\n .map((d) => d[0])\n .sort(d3.ascending),\n { label: \"Constituency\", width: 800 }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":501,"value":"newFiltered = newconstituencies.features.filter(\n (d) => d.properties.ENG_NAME_VALUE == `${newconstituencyPicker}`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"

Popular parliamentary question topics in ${thisYear} | ${constituencyPicker}

Constituency profiles

Constituency profiles

Population profiles in ${constituencyPicker}

Employment types in ${constituencyPicker}

Housing in ${constituencyPicker}

Constituency profiles

Constituency profiles