2b:null 2c:["$","title",null,{"children":"Visual exploration of the activities of the german financial lobby (Embed) | Christopher Pietsch | Observable"}] 31:T476,width = Generators.observe(function (change) { const selectorDeploy = document.querySelector(".document-content__content") const selectorObservable = document.querySelector(".observablehq") console.log("selector", selectorDeploy, selectorObservable) let value = 770 if(selectorDeploy) { value = selectorDeploy.getBoundingClientRect().width } else if(selectorObservable) { value = selectorObservable.getBoundingClientRect().width // or document.body.clientWidth } change(value) function resized() { console.log("selector2", selectorDeploy, selectorObservable) let nvalue if(selectorDeploy) { nvalue = selectorDeploy.getBoundingClientRect().width } else if(selectorObservable) { nvalue = selectorObservable.getBoundingClientRect().width } console.log(nvalue, value) if (nvalue && nvalue !== value) { console.log("change", nvalue, value) change(value = nvalue) }; } window.addEventListener("resize", resized); return function () { window.removeEventListener("resize", resized); }; });32:T79a,viewof source = { const form = html`` const container = html`

Einzelne Themenbereiche und die aktivsten Lobbyisten

In der folgenden Graphik lässt sich der Datensatz komplett erkunden. Die Kreise stehen jeweils für eine Organisation. Je weiter rechts sie sich befindet, desto öfter hat sie sich an einem Referentenentwurf bzw. Ausschuss beteiligt.

Der Balken links von den Entwurfs-/Ausschussnamen zeigt die Anzahl der jeweils Beteiligten. Je größer der Balken, desto mehr Aufmerksamkeit hat ein Thema somit gehabt. Besonders viele „Eingaben“ hatten beispielsweise die Themen Geldwäsche und Zahlungsdienste bei den Referentenentwürfen.

Klickt man per Maus auf einen der Kreise, erscheint der Name der Organisation und ihre Beteiligung wird hervorgehoben. So kann zum Beispiel die aktivste Lobbyorganisation bei Referentenentwürfen, der GDV-Versicherungsverband, angewählt werden. Der GDV steht als aktivste Organisation ganz rechts.

Durch Klick und Mouseover auf einen Entwurfs-/Ausschussnahmen werden alle Organisationen, die an ihm beteiligt waren, dargestellt. Per Schalter kann zwischen der Ansicht für Referentenentwürfe und Ausschüsse gewechselt werden.

${form}` const sources = [drafts, committees] form.addEventListener("input", () => { const value = formValue(form) const source = sources[+value.source] container.value = source }); form.addEventListener("change", () => container.dispatchEvent(new CustomEvent("input"))); container.value = sources[0] return container }33:T179a,graph = { let firstRun = true if(600 > width){ const imageUrl = await FileAttachment("netzwerk.png").url() return html`

Bitte betrachten Sie das interaktive Netzwerk auf einem größeren Bildschirm

` } const barScale = d3.scaleLinear() .domain(d3.extent(source, d => d.lobbies.length)) .range([10,30]) const nodes1 = nodes(source)//.map(d => ({...d})) const links1 = links(source)//.map(d => ({...d})) const simulation = d3.forceSimulation(nodes1) // .velocityDecay(0.3) //.alphaTarget(0.01) .force("link", d3.forceLink(links1).id(d => d.id).strength(0.2) // .strength(d => { // return (50 - d.target.data.lobbies.length) / 1000 // }) ) //.force("collide", d3.forceCollide(d => d.type == "l" ? 5 : 13)) .force("x", d3.forceX(0).strength(0.6)) .force("y", d3.forceY(height*0.5).strength(0.07)) //.force("radial", d3.forceRadial(200, width / 2, height / 2) //.strength(d => d.type == "l" ? 0.2 : 0.1) //.radius(d => d.type == "l" ? 10 : 500) //) .force("charge", d3.forceManyBody() .distanceMin(0.2) //.strength(d => d.type == "l" ? -40 : -400) ) .stop() //.force("center", d3.forceCenter(width / 2, height / 2)); function run(){ simulation.restart() console.log("run", firstRun) let s = 0 //for (var i = 0, n = Math.ceil(Math.log(simulation.alphaMin()) / Math.log(1 - simulation.alphaDecay())); i < n; ++i) { for(var i=0; i < 200; i++){ //postMessage({type: "tick", progress: i}); simulation.tick(); s++ } console.log(s) } console.time("calc") run() const sort = nodes1 .filter(d => d.type == "c") .sort((a,b) => (a.y - b.y)) sort.forEach((d,i) => { d.fy = 30 + (i / sort.length) * (height-60) }) //simulation.restart().alpha(1) simulation.alphaTarget(0.3); run() simulation.stop() console.timeEnd("calc") const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]) .style("font-family","Barlow Condensed,Consolas,monospace") .on('click', reset); /* svg.append("text") .attr("x", 10) .attr("y", 60) .text(width) */ const link = svg.append("g") .selectAll("path") .data(links1) .join("path") .attr("stroke", "#999") .attr("fill", "none") .attr("stroke-opacity", 0.1) .style("mix-blend-mode", "multiply") let lastHighlight = null function highlight(d){ if(lastHighlight == d) return reset(); lastHighlight = d; let nodesToHighlight = links1 .map(function (e) { return e.source.id == d.id ? e.target.id : e.target.id == d.id ? e.source.id : 0}) .filter(function (d) { return d; }) nodesToHighlight.push(d.id) node.style("opacity", d => nodesToHighlight.indexOf(d.id) >= 0 ? 1: 0.1) node.filter(d => d.type == "l") .select("circle") .attr("r", d => nodesToHighlight.indexOf(d.id) >= 0 ? 7: 5) link.attr("stroke-opacity", l => l.source === d || l.target === d ? 0.4 : 0); } function reset(){ lastHighlight = null node.style("opacity", 1) node.filter(d => d.type == "l").select("circle").attr("r", 5) link.attr("stroke-opacity", 0.1) } const node = svg.append("g") .attr("stroke", "#fff") .attr("stroke-width", 1.5) .selectAll("g") .data(nodes1) .join("g") .on('click', (e,d) => { e.preventDefault() e.stopPropagation() highlight(d); return false }) //.on('mouseover', (e,d) => highlight(d)) //.on('mouseout', reset); node .filter(d => d.type == "l") .append("circle") .attr("cursor", "pointer") .attr("r", 5) .attr("fill", d => sectorsColors[d.sector]) .append("title") .text(d => d.name); const ls = node .filter(d => d.type != "l") .append("g") .attr("cursor", "pointer") .attr("transform", d => `translate(10,0)`) ls.append("rect") .attr("width", d => barScale(d.data.lobbies.length)) .attr("x", d => -5 -barScale(d.data.lobbies.length)) .attr("height", 5) .attr("y", -2) .attr("fill", "rgb(100,100,100)") ls.append("text") .attr("x", 0) .attr("font-size", "small") .attr("y", 5) .attr("stroke", "none") .append("tspan") //.text(d => d.name.replace(/(.{40})..+/, "$1…")) .text(d => { const num = parseInt(paddingLeft / 5) if (d.name.length <= num) { return d.name } return d.name.slice(0, num) + "…" }) .append("title") .text(d => d.name); //.attr("textLength", 10) //.attr("lengthAdjust", "spacingAndGlyphs") const tick = () => { link .attr("d", d => ` M${d.target.x},${d.target.y} C${d.target.x + (d.source.x-d.target.x)/2},${d.target.y} ${d.source.x},${d.source.y} ${d.source.x},${d.source.y} `); //C${d.source.x + (d.target.x-d.source.x)/2},${d.target.y} node .attr("transform", d => `translate(${d.x} ${d.y})`) } tick() //simulation.on("tick", tick); /* simulation.on("end", () => { console.log("end", firstRun) if(firstRun){ firstRun = false const sort = nodes1 .filter(d => d.type == "c") .sort((a,b) => (a.y - b.y)) sort.forEach((d,i) => { d.fy = 30 + (i / sort.length) * (height-60) }) //simulation.restart().alpha(1) simulation.alphaTarget(0.3); run() tick() simulation.stop() } }) */ //tick() invalidation.then(() => simulation.stop()); return html`${svg.node()}
${swatches({ swatchSize:20, color: d3.scaleOrdinal(Object.keys(sectorsColors), Object.values(sectorsColors)) })}
`; }34:T546,viewof treemapSelection = { const form = html`

Anzahl und Budgets der Lobbyorganisationen

Die erste Grafik zeigt die Anzahl aller Organisationen, denen zwischen 2014 und 2020 Lobbyaktivitäten im Bereich der Finanzmarktpolitik nachgewiesen werden konnten. Diese Aktivitäten beinhalten Kommentierungen von Referentenentwürfen, Stellungnahmen in Ausschüssen, Mitgliedschaften in Ministeriums-Beiräten sowie direkte Treffen mit Abgeordneten.

In einer zweiten Graphik sind für die Organisationen der Finanzlobby die Budgets darstellbar und nach Subsektoren (z.B. Versicherungen, Fonds, Banken) eingeteilt.

Farblich sind die Graphiken nach den vier Hauptsektoren markiert: Finanzlobby, Behörden, Zivilgesellschaft und Sonstige.

Zeige die Größenverhältnisse nach
Anzahl der Organisationen Budgets der Finanzlobby

` form.addEventListener("input", () => { const value = formValue(form) treemapChart.draw(value.source) }); return form }35:Tc3c,treemapChart = { const sources = [sectors,sectorsBudgets].map(treemap) const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]) .style("font-family","Barlow Condensed,Consolas,monospace") //.style("font", "10px sans-serif") function draw(idx){ const root = sources[idx] const fontScale = d3.scaleLinear(d3.extent(root.leaves(), d => d.value),[10,40]) const leaf = svg.selectAll("g") .data(root.leaves(), d => d.data[0]) const exit = leaf.exit().remove() const enter = leaf.enter().append("g") .attr("transform", d => `translate(${d.x0},${d.y0})`) enter.append("title") .text(d => `${d.ancestors().reverse().map(d => d.data[0]).join("/")}\n${format(d.value)+ (idx ? "€ Budget (geschätzt)":" Organisationen")}`); enter.append("rect") .attr("id", d => (d.leafUid = DOM.uid("leaf")).id) //.attr("fill-opacity", 0.6) .attr("width", d => d.x1 - d.x0) .attr("height", d => d.y1 - d.y0) .attr("fill", d => { while (d.depth > 1) d = d.parent; return sectorsColors[d.data[0]]; }) .style("opacity",0) .transition() .delay(1000) .duration(1000) .style("opacity",1) enter.append("clipPath") .attr("id", d => (d.clipUid = DOM.uid("clip")).id) .append("use") .attr("xlink:href", d => d.leafUid.href); enter.append("text") .attr("clip-path", d => d.clipUid) .attr("font-size", d => (console.log(fontScale(d.value)), (fontScale(d.value)) + "px")) .attr("fill", d => (d3.lab(sectorsColors[d.parent.data[0]]).l < 50 ? "white" : "black")) .selectAll("tspan") .data(d => d.data[0].split(/(?=[A-Z][a-z])|\s+/g).concat(format(d.value))) .join("tspan") .attr("x", 3) .attr("y", (d, i, nodes) => `${(i === nodes.length - 1) * 0.3 + 1.1 + i * 0.9}em`) .attr("fill-opacity", (d, i, nodes) => i === nodes.length - 1 ? 0.7 : null) .text(d => d) .style("opacity",0) .transition() .delay(1200) .duration(1000) .style("opacity",1) const update = leaf.transition().duration(1000) update.attr("transform", d => `translate(${d.x0},${d.y0})`) update.select("rect") .attr("width", d => d.x1 - d.x0) .attr("height", d => d.y1 - d.y0); update.select("text") .attr("font-size", d => (console.log(fontScale(d.value)), (fontScale(d.value)) + "px")) .select("tspan:last-child") .tween("text", function(d) { const i = d3.interpolate(parseNumberTree(this.textContent), d.value); return function(t) { this.textContent = format(i(t))+ (idx ? "€":""); }; }); leaf.select("title").text(d => `${d.ancestors().reverse().map(d => d.data[0]).join("/")}\n${format(d.value)+ (idx ? "€ Budget (geschätzt)":" Organisationen")}`); } draw(0) return Object.assign(html`${svg.node()}
${swatches({ swatchSize:20, color: d3.scaleOrdinal(Object.keys(sectorsColors), Object.values(sectorsColors)) })}
`, { draw: (idx) => draw(+idx) }); }36:T5cd,chartStacked = (stack) => { const margin = ({top: 0, right: 0, bottom: 0, left: 0}) const x = d3.scaleLinear([0, 1], [margin.left, width - margin.right]) const height = 33 const formatPercent = x.tickFormat(null, "%") const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]) .style("display", "block"); svg.append("g") .attr("stroke", "white") .selectAll("rect") .data(stack) .join("rect") .attr("fill", d => sectorsColors[d.name]) .attr("x", d => x(d.startValue)) .attr("y", margin.top) .attr("width", d => x(d.endValue) - x(d.startValue)) .attr("height", height - margin.top - margin.bottom) .append("title") .text(d => `${d.name} ${formatPercent(d.value)}`); svg.append("g") .attr("font-family", "sans-serif") .attr("font-size", 12) .selectAll("text") .data(stack.filter(d => x(d.endValue) - x(d.startValue) > 100)) .join("text") .attr("fill", d => d3.lab(sectorsColors[d.name]).l < 50 ? "white" : "black") .attr("transform", d => `translate(${x(d.startValue) + 6}, 6)`) .call(text => text.append("tspan") .attr("y", "0.7em") .attr("font-weight", "bold") .text(d => d.name)) .call(text => text.append("tspan") .attr("x", 0) .attr("y", "1.7em") .attr("fill-opacity", 0.7) //.text(d => d.total)) .text(d => formatPercent(d.value))) return svg.node(); }37:T922,viewof sorter = { const form = html`

Sortiere nach

Anzahl der Kommentare / Teilnahmen Anteil der Finanzlobby

Zeige

Top 5 Alle Referentenentwürfe / Ausschüsse

` const container = html`
Die Aktivitäten der Finanzlobby bei einzelnen Themen (2014 - 2020)

In den folgenden zwei Diagrammen sind die Kommentierungen sogenannter Referentenentwürfe und die Stellungnahmen bei Ausschüssen dargestellt. Aufgenommen wurden 33 Referentenentwürfe für Finanzpolitik zwischen 2014 und 2020 sowie 34 Sitzungen des Finanzauschusses des deutschen Bundestages.

Die Breite der farblichen Abschnitte gibt das Verhältnis nach Interessengruppe wieder.

Per Schalter lässt sich auch eine Auflistung der Top 5 Ausschüsse/Referentenentwürfe zeigen, in der die Finanzlobby am dominantesten war. So lassen sich beispielsweise Themenbereiche darstellen, bei denen die Industrielobby komplett unter sich war.

Per Klick auf die Zahl neben dem Referentenentwurf/Ausschuss wird der Link zu dem entsprechenden Dokument beim Bundestag oder Finanzministerium geöffnet.

${form}` const sorter = [(a,b) => b.lobbies.length - a.lobbies.length, (a,b) => b.stack[0].value - a.stack[0].value] form.addEventListener("input", () => { const value = formValue(form) //console.log(value) const sort = sorter[+value.sort] const top = +value.top container.value = {sort, top} //console.log(sort) //treemapChart.draw(value.source) }); form.addEventListener("change", () => container.dispatchEvent(new CustomEvent("input"))); container.value = {sort: sorter[0], top: 5} //.sort(sorter) //.filter((d,i) => i < top) return container }38:[{"id":"147572263a59c7469a2b3ac668fc2c21c0f35a93f13e47c230c00ad7a9487a4a7d19a0d891ae100269b275b029ab85a3c01a2dee0da3db0622aeac9d15d42a54","href":"https://static.observableusercontent.com/files/147572263a59c7469a2b3ac668fc2c21c0f35a93f13e47c230c00ad7a9487a4a7d19a0d891ae100269b275b029ab85a3c01a2dee0da3db0622aeac9d15d42a54","name":"1_MASTER-DATENSATZ-04.12.2020 - DATENSATZ(1).csv","type":"text/csv","lastModified":1667396976756.919,"size":193445},{"id":"fd6031f606557409d754f75c3af2424f0f29718c6b9a29f3f50ba21006540a16ed141d003746fa3a5d3af97ab749caf085149785cd00df36903d32d743c5cbac","href":"https://static.observableusercontent.com/files/fd6031f606557409d754f75c3af2424f0f29718c6b9a29f3f50ba21006540a16ed141d003746fa3a5d3af97ab749caf085149785cd00df36903d32d743c5cbac","name":"1_MASTER-DATENSATZ-04.12.2020 - URLS@1.csv","type":"text/csv","lastModified":1667396976756.919,"size":12587},{"id":"a0ba6916d10f37f61eab23dd719797e34efe95cd3672cdcac2adef1928b65c54e801029b4bfa27fc0aa9ba52575ec6088b548b314b7351fe57d59f7b87c92ac9","href":"https://static.observableusercontent.com/files/a0ba6916d10f37f61eab23dd719797e34efe95cd3672cdcac2adef1928b65c54e801029b4bfa27fc0aa9ba52575ec6088b548b314b7351fe57d59f7b87c92ac9","name":"netzwerk.png","type":"image/png","lastModified":1667396976756.919,"size":47652}] 2f:{"id":"373874052ceae7da","slug":null,"title":"Visual exploration of the activities of the german financial lobby (Embed)","thumbnail":"4329ea6a789f163270a649f6602a52acc8f50231bda7fda970752da4e18afef8","access_level":"public","create_time":"$D2022-11-02T13:49:36.756Z","update_time":"$D2022-11-02T13:49:36.756Z","view_time":null,"first_public_time":"$D2023-04-11T19:22:51.476Z","has_unpublished_edits":null,"fork":{"id":"bfb520a890aab1ea","slug":null,"title":"Finanzwende Final Embed","owner":{"id":"dbaac3ef74ea8f0c","login":"cpietsch","name":"Christopher Pietsch"}},"stars":0,"starred":false,"owner":{"type":"team","id":"dbaac3ef74ea8f0c","login":"cpietsch","name":"Christopher Pietsch","avatar_url":"https://avatars-next.observableusercontent.com/5c893db7cf5c2699bda61c80eaa28fc9ebd560ec948b9bec441e6eefe34c25f8","tier":"starter_2024"},"version":2102,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"42a00b3d53c425cb","login":"cpietsch","name":"Christopher Pietsch","avatar_url":"https://avatars-next.observableusercontent.com/5c893db7cf5c2699bda61c80eaa28fc9ebd560ec948b9bec441e6eefe34c25f8","tier":null}],"members":[{"type":"individual","id":"42a00b3d53c425cb","login":"cpietsch","name":"Christopher Pietsch","avatar_url":"https://avatars-next.observableusercontent.com/5c893db7cf5c2699bda61c80eaa28fc9ebd560ec948b9bec441e6eefe34c25f8","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Visual exploration of the activities of the german financial lobby (Embed)","cells":[{"id":0,"value":"md`# Visual exploration of the activities of the german financial lobby (Embed)\n\nWith the \"Uneven Terrain\" study, http://finanzwende.de measured the size and influence of the German financial lobby for the first time. The most important background to the study can be found here, the full report here. We can show individually for 34 meetings of the Bundestag Finance Committee (2014-2020) and for 33 draft bills related to the financial market (2014-2020) which associations and companies made comments and have submitted comments. We've seen more than 500 comments on draft bills and more than 500 invitations to committee meetings. For the first time, a cartography of the German financial lobby can be presented.\n\nHow to explore:\n\nthe four main interest groups and their subdivisions\nthe budgets of individual parts of the financial lobby\n33 individual draft papers and their comments\n34 individual meetings of the Finance Committee of the German Bundestag and the statements on them`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2094,"value":"Final deployment on https://www.finanzwende.de/themen/finanzlobbyismus/visuelle-erkundung-der-aktivitaeten-der-finanzlobby/","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"viewof dataCsv = csvInput({\n initialUrl: await FileAttachment(\"1_MASTER-DATENSATZ-04.12.2020 - DATENSATZ(1).csv\").url(),\n label: \"csv\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1931,"value":"viewof urlsCsv = csvInput({\n initialUrl: await FileAttachment(\"1_MASTER-DATENSATZ-04.12.2020 - URLS@1.csv\").url(),\n label: \"csv\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1944,"value":"urlsCsv","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1935,"value":"urls = new Map(urlsCsv.map(d => [dataCsv.columns.indexOf(d.id), d.url]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1052,"value":"dataCsv","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"dataCsv.columns","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"columns = dataCsv.columns.map(formatKey)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"formatKey = d => d.replace(/\\r/g,\"\").replace(/\\n/g,\" \").replace(/- /g,\"\").replace(/\\\"/g,\"\").normalize()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":682,"value":"data = dataCsv\n .map(d => {\n const values = Object.values(d)\n values[11] = parseNumber(values[11])\n return values\n })\n .filter(d => d[1] != \"\")\n //.map(d => [...d])\n //.map(d => (d[11] = parseNumber(d[11]), d))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"parseNumber = d => parseInt((\"\"+d).replace(/,/g, \"\").split(\".\")[0]) || undefined","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1065,"value":"parseNumber(\"61,876,000.00\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":734,"value":"dataLookup = new Map(data.map(d => [d[1], d]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"md`# Ausschüsse und Entwürfe`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"committees = columns\n .map((d,i) => [i,d])\n .filter((d,i) => i >=20 && i <= 53)\n .map(d => {\n const idx = d[0]\n const url = urls.get(idx)\n const date = d[1].substring(0,10)\n const name = d[1].substring(11)\n\n const lobbies = data.filter(l => l[idx] === \"1\").map(d => d[1])\n return { name, idx, lobbies, date, url }\n })\n .sort((a,b) => b.lobbies.length - a.lobbies.length)\n //.filter((d,i) => i < 10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"drafts = columns\n .map((d,i) => [i,d])\n .filter((d,i) => i >=57 && i <= 88)\n .map(d => {\n const idx = d[0]\n const url = urls.get(idx)\n const date = d[1].substring(0,10)\n const name = d[1].substring(11)\n const lobbies = data.filter(l => l[idx] === \"1\").map(d => d[1])\n\n return { url, idx, lobbies, date, name }\n })\n .sort((a,b) => b.lobbies.length - a.lobbies.length)\n //.sort(d => d.date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"nodes = data => {\n const l = [...new Set(data.map(d => d.lobbies).flat())]\n .map(d => {\n const data = dataLookup.get(d)\n \n return {\n id: \"l\" + d,\n type: \"l\",\n data,\n name: data[2],\n sector: data[6]\n }\n })\n const c = data.map(d => ({\n id: \"c\" + d.idx,\n fx: width - paddingLeft,\n data: d,\n type: \"c\",\n name: d.name\n }))\n return [...c, ...l]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"links = data => {\n const links = []\n for(const c of data){\n for(const l of c.lobbies){\n links.push({ target: \"c\"+c.idx, source: \"l\"+l })\n }\n }\n \n return links\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1012,"value":"md`## Netzwerk`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2084,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1601,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1523,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1540,"value":"md`# Verhältnisse`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1556,"value":"draftsStacked = drafts \n .map(d => {\n /*const balanceMap = [...d3.rollup(d.lobbies,v => v.length, d => dataLookup.get(d)[6])]\n .sort((a,b) => sectorsColorsKeys.indexOf(a[0]) - sectorsColorsKeys.indexOf(b[0]))*/\n const balanceMap = [...new Map([...sectorsColorsMap, ...d3.rollup(d.lobbies,v => v.length, d => dataLookup.get(d)[6])])]\n const total = d3.sum(balanceMap, d => d[1]);\n let value = 0;\n const stack = balanceMap.map(d => ({\n name: d[0],\n total: d[1],\n value: d[1] / total,\n startValue: value / total,\n endValue: (value += d[1]) / total\n }));\n \n return {\n ...d, balanceMap, stack\n }\n })\n .sort(sorter.sort)\n .filter((d,i) => i < sorter.top)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1558,"value":"committeesStacked = committees \n //.filter((d,i) => i < 10)\n .map(d => {\n //const balance = d3.rollup(d.lobbies,v => v.length, d => dataLookup.get(d)[6])\n const balanceMap = [...new Map([...sectorsColorsMap, ...d3.rollup(d.lobbies,v => v.length, d => dataLookup.get(d)[6])])]\n //.sort((a,b) => sectorsColorsKeys.indexOf(a[0]) - sectorsColorsKeys.indexOf(b[0]))\n const total = d3.sum(balanceMap, d => d[1]);\n let value = 0;\n const stack = balanceMap.map(d => ({\n name: d[0],\n total: d[1],\n value: d[1] / total,\n startValue: value / total,\n endValue: (value += d[1]) / total\n }));\n \n return {\n ...d, balanceMap, stack\n }\n })\n .sort(sorter.sort)\n .filter((d,i) => i < sorter.top)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1969,"value":"\nsectorsColorsMap = new Map(Object.entries(sectorsColors).map(d => (d[1]=0,d)));\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1562,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1813,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1549,"value":"view1 = html`\n ${draftsStacked.map(d => html`\n
\n
${d.name} ${d.date} (${d.lobbies.length} Kommentare)
\n ${chartStacked(d.stack)}\n
\n `)}\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1551,"value":"view2 = html`\n
Ausschüsse
\n
\n

\n ${committeesStacked.map(d => html`\n
\n
${d.name} ${d.date} (${d.lobbies.length} Teilnahmen)
\n ${chartStacked(d.stack)}\n
\n `)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"md`# Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"function csvInput({initialUrl, init, accept = \".csv\", label = \"\"}) {\n return fileInput({\n initialUrl,\n accept,\n load(url) {\n return fetch(url, init).then(function(response) {\n return response.ok ? response.text() : Promise.reject(response.status);\n }).then(function(text) {\n return d3.csvParse(text\n //,d => Object.values(d)\n //d => d3.zip(Object.keys(d).map(formatKey), Object.values(d))\n );\n });\n },\n label\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"import {fileInput} from \"@mbostock/file-input\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":805,"value":"import {swatches} from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1625,"value":"import {form, formValue} from \"@mbostock/form-input\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1"}} 30:"$2f:body"