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-G0124	1	12:00	BOS		CHI		nan	nan	Start of 1st Period (7:46 PM EST)	period	start							nan
S2223-G0124	1	12:00	BOS		CHI		A. Horford	BOS	Jump Ball Horford vs. Vucevic: Tip to Dosunmu	Jump Ball	nan							h
S2223-G0124	1	11:43	BOS		CHI		D. DeRozan	CHI	MISS DeRozan 15' Pullup Jump Shot	Missed Shot	Pullup Jump shot	119	84	15	1	2		v
S2223-G0124	1	11:39	BOS		CHI		J. Tatum	BOS	Tatum REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G0124	1	11:28	BOS	2	CHI		J. Tatum	BOS	Tatum 3' Cutting Layup Shot (2 PTS) (Horford 1 AST)	Made Shot	Cutting Layup Shot	6	26	3	1	2	2	h
S2223-G0124	1	11:18	BOS	2	CHI	3	P. Williams	CHI	Williams 24' 3PT Jump Shot (3 PTS) (Vucevic 1 AST)	Made Shot	Jump Shot	-232	75	24	1	3	3	v
S2223-G0124	1	10:52	BOS		CHI		J. Tatum	BOS	MISS Tatum 11' Driving Floating Bank Jump Shot	Missed Shot	Driving Floating Bank Jump Shot	-99	40	11	1	2		h
S2223-G0124	1	10:52	BOS		CHI		Z. LaVine	CHI	LaVine REBOUND (Off:0 Def:1)	Rebound	Unknown							v
S2223-G0124	1	10:38	BOS	2	CHI	5	N. Vucevic	CHI	Vucevic 5' Cutting Layup Shot (2 PTS) (Dosunmu 1 AST)	Made Shot	Cutting Layup Shot	-2	46	5	1	2	2	v
S2223-G0124	1	10:13	BOS	4	CHI	5	M. Smart	BOS	Smart 9' Driving Floating Jump Shot (2 PTS) (Horford 2 AST)	Made Shot	Driving Floating Jump Shot	-70	64	9	1	2	2	h


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