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-G1021	1	12:00	ATL		MIN		nan	nan	Start of 1st Period (7:41 PM EST)	period	start							nan
S2223-G1021	1	12:00	ATL		MIN		C. Capela	ATL	Jump Ball Capela vs. Gobert: Tip to Edwards	Jump Ball	nan							h
S2223-G1021	1	11:46	ATL		MIN		A. Edwards	MIN	MISS Edwards 25' 3PT Jump Shot	Missed Shot	Jump Shot	216	120	25	1	3		v
S2223-G1021	1	11:43	ATL		MIN		C. Capela	ATL	Capela REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G1021	1	11:39	ATL		MIN		T. Young	ATL	Young Lost Ball Turnover (P1.T1)	Turnover	Lost Ball							h
S2223-G1021	1	11:39	ATL		MIN		J. McDaniels	MIN	McDaniels STEAL (1 STL)	nan	nan							v
S2223-G1021	1	11:36	ATL		MIN	2	J. McDaniels	MIN	McDaniels 1' Running Dunk (2 PTS)	Made Shot	Running Dunk Shot	5	6	1	1	2	2	v
S2223-G1021	1	11:18	ATL	2	MIN	2	T. Young	ATL	Young 7' Driving Floating Jump Shot (2 PTS) (Hunter 1 AST)	Made Shot	Driving Floating Jump Shot	-23	63	7	1	2	2	h
S2223-G1021	1	11:08	ATL	2	MIN	4	M. Conley	MIN	Conley 10' Driving Floating Jump Shot (2 PTS)	Made Shot	Driving Floating Jump Shot	9	100	10	1	2	2	v
S2223-G1021	1	10:54	ATL	4	MIN	4	D. Hunter	ATL	Hunter 12' Driving Floating Jump Shot (2 PTS) (Murray 1 AST)	Made Shot	Driving Floating Jump Shot	-42	116	12	1	2	2	h


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