43:["$","title",null,{"children":"Dublin Property Market, 2010-2022 | Anthony Munnelly | Observable"}] 4b:[{"id":"d9d6f5fb14b7069bf359baedc3a62d2a8849c33dcd639c6529c55ab81aeda201167f16101f6bf699d4f0f3534fa2b7b277f5829cbf8babc8ba8ef74e181704af","href":"https://static.observableusercontent.com/files/d9d6f5fb14b7069bf359baedc3a62d2a8849c33dcd639c6529c55ab81aeda201167f16101f6bf699d4f0f3534fa2b7b277f5829cbf8babc8ba8ef74e181704af","name":"hpa_by_eircode.csv","type":"text/csv","lastModified":1676998906900.458,"size":18138803},{"id":"e335d6d8f356eab71821bd4465fdf3d60b92aa9c9ff58c5a7f55c4eb6c559730b3d245f2d9a8a1b0732a9d9c0455f799251cf772c00f58e99dd06409720aa4b3","href":"https://static.observableusercontent.com/files/e335d6d8f356eab71821bd4465fdf3d60b92aa9c9ff58c5a7f55c4eb6c559730b3d245f2d9a8a1b0732a9d9c0455f799251cf772c00f58e99dd06409720aa4b3","name":"eircode_mapper.json","type":"application/json","lastModified":1676998906900.458,"size":17731}] 47:{"id":"f346aeec2dd341e3","slug":"dublin-property-market-2010-2022","title":"Dublin Property Market, 2010-2022","thumbnail":"3c95b00723277a4e375c894f77cd3eae0fd6daa60b4948da71912eee1e6f0d35","access_level":"public","create_time":"$D2023-02-21T17:01:46.900Z","update_time":"$D2023-02-24T14:59:28.333Z","view_time":null,"first_public_time":"$D2023-02-21T17:01:46.900Z","has_unpublished_edits":null,"fork":{"id":"c1b73f5381d2c2c7","slug":"irish-property-market-2010-2022","title":"Irish Property Market, 2010-2022","owner":{"id":"d68b4108b6911268","login":"anthony-munnelly","name":"Anthony Munnelly"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d68b4108b6911268","login":"anthony-munnelly","name":"Anthony Munnelly","avatar_url":"https://avatars-next.observableusercontent.com/62dfc61aacd9375b67fbd6a5e1b3f129c6407ef8cad0fe7f679b03e5f4e08cca","tier":"starter_2024","bio":"","following":false},"version":821,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"1dfccb5da7c24940","login":"anthony-munnelly","name":"Anthony Munnelly","avatar_url":"https://avatars-next.observableusercontent.com/62dfc61aacd9375b67fbd6a5e1b3f129c6407ef8cad0fe7f679b03e5f4e08cca","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"1dfccb5da7c24940","login":"anthony-munnelly","name":"Anthony Munnelly","avatar_url":"https://avatars-next.observableusercontent.com/62dfc61aacd9375b67fbd6a5e1b3f129c6407ef8cad0fe7f679b03e5f4e08cca","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Dublin Property Market, 2010-2022","cells":[{"id":0,"value":"# Dublin Property Market, 2010-2022\n\nThis is a study of the Dublin Property Market over the years from 2010 to 2022, inclusive, as per the data provided by the [Central Statistics Office](https://data.gov.ie/dataset/hpa04-market-based-household-purchases-of-residential-dwellings). Use the table of contents to move back and forth between areas of immediate interest.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":430,"value":"toc()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"## Volume of Sales\n### Annually by Dwelling Status\nThe effects of the crash were still being felt until 2011, but from 2012 onwards we see a steady growth until 2017, where the data plateaus (the 2020 and 2021 dips are because of Covid, of course).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"Plot.plot({\n marginLeft: 50,\n marginBottom: 75,\n x: { tickRotate: -90, label: \"County\", tickFormat: \"d\" },\n y: { grid: true, tickFormat: \"2s\", label: \"Units Sold\" },\n marks: [\n Plot.barY(\n annual_sales_volume,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"Year\",\n y: \"VALUE\",\n fill: \"Dwelling Status\"\n }\n )\n ),\n\n Plot.ruleY([0])\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"### By Eircode by Dwelling Status\nThe Property market is busiest in Dublin’s North-West and South-West Suburbs.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"Plot.plot({\n marginLeft: 100,\n x: { tickFormat: \"2s\", label: \"units sold\" },\n y: { grid: true },\n marks: [\n Plot.barX(\n annual_sales_volume,\n Plot.groupY(\n { x: \"sum\" },\n {\n y: \"Eircode Output\",\n x: \"VALUE\",\n fill: \"Dwelling Status\",\n sort: { y: \"x\", reverse: true }\n }\n )\n ),\n Plot.ruleY([0])\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"## Value of Sales","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":364,"value":"### Annually by Dwelling Status\nWhere we saw sales volume plateau in 2017, the price of property continued to climb from 2017 (with the exception of the lockdown years, of course).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"Plot.plot({\n marginLeft: 100,\n marginBottom: 50,\n x: { tickRotate: -90, label: \"Year\", tickFormat: \"d\" },\n y: {\n grid: true,\n tickFormat: (d) => irishLocale.format(\"$,\")(d),\n label: \"Sales (Euro Millions)\"\n },\n marks: [\n Plot.barY(\n annual_sales_value,\n Plot.groupX(\n { y: \"sum\" },\n {\n x: \"Year\",\n y: \"VALUE\",\n fill: \"Dwelling Status\"\n }\n )\n ),\n\n Plot.ruleY([0])\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"### By Eircode by Dwelling Status\nSignificant differences here from the chart of sales volume by Eircode. Dublin 15 tops this list also, but although the volume of property sales in Dublin 24 was second in the list of sales by volume, it’s tenth in the list of sales by value. Property is considerably more expensive in Glenageary, Carrickmines and Sandyford (D18), Dublin 4, Blackrock, Ranelagh and Rathmines (D6) and others.\n\nIt’s also interesting to note that the proportion of new houses being sold in Glenageary is considerably smaller than in Dublin 15 or 18. New housing markets are generally in the suburbs, as this is where the land is on which the houses can be built. Glenageary is hemmed in by Glasthule, Sallynoggin, Killiney and Dalkey to the north, west and south, and by the Irish Sea to the east.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":661,"value":"Plot.plot({\n marginLeft: 100,\n x: {\n tickFormat: (d) => irishLocale.format(\"$,\")(d),\n label: \"Sales (Euro Millions)\"\n },\n y: { grid: true },\n marks: [\n Plot.barX(\n annual_sales_value,\n Plot.groupY(\n { x: \"sum\" },\n {\n y: \"Eircode Output\",\n x: \"VALUE\",\n fill: \"Dwelling Status\",\n sort: { y: \"x\", reverse: true }\n }\n )\n ),\n Plot.ruleY([0])\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"## Volume vs Value by Eircode\nThis is a graph of sales volume vs sales value by Dublin Eircode for the twelve years in question. Use the range sliders to increase or decrease the volume and value parameters to zoom in or out out of the graph (the lower labels will, thankfully, become a little clearer).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":605,"value":"\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Category	Value
Eircodes	${volAuValByEircode.filter(\n (d) => d.volume <= eircodeMinMax[0] && d.value <= eircodeMinMax[1]\n ).length}
Sales Volume	${d3.format(\",d\")(eircodeMinMax[0])}
Sales Value (Euro Millions)	${irishLocale.format(\"$,\")(eircodeMinMax[1])}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":559,"value":"viewof eircodeMinMax = Inputs.form([\n Inputs.range([0, d3.max(volAuValByEircode, (d) => d.volume) + 500], {\n step: 1e2,\n label: \"Volume\"\n }),\n Inputs.range([0, d3.max(volAuValByEircode, (d) => d.value) + 5e5], {\n step: 1e3,\n label: \"Value\",\n tickFormat: \"$.2s\"\n })\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":614,"value":"Plot.plot({\n caption: \"Units Sold vs Total Sales Value by Eircode\",\n margin: 50,\n height: 500,\n width: 600,\n style: { background: \"teal\", color: \"orange\", fontSize: 14 },\n x: {\n //domain: [0, 1.5e4],\n label: \"units sold\",\n grid: true\n },\n y: {\n // domain: [0, 4.75e6],\n tickFormat: irishLocale.format(\"$,\"),\n label: \"total value (Euro Millions)\",\n grid: true\n },\n marginLeft: 100,\n MarginRight: 100,\n width: 900,\n marks: [\n Plot.text(\n volAuValByEircode.filter(\n (d) => d.volume <= eircodeMinMax[0] && d.value <= eircodeMinMax[1]\n ),\n {\n x: \"volume\",\n y: \"value\",\n text: (d) => (d.eircode[0] == \"D\" ? d.eircode.slice(0, 3) : d.eircode),\n fill: \"white\"\n }\n ),\n Plot.ruleX([0]),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"## Value by Year by Eircode","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":772,"value":"Plot.plot({\n marginLeft: 100,\n width: 800,\n height: 1000,\n x: { tickFormat: \"d\" },\n color: {\n scheme: \"Greens\",\n legend: true\n },\n marks: [\n Plot.cell(byEircodeByYear, {\n x: \"year\",\n y: \"eircode\",\n fill: \"value\",\n stroke: \"none\"\n }),\n Plot.text(byEircodeByYear, {\n x: \"year\",\n y: \"eircode\",\n text: (d) => irishLocale.format(\"$.1s\")(d.value),\n fill: \"black\",\n stroke: \"white\"\n // fill: (d) => fontColorHack(d.value)\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":799,"value":"function fontColorHack(value) {\n return value < 0 ? \"black\" : \"white\";\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"# Data\nBecause all Observable notebook cells run at once, it’s convenient to leave the data to the end and use the top cells to narrate and investigate the data. Here are the various manipulations performed on the original CSO data, as well as some other functions to help make the data more presentable.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":130,"value":"## Raw Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"rawdata = await FileAttachment(\"hpa_by_eircode.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"rawdata","database":"$undefined"},{"id":102,"value":"data = {\n rawdata.forEach(\n (d) => (d.county = eircode_mapper[d[\"Eircode Output\"]].county)\n );\n return rawdata;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"## Annual Sales Volume","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"annual_sales_volume = data.filter(\n (d) =>\n d[\"Statistic Label\"] == \"Volume of Sales\" &&\n d[\"Dwelling Status\"] != \"All Dwelling Statuses\" &&\n d[\"Eircode Output\"] != \"All\" &&\n d[\"Type of Buyer\"] != \"All Buyer Types\" &&\n d[\"county\"] == \"Dublin\" &&\n d[\"Stamp Duty Event\"] == \"Filings\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"annual_sales_volume","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":217,"value":"## Annual Sales Value","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":188,"value":"annual_sales_value = data.filter(\n (d) =>\n d[\"Statistic Label\"] == \"Value of Sales\" &&\n d[\"Dwelling Status\"] != \"All Dwelling Statuses\" &&\n d[\"Eircode Output\"] != \"All\" &&\n d[\"Type of Buyer\"] != \"All Buyer Types\" &&\n d[\"county\"] == \"Dublin\" &&\n d[\"Stamp Duty Event\"] == \"Filings\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"annual_sales_value","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":332,"value":"valueByEircode = d3.rollup(\n annual_sales_value,\n (e) => d3.sum(e, (f) => f.VALUE),\n (g) => g[\"Eircode Output\"]\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"volumeByEircode = d3.rollup(\n annual_sales_volume,\n (e) => d3.sum(e, (f) => f.VALUE),\n (g) => g[\"Eircode Output\"]\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"volAuValByEircode = {\n let result = [];\n for (let i of valueByEircode) {\n result.push({\n eircode: i[0],\n volume: volumeByEircode.get(i[0]),\n value: i[1]\n });\n }\n return result;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"volAuValByEircode","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":698,"value":"## Heatmap Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":700,"value":"heatmapData = d3.rollup(\n annual_sales_value,\n (e) => d3.sum(e, (f) => f.VALUE),\n (g) => g[\"Eircode Output\"],\n (h) => h.Year\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":707,"value":"byEircodeByYear = {\n let holder = [];\n for (let a of heatmapData) {\n for (let y = 2011; y < 2023; y++) {\n // let value =\n // heatmapData.get(a[0]) == undefined\n // ? a[0]\n // : heatmapData.get(a[0]).get(y);\n // holder.push(value);\n holder.push({\n eircode: a[0],\n year: y,\n value:\n heatmapData.get(a[0]) == undefined\n ? 0\n : heatmapData.get(a[0]).get(y) * 1e3\n });\n }\n }\n return holder;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"byEircodeByYear","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":459,"value":"# Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":247,"value":"## Format Currency in Euro","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":224,"value":"irishLocale = d3.formatLocale({\n decimal: \".\",\n thousands: \",\",\n grouping: [3],\n currency: [\"€\", \"\"]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"## Identifying Counties by Eircode","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":77,"value":"eircode = FileAttachment(\"eircode_mapper.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"eircode_mapper = {\n let m = {};\n for (let e in eircode) {\n m[eircode[e].longKey] = {\n key: eircode[e].key,\n county: eircode[e].county,\n town: eircode[e].town\n };\n }\n m[\"All\"] = { key: null, county: null, town: null };\n return m;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"## Table of Contents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":427,"value":"import { toc } from \"@harrystevens/toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 42:null