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 |
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!
@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, 2020Thanks man. Needed this
DeshaunB commented May 27, 2020Never thought I'd need this, But here I am! Thanks!
mbonett commented Sep 4, 2020Thank 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, 2020Can't believe people still find this useful, thanks @mbonett
muzop commented Sep 9, 2020 via emailIt 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, 2020Search 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 emailFor 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 .