NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	scorehome ScoreHome	away Away	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-G0523	1	12:00	CHA		OKC	nan	nan	Start of 1st Period (7:11 PM EST)	period	start							nan
S2223-G0523	1	12:00	CHA		OKC	M. Plumlee	CHA	Jump Ball Plumlee vs. Jay. Williams: Tip to Washington	Jump Ball	nan							h
S2223-G0523	1	11:45	CHA	2	OKC	M. Plumlee	CHA	Plumlee 2' Cutting Layup Shot (2 PTS) (Ball 1 AST)	Made Shot	Cutting Layup Shot	2	18	2	1	2	2	h
S2223-G0523	1	11:31	CHA		OKC	J. Williams	OKC	Jay. Williams OFF.Foul (P1) (B.Forte)	Foul	Offensive							v
S2223-G0523	1	11:31	CHA		OKC	J. Williams	OKC	Jay. Williams Offensive Foul Turnover (P1.T1)	Turnover	Offensive Foul Turnover							v
S2223-G0523	1	11:14	CHA	5	OKC	L. Ball	CHA	Ball 30' 3PT Jump Shot (3 PTS) (Hayward 1 AST)	Made Shot	Jump Shot	-121	278	30	1	3	3	h
S2223-G0523	1	10:52	CHA		OKC	J. Williams	OKC	MISS Jay. Williams 26' 3PT Jump Shot	Missed Shot	Jump Shot	-202	158	26	1	3		v
S2223-G0523	1	10:49	CHA		OKC	L. Ball	CHA	Ball REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0523	1	10:44	CHA	7	OKC	P. Washington	CHA	Washington 1' Alley Oop Dunk (2 PTS) (Rozier 1 AST)	Made Shot	Alley Oop Dunk Shot	4	12	1	1	2	2	h
S2223-G0523	1	10:34	CHA		OKC	S. Gilgeous-Alexander	OKC	MISS Gilgeous-Alexander 14' Pullup Jump Shot	Missed Shot	Pullup Jump shot	-81	111	14	1	2		v


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