Name: Quarterback Stats From 1996 - 2016
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Quarterback Stats From 1996 - 2016

Why?

The NFL, ESPN, and many others have their own Quarterback rating system. Can you create your own? How many points does a QB contribute to a given game? And, with MVP trophy season coming up, who really stands out as an MVP and who is carried by their team?

QB Stats

This is scraped from footballdb.com using Pandas' read_html function. This dataset contains every regular season NFL game and every NFL passer (including non-quarterbacks) from 1996 to 2016. Individual years are available for the past 10 years, and all 21 years are in QBStats_all. In addition to the traditional stats, the total points from the game have been appended to the stats. Win/Loss is up and coming, but is not a priority at the moment since a QB cannot control how well the defense stops the opposing offense.

Content

Inside you'll find:

Quarterback Name (qb)
Attempts (att)
Completions (cmp)
Yards (yds)
Yards per Attempt (ypa)
Touchdowns (td)
Interceptions (int)
Longest Throw (lg)
Sacks (sack)
Loss of Yards (loss)
The NFL's Quarterback Rating for the game (rate)
Total points scored in the game (game_points)
Home or Away Game (home_away)
Year (year)

Important Note:

Because of the way that these were scraped, the the game week is not supplied. However, the games are all in oldest to most recent which would allow for some time-series analysis.

Additionally:

Feel free to make any requests for additional information. But due to the time that it takes to scrape 21 years of NFL stats, it will likely take a while before I finish updating the dataset.

Acknowledgements

I would very much like to thank footballdb.com for not blacklisting me after numerous scrapes and potential future scrapes for information on other positions.

Tables

Qbstats 2004

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2004

22.87 kB
648 rows
14 columns

CREATE TABLE qbstats_2004 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2005

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2005

22.41 kB
637 rows
14 columns

CREATE TABLE qbstats_2005 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2006

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2006

22.11 kB
620 rows
14 columns

CREATE TABLE qbstats_2006 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2007

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2007

22.52 kB
639 rows
14 columns

CREATE TABLE qbstats_2007 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2008

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2008

22.34 kB
626 rows
14 columns

CREATE TABLE qbstats_2008 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2009

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2009

23.23 kB
671 rows
14 columns

CREATE TABLE qbstats_2009 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" DOUBLE,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" VARCHAR,
  "lg" VARCHAR,
  "sack" DOUBLE,
  "loss" DOUBLE,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2010

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2010

22.33 kB
625 rows
14 columns

CREATE TABLE qbstats_2010 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2011

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2011

22.07 kB
614 rows
14 columns

CREATE TABLE qbstats_2011 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2012

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2012

21.74 kB
604 rows
14 columns

CREATE TABLE qbstats_2012 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2013

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2013

21.56 kB
589 rows
14 columns

CREATE TABLE qbstats_2013 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2014

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2014

22.07 kB
616 rows
14 columns

CREATE TABLE qbstats_2014 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2015

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2015

21.46 kB
592 rows
14 columns

CREATE TABLE qbstats_2015 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats 2016

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2016

21.86 kB
610 rows
14 columns

CREATE TABLE qbstats_2016 (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" BIGINT,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" BIGINT,
  "lg" VARCHAR,
  "sack" BIGINT,
  "loss" BIGINT,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);

Qbstats All

@kaggle.speckledpingu_nfl_qb_stats.qbstats_all

170.11 kB
13,188 rows
14 columns

CREATE TABLE qbstats_all (
  "qb" VARCHAR,
  "att" BIGINT,
  "cmp" BIGINT,
  "yds" DOUBLE,
  "ypa" DOUBLE,
  "td" BIGINT,
  "int" VARCHAR,
  "lg" VARCHAR,
  "sack" DOUBLE,
  "loss" DOUBLE,
  "rate" DOUBLE,
  "game_points" BIGINT,
  "home_away" VARCHAR,
  "year" BIGINT
);