ESPN NFL Draft Prospect Data

Drafted NFL players from 1967-present with text analysis of over 4000 players

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data

Table List

5 tables(3.69 MB)

Ids

College Statistics

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.college_statistics

154.75 KB
66672 rows
13 columns

player_id Player Id	alt_player_id Alt Player Id	player_name Player Name	pos_abbr Pos Abbr	school School	school_abbr School Abbr	school_primary_color School Primary Color	school_alt_color School Alt Color	season Season	statistic Statistic	value Value	active Active
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Total Tackles	20	true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Solo Tackles	9	true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Assist Tackles	11	true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Passes Defended		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Sacks		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Forced Fumbles		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Interceptions		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Interception Yards		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2015	Interception Touchdowns		true
14420	3915189	Royce Smith	OG	Georgia	UGA	#CC0000	#000000	2016	Total Tackles	95	true


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