Skip to content

Instantly share code, notes, and snippets.

@cnizzardini
Last active January 30, 2024 23:03
Show Gist options
  • Star 15 You must be signed in to star a gist
  • Fork 12 You must be signed in to fork a gist
  • Save cnizzardini/13d0a072adb35a0d5817 to your computer and use it in GitHub Desktop.
Save cnizzardini/13d0a072adb35a0d5817 to your computer and use it in GitHub Desktop.
List of nfl teams as a CSV: name,abbreviation,conference,division for MySQL format. Please comment if you find any errors.
ID Name Abbreviation Conference Division
1 Arizona Cardinals ARI NFC West
2 Atlanta Falcons ATL NFC South
3 Baltimore Ravens BAL AFC North
4 Buffalo Bills BUF AFC East
5 Carolina Panthers CAR NFC South
6 Chicago Bears CHI NFC North
7 Cincinnati Bengals CIN AFC North
8 Cleveland Browns CLE AFC North
9 Dallas Cowboys DAL NFC East
10 Denver Broncos DEN AFC West
11 Detroit Lions DET NFC North
12 Green Bay Packers GB NFC North
13 Houston Texans HOU AFC South
14 Indianapolis Colts IND AFC South
15 Jacksonville Jaguars JAX AFC South
16 Kansas City Chiefs KC AFC West
17 Miami Dolphins MIA AFC East
18 Minnesota Vikings MIN NFC North
19 New England Patriots NE AFC East
20 New Orleans Saints NO NFC South
21 New York Giants NYG NFC East
22 New York Jets NYJ AFC East
23 Las Vegas Raiders LV AFC West
24 Philadelphia Eagles PHI NFC East
25 Pittsburgh Steelers PIT AFC North
26 Los Angeles Chargers LAC AFC West
27 San Francisco 49ers SF NFC West
28 Seattle Seahawks SEA NFC West
29 Los Angeles Rams LAR NFC West
30 Tampa Bay Buccaneers TB NFC South
31 Tennessee Titans TEN AFC South
32 Washington Commanders WAS NFC East
@fouroh4
Copy link

fouroh4 commented Dec 1, 2019

this is strangely useful. Thanks

@tammer
Copy link

tammer commented Mar 2, 2020

Just what I need! One request so I don't have to fork: Could you please change "Oakland Raiders" to "Las Vegas Raiders"?
Oh and St. Louis moved some years ago back to LA!

@cnizzardini
Copy link
Author

cnizzardini commented Mar 2, 2020

@tammer Chargers too. Edits made. Surprised people actually use this, but then again, nothing existed which is why I posted this public.

@muzop
Copy link

muzop commented May 3, 2020

Thanks man. Needed this

@DeshaunB
Copy link

Never thought I'd need this, But here I am! Thanks!

@mbonett
Copy link

mbonett commented Sep 4, 2020

Thank you for the list. You should also change Washington to "Washington Football Team", as that is their official name for now.

@cnizzardini
Copy link
Author

Can't believe people still find this useful, thanks @mbonett

@muzop
Copy link

muzop commented Sep 9, 2020 via email

@cnizzardini
Copy link
Author

cnizzardini commented Sep 9, 2020

Post in here if find something. What about https://www.pro-football-reference.com/ @muzop? I imagine you code write a scaper as well, brittle as they are. Particularly easy if someone has CORS set to * and you can rip the JSON direct. Or I guess it doesn't matter on that account if you are using a server-side scripting language, sometimes need to jimmy it with cookies and what not.

@mbonett
Copy link

mbonett commented Sep 22, 2020

Search github for "espn" or "nfl ESPN", there are a number of people who appear to have created ways of scraping ESPN to get live data. I have not tried them as I am playing with getting that data from ESPN in JSON format and playing with it, as a learning experience.

@muzop
Copy link

muzop commented Sep 22, 2020 via email

@TidyH
Copy link

TidyH commented Oct 23, 2022

Please update 'Washington Football Team' to 'Washington Commanders'

I'd also suggest changing both NY teams to 'New York' as it is more in line with the rest of the data.

@cnizzardini
Copy link
Author

@TidyH done

@hscottv5
Copy link

This is super helpful!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment