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-G0962	1	12:00	DAL		PHX		nan	nan	Start of 1st Period (1:11 PM EST)	period	start							nan
S2223-G0962	1	12:00	DAL		PHX		D. Powell	DAL	Jump Ball Powell vs. Ayton: Tip to Durant	Jump Ball	nan							h
S2223-G0962	1	11:46	DAL		PHX		K. Durant	PHX	Durant Out of Bounds - Bad Pass Turnover Turnover (P1.T1)	Turnover	Out of Bounds - Bad Pass Turnover							v
S2223-G0962	1	11:27	DAL	2	PHX		D. Powell	DAL	Powell 1' Cutting Layup Shot (2 PTS) (Irving 1 AST)	Made Shot	Cutting Layup Shot	10	11	1	1	2	2	h
S2223-G0962	1	11:07	DAL	2	PHX	2	D. Ayton	PHX	Ayton 1' Cutting Dunk Shot (2 PTS) (Booker 1 AST)	Made Shot	Cutting Dunk Shot	2	12	1	1	2	2	v
S2223-G0962	1	10:49	DAL	4	PHX	2	L. Doncic	DAL	Doncic 19' Step Back Jump Shot (2 PTS)	Made Shot	Step Back Jump shot	-179	77	19	1	2	2	h
S2223-G0962	1	10:31	DAL	4	PHX	5	D. Booker	PHX	Booker 24' 3PT Jump Shot (3 PTS) (Paul 1 AST)	Made Shot	Jump Shot	192	152	24	1	3	3	v
S2223-G0962	1	10:16	DAL		PHX		L. Doncic	DAL	MISS Doncic 25' 3PT Jump Shot	Missed Shot	Jump Shot	-202	150	25	1	3		h
S2223-G0962	1	10:14	DAL		PHX		D. Ayton	PHX	Ayton REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0962	1	10:05	DAL		PHX		D. Booker	PHX	MISS Booker 9' Driving Floating Jump Shot	Missed Shot	Driving Floating Jump Shot	-27	88	9	1	2		v


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