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-G0574	1	12:00	LAL		MIA		nan	nan	Start of 1st Period (10:11 PM EST)	period	start							nan
S2223-G0574	1	12:00	LAL		MIA		T. Bryant	LAL	Jump Ball Bryant vs. Adebayo: Tip to Schroder	Jump Ball	nan							h
S2223-G0574	1	11:46	LAL		MIA		A. Reaves	LAL	MISS Reaves 3PT Jump Shot	Missed Shot	Jump Shot	-227	22		1	3		h
S2223-G0574	1	11:42	LAL		MIA		T. Herro	MIA	Herro REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0574	1	11:33	LAL		MIA		B. Adebayo	MIA	MISS Adebayo 17' Jump Shot	Missed Shot	Jump Shot	-83	147	17	1	2		v
S2223-G0574	1	11:29	LAL		MIA		A. Reaves	LAL	Reaves REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0574	1	11:25	LAL	2	MIA		P. Beverley	LAL	Beverley 5' Running Layup (2 PTS)	Made Shot	Running Layup Shot	32	43	5	1	2	2	h
S2223-G0574	1	11:10	LAL	2	MIA	2	K. Lowry	MIA	Lowry 9' Driving Floating Jump Shot (2 PTS) (Adebayo 1 AST)	Made Shot	Driving Floating Jump Shot	4	85	9	1	2	2	v
S2223-G0574	1	10:54	LAL		MIA		T. Bryant	LAL	MISS Bryant 14' Jump Shot	Missed Shot	Jump Shot	-138	10	14	1	2		h
S2223-G0574	1	10:48	LAL		MIA		B. Adebayo	MIA	Adebayo REBOUND (Off:0 Def:1)	Rebound	Unknown							v


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