NFL Play Statistics Dataset (primary)

playerid PlayerId	draft Draft	round Round	pick Pick	drafttradevalue DraftTradeValue	draftteam DraftTeam	position Position	teamid TeamId	namefirst NameFirst	namelast NameLast	namefull NameFull	collegeid CollegeId	nflid NflId	college College	heightinches HeightInches	weight Weight	dob Dob	ageatdraft AgeAtDraft	playerprofileurl PlayerProfileUrl	homecity HomeCity	homestate HomeState	homecountry HomeCountry	highschool HighSchool	hscity HsCity	hsstate HsState	hscountry HsCountry
19770001	1977	1	1	3000	TB	RB	4900	Ricky	Bell	Ricky Bell	90089	2509366	USC	74	220	Fri Apr 08 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	22.084931506849315	http://www.nfl.com/player/RickyBell/2509366/profile	Houston	TX	USA	nan	nan	nan	nan
19770002	1977	1	2	2600	DAL	RB	1200	Tony	Dorsett	Tony Dorsett	15260	2513084	Pittsburgh	71	192	Wed Apr 07 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	23.087671232876712	http://www.nfl.com/player/TonyDorsett/2513084/profile	Rochester	PA	USA	nan	nan	nan	nan
19770003	1977	1	3	2200	CIN	DE	920	Eddie	Edwards	Eddie Edwards	33124	2513479	Miami (FL)	77	256	Sun Apr 25 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	23.03835616438356	http://www.nfl.com/player/EddieEdwards/2513479/profile	Sumter	SC	USA	nan	nan	nan	nan
19770004	1977	1	4	1800	NYJ	OT	3430	Marvin	Powell	Marvin Powell	90089	2523462	USC	77	268	Tue Aug 30 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	21.69041095890411	http://www.nfl.com/player/MarvinPowell/2523462/profile	Los Angeles	CA	USA	nan	nan	nan	nan
19770005	1977	1	5	1700	NYG	DE	3410	Gary	Jeter	Gary Jeter	90089	2517530	USC	76	259	Mon Jan 24 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	22.28767123287671	http://www.nfl.com/player/GaryJeter/2517530/profile	Weirton	WV	USA	nan	nan	nan	nan
19770006	1977	1	6	1600	ATL	OT	200	Warren	Bryant	Warren Bryant	40506	2510562	Kentucky	78	273	Fri Nov 11 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	21.49041095890411	http://www.nfl.com/player/WarrenBryant/2510562/profile	Miami	FL	USA	nan	nan	nan	nan
19770007	1977	1	7	1500	NO	DE	3300	Joe	Campbell	Joe Campbell	20740	2510983	Maryland	78	254	Sun May 08 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	22.0027397260274	http://www.nfl.com/player/JoeCampbell/2510983/profile	Wilmington	DE	USA	nan	nan	nan	nan
19770008	1977	1	8	1400	CIN	DT	920	Wilson	Whitley	Wilson Whitley	77006	2528733	Houston	75	265	Thu Apr 28 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	22.03013698630137	http://www.nfl.com/player/WilsonWhitley/2528733/profile	Brenham	TX	USA	nan	nan	nan	nan
19770009	1977	1	9	1350	GB	DE	1800	Mike	Butler	Mike Butler	66045	2510834	Kansas	77	265	Sun Apr 04 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	23.095890410958905	http://www.nfl.com/player/MikeButler/2510834/profile	Washington	DC	USA	nan	nan	nan	nan
19770010	1977	1	10	1300	KC	DB	2310	Gary	Green	Gary Green	76706	2515266	Baylor	71	187	Sat Oct 22 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	21.54520547945205	http://www.nfl.com/player/GaryGreen/2515266/profile	San Antonio	TX	USA	nan	nan	nan	nan


CREATE TABLE draft (
  "playerid" BIGINT,
  "draft" BIGINT,
  "round" DOUBLE,
  "pick" BIGINT,
  "drafttradevalue" DOUBLE,
  "draftteam" VARCHAR,
  "position" VARCHAR,
  "teamid" BIGINT,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "collegeid" BIGINT,
  "nflid" DOUBLE,
  "combineid" DOUBLE,
  "college" VARCHAR,
  "heightinches" DOUBLE,
  "weight" DOUBLE,
  "dob" TIMESTAMP,
  "ageatdraft" DOUBLE,
  "playerprofileurl" VARCHAR,
  "homecity" VARCHAR,
  "homestate" VARCHAR,
  "homecountry" VARCHAR,
  "highschool" VARCHAR,
  "hscity" VARCHAR,
  "hsstate" VARCHAR,
  "hscountry" VARCHAR
);