43:["$","title",null,{"children":"Irish 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":1676921015745.629,"size":18138803},{"id":"e335d6d8f356eab71821bd4465fdf3d60b92aa9c9ff58c5a7f55c4eb6c559730b3d245f2d9a8a1b0732a9d9c0455f799251cf772c00f58e99dd06409720aa4b3","href":"https://static.observableusercontent.com/files/e335d6d8f356eab71821bd4465fdf3d60b92aa9c9ff58c5a7f55c4eb6c559730b3d245f2d9a8a1b0732a9d9c0455f799251cf772c00f58e99dd06409720aa4b3","name":"eircode_mapper.json","type":"application/json","lastModified":1676931000422.197,"size":17731}] 47:{"id":"c1b73f5381d2c2c7","slug":"irish-property-market-2010-2022","title":"Irish Property Market, 2010-2022","thumbnail":"a21e28954be8beebcd4bd5f114fb9e3becc7d4f3feb60e5ffb7ff6f71f5f31a2","access_level":"public","create_time":"$D2023-02-20T19:22:43.142Z","update_time":"$D2023-02-21T17:01:20.553Z","view_time":null,"first_public_time":"$D2023-02-20T19:22:43.142Z","has_unpublished_edits":null,"fork":false,"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":437,"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":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Irish Property Market, 2010-2022","cells":[{"id":0,"value":"# Irish Property Market, 2010-2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":430,"value":"toc()","pinned":true,"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","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 County by Dwelling Status","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\" },\n y: { grid: true },\n marks: [\n Plot.barX(\n annual_sales_volume,\n Plot.groupY(\n { x: \"sum\" },\n {\n y: \"county\",\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","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: 50,\n marginBottom: 50,\n width: 1000,\n height: 570,\n x: { tickRotate: -90, label: \"Year\", tickFormat: \"d\" },\n y: {\n grid: true,\n transform: (d) => d * 1e3,\n tickFormat: (d) => irishLocale.format(\"$,.2s\")(d),\n label: \"Sales\"\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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"Plot.plot({\n marginLeft: 100,\n x: {\n transform: (d) => d * 1e3,\n tickFormat: (d) => irishLocale.format(\"$,.3s\")(d),\n label: \"Sales\"\n },\n y: { grid: true },\n marks: [\n Plot.barX(\n annual_sales_value,\n Plot.groupY(\n { x: \"sum\" },\n {\n y: \"county\",\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":275,"value":"## Volume vs Value by County","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":406,"value":"\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Category	Value
Counties	${volAuValByCounty.filter(\n (d) => d.volume <= countyMinMax[0] && d.value <= countyMinMax[1]\n ).length}
Sales Volume	${d3.format(\",d\")(countyMinMax[0])}
Sales Value	${irishLocale.format(\"$,\")(countyMinMax[1])}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":362,"value":"viewof countyMinMax = Inputs.form([\n Inputs.range(\n [\n d3.min(volAuValByCounty, (d) => d.volume) - 2.5e3,\n d3.max(volAuValByCounty, (d) => d.volume) + 2.5e3\n ],\n { step: 1e3, label: \"Volume\" }\n ),\n Inputs.range(\n [\n d3.min(volAuValByCounty, (d) => d.value) - 2e6,\n d3.max(volAuValByCounty, (d) => d.value) + 2e6\n ],\n { step: 1e6, label: \"Value\", 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":371,"value":"Plot.plot({\n marginLeft: 100,\n MarginRight: 100,\n width: 900,\n marks: [\n Plot.dot(\n volAuValByCounty.filter(\n (d) => d.volume <= countyMinMax[0] && d.value <= countyMinMax[1]\n ),\n { x: \"volume\", y: \"value\", fill: \"county\" }\n ),\n Plot.text(\n volAuValByCounty.filter(\n (d) => d.volume <= countyMinMax[0] && d.value <= countyMinMax[1]\n ),\n {\n x: \"volume\",\n y: \"value\",\n text: \"county\",\n dx: -5,\n dy: -5,\n textAnchor: \"end\"\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"Plot.plot({\n marginLeft: 100,\n MarginRight: 100,\n width: 900,\n marks: [\n Plot.dot(volAuValByCounty, {\n x: \"volume\",\n y: \"value\",\n fill: \"county\"\n }),\n Plot.text(volAuValByCounty, {\n x: \"volume\",\n y: \"value\",\n text: \"county\",\n dx: -5,\n dy: -5,\n textAnchor: \"end\"\n })\n ]\n})","pinned":true,"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","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":352,"value":"Plot.plot({\n x: { domain: [0, 2000] },\n y: { domain: [0, 1e6] },\n marginLeft: 100,\n MarginRight: 100,\n width: 900,\n marks: [\n Plot.text(\n volAuValByEircode.filter((d) => d.volume < 2000),\n { x: \"volume\", y: \"value\", text: \"eircode\" }\n )\n ]\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","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":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":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[\"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[\"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":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":280,"value":"### Volume vs Value Data by County","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":282,"value":"valueByCounty = d3.rollup(\n annual_sales_value,\n (e) => d3.sum(e, (f) => f.VALUE),\n (g) => g.county,\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"volumeByCounty = d3.rollup(\n annual_sales_volume,\n (e) => d3.sum(e, (f) => f.VALUE),\n (g) => g.county\n // (d) => d.Year\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"volAuValByCounty = {\n let result = [];\n for (let i of valueByCounty) {\n result.push({\n county: i[0],\n volume: volumeByCounty.get(i[0]),\n value: i[1] * 1e3\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":313,"value":"volAuValByCounty","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] * 1e3\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":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