2b:null 2c:["$","title",null,{"children":"Neueintragungen | Office for Statistics and Data of the Canton of Zurich | Observable"}] 31:Tc02,viewof totalNeueintragungen = vl .data(neueintragungen) .transform([ { calculate: "datum.kumsum > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "kumsum", axis: { format: "f", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "transparent" }, value: "#fff" } }, scale: { domain: [0, extentKumsum * 1.1] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { timeUnit: "year", field: "jahr", type: "ordinal", scale: { range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: null } } }, { mark: { type: "text" }, encoding: { text: { field: "kumsum", type: "quantitative" } } } ] }) .columns(nCol) .title({ text: "Kumulierte Anzahl Neueintragungen pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14, color: "white", dy: 15 } }) .render()32:Tbe4,viewof anzahlNeueintragungen = vl .data(neueintragungen) .transform([ { calculate: "datum.n > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "n", axis: { format: "f", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "transparent" }, value: "#fff" } }, scale: { domain: [0, extentN * 1.1] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { timeUnit: "year", field: "jahr", type: "ordinal", scale: { range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: null } } }, { mark: { type: "text" }, encoding: { text: { field: "n", type: "quantitative" } } } ] }) .columns(nCol) .title({ text: "Anzahl Neueintragungen pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14, color: "white", dy: 15 } }) .render()33:Tcdd,viewof vorjahresvergleichNeueintragungen = vl .data(neueintragungen) .transform([ { calculate: "datum.ytd > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "ytd", axis: { format: "+%", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: extentYTD } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.ytd < 0 ? 12.5 : -12.5" } }, encoding: { text: { field: "ytd", type: "quantitative", format: "+.0%" }, color: { condition: { test: "datum.ytd < 0", value: "#000" }, value: "#000" } } } ] }) .columns(nCol) .title({ text: "Veränderung zum Vorjahresquartal, in Prozent", subtitle: "Kanton Zürich, Basis: Anzahl Neueintragungen" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()34:T4fd,drawGroupedBarChart = function (daten, facet_field, title, y_value) { const plot = vl .data(daten) // .transform({ // filter: "datum.stichtag_quarter == '06-30' " // }) .layer( vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusTopLeft: 3 }) .encode( vl.column().fieldO(facet_field).timeUnit("utcmonth").title(null), vl.x().fieldN("jahr").axis({ title: null }), vl.y().sum(y_value).axis(null), vl .color({ legend: null }) .fieldN("jahr") .scale({ range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }) ), vl .markText({ align: "center", fill: "white", fontWeight: "bold", fontSize: 12, dy: 15 }) .encode( vl.column().fieldO(facet_field).timeUnit("utcmonth").title(null), vl.x().fieldN("jahr"), vl.y().sum(y_value), vl.text({ baseline: "middle", field: `${y_value}` }) ) ) .title({ text: title, anchor: "middle", fontSize: 13 }); return plot; }35:[{"id":"b56b855d8d25b20dc0205735d8f36493f660b83674d6d34a980b463be4dc1999a4fd0d39b33fdb2f0b546017ce6db2b8237c3954d60b85a64df4951d37a42e97","href":"https://static.observableusercontent.com/files/b56b855d8d25b20dc0205735d8f36493f660b83674d6d34a980b463be4dc1999a4fd0d39b33fdb2f0b546017ce6db2b8237c3954d60b85a64df4951d37a42e97","name":"data_neu@1.csv","type":"text/csv","lastModified":1654174100701.089,"size":23580},{"id":"5bf84a7c2acaad5272114053bef11ce50eda61c276c7eb10f720ae61950966a626c66096fe711ca09001e516c5c87f5cd4b391c3b464aee92b632a63fce9e7c3","href":"https://static.observableusercontent.com/files/5bf84a7c2acaad5272114053bef11ce50eda61c276c7eb10f720ae61950966a626c66096fe711ca09001e516c5c87f5cd4b391c3b464aee92b632a63fce9e7c3","name":"data_neu@2.csv","type":"text/csv","lastModified":1657790083491.938,"size":25916}] 2f:{"id":"7c86a232e61a9346","slug":null,"title":"Neueintragungen","thumbnail":"5fba4457bcb4d6763b81d6238aba72c1319b547e08706d7aaead7972f66b24bd","access_level":"public","create_time":"$D2022-03-22T06:40:20.413Z","update_time":"$D2024-09-05T05:38:18.917Z","view_time":null,"first_public_time":"$D2022-10-26T05:56:05.864Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro"},"version":2628,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null}],"members":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Neueintragungen","cells":[{"id":0,"value":"# Neueintragungen\n\nOpen Data beziehen: [Neueintragungen pro Quartal und Branchen ab 2018](https://www.zh.ch/de/politik-staat/statistik-daten/datenkatalog.html#/datasets/1421@handelsregisteramt-kanton-zuerich/distributions/2778)\n\nThemenseite auf zh.ch: [Zahlen & Fakten zu Eintragungen im Handelsregister](https://www.zh.ch/de/wirtschaft-arbeit/handelsregister/zahlen-fakten.html#main_linklist)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2410,"value":"viewof neueintragungenSelection = Inputs.radio(\n [\"Anzahl\", \"Kumulierte Anzahl\", \"Veränderung\"],\n {\n label: \"Datensicht wechseln\",\n value: \"Anzahl\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2413,"value":"neueintragungenTotal = (function () {\n if (neueintragungenSelection == \"Anzahl\") {\n return htl.html`\n${viewof neueintragungenSelection}\n
\n${viewof anzahlNeueintragungen}`;\n } else if (neueintragungenSelection == \"Kumulierte Anzahl\") {\n return htl.html`\n${viewof neueintragungenSelection}\n
\n${viewof totalNeueintragungen}`;\n } else if (neueintragungenSelection == \"Veränderung\") {\n return htl.html`\n${viewof neueintragungenSelection}\n
\n${viewof vorjahresvergleichNeueintragungen}`;\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2596,"value":"---\n### Code für Plots","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2211,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2332,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2344,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1845,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"-----\n### Daten","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2446,"value":"data = \n d3.csv(\n \"https://www.web.statistik.zh.ch/ogd/data/KANTON_ZUERICH_HRA_Neueintragungen.csv\",\n { typed: true }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"neueintragungen = tidy(\n data,\n filter((d) => d.branchen == \"Total\" && d.jahr >= mostRecentYear - 2),\n mutate({\n ytd: (d) => +d.vj_rel_n,\n n: (d) => +d.n,\n kumsum: (d) => +d.kumsum,\n jahr: (d) => d.jahr.toString(),\n stichtag_quarter: (d) => d.quartal\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2051,"value":"mostRecentYear = d3.max(data, (d) => d.jahr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2161,"value":"extentYTD = (function (d) {\n const minNetflow = d3.min(neueintragungen, (d) => d.ytd);\n const maxNetflow = d3.max(neueintragungen, (d) => d.ytd);\n\n if (minNetflow < 0 && 0 - minNetflow > maxNetflow - 0) {\n return [minNetflow * 1.25, (0 - minNetflow) * 1.25];\n } else if (minNetflow < 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.25, maxNetflow * 1.25];\n } else if (minNetflow > 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.25, maxNetflow * 1.25];\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2181,"value":"extentKumsum = d3.max(neueintragungen, (d) => d.kumsum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2175,"value":"extentN = d3.max(neueintragungen, (d) => d.n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"---\n### Code for Formatting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"// Sets the locale for Vega-Lite axis, but not for text in tooltip (CMS does not recognise)\nlocale = await d3.json(\n \"https://cdn.jsdelivr.net/npm/d3-format@3/locale/de-CH.json\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"plotWidth = function (nPlots) {\n if (nPlots == 1) {\n // Entspricht Mobile\n if (width < 415) {\n return width * 0.88;\n } else if (width >= 415 && width < 768) {\n return width * 0.855;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return width * 0.877;\n // Entspricht Laptops & Desktops\n } else {\n return 1128 * 0.9275;\n }\n } else {\n // Entspricht Mobile\n if (width < 768) {\n return (width * 1.4) / nPlots;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return (width * 1.6) / nPlots;\n // Entspricht Laptops & Desktops\n } else {\n return (1128 * 0.92) / nPlots;\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"nCol = {\n if (width >= 1100) {\n return 4;\n } else if (width < 1100 && width >= 750) {\n return 2;\n } else {\n return 1;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"---\n### Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2620,"value":"import { fonts as ZHFonts } from \"@statistikzh/common-styles\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"import { tidy, mutate, filter } from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":478,"value":"eintragungenTotal = tidy(\n data,\n filter((d) => d.branchen == \"Total\"),\n mutate({\n jahr: (d) => d3.timeFormat(\"%Y\")(new Date(d.stichtag)),\n // convert the date string into a date object:\n date: (d) => new Date(d.stichtag),\n stichtag_quarter: (d) => d3.timeFormat(\"%m-%d\")(d.date)\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"