Baselight

Quarterback Stats From 1996 - 2016

Over 5000 Regular Season Games

@kaggle.speckledpingu_nfl_qb_stats

Loading...
Loading...

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 2008

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2008
  • 21.82 KB
  • 626 rows
  • 14 columns
Loading...

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 2004

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2004
  • 22.34 KB
  • 648 rows
  • 14 columns
Loading...

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 2009

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2009
  • 22.68 KB
  • 671 rows
  • 14 columns
Loading...

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 2011

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2011
  • 21.55 KB
  • 614 rows
  • 14 columns
Loading...

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 2016

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2016
  • 21.34 KB
  • 610 rows
  • 14 columns
Loading...

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 2015

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2015
  • 20.96 KB
  • 592 rows
  • 14 columns
Loading...

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 2007

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2007
  • 22 KB
  • 639 rows
  • 14 columns
Loading...

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 2012

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2012
  • 21.23 KB
  • 604 rows
  • 14 columns
Loading...

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.05 KB
  • 589 rows
  • 14 columns
Loading...

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 All

@kaggle.speckledpingu_nfl_qb_stats.qbstats_all
  • 166.13 KB
  • 13188 rows
  • 14 columns
Loading...

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
);

Qbstats 2010

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2010
  • 21.81 KB
  • 625 rows
  • 14 columns
Loading...

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 2014

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2014
  • 21.55 KB
  • 616 rows
  • 14 columns
Loading...

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 2006

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2006
  • 21.59 KB
  • 620 rows
  • 14 columns
Loading...

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 2005

@kaggle.speckledpingu_nfl_qb_stats.qbstats_2005
  • 21.88 KB
  • 637 rows
  • 14 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.