NFL Play Statistics Dataset (primary)

gamepartid GamePartId	gameid GameId	teamid TeamId	playerid PlayerId	gamepartunit GamePartUnit	gamepartsnapcount GamePartSnapCount	namefirst NameFirst	namelast NameLast	namefull NameFull	position Position	collegeid CollegeId	nflid NflId	combineid CombineId	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
12100001	56473	3800	20140091	offense	39	John	Brown	John Brown	WR	66762	2543847	18301	Pittsburg State (KS)	71	179	Tue Apr 03 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	24.112328767123287	http://www.nfl.com/player/JohnBrown/2543847/profile	Homestead	FL	USA	Homestead HS	nan	FL	USA
12100002	56473	3800	20100645	offense	33	John	Estes	John Estes	C	96813	2507981		Hawaii	74	293	Wed Mar 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	23.09315068493151	http://www.nfl.com/player/JohnEstes/2507981/profile	Stockton	CA	USA	St. Mary's HS	Stockton	CA	USA
12100003	56473	3800	20120112	offense	30	Bobby	Massie	Bobby Massie	OT	38677	2533543	17840	Mississippi	78	317	Tue Aug 01 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	22.75068493150685	http://www.nfl.com/player/BobbyMassie/2533543/profile	Lynchburg	VA	USA	Hargrave Military Academy	Chatham	VA	USA
12100004	56473	3800	20100205	offense	30	Ted	Larsen	Ted Larsen	OG	27607	497026	17200	NC State	75	320	Sat Jun 13 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	22.873972602739727	http://www.nfl.com/player/TedLarsen/497026/profile	Miami	FL	USA	Palm Harbor University HS	nan	FL	USA
12100005	56473	3800	20090213	offense	30	Paul	Fanaika	Paul Fanaika	OG	85287	71293	16847	Arizona State	77	327	Wed Apr 09 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	23.06027397260274	http://www.nfl.com/player/PaulFanaika/71293/profile	San Mateo	CA	USA	Mills HS	Millbrae	CA	USA
12100006	56473	3800	20100069	offense	30	Jared	Veldheer	Jared Veldheer	OT	49242	497061	17312	Hillsdale (MI)	80	321	Sun Jun 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	22.87123287671233	http://www.nfl.com/player/JaredVeldheer/497061/profile	Grand Rapids	MI	USA	Forest Hills Northern HS	Grand Rapids	MI	USA
12100007	56473	3800	20030001	offense	30	Carson	Palmer	Carson Palmer	QB	90089	2505245	15309	USC	77	235	Thu Dec 27 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	23.34520547945205	http://www.nfl.com/player/CarsonPalmer/2505245/profile	Fresno	CA	USA	Santa Margarita HS	Rancho Santa Margarita	CA	USA
12100008	56473	3800	20070680	offense	30	Lyle	Sendlein	Lyle Sendlein	OG	78712	2507273		Texas	75	308	Fri Mar 16 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	23.13150684931507	http://www.nfl.com/player/LyleSendlein/2507273/profile	Edina	MN	USA	Chaparral HS	Scottsdale	AZ	USA
12100009	56473	3800	20120716	offense	29	Brittan	Golden	Brittan Golden	WR	79016	2535988		West Texas A&M	71	186	Wed Jul 20 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	23.78356164383561	http://www.nfl.com/player/BrittanGolden/2535988/profile	Plainview	TX	USA	Denver City HS	nan	TX	USA
12100010	56473	3800	20120013	offense	28	Michael	Floyd	Michael Floyd	WR	46556	2532841	17734	Notre Dame	75	220	Mon Nov 27 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	22.42739726027397	http://www.nfl.com/player/MichaelFloyd/2532841/profile	St. Paul	MN	USA	Cretin-Derham Hall HS	nan	MN	USA


CREATE TABLE gameparticipation (
  "gamepartid" BIGINT,
  "gameid" BIGINT,
  "teamid" BIGINT,
  "playerid" BIGINT,
  "gamepartunit" VARCHAR,
  "gamepartsnapcount" BIGINT,
  "namefirst" VARCHAR,
  "namelast" VARCHAR,
  "namefull" VARCHAR,
  "position" VARCHAR,
  "collegeid" DOUBLE,
  "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
);