29:null 2a:["$","title",null,{"children":"Regierungserfahrung Kandidaten | RND | Observable"}] 2f:T891,kandidaten_charts = html`

2025 gegen Scholz

${kandidaten_function("2025")}

2021 nach Merkel

${kandidaten_function("2021")}

2017 gegen Merkel

${kandidaten_function("2018")}

2013 gegen Merkel

${kandidaten_function("2013")}

2009 gegen Merkel

${kandidaten_function("2009")}

2005 gegen Schröder

${kandidaten_function("2005")}

2002 gegen Schröder

${kandidaten_function("2002")}

1998 gegen Kohl

${kandidaten_function("1998")}

1994 gegen Kohl

${kandidaten_function("1994")}

1990 gegen Kohl

${kandidaten_function("1991")}

1987 gegen Kohl

${kandidaten_function("1987")}

1983 gegen Kohl

${kandidaten_function("1983")}

1980 gegen Schmidt

${kandidaten_function("1980")}

1976 gegen Schmidt

${kandidaten_function("1974")}

`30:Te49,kandidaten_function = (data) => Plot.plot({ width, height: new Set( kandidaten.filter((d) => d.Kandidat == data).map((d) => d.Nachname) ).size * 30 + 26, marginTop: 15, marginBottom: 16, marginLeft: 135, x: { tickFormat: (d) => `${d.toLocaleString("de", { maximumFractionDigits: "0" })}`, label: null, grid: false, axis: null, domain: [0, 25], ticks: [0, 10, 20] }, y: { axis: null, domain: kandidaten .filter((d) => d.Kandidat == data) .map((d) => d.Nachname) }, marks: [ // Text Kandidaten siegreich Plot.text(kandidaten, { filter: (d) => (d.Kandidat == data) & kanzler.includes(d.Nachname), x: 0, y: "Nachname", dx: -17, textAnchor: "end", fontWeight: 600, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.Nachname} (${d.Partei})` }), // Text Kandidaten unterlegen Plot.text(kandidaten, { filter: (d) => (d.Kandidat == data) & !kanzler.includes(d.Nachname), x: 0, y: "Nachname", dx: -17, textAnchor: "end", fontWeight: 400, fontSize: 12, fontFamily: "InterRegular", text: (d) => `${d.Nachname} (${d.Partei})` }), // Haken Plot.text(kandidaten, { filter: (d) => kanzler.includes(d.Nachname), x: 0, y: "Nachname", dx: -5, fill: "#6bb024", textAnchor: "end", text: (d) => `✔` }), // Kreuz Plot.text(kandidaten, { filter: (d) => !kanzler.includes(d.Nachname) & !kandidaten_2025.includes(d.Nachname), x: 0, y: "Nachname", dx: -5, fill: "#e84f1c", textAnchor: "end", text: (d) => `✘` }), // Balken Erfahrung bis kandidaten Plot.rectX(kandidaten, { filter: (d) => d.Kandidat == data, x: "Erfahrung_bis_Amt", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), strokeWidth: 0 }), // Balken Erfahrung kandidaten Plot.rectX(kandidaten, { filter: (d) => d.Kandidat == data, x1: "Erfahrung_bis_Amt", x2: "Erfahrung", y: "Nachname", fill: (d) => hochburgen.get(d.Partei), fillOpacity: 0.1, strokeWidth: 0 }), // Label Plot.text(kandidaten, { filter: (d) => d.Kandidat == data, 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( kandidaten, Plot.pointerY({ filter: (d) => d.Kandidat == data, 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:T11e7,style = html`

`32:[] 2d:{"id":"098115b26e9d458e","slug":null,"title":"Regierungserfahrung Kandidaten","thumbnail":"f5c4ef7e7be1d9d3a7e7e5ca01286902ebc2a18f8f8dcb7ec90d346d99461ad6","access_level":"public","create_time":"$D2024-12-29T14:24:12.840Z","update_time":"$D2025-04-28T15:03:35.881Z","view_time":null,"first_public_time":"$D2024-12-29T14:24:12.840Z","fork":{"id":"211b5055db659907","slug":null,"title":"Regierungserfahrung MPs","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":2058,"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":0,"collection":null,"type":"notebook","body":{"title":"Regierungserfahrung Kandidaten","cells":[{"id":0,"value":"# Regierungserfahrung Kandidaten","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 \"Das Vorleben der Herausforderer\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"kandidaten_title = html`\n

${title}

\n Regierungserfahrung der Kanzlerkandidatinnen und -kandidaten im Wahljahr (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":1809,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"kandidaten_credits = md`

Grafik: RND/Christ • Quelle: eigene Recherche

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":667,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1931,"value":"kanzler = [\"Scholz\", \"Merkel\", \"Schröder\", \"Schmidt\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2009,"value":"kandidaten_2025 = [\"Habeck\", \"Merz\", \"Weidel\", \"Wagenknecht\"]","pinned":true,"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":true,"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":"kandidaten_data = read(\n \"https://docs.google.com/spreadsheets/d/1Pksx4Nj3FwkWiCBis0NdmMkGrZHlg7UTrYbYgkzNs6s/edit?gid=752732988#gid=752732988\",\n \"regierung_historisch\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1487,"value":"kandidaten = kandidaten_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":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"