Public
Edited
Feb 22
Paused
1 fork
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
seats_table = md`
<table class="table_migration">
<tbody>
<tr >
<th style="text-align: left;height: 40px;min-width: 60px;padding: 5px;"><span></span><b>Partei</b></th>
<th style="width: 55px; text-align: right;padding: 5px;">ja</th>
<th style="width: 55px; text-align: right;padding: 5px;">nein</th>
<th style="width: 55px; text-align: right;padding: 5px;">enthalten</th>
<th style="width: 70px; text-align: right;padding: 5px;">nicht<br>abgegeben</th>
</tr>
${migration_table.map(
(d) => htl.html`<tr >
<td style="text-align: left;padding: 5px;min-width: 60px"><span class="selected" style="color:${d.color};font-size: 14px; font-weight: 600;">${d.party}</span></span></td>
<td style="width: 55px; text-align: right;padding: 5px;"><b>${d.ja}</b></span></td>
<td style="width: 55px; text-align: right;padding: 5px;"><b>${d.nein}</b></span></td>
<td style="width: 55px; text-align: right;padding: 5px;"><b>${d.enthaltung}</b></span></td>
<td style="width: 70px; text-align: right;padding: 5px;"><b>${d.nicht}</b></span></td>
</tr>`
)}
</tbody>
</table>`
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
migration = d3
.csv("https://static.rndtech.de/share/rnd/migrationspolitik.csv")
.then(function (data) {
data.forEach(function (d) {
d.name = d.name;
d.vorname = d.vorname;
d.fullname = d.fullname;
d.party = d.party;
d.sum = +d.sum;
d.ja = +d.ja;
d.nein = +d.nein;
d.enthaltung = +d.enthaltung;
d.ungültig = +d.ungültig;
d.nicht = +d.nicht;
d.abstimmung = d.abstimmung
.replace("ja", "Ja")
.replace("nein", "Nein")
.replace("enthaltung", "Enthaltung")
.replace("nicht", "nicht abgegeben");
d.color = Array.from(hochburgen.keys()).includes(d.party)
? hochburgen.get(d.party)
: "#99AFC2";
});
return data;
})
Insert cell
migration
SELECT party, sum(ja) as ja, sum(nein) as nein, sum(enthaltung) as enthaltung, sum(ungültig) as ungültig, sum(nicht) as nicht, sum, color FROM migration
group by party, sum, color
order by sum desc
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more