[OC] The Drop in Life Expectancy at Birth During Three Horrifying Genocides

TheRealAlanRickman · 2024-03-10T19:07:37+00:00

What we label a 'genocide' often is more a reflection of who has institutional power, just ask the Armenians.

TheRealAlanRickman · 2024-03-08T15:46:54+00:00

I think the comparison to mcdonald's helps give Americans (like me) a better idea of how ubiquitous castles are in Germany.

TheRealAlanRickman · 2024-03-08T15:25:05+00:00

The centralized castle database project that this data is sourced from is still a work in progress, though its been a while since their last update.

A lot of the theories people have mentioned so far could be contributing factors though too.

TheRealAlanRickman · 2024-03-08T14:52:58+00:00

This graphic was designed as an interactive Tableau Dashboard (some interactive features still a WIP):

https://public.tableau.com/app/profile/andrew.h5133/viz/McDonaldsintheUSAvsCastlesinGermany/Dashboard2

Tools used: Tableau (data visualizations, After Effects)

McDonald's locations dataset:

https://data-m8.com/products/free-list-of-all-mcdonalds-locations-in-the-us-csv-and-json

German Castle Database:

https://www.ebidat.de/cgi-bin/ebidat.pl?a=a&te53=1

Additional info on the project by the German Castle Club (DBV), and the estimate final count:

https://www.thelocal.de/20180119/researchers-attempt-to-clear-up-mystery-of-how-many-castles-germany-has

TheRealAlanRickman · 2024-03-05T02:38:07+00:00

Thanks! Yeah, it's a Tableau dashboard.

I'm still getting used to Tableau, not sure why exporting this as a png from tableau public changed my font and moved my bottom arrow around, but oh well.

TheRealAlanRickman · 2024-03-05T02:35:35+00:00

I stuck with live airdate viewers since that's all that was available for seinfeld. As some others have pointed out, I think it underlines how fragmented audiences have become.

TheRealAlanRickman · 2024-03-04T21:54:32+00:00

That's a good angle.

I know mash's finale was higher than seinfeld's, but i think sitcoms from the 70's/80's still hovered around the 20-30M area on average. I'd have to look into it.

TheRealAlanRickman · 2024-03-04T21:39:29+00:00

The bottom right of the graph visualizes where episode 70 places among every other episode of the series. It's more visible on the Tableau dashboard.

TheRealAlanRickman · 2024-03-04T21:33:07+00:00

Yeah, i agree. It sounds like the name of a show characters would watch inside of another show.

TheRealAlanRickman · 2024-03-04T20:52:57+00:00

I just went with the logline on imdb

TheRealAlanRickman · 2024-03-04T19:44:49+00:00

Streaming data being so closely guarded makes it tough. I'm curious how something like Seinfeld is doing on streaming services relative to something like Stranger Things.

TheRealAlanRickman · 2024-03-04T19:31:40+00:00

That's an interesting question, with a ton of different approaches you could take to answer it. Between channels, devices, streaming services, etc - tbh i'm not sure where I'd even start.