NFL Teams Data
Discovering NFL Teams, Superbowls, and Stadiums on the Map
@kaggle.kayla96_nfl_teams_data
Nfl Team Data
@kaggle.kayla96_nfl_teams_data.nfl_team_data
- 10.49 KB
- 32 rows
- 11 columns
team_nameTeam Name | home_stadiumHome Stadium | locationLocation | latLat | longLong | mascotMascot | live_mascotsLive Mascots | conferenceConference | divisionDivision | superbowl_winsSuperbowl Wins | year_estYear Est |
|---|---|---|---|---|---|---|---|---|---|---|
| Buffalo Bills | Highmark Stadium | Ochard Park, New York | 42.773773 | -78.78746 | Buffalo Billy | nan | AFC | East | 1959 | |
| Miami Dolphins | Hard Rock Stadium | Miami Gardens, Florida | 25.95796 | -80.239311 | T.D. | nan | AFC | East | 2 | 1965 |
| New England Patriots | Gillete Stadium | Foxborough, Massachusetts | 42.08783298 | -71.25866563 | Pat Patriot | nan | AFC | East | 6 | 1959 |
| New York Jets | MetLife Stadium | East Rutherford, New Jersey | 40.813778 | -74.217121 | nan | nan | AFC | East | 1 | 1959 |
| Denver Broncos | Empower Field at Mile High | Denver, Colorado | 39.744129 | -105.020828 | Miles | Thunder (Horse) | AFC | West | 3 | 1959 |
| Kansas City Chiefs | Arrowhead Stadium | Kansas City, Missouri | 39.048786 | -94.484566 | K.C. Wolf | nan | AFC | West | 3 | 1959 |
| Las Vegas Raiders | Allegiant Stadium | Paradise, Nevada | 36.090794 | -115.183952 | Raider Rush | nan | AFC | West | 3 | 1960 |
| Los Angeles Chargers | SoFi Stadium | Inglewood, California | 33.953587 | -118.482441 | nan | nan | AFC | West | 1959 | |
| Baltimore Ravens | M&T Bank Stadium | Baltimore, Maryland | 39.278088 | -76.623322 | Poe | Rise and Conquer (Ravens) | AFC | North | 2 | 1996 |
| Cincinnati Bengals | Paycor Stadium | Cincinnati, Ohio | 39.096306 | -84.516846 | Who Dey | nan | AFC | North | 1967 |
CREATE TABLE nfl_team_data (
"team_name" VARCHAR,
"home_stadium" VARCHAR,
"location" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"mascot" VARCHAR,
"live_mascots" VARCHAR,
"conference" VARCHAR,
"division" VARCHAR,
"superbowl_wins" BIGINT,
"year_est" BIGINT
);