mlb-allstar-teams/allstar_player_talent

3,930 rows

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
4 greinza01 2015 0 NLS201507140 NL 1 0.0 0.0 15.64561093 0 2.0 0.0 0.0 0.156456109 0.156456109
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
8 kershcl01 2015 0 NLS201507140 NL   0.0 0.0 14.69587484 0 1.0 0.0 0.0 0.073479374 0.073479374
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
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
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
31 keuchda01 2015 0 NLS201507140 AL 1 0.0 0.0 10.85397806 0 2.0 0.0 0.0 0.108539781 0.108539781
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
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
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
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
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
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
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
61 harvema01 2013 0 NLS201307160 NL 1 0.0 0.0 11.573843400000001 0 2.0 0.0 0.0 0.115738434 0.115738434
62 molinya01 2013 0 NLS201307160 NL 2 13.24493862 14.95291802 0.0 2 0.0 0.05127073 0.057882262999999996 0.0 0.109152993
63 kershcl01 2013 0 NLS201307160 NL   0.0 0.0 19.2235995 0 1.0 0.0 0.0 0.096117997 0.096117997
64 tulowtr01 2013 0 NLS201307160 NL 6 15.22694025 8.537136659 0.0 2 0.0 0.058942995 0.033046981 0.0 0.091989975
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
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
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
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
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
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
85 salech01 2013 0 NLS201307160 AL   0.0 0.0 17.92905256 0 2.0 0.0 0.0 0.17931044899999998 0.17931044899999998
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
89 scherma01 2013 0 NLS201307160 AL 1 0.0 0.0 13.25917481 0 1.0 0.0 0.0 0.066303241 0.066303241
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
92 nathajo01 2013 0 NLS201307160 AL   0.0 0.0 11.52333118 0 1.0 0.0 0.0 0.057623058 0.057623058
93 canoro01 2013 0 NLS201307160 AL 4 25.26117507 7.292741231 0.0 1 0.0 0.044578544000000005 0.012869543 0.0 0.057448088
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
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
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

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