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

Nfl Draft Prospects

@kaggle.jacklichtenstein_espn_nfl_draft_prospect_data.nfl_draft_prospects

714.51 KB
13354 rows
24 columns

draft_year Draft Year	player_id Player Id	player_name Player Name	position Position	pos_abbr Pos Abbr	school School	school_name School Name	school_abbr School Abbr	link Link	pick Pick	overall Overall	round Round	traded Traded	trade_note Trade Note	team Team	team_abbr Team Abbr	team_logo_espn Team Logo Espn	guid Guid	player_image Player Image
1967	23590	Bubba Smith	Defensive End	DE	Michigan State	Spartans	MSU	http://insider.espn.com/nfl/draft/player/_/id/23590	1	1	1	False	from New Orleans	Baltimore Colts	IND	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/ind.png	nan	nan
1967	23591	Clinton Jones	Running Back	RB	Michigan State	Spartans	MSU	http://insider.espn.com/nfl/draft/player/_/id/23591	2	2	1	False	from N.Y. Giants	Minnesota Vikings	MIN	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/min.png	nan	nan
1967	23592	Steve Spurrier	Quarterback	QB	Florida	Gators	FLA	http://insider.espn.com/nfl/draft/player/_/id/23592	3	3	1	False	from Atlanta	San Francisco 49ers	SF	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/sf.png	nan	nan
1967	23593	Bob Griese	Quarterback	QB	Purdue	Boilermakers	PUR	http://insider.espn.com/nfl/draft/player/_/id/23593	4	4	1	False	nan	Miami Dolphins	MIA	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/mia.png	nan	nan
1967	23594	George Webster	Linebacker	LB	Michigan State	Spartans	MSU	http://insider.espn.com/nfl/draft/player/_/id/23594	5	5	1	False	nan	Houston Oilers	TEN	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/ten.png	nan	nan
1967	23595	Floyd Little	Running Back	RB	Syracuse	Orange	SYR	http://insider.espn.com/nfl/draft/player/_/id/23595	6	6	1	False	nan	Denver Broncos	DEN	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/den.png	nan	nan
1967	23596	Mel Farr	Running Back	RB	UCLA	Bruins	UCLA	http://insider.espn.com/nfl/draft/player/_/id/23596	7	7	1	False	nan	Detroit Lions	DET	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/det.png	nan	nan
1967	23597	Gene Washington	Wide Receiver	WR	Michigan State	Spartans	MSU	http://insider.espn.com/nfl/draft/player/_/id/23597	8	8	1	False	nan	Minnesota Vikings	MIN	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/min.png	nan	nan
1967	23598	Bob Hyland	nan	nan	Boston College	Eagles	BC	http://insider.espn.com/nfl/draft/player/_/id/23598	9	9	1	False	from Pittsburgh	Green Bay Packers	GB	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/gb.png	nan	nan
1967	23599	Loyd Phillips	Defensive End	DE	Arkansas	Razorbacks	ARK	http://insider.espn.com/nfl/draft/player/_/id/23599	10	10	1	False	nan	Chicago Bears	CHI	https://a.espncdn.com/i/teamlogos/nfl/500/scoreboard/chi.png	nan	nan


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