Dataset: ESPN NFL Draft Prospect Data

About this Dataset

ESPN NFL Draft Prospect Data

NFL draft prospect data from ESPN dating back to 1967 (first year of common draft era). There is text analysis for over 4000 of these prospects in nfl_draft_profiles.csv. You can join each of the datasets together nfl_draft_prospects.csv, which has data on when a prospect was drafted and which team drafted them, and college_statistics.csv which has data on counting statistics for players during their college career, using player_id.

Additionally, college_qbr.csv contains data on college QB's ESPN QBR metric as well as other EPA-based metrics from a college QB dating back to 2004. You can join this dataset using guid and player_name.

Tables

College Qbr

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.college_qbr

108.23 KB
2049 rows
14 columns


CREATE TABLE college_qbr (
  "season" BIGINT,
  "guid" VARCHAR,
  "player_name" VARCHAR,
  "age" DOUBLE,
  "total_qbr" DOUBLE,
  "points_added" DOUBLE,
  "qb_plays" BIGINT,
  "total_epa" DOUBLE,
  "pass" DOUBLE,
  "run" DOUBLE,
  "exp_sack" DOUBLE,
  "penalty" DOUBLE,
  "raw_qbr" DOUBLE,
  "sack" DOUBLE
);

College Statistics

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.college_statistics

154.75 KB
66672 rows
13 columns


CREATE TABLE college_statistics (
  "player_id" BIGINT,
  "alt_player_id" BIGINT,
  "player_name" VARCHAR,
  "pos_abbr" VARCHAR,
  "school" VARCHAR,
  "school_abbr" VARCHAR,
  "school_primary_color" VARCHAR,
  "school_alt_color" VARCHAR,
  "season" BIGINT,
  "statistic" VARCHAR,
  "value" DOUBLE,
  "active" BOOLEAN,
  "all_star" BOOLEAN
);

Ids

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.ids

8.8 KB
236 rows
3 columns


CREATE TABLE ids (
  "espn_id" BIGINT,
  "player_name" VARCHAR,
  "nflfastr_id" VARCHAR
);

Nfl Draft Profiles

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.nfl_draft_profiles

2.73 MB
12905 rows
21 columns


CREATE TABLE nfl_draft_profiles (
  "player_id" BIGINT,
  "guid" VARCHAR,
  "alt_player_id" DOUBLE,
  "player_name" VARCHAR,
  "position" VARCHAR,
  "pos_abbr" VARCHAR,
  "weight" BIGINT,
  "height" DOUBLE,
  "player_image" VARCHAR,
  "link" VARCHAR,
  "school_logo" VARCHAR,
  "school" VARCHAR,
  "school_abbr" VARCHAR,
  "school_name" VARCHAR,
  "pos_rk" DOUBLE,
  "ovr_rk" DOUBLE,
  "grade" DOUBLE,
  "text1" VARCHAR,
  "text2" VARCHAR,
  "text3" VARCHAR,
  "text4" VARCHAR
);

Nfl Draft Prospects

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.nfl_draft_prospects

714.51 KB
13354 rows
24 columns


CREATE TABLE nfl_draft_prospects (
  "draft_year" BIGINT,
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "position" VARCHAR,
  "pos_abbr" VARCHAR,
  "school" VARCHAR,
  "school_name" VARCHAR,
  "school_abbr" VARCHAR,
  "link" VARCHAR,
  "pick" DOUBLE,
  "overall" DOUBLE,
  "round" DOUBLE,
  "traded" VARCHAR,
  "trade_note" VARCHAR,
  "team" VARCHAR,
  "team_abbr" VARCHAR,
  "team_logo_espn" VARCHAR,
  "guid" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "pos_rk" DOUBLE,
  "ovr_rk" DOUBLE,
  "grade" DOUBLE,
  "player_image" VARCHAR
);