NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	away Away	playernamei PlayerNameI	teamtricode TeamTricode	description Description	actiontype ActionType	subtype SubType	xlegacy XLegacy	ylegacy YLegacy	shotdistance ShotDistance	isfieldgoal IsFieldGoal	shotval ShotVal	location Location
S2223-G0718	1	12:00	PHX	CHA	nan	nan	Start of 1st Period (9:11 PM EST)	period	start						nan
S2223-G0718	1	12:00	PHX	CHA	B. Biyombo	PHX	Jump Ball Biyombo vs. Plumlee: Tip to McGowens	Jump Ball	nan						h
S2223-G0718	1	11:40	PHX	CHA	M. Plumlee	CHA	MISS Plumlee 2' Dunk	Missed Shot	Dunk Shot	-2	20	2	1	2	v
S2223-G0718	1	11:40	PHX	CHA	B. Biyombo	PHX	Biyombo BLOCK (1 BLK)	nan	nan						h
S2223-G0718	1	11:37	PHX	CHA	B. Biyombo	PHX	Biyombo REBOUND (Off:0 Def:1)	Rebound	Unknown						h
S2223-G0718	1	11:32	PHX	CHA	T. Craig	PHX	MISS Craig 25' 3PT Jump Shot	Missed Shot	Jump Shot	-154	198	25	1	3	h
S2223-G0718	1	11:30	PHX	CHA	C. Johnson	PHX	Johnson REBOUND (Off:1 Def:0)	Rebound	Unknown						h
S2223-G0718	1	11:25	PHX	CHA	M. Bridges	PHX	Bridges Bad Pass Turnover (P1.T1)	Turnover	Bad Pass						h
S2223-G0718	1	11:25	PHX	CHA	P. Washington	CHA	Washington STEAL (1 STL)	nan	nan						v
S2223-G0718	1	11:20	PHX	CHA	T. Rozier	CHA	MISS Rozier 25' 3PT Jump Shot	Missed Shot	Jump Shot	-202	151	25	1	3	v


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