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-G1109	1	12:00	DEN		MIL		nan	nan	Start of 1st Period (9:12 PM EST)	period	start							nan
S2223-G1109	1	12:00	DEN		MIL		N. Jokic	DEN	Jump Ball Jokic vs. Lopez: Tip to Gordon	Jump Ball	nan							h
S2223-G1109	1	11:48	DEN	2	MIL		N. Jokic	DEN	Jokic 18' Jump Shot (2 PTS) (Murray 1 AST)	Made Shot	Jump Shot	157	83	18	1	2	2	h
S2223-G1109	1	11:30	DEN		MIL		J. Holiday	MIL	MISS Holiday 26' 3PT Pullup Jump Shot	Missed Shot	Pullup Jump shot	-6	264	26	1	3		v
S2223-G1109	1	11:28	DEN		MIL		A. Gordon	DEN	Gordon REBOUND (Off:0 Def:1)	Rebound	Unknown							h
S2223-G1109	1	11:15	DEN		MIL		N. Jokic	DEN	Jokic Lost Ball Turnover (P1.T1)	Turnover	Lost Ball							h
S2223-G1109	1	11:15	DEN		MIL		G. Antetokounmpo	MIL	G. Antetokounmpo STEAL (1 STL)	nan	nan							v
S2223-G1109	1	11:10	DEN	2	MIL	2	G. Antetokounmpo	MIL	G. Antetokounmpo 1' Running Dunk (2 PTS) (Holiday 1 AST)	Made Shot	Running Dunk Shot	-5	5	1	1	2	2	v
S2223-G1109	1	10:53	DEN		MIL		J. Murray	DEN	Murray Bad Pass Turnover (P1.T2)	Turnover	Bad Pass							h
S2223-G1109	1	10:53	DEN		MIL		J. Holiday	MIL	Holiday STEAL (1 STL)	nan	nan							v


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