3e:null 3f:["$","title",null,{"children":"central vs local budjets | data-lab | Observable"}] 45:T882,vis2 = Plot.plot({ style: { fontSize: 14 }, inset: 10, width: width > 600 ? 650 : 350, height: width > 600 ? 550 : 350, grid: true, color: { // scheme: "RdYlBu", domain: [0, 200], range: ["red", "blue"] // type: "threshold" // legend: true }, marginBottom: 60, marginLeft: 60, x: { domain: [0, 350], nice: true }, y: { domain: [0, 350], nice: true }, marks: [ Plot.axisX({ tickFormat: (d) => d + "%", label: "Доходи в 2022 році\nвідносно 2021 року", fontWeight: 700, labelOffset: 50 }), Plot.axisY({ tickFormat: (d) => d + "%", label: "Витрати в 2022 році\nвідносно 2021 року", fontWeight: 700, ticks: 4 }), // Мостиської Plot.dot(data2, { filter: (d) => d.gromada.includes("терит"), x: "per_inc22", y: "per_spend22", fill: "per_inc22", tip: true, r: 4, title: (d) => `Бюджет ${d.gromada}\n\nДоходи в 2022 році: ${Math.round( d.per_inc22 )}%\nВитрати в 2022 році: ${Math.round(d.per_spend22)}%`, stroke: "white", strokeWidth: 0.5 }), Plot.dot(data2, { filter: (d) => d.gromada.includes("Мачух"), x: "per_inc22", y: "per_spend22", fill: "per_inc22", tip: true, r: 14, title: (d) => `Бюджет ${d.gromada}\n\nДоходи в 2022 році: ${Math.round( d.per_inc22 )}%\nВитрати в 2022 році: ${Math.round(d.per_spend22)}%`, stroke: "white", strokeWidth: 0.5 }), Plot.text(["Яворівська\nгромада"], { frameAnchor: "middle", dx: width > 600 ? 220 : 110, dy: width > 600 ? -65 : -45, stroke: "white", strokeWidth: 4, fill: "currentColor", fontSize: 12 }), Plot.ruleX([100], { strokeDasharray: 4, strokeOpacity: 0.4 }), Plot.ruleY([100], { strokeDasharray: 4, strokeOpacity: 0.4 }) // Plot.linearRegressionY(data2, { // x: "per_inc", // y: "per_spend", // opacity: 0.5 // }) ] })46:T67d,// 11020000 Податок на прибуток підприємств // 14040000 Акцизний податок з реалізації суб’єктами …дарювання роздрібної торгівлі підакцизних товарів. // 13030000 Рентна плата за користування надрами загальнодержавного значення // 41020000 Дотації з державного бюджету місцевим бюджетам // 11010000 Податок та збір на доходи фізичних осіб data = { return (await FileAttachment("data@2.tsv").tsv()) .filter( (d) => d.INCO3 == "11010000 Податок та збір на доходи фізичних осіб" ) .map((d) => { return { ...d, v21: +d["2021_EXECUTED"], v22: +d["2022_EXECUTED"], diff: +d["2022_EXECUTED"] - +d["2021_EXECUTED"], diff_per2: +d["2022_EXECUTED"] / +d["2021_EXECUTED"], diff_per: ((+d["2022_EXECUTED"] - +d["2021_EXECUTED"]) / +d["2021_EXECUTED"]) * 100, type: d.ADMIN4.includes("міської") || d.ADMIN4.includes("Київ") ? "Міські" : d.ADMIN4.includes("сільської") ? "сілські" : d.ADMIN4.includes("селищної") ? "селищні" : "інші", otg: d.ADMIN4.replace(/.+Бюджет\s/, "").replace(/(цьк.+)|(ськ.+)/, "") }; }) .sort((a, b) => b.diff - a.diff) .filter((d) => d.type != "інші"); // .filter((d) => d.diff_per > -100); } 47:[{"id":"103d40412daaa7b23194f92d714c708535206053f62f7d2633e2aaf78d7f00eb9d915bdf29c1c0900f57b564078dcc58d2b2f4617aac32e9f804e52fa75789fe","href":"https://static.observableusercontent.com/files/103d40412daaa7b23194f92d714c708535206053f62f7d2633e2aaf78d7f00eb9d915bdf29c1c0900f57b564078dcc58d2b2f4617aac32e9f804e52fa75789fe","name":"otg_LotLan.geojson","type":"application/geo+json","lastModified":1684154474995.841,"size":282714},{"id":"a54c897ae8ef1b8e239d7304f50e298ef2189b5eaa8c785e55864dc9a74b64c8aa5306ab1422c2a225a1f4024b6c43c9decaa6dcb2c5395d54a5c29866f5208a","href":"https://static.observableusercontent.com/files/a54c897ae8ef1b8e239d7304f50e298ef2189b5eaa8c785e55864dc9a74b64c8aa5306ab1422c2a225a1f4024b6c43c9decaa6dcb2c5395d54a5c29866f5208a","name":"data@2.tsv","type":"text/tab-separated-values","lastModified":1684510369796.767,"size":14620803},{"id":"047ffa9a3264c326438a404a06427e29684326d50e7a35d3fec376acaaf5a29831cf89b73dce9904ded82fbf482d5aa1a35a34e81fad9a3ead248dc160b6aac0","href":"https://static.observableusercontent.com/files/047ffa9a3264c326438a404a06427e29684326d50e7a35d3fec376acaaf5a29831cf89b73dce9904ded82fbf482d5aa1a35a34e81fad9a3ead248dc160b6aac0","name":"ukraine2@1.json","type":"application/json","lastModified":1689753801161.326,"size":1597426},{"id":"325039ea99a75eee92b05ff6a92a6d91038707312e934e8fe1ad97789b5eabb1c96b2217fa2087afe806a6d5fd1df4b30523d2b2ca837cd846b5fdc1748ad566","href":"https://static.observableusercontent.com/files/325039ea99a75eee92b05ff6a92a6d91038707312e934e8fe1ad97789b5eabb1c96b2217fa2087afe806a6d5fd1df4b30523d2b2ca837cd846b5fdc1748ad566","name":"opendudget@4.csv","type":"text/csv","lastModified":1689773364152.405,"size":277751},{"id":"586f9882fcea9c401ba5711413a608d04c6ffb1b67a8c67d7ab65fbc953a22e1e080383d82566da0a778f3a35f606adf7be0c2f8a163cb7aa31edcec6c15ef7d","href":"https://static.observableusercontent.com/files/586f9882fcea9c401ba5711413a608d04c6ffb1b67a8c67d7ab65fbc953a22e1e080383d82566da0a778f3a35f606adf7be0c2f8a163cb7aa31edcec6c15ef7d","name":"opendudget@5.csv","type":"text/csv","lastModified":1689846490422.953,"size":280166}] 43:{"id":"8404992955f74dfc","slug":null,"title":"central vs local budjets","thumbnail":"4da0a4e54db7a8bfcd0a140ce6dffc9bdc720d0a07493905e9362beff24e0b7e","access_level":"public","create_time":"$D2023-05-15T09:50:14.686Z","update_time":"$D2024-07-02T16:15:55.980Z","view_time":null,"first_public_time":"$D2023-05-15T09:50:14.686Z","has_unpublished_edits":null,"fork":{"id":"a494fea1c03bee0d","slug":null,"title":"Plot map ua detaled","owner":{"id":"4d72365432a21036","login":"data-lab","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"4d72365432a21036","login":"data-lab","name":"","avatar_url":"https://avatars-next.observableusercontent.com/5ef3e55a07e7e93b9f705441da61ea92b2221fd514da19cf2f785fa33256efec","tier":"starter_2024","bio":"","following":false},"version":3613,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6886b4af7abe4967","login":"data-lab","name":"","avatar_url":"https://avatars-next.observableusercontent.com/5ef3e55a07e7e93b9f705441da61ea92b2221fd514da19cf2f785fa33256efec","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"6886b4af7abe4967","login":"data-lab","name":"","avatar_url":"https://avatars-next.observableusercontent.com/5ef3e55a07e7e93b9f705441da61ea92b2221fd514da19cf2f785fa33256efec","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"central vs local budjets","cells":[{"id":0,"value":"# central vs local budjets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2955,"value":"ua = FileAttachment(\"ukraine2@1.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2945,"value":"regions = topojson.feature(ua, ua.objects.regions)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3543,"value":"legend = html`

Громади, які в 2022 році збільшили або зменшили
надходження від ПДФО, у порівнянні з 2021 роком.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1852,"value":"vis1 = Plot.plot({\n // style: { fontSize: 12, background: \"#e0ecf4\" },\n width: width > 600 ? 900 : 400,\n height: width > 600 ? 560 : 270,\n projection: d3\n .geoMercator()\n .scale(width > 600 ? 2500 : 1250)\n .center([width > 600 ? 32 : 44, width > 600 ? 48.9 : 45]),\n marks: [\n // Plot.frame(),\n Plot.geo(regions, {\n strokeWidth: 0.5,\n stroke: \"#333\"\n }),\n\n Plot.vector(\n otgLonLan,\n Plot.centroid({\n anchor: \"start\",\n length: (d) => d.diff,\n stroke: (d) => (d.diff < 0 ? \"red\" : \"blue\"),\n rotate: (d) => (d.diff < 0 ? 60 : -60)\n })\n ),\n Plot.text([\"Яворівська\\nгромада\"], {\n frameAnchor: \"middle\",\n dx: width > 600 ? -370 : -165,\n dy: width > 600 ? -140 : -80,\n stroke: \"white\",\n strokeWidth: 4,\n fill: \"currentColor\",\n fontSize: 14\n })\n ]\n // caption: htl.html`The voyage of Charles Darwin aboard HMS Beagle, 1831–1836.`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3576,"value":"otgLonLan","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2990,"value":"data2.filter((d) => d.ADMIN4.includes(\"дачн\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2979,"value":"s","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3187,"value":"$45","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2642,"value":"d3.rollup(\n data,\n (v) => v.length,\n (d) => d.INCO3\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2296,"value":"$46","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2555,"value":"data.sort((b, a) => a.diff_per - b.diff_per)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2595,"value":"// data.filter((d) => d.ADMIN4.includes(\"Дніпро\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1846,"value":"diff = new Map(data.map((d) => [d.otg, d.diff_per]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1909,"value":"otgLonLan = {\n return (\n (await FileAttachment(\"otg_LotLan.geojson\").json()).features\n .map((d) => {\n return {\n ...d,\n diff: diff.get(d.properties.hromada.replace(/(цьк.+)|(ськ.+)/, \"\"))\n };\n })\n // .filter((d) => d.diff < 1000 && d.diff > -50)\n .sort((a, b) => b.diff - a.diff)\n );\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3011,"value":"data2 = {\n return (await FileAttachment(\"opendudget@5.csv\").csv()).map((d) => {\n return {\n ...d,\n per_inc: +d.per_inc,\n per_spend: +d.per_spend,\n per_inc22: +d.per_inc22,\n per_spend22: +d.per_spend22,\n gromada: d.ADMIN4.replace(/.+жет\\s/, \"\")\n };\n });\n // .filter((d) => d.diff < 1000 && d.diff > -50)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 44:"$43:body"