29:null 2a:["$","title",null,{"children":"Regierungserfahrung MPs | RND | Observable"}] 2f:T944,mp_chart = Plot.plot({ width, height: new Set(mp.map((d) => d.Nachname)).size * 40 + 40, insetRight: 20, marginBottom: 30, marginLeft: 160, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: null, grid: true, axis: "top", domain: [0, 30], ticks: [0, 10, 20, 30] }, y: { axis: null, domain: mp.map((d) => d.Nachname) }, marks: [ // Text Minister Plot.text(mp, { x: 0, y: "Nachname", dx: -5, dy: -7, fontWeight: 600, fontSize: 12, fontFamily: "InterRegular", textAnchor: "end", text: (d) => `${d.Nachname} (${d.Partei})` }), // Text Amt Plot.text(mp, { x: 0, y: "Nachname", dx: -5, dy: 7, textAnchor: "end", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.Gebietskörperschaft}` }), // Balken Erfahrung bis MP Plot.rectX(mp, { x: "Erfahrung_bis_Amt", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), strokeWidth: 0 }), // Balken Erfahrung MP Plot.rectX(mp, { x1: "Erfahrung_bis_Amt", x2: "Erfahrung", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), fillOpacity: 0.1, strokeWidth: 0 }), // Label Plot.text(mp, { x: "Erfahrung_bis_Amt", y: "Nachname", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", textAnchor: "start", dx: 3, text: (d) => d.Erfahrung_bis_Amt > 0 ? `${d.Erfahrung_bis_Amt.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` : 0 }), // Tooltip Plot.tip( mp, Plot.pointerY({ x: 0, y: "Nachname", anchor: "left", fill: isDarkMode() ? "#293845" : "#ffffff", fillOpacity: 0.8, strokeOpacity: 0.5, title: (d) => `${d.Vorname} ${ d.Nachname }\nbis Amtsantritt: ${d.Erfahrung_bis_Amt.toLocaleString("de", { maximumFractionDigits: 1 })} Jahre\ninsgesamt: ${d.Erfahrung.toLocaleString("de", { maximumFractionDigits: 1 })} Jahre` }) ), Plot.ruleX([0]) ] })30:T957,weil_chart = Plot.plot({ width, height: new Set(mp_weil.map((d) => d.Nachname)).size * 40 + 40, insetRight: 20, marginBottom: 30, marginLeft: 160, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: null, grid: true, axis: "top", domain: [0, 30], ticks: [0, 10, 20, 30] }, y: { axis: null, domain: mp_weil.map((d) => d.Nachname) }, marks: [ // Text Minister Plot.text(mp_weil, { x: 0, y: "Nachname", dx: -5, dy: -7, fontWeight: 600, fontSize: 12, fontFamily: "InterRegular", textAnchor: "end", text: (d) => `${d.Nachname} (${d.Partei})` }), // Text Amt Plot.text(mp_weil, { x: 0, y: "Nachname", dx: -5, dy: 7, textAnchor: "end", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.Gebietskörperschaft}` }), // Balken Erfahrung bis MP Plot.rectX(mp_weil, { x: "Erfahrung_bis_Amt", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), strokeWidth: 0, fillOpacity: 0.3 }), // Balken Erfahrung MP Plot.rectX(mp_weil, { x1: "Erfahrung_bis_Amt", x2: "Erfahrung", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), strokeWidth: 0 }), // Label Plot.text(mp_weil, { x: "Erfahrung", y: "Nachname", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", textAnchor: "start", dx: 3, text: (d) => d.Erfahrung > 0 ? `${d.Erfahrung.toLocaleString("de", { minimumFractionDigits: 1, maximumFractionDigits: 1 })}` : 0 }), // Tooltip Plot.tip( mp_weil, Plot.pointerY({ x: 0, y: "Nachname", anchor: "left", fill: isDarkMode() ? "#293845" : "#ffffff", fillOpacity: 0.8, strokeOpacity: 0.5, title: (d) => `${d.Vorname} ${ d.Nachname }\nbis Amtsantritt: ${d.Erfahrung_bis_Amt.toLocaleString("de", { maximumFractionDigits: 1 })} Jahre\ninsgesamt: ${d.Erfahrung.toLocaleString("de", { maximumFractionDigits: 1 })} Jahre` }) ), Plot.ruleX([0]) ] })31:Tf45,style = html`

`32:[] 2d:{"id":"211b5055db659907","slug":null,"title":"Regierungserfahrung MPs","thumbnail":"e649c66ba2a1aaf847fd3bfb648f479b7668005e225b14f78a065f9811168960","access_level":"public","create_time":"$D2024-12-25T10:31:04.687Z","update_time":"$D2025-04-28T13:14:30.951Z","view_time":null,"first_public_time":"$D2024-12-25T10:31:04.687Z","fork":{"id":"6aa9be5543c23343","slug":null,"title":"Regierungserfahrung Ampel","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":1796,"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 MPs","cells":[{"id":0,"value":"# Regierungserfahrung MPs","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 \"Weil ist der erfahrenste Landeschef\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"mp_title = html`\n

${title}

\n Regierungserfahrung der Ministerpräsidentinnen und Ministerpräsidenten zum Amtsantritt (und bis heute als transparenter Balken im Hintergrund) in Jahren. Stand: ${stand}\n

\n `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1765,"value":"weil_title = html`\n

${title}

\n Regierungserfahrung im Ministerprädisentenamt (dunkel) und davor in anderen Regierungsämtern, etwa als Minister, Bürgermeister oder Kämmerer (hell) in Jahren. Stand: ${stand}\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":1746,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"mp_credits = md`

Grafik: Christ/RND • Quelle: eigene Recherche

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1718,"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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1611,"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":444,"value":"hochburgen = new Map([\n [\"CDU\", isDarkMode() ? \"#99AFC2\" : \"#333\"],\n [\"CSU\", 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 [\"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":"mp_data = read(\n \"https://docs.google.com/spreadsheets/d/1Pksx4Nj3FwkWiCBis0NdmMkGrZHlg7UTrYbYgkzNs6s/edit?gid=752732988#gid=752732988\",\n \"ministerpräsidenten\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1487,"value":"mp = mp_data.map((d) => ({\n ...d,\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":1756,"value":"mp_weil = d3.sort(mp, (d) => -d.Erfahrung)","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":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2e:"$2d:body"