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-G0866	1	12:00	GSW		WAS		nan	nan	Start of 1st Period (10:12 PM EST)	period	start							nan
S2223-G0866	1	12:00	GSW		WAS		K. Looney	GSW	Jump Ball Looney vs. Porzingis: Tip to Morris	Jump Ball	nan							h
S2223-G0866	1	11:43	GSW		WAS	2	K. Porzingis	WAS	Porzingis 5' Driving Layup (2 PTS) (Beal 1 AST)	Made Shot	Driving Layup Shot	-38	38	5	1	2	2	v
S2223-G0866	1	11:31	GSW		WAS		K. Thompson	GSW	MISS Thompson 26' 3PT Pullup Jump Shot	Missed Shot	Pullup Jump shot	-93	241	26	1	3		h
S2223-G0866	1	11:29	GSW		WAS		D. Gafford	WAS	Gafford REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0866	1	11:20	GSW		WAS		B. Beal	WAS	MISS Beal 3' Driving Reverse Layup	Missed Shot	Driving Reverse Layup Shot	-22	13	3	1	2		v
S2223-G0866	1	11:19	GSW		WAS		A. Wiggins	GSW	Wiggins REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0866	1	11:15	GSW	2	WAS	2	D. Green	GSW	D. Green 4' Running Layup (2 PTS) (Wiggins 1 AST)	Made Shot	Running Layup Shot	34	11	4	1	2	2	h
S2223-G0866	1	10:58	GSW		WAS		D. Green	GSW	D. Green S.FOUL (P1.T1) (J.Goldenberg)	Foul	Shooting							h
S2223-G0866	1	10:58	GSW	2	WAS	3	K. Porzingis	WAS	Porzingis Free Throw 1 of 2 (3 PTS)	Free Throw	Free Throw 1 of 2					1	1	v


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