29:null 2a:["$","title",null,{"children":"Direktmandate der Ministerpräsidenten | RND | Observable"}] 2f:Ta4d,gemeinden_bb = Plot.plot({ width, height: new Set(direktmandat.map((d) => d.nachname)).size * 40 + 40, insetRight: 20, marginBottom: 40, marginLeft: 90, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: "Prozent", grid: true, ticks: [20, 40, 60] }, y: { axis: null, domain: direktmandat.map((d) => d.nachname) }, marks: [ // Text MP Plot.text(direktmandat, { x: 0, y: "nachname", dx: -5, dy: -7, fontWeight: 600, fontSize: 12, fontFamily: "InterRegular", textAnchor: "end", text: (d) => `${d.nachname}` }), // Text Partei Plot.text(direktmandat, { x: 0, y: "nachname", dx: -5, dy: 7, textAnchor: "end", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.party}` }), // Balken Plot.rectX(direktmandat, { x: "percent", y: "nachname", fill: (d) => Array.from(hochburgen.keys()).includes(d.party) ? hochburgen.get(d.party) : "#99AFC2", stroke: "#fff", strokeWidth: isDarkMode() ? 1 : 0 }), // Text Land Plot.text(direktmandat, { x: 0, y: "nachname", dx: 5, textAnchor: "start", fill: "#fff", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.land.replace("-", "-\n")}` }), // Label Plot.text(direktmandat, { x: "percent", y: "nachname", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", textAnchor: "start", dx: 3, text: (d) => `${d.percent.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` }), // Symbol Plot.text(direktmandat, { x: "percent", y: "nachname", fill: (d) => (d.verlierer == "FALSE" ? "#6bb024" : "#e84f1c"), fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", textAnchor: "start", dx: 32, text: (d) => (d.verlierer == "FALSE" ? `✔` : `✘`) }), // Tooltip Plot.tip( direktmandat, Plot.pointerY({ x: 0, y: "nachname", anchor: "left", fill: isDarkMode() ? "#293845" : "#ffffff", fillOpacity: 0.8, strokeOpacity: 0.5, title: (d) => `${d.mp}: ${d.percent.toLocaleString("de", { maximumFractionDigits: 1 })} Prozent\n${d.wahlkreis}` }) ), Plot.ruleX([0]) ] })30:Tf45,style = html`

`31:[] 2d:{"id":"5f0cdb6d8542649e","slug":null,"title":"Direktmandate der Ministerpräsidenten","thumbnail":"25cbe05f8f7ada5c94edfee2e36cdac5f775ee56d71181aca0c67874c7d07039","access_level":"public","create_time":"$D2024-09-24T07:28:06.103Z","update_time":"$D2024-09-24T09:20:47.330Z","view_time":null,"first_public_time":"$D2024-09-24T07:28:06.103Z","fork":{"id":"58f7ed4da89212a4","slug":null,"title":"Briefwahl versus Urnenwahl","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":1568,"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":2,"collection":null,"type":"notebook","body":{"title":"Direktmandate der Ministerpräsidenten","cells":[{"id":0,"value":"# Direktmandate der Ministerpräsidenten","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 \"Ergebnisse im Wahlkreis\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"bb_gemeinden_title = html`\n

${title}

\n Erststimmenanteile der Ministerpräsidenten in ihrem Wahlkreis jeweils in der vergangengenen Landtagswahl in Prozent\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":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 [\"CSU\", \"#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":"direktmandat_data = read(\n \"https://docs.google.com/spreadsheets/d/1aRyqh6nESs8RSa4M2XuEdR9Ll7QXAfgRrKnGRKLpGFM/edit?gid=0#gid=0\",\n \"direktmandat\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1487,"value":"direktmandat = direktmandat_data.map((d) => ({\n ...d,\n percent: +d.percent\n}))","pinned":true,"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":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2e:"$2d:body"