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-G1164	1	12:00	BKN		UTA	nan	nan	Start of 1st Period (3:41 PM EST)	period	start							nan
S2223-G1164	1	12:00	BKN		UTA	N. Claxton	BKN	Jump Ball Claxton vs. Kessler: Tip to Dinwiddie	Jump Ball	nan							h
S2223-G1164	1	11:37	BKN	2	UTA	N. Claxton	BKN	Claxton 1' Cutting Dunk Shot (2 PTS) (Bridges 1 AST)	Made Shot	Cutting Dunk Shot	-7	4	1	1	2	2	h
S2223-G1164	1	11:09	BKN		UTA	L. Markkanen	UTA	MISS Markkanen 27' 3PT Jump Shot	Missed Shot	Jump Shot	-94	254	27	1	3		v
S2223-G1164	1	11:06	BKN		UTA	M. Bridges	BKN	Bridges REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G1164	1	11:00	BKN		UTA	M. Bridges	BKN	MISS Bridges 12' Pullup Jump Shot	Missed Shot	Pullup Jump shot	-119	-18	12	1	2		h
S2223-G1164	1	10:56	BKN		UTA	W. Kessler	UTA	Kessler REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G1164	1	10:46	BKN		UTA	T. Horton-Tucker	UTA	MISS Horton-Tucker 13' Turnaround Fadeaway Shot	Missed Shot	Turnaround Fadeaway shot	-91	94	13	1	2		v
S2223-G1164	1	10:43	BKN		UTA	C. Johnson	BKN	Johnson REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G1164	1	10:29	BKN	4	UTA	N. Claxton	BKN	Claxton 10' Floating Jump Shot (4 PTS) (Finney-Smith 1 AST)	Made Shot	Floating Jump shot	102	-2	10	1	2	2	h


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