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-G0061	1	12:00	CHI		IND		nan	nan	Start of 1st Period (8:11 PM EST)	period	start							nan
S2223-G0061	1	12:00	CHI		IND		N. Vucevic	CHI	Jump Ball Vucevic vs. Turner: Tip to Haliburton	Jump Ball	nan							h
S2223-G0061	1	11:37	CHI		IND	2	A. Nesmith	IND	Nesmith 1' Driving Reverse Dunk Shot (2 PTS) (Turner 1 AST)	Made Shot	Driving Reverse Dunk Shot	-11	7	1	1	2	2	v
S2223-G0061	1	11:21	CHI		IND		P. Williams	CHI	MISS Williams 2' Driving Layup	Missed Shot	Driving Layup Shot	-9	22	2	1	2		h
S2223-G0061	1	11:18	CHI		IND		M. Turner	IND	Turner REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0061	1	11:16	CHI		IND	5	B. Hield	IND	Hield 26' 3PT Jump Shot (3 PTS) (Haliburton 1 AST)	Made Shot	Jump Shot	157	204	26	1	3	3	v
S2223-G0061	1	10:56	CHI	3	IND	5	P. Williams	CHI	Williams 25' 3PT Jump Shot (3 PTS) (Dosunmu 1 AST)	Made Shot	Jump Shot	154	197	25	1	3	3	h
S2223-G0061	1	10:44	CHI		IND		J. Smith	IND	MISS Smith 1' Driving Layup	Missed Shot	Driving Layup Shot	-2	13	1	1	2		v
S2223-G0061	1	10:42	CHI		IND		N. Vucevic	CHI	Vucevic REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0061	1	10:33	CHI	5	IND	5	N. Vucevic	CHI	Vucevic 9' Jump Shot (2 PTS) (Dosunmu 2 AST)	Made Shot	Jump Shot	16	89	9	1	2	2	h


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