NBA Enhanced Box Score And Standings (2012 - 2018)
Box Scores and Standings stats with advanced calculations
@kaggle.pablote_nba_enhanced_stats
Box Scores and Standings stats with advanced calculations
@kaggle.pablote_nba_enhanced_stats
CREATE TABLE n_2012_18_officialboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm" VARCHAR,
"offfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT,
"opptpts8" BIGINT,
"oppttreb" DOUBLE,
"opptasst" DOUBLE,
"opptts" DOUBLE
);
CREATE TABLE n_2012_18_playerboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"playlnm" VARCHAR,
"playfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teamdayoff" BIGINT,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"playdispnm" VARCHAR,
"playstat" VARCHAR,
"playmin" BIGINT,
"playpos" VARCHAR,
"playheight" BIGINT,
"playweight" BIGINT,
"playbdate" TIMESTAMP,
"playpts" BIGINT,
"playast" BIGINT,
"playto" BIGINT,
"playstl" BIGINT,
"playblk" BIGINT,
"playpf" BIGINT,
"playfga" BIGINT,
"playfgm" BIGINT,
"playfg" DOUBLE,
"play2pa" BIGINT,
"play2pm" BIGINT,
"play2p" DOUBLE,
"play3pa" BIGINT,
"play3pm" BIGINT,
"play3p" DOUBLE,
"playfta" BIGINT,
"playftm" BIGINT,
"playft" DOUBLE,
"playorb" BIGINT,
"playdrb" BIGINT,
"playtrb" BIGINT,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptdayoff" BIGINT
);
CREATE TABLE n_2012_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
);
CREATE TABLE n_2012_18_teamboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT
);
CREATE TABLE n_2016_17_officialboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm" VARCHAR,
"offfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT,
"opptpts8" BIGINT,
"oppttreb" DOUBLE,
"opptasst" DOUBLE,
"opptts" DOUBLE
);
CREATE TABLE n_2016_17_playerboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"playlnm" VARCHAR,
"playfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teamdayoff" BIGINT,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"playdispnm" VARCHAR,
"playstat" VARCHAR,
"playmin" BIGINT,
"playpos" VARCHAR,
"playheight" BIGINT,
"playweight" BIGINT,
"playbdate" TIMESTAMP,
"playpts" BIGINT,
"playast" BIGINT,
"playto" BIGINT,
"playstl" BIGINT,
"playblk" BIGINT,
"playpf" BIGINT,
"playfga" BIGINT,
"playfgm" BIGINT,
"playfg" DOUBLE,
"play2pa" BIGINT,
"play2pm" BIGINT,
"play2p" DOUBLE,
"play3pa" BIGINT,
"play3pm" BIGINT,
"play3p" DOUBLE,
"playfta" BIGINT,
"playftm" BIGINT,
"playft" DOUBLE,
"playorb" BIGINT,
"playdrb" BIGINT,
"playtrb" BIGINT,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptdayoff" BIGINT
);
CREATE TABLE n_2016_17_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
);
CREATE TABLE n_2016_17_teamboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT
);
CREATE TABLE n_2017_18_officialboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm" VARCHAR,
"offfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT,
"opptpts8" BIGINT,
"oppttreb" DOUBLE,
"opptasst" DOUBLE,
"opptts" DOUBLE
);
CREATE TABLE n_2017_18_playerboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"playlnm" VARCHAR,
"playfnm" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teamdayoff" BIGINT,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"playdispnm" VARCHAR,
"playstat" VARCHAR,
"playmin" BIGINT,
"playpos" VARCHAR,
"playheight" BIGINT,
"playweight" BIGINT,
"playbdate" TIMESTAMP,
"playpts" BIGINT,
"playast" BIGINT,
"playto" BIGINT,
"playstl" BIGINT,
"playblk" BIGINT,
"playpf" BIGINT,
"playfga" BIGINT,
"playfgm" BIGINT,
"playfg" DOUBLE,
"play2pa" BIGINT,
"play2pm" BIGINT,
"play2p" DOUBLE,
"play3pa" BIGINT,
"play3pm" BIGINT,
"play3p" DOUBLE,
"playfta" BIGINT,
"playftm" BIGINT,
"playft" DOUBLE,
"playorb" BIGINT,
"playdrb" BIGINT,
"playtrb" BIGINT,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptdayoff" BIGINT
);
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
);
CREATE TABLE n_2017_18_teamboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT
);
CREATE TABLE teamboxscore (
"gmdate" TIMESTAMP,
"gmtime" VARCHAR,
"seastyp" VARCHAR,
"offlnm1" VARCHAR,
"offfnm1" VARCHAR,
"offlnm2" VARCHAR,
"offfnm2" VARCHAR,
"offlnm3" VARCHAR,
"offfnm3" VARCHAR,
"teamabbr" VARCHAR,
"teamconf" VARCHAR,
"teamdiv" VARCHAR,
"teamloc" VARCHAR,
"teamrslt" VARCHAR,
"teammin" BIGINT,
"teamdayoff" BIGINT,
"teampts" BIGINT,
"teamast" BIGINT,
"teamto" BIGINT,
"teamstl" BIGINT,
"teamblk" BIGINT,
"teampf" BIGINT,
"teamfga" BIGINT,
"teamfgm" BIGINT,
"teamfg" DOUBLE,
"team2pa" BIGINT,
"team2pm" BIGINT,
"team2p" DOUBLE,
"team3pa" BIGINT,
"team3pm" BIGINT,
"team3p" DOUBLE,
"teamfta" BIGINT,
"teamftm" BIGINT,
"teamft" DOUBLE,
"teamorb" BIGINT,
"teamdrb" BIGINT,
"teamtrb" BIGINT,
"teampts1" BIGINT,
"teampts2" BIGINT,
"teampts3" BIGINT,
"teampts4" BIGINT,
"teampts5" BIGINT,
"teampts6" BIGINT,
"teampts7" BIGINT,
"teampts8" BIGINT,
"teamtreb" DOUBLE,
"teamasst" DOUBLE,
"teamts" DOUBLE,
"teamefg" DOUBLE,
"teamoreb" DOUBLE,
"teamdreb" DOUBLE,
"teamto_7b6bd9" DOUBLE,
"teamstl_6034de" DOUBLE,
"teamblk_d02235" DOUBLE,
"teamblkr" DOUBLE,
"teampps" DOUBLE,
"teamfic" DOUBLE,
"teamfic40" DOUBLE,
"teamortg" DOUBLE,
"teamdrtg" DOUBLE,
"teamediff" DOUBLE,
"teamplay" DOUBLE,
"teamar" DOUBLE,
"teamast_to" DOUBLE,
"teamstl_to" DOUBLE,
"opptabbr" VARCHAR,
"opptconf" VARCHAR,
"opptdiv" VARCHAR,
"opptloc" VARCHAR,
"opptrslt" VARCHAR,
"opptmin" BIGINT,
"opptdayoff" BIGINT,
"opptpts" BIGINT,
"opptast" BIGINT,
"opptto" BIGINT,
"opptstl" BIGINT,
"opptblk" BIGINT,
"opptpf" BIGINT,
"opptfga" BIGINT,
"opptfgm" BIGINT,
"opptfg" DOUBLE,
"oppt2pa" BIGINT,
"oppt2pm" BIGINT,
"oppt2p" DOUBLE,
"oppt3pa" BIGINT,
"oppt3pm" BIGINT,
"oppt3p" DOUBLE,
"opptfta" BIGINT,
"opptftm" BIGINT,
"opptft" DOUBLE,
"opptorb" BIGINT,
"opptdrb" BIGINT,
"oppttrb" BIGINT,
"opptpts1" BIGINT,
"opptpts2" BIGINT,
"opptpts3" BIGINT,
"opptpts4" BIGINT,
"opptpts5" BIGINT,
"opptpts6" BIGINT,
"opptpts7" BIGINT
);
Anyone who has the link will be able to view this.