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-G0827	1	12:00	HOU		SAC		nan	nan	Start of 1st Period (8:12 PM EST)	period	start							nan
S2223-G0827	1	12:00	HOU		SAC		A. Sengun	HOU	Jump Ball Sengun vs. Sabonis: Tip to Huerter	Jump Ball	nan							h
S2223-G0827	1	11:39	HOU		SAC	2	D. Sabonis	SAC	Sabonis 5' Turnaround Hook Shot (2 PTS) (Huerter 1 AST)	Made Shot	Turnaround Hook Shot	-9	53	5	1	2	2	v
S2223-G0827	1	11:17	HOU		SAC		J. Green	HOU	MISS Green 9' Driving Floating Bank Jump Shot	Missed Shot	Driving Floating Bank Jump Shot	25	86	9	1	2		h
S2223-G0827	1	11:15	HOU		SAC		K. Martin Jr.	HOU	Martin Jr. REBOUND (Off:1 Def:0)	Rebound	Unknown							h
S2223-G0827	1	11:14	HOU	2	SAC	2	K. Martin Jr.	HOU	Martin Jr. 3' Putback Layup (2 PTS)	Made Shot	Putback Layup Shot	23	17	3	1	2	2	h
S2223-G0827	1	11:03	HOU		SAC		D. Fox	SAC	Fox Bad Pass Turnover (P1.T1)	Turnover	Bad Pass							v
S2223-G0827	1	11:03	HOU		SAC		E. Gordon	HOU	Gordon STEAL (1 STL)	nan	nan							h
S2223-G0827	1	11:00	HOU	4	SAC	2	K. Martin Jr.	HOU	Martin Jr. 2' Running Dunk (4 PTS) (Sengun 1 AST)	Made Shot	Running Dunk Shot	5	20	2	1	2	2	h
S2223-G0827	1	10:38	HOU	4	SAC	4	K. Murray	SAC	Murray 9' Driving Floating Jump Shot (2 PTS) (Fox 1 AST)	Made Shot	Driving Floating Jump Shot	62	69	9	1	2	2	v


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