Name: NFL Play Statistics Dataset (primary)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NFL Play Statistics Dataset (primary)

NFL is one of the most popular sports in the world. Many of us are stat geeks who understanding not what just happened but also who and why. This NFL dataset provides a comprehensive view of NFL games, statistics, participation, the annual NFL combine, and the NFL draft. The dataset includes NFL play data from 2004 to the present.

This NFL dataset provides play-by-play data from the 2004 to 2019 seasons. Dataset also includes play and participation information for players, coaches, and game officials. Additional data tables included in this file includes NFL Draft from 1989 to present, NFL Combine 1999 to present, NFL rosters from 1998 to present, NFL schedules, stadium information and much more.
The granularity of NFL statistics varies by NFL season. The current version of NFL statistics has been collected since 2012. All information sources used to create this dataset are from publically accessible websites and the NFL GSIS dataset.

All information sources used to create this dataset are from publically accessible websites and NFL documentation. Although my current life is focused on data science, this project has a special place in my heart, since it links my previous profession in the NFL with my current passion for data analysis.

Tables

Combine

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.combine

918.32 kB
10,080 rows
35 columns

CREATE TABLE combine (
  "combineid" BIGINT,
  "playerid" BIGINT,
  "combineyear" BIGINT,
  "combineposition" VARCHAR,
  "combineheight" DOUBLE,
  "combineweight" BIGINT,
  "combinehand" DOUBLE,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "position" VARCHAR,
  "collegeid" DOUBLE,
  "nflid" VARCHAR,
  "college" VARCHAR,
  "heightinches" DOUBLE,
  "weight" DOUBLE,
  "dob" TIMESTAMP,
  "ageatdraft" DOUBLE,
  "playerprofileurl" VARCHAR,
  "homecity" VARCHAR,
  "homestate" VARCHAR,
  "homecountry" VARCHAR,
  "highschool" VARCHAR,
  "hscity" VARCHAR,
  "hsstate" VARCHAR,
  "hscountry" VARCHAR,
  "combinearm" DOUBLE,
  "combine40yd" DOUBLE,
  "combinevert" DOUBLE,
  "combinebench" DOUBLE,
  "combineshuttle" DOUBLE,
  "combinebroad" DOUBLE,
  "combine3cone" DOUBLE,
  "combine60ydshuttle" DOUBLE,
  "combinewonderlic" DOUBLE
);

Draft

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.draft

954.93 kB
12,140 rows
27 columns

CREATE TABLE draft (
  "playerid" BIGINT,
  "draft" BIGINT,
  "round" DOUBLE,
  "pick" BIGINT,
  "drafttradevalue" DOUBLE,
  "draftteam" VARCHAR,
  "position" VARCHAR,
  "teamid" BIGINT,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "collegeid" BIGINT,
  "nflid" DOUBLE,
  "combineid" DOUBLE,
  "college" VARCHAR,
  "heightinches" DOUBLE,
  "weight" DOUBLE,
  "dob" TIMESTAMP,
  "ageatdraft" DOUBLE,
  "playerprofileurl" VARCHAR,
  "homecity" VARCHAR,
  "homestate" VARCHAR,
  "homecountry" VARCHAR,
  "highschool" VARCHAR,
  "hscity" VARCHAR,
  "hsstate" VARCHAR,
  "hscountry" VARCHAR
);

Fumbles

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.fumbles

241.52 kB
14,910 rows
9 columns

CREATE TABLE fumbles (
  "fumid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "fumposition" VARCHAR,
  "fumtype" VARCHAR,
  "fumoob" BIGINT,
  "fumturnover" DOUBLE,
  "fumnull" BIGINT
);

Fumblforced

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.fumblforced

165.95 kB
9,876 rows
7 columns

CREATE TABLE fumblforced (
  "fumforcedid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" DOUBLE,
  "fumforcedposition" VARCHAR,
  "fumforcedturnover" DOUBLE,
  "fumforcednull" BIGINT
);

Gameparticipation

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.gameparticipation

12.49 MB
423,185 rows
26 columns

CREATE TABLE gameparticipation (
  "gamepartid" BIGINT,
  "gameid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "gamepartunit" VARCHAR,
  "gamepartsnapcount" BIGINT,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "position" VARCHAR,
  "collegeid" DOUBLE,
  "nflid" DOUBLE,
  "combineid" DOUBLE,
  "college" VARCHAR,
  "heightinches" DOUBLE,
  "weight" DOUBLE,
  "dob" TIMESTAMP,
  "ageatdraft" DOUBLE,
  "playerprofileurl" VARCHAR,
  "homecity" VARCHAR,
  "homestate" VARCHAR,
  "homecountry" VARCHAR,
  "highschool" VARCHAR,
  "hscity" VARCHAR,
  "hsstate" VARCHAR,
  "hscountry" VARCHAR
);

Games

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.games

107.4 kB
5,308 rows
16 columns

CREATE TABLE games (
  "gameid" BIGINT,
  "season" BIGINT,
  "week" BIGINT,
  "gamedate" TIMESTAMP,
  "gametimeeastern" VARCHAR,
  "gametimelocal" VARCHAR,
  "hometeamid" BIGINT,
  "visitorteamid" BIGINT,
  "seasontype" VARCHAR,
  "weeknameabbr" VARCHAR,
  "siteid" BIGINT,
  "hometeamdistance" BIGINT,
  "visitingteamdistance" BIGINT,
  "hometeamfinalscore" BIGINT,
  "visitingteamfinalscore" BIGINT,
  "winningteam" BIGINT
);

Interceptions

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.interceptions

120.27 kB
9,463 rows
9 columns

CREATE TABLE interceptions (
  "interceptionid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "intposition" VARCHAR,
  "int" BIGINT,
  "intyards" BIGINT,
  "inttd" BIGINT,
  "intnull" BIGINT
);

Kickreturns

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.kickreturns

701.06 kB
60,453 rows
11 columns

CREATE TABLE kickreturns (
  "kickretid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" DOUBLE,
  "kickretposition" VARCHAR,
  "kickretoutcome" VARCHAR,
  "kickretprimary" BIGINT,
  "kickretyds" BIGINT,
  "kickrettd" DOUBLE,
  "kickretend" VARCHAR,
  "kickretnull" BIGINT
);

Kicks

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.kicks

2.59 MB
148,014 rows
15 columns

CREATE TABLE kicks (
  "kickid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "kickposition" VARCHAR,
  "kicktype" VARCHAR,
  "kickoutcome" VARCHAR,
  "kickinside20" BIGINT,
  "kickonside" BIGINT,
  "kickownrecovery" BIGINT,
  "kicklength" DOUBLE,
  "kickreturnyds" BIGINT,
  "kicknetyds" DOUBLE,
  "kickreturntd" BIGINT,
  "kicknull" BIGINT
);

Officials

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.officials

373.31 kB
39,434 rows
5 columns

CREATE TABLE officials (
  "officialpartid" DOUBLE,
  "officialid" BIGINT,
  "officialname" VARCHAR,
  "officialposition" VARCHAR,
  "gameid" DOUBLE
);

Passdef

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.passdef

532.78 kB
48,172 rows
6 columns

CREATE TABLE passdef (
  "passdefid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "passdefposition" VARCHAR,
  "passdefnull" BIGINT
);

Passer

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.passer

4.83 MB
397,265 rows
19 columns

CREATE TABLE passer (
  "passid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "passposition" VARCHAR,
  "passoutcomes" VARCHAR,
  "passdirection" VARCHAR,
  "passdepth" VARCHAR,
  "passlength" BIGINT,
  "passatt" BIGINT,
  "passcomp" BIGINT,
  "passtd" BIGINT,
  "passint" BIGINT,
  "passinttd" BIGINT,
  "passsack" BIGINT,
  "passsackyds" BIGINT,
  "passhit" BIGINT,
  "passdef" BIGINT,
  "passnull" BIGINT
);

Penalties

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.penalties

872.46 kB
68,782 rows
8 columns

CREATE TABLE penalties (
  "penaltyid" DOUBLE,
  "playid" DOUBLE,
  "teamid" DOUBLE,
  "playerid" DOUBLE,
  "penaltyposition" VARCHAR,
  "penaltydescrip" VARCHAR,
  "penaltyyds" DOUBLE,
  "penaltyresult" VARCHAR
);

Players

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.players

1.69 MB
23,295 rows
21 columns

CREATE TABLE players (
  "playerid" BIGINT,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "position" VARCHAR,
  "collegeid" BIGINT,
  "nflid" VARCHAR,
  "combineid" DOUBLE,
  "college" VARCHAR,
  "heightinches" DOUBLE,
  "weight" DOUBLE,
  "dob" TIMESTAMP,
  "ageatdraft" DOUBLE,
  "playerprofileurl" VARCHAR,
  "homecity" VARCHAR,
  "homestate" VARCHAR,
  "homecountry" VARCHAR,
  "highschool" VARCHAR,
  "hscity" VARCHAR,
  "hsstate" VARCHAR,
  "hscountry" VARCHAR
);

Plays

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.plays

153.49 MB
870,384 rows
44 columns

CREATE TABLE plays (
  "playid" BIGINT,
  "gameid" BIGINT,
  "playsequence" BIGINT,
  "quarter" BIGINT,
  "possessionteamid" BIGINT,
  "nonpossessionteamid" BIGINT,
  "playtype" VARCHAR,
  "playtype2" VARCHAR,
  "playtypedetailed" VARCHAR,
  "playnumberbyteam" BIGINT,
  "gameclock" VARCHAR,
  "gameclocksecondsexpired" BIGINT,
  "gameclockstoppedafterplay" BIGINT,
  "down" BIGINT,
  "distance" BIGINT,
  "fieldposition" VARCHAR,
  "distancetogoalpre" DOUBLE,
  "noplay" BIGINT,
  "playdescription" VARCHAR,
  "playstats" VARCHAR,
  "playdescriptionfull" VARCHAR,
  "typeofplay" VARCHAR,
  "changepossession" BIGINT,
  "turnover" BIGINT,
  "safety" BIGINT,
  "offensiveyards" BIGINT,
  "netyards" BIGINT,
  "firstdown" BIGINT,
  "efficientplay" BIGINT,
  "evpre" DOUBLE,
  "evpost" DOUBLE,
  "evplay" DOUBLE,
  "fourthdownconversion" BIGINT,
  "thirddownconversion" BIGINT,
  "scorepossession" BIGINT,
  "scorenonpossession" BIGINT,
  "homescorepre" BIGINT,
  "visitingscorepre" BIGINT,
  "homescorepost" BIGINT,
  "visitingscorepost" BIGINT,
  "distancetogoalpost" DOUBLE,
  "fieldgoalprobability" DOUBLE,
  "huddle" VARCHAR,
  "formation" VARCHAR
);

Qhhits

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.qhhits

536.77 kB
51,553 rows
6 columns

CREATE TABLE qhhits (
  "qbhitid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" DOUBLE,
  "position" VARCHAR,
  "statnull" BIGINT
);

Receiver

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.receiver

3.66 MB
350,924 rows
14 columns

CREATE TABLE receiver (
  "receiverid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "recposition" VARCHAR,
  "recyards" BIGINT,
  "rec" BIGINT,
  "recyac" BIGINT,
  "rec1down" BIGINT,
  "recfumble" BIGINT,
  "recpassdef" BIGINT,
  "recpassint" BIGINT,
  "recend" VARCHAR,
  "recnull" BIGINT
);

Rusher

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.rusher

2.94 MB
278,598 rows
13 columns

CREATE TABLE rusher (
  "rushid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "rushposition" VARCHAR,
  "rushtype" VARCHAR,
  "rushdirection" VARCHAR,
  "rushlandmark" VARCHAR,
  "rushyards" BIGINT,
  "rushprimary" BIGINT,
  "rushtd" DOUBLE,
  "rushend" VARCHAR,
  "rushnull" BIGINT
);

Sacks

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.sacks

302.75 kB
25,964 rows
9 columns

CREATE TABLE sacks (
  "sackid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "sackposition" VARCHAR,
  "sacktype" DOUBLE,
  "sackyards" BIGINT,
  "sackend" VARCHAR,
  "sacknull" BIGINT
);

Tackles

@kaggle.toddsteussie_nfl_play_statistics_dataset_2004_to_present.tackles

9.03 MB
726,294 rows
9 columns

CREATE TABLE tackles (
  "tackleid" BIGINT,
  "playid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "tackleposition" VARCHAR,
  "tackletype" VARCHAR,
  "tackleydsscrim" DOUBLE,
  "tackleend" VARCHAR,
  "tacklenull" BIGINT
);