NBA Enhanced Box Score And Standings (2012 - 2018)

stdate StDate	teamabbr TeamAbbr	rank Rank	rankord RankOrd	gamewon GameWon	gamelost GameLost	stk Stk	stktype StkType	stktot StkTot	gameback GameBack	ptsfor PtsFor	ptsagnst PtsAgnst	homewin HomeWin	homeloss HomeLoss	awayloss AwayLoss	confwin ConfWin	confloss ConfLoss	lastfive LastFive	lastten LastTen	gameplay GamePlay	ptsscore PtsScore	ptsallow PtsAllow	ptsdiff PtsDiff	mov Mov	srs Srs	pw Pw%	pyth_13_91 Pyth%13.91	wpyth13_91 Wpyth13.91	lpyth13_91 Lpyth13.91	pyth_16_5 Pyth%16.5	wpyth16_5 Wpyth16.5	lpyth16_5 Lpyth16.5
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ATL	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BKN	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BOS	15	15th		1	L1	loss	1	1	99	102			1		1			1	99	102	-3	-3	-3	0.4012	0.3977	32.6114	49.3886	0.3793	31.1026	50.8974
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	CHA	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	CHI	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	CLE	1	1st	1		W1	win	1		102	99	1			1		1	1	1	102	99	3	3	3	0.5988	0.6023	49.3886	32.6114	0.6207	50.8974	31.1026
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	DAL	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	DEN	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	DET	2	2nd			-	-		0.5																0.5			82			82
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	GS	15	15th		1	L1	loss	1	1	121	122		1			1			1	121	122	-1	-1	-1	0.4671	0.4714	38.6548	43.3452	0.4661	38.2202	43.7798


CREATE TABLE n_2017_18_standings (
  "stdate" TIMESTAMP,
  "teamabbr" VARCHAR,
  "rank" BIGINT,
  "rankord" VARCHAR,
  "gamewon" BIGINT,
  "gamelost" BIGINT,
  "stk" VARCHAR,
  "stktype" VARCHAR,
  "stktot" BIGINT,
  "gameback" DOUBLE,
  "ptsfor" BIGINT,
  "ptsagnst" BIGINT,
  "homewin" BIGINT,
  "homeloss" BIGINT,
  "awaywin" BIGINT,
  "awayloss" BIGINT,
  "confwin" BIGINT,
  "confloss" BIGINT,
  "lastfive" BIGINT,
  "lastten" BIGINT,
  "gameplay" BIGINT,
  "ptsscore" DOUBLE,
  "ptsallow" DOUBLE,
  "ptsdiff" DOUBLE,
  "opptgmplay" BIGINT,
  "opptgmwon" BIGINT,
  "opptopptgmplay" BIGINT,
  "opptopptgmwon" BIGINT,
  "sos" DOUBLE,
  "rel_indx" DOUBLE,
  "mov" DOUBLE,
  "srs" DOUBLE,
  "pw" DOUBLE,
  "pyth_13_91" DOUBLE,
  "wpyth13_91" DOUBLE,
  "lpyth13_91" DOUBLE,
  "pyth_16_5" DOUBLE,
  "wpyth16_5" DOUBLE,
  "lpyth16_5" DOUBLE
);