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 Timeout	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
35	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	30	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	900	1800	3600	Half1	1	1		15:00	LA 30		53	J.Wilkins kicks 62 yards from STL 30 to ARI 8. J.Scobey to ARI 33 for 25 yards (J.Lucas, A.Harris). PENALTY on ARI-M.Stone, Offensive Holding, 9 yards, enforced at ARI 18.	kickoff				nan	nan	nan	nan	62	nan	nan	3	3		nan	nan	3	3	0.008067388087511	0.1742238700389862	0.0067697642371058	0.3113869726657867	0.1836856305599212	0.0036104640457779	0.3122558891773224	0.0281490967608988	-0.6659456517081708	0.6659456517081708	-0.6659456517081708					0.0002330589632038027	0.9997669410367962	0.9997669410367962	0.0002330589632038027	0.3887909900804516	0.6109759509563446	0.3890240490436554	0.00011879182420670986	0.9998812081757932
68	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	ARI	91	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	895	1795	3595	Half1	1	1	1	14:55	ARI 9	10	53	(14:55) J.McCown pass to L.Fitzgerald to ARI 46 for 37 yards (A.Williams). fleaflicker play.	pass	37		1	nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0082194143906235	0.2049064487218856	0.0164669323712587	0.3375301659107208	0.1619749069213867	0.0019344313768669	0.2689677476882934	-0.6377965549472719	2.414031903957948	-1.748086252249777	1.748086252249777			-2.414031903957948	2.414031903957948	0.3890240490436554	0.6109759509563446	0.6109759509563446	0.3890240490436554	0.0745614767074585	0.5364144742488861	0.4635855257511139	0.1198968216776847	0.8801031783223152
93	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	ARI	54	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	855	1755	3555	Half1	1	1	1	14:15	ARI 46	10	53	(14:15) J.McCown pass incomplete to L.Diamond.	pass			1	nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0091768270358443	0.1150025576353073	0.0026036074850708	0.2072822153568267	0.2645799219608307	0.0051595699042081	0.3961952626705169	1.776235349010676	-0.4934246516786515	-1.2546616005711255	1.2546616005711255			-1.9206072522792963	1.9206072522792963	0.4635855257511139	0.5364144742488861	0.5364144742488861	0.4635855257511139	-0.0217164754867553	0.5581309497356415	0.4418690502643585	0.1945019364356994	0.8054980635643005
112	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	ARI	54	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	849	1749	3549	Half1	1	1	2	14:09	ARI 46	10	53	(14:09) J.McCown pass incomplete to L.Fitzgerald.	pass			1	nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0092877782881259	0.1324196755886078	0.0027242461219429	0.2351401299238205	0.2459337711334228	0.0055525582283735	0.3689418137073517	1.2828106973320246	-0.9043984576128424	-0.3502631429582834	0.3502631429582834			-1.0162087946664542	1.0162087946664542	0.4418690502643585	0.5581309497356415	0.5581309497356415	0.4418690502643585	-0.0365043580532074	0.5946353077888489	0.4053646922111511	0.1779829114675521	0.8220170885324478
131	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	ARI	54	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	846	1746	3546	Half1	1	1	3	14:06	ARI 46	10	53	(14:06) (Shotgun) PENALTY on STL-B.Fisher, Neutral Zone Infraction, 5 yards, enforced at ARI 46 - No Play.	no_play		1		nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.009810128249228	0.1652522534132003	0.002922166371718	0.2857889831066131	0.2106406539678573	0.0060972874052822	0.319488525390625	0.3784122397191822	0.5770977842621505	-0.927360927220434	0.927360927220434			-1.0162087946664542	1.0162087946664542	0.4053646922111511	0.5946353077888489	0.5946353077888489	0.4053646922111511	0.0373139381408691	0.5573213696479797	0.4426786303520202	0.1630279868841171	0.8369720131158829
154	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	49	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	846	1746	3546	Half1	1	1	3	14:06	LA 49	5	53	(14:06) J.McCown pass to B.Johnson to STL 43 for 6 yards (J.Butler).	pass	6		1	nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0099410833790898	0.1414956450462341	0.002829210832715	0.2553100883960724	0.2329380065202713	0.0056779496371746	0.3518080115318298	0.9555100239813328	1.4867476914077995	-2.4141086186282337	2.4141086186282337			-2.502956486074254	2.502956486074254	0.4426786303520202	0.5573213696479797	0.5573213696479797	0.4426786303520202	0.0398272573947906	0.5174941122531891	0.4825058877468109	0.1750576794147491	0.8249423205852509
175	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	43	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	816	1716	3516	Half1	1	1	1	13:36	LA 43	10	53	(13:36) E.Smith up the middle to STL 42 for 1 yard (R.Pickett).	run	1			nan	middle	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0089077977463603	0.087089255452156	0.0025927373208105	0.1699186265468597	0.2995922267436981	0.0047862171195447	0.4271131753921509	2.4422577153891325	-0.3495159959420562	-2.064592622686177	2.064592622686177	0.3495159959420562	-0.3495159959420562	-2.502956486074254	2.502956486074254	0.4825058877468109	0.5174941122531891	0.5174941122531891	0.4825058877468109	-0.0117314159870147	0.5292255282402039	0.4707744717597961	0.2057214081287384	0.7942785918712616	0.0117314159870147
196	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	42	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	769	1669	3469	Half1	1	1	2	12:49	LA 42	9	53	(12:49) J.McCown pass incomplete to L.Fitzgerald (J.Butler).	pass			1	nan	nan	nan	nan		nan	nan	3	3		nan	nan	3	3	0.0092883622273802	0.100193366408348	0.0027477825060486	0.1861092746257782	0.295934110879898	0.0052619245834648	0.4004651606082916	2.0927417194470763	-1.0357280392199757	-1.028864583466202	1.028864583466202	0.3495159959420562	-0.3495159959420562	-1.4672284468542784	1.4672284468542784	0.4707744717597961	0.5292255282402039	0.5292255282402039	0.4707744717597961	-0.0362394750118255	0.5654650032520294	0.4345349967479706	0.2032020390033722	0.7967979609966278	0.0117314159870147
215	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	42	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	761	1661	3461	Half1	1	1		12:41	LA 42		53	Timeout #1 by ARI at 12:41.	no_play				nan	nan	nan	nan		nan	nan	3	2	1	ARI	nan	2	3								1.0570136802271008		-1.028864583466202	1.028864583466202	0.3495159959420562	-0.3495159959420562	-1.4672284468542784	1.4672284468542784	0.4345349967479706	0.5654650032520294	0.5654650032520294	0.4345349967479706		0.5654650032520294	0.4345349967479706	0.1899065971374511	0.8100934028625488	0.0117314159870147
232	2004_01_ARI_STL	2004091208	LA	ARI	REG	1	ARI	away	LA	LA	42	Sun Sep 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	761	1661	3461	Half1	1	1	3	12:41	LA 42	9	53	(12:41) (Shotgun) PENALTY on ARI-L.Davis, False Start, 5 yards, enforced at STL 42 - No Play.	no_play		1		nan	nan	nan	nan		nan	nan	3	2		nan	nan	2	3	0.0121622290462255	0.1367201209068298	0.0032540801912546	0.2407900393009185	0.2634040713310241	0.0073372167535126	0.3363322615623474	1.0570136802271008	-0.7865915112197399	-0.2422730722464621	0.2422730722464621	0.3495159959420562	-0.3495159959420562	-1.4672284468542784	1.4672284468542784	0.4345349967479706	0.5654650032520294	0.5654650032520294	0.4345349967479706	-0.0419130623340606	0.5654650032520294	0.4345349967479706	0.1899065971374511	0.8100934028625488	0.0117314159870147


CREATE TABLE play_by_play_2004 (
  "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
);