Nflfastr

play_id Play Id	game_id Game Id	old_game_id Old Game Id	home_team Home Team	away_team Away Team	season_type Season Type	week Week	posteam Posteam	posteam_type Posteam Type	defteam Defteam	side_of_field Side Of Field	yardline_100 Yardline 100	game_date Game Date	quarter_seconds_remaining Quarter Seconds Remaining	half_seconds_remaining Half Seconds Remaining	game_seconds_remaining Game Seconds Remaining	game_half Game Half	drive Drive	qtr Qtr	down Down	time Time	yrdln Yrdln	ydstogo Ydstogo	ydsnet Ydsnet	desc Desc	play_type Play Type	yards_gained Yards Gained	shotgun Shotgun	qb_dropback Qb Dropback	pass_location Pass Location	run_location Run Location	run_gap Run Gap	field_goal_result Field Goal Result	kick_distance Kick Distance	extra_point_result Extra Point Result	two_point_conv_result Two Point Conv Result	home_timeouts_remaining Home Timeouts Remaining	away_timeouts_remaining Away Timeouts Remaining	timeout_team Timeout Team	td_team Td Team	posteam_timeouts_remaining Posteam Timeouts Remaining	defteam_timeouts_remaining Defteam Timeouts Remaining	no_score_prob No Score Prob	opp_fg_prob Opp Fg Prob	opp_safety_prob Opp Safety Prob	opp_td_prob Opp Td Prob	fg_prob Fg Prob	safety_prob Safety Prob	td_prob Td Prob	ep Ep	epa Epa	total_home_epa Total Home Epa	total_away_epa Total Away Epa	total_home_rush_epa Total Home Rush Epa	total_away_rush_epa Total Away Rush Epa	total_home_pass_epa Total Home Pass Epa	total_away_pass_epa Total Away Pass Epa	wp Wp	def_wp Def Wp	home_wp Home Wp	away_wp Away Wp	wpa Wpa	home_wp_post Home Wp Post	away_wp_post Away Wp Post	vegas_wp Vegas Wp	vegas_home_wp Vegas Home Wp	total_home_rush_wpa Total Home Rush Wpa
34	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	NYG	30	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	900	1800	3600	Half1	1	1		15:00	NYG 30		2	B.Daluiso kicks 72 yards from NYG 30 to ARI -2. M.Jenkins to ARI 23 for 25 yards (R.Phillips). PENALTY on NYG-B.Short, Offside on Free Kick, 5 yards, enforced at NYG 30 - No Play.	no_play				nan	nan	nan	nan		nan	nan	3	3	nan	nan	3	3																0.3942385613918304	0.6057614386081696	0.6057614386081696	0.3942385613918304				0.2233738452196121	0.7766261547803879
70	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	NYG	25	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	900	1800	3600	Half1	1	1		15:00	NYG 25		2	B.Daluiso kicks 69 yards from NYG 25 to ARI 6. M.Jenkins to ARI 35 for 29 yards (T.Davis, P.Monty).	kickoff				nan	nan	nan	nan	69	nan	nan	3	3	nan	nan	3	3	0.0093709910288453	0.1937064826488495	0.0063336146995425	0.3074414730072021	0.1922670602798462	0.0031566980760544	0.2877236902713775	-0.1486965795047581	0.812261460814625	-0.812261460814625	0.812261460814625					0.3942385613918304	0.6057614386081696	0.6057614386081696	0.3942385613918304	0.0247074961662292	0.5810539424419403	0.4189460575580597	0.2233738452196121	0.7766261547803879
106	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	ARI	65	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	900	1800	3600	Half1	1	1	1	15:00	ARI 35	10	2	(15:00) T.Jones left end to ARI 37 for 2 yards (C.Jones). AC #70 - L.J. Shelton, injured on the play	run	2			nan	left	end	nan		nan	nan	3	3	nan	nan	3	3	0.0087575484067201	0.1614040434360504	0.0057546286843717	0.26312917470932	0.2261667400598526	0.0041649457998573	0.330622911453247	0.6635648813098669	-0.0768500855192542	-0.7354113752953708	0.7354113752953708	0.0768500855192542	-0.0768500855192542			0.4189460575580597	0.5810539424419403	0.5810539424419403	0.4189460575580597	-0.0010689795017242	0.5821229219436646	0.4178770780563354	0.2339376658201217	0.7660623341798782	0.0010689795017242
131	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	ARI	63	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	844	1744	3544	Half1	1	1	2	14:04	ARI 37	8	2	(14:04) J.Plummer pass incomplete to T.Jones.	pass			1	nan	nan	nan	nan		nan	nan	3	3	nan	nan	3	3	0.0128401415422558	0.1563294827938079	0.0027478048577904	0.2655805051326751	0.249079167842865	0.0041871038265526	0.3092358112335205	0.5867147957906127	-0.7652349234558642	0.0298235481604933	-0.0298235481604933	0.0768500855192542	-0.0768500855192542	0.7652349234558642	-0.7652349234558642	0.4178770780563354	0.5821229219436646	0.5821229219436646	0.4178770780563354	-0.0251956284046173	0.6073185503482819	0.3926814496517181	0.2725354433059692	0.7274645566940308	0.0010689795017242
148	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	ARI	63	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	837	1737	3537	Half1	1	1	3	13:57	ARI 37	8	2	(13:57) (Shotgun) J.Plummer pass incomplete to F.Sanders.	pass		1	1	nan	nan	nan	nan		nan	nan	3	3	nan	nan	3	3	0.0132216587662696	0.1861596703529358	0.0028753813821822	0.3087468147277832	0.2135864496231079	0.0043384595774114	0.271071583032608	-0.1785201276652515	-1.3116457997821271	1.3414693479426203	-1.3414693479426203	0.0768500855192542	-0.0768500855192542	2.0768807232379918	-2.0768807232379918	0.3926814496517181	0.6073185503482819	0.6073185503482819	0.3926814496517181	-0.0221847593784332	0.6295033097267151	0.3704966902732849	0.2594973146915436	0.7405026853084564	0.0010689795017242
165	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	ARI	away	NYG	ARI	63	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	832	1732	3532	Half1	1	1	4	13:52	ARI 37	8	2	(13:52) S.Player punts 41 yards to NYG 22, Center-T.Junkin. T.Barber to NYG 22 for no gain (M.Jenkins).	punt				nan	nan	nan	nan	41	nan	nan	3	3	nan	nan	3	3	0.0143546909093856	0.2326735258102417	0.0034277788363397	0.3858028650283813	0.1526639312505722	0.0040403539314866	0.2070368230342865	-1.4901659274473786	0.7927371556870639	0.5487321922555566	-0.5487321922555566	0.0768500855192542	-0.0768500855192542	2.0768807232379918	-2.0768807232379918	0.3704966902732849	0.6295033097267151	0.6295033097267151	0.3704966902732849	0.0349320173263549	0.5945712924003601	0.4054287075996399	0.2265473306179046	0.7734526693820953	0.0010689795017242
190	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	NYG	home	ARI	NYG	78	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	820	1720	3520	Half1	2	1	1	13:40	NYG 22	10	39	(13:40) T.Barber right tackle to NYG 30 for 8 yards (R.McKinnon).	run	8			nan	right	tackle	nan		nan	nan	3	3	nan	nan	3	3	0.0154089787974953	0.1778567284345626	0.0032746272627264	0.2485367655754089	0.2212676256895065	0.0044168950989842	0.3292384147644043	0.6974287717603147	0.7650371892377734	1.31376938149333	-1.31376938149333	0.8418872747570276	-0.8418872747570276	2.0768807232379918	-2.0768807232379918	0.5945712924003601	0.4054287075996399	0.5945712924003601	0.4054287075996399	0.0322089791297912	0.6267802715301514	0.3732197284698486	0.7344047427177429	0.7344047427177429	0.0332779586315155
211	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	NYG	home	ARI	NYG	70	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	820	1720	3520	Half1	2	1	2	13:40	NYG 30	2	39	(13:40) R.Dayne right guard to NYG 33 for 3 yards (R.Thompson, C.Sears).	run	3			nan	right	guard	nan		nan	nan	3	3	nan	nan	3	3	0.0147695494815707	0.1534450501203537	0.0031763988081365	0.2094112485647201	0.2296560555696487	0.0041453936137259	0.3853962421417236	1.462465960998088	0.1220114366151392	1.4357808181084692	-1.4357808181084692	0.9638987113721668	-0.9638987113721668	2.0768807232379918	-2.0768807232379918	0.6267802715301514	0.3732197284698486	0.6267802715301514	0.3732197284698486	0.0144764780998229	0.6412567496299744	0.3587432503700256	0.7503001093864441	0.7503001093864441	0.0477544367313385
232	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	NYG	home	ARI	NYG	67	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	820	1720	3520	Half1	2	1	1	13:40	NYG 33	10	39	(13:40) T.Barber left end pushed ob at NYG 32 for -1 yards (R.McKinnon).	run	-1			nan	left	end	nan		nan	nan	3	3	nan	nan	3	3	0.0149448839947581	0.1443910002708435	0.0023073637858033	0.2011345475912094	0.2514879405498504	0.004879402462393	0.3808549046516418	1.5844773976132274	-0.6401551938615739	0.7956256242468953	-0.7956256242468953	0.3237435175105929	-0.3237435175105929	2.0768807232379918	-2.0768807232379918	0.6412567496299744	0.3587432503700256	0.6412567496299744	0.3587432503700256	-0.029392659664154	0.6118640899658203	0.3881359100341797	0.7467964887619019	0.7467964887619019	0.0183617770671844
253	2000_01_ARI_NYG	2000090300	NYG	ARI	REG	1	NYG	home	ARI	NYG	68	Sun Sep 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	820	1720	3520	Half1	2	1	2	13:40	NYG 32	11	39	(13:40) K.Collins pass to T.Barber to NYG 47 for 15 yards (A.Williams, P.Tillman).	pass	15		1	nan	nan	nan	nan		nan	nan	3	3	nan	nan	3	3	0.0153885008767247	0.170157790184021	0.0035062215756624	0.235297605395317	0.2247027456760406	0.0043693366460502	0.3465777635574341	0.9443222037516534	1.5489790446590632	2.3446046689059585	-2.3446046689059585	0.3237435175105929	-0.3237435175105929	3.625859767897055	-3.625859767897055	0.6118640899658203	0.3881359100341797	0.6118640899658203	0.3881359100341797	0.0447719097137451	0.6566359996795654	0.3433640003204345	0.7380632162094116	0.7380632162094116	0.0183617770671844


CREATE TABLE play_by_play_2000 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);