Ansgar Wolsing

@ansgarw

Powerpoint by day, #ggplot2 by night. Here for dataviz and #rstats content and rants about football. 📊⚽️ Based in Cologne, Germany.

1400 Siguiendo4062 Seguidores2595 Publicaciones

YouTube Bluesky

¿Es tu perfil?Reclámalo y ansgarw.dirty.social es tuyo.Reclamar perfil

Ansgar Wolsing@ansgarw· 23d

Twitter down for the World Cup Final?

Downdetector chart for Twitter. It shows a massive spike of reported problems around 12 AM CEST.

Ansgar Wolsing@ansgarw· 23d

Rodri and Trump - both 6' 3''

Trump and Rodri at the World Cup ceremony. Rodri is clearly taller than Trump.

Ansgar Wolsing@ansgarw· Jun 26

Fight Club, FIFA edition

Edward Norton and Brad Pitt attending the World Cup match USA against Turkey

Ansgar Wolsing@ansgarw· Jun 7

Ich möchte die Stadt nicht aus der Verantwortung lassen, aber das macht leider Excel automatisch. Warum jemand die Farben ändert (Grün, weil Grün bekanntlich die Farbe der Neonazis ist), aber das so lässt...?

Screenshot Excel. 2x2 Tabelle mit den Werten der Kandidaten. Empfohlenes Diagramm: Balkendiagramm, y-Achse bei 4200 abgeschnitten

Ansgar Wolsing@ansgarw· May 30

Arsenal completed so few passes I had to make a chart about it. Passes after 90' #UCLFinal

A dot plot showing the number of completed passes for the team which won and lost the Champions League finals since 2013, excluding 2014 and 2016. Arsenal completed 146 passes after 90 minutes in 2026, PSG completed 589. Arsenal has completed the fewest passes. The next team (Liverpool, won, 2019) completed 174.

Ansgar Wolsing@ansgarw· May 30

Dieser Moment, in der die innerparteiliche Demokratie kickt. #FDP

Bild aus dem Livestream vom FDP-Parteitag 2026. Kubicki und Dürr sitzen und gucken betreten.

Ansgar Wolsing@ansgarw· May 16

Ich wusste doch, dass ich vor einer Weil etwas dazu gemacht hatte:

Ein zu 100 % gestapeltes Balkendiagramm, das anzeigt, wer die Relegation für die 1. und 2. Bundesliga gewonnen hat.
1. Bundesliga: 12 Mal Erstligist erfolgreich, 3x Zweitligist
2. Bundesliga: 4x Zweiligist, 11x Driitligist
(Zeitraum 2009 bis 2023)

Ansgar Wolsing@ansgarw· May 16

The majority of countries in the world has seen a drop in the share of adolescents since 1970. This does not apply to many countries in sub-Saharan Africa and a few in Asia where the share has increased by up to 5 %-points. #30DayChartChallenge | Day 18 - Data Day: Unicef #dataviz

A scatterplot chart titled comparing the percentage of 10-to-19-year-olds in a population. The x axis shows the share in 1970, the x axis shows the share in 2025. Diagonal lines indicate the change in percentage points.

Most global nations sit below the diagonal 0-change line, showing a widespread decline in youth share since 1970.

The primary exception is Africa South of the Sahara, which clusters at the top of the chart.

Ansgar Wolsing@ansgarw· May 14

It does! github.com/AtherEnergy/...

A calendar heatmap, screenshot from the linked page

Ansgar Wolsing@ansgarw· May 14

Heute ist Vatertag - und mit großer Wahrscheinlichkeit der Tag mit den meisten Verkehrsunfällen unter Alkoholeinfluss in diesem Jahr. Daten: Statistisches Bundesamt Tool: R und #ggplot2 Also: Don’t drink and drive - außer im Bollerwagen.

Ein Diagramm, das die tägliche Anzahl der Verkehrsunfälle unter Alkoholeinfluss mit Personenschäden in Deutschland 2020-2024 in Kacheln, die nach Wochentag (senkrecht) und Kalenderwoche (waagerecht) angeordnet sind, anzeigt. Die Färbung der Kacheln gibt die Anzahl an. Hellorange = geringe Anzahl, dunkelrot = hohe Anzahl

Für jedes Jahr gibt es eine separate Darstellung.

In allen Jahren (außer 2021) erscheint ein Donnerstag im Mai mit der dunkelsten Farbe: Christi Himmelfahrt. Außerdem fällt Neujahr in jedem Jahr sowie der 1. Mai in den Jahren 2023 und 2024 auf.

Ansgar Wolsing@ansgarw· May 10

Und wichtig ist auch, dass es kein "repräsentativ" gibt, wenn irgendwann 60, 70 oder 80 % der Wahlbezirke ausgezählt sind. Hier ein Beispiel von der Europawahl in Sachsen 2024, als 399 von 418 Gemeinden ausgezählt waren vs. dem vorläufigen Endergebnis:

3 Grafiken zur Europawahl 2024 für Sachsen:
1.) Karte zeigt, dass 399 von 418 Gemeinden ausgezählt sind.
2.) Diagramm: auf Twitter geteilter Zwischenstand zeigt AfD bei 43,1%
3.) Diagramm: Vorläufiges Endergebnis: AfD bei 31,8%.

Ansgar Wolsing@ansgarw· May 9

Da ist man einmal für Bayern... 🤷‍♂️

Kicker Liveticker: Kane verschießt Elfmeter gegen VW

Ansgar Wolsing@ansgarw· May 9

Food web of Antarctic marine ecosystems A simplified network revealing the "who eats whom" of the Southern Ocean. #30DayChartChallenge | Day 13 - Ecosystems #dataviz #ggplot2

A directed graph showing the food web of the Antarctic marine ecosystems. Species/genera/classes are connected with each other to show predator-prey relationships.

Ansgar Wolsing@ansgarw· May 6

Friedrich Merz muss deutlich schlechtere Popularitätswerte als seine beiden Amtsvorgänger ertragen Merz ist nun seit einem Jahr Bundeskanzler. Wie steht er im Vergleich zu Merkel und Scholz da?

Ein Liniendiagramm mit 3 Linien, das die Popularitätswerte von Merz, Merkel und Scholz im ersten Jahr ihrer Amtszeit anzeigt.
Merz startet bei -0,3 und landet nach einem Jahr bei -1,1.
Merkel: +1,6 zu +1,3
Scholz: +2,1 zu +0,6

Ansgar Wolsing@ansgarw· May 4

The median age of astronauts increased by 11 years between the 1960s and 2010s. This reflects a shift from the era of young military test pilots to modern crews of seasoned commanders and specialized scientists. #30DayChartChallenge | Day 25 - Space #ggplot2

A jitter plot with the age of astronauts in the year of their missions, grouped by decade. The x axis shows decades from the 1960s to 2010s. The y axis shows age from 20 to 80. The age of each astronaut is represented by a dot. A bright yellow dot marks the median (central point) of the age distribution in each decade:
- 1960s: 36 years
- 1970s: 40 years
- 1980s: 41 years
- 1990s: 41.5 years
- 2000s: 45 years
- 2010s: 47 years

Ansgar Wolsing@ansgarw· May 3

Today is World Press Freedom Day, observed to raise awareness of the importance of freedom of the press. The conditions for journalists vary considerably between OECD countries Here’s an update on the chart I shared on day 6 of the #30DayChartChallenge with 2026 data.

A dot plot, each OECD country’s freedom of the press score is plotted on a horizontal axis ranging from 25 to 100. Norway ranks first with 93, Türkiye last with 28.
Color indicates the press freedom classification: 7 countries with a good situation, 20 satisfactory, 7 problematic, 3 difficult, 1 very serious. A smaller grey dot indicates the value from the previous year (biggest developments mentioned in the post).

Ansgar Wolsing@ansgarw· May 3

Added two labels to describe the series #30DayChartChallenge | Day 16 - Causation

A chart showing the annual number of notified cases of measles in England and Wales from 1940 to 2025. Light bars in the background show the annual values, a smoothed line shows the long-term trend. The time on the x axis is cut into segments:
Before 1968: About 1000 cases per 100000 inhabitants annually.
Between 1968 and 1988: 150 cases per 100000 inhabitants.
After 1988 (intro of MMR): Up to 10 cases per 100000 inhabitants, with some spikes in numbers up to 18 cases per 100000 inhabitants.

Ansgar Wolsing@ansgarw· May 3

When the first measles vaccination was approved in the United Kingdom in 1968, the number of infections decreased quickly and significantly. #30DayChartChallenge | Day 16 - Causation #dataviz

Ansgar Wolsing@ansgarw· May 2

This chart is a remake of a graph made by Deutsche Bundesbank in their report on Household wealth and finances in Germany: Results of the 2023 household wealth survey (published April 2025). publikationen.bundesbank.de/publikatione...

A stacked bar chart that shows the quintiles from 2011 as bars, the stacked segments represent the quintiles the same households are in in 2023.

Ansgar Wolsing@ansgarw· May 2

Most wealth mobility occurs in the middle of the wealth distribution in Germany. (April is officially over, but I have a few more ideas - and missing categories - to be shared.) #30DayChartChallenge | Day 17 - Remake #dataviz

A chart with 2 graphs. First, a flow diagram which shows the movement between wealth quintiles between 2 survey waves in 2011 (left bar) and 2023 (right bar). The size of the streams between these stacked bars are sized proportionally to the share of households which moved between the connected segments. As the post implies, most movement happes in the 2nd to 4th quintile, while the 5th and highest quintile as well as the 1st/lowest quintile remain rather stable. The second part is a matrix showing the percentage values for each combination of 2011 and 2023 quintile.

Ansgar Wolsing@ansgarw· Apr 30

Day 30 and final day of the #30DayChartChallenge! The German government agreed on a major healthcare reform this week, introducing cost-saving measures that have been heavily debated. #30DayChartChallenge | Day 30 - Data Day: Global Health Data Exchange #dataviz

Line charts comparing projected healthcare spending per person in the United States and Germany from 2023 to 2050, measured in constant 2023 purchasing power parity dollars. The U.S. shows a steep increase in "Total Health Spending," rising from approximately USD14,000 to $25,000. Germany's total spending rises from roughly $8,000 to $12,000. For both countries, the government contribution line remains significantly lower, ending at around $10,000 in the U.S. and $8,500 in Germany.

Ansgar Wolsing@ansgarw· Apr 29

In just one year, the Republicans have set US democracy back by decades. Since the inauguration, the Trump administration has not hesitated to dismantle critical institutions and checks and balances. #30DayChartChallenge | Day 29 - Monochrome #dataviz

2 line charts which show the trends in two democracy indices for the U.S.: Liberal Democracy and Electoral Democracy measured by V-Dem. The x axis shows years from 1950 to 2025. The y axis shows the index values from 0.4 to 1. Both indices show a steadily increasing trend from 1950 (values: 0.5 / 0.6) to the late 1970s / early 1980s (values: 0.8 / 0.85), followed by a stable period until 2001 with a decrease after 9/11. Indices improved from 2008 to 2016, but fell under the first Trump administration (esp. Liberal Democracy to 0.75). A partial recovery under Biden, then a steep decline in 2025 to 0.57 (LD) and 0.74 (ED).

Ansgar Wolsing@ansgarw· Apr 28

Germany's future: 30 population projections 2025-2070 Projections by the Federal Statistics Office #30DayChartChallenge | Day 28 - Modeling #dataviz

A line chart titled “Germany's future: 30 population projections 2025-2070" showing 30 different population scenarios for Germany from 2025 to 2070.

28 lines trend downward, starting from 84M in 2025. Key data points for 2070 include:

- Maximum population: 86.5M (1 of only 2 growth scenarios).
- Constant at 2024 level: 81.8M.
- Minimum population: 63.9M.
- No external migration scenario: 59.6M (the lowest projection).

20 scenarios, the population decreases by more than 8 million people by 2070.

Ansgar Wolsing@ansgarw· Apr 28

Das ebenso wenig seriöse Schwesterblatt berichtet ohne Paywall:

Screenshot welt.de: Insa-Politikerranking: Merz auf dem 20. und letzten Platz. War vorher Platz 18.

Ansgar Wolsing@ansgarw· Apr 27

What if there was a federal election in Germany next Sunday… … and we included the uncertainty in the data in the chart? The results of every opinion poll come with a margin of error. How can we communicate this uncertainty? #30DayChartChallenge | Day 27 - Animation #dataviz 📊

Ansgar Wolsing@ansgarw· Apr 26

Ansgar Wolsing@ansgarw· Apr 25

German car exports to China have dropped sharply since 2022. At the same time, imports from China have caught up. #30DayChartChallenge | Day 24 - Theme Day: South China Morning Post #dataviz

A line chart. One line shows the annual volume of exports from Germany to China (in EUR) between 2008 and 2025, the other shows imports from China. Between 2008 and 2012, German car exports to China almost quadrupled. Exports reach its peak in 2022, but have dropped by 55 in just 3 years. Imports from China have tripled between 2020 and 2023.

Ansgar Wolsing@ansgarw· Apr 24

Germany has experienced a consistent rise in seasonal temperatures from 1881 through 2025. Source: @dwdderwetterdienst.bsky.social #30DayChartChallenge | Day 23 - Seasons #dataviz

4 bar charts showing seasonal temperature anomalies in Germany from 1881-2025 for spring, summer, autumn, and winter. Each chart uses vertical bars to show deviations from the 1961-1990 average, with blue for colder and red for warmer years. A clear trend shows a transition from frequent cold anomalies in the late 19th century to dominant heat anomalies in the 21st century. Saturated red bars, marking the top 10 hottest seasons, are concentrated almost entirely after 1990.

Ansgar Wolsing@ansgarw· Apr 23

Even in early development, ggsql supports a variety of geoms and aesthetics which you know from ggplot2 in R. I challenged myself to re-create the time series chart about BEV sales in Germany I shared for day 19 of the #30DayChartChallenge. bsky.app/profile/ansg...

Ansgar Wolsing@ansgarw· Apr 23

The Grammar of Graphics for SQL – and it’s for real! 😅 #ggsql brings the Grammar of Graphics to SQL - developed by the team behind ggplot2 at Posit. No need to switch to another tool to create nice charts once you have queried your database. #30DayChartChallenge | Day 22 - New tool #dataviz 📊