29:null 2a:["$","title",null,{"children":"Briefwahl versus Urnenwahl | RND | Observable"}] 2f:Tea4,gemeinden_bb = Plot.plot({ width, height: new Set(brief_urne_bb.map((d) => d.party)).size * 45 + 60, insetRight: 20, marginBottom: 40, marginLeft: 100, marginTop: 20, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: "Prozent", grid: true, ticks: [10, 20, 30] }, y: { axis: null, domain: brief_urne_bb.map((d) => d.party) }, marks: [ // Überschrift Plot.text([`Brandenburg`], { frameAnchor: "top-left", dy: -15 }), // Text Partei Plot.text(brief_urne_bb, { x: 0, y: "party", dx: -50, textAnchor: "end", text: (d) => `${d.party}` }), // Text Veränderung positiv Plot.text(brief_urne_bb, { filter: (d) => d.change > 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#6bb024", text: (d) => `+${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // Text Veränderung Null Plot.text(brief_urne_bb, { filter: (d) => d.change == 0, x: 0, y: "party", fill: "#99AFC2", dx: -25, textAnchor: "middle", text: (d) => `±0` }), // Text Veränderung negativ Plot.text(brief_urne_bb, { filter: (d) => d.change < 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#e84f1c", text: (d) => `${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // helle Balken Plot.rectX(brief_urne_bb, { x: "brief", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#bfcdd9", fillOpacity: 0.3, insetTop: 2, insetBottom: 20, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // dunkle Balken Plot.rectX(brief_urne_bb, { x: "urne", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#99AFC2", insetTop: 20, insetBottom: 2, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // erstes Label Urne Plot.text(brief_urne_bb, { filter: (d) => d.party == "AfD", x: "urne", y: "party", textAnchor: "end", fill: "#fff", dx: -3, dy: 9, text: (d) => `Urne ${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // erstes Label Brief Plot.text(brief_urne_bb, { filter: (d) => d.party == "AfD", x: "brief", y: "party", textAnchor: "end", dx: -3, dy: -9, text: (d) => `Brief ${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Urne Plot.text(brief_urne_bb, { filter: (d) => d.party != "AfD", x: "urne", y: "party", textAnchor: "start", dx: 3, dy: 9, text: (d) => `${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Brief Plot.text(brief_urne_bb, { filter: (d) => d.party != "AfD", x: "brief", y: "party", textAnchor: "start", dx: 3, dy: -9, text: (d) => `${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), Plot.ruleX([0]) ] })30:Tea0,gemeinden_sn = Plot.plot({ width, height: new Set(brief_urne_sn.map((d) => d.party)).size * 45 + 60, insetRight: 20, marginBottom: 40, marginLeft: 100, marginTop: 20, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: "Prozent", grid: true, ticks: [10, 20, 30] }, y: { axis: null, domain: brief_urne_sn.map((d) => d.party) }, marks: [ // Überschrift Plot.text([`Sachsen`], { frameAnchor: "top-left", dy: -15 }), // Text Partei Plot.text(brief_urne_sn, { x: 0, y: "party", dx: -50, textAnchor: "end", text: (d) => `${d.party}` }), // Text Veränderung positiv Plot.text(brief_urne_sn, { filter: (d) => d.change > 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#6bb024", text: (d) => `+${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // Text Veränderung Null Plot.text(brief_urne_sn, { filter: (d) => d.change == 0, x: 0, y: "party", fill: "#99AFC2", dx: -25, textAnchor: "middle", text: (d) => `±0` }), // Text Veränderung negativ Plot.text(brief_urne_sn, { filter: (d) => d.change < 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#e84f1c", text: (d) => `${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // helle Balken Plot.rectX(brief_urne_sn, { x: "brief", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#bfcdd9", fillOpacity: 0.3, insetTop: 2, insetBottom: 20, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // dunkle Balken Plot.rectX(brief_urne_sn, { x: "urne", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#99AFC2", insetTop: 20, insetBottom: 2, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // erstes Label Urne Plot.text(brief_urne_sn, { filter: (d) => d.party == "AfD", x: "urne", y: "party", textAnchor: "end", fill: "#fff", dx: -3, dy: 9, text: (d) => `Urne ${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // erstes Label Brief Plot.text(brief_urne_sn, { filter: (d) => d.party == "AfD", x: "brief", y: "party", textAnchor: "end", dx: -3, dy: -9, text: (d) => `Brief ${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Urne Plot.text(brief_urne_sn, { filter: (d) => d.party != "AfD", x: "urne", y: "party", textAnchor: "start", dx: 3, dy: 9, text: (d) => `${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Brief Plot.text(brief_urne_sn, { filter: (d) => d.party != "AfD", x: "brief", y: "party", textAnchor: "start", dx: 3, dy: -9, text: (d) => `${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), Plot.ruleX([0]) ] })31:Tea2,gemeinden_th = Plot.plot({ width, height: new Set(brief_urne_th.map((d) => d.party)).size * 45 + 60, insetRight: 20, marginBottom: 40, marginLeft: 100, marginTop: 20, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: "Prozent", grid: true, ticks: [10, 20, 30] }, y: { axis: null, domain: brief_urne_th.map((d) => d.party) }, marks: [ // Überschrift Plot.text([`Thüringen`], { frameAnchor: "top-left", dy: -15 }), // Text Partei Plot.text(brief_urne_th, { x: 0, y: "party", dx: -50, textAnchor: "end", text: (d) => `${d.party}` }), // Text Veränderung positiv Plot.text(brief_urne_th, { filter: (d) => d.change > 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#6bb024", text: (d) => `+${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // Text Veränderung Null Plot.text(brief_urne_th, { filter: (d) => d.change == 0, x: 0, y: "party", fill: "#99AFC2", dx: -25, textAnchor: "middle", text: (d) => `±0` }), // Text Veränderung negativ Plot.text(brief_urne_th, { filter: (d) => d.change < 0, x: 0, y: "party", dx: -25, textAnchor: "middle", fill: "#e84f1c", text: (d) => `${d.change.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // helle Balken Plot.rectX(brief_urne_th, { x: "brief", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#bfcdd9", fillOpacity: 0.3, insetTop: 2, insetBottom: 20, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // dunkle Balken Plot.rectX(brief_urne_th, { x: "urne", y: "party", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#99AFC2", insetTop: 20, insetBottom: 2, stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // erstes Label Urne Plot.text(brief_urne_th, { filter: (d) => d.party == "AfD", x: "urne", y: "party", textAnchor: "end", fill: "#fff", dx: -3, dy: 9, text: (d) => `Urne ${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // erstes Label Brief Plot.text(brief_urne_th, { filter: (d) => d.party == "AfD", x: "brief", y: "party", textAnchor: "end", dx: -3, dy: -9, text: (d) => `Brief ${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Urne Plot.text(brief_urne_th, { filter: (d) => d.party != "AfD", x: "urne", y: "party", textAnchor: "start", dx: 3, dy: 9, text: (d) => `${d.urne.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // weitere Label Brief Plot.text(brief_urne_th, { filter: (d) => d.party != "AfD", x: "brief", y: "party", textAnchor: "start", dx: 3, dy: -9, text: (d) => `${d.brief.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), Plot.ruleX([0]) ] })32:Tca9,style = html`

`33:[{"id":"792f60fd8c11d7ccf712317cf009ea7807db38c0faa34c68f93daf2e7100bd2e2ba65715ec730b68b5565e06addd5ea1886436f43f28ad3a91c24623573b6cd8","href":"https://static.observableusercontent.com/files/792f60fd8c11d7ccf712317cf009ea7807db38c0faa34c68f93daf2e7100bd2e2ba65715ec730b68b5565e06addd5ea1886436f43f28ad3a91c24623573b6cd8","name":"bb_gemeinden_kreise_erst_zweit@10.csv","type":"text/csv","lastModified":1727091728741.574,"size":1194946}] 2d:{"id":"58f7ed4da89212a4","slug":null,"title":"Briefwahl versus Urnenwahl","thumbnail":"beed3c42eb56da7e029cea3ef43279040b64678cbb611eba736e88d536a00bd0","access_level":"public","create_time":"$D2024-09-23T11:42:08.741Z","update_time":"$D2024-09-23T14:44:31.871Z","view_time":null,"first_public_time":"$D2024-09-23T11:42:08.741Z","fork":{"id":"5a83acc6c761bec1","slug":null,"title":"Brandenburg: Gewinne und Verluste (Balken)","owner":{"id":"b8db01b7dd27a055","login":"rnd","name":"RND"}},"stars":0,"starred":false,"owner":{"type":"team","id":"b8db01b7dd27a055","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":"starter_2024"},"version":1460,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5f9b41b7f852d3da","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":null}],"members":[{"type":"individual","id":"5f9b41b7f852d3da","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":null,"role":"editor"},{"type":"team","id":"b8db01b7dd27a055","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Briefwahl versus Urnenwahl","cells":[{"id":0,"value":"# Briefwahl versus Urnenwahl","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1169,"value":"title = new URLSearchParams(document.location.search).get(\"title\") ??\n \"Landtagswahlen: Urnen- und Briefwahl\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"bb_gemeinden_title = html`\n

${title}

\n Zweitstimmenanteile der Parteien bei der Landtagswahl 2024 in Brandenburg in Prozent nach Art der Stimmabgabe und Unterschied zwischen Urnen- und Briefwahl. Stand: Vorläufiges Ergebnis vom 22.9.2024 um 23.10 Uhr

\n

\n `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":667,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1406,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1418,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"ltw_credits = md`

Grafik: RND/Christ • Quelle: Statistikämter der Länder

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"hochburgen = new Map([\n [\"CDU\", \"#333\"],\n [\"SPD\", \"#f44647\"],\n [\"Grüne\", \"#6abf4a\"],\n [\"FDP\", \"#ffd600\"],\n [\"Linke\", \"#c72767\"],\n [\"AfD\", \"#5fb1bf\"],\n [\"BSW\", \"#312783\"],\n [\"PARTEI\", \"#C63141\"],\n [\"BVB/Freie Wähler\", \"#E99939\"],\n [\"Piraten\", \"#FFC02F\"]\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1308,"value":"brief_urne_bb_data = read(\n \"https://docs.google.com/spreadsheets/d/1T8E61_wYdQeTahddH_ny1fQ82DzeojpSXtOFWk_AgpM/edit?gid=0#gid=0\",\n \"Brandenburg\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1408,"value":"brief_urne_sn_data = read(\n \"https://docs.google.com/spreadsheets/d/1T8E61_wYdQeTahddH_ny1fQ82DzeojpSXtOFWk_AgpM/edit?gid=0#gid=0\",\n \"Sachsen\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1410,"value":"brief_urne_th_data = read(\n \"https://docs.google.com/spreadsheets/d/1T8E61_wYdQeTahddH_ny1fQ82DzeojpSXtOFWk_AgpM/edit?gid=0#gid=0\",\n \"Thüringen\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1315,"value":"brief_urne_bb = brief_urne_bb_data.map((d) => ({\n party: d.party,\n urne: +d.urne,\n brief: +d.brief,\n change: +d.change\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1412,"value":"brief_urne_sn = brief_urne_sn_data.map((d) => ({\n party: d.party,\n urne: +d.urne,\n brief: +d.brief,\n change: +d.change\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1414,"value":"brief_urne_th = brief_urne_th_data.map((d) => ({\n party: d.party,\n urne: +d.urne,\n brief: +d.brief,\n change: +d.change\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"isDarkMode = () =>\n window.matchMedia && window.matchMedia(\"(prefers-color-scheme: dark)\").matches","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1304,"value":"googleSpreadsheetURLAdaptor = (path, sheet) => {\n // adjust path if given a path to a google doc but without the correct export suffix. the first sheet is taken since none is specified\n const GOOGLE_DOC_PREFIX = \"https://docs.google.com/spreadsheets/\";\n\n if (\n path.includes(GOOGLE_DOC_PREFIX) &&\n !path.includes(\"tqx=out:csv\") &&\n !path.includes(\"/pub?\")\n ) {\n const googleDocParsedUrl = path.split(GOOGLE_DOC_PREFIX)[1].split(\"/\");\n const googleDocId = googleDocParsedUrl[googleDocParsedUrl.indexOf(\"d\") + 1];\n return (\n GOOGLE_DOC_PREFIX +\n \"d/\" +\n googleDocId +\n \"/gviz/tq?tqx=out:csv\" +\n (sheet ? \"&sheet=\" + encodeURI(sheet.toLowerCase()) : \"\")\n );\n } else {\n return path;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"read = async function (url, sheet) {\n if (!url) return \"Provide URL above\";\n let result = [];\n const path = googleSpreadsheetURLAdaptor(url, sheet);\n const spreadsheet = await d3\n .csv(path)\n .then((data) => data.forEach((d) => result.push(d))); // d3.csv returns a Promise\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"ns = Inputs.text().classList[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2e:"$2d:body"