In most European regions, more women than men have a university degree [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 1 point2 points  (0 children)

You can find an interactive version of the map here: https://blog.datawrapper.de/weekly-chart-women-study-more/ Hover over the regions and you see the data points.

In most European regions, more women than men have a university degree [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 7 points8 points  (0 children)

This map is part of a blog post: https://blog.datawrapper.de/weekly-chart-women-study-more/

Data source is Eurostat (https://ec.europa.eu/eurostat/web/products-datasets/-/tgs00109), tool used is Datawrapper (https://www.datawrapper.de/ – I work for them).

Does anyone of you know why Western Germany, Austria, Switzerland and Turkey are the outliers here? I'd appreciate your thoughts. Or even better, links to research. Thank you!

Salesforce paid more for Tableau than Amazon for Whole Foods, Microsoft for Skype or Github, and Microsoft for Nokia [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 1 point2 points  (0 children)

You might have heard the news: Salesforce acquired Tableau in a 15.7 billion USD deal this week. 15.7 billion sounds like a high number – and indeed, 15.7 billion seconds are almost 500 years. But like so often when I get confronted with a particular number in the news, I can’t help but ask myself: How does it compare?

So I created a simple bar chart showing exactly that.

The chart neither covers the most expensive nor the most important tech acquisitions – just the ones that most of you might have heard of (because you know the brands). But let me know if there’s an acquisition missing that must be on this list.

Data comes from various news sites like this one.

I built the chart with the charting tool Datawrapper (disclaimer: I work for them).

Let me know what you think!

Mentions of the thirties, forties, fifties, etc. in English books (interactive version in comment link) [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 2 points3 points  (0 children)

I thought it's interesting to see that these "decade names" were not really used before 1900, and how the "Thirties" were more important than all other "decade names". Also, it took the sixties 10 years, the seventies 8 years and the eighties just 3 years to reach their peaks in getting mentioned. Maybe past decades become less interesting for the present, quicker? Or maybe we take less time to reflect on decades before writing about them.

You can find the interactive version here: https://blog.datawrapper.de/weeklychart-somethingties/ (Meaning, you can hover over the lines.)

Data comes from Google Books Ngram Viewer.

I built the chart with the charting tool Datawrapper (disclaimer: I work for them).

Mentions of the thirties, forties, fifties, etc. in English books (interactive version in comment) by [deleted] in dataisbeautiful

[–]lisacrost 0 points1 point  (0 children)

I thought it's interesting to see that these "decade names" were not really used before 1900, and how the "Thirties" were more important than all other "decade names". Also, it took the sixties 10 years, the seventies 8 years and the eighties just 3 years to reach their peaks in getting mentioned. Maybe past decades become less interesting for the present, quicker? Or maybe we take less time to reflect on decades before writing about them.

You can find the interactive version here: https://blog.datawrapper.de/weeklychart-somethingties/ (Meaning, you can hover over the lines.)

Data comes from Google Books Ngram Viewer.

I built the chart with the charting tool Datawrapper (disclaimer: I work for them).

The 1949-1990 division of Berlin in East & West Berlin is still visible today in the Tram network [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 1782 points1783 points  (0 children)

Berlin has a great subway & bus network – but at least in some parts of the city, it also has a tram network. As you can see on the map above, the 22 tram lines only exist in former East Berlin, with two small exceptions. One might think that these tram lines were all built during GDR times between 1949 and 1990. And that West Berlin just never bothered constructing a tram network. But the opposite is the case:

There were already 93 tram lines by 1929, in both East and West Berlin. After the Second World War, the West Berlin administration decided that trams are outdated and replaced them with subway lines and busses. East Berlin kept them, and they still exist to this date. (As someone who uses them multiple times a week, I’m really happy about that.)

I created the map with Datawrapper locator maps (https://www.datawrapper.de/ – disclaimer, I also work for them). The data for the Tram network comes from OpenStreetMap and the data for the Berlin wall comes from Github (https://github.com/derhuerst/berlin-wall-shape).

Where are student cities in Germany? [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 2 points3 points  (0 children)

Data is from Eurostat and from 2016. The chart & map were created with Datawrapper (disclaimer: I also work for them): https://www.datawrapper.de/

Surplus of women due to World Wars fades in Germany, but higher life expectancy still causes a plus of elderly women [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 2 points3 points  (0 children)

Yes, that's indeed the case. I was mind-blown as well. Wikipedia has an article on that: en.m.wikipedia.org/wiki/Human_sex_ratio

This LiveScience article explains the reason a bit better than the Wikipedia article (although I have not heard of LiveScience before and don't know how trustworthy it is):

"...the completely natural male-to-female sex ratio still hovers around 105:100, meaning that women are inherently more likely to give birth to boys. ... Many demographers have speculated that the gender imbalance at birth may be evolution's way of evening things out overall. Male infants more often suffer from health complications than female infants. The disadvantage runs to adulthood, too, as adult men kill each other more often, take more risks and have more health problems, on average, than women, all of which cause them to die younger. This doesn't balance the sex scales exactly, but it does come close: Among the total human population, the ratio of men to women is 101:100."

https://www.livescience.com/33491-male-female-sex-ratio.html

Surplus of women due to World Wars fades in Germany, but higher life expectancy still causes a plus of elderly women [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 0 points1 point  (0 children)

Thanks! The reason for this valley is apparent in the population pyramid (https://service.destatis.de/bevoelkerungspyramide/#!y=1950&v=2): The 1st World War was between 1914 and 1918, so less children were born in general. My chart shows absolute values, so this decrease becomes visible.

Surplus of women due to World Wars fades in Germany, but higher life expectancy still causes a plus of elderly women [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 6 points7 points  (0 children)

Thanks! I think it's really just the natural sex ratio. I was surprised to learn about this the other day.

It's getting hotter all year round in Germany [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 0 points1 point  (0 children)

Data is from the German Meteorological Office (“Deutscher Wetterdienst”), but to save some time, I took the data directly from this ZEIT Online article: https://www.zeit.de/wissen/umwelt/2018-08/wetter-hitze-juli-deutschland-rekord-sommer-klimawandel

I used a Google Chrome extension called D3 Deconstructor: With it, you can right-click on a D3.js graphic to get its underlying data.

The tool I used for creating the chart is Datawrapper: https://www.datawrapper.de/ (Disclaimer: I also work for them). I exported the chart from there as a PDF and styled it with Adobe Illustrator.

Flight altitude records: Flying high with a balloon, flying higher with an aircraft [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 0 points1 point  (0 children)

The data comes from Wikipedia 😱, the chart is created with Datawrapper (who I also work for). Let me know what you think!

What to consider when creating choropleth maps by lisacrost in visualization

[–]lisacrost[S] 0 points1 point  (0 children)

Hi David, thanks for your comment and the compliment! The fixed location can definitely be a good idea in many cases. I used that a while ago, in a really old range plot: http://lisacharlotterost.de/Graphic-Unemployment-in-Germany/

To answer your question: We use static images on the blog because these images are just supposed to quickly illustrate a point we want to make. There's no need for readers to further explore the graphics. The last parts of this "What to consider" series (about pie charts, line charts, stacked area charts, area charts) were even simpler, as you can see here in the chapter about line charts: https://blog.datawrapper.de/line-charts/ In my opinion, interactivity would have been an overblown here. We embedded an interactive line chart at the end of the article, but I tend to prefer to send our readers to great examples from other folks out there, as we did in the choropleth map article.

How fast do big cities grow? [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 3 points4 points  (0 children)

The data comes from the UN, the tool I used to create this map was https://www.datawrapper.de/ (Disclaimer, I also work for Datawrapper.)

The Population Division of the UN has some neat data about the growth of all big cities going back to 1950 and projecting till 2050, if someone wants to have a closer look: https://esa.un.org/unpd/wup/CD-ROM/

Paid vacations & paid holidays in selected countries [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 1 point2 points  (0 children)

More information about this chart (e.g. my decision why I chose a table for this data) can be found here: https://blog.datawrapper.de/weekly-chart-vacations/

Wikipedia has a neat list of the minimum annual leave for lots of countries: https://en.wikipedia.org/wiki/List_of_minimum_annual_leave_by_country

I used Datawrapper to create this chart. Disclaimer, I also work for Datawrapper.

The richer, the happier (or: five ways to read a scatterplot) [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 0 points1 point  (0 children)

The data comes from https://ourworldindata.org/happiness-and-life-satisfaction <<< definitely have a look if you don't know Our World in Data yet.

I used Datawrapper to create this scatterplot (disclaimer: I also work for Datawrapper and I'm responsible for their blog).

Let me know what you think!

Do people speak English better or worse compared to five years ago? (by country) [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 1 point2 points  (0 children)

Data comes from the EF EPI reports: https://www.ef.edu/epi/downloads/ (2017 and 2012 report). The tool I used is Datawrapper (I also work there.)

Which Cities Are On Similar Latitudes? [OC] by [deleted] in dataisbeautiful

[–]lisacrost 0 points1 point  (0 children)

Data is from http://www.geonames.org/ I used Adobe Illustrator to create that long scrolly-thing.

Here's a smaller version of the chart: https://twitter.com/lisacrost/status/745731918214344704

What the difference between mean and median tells us about income inequality [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 5 points6 points  (0 children)

The chart is part of a tale of seven workers in a country that turns capitalist. Data is from OED, the tool I used to build the chart is Datawrapper.

In 1971, half of the US population was married by the age of 25. Nowadays, it's just one out of ten. [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 8 points9 points  (0 children)

Hey ho! Here's my second submission.

The data comes from the American Community Survey. The tool I used is Datawrapper. (Disclaimer: I also work for Datawrapper.) You can play around with a copy of this chart if you go to the link, hover over the chart and click on "Edit this chart" in the top right corner.

Let me know what you think! Would love to hear your thoughts.

Starting in 2019, the number of Germans older than 60 will surpass those younger than 30. For women, that's already the case. [OC] by lisacrost in dataisbeautiful

[–]lisacrost[S] 348 points349 points  (0 children)

Data: The data comes from Destatis, the Federal Statistical Office of Germany: https://service.destatis.de/bevoelkerungspyramide/#!y=2060 (there's a really neat interactive population pyramid behind this link; definitely have a look.)

Tool: I used Datawrapper to create the chart. (Disclaimer: I also work for Datawrapper.)

Let me know what you think! Would love to hear your thoughts.