29:null 2a:["$","title",null,{"children":"Sonntagsfrage Small Multiples | RND | Observable"}] 2f:T102a,sonntagsfrage_function = (data) => { const first = Math.round( sonntagsfrage_smooth .filter((d) => d.party == data) .map((d) => d.rolling_avg) .reverse()[0] * 10 ) / 10; const last = Math.round( sonntagsfrage_smooth .filter((d) => d.party == data) .map((d) => d.rolling_avg)[0] * 10 ) / 10; const min = d3.min( sonntagsfrage_smooth .filter((d) => d.party == data) .map((d) => d.rolling_avg) ); const max = d3.max( sonntagsfrage_smooth .filter((d) => d.party == data) .map((d) => d.rolling_avg) ); const plus = last - first > 0 ? "+" : last == first ? "±" : ""; const arrow = (last - first < 0.25) & (last - first > -0.25) ? "⮕" : (last - first >= 0.25) & (last - first < 1) ? "⬈" : last - first >= 1 ? "⬆" : (last - first > -1) & (last - first < -0.25) ? "⬊" : "⬇"; return Plot.plot({ marginBottom: 20, marginTop: 20, width: chart_width, height: 200, marginRight: 30, marginLeft: 30, color: { domain: parties, range: isDarkMode() ? colors_dark : colors }, x: { axis: null }, y: { axis: null, domain: [ first - sonntagsfrage_low_diff[0].difference * -1, first + sonntagsfrage_high_diff[0].difference ] }, marks: [ // Linie Plot.line(sonntagsfrage_smooth, { filter: (d) => d.party == data, x: "date", y: "rolling_avg", stroke: "party", strokeWidth: 2, fillOpacity: 0.9, curve: "catmull-rom" }), // Area Plot.areaY(sonntagsfrage_smooth, { filter: (d) => d.party == data, x: "date", y1: first, y2: "rolling_avg", fill: "party", fillOpacity: 0.2, curve: "catmull-rom" }), // Punkte aktueller Wert Plot.dot( sonntagsfrage_smooth, Plot.selectFirst({ filter: (d) => d.party == data, x: "date", y: "rolling_avg", fill: "party" }) ), // Punkte erster Wert Plot.dot( sonntagsfrage_smooth, Plot.selectLast({ filter: (d) => d.party == data, x: "date", y: "rolling_avg", fill: "party" }) ), // Label aktueller Wert Plot.text( sonntagsfrage_smooth, Plot.selectFirst({ filter: (d) => d.party == data, x: "date", y: "rolling_avg", strokeWidth: isDarkMode() ? 0 : 2.5, stroke: "#ffffff", fill: "party", textAnchor: "start", text: (d) => `${d.rolling_avg.toLocaleString("de", { maximumFractionDigits: 1, minimumFractionDigits: 1 })}`, dx: 5 }) ), // Label erster Wert Plot.text( sonntagsfrage_smooth, Plot.selectLast({ filter: (d) => d.party == data, x: "date", y: "rolling_avg", strokeWidth: isDarkMode() ? 0 : 2.5, stroke: "#ffffff", fill: "party", textAnchor: "end", text: (d) => `${d.rolling_avg.toLocaleString("de", { maximumFractionDigits: 1, minimumFractionDigits: 1 })}`, dx: -5 }) ), // große Zahl Plot.text( sonntagsfrage_smooth, Plot.selectLast({ filter: (d) => d.party == data, x: date_start, dx: -30, y: first + sonntagsfrage_high_diff[0].difference, text: (d) => data + ": " + plus + (last - first).toLocaleString("de", { maximumFractionDigits: 1, minimumFractionDigits: 1 }) + "% " + arrow, textAnchor: "start", fill: "party", fontSize: 16, fontWeight: 600, fontFamily: "DIN Next LT Pro" }) ) ] }); }30:T1302,style = html`

`31:[] 2d:{"id":"a887991030f8f14b","slug":null,"title":"Sonntagsfrage Small Multiples","thumbnail":"a2853269060d8c343ffafd482f050f39782bcf4b4fea1733a372a13a84aa2b78","access_level":"public","create_time":"$D2025-01-12T11:41:33.490Z","update_time":"$D2025-03-17T09:10:54.906Z","view_time":null,"first_public_time":"$D2025-01-12T11:41:33.490Z","fork":true,"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":1941,"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":"Sonntagsfrage Small Multiples","cells":[{"id":0,"value":"# Sonntagsfrage Small Multiples","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1936,"value":"title = new URLSearchParams(document.location.search).get(\"title\") ??\n \"Trends seit der Vertrauensfrage\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"title_sonntagsfrage = md`

${title}

„Wen würden Sie wählen, wenn am Sonntag Bundestagswahl wäre?“ Anteile der Parteien im Durchschnitt der Umfragen seit dem 16. Dezember 2024 in Prozent. Stand: ${stand.toLocaleString(\n \"de\",\n { day: \"numeric\", month: \"numeric\", year: \"numeric\" }\n)}

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

\n\n

\n ${sonntagsfrage_function(\"Union\")}\n

\n\n

\n ${sonntagsfrage_function(\"AfD\")}\n

\n\n

\n ${sonntagsfrage_function(\"SPD\")}\n

\n\n

\n ${sonntagsfrage_function(\"Grüne\")}\n

\n\n

\n ${sonntagsfrage_function(\"BSW\")}\n

\n\n

\n ${sonntagsfrage_function(\"FDP\")}\n

\n\n

\n ${sonntagsfrage_function(\"Linke\")}\n

\n\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"sonntagsfrage_credits = md`Grafik: Christ/RND • Durchschnitt der vergangenen zehn Umfragen. Quelle: wahlrecht.de`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1155,"value":"parties = [\n \"Union\",\n \"SPD\",\n \"Grüne\",\n \"FDP\",\n \"Linke\",\n \"AfD\",\n \"BSW\",\n \"BVB/FW\",\n \"Sonstige\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1154,"value":"colors = [\n \"#333333\",\n \"#f44647\",\n \"#6abf4a\",\n \"#ffd600\",\n \"#c72767\",\n \"#5fb1bf\",\n \"#312783\",\n \"#f28800\",\n \"#99AFC2\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":402,"value":"colors_dark = [\n \"#99AFC2\",\n \"#f44647\",\n \"#6abf4a\",\n \"#ffd600\",\n \"#c72767\",\n \"#5fb1bf\",\n \"#f79646\",\n \"#eff3f5\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"stand = new Date(d3.max(sonntagsfrage_data.map((d) => d.date)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1929,"value":"date_max = d3.max(sonntagsfrage.map((d) => d.date))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1351,"value":"date_start = roundUTCDay(new Date(2024, 11, 16))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"sonntagsfrage_data = d3.csv(\"https://static.rndtech.de/share/rnd/institut_total.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1380,"value":"sonntagsfrage = sonntagsfrage_data\n .map((d) => ({\n date: new Date(d.date),\n rolling_avg: +d.rolling_avg,\n party: d.party\n .replace(\"union\", \"Union\")\n .replace(\"spd\", \"SPD\")\n .replace(\"grüne\", \"Grüne\")\n .replace(\"fdp\", \"FDP\")\n .replace(\"linke\", \"Linke\")\n .replace(\"afd\", \"AfD\")\n .replace(\"bsw\", \"BSW\")\n .replace(\"bvb\", \"BVB/FW\")\n .replace(\"sonstige\", \"Sonstige\")\n }))\n .filter(\n (d) =>\n (d.party != \"\") &\n (d.party != \"Sonstige\") &\n (d.rolling_avg > 0) &\n (d.date >= date_start)\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1388,"value":"WITH sonntagsfrage AS (\n SELECT\n *,\n ROW_NUMBER() OVER (PARTITION BY date, party) AS rn\n FROM sonntagsfrage\n)\nSELECT date, party, rolling_avg\nFROM sonntagsfrage\nWHERE rn = 1\nORDER BY date desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sonntagsfrage_smooth","database":"var:sonntagsfrage"},{"id":1527,"value":"WITH sonntagsfrage_high AS (\n SELECT \n date,\n party,\n rolling_avg,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY rolling_avg DESC) AS highest_rank,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY date) AS first_rank,\n FROM sonntagsfrage_smooth\n)\nSELECT party, rolling_avg, highest_rank\nFROM sonntagsfrage_high\nWHERE highest_rank = 1 OR first_rank = 1","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sonntagsfrage_high","database":"var:sonntagsfrage_smooth"},{"id":1767,"value":"WITH sonntagsfrage_high_diff AS (\n SELECT \n party, \n rolling_avg,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY highest_rank) AS row_num\n FROM sonntagsfrage_high\n)\nSELECT \n a.party,\n b.rolling_avg - a.rolling_avg AS difference\nFROM sonntagsfrage_high_diff a\nJOIN sonntagsfrage_high_diff b\n ON a.party = b.party\n AND a.row_num = 2\n AND b.row_num = 1\nORDER BY difference desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sonntagsfrage_high_diff","database":"var:sonntagsfrage_high"},{"id":1798,"value":"WITH sonntagsfrage_high AS (\n SELECT \n date,\n party,\n rolling_avg,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY rolling_avg) AS lowest_rank,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY date) AS first_rank,\n FROM sonntagsfrage_smooth\n)\nSELECT party, rolling_avg, lowest_rank\nFROM sonntagsfrage_high\nWHERE lowest_rank = 1 OR first_rank = 1","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sonntagsfrage_low","database":"var:sonntagsfrage_smooth"},{"id":1842,"value":"WITH sonntagsfrage_low_diff AS (\n SELECT \n party, \n rolling_avg,\n ROW_NUMBER() OVER (PARTITION BY party ORDER BY lowest_rank) AS row_num\n FROM sonntagsfrage_low\n)\nSELECT \n a.party,\n b.rolling_avg - a.rolling_avg AS difference\nFROM sonntagsfrage_low_diff a\nJOIN sonntagsfrage_low_diff b\n ON a.party = b.party\n AND a.row_num = 2\n AND b.row_num = 1\nORDER BY difference","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sonntagsfrage_low_diff","database":"var:sonntagsfrage_low"},{"id":233,"value":"bundestagswahl = sonntagsfrage.filter((d) => d.institut == \"bundestagswahl\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1360,"value":"function roundUTCDay(d) {\n return new Date(\n Date.UTC(\n d.getUTCFullYear(),\n d.getUTCMonth(),\n d.getUTCDate() + (d.getUTCHours() < 12 ? 0 : 1)\n )\n );\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"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":1860,"value":"chart_width = window.innerWidth / 2 - 20","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2e:"$2d:body"