The avatar for @rnd
RND
RedaktionsNetzwerk Deutschland
Public
Edited
Jun 11, 2024
2 forks
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data = format_seat
Insert cell
percent_party = format_seat.filter(
(d) => (d.percent_party > 0) & (d.parliament == "constitutive")
)
Insert cell
percent_party
SELECT party, party_long, country, election, percent_party, color_party, "date", status, "time" FROM percent_party
WHERE election = ${election_select}
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9
Insert cell
percent_party
SELECT party, party_long, country, election, percent_party, color_party, "date", status, "time" FROM percent_party
WHERE country = ${country_select}
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9
Insert cell
percent_party
SELECT party, party_long, country, election, percent_party, color_party, "date", status, "time" FROM percent_party
WHERE election = ${election_select}
AND country = ${country_select}
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9
Insert cell
Insert cell
stand_country = percent_selected.filter(
(d) => d.time == d3.max(percent_selected.map((d) => +d.time))
)[0]
Insert cell
stand = stand_country.date != ""
? `${stand_country.status} vom ${new Date(stand_country.date).getDate()}.${
new Date(stand_country.date).getMonth() + 1
}.${new Date(stand_country.date).getFullYear()} um ${
stand_country.time
} Uhr`
: `${stand_country.status} ${stand_country.election}`
Insert cell
import { election } from "94dfb6f60d9d6b34"
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