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-G0077	1	12:00	SAS		CHI	nan	nan	Start of 1st Period (8:41 PM EST)	period	start							nan
S2223-G0077	1	12:00	SAS		CHI	J. Poeltl	SAS	Jump Ball Poeltl vs. Vucevic: Tip to Johnson	Jump Ball	nan							h
S2223-G0077	1	11:37	SAS	3	CHI	K. Johnson	SAS	Johnson 25' 3PT Jump Shot (3 PTS) (Jones 1 AST)	Made Shot	Jump Shot	98	235	25	1	3	3	h
S2223-G0077	1	11:21	SAS		CHI	N. Vucevic	CHI	MISS Vucevic 12' Floating Jump Shot	Missed Shot	Floating Jump shot	-50	110	12	1	2		v
S2223-G0077	1	11:18	SAS		CHI	J. Sochan	SAS	Sochan REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0077	1	11:12	SAS	6	CHI	J. Richardson	SAS	Richardson 27' 3PT Jump Shot (3 PTS) (Sochan 1 AST)	Made Shot	Jump Shot	100	255	27	1	3	3	h
S2223-G0077	1	10:51	SAS		CHI	A. Dosunmu	CHI	MISS Dosunmu 6' Floating Jump Shot	Missed Shot	Floating Jump shot	61	13	6	1	2		v
S2223-G0077	1	10:48	SAS		CHI	K. Johnson	SAS	Johnson REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0077	1	10:35	SAS		CHI	J. Richardson	SAS	MISS Richardson 27' 3PT Jump Shot	Missed Shot	Jump Shot	-137	229	27	1	3		h
S2223-G0077	1	10:32	SAS		CHI	N. Vucevic	CHI	Vucevic REBOUND (Off:0 Def:1)	Rebound	Unknown							v


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