fivethirtyeight

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidPlayerPositionIDDraft YearProjected SPMSuperstarStarterRole PlayerBust
1 Karl-Anthony Towns C karl-anthony-towns 2015 1.030605703 0.13476666699999998 0.42718333299999994 0.163083333 0.274966667
2 Justise Winslow SF justise-winslow 2015 0.875328997 0.083528571 0.510904762 0.176766667 0.2288
3 Stanley Johnson SF stanley-johnson 2015 0.679493305 0.0678 0.423733333 0.2785 0.22996666699999999
4 Jahlil Okafor C jahlil-okafor 2015 0.521661276 0.058716667 0.4099 0.235533333 0.29585
5 D`Angelo Russell PG d-angelo-russell 2015 0.511966664 0.15203333300000002 0.34228333299999997 0.09658333300000001 0.4091
6 Dakari Johnson C dakari-johnson 2015 0.491787354 0.021340777999999998 0.36754357 0.41757199700000003 0.193543655
7 Devin Booker SG 3-devin-booker 2015 0.472577305 0.073366667 0.324466667 0.390166667 0.212
8 Willie Cauley-Stein C willie-cauley-stein 2015 0.35117138299999995 0.047114455 0.40598986299999995 0.243185719 0.303709963
9 Rondae Hollis-Jefferson SF rondae-hollis-jefferson 2015 0.311909198 0.014589784 0.36853314299999995 0.392480667 0.22439640600000002
10 Trey Lyles PF trey-lyles 2015 0.26750941100000003 0.022385713999999998 0.35132857100000003 0.403052381 0.223233333
11 Sam Dekker SF sam-dekker 2015 0.254164944 0.008691989 0.38500394600000004 0.32905360100000003 0.277250464
12 Kelly Oubre Jr. SF kelly-oubre-jr 2015 0.24731024699999998 0.019833333 0.378983333 0.33796666700000005 0.263216667
13 Tyus Jones PG tyus-jones 2015 0.24354879699999998 0.0272 0.414561905 0.284404762 0.273833333
14 Kevon Looney PF kevon-looney 2015 0.204173217 0.0083 0.355566667 0.37491666700000004 0.261216667
15 Myles Turner PF 2-myles-turner 2015 0.076381303 0.029416667 0.335797619 0.318516667 0.316269048
16 Cliff Alexander PF cliff-alexander 2015 0.026133537000000002 0.007633333000000001 0.294783333 0.40661666700000004 0.290966667
17 Christian Wood PF christian-wood 2015 -0.019560841000000002 0.008396848 0.31111083 0.393687898 0.286804424
18 Frank Kaminsky C frank-kaminsky 2015 -0.072352472 0.006718361 0.352834529 0.327164489 0.31328262100000004
19 Michael Frazier II SG michael-frazier-ii 2015 -0.16705094 0.010083843 0.254306634 0.381989035 0.35362048799999996
20 Brandon Ashley PF brandon-ashley 2015 -0.170210127 0.011186811999999999 0.253264673 0.35613880200000003 0.379409713
21 Bobby Portis PF bobby-portis 2015 -0.314574233 0.003141375 0.253027047 0.386533364 0.357298214
22 Andrew Harrison PG andrew-harrison 2015 -0.337040592 0.01122782 0.209972569 0.3939911 0.384808511
23 Rashad Vaughn SG rashad-vaughn 2015 -0.342326069 0.020666667 0.242333333 0.3678 0.3692
24 Aaron Harrison SG 3-aaron-harrison 2015 -0.420844124 0.009668813 0.191222705 0.391380191 0.407728291
25 Montrezl Harrell PF montrezl-harrell 2015 -0.436183176 0.003904083 0.20032108399999998 0.41158411899999997 0.384190715
26 Quinn Cook PG quinn-cook 2015 -0.45351841299999995 0.000128454 0.22139455600000002 0.365234166 0.413242824
27 Cameron Payne PG 2-cameron-payne 2015 -0.604344604 0.009530364 0.19008399 0.316887572 0.483498073
28 Chris McCullough PF chris-mccullough 2015 -0.630996181 0.006566666999999999 0.19213333300000002 0.2932 0.5081
29 Justin Anderson SF justin-anderson 2015 -0.635744631 0.000926066 0.157187056 0.412166931 0.42971994700000005
30 Terry Rozier PG terry-rozier 2015 -0.637633814 0.007467100999999999 0.188247503 0.299670223 0.504615174
31 Vince Hunter SF vince-hunter 2015 -0.644930502 0.0039991309999999995 0.145082443 0.385996989 0.46492143700000005
32 Delon Wright PG delon-wright 2015 -0.666006064 0.0026507040000000003 0.169565987 0.35993691299999997 0.467846395
33 Jarell Martin PF jarell-martin 2015 -0.7217396640000001 0.0014716360000000001 0.15872561699999999 0.35777267799999996 0.482030069
34 Jordan Mickey PF jordan-mickey 2015 -0.745960108 0.0014437870000000002 0.144665538 0.37433251799999995 0.47955815799999996
35 Wayne Blackshear SG wayne-blackshear 2015 -0.750833557 0.001026966 0.11546061099999999 0.433883586 0.449628838
36 Chris Walker PF 5-chris-walker 2015 -0.75113066 0.001166667 0.157566667 0.35343333299999996 0.487833333
37 T.J. McConnell PG tj-mcconnell 2015 -0.760484149 0.002670752 0.102511805 0.43556844 0.459249003
38 J.P. Tokoto SF jp-tokoto 2015 -0.785873736 0.0006736289999999999 0.107998383 0.431220506 0.460107482
39 Pat Connaughton SF pat-connaughton 2015 -0.8337818709999999 0.000664804 0.08891347 0.432599715 0.47782201
40 R.J. Hunter SG rj-hunter 2015 -0.836776877 0.004112703 0.12123949099999999 0.385605421 0.489042385
41 Jerian Grant PG jerian-grant 2015 -0.869777062 0.001169979 0.130352495 0.345982451 0.522495076
42 Olivier Hanlan SG olivier-hanlan 2015 -0.939601082 0.00022736900000000002 0.058708643 0.482292406 0.458771582
43 Branden Dawson SF branden-dawson 2015 -0.94832171 0.000308971 0.09316623800000001 0.39117086100000004 0.51535393
44 Robert Upshaw C robert-upshaw 2015 -0.953017497 0.00021639400000000002 0.088032316 0.38180529 0.529946
45 Tyler Harvey SG tyler-harvey 2015 -0.963286998 0.0 0.045680357000000005 0.485580914 0.46873872899999997
46 Darrun Hilliard SG darrun-hilliard 2015 -0.997597057 0.001336934 0.058581954000000006 0.430904831 0.509176281
47 Tyler Haws SG tyler-haws 2015 -1.014375418 0.0010355639999999999 0.038756025 0.476593937 0.48361447399999996
48 Treveon Graham SG treveon-graham 2015 -1.026896912 0.001371164 0.07552874400000001 0.37948035399999996 0.543619737
49 Rakeem Christmas PF rakeem-christmas 2015 -1.037407078 0.000103674 0.074800607 0.39935904899999997 0.52573667
50 Kenneth Smith PG 3-kenneth-smith 2015 -1.0395478790000001 0.0007467760000000001 0.073520453 0.35809779 0.567634981
51 Michael Qualls SG 3-michael-qualls 2015 -1.041676256 0.005867204 0.056290419 0.39026949 0.5475728879999999
52 Aaron White PF 5-aaron-white 2015 -1.044431359 0.000858212 0.090374546 0.35878840700000003 0.549978835
53 Alan Williams PF 3-alan-williams 2015 -1.051104888 0.00100349 0.027920017999999998 0.44934265100000004 0.52173384
54 Shannon Scott PG shannon-scott 2015 -1.061872742 0.001596119 0.06800875099999999 0.356970581 0.573424549
55 Isaac Fotu PF isaac-fotu 2015 -1.065081918 0.0013180129999999998 0.054936125999999995 0.384945795 0.558800066
56 Keifer Sykes PG keifer-sykes 2015 -1.083833575 0.002417356 0.04982042 0.387609233 0.560152991
57 Juwan Staten PG juawn-staten 2015 -1.095315539 0.00047684400000000003 0.038064935 0.414884254 0.546573966
58 Corey Hawkins SG corey-hawkins 2015 -1.096899647 0.00010882200000000001 0.033205484 0.43606985200000004 0.530615842
59 D.J. Newbill SG devonte-newbill 2015 -1.108784009 0.000554941 0.026482771000000002 0.436494657 0.5364676310000001
60 Josh Richardson SG 2-josh-richardson 2015 -1.1250298220000001 0.00013125299999999998 0.056205838 0.376816007 0.566846902
61 Jonathan Holmes SF 2-jonathan-holmes 2015 -1.13357382 0.0 0.053248718 0.365396839 0.5813544429999999
62 Joseph Young SG joseph-young 2015 -1.138828781 8.03961e-05 0.04891635 0.394276343 0.55672691
63 Wesley Saunders SG wesley-saunders 2015 -1.171996457 0.00037318599999999996 0.036596138 0.38704508600000004 0.575985589
64 Richaun Holmes PF richaun-holmes 2015 -1.186744347 0.000357099 0.060157338 0.314633278 0.624852285
65 Anthony Brown SG 3-anthony-brown 2015 -1.187041132 0.0 0.038678905 0.379622804 0.581698291
66 Norman Powell SG norman-powell 2015 -1.189678464 0.0 0.03610954 0.38697547 0.5769149889999999
67 Josh Smith C 9-josh-smith 2015 -1.192473127 0.0 0.026755605 0.382057886 0.591186509
68 Derrick Marks SG derrick-marks 2015 -1.1997864809999998 0.001857445 0.030881673 0.379643412 0.587617469
69 Marcus Thornton SG 2-marcus-thornton 2015 -1.202113387 0.000489255 0.021634511000000002 0.389748446 0.588127788
70 Terran Petteway SG terran-petteway 2015 -1.207198123 0.0 0.035343103 0.367281274 0.597375623
71 Seth Tuttle PF seth-tuttle 2015 -1.221872777 0.0 0.03687377 0.35878530399999997 0.604340925
72 Trevor Lacey SG trevor-lacey 2015 -1.2269165000000002 0.0 0.033303382 0.35775944200000004 0.608937176
73 Dez Wells SG dezmine-wells 2015 -1.244978961 0.000229033 0.022535212000000002 0.384498234 0.59273752
74 Larry Nance, Jr. PF larry-nance-jr 2015 -1.254446537 0.0 0.030613137000000002 0.33979612600000003 0.629590736
75 Sir`Dominic Pointer SF sir-dominic-pointer 2015 -1.301544045 0.0 0.029016181000000002 0.320955511 0.650028307
76 Briante Weber PG briante-weber 2015 -1.308756716 0.004466225999999999 0.037216853 0.286508463 0.671808458
77 Cady Lalanne PF cady-lalanne 2015 -1.312742518 0.0 0.022921295 0.33122696 0.645851745
78 Joel Embiid C joel-embiid 2014 1.164983449 0.14786666699999998 0.398188095 0.234645238 0.2193
79 Marcus Smart PG marcus-smart 2014 0.9972631999999999 0.163507826 0.36384558899999997 0.14213199599999998 0.33051459
80 Noah Vonleh PF noah-vonieh 2014 0.88516864 0.099 0.46106666700000004 0.1801 0.259833333
81 Aaron Gordon PF aaron-gordon 2014 0.8442044190000001 0.0966 0.4617 0.200033333 0.241666667
82 Andrew Wiggins SG andrew-wiggins 2014 0.6941047309999999 0.11021666699999999 0.42225 0.11800000000000001 0.34953333299999995
83 Julius Randle PF julius-randle 2014 0.627281437 0.08223333299999999 0.41743333299999996 0.2036 0.296733333
84 Jabari Parker SF jabari-parker 2014 0.514308936 0.0885 0.405 0.152666667 0.35383333299999997
85 Jordan Adams SG 2-jordan-adams 2014 0.416089009 0.051623342999999995 0.35778070799999995 0.32551334600000004 0.265082604
86 Gary Harris SG gary-harris 2014 0.298824269 0.068668118 0.334410402 0.310628849 0.286292631
87 Jarnell Stokes PF jarnell-stokes 2014 0.144021715 0.014131988 0.293791082 0.41587172 0.27620521
88 Nik Stauskas SG nik-stauskas 2014 0.09764512 0.016286567 0.302474659 0.390961236 0.290277537
89 James Young SF james-young 2014 0.023821786 0.0317 0.310783333 0.359264286 0.298252381
90 Glenn Robinson III SF glenn-robinson-iii 2014 -0.005355215 0.006183208000000001 0.28136358300000003 0.404918844 0.307534365
91 Zach LaVine PG zach-lavine 2014 -0.04600119 0.032766667 0.2868 0.39793333299999994 0.2825
92 T.J. Warren SF tj-warren 2014 -0.148039157 0.013448779 0.258598773 0.36924236 0.358710088
93 Mitch McGary PF mitch-mcgary 2014 -0.274478981 0.007489118 0.23759761899999998 0.434655687 0.320257575
94 Elfrid Payton PG elfrid-payton 2014 -0.284167648 0.019206755 0.23972399600000002 0.343878864 0.397190385
95 Kyle Anderson PF 3-kyle-anderson 2014 -0.291038075 0.012674006000000002 0.254152427 0.329701228 0.40347234
96 Rodney Hood SG rodney-hood 2014 -0.315093348 0.002403967 0.236255935 0.414664765 0.346675333
97 Tyler Ennis PG tyler-ennis 2014 -0.39278162299999997 0.037816667000000005 0.24841666699999998 0.2376 0.47616666700000004
98 Scottie Wilbekin PG scottie-wilbekin 2014 -0.429531082 0.008391528 0.1896991 0.410623309 0.39128606200000005
99 Jerami Grant SF jerami-grant 2014 -0.453116853 0.008432581 0.191915165 0.375301105 0.424351149
100 Ioannis Papapetrou SF ioannis-papapetrou 2014 -0.5465378479999999 0.011866667 0.1737 0.38636666700000005 0.428066667
101 P.J. Hairston SG pj-hairston 2014 -0.571128526 0.004645311 0.17656629399999998 0.402214391 0.416574004
Powered by Datasette · Query took 19.832ms