mlb-allstar-teams/allstar_player_talent

3,930 rows sorted by startingPos

View and edit SQL

Suggested facets: gameNum, lgID, startingPos, asg_PA, asg_IP

Link rowid bbref_ID yearID gameNum gameID lgID startingPos ▼ OFF600 DEF600 PITCH200 asg_PA asg_IP OFFper9innASG DEFper9innASG PITper9innASG TOTper9innASG
8 kershcl01 2015 0 NLS201507140 NL   0.0 0.0 14.69587484 0 1.0 0.0 0.0 0.073479374 0.073479374
10 crawfbr01 2015 0 NLS201507140 NL   2.372143139 13.07962617 0.0 2 0.0 0.007907144 0.043598754 0.0 0.051505898
11 degroja01 2015 0 NLS201507140 NL   0.0 0.0 9.670052969 0 1.0 0.0 0.0 0.048350265 0.048350265
12 polloaj01 2015 0 NLS201507140 NL   13.55430376 14.748542800000001 0.0 1 0.0 0.022590506 0.024580905 0.0 0.047171410999999996
13 tulowtr01 2015 0 NLS201507140 NL   19.62542057 8.049826759 0.0 1 0.0 0.032709034 0.013416378 0.0 0.046125412000000005
14 arenano01 2015 0 NLS201507140 NL   4.151574702 22.3198544 0.0 1 0.0 0.006919291 0.037199757 0.0 0.044119049
15 melanma01 2015 0 NLS201507140 NL   0.0 0.0 8.36372438 0 1.0 0.0 0.0 0.041818622 0.041818622
16 chapmar01 2015 0 NLS201507140 NL   0.0 0.0 7.730133295 0 1.0 0.0 0.0 0.038650666 0.038650666
17 rodrifr03 2015 0 NLS201507140 NL   0.0 0.0 7.605978192 0 1.0 0.0 0.0 0.038029891 0.038029891
18 panikjo01 2015 0 NLS201507140 NL   8.338986979 1.7931204669999998 0.0 2 0.0 0.027796623 0.005977068 0.0 0.033773691
19 bryankr01 2015 0 NLS201507140 NL   9.858185237999999 -0.7896018340000001 0.0 2 0.0 0.032860617 -0.0026320059999999997 0.0 0.030228611000000002
20 bumgama01 2015 0 NLS201507140 NL   0.0 0.0 4.773869255 0 1.0 0.0 0.0 0.023869346 0.023869346
21 molinya01 2015 0 NLS201507140 NL   -1.401576855 15.00442152 0.0 1 0.0 -0.002335961 0.025007368999999998 0.0 0.022671407999999997
22 colege01 2015 0 NLS201507140 NL   0.0 0.0 4.063585062 0 1.0 0.0 0.0 0.020317925 0.020317925
23 uptonju01 2015 0 NLS201507140 NL   15.79394445 -3.6487258110000003 0.0 1 0.0 0.026323241 -0.00608121 0.0 0.020242031
24 gonzaad01 2015 0 NLS201507140 NL   10.73627332 1.379488667 0.0 1 0.0 0.017893789 0.002299148 0.0 0.020192937
26 grandya01 2015 0 NLS201507140 NL   10.50556912 -2.937029926 0.0 1 0.0 0.017509282 -0.00489505 0.0 0.012614232
28 braunry02 2015 0 NLS201507140 NL   11.95682091 -7.153399742 0.0 1 0.0 0.019928035 -0.011922333 0.0 0.008005702
33 machama01 2015 0 NLS201507140 AL   11.89500486 18.31611284 0.0 2 0.0 0.037563173 0.057840355999999996 0.0 0.09540353
34 hernafe02 2015 0 NLS201507140 AL   0.0 0.0 13.68661117 0 1.0 0.0 0.0 0.06843305599999999 0.06843305599999999
35 betande01 2015 0 NLS201507140 AL   0.0 0.0 10.51321504 0 1.0 0.0 0.0 0.052566075 0.052566075
36 gardnbr01 2015 0 NLS201507140 AL   12.80781841 1.336028519 0.0 2 0.0 0.040445742 0.004219037 0.0 0.04466478
39 priceda01 2015 0 NLS201507140 AL   0.0 0.0 7.869745063 0 1.0 0.0 0.0 0.039348725 0.039348725
40 perkigl01 2015 0 NLS201507140 AL   0.0 0.0 7.684233817000001 0 1.0 0.0 0.0 0.038421169 0.038421169
41 daviswa01 2015 0 NLS201507140 AL   0.0 0.0 7.568068633999999 0 1.0 0.0 0.0 0.037840343 0.037840343
42 archech01 2015 0 NLS201507140 AL   0.0 0.0 5.405436997000001 0 1.3330000000000002 0.0 0.0 0.036027237999999996 0.036027237999999996
43 martiru01 2015 0 NLS201507140 AL   8.472729454 12.95907107 0.0 1 0.0 0.013377993999999999 0.020461691 0.0 0.033839685
47 kipnija01 2015 0 NLS201507140 AL   13.8838169 -0.322665407 0.0 1 0.0 0.021921816 -0.000509472 0.0 0.021412344
48 brittza01 2015 0 NLS201507140 AL   0.0 0.0 6.354951044 0 0.667 0.0 0.0 0.021193762 0.021193762
49 doziebr01 2015 0 NLS201507140 AL   9.096503426 4.1387151289999995 0.0 1 0.0 0.0143629 0.006534813 0.0 0.020897713999999998
50 martijd02 2015 0 NLS201507140 AL   15.96245909 -7.676506516 0.0 1 0.0 0.025203883 -0.0121208 0.0 0.013083083
51 vogtst01 2015 0 NLS201507140 AL   7.336364395 0.538745787 0.0 1 0.0 0.011583733 0.000850651 0.0 0.012434384
52 holtbr01 2015 0 NLS201507140 AL   6.348839212000001 0.63514577 0.0 1 0.0 0.010024483 0.001002862 0.0 0.011027345
53 iglesjo01 2015 0 NLS201507140 AL   -1.62677861 4.65610196 0.0 2 0.0 -0.005137196 0.01470348 0.0 0.009566284
54 moustmi01 2015 0 NLS201507140 AL   -8.244947262 2.311793635 0.0 0 0.0 0.0 0.0 0.0 0.0
55 teixema01 2015 0 NLS201507140 AL   1.503351193 -2.774522189 0.0 2 0.0 0.004747425 -0.008761649 0.0 -0.004014224
57 fieldpr01 2015 0 NLS201507140 AL   10.17888542 -14.08814163 0.0 2 0.0 0.032143849 -0.044488868 0.0 -0.01234502
59 mccutan01 2013 0 NLS201307160 NL   31.82050161 4.206932741 0.0 2 0.0 0.123176135 0.016284901 0.0 0.13946103599999998
63 kershcl01 2013 0 NLS201307160 NL   0.0 0.0 19.2235995 0 1.0 0.0 0.0 0.096117997 0.096117997
65 leecl02 2013 0 NLS201307160 NL   0.0 0.0 18.04254459 0 1.0 0.0 0.0 0.09021272300000001 0.09021272300000001
66 goldspa01 2013 0 NLS201307160 NL   23.82314261 -1.756812026 0.0 2 0.0 0.09221861699999999 -0.006800563000000001 0.0 0.08541805400000001
68 carpema01 2013 0 NLS201307160 NL   19.90048053 -1.2528766470000001 0.0 2 0.0 0.077034118 -0.004849845 0.0 0.072184273
70 kimbrcr01 2013 0 NLS201307160 NL   0.0 0.0 13.35429036 0 1.0 0.0 0.0 0.066771452 0.066771452
71 gomezca01 2013 0 NLS201307160 NL   7.253967272000001 23.62815151 0.0 1 0.0 0.014039936999999999 0.045731905999999996 0.0 0.059771843
72 fernajo02 2013 0 NLS201307160 NL   0.0 0.0 11.6166679 0 1.0 0.0 0.0 0.058083339000000005 0.058083339000000005
73 poseybu01 2013 0 NLS201307160 NL   22.86849366 6.599924081 0.0 1 0.0 0.044261601 0.012774047 0.0 0.057035647
74 chapmar01 2013 0 NLS201307160 NL   0.0 0.0 8.278667249 0 1.0 0.0 0.0 0.041393336 0.041393336
77 grillja01 2013 0 NLS201307160 NL   0.0 0.0 3.461209526 0 1.0 0.0 0.0 0.017306048 0.017306048
78 segurje01 2013 0 NLS201307160 NL   2.34936249 6.0466945160000005 0.0 1 0.0 0.004547153 0.01170328 0.0 0.016250433
79 craigal01 2013 0 NLS201307160 NL   16.70931488 -9.731161689 0.0 1 0.0 0.032340609 -0.018834506 0.0 0.013506103
80 corbipa01 2013 0 NLS201307160 NL   0.0 0.0 0.863964958 0 1.0 0.0 0.0 0.004319825 0.004319825
81 alvarpe01 2013 0 NLS201307160 NL   1.541331175 -0.8415766990000001 0.0 1 0.0 0.0029832220000000002 -0.001628858 0.0 0.001354364
82 browndo01 2013 0 NLS201307160 NL   8.214554582 -13.01373283 0.0 1 0.0 0.015899138 -0.02518787 0.0 -0.009288732
85 salech01 2013 0 NLS201307160 AL   0.0 0.0 17.92905256 0 2.0 0.0 0.0 0.17931044899999998 0.17931044899999998
87 pedrodu01 2013 0 NLS201307160 AL   11.87000456 12.63811425 0.0 2 0.0 0.041894134 0.044605109000000004 0.0 0.086499243
92 nathajo01 2013 0 NLS201307160 AL   0.0 0.0 11.52333118 0 1.0 0.0 0.0 0.057623058 0.057623058
94 riverma01 2013 0 NLS201307160 AL   0.0 0.0 11.28793255 0 1.0 0.0 0.0 0.056445935 0.056445935
95 hernafe02 2013 0 NLS201307160 AL   0.0 0.0 10.9692711 0 1.0 0.0 0.0 0.05485245 0.05485245
98 machama01 2013 0 NLS201307160 AL   -1.757951064 22.17290001 0.0 1 0.0 -0.003102267 0.039128647 0.0 0.03602638
99 balfogr01 2013 0 NLS201307160 AL   0.0 0.0 6.761375442 0 1.0 0.0 0.0 0.033810634 0.033810634
100 gordoal01 2013 0 NLS201307160 AL   10.21968962 8.607640534 0.0 1 0.0 0.018034746 0.015189953999999999 0.0 0.033224699999999996
101 perezsa02 2013 0 NLS201307160 AL   2.214183682 16.10082041 0.0 1 0.0 0.0039073829999999995 0.028413212 0.0 0.032320595
102 encared01 2013 0 NLS201307160 AL   22.14417243 -13.42327449 0.0 2 0.0 0.078155903 -0.047376262999999995 0.0 0.03077964
103 kipnija01 2013 0 NLS201307160 AL   14.46098089 2.244011536 0.0 1 0.0 0.025519378 0.00396002 0.0 0.029479397999999997
105 hollagr01 2013 0 NLS201307160 AL   0.0 0.0 10.7408449 0 0.33299999999999996 0.0 0.0 0.017885494 0.017885494
106 hunteto01 2013 0 NLS201307160 AL   9.977153215 -3.821687424 0.0 1 0.0 0.017606741000000002 -0.0067441540000000005 0.0 0.010862587
107 moorema02 2013 0 NLS201307160 AL   0.0 0.0 1.770579886 0 1.0 0.0 0.0 0.008853883 0.008853883
108 fieldpr01 2013 0 NLS201307160 AL   18.74564244 -14.08792985 0.0 1 0.0 0.033080545 -0.024861052999999998 0.0 0.008219493000000001
109 peraljh01 2013 0 NLS201307160 AL   -2.074780189 5.339437193999999 0.0 1 0.0 -0.003661377 0.009422536 0.0 0.005761159
110 delabst01 2013 0 NLS201307160 AL   0.0 0.0 0.268531742 0 0.33299999999999996 0.0 0.0 0.000447155 0.000447155
111 cecilbr01 2013 0 NLS201307160 AL   0.0 0.0 0.031395755 0 0.33299999999999996 0.0 0.0 5.2300000000000004e-05 5.2300000000000004e-05
112 cruzne02 2013 0 NLS201307160 AL   4.125407084 -12.0511154 0.0 2 0.0 0.01456026 -0.042533348 0.0 -0.027973087999999997
114 leecl02 2011 0 NLS201107120 NL   0.0 0.0 19.31343762 0 1.6669999999999998 0.0 0.0 0.160977503 0.160977503
116 vottojo01 2011 0 NLS201107120 NL   35.88958903 -4.59918942 0.0 2 0.0 0.134585959 -0.01724696 0.0 0.117338999
118 kershcl01 2011 0 NLS201107120 NL   0.0 0.0 16.1022013 0 1.0 0.0 0.0 0.080511007 0.080511007
120 uptonju01 2011 0 NLS201107120 NL   18.83261606 -0.014771112 0.0 2 0.0 0.07062231 -5.539999999999999e-05 0.0 0.070566919
122 pencehu01 2011 0 NLS201107120 NL   17.13588238 -0.803201073 0.0 2 0.0 0.06425955900000001 -0.0030120040000000004 0.0 0.061247555
124 jurrjja01 2011 0 NLS201107120 NL   0.0 0.0 6.1944210570000005 0 1.6669999999999998 0.0 0.0 0.051630499999999996 0.051630499999999996
126 sandopa01 2011 0 NLS201107120 NL   17.39130858 4.992126569 0.0 1 0.0 0.032608704 0.009360236999999999 0.0 0.041968940999999996
129 mccutan01 2011 0 NLS201107120 NL   18.89080073 0.59577391 0.0 1 0.0 0.035420251 0.001117076 0.0 0.036537327
130 ventejo01 2011 0 NLS201107120 NL   0.0 0.0 8.499595994 0 0.667 0.0 0.0 0.028346153 0.028346153
131 phillbr01 2011 0 NLS201107120 NL   5.02078537 7.295901081 0.0 1 0.0 0.009413973 0.013679815 0.0 0.023093787
132 molinya01 2011 0 NLS201107120 NL   -3.500604043 13.66045647 0.0 1 0.0 -0.006563633 0.025613356 0.0 0.019049723
133 clippty01 2011 0 NLS201107120 NL   0.0 0.0 10.23779111 0 0.33299999999999996 0.0 0.0 0.017045921999999998 0.017045921999999998
134 bruceja01 2011 0 NLS201107120 NL   7.8962841820000005 0.502227133 0.0 1 0.0 0.014805533000000001 0.000941676 0.0 0.015747208999999998
135 wilsobr01 2011 0 NLS201107120 NL   0.0 0.0 4.379006264 0 0.667 0.0 0.0 0.014603986000000001 0.014603986000000001
137 hanrajo01 2011 0 NLS201107120 NL   0.0 0.0 7.0397596689999995 0 0.33299999999999996 0.0 0.0 0.011721200000000001 0.011721200000000001
138 kimbrcr01 2011 0 NLS201107120 NL   0.0 0.0 6.181542059 0 0.33299999999999996 0.0 0.0 0.010292268 0.010292268
139 castrst01 2011 0 NLS201107120 NL   4.183514633 0.075908508 0.0 1 0.0 0.00784409 0.000142328 0.0 0.007986418
140 ethiean01 2011 0 NLS201107120 NL   11.77153736 -8.379707384 0.0 1 0.0 0.022071632999999997 -0.015711951000000002 0.0 0.006359681
141 bellhe01 2011 0 NLS201107120 NL   0.0 0.0 3.800850729 0 0.33299999999999996 0.0 0.0 0.006328416 0.006328416
142 montemi01 2011 0 NLS201107120 NL   4.007291287 10.07138704 0.0 0 0.0 0.0 0.0 0.0 0.0
143 sanchga01 2011 0 NLS201107120 NL   4.247945866 -6.802700781 0.0 1 0.0 0.007964898 -0.012755063999999998 0.0 -0.004790165
150 ellsbja01 2011 0 NLS201107120 AL   17.17220657 4.423719362 0.0 2 0.0 0.060607787999999996 0.015613127 0.0 0.076220915
151 roberda08 2011 0 NLS201107120 AL   0.0 0.0 12.06493726 0 1.0 0.0 0.0 0.067865272 0.067865272
153 wilsocj01 2011 0 NLS201107120 AL   0.0 0.0 10.07250782 0 1.0 0.0 0.0 0.056657856 0.056657856
154 cabremi01 2011 0 NLS201107120 AL   38.92148186 -9.163162813 0.0 1 0.0 0.068684968 -0.016170287 0.0 0.052514680999999994
155 youklke01 2011 0 NLS201107120 AL   25.02126434 2.321159895 0.0 1 0.0 0.044155172 0.004096165 0.0 0.048251337000000005
158 ogandal01 2011 0 NLS201107120 AL   0.0 0.0 8.67284933 0 0.667 0.0 0.0 0.032539447 0.032539447
159 joycema01 2011 0 NLS201107120 AL   14.103358499999999 -6.371765333 0.0 2 0.0 0.049776559000000005 -0.022488584 0.0 0.027287976000000002

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "mlb-allstar-teams/allstar_player_talent" (
"bbref_ID" TEXT,
  "yearID" INTEGER,
  "gameNum" INTEGER,
  "gameID" TEXT,
  "lgID" TEXT,
  "startingPos" INTEGER,
  "OFF600" REAL,
  "DEF600" REAL,
  "PITCH200" REAL,
  "asg_PA" INTEGER,
  "asg_IP" REAL,
  "OFFper9innASG" REAL,
  "DEFper9innASG" REAL,
  "PITper9innASG" REAL,
  "TOTper9innASG" REAL
);
Powered by Datasette · Query took 276.217ms