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-G1220	1	12:00	NYK		IND		nan	nan	Start of 1st Period (1:13 PM EST)	period	start							nan
S2223-G1220	1	12:00	NYK		IND		M. Robinson	NYK	Jump Ball Robinson vs. Jackson: Tip to Nembhard	Jump Ball	nan							h
S2223-G1220	1	11:39	NYK		IND	2	A. Nembhard	IND	Nembhard 19' Pullup Jump Shot (2 PTS)	Made Shot	Pullup Jump shot	112	159	19	1	2	2	v
S2223-G1220	1	11:16	NYK	2	IND	2	I. Quickley	NYK	Quickley 8' Driving Floating Jump Shot (2 PTS) (Toppin 1 AST)	Made Shot	Driving Floating Jump Shot	-42	69	8	1	2	2	h
S2223-G1220	1	11:00	NYK		IND		A. Nembhard	IND	MISS Nembhard 3' Driving Reverse Layup	Missed Shot	Driving Reverse Layup Shot	-28	10	3	1	2		v
S2223-G1220	1	10:58	NYK		IND		M. Robinson	NYK	Robinson REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G1220	1	10:51	NYK	4	IND	2	O. Toppin	NYK	Toppin 8' Driving Floating Jump Shot (2 PTS) (Quickley 1 AST)	Made Shot	Driving Floating Jump Shot	-40	74	8	1	2	2	h
S2223-G1220	1	10:51	NYK		IND		A. Nesmith	IND	Nesmith S.FOUL (P1.T1) (J.DeRosa)	Foul	Shooting							v
S2223-G1220	1	10:51	NYK		IND		nan	nan	Pacers Timeout: Regular (Reg.1 Short 0)	Timeout	Regular							v
S2223-G1220	1	10:51	NYK	5	IND	2	O. Toppin	NYK	Toppin Free Throw 1 of 1 (3 PTS)	Free Throw	Free Throw 1 of 1					1	1	h


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