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-G0165	1	12:00	TOR		HOU		nan	nan	Start of 1st Period (7:41 PM EST)	period	start							nan
S2223-G0165	1	12:00	TOR		HOU		C. Koloko	TOR	Jump Ball Koloko vs. Sengun: Tip to Barnes	Jump Ball	nan							h
S2223-G0165	1	11:46	TOR		HOU		F. VanVleet	TOR	MISS VanVleet 27' 3PT Pullup Jump Shot	Missed Shot	Pullup Jump shot	-141	233	27	1	3		h
S2223-G0165	1	11:44	TOR		HOU		S. Barnes	TOR	Barnes REBOUND (Off:1 Def:0)	Rebound	Unknown							h
S2223-G0165	1	11:34	TOR		HOU		S. Barnes	TOR	MISS Barnes 4' Driving Floating Jump Shot	Missed Shot	Driving Floating Jump Shot		39	4	1	2		h
S2223-G0165	1	11:33	TOR		HOU		nan	nan	RAPTORS Rebound	Rebound	Unknown							h
S2223-G0165	1	11:29	TOR	2	HOU		G. Trent Jr.	TOR	Trent Jr. 15' Step Back Jump Shot (2 PTS)	Made Shot	Step Back Jump shot	147	20	15	1	2	2	h
S2223-G0165	1	11:01	TOR	2	HOU	3	E. Gordon	HOU	Gordon 30' 3PT Jump Shot (3 PTS) (Green 1 AST)	Made Shot	Jump Shot	150	260	30	1	3	3	v
S2223-G0165	1	10:38	TOR		HOU		C. Koloko	TOR	MISS Koloko 1' Reverse Layup	Missed Shot	Reverse Layup Shot	13	5	1	1	2		h
S2223-G0165	1	10:37	TOR		HOU		E. Gordon	HOU	Gordon REBOUND (Off:0 Def:1)	Rebound	Unknown							v


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