32:[{"id":"73c9025a11866bb60389f6696354db8c18e831b671f8f3a96789834bcdbdaaf7d19797869966dcaa2c82493ea084fd5889178a74cd503c582826e0830c1843da","href":"https://static.observableusercontent.com/files/73c9025a11866bb60389f6696354db8c18e831b671f8f3a96789834bcdbdaaf7d19797869966dcaa2c82493ea084fd5889178a74cd503c582826e0830c1843da","name":"hibeta.json","type":"application/json","lastModified":1624349443793.407,"size":542104}] 30:{"title":"An attempt at some simple functions to work with JSON-stat","cells":[{"id":0,"value":"md`# An attempt at some simple functions to work with JSON-stat\n\nThis is a quick attempt at creating some simple functions to work with data in JSON-stat format. These won't work with all types of JSON-stat, and in general it would be better to use the [JSON-stat toolkit](https://www.npmjs.com/package/jsonstat-toolkit).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"md`jsonstatGet() takes a JSON-stat object and one category per dimension, and returns the corresponding value.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"jsonstatGet(data, \"E06000010\", \"Indicator:Housing affordability\", \"2016\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":140,"value":"md`jsonstatGetPartial() takes a JSON-stat object and one category per dimension, with optional nulls for unspecified categories. It returns a function whose arguments fill in the blanks for the unspecified categories, and which returns the corresponding value. In the following example, getHousingAffordability returns a getter for housing affordability that has two parameters: area code and year.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":127,"value":"getHousingAffordability = jsonstatGetPartial(\n data,\n null,\n \"Indicator:Housing affordability\",\n null\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":83,"value":"getHousingAffordability(\"E92000001\", \"2016\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":147,"value":"md`jsonStatToArray() takes a JSON-stat object and returns an array containing one object per value. Each object contains a value along with the corresponding categories. It also contains category labels (e.g. \"AreaCode_label\": \"England\") if they exist.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"jsonstatToArray(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":158,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"id":68,"value":"function jsonstatGet(data, ...keys) {\n let index = 0;\n keys.forEach((key, i) => {\n if (i > 0) index *= data.size[i];\n index += data.dimension[data.id[i]].category.index[key];\n });\n return data.value[index];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":81,"value":"function jsonstatGetPartial(data, ...partialKeys) {\n return (...keys) => {\n let i = 0;\n return jsonstatGet(\n data,\n ...partialKeys.map(key => (key === null ? keys[i++] : key))\n );\n };\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":99,"value":"function jsonstatToArray(data) {\n let value = {};\n let result = [];\n let dimensions = data.id.map((id, i) => {\n let dims = new Array(data.size[i]);\n for (let category in data.dimension[id].category.index) {\n dims[data.dimension[id].category.index[category]] = category;\n }\n return dims;\n });\n let helper = function(dimensionIndex) {\n let dimensionId = data.id[dimensionIndex];\n for (let category of dimensions[dimensionIndex]) {\n value[dimensionId] = category;\n if (\"label\" in data.dimension[dimensionId].category) {\n value[dimensionId + \"_label\"] =\n data.dimension[dimensionId].category.label[category];\n }\n if (dimensionIndex === dimensions.length - 1) {\n value[\"value\"] = data.value[result.length];\n result.push({ ...value });\n } else {\n helper(dimensionIndex + 1);\n }\n }\n };\n helper(0);\n return result;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":101,"value":"jsonstatToArray(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":23,"value":"data = FileAttachment(\"hibeta.json\").json()","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}