29:null 2a:["$","title",null,{"children":"Regierungserfahrung Parteien | RND | Observable"}] 2f:T11fe,parteien_chart = Plot.plot({ height: 700, width, marginRight: 50, marginLeft: 60, marginBottom: 20, y: { axis: null }, x: { label: null, grid: true, axis: "top", ticks: [0, 10, 20, 30] }, facet: { data: parteien, y: "Partei", label: null }, fy: { padding: 0.1, axis: null, domain: [ "CSU", "SPD", "Freie Wähler", "CDU", "FDP", "Grüne", "BSW", "Linke" ] }, marks: [ // Label Parteien Plot.text(new Set(parteien.map((d) => d.Partei)), { fy: (d) => d, x: 0, dx: -10, textAnchor: "end", text: (d) => d.replace("Freie Wähler", "FW") }), // Punkte Plot.dot( parteien, Plot.dodgeY({ fy: "Partei", x: "Erfahrung", fill: (d) => hochburgen.get(d.Partei), fillOpacity: 0.4, r: 4, padding: 0.2, tip: false, anchor: "middle" }) ), // Punkte Durchschnitt Plot.dot( parteien, Plot.dodgeY( Plot.groupY( { x: "mean" }, { x: "Erfahrung", y: (d) => d.Partei, r: 14, stroke: "#fff", strokeWidth: 1.5, anchor: "middle", stroke: (d) => hochburgen.get(d.Partei), sort: { y: "x" } } ) ) ), // Label Durchschnitt Plot.text( parteien, Plot.dodgeY( Plot.groupY( { x: "mean", text: (d) => d3.mean(d).toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 }) }, { x: "Erfahrung", y: (d) => d.Partei, anchor: "middle", fill: "#0f151a", stroke: "#fff", text: "Erfahrung", sort: { y: "x" } } ) ) ), // hervorgehobener Text Plot.text( parteien, Plot.dodgeY({ x: "Erfahrung", fillOpacity: (d) => [ "Reiner Haseloff", "Joachim Herrmann", "Boris Pistorius", "Stephan Weil", "Winfried Kretschmann", "Katja Wolf" ].includes(d.Name) ? 1 : 0, strokeOpacity: (d) => [ "Reiner Haseloff", "Joachim Herrmann", "Boris Pistorius", "Stephan Weil", "Winfried Kretschmann", "Katja Wolf" ].includes(d.Name) ? 1 : 0, r: 4, dy: -7, padding: 0.2, stroke: isDarkMode() ? "#657482" : "#ffffff", fill: isDarkMode() ? "#ffffff" : "#657482", lineAnchor: "bottom", textAnchor: "middle", text: (d) => `${d.Nachname}`, anchor: "middle" ?? undefined }) ), // hervorgehobene Kreise Plot.dotX( parteien, Plot.dodgeY({ x: "Erfahrung", fillOpacity: 0, r: 4, stroke: (d) => hochburgen.get(d.Partei), strokeWidth: 0.75, strokeOpacity: (d) => [ "Reiner Haseloff", "Joachim Herrmann", "Boris Pistorius", "Stephan Weil", "Winfried Kretschmann", "Katja Wolf" ].includes(d.Name) ? 1 : 0, padding: 0.2, tip: false, anchor: "middle" ?? undefined }) ), // Tooltip Plot.text( parteien, Plot.dodgeY( Plot.pointer({ x: "Erfahrung", r: 4, padding: 0.2, stroke: isDarkMode() ? "#657482" : "#ffffff", fill: isDarkMode() ? "#ffffff" : "#657482", lineAnchor: "top", textAnchor: "middle", dy: 7, text: (d) => `${d.Vorname} ${d.Nachname}\n${d.Amt}\n${ d.Gebietskörperschaft }\n${d.Erfahrung.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })} Jahre`, anchor: "middle" ?? undefined }) ) ), // Hover Plot.dotX( parteien, Plot.dodgeY( Plot.pointer({ x: "Erfahrung", fillOpacity: 0, r: 4, strokeWidth: 0.75, padding: 0.2, tip: false, stroke: (d) => hochburgen.get(d.Partei), anchor: "middle" ?? undefined }) ) ) ] })30:Tef3,style = html`

`31:[] 2d:{"id":"6d7b483a9728ed3d","slug":null,"title":"Regierungserfahrung Parteien","thumbnail":"113ad5e336c1dec3e29bd1faceece413d902abc09e78ee80572498ef99c4a5ac","access_level":"public","create_time":"$D2024-12-25T13:02:54.698Z","update_time":"$D2026-05-04T11:28:36.856Z","view_time":null,"first_public_time":"$D2024-12-25T13:02:54.698Z","fork":{"id":"3d3eb6effc05e9b1","slug":null,"title":"Parteispenden Volt","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":669,"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":"Regierungserfahrung Parteien","cells":[{"id":0,"value":"# Regierungserfahrung Parteien","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":137,"value":"parteien_title = html`\n

Erfahrene CSU-Minister

\n Durchschnittliche Regierungserfahrung der amtierenden Regierungsmitglieder in Bund und Ländern in Jahren. Stand: ${stand}\n

\n `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"parteien_credits = md`

Grafik: RND/Christ • Quelle: eigene Recherche

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"stand = new Date(today)\n .getDate()\n .toString()\n .concat(\".\")\n .concat((new Date(today).getMonth() + 1).toString())\n .concat(\".\")\n .concat(new Date(today).getFullYear().toString())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"today = new Date(2025, 3, 29).toJSON().slice(0, 10).replace(/-/g, \"-\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"hochburgen = new Map([\n [\"CDU\", isDarkMode() ? \"#99AFC2\" : \"#333\"],\n [\"CSU\", isDarkMode() ? \"#99AFC2\" : \"#333\"],\n [\"Union\", isDarkMode() ? \"#99AFC2\" : \"#333\"],\n [\"SPD\", \"#f44647\"],\n [\"Grüne\", \"#6abf4a\"],\n [\"FDP\", \"#ffd600\"],\n [\"Linke\", \"#c72767\"],\n [\"AfD\", \"#5fb1bf\"],\n [\"BSW\", \"#312783\"],\n [\"PARTEI\", \"#C63141\"],\n [\"Freie Wähler\", \"#E99939\"],\n [\"FW\", \"#E99939\"],\n [\"Piraten\", \"#FFC02F\"]\n])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":169,"value":"parteien_data = read(\n \"https://docs.google.com/spreadsheets/d/1Pksx4Nj3FwkWiCBis0NdmMkGrZHlg7UTrYbYgkzNs6s/edit?gid=752732988#gid=752732988\",\n \"regierung_bund_land\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"parteien = parteien_data.map((d) => ({\n ...d,\n Partei: d.Partei,\n Erfahrung: +d.Erfahrung,\n Erfahrung_bis_Amt: +d.Erfahrung_bis_Amt\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"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":171,"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":43,"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":31,"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"