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-G0470	1	12:00	BKN		GSW		nan	nan	Start of 1st Period (7:41 PM EST)	period	start							nan
S2223-G0470	1	12:00	BKN		GSW		N. Claxton	BKN	Jump Ball Claxton vs. Looney: Tip to Green	Jump Ball	nan							h
S2223-G0470	1	11:41	BKN		GSW		J. Kuminga	GSW	Kuminga Bad Pass Turnover (P1.T1)	Turnover	Bad Pass							v
S2223-G0470	1	11:41	BKN		GSW		J. Harris	BKN	Harris STEAL (1 STL)	nan	nan							h
S2223-G0470	1	11:35	BKN	3	GSW		R. O'Neale	BKN	O'Neale 25' 3PT Jump Shot (3 PTS) (Simmons 1 AST)	Made Shot	Jump Shot	-158	197	25	1	3	3	h
S2223-G0470	1	11:15	BKN		GSW		B. Simmons	BKN	Simmons P.FOUL (P1.T1) (M.Kallio)	Foul	Personal							h
S2223-G0470	1	11:02	BKN	3	GSW	2	D. Green	GSW	Green 2' Cutting Layup Shot (2 PTS) (Kuminga 1 AST)	Made Shot	Cutting Layup Shot	16	-4	2	1	2	2	v
S2223-G0470	1	10:41	BKN	5	GSW	2	N. Claxton	BKN	Claxton 6' Hook Shot (2 PTS) (Durant 1 AST)	Made Shot	Hook Shot	4	55	6	1	2	2	h
S2223-G0470	1	10:29	BKN		GSW		J. Kuminga	GSW	Kuminga Bad Pass Turnover (P2.T2)	Turnover	Bad Pass							v
S2223-G0470	1	10:29	BKN		GSW		N. Claxton	BKN	Claxton STEAL (1 STL)	nan	nan							h


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