cnizzardini / nfl_teams.csv

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.

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters

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 commented Dec 1, 2019

this is strangely useful. Thanks

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 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 commented May 3, 2020

Thanks man. Needed this

DeshaunB commented May 27, 2020

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

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 commented Sep 4, 2020

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

muzop commented Sep 9, 2020 via email

It has been since NFL locked out the API access. Now I just need to find out where to access live scores from.

On Thu, Sep 3, 2020 at 7:54 PM Chris Nizzardini ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Can't believe people still find this useful, thanks @mbonett — You are receiving this because you commented. Reply to this email directly, view it on GitHub , or unsubscribe .

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 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 commented Sep 22, 2020 via email

For those interested in live scores only without other stats, there's a json feed here. http://static.nfl.com/liveupdate/scores/scores.json . Btw, I looked at the pro-football link and gave up trying to figure out how they are loading data after discovering they only had historical data and no live scores. I'll see what github has with those search params and try them out. For my purpose, I only needed the schedule which is fairly static and live scores. That is currently satisfied from the dump and above link. Still would love to be able to load schedule from scrape in the future.

On Mon, Sep 21, 2020 at 8:59 PM mbonett ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ 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. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or unsubscribe .