NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	away Away	playernamei PlayerNameI	teamtricode TeamTricode	description Description	actiontype ActionType	subtype SubType	xlegacy XLegacy	ylegacy YLegacy	shotdistance ShotDistance	isfieldgoal IsFieldGoal	shotval ShotVal	location Location
S2223-G0020	1	12:00	ATL	ORL	nan	nan	Start of 1st Period (7:41 PM EST)	period	start						nan
S2223-G0020	1	12:00	ATL	ORL	C. Capela	ATL	Jump Ball Capela vs. Carter Jr.: Tip to Wagner	Jump Ball	nan						h
S2223-G0020	1	11:45	ATL	ORL	W. Carter Jr.	ORL	MISS Carter Jr. 19' Jump Shot	Missed Shot	Jump Shot	66	180	19	1	2	v
S2223-G0020	1	11:40	ATL	ORL	J. Collins	ATL	Collins REBOUND (Off:0 Def:1)	Rebound	Unknown						h
S2223-G0020	1	11:32	ATL	ORL	J. Collins	ATL	MISS Collins 6' Fadeaway Jumper	Missed Shot	Fadeaway Jump Shot	53	37	6	1	2	h
S2223-G0020	1	11:28	ATL	ORL	W. Carter Jr.	ORL	Carter Jr. REBOUND (Off:0 Def:1)	Rebound	Unknown						v
S2223-G0020	1	11:15	ATL	ORL	W. Carter Jr.	ORL	MISS Carter Jr. 2' Driving Layup	Missed Shot	Driving Layup Shot	-13	9	2	1	2	v
S2223-G0020	1	11:15	ATL	ORL	C. Capela	ATL	Capela BLOCK (1 BLK)	nan	nan						h
S2223-G0020	1	11:11	ATL	ORL	C. Capela	ATL	Capela REBOUND (Off:0 Def:1)	Rebound	Unknown						h
S2223-G0020	1	11:09	ATL	ORL	T. Young	ATL	MISS Young 33' 3PT Running Pull-Up Jump Shot	Missed Shot	Running Pull-Up Jump Shot	-11	325	33	1	3	h


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