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-G0309	1	12:00	DET		NYK		nan	nan	Start of 1st Period (7:11 PM EST)	period	start							nan
S2223-G0309	1	12:00	DET		NYK		M. Bagley III	DET	Jump Ball Bagley III vs. Robinson: Tip to Brunson	Jump Ball	nan							h
S2223-G0309	1	11:42	DET		NYK	2	M. Robinson	NYK	Robinson 1' Dunk (2 PTS) (Barrett 1 AST)	Made Shot	Dunk Shot	-1	-11	1	1	2	2	v
S2223-G0309	1	11:26	DET		NYK		I. Stewart	DET	MISS Stewart 20' Jump Shot	Missed Shot	Jump Shot	91	180	20	1	2		h
S2223-G0309	1	11:23	DET		NYK		Q. Grimes	NYK	Grimes REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0309	1	11:14	DET		NYK		R. Barrett	NYK	MISS Barrett 26' 3PT Jump Shot	Missed Shot	Jump Shot	38	258	26	1	3		v
S2223-G0309	1	11:11	DET		NYK		I. Livers	DET	Livers REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0309	1	10:55	DET		NYK		M. Bagley III	DET	Bagley III Traveling Turnover (P1.T1)	Turnover	Traveling							h
S2223-G0309	1	10:39	DET		NYK	5	J. Randle	NYK	Randle 25' 3PT Jump Shot (3 PTS) (Brunson 1 AST)	Made Shot	Jump Shot	34	243	25	1	3	3	v
S2223-G0309	1	10:27	DET	2	NYK	5	K. Hayes	DET	Hayes 13' Driving Floating Jump Shot (2 PTS)	Made Shot	Driving Floating Jump Shot	-67	116	13	1	2	2	h


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