NBA Plays From 2022-2023 Season

game_id Game Id	period Period	clock Clock	home Home	scorehome ScoreHome	away Away	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-G0489	1	12:00	DEN		POR	nan	nan	Start of 1st Period (9:12 PM EST)	period	start							nan
S2223-G0489	1	12:00	DEN		POR	N. Jokic	DEN	Jump Ball Jokic vs. Nurkic: Tip to Gordon	Jump Ball	nan							h
S2223-G0489	1	11:36	DEN		POR	D. Lillard	POR	Lillard P.FOUL (P1.T1) (R.Hussey)	Foul	Personal							v
S2223-G0489	1	11:31	DEN		POR	M. Porter Jr.	DEN	MISS Porter Jr. 4' Driving Finger Roll Layup	Missed Shot	Driving Finger Roll Layup Shot	1	41	4	1	2		h
S2223-G0489	1	11:29	DEN		POR	N. Jokic	DEN	Jokic REBOUND (Off:1 Def:0)	Rebound	Unknown							h
S2223-G0489	1	11:23	DEN	3	POR	M. Porter Jr.	DEN	Porter Jr. 25' 3PT Jump Shot (3 PTS) (Jokic 1 AST)	Made Shot	Jump Shot	-140	211	25	1	3	3	h
S2223-G0489	1	10:56	DEN		POR	J. Hart	POR	MISS Hart 25' 3PT Jump Shot	Missed Shot	Jump Shot	-113	226	25	1	3		v
S2223-G0489	1	10:53	DEN		POR	A. Gordon	DEN	Gordon REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0489	1	10:47	DEN	5	POR	N. Jokic	DEN	Jokic 7' Turnaround Hook Shot (2 PTS)	Made Shot	Turnaround Hook Shot	-32	57	7	1	2	2	h
S2223-G0489	1	10:31	DEN		POR	J. Nurkic	POR	Nurkic Lost Ball Turnover (P1.T1)	Turnover	Lost Ball							v


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