NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	scorehome ScoreHome	away Away	scoreaway ScoreAway	playernamei PlayerNameI	teamtricode TeamTricode	description Description	actiontype ActionType	subtype SubType	xlegacy XLegacy	ylegacy YLegacy	shotdistance ShotDistance	isfieldgoal IsFieldGoal	shotval ShotVal	scoreval ScoreVal	location Location
S2223-G0173	1	12:00	ATL		PHI		nan	nan	Start of 1st Period (7:41 PM EST)	period	start							nan
S2223-G0173	1	12:00	ATL		PHI		C. Capela	ATL	Jump Ball Capela vs. Embiid: Tip to Tucker	Jump Ball	nan							h
S2223-G0173	1	11:43	ATL		PHI	2	T. Harris	PHI	Harris 7' Turnaround Jump Shot (2 PTS)	Made Shot	Turnaround Jump Shot	-67	26	7	1	2	2	v
S2223-G0173	1	11:18	ATL	2	PHI	2	D. Murray	ATL	Murray 18' Pullup Jump Shot (2 PTS)	Made Shot	Pullup Jump shot	34	176	18	1	2	2	h
S2223-G0173	1	10:59	ATL		PHI		J. Embiid	PHI	MISS Embiid 10' Turnaround Fadeaway Shot	Missed Shot	Turnaround Fadeaway shot	36	98	10	1	2		v
S2223-G0173	1	10:56	ATL		PHI		J. Collins	ATL	Collins REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0173	1	10:49	ATL	4	PHI	2	T. Young	ATL	Young 9' Layup (2 PTS)	Made Shot	Layup Shot	2	85	9	1	2	2	h
S2223-G0173	1	10:49	ATL		PHI		P. Tucker	PHI	Tucker S.FOUL (P1.T1) (M.Boland)	Foul	Shooting							v
S2223-G0173	1	10:49	ATL	5	PHI	2	T. Young	ATL	Young Free Throw 1 of 1 (3 PTS)	Free Throw	Free Throw 1 of 1					1	1	h
S2223-G0173	1	10:37	ATL	5	PHI	4	J. Embiid	PHI	Embiid 4' Turnaround Hook Shot (2 PTS)	Made Shot	Turnaround Hook Shot	15	37	4	1	2	2	v


CREATE TABLE phi (
  "game_id" VARCHAR,
  "period" BIGINT,
  "clock" VARCHAR,
  "home" VARCHAR,
  "scorehome" DOUBLE,
  "away" VARCHAR,
  "scoreaway" DOUBLE,
  "playernamei" VARCHAR,
  "teamtricode" VARCHAR,
  "description" VARCHAR,
  "actiontype" VARCHAR,
  "subtype" VARCHAR,
  "xlegacy" BIGINT,
  "ylegacy" BIGINT,
  "shotdistance" BIGINT,
  "isfieldgoal" BIGINT,
  "shotval" DOUBLE,
  "scoreval" DOUBLE,
  "location" VARCHAR
);