Recent comments in /f/dataisbeautiful

twintig5 OP t1_j1rhvhz wrote

I shared a similar chart last year, and then there were a lot of comments and questions, so I wanted to improve it a bit.

  • Source: Wikipedia
  • Tools: Python for data cleaning and wrangling
  • Datawrapper for chart

Few things to have in mind:

  • The championships won are recorded for the cities only, not the individual franchises
  • When a team relocates to a new city, the number of championships won in the prior city remain with that city
  • Cities from suburbs and metropolitan areas, are mapped to the “main” city (e.g. Oakland to San Francisco)

If you would like to see different breakdowns (last 50 years, 21st century), or a full list of the cities (with at least 1 championship), you can find all that on my blog post here

On top of that, you can see a time series, and have a look how things changed with time. And there's a breakdown of all NYC sports championships.

Also, you find details about sources, methodology and mapping (which team was mapped to which city).

In general, it took quite some time to collect, organize and prepare all datasets, therefore hope you enjoyed.

Merry Christmas and happy holidays, everyone!

Edit: to provide some additional explanation. Wording is not the best, as if we are speaking about North America, we would need to include other countries and other leagues (e.g. Liga MX). Using wording like "US Sports" also isn't correct, as we have Canadian cities having representatives in some of the leagues. Some term like "US & Canada joint leagues" would maybe be better. General idea was to take 5 most popular sports, and get the winners of the top leagues of every sport. And that's why I haven't included CFL. For those asking why pre-NFL championships are included for football, it is because NFL recognizes them officially, similar like NBA recognizes BAA winners. Regarding soccer, I understand it wasn't big historically, but now is somewhere on pair with NHL, and that's why it was included. And I was only including MLS, since 1996.

8