mlb-allstar-teams/allstar_player_talent

3,930 rows sorted by asg_IP

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
1 goldspa01 2015 0 NLS201507140 NL 3 36.75572404 -0.11721352199999999 0.0 3 0.0 0.18377862 -0.000586068 0.0 0.183192553
2 mccutan01 2015 0 NLS201507140 NL 8 33.67616805 -0.168658418 0.0 3 0.0 0.16838084 -0.0008432919999999999 0.0 0.167537548
3 harpebr03 2015 0 NLS201507140 NL 9 30.92545388 1.3829693719999998 0.0 3 0.0 0.154627269 0.006914846999999999 0.0 0.16154211599999999
5 poseybu01 2015 0 NLS201507140 NL 2 21.69296916 7.59554639 0.0 2 0.0 0.072309897 0.025318487999999997 0.0 0.097628385
6 frazito01 2015 0 NLS201507140 NL 5 14.53426139 4.787243006000001 0.0 3 0.0 0.072671307 0.023936215 0.0 0.09660752199999999
7 rizzoan01 2015 0 NLS201507140 NL 0 22.17114817 0.670664775 0.0 2 0.0 0.073903827 0.002235549 0.0 0.076139376
9 peraljh01 2015 0 NLS201507140 NL 6 7.193125866 10.38504755 0.0 2 0.0 0.023977086 0.034616825 0.0 0.058593911
10 crawfbr01 2015 0 NLS201507140 NL   2.372143139 13.07962617 0.0 2 0.0 0.007907144 0.043598754 0.0 0.051505898
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
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
21 molinya01 2015 0 NLS201507140 NL   -1.401576855 15.00442152 0.0 1 0.0 -0.002335961 0.025007368999999998 0.0 0.022671407999999997
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
25 pederjo01 2015 0 NLS201507140 NL 7 3.696578417 1.397402342 0.0 2 0.0 0.012321928000000001 0.004658008 0.0 0.016979936
26 grandya01 2015 0 NLS201507140 NL   10.50556912 -2.937029926 0.0 1 0.0 0.017509282 -0.00489505 0.0 0.012614232
27 lemahdj01 2015 0 NLS201507140 NL 4 -12.17119639 14.98804875 0.0 2 0.0 -0.040570655 0.049960162 0.0 0.009389508000000001
28 braunry02 2015 0 NLS201507140 NL   11.95682091 -7.153399742 0.0 1 0.0 0.019928035 -0.011922333 0.0 0.008005702
29 troutmi01 2015 0 NLS201507140 AL 8 50.64962847 -1.205686239 0.0 4 0.0 0.31989239 -0.00761486 0.0 0.31227753
30 cainlo01 2015 0 NLS201507140 AL 9 5.858901822000001 19.86794018 0.0 3 0.0 0.027752693 0.094111296 0.0 0.121863988
32 donaljo02 2015 0 NLS201507140 AL 5 19.12438229 12.85819769 0.0 2 0.0 0.060392786 0.040604835 0.0 0.100997621
33 machama01 2015 0 NLS201507140 AL   11.89500486 18.31611284 0.0 2 0.0 0.037563173 0.057840355999999996 0.0 0.09540353
36 gardnbr01 2015 0 NLS201507140 AL   12.80781841 1.336028519 0.0 2 0.0 0.040445742 0.004219037 0.0 0.04466478
37 jonesad01 2015 0 NLS201507140 AL 7 10.53875953 2.682464564 0.0 2 0.0 0.033280292999999996 0.008470941 0.0 0.041751234
38 perezsa02 2015 0 NLS201507140 AL 2 -2.533871697 15.63544474 0.0 2 0.0 -0.008001699999999999 0.049375089000000004 0.0 0.041373388999999997
43 martiru01 2015 0 NLS201507140 AL   8.472729454 12.95907107 0.0 1 0.0 0.013377993999999999 0.020461691 0.0 0.033839685
44 altuvjo01 2015 0 NLS201507140 AL 4 8.917639485 1.3888149230000002 0.0 2 0.0 0.028160967000000002 0.0043857309999999995 0.0 0.032546698
45 cruzne02 2015 0 NLS201507140 AL 0 17.87237529 -9.002923165 0.0 2 0.0 0.05643908 -0.028430284 0.0 0.028008796000000002
46 pujolal01 2015 0 NLS201507140 AL 3 9.859501597000001 -5.29621644 0.0 3 0.0 0.046702902000000004 -0.025087341000000003 0.0 0.021615561000000002
47 kipnija01 2015 0 NLS201507140 AL   13.8838169 -0.322665407 0.0 1 0.0 0.021921816 -0.000509472 0.0 0.021412344
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
56 escobal02 2015 0 NLS201507140 AL 6 -10.60471541 7.377942818999999 0.0 2 0.0 -0.033488575 0.023298767 0.0 -0.010189808
57 fieldpr01 2015 0 NLS201507140 AL   10.17888542 -14.08814163 0.0 2 0.0 0.032143849 -0.044488868 0.0 -0.01234502
58 wrighda03 2013 0 NLS201307160 NL 5 22.33806657 6.610164471 0.0 3 0.0 0.129704903 0.038381599999999995 0.0 0.168086503
59 mccutan01 2013 0 NLS201307160 NL   31.82050161 4.206932741 0.0 2 0.0 0.123176135 0.016284901 0.0 0.13946103599999998
60 vottojo01 2013 0 NLS201307160 NL 3 32.62009308 -1.941205775 0.0 2 0.0 0.12627132800000002 -0.007514345 0.0 0.11875698300000001
62 molinya01 2013 0 NLS201307160 NL 2 13.24493862 14.95291802 0.0 2 0.0 0.05127073 0.057882262999999996 0.0 0.109152993
64 tulowtr01 2013 0 NLS201307160 NL 6 15.22694025 8.537136659 0.0 2 0.0 0.058942995 0.033046981 0.0 0.091989975
66 goldspa01 2013 0 NLS201307160 NL   23.82314261 -1.756812026 0.0 2 0.0 0.09221861699999999 -0.006800563000000001 0.0 0.08541805400000001
67 harpebr03 2013 0 NLS201307160 NL 8 17.28839515 4.591078426 0.0 2 0.0 0.06692282 0.017771916000000002 0.0 0.08469473599999999
68 carpema01 2013 0 NLS201307160 NL   19.90048053 -1.2528766470000001 0.0 2 0.0 0.077034118 -0.004849845 0.0 0.072184273
69 gonzaca01 2013 0 NLS201307160 NL 7 19.7923236 -2.128000637 0.0 2 0.0 0.07661544599999999 -0.008237422 0.0 0.06837802400000001
71 gomezca01 2013 0 NLS201307160 NL   7.253967272000001 23.62815151 0.0 1 0.0 0.014039936999999999 0.045731905999999996 0.0 0.059771843
73 poseybu01 2013 0 NLS201307160 NL   22.86849366 6.599924081 0.0 1 0.0 0.044261601 0.012774047 0.0 0.057035647
75 beltrca01 2013 0 NLS201307160 NL 9 14.64398539 -6.867289242000001 0.0 2 0.0 0.056686395 -0.026583055 0.0 0.03010334
76 phillbr01 2013 0 NLS201307160 NL 4 -0.251916125 6.139187517000001 0.0 2 0.0 -0.000975159 0.023764597000000002 0.0 0.022789438
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
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
83 cuddymi01 2013 0 NLS201307160 NL 0 14.29032129 -18.345854199999998 0.0 2 0.0 0.055317372999999996 -0.07101621 0.0 -0.015698837
84 troutmi01 2013 0 NLS201307160 AL 7 49.36717733 2.097973191 0.0 3 0.0 0.261355645 0.011106917 0.0 0.272462562
86 cabremi01 2013 0 NLS201307160 AL 5 41.97734268 -8.441702232 0.0 3 0.0 0.22223299100000002 -0.044691365 0.0 0.177541626
87 pedrodu01 2013 0 NLS201307160 AL   11.87000456 12.63811425 0.0 2 0.0 0.041894134 0.044605109000000004 0.0 0.086499243
88 bautijo02 2013 0 NLS201307160 AL 9 27.55944119 -3.1305280189999998 0.0 2 0.0 0.097268616 -0.011048922 0.0 0.086219694
90 mauerjo01 2013 0 NLS201307160 AL 2 17.08688412 0.809616388 0.0 2 0.0 0.06030665 0.00285747 0.0 0.063164119
91 davisch02 2013 0 NLS201307160 AL 3 23.8561755 -12.59528528 0.0 3 0.0 0.1262974 -0.066680922 0.0 0.059616478
93 canoro01 2013 0 NLS201307160 AL 4 25.26117507 7.292741231 0.0 1 0.0 0.044578544000000005 0.012869543 0.0 0.057448088
96 jonesad01 2013 0 NLS201307160 AL 8 12.34095119 -3.143886779 0.0 3 0.0 0.065334447 -0.016644106000000002 0.0 0.048690341
97 ortizda01 2013 0 NLS201307160 AL 0 24.837510199999997 -11.6019817 0.0 2 0.0 0.087661801 -0.040948171 0.0 0.04671363
98 machama01 2013 0 NLS201307160 AL   -1.757951064 22.17290001 0.0 1 0.0 -0.003102267 0.039128647 0.0 0.03602638
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
104 hardyjj01 2013 0 NLS201307160 AL 6 -7.312302464 13.9260301 0.0 2 0.0 -0.025808126 0.049150694 0.0 0.023342567999999998
106 hunteto01 2013 0 NLS201307160 AL   9.977153215 -3.821687424 0.0 1 0.0 0.017606741000000002 -0.0067441540000000005 0.0 0.010862587
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
112 cruzne02 2013 0 NLS201307160 AL   4.125407084 -12.0511154 0.0 2 0.0 0.01456026 -0.042533348 0.0 -0.027973087999999997
115 tulowtr01 2011 0 NLS201107120 NL 6 19.16301815 17.49129322 0.0 2 0.0 0.071861318 0.06559235 0.0 0.137453668
116 vottojo01 2011 0 NLS201107120 NL   35.88958903 -4.59918942 0.0 2 0.0 0.134585959 -0.01724696 0.0 0.117338999
117 kempma01 2011 0 NLS201107120 NL 8 25.37596005 -8.175108938 0.0 3 0.0 0.142739775 -0.045984988 0.0 0.096754787
119 weeksri01 2011 0 NLS201107120 NL 4 15.48799121 -2.7301365389999996 0.0 3 0.0 0.087119951 -0.015357018 0.0 0.071762933
120 uptonju01 2011 0 NLS201107120 NL   18.83261606 -0.014771112 0.0 2 0.0 0.07062231 -5.539999999999999e-05 0.0 0.070566919
121 beltrca01 2011 0 NLS201107120 NL 0 21.76533628 -4.5192130630000005 0.0 2 0.0 0.08162001099999999 -0.016947049 0.0 0.064672962
122 pencehu01 2011 0 NLS201107120 NL   17.13588238 -0.803201073 0.0 2 0.0 0.06425955900000001 -0.0030120040000000004 0.0 0.061247555
123 rolensc01 2011 0 NLS201107120 NL 5 1.9995780380000001 14.18877009 0.0 2 0.0 0.007498418000000001 0.053207887999999995 0.0 0.060706305
125 fieldpr01 2011 0 NLS201107120 NL 3 26.56729954 -13.27004361 0.0 2 0.0 0.099627373 -0.049762664000000005 0.0 0.04986471
126 sandopa01 2011 0 NLS201107120 NL   17.39130858 4.992126569 0.0 1 0.0 0.032608704 0.009360236999999999 0.0 0.041968940999999996
127 mccanbr01 2011 0 NLS201107120 NL 2 6.898105768 4.124312822 0.0 2 0.0 0.025867897 0.015466173 0.0 0.04133407
128 hollima01 2011 0 NLS201107120 NL 7 24.66926671 -2.970826343 0.0 1 0.0 0.046254875 -0.005570299 0.0 0.040684576
129 mccutan01 2011 0 NLS201107120 NL   18.89080073 0.59577391 0.0 1 0.0 0.035420251 0.001117076 0.0 0.036537327
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
134 bruceja01 2011 0 NLS201107120 NL   7.8962841820000005 0.502227133 0.0 1 0.0 0.014805533000000001 0.000941676 0.0 0.015747208999999998
136 berkmla01 2011 0 NLS201107120 NL 9 19.75138899 -12.74078977 0.0 1 0.0 0.037033854 -0.023888981 0.0 0.013144873999999999
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
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
144 bautijo02 2011 0 NLS201107120 AL 9 35.60554755 -2.181436008 0.0 2 0.0 0.125666638 -0.007699185999999999 0.0 0.11796745300000001

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 273.961ms