NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	scorehome ScoreHome	away Away	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-G0431	1	12:00	CLE		IND	nan	nan	Start of 1st Period (7:42 PM EST)	period	start							nan
S2223-G0431	1	12:00	CLE		IND	J. Allen	CLE	Jump Ball Allen vs. Turner: Tip to Mobley	Jump Ball	nan							h
S2223-G0431	1	11:44	CLE		IND	J. Smith	IND	Smith S.FOUL (P1.T1) (E.Lewis)	Foul	Shooting							v
S2223-G0431	1	11:44	CLE	1	IND	J. Allen	CLE	Allen Free Throw 1 of 2 (1 PTS)	Free Throw	Free Throw 1 of 2					1	1	h
S2223-G0431	1	11:44	CLE	2	IND	J. Allen	CLE	Allen Free Throw 2 of 2 (2 PTS)	Free Throw	Free Throw 2 of 2					1	1	h
S2223-G0431	1	11:25	CLE		IND	A. Nembhard	IND	MISS Nembhard 2' Driving Floating Bank Jump Shot	Missed Shot	Driving Floating Bank Jump Shot	-5	20	2	1	2		v
S2223-G0431	1	11:22	CLE		IND	J. Allen	CLE	Allen REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0431	1	11:19	CLE	4	IND	E. Mobley	CLE	Mobley 1' Running Dunk (2 PTS) (Mitchell 1 AST)	Made Shot	Running Dunk Shot	1	6	1	1	2	2	h
S2223-G0431	1	11:06	CLE		IND	J. Smith	IND	MISS Smith 25' 3PT Jump Shot	Missed Shot	Jump Shot	-20	252	25	1	3		v
S2223-G0431	1	11:03	CLE		IND	E. Mobley	CLE	Mobley REBOUND (Off:0 Def:1)	Rebound	Unknown							h


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