2e:null 2f:["$","title",null,{"children":"Suffolk County Council swing-o-meter | Louis Goddard | Observable"}] 34:[{"id":"5651276cd1007210899eeb7b347f699df3c40a607274bac9f7228672e20a5ea0b86874b8c3e0f32a44378ece93d80421e2bc9b92d244381093d81f5b3e1478c6","href":"https://static.observableusercontent.com/files/5651276cd1007210899eeb7b347f699df3c40a607274bac9f7228672e20a5ea0b86874b8c3e0f32a44378ece93d80421e2bc9b92d244381093d81f5b3e1478c6","name":"CED.geojson","type":"application/geo+json","lastModified":1641749730856.664,"size":516599}] 32:{"id":"e41f5d127bcea719","slug":"suffolk-county-council","title":"Suffolk County Council swing-o-meter","thumbnail":"08a6aa95d4397e6397a24e27541346be8fc5ab1192d576f4b688d671608bdb79","access_level":"public","create_time":"$D2022-01-08T10:30:44.692Z","update_time":"$D2022-01-15T13:19:37.004Z","view_time":null,"first_public_time":"$D2022-01-09T18:25:26.471Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ee7260255077c9b9","login":"ltrgoddard","name":"Louis Goddard","avatar_url":"https://avatars-next.observableusercontent.com/1377626138082cc67856d07ec28bd2c084e33cce0d8c3a75b0c15181ac05970c","tier":"starter_2024"},"version":1885,"publish_version":1885,"role":null,"authored":false,"authors":[{"type":"individual","id":"947c7b1fe1e9c407","login":"ltrgoddard","name":"Louis Goddard","avatar_url":"https://avatars-next.observableusercontent.com/1377626138082cc67856d07ec28bd2c084e33cce0d8c3a75b0c15181ac05970c","tier":null}],"members":[{"type":"individual","id":"947c7b1fe1e9c407","login":"ltrgoddard","name":"Louis Goddard","avatar_url":"https://avatars-next.observableusercontent.com/1377626138082cc67856d07ec28bd2c084e33cce0d8c3a75b0c15181ac05970c","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Suffolk County Council swing-o-meter","cells":[{"id":429,"value":"# Suffolk County Council swing-o-meter","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1541,"value":"The bar chart and map below show the Suffolk County Council electoral divisions where the selected party increased its vote share the most in 2021, relative to the other parties. Scroll down to view the detailed results as a table, based on [data from Wikipedia](https://en.wikipedia.org/wiki/Suffolk_County_Council_elections).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":482,"value":"viewof swing_to = Inputs.radio([\"Labour\", \"Conservative\", \"Liberal Democrats\", \"Green\"], { label: \"Swing to\", value: \"Labour\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":476,"value":"viewof swing_from = Inputs.checkbox(d3.union(results.map(d => d.party)), { label: \"Swing from\", value: [...d3.difference(d3.union(results.map(d => d.party)), [swing_to]), [\"Other\", d3.union(results.map(d => d.party))]] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":492,"value":"viewof comparison_year = Inputs.radio(new Map([[\"2009\", 2009], [\"2013\", 2013], [\"2017\", 2017]]), { label: \"2021 vs.\", value: 2017 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":822,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1485,"value":"html`

${viewof chart}

${viewof map}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":842,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":838,"value":"## 2024 target seats","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1821,"value":"Inputs.table(target_seats, { sort: \"Majority\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1577,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":568,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1289,"value":"turf = require(\"@turf/turf@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"import { getWiki } from \"@ltrgoddard/utils\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"years = [2009, 2013, 2017, 2021]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1061,"value":"### Visualisation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1125,"value":"viewof map = {\n const svg = d3.create(\"svg\")\n .attr(\"viewBox\", [0, 0, 975, 530]);\n\n const projection = d3.geoMercator()\n .scale(3e4)\n .center(turf\n .centroid(boundaries)\n .geometry\n .coordinates.map((d, i) => i === 1 ? d + .06 : d));\n\n const path = d3.geoPath(projection);\n\n svg.append(\"g\")\n .selectAll(\"path\")\n .data(boundaries.features)\n .join(\"path\")\n .attr(\"fill\", d =>\n d3.interpolateRgb(\"white\", party_colours.get(swing_to))(\n colour(\n (vote_share_change\n .map(c => ({\n constituency: c.constituency.toUpperCase(),\n change: c.change}))\n .find(c => c.constituency === d.properties.name) || { change: 0 }).change\n )\n ))\n .attr(\"stroke\", \"grey\")\n .attr(\"d\", path);\n \n return svg.node();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"viewof chart = htl.html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1432,"value":"colour = d3\n .scaleLinear()\n .domain([d3.min(vote_share_change, d => d.change), d3.max(vote_share_change, d => d.change)])\n .range([0, 1])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"x = d3\n .scaleLinear()\n .domain([0, d3.max(vote_share_change, d => d.change)])\n .range([0, width])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"y = d3\n .scaleBand()\n .domain(vote_share_change.map(d => d.constituency))\n .range([0, height])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":813,"value":"// Thanks, Wikipedia! https://en.wikipedia.org/wiki/Wikipedia:Index_of_United_Kingdom_political_parties_meta_attributes\nparty_colours = new Map([\n [\"Labour\", \"#E4003B\"],\n [\"Conservative\", \"#0087DC\"],\n [\"Liberal Democrats\", \"#FAA61A\"],\n [\"Green\", \"#6AB023\"]\n])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":678,"value":"height = 260","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":680,"value":"width = \"100%\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1065,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1359,"value":"boundaries = FileAttachment(\"CED.geojson\")\n .json()\n .then(d => ({\n ...d,\n features: d.features.filter(f => /SUFFOLK COUNTY$/.test(f.properties.fullname))\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1581,"value":"target_seats =\n d3.flatRollup(\n results.filter(d => d.year === 2021),\n v => {\n const threshold = v[0].seats === 2 ?\n d3.sort(v, d => -d.votes)[1].votes :\n d3.sort(v, d => -d.votes)[0].votes;\n return {\n Constituency: v[0].constituency,\n Party: d3.sort(v, d => -d.votes)[0].party,\n Candidate: d3.sort(v, d => -d.votes)[0].candidate,\n Majority: (\n d3.min(v\n .filter(d => d.party !== swing_to)\n .filter(d => d.votes >= threshold)\n .map(d => d.votes)) - \n d3.max(v\n .filter(d => d.party === swing_to)\n .filter(d => d.votes < threshold)\n .map(d => d.votes))\n )\n };\n },\n d => d.constituency)\n .map(d => d[1])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"vote_share_change =\n d3.sort(\n d3.rollups(\n vote_share,\n v =>\n (v.find(d => d.year === 2021) || {share: 0}).share -\n (v.find(d => d.year === comparison_year) || {share: 0}).share,\n d => d.constituency)\n .map(d => ({\n constituency: d[0],\n change: d[1]\n })),\n d => -d.change)\n .filter(d => d.change < Infinity && d.change > 0)\n .slice(0, 10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"vote_share =\n d3.flatRollup(\n results,\n v => ({\n share:\n d3.sum(v.filter(d => swing_to.includes(d.party)), d => d.votes) /\n d3.sum(v.filter(d => [...swing_from, ...[swing_to]].includes(d.party)), d => d.votes),\n }),\n d => d.year,\n d => d.constituency)\n .map(d => ({\n year: d[0],\n constituency: d[1],\n ...d[2]\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"results =\n Promise.all(\n years\n .map(year => getWiki(`${year}_Suffolk_County_Council_election`)\n .then(w => get_results(w)\n .map(r => ({year: year, ...r})))))\n .then(d => d.flat())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"function get_results(wiki) {\n return [...wiki.querySelectorAll(\"table.wikitable.plainrowheaders\")]\n .map(table => ({\n constituency: table.querySelector(\"caption\")\n .textContent\n .replace(/\$.*\$/g, \"\")\n .replace(/\\[.*\\]/g, \"\")\n .replace(/ & /g, \" and \")\n .replace(/^St\\./g, \"St\")\n .trim(),\n seats: /2/.test(table.querySelector(\"caption\").textContent) ? 2 : 1,\n results: [...table.querySelectorAll(\"tr\")]\n .map(row => [...row.querySelectorAll(\"td\")]\n .map(cell => cell.textContent.trim()))\n .filter(row => row.length === 6)\n }))\n .flatMap(d => d.results\n .map(c => ({\n constituency: d.constituency,\n seats: d.seats,\n party: c[1],\n candidate: c[2].replace(/ \\*$/, \"\"),\n votes: parseInt(c[3].replace(\",\", \"\"))\n })))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"