twintig5

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

twintig5 OP t1_j0thrfn wrote

Yes, I actually use Photopea , a free online version of a photoshop. Wonderful tool. Also, I'm not very good at PS, just basic stuff. I was looking for a template but couldn't find one, so I did it by myself. Just take the straight line, and arrange it with different angles, that's the basic principle of it.

3

twintig5 OP t1_j0thar4 wrote

I started with it when knockout stages was drawn, then updating as the rounds progress. Yesterday I created 2 versions before the finals (because I knew I will be deep into post game stuff after the whistle :) ), and just posted when game ended.

I did added a medals, mostly to identify the 3rd placed team, but adding a star on ARG logo would be messing with their logo, which I wouldn't do. I took the logos as they are, not sure even ARG FA updated it yet. Or maybe they had it ready in advance so they did.

7