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-G0889	1	12:00	PHI	MEM	nan	nan	Start of 1st Period (7:33 PM EST)	period	start						nan
S2223-G0889	1	12:00	PHI	MEM	J. Embiid	PHI	Jump Ball Embiid vs. Jackson Jr.: Tip to Clarke	Jump Ball	nan						h
S2223-G0889	1	11:41	PHI	MEM	J. Jackson Jr.	MEM	MISS Jackson Jr. 26' 3PT Jump Shot	Missed Shot	Jump Shot	18	261	26	1	3	v
S2223-G0889	1	11:38	PHI	MEM	J. Embiid	PHI	Embiid REBOUND (Off:0 Def:1)	Rebound	Unknown						h
S2223-G0889	1	11:27	PHI	MEM	J. Embiid	PHI	MISS Embiid 3' Driving Layup	Missed Shot	Driving Layup Shot	31	6	3	1	2	h
S2223-G0889	1	11:27	PHI	MEM	B. Clarke	MEM	Clarke BLOCK (1 BLK)	nan	nan						v
S2223-G0889	1	11:27	PHI	MEM	nan	nan	76ERS Rebound	Rebound	Unknown						h
S2223-G0889	1	11:16	PHI	MEM	T. Harris	PHI	MISS Harris 6' Driving Layup	Missed Shot	Driving Layup Shot	58	12	6	1	2	h
S2223-G0889	1	11:16	PHI	MEM	J. Jackson Jr.	MEM	Jackson Jr. BLOCK (1 BLK)	nan	nan						v
S2223-G0889	1	11:14	PHI	MEM	D. Brooks	MEM	Brooks REBOUND (Off:0 Def:1)	Rebound	Unknown						v


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