NFL Teams Data

Discovering NFL Teams, Superbowls, and Stadiums on the Map

@kaggle.kayla96_nfl_teams_data

Table List

2 tables(21 KB)

Nfl

@kaggle.kayla96_nfl_teams_data.nfl

10.51 KB
32 rows
11 columns

team_name Team Name	home_stadium Home Stadium	location Location	lat Lat	long Long	mascot Mascot	live_mascots Live Mascots	conference Conference	division Division	superbowl_wins Superbowl Wins	year_est Year 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	41.248489	-74.61033	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	34.081062	-118.623463	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_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
);