2b:null 2c:["$","title",null,{"children":"Finanzwende Final 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":"643b018c0cb76f420da470504b394aaeea5a4f464de1796c6b74954b21c009fd3e22ac678b40cdbccfc27b98377a8f6f508cf20eb7381a95acda737bbdff3fcf","href":"https://static.observableusercontent.com/files/643b018c0cb76f420da470504b394aaeea5a4f464de1796c6b74954b21c009fd3e22ac678b40cdbccfc27b98377a8f6f508cf20eb7381a95acda737bbdff3fcf","name":"1_MASTER-DATENSATZ-04.12.2020 - DATENSATZ.csv","type":"text/csv","lastModified":1607422113501.27,"size":193444},{"id":"147572263a59c7469a2b3ac668fc2c21c0f35a93f13e47c230c00ad7a9487a4a7d19a0d891ae100269b275b029ab85a3c01a2dee0da3db0622aeac9d15d42a54","href":"https://static.observableusercontent.com/files/147572263a59c7469a2b3ac668fc2c21c0f35a93f13e47c230c00ad7a9487a4a7d19a0d891ae100269b275b029ab85a3c01a2dee0da3db0622aeac9d15d42a54","name":"1_MASTER-DATENSATZ-04.12.2020 - DATENSATZ(1).csv","type":"text/csv","lastModified":1607442188858.311,"size":193445},{"id":"46f6d0916bfd12bfab09498336b58571d9fc773833d5e5e9d5a0b5454b29ebd68e409ec02a706b22a21d5bc05c1ed624d8b3ee23519442727796997ca1c865a0","href":"https://static.observableusercontent.com/files/46f6d0916bfd12bfab09498336b58571d9fc773833d5e5e9d5a0b5454b29ebd68e409ec02a706b22a21d5bc05c1ed624d8b3ee23519442727796997ca1c865a0","name":"netzwerk.jpg","type":"image/jpeg","lastModified":1607504259065.547,"size":186070},{"id":"a0ba6916d10f37f61eab23dd719797e34efe95cd3672cdcac2adef1928b65c54e801029b4bfa27fc0aa9ba52575ec6088b548b314b7351fe57d59f7b87c92ac9","href":"https://static.observableusercontent.com/files/a0ba6916d10f37f61eab23dd719797e34efe95cd3672cdcac2adef1928b65c54e801029b4bfa27fc0aa9ba52575ec6088b548b314b7351fe57d59f7b87c92ac9","name":"netzwerk.png","type":"image/png","lastModified":1607508780291.507,"size":47652},{"id":"fd6031f606557409d754f75c3af2424f0f29718c6b9a29f3f50ba21006540a16ed141d003746fa3a5d3af97ab749caf085149785cd00df36903d32d743c5cbac","href":"https://static.observableusercontent.com/files/fd6031f606557409d754f75c3af2424f0f29718c6b9a29f3f50ba21006540a16ed141d003746fa3a5d3af97ab749caf085149785cd00df36903d32d743c5cbac","name":"1_MASTER-DATENSATZ-04.12.2020 - URLS@1.csv","type":"text/csv","lastModified":1607475741066.379,"size":12587}] 2f:{"id":"bfb520a890aab1ea","slug":null,"title":"Finanzwende Final Embed","thumbnail":"949187f57db5791012f6faf62b24c0e4d9f4f2f231bf16c71feacc392b66b509","access_level":"public","create_time":"$D2020-12-08T10:08:33.501Z","update_time":"$D2021-06-28T10:11:00.708Z","view_time":null,"first_public_time":"$D2023-04-11T19:23:08.085Z","has_unpublished_edits":null,"fork":{"id":"c932fa79afc92264","slug":null,"title":"Finanzwende Sketches","owner":{"id":"dbaac3ef74ea8f0c","login":"cpietsch","name":"Christopher Pietsch"}},"stars":2,"starred":false,"owner":{"type":"team","id":"dbaac3ef74ea8f0c","login":"cpietsch","name":"Christopher Pietsch","avatar_url":"https://avatars-next.observableusercontent.com/5c893db7cf5c2699bda61c80eaa28fc9ebd560ec948b9bec441e6eefe34c25f8","tier":"starter_2024"},"version":2097,"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":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Finanzwende Final Embed","cells":[{"id":0,"value":"md`# Finanzwende Final Embed`","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"