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-G0333	1	12:00	SAS		NOP		nan	nan	Start of 1st Period (8:11 PM EST)	period	start							nan
S2223-G0333	1	12:00	SAS		NOP		Z. Collins	SAS	Jump Ball Collins vs. Valanciunas: Tip to Jones	Jump Ball	nan							h
S2223-G0333	1	11:47	SAS		NOP		K. Johnson	SAS	MISS K. Johnson 25' 3PT Jump Shot	Missed Shot	Jump Shot	189	166	25	1	3		h
S2223-G0333	1	11:44	SAS		NOP		Z. Williamson	NOP	Williamson REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0333	1	11:38	SAS		NOP		C. McCollum	NOP	MISS McCollum 26' 3PT Pullup Jump Shot	Missed Shot	Pullup Jump shot	-118	228	26	1	3		v
S2223-G0333	1	11:34	SAS		NOP		Z. Collins	SAS	Collins REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0333	1	11:21	SAS		NOP		D. Vassell	SAS	MISS Vassell 25' 3PT Jump Shot	Missed Shot	Jump Shot	48	247	25	1	3		h
S2223-G0333	1	11:19	SAS		NOP		J. Valanciunas	NOP	Valanciunas REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0333	1	11:02	SAS		NOP	2	J. Valanciunas	NOP	Valanciunas 19' Jump Shot (2 PTS) (McCollum 1 AST)	Made Shot	Jump Shot	126	137	19	1	2	2	v
S2223-G0333	1	10:42	SAS	3	NOP	2	D. Vassell	SAS	Vassell 26' 3PT Jump Shot (3 PTS) (K. Johnson 1 AST)	Made Shot	Jump Shot	92	241	26	1	3	3	h


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