mlb-allstar-teams/allstar_player_talent

3,930 rows sorted by PITper9innASG

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
1495 burdele01 1959 1 NLS195907070 NL   0.0 0.0 -6.48329598 0 3.0 0.0 0.0 -0.09724944 -0.09724944
1865 brownma01 1938 0 NLS193807060 NL   0.0 0.0 -5.74984287 0 3.0 0.0 0.0 -0.08624764300000001 -0.08624764300000001
1538 burdele01 1957 0 NLS195707090 NL   0.0 0.0 -4.280050463 0 4.0 0.0 0.0 -0.085601009 -0.085601009
3458 coateji01 1960 1 ALS196007110 AL   0.0 0.0 -6.620151689 0 2.0 0.0 0.0 -0.066201517 -0.066201517
302 turnbde01 2006 0 NLS200607110 NL   0.0 0.0 -8.858472614 0 1.0 0.0 0.0 -0.044292363 -0.044292363
3457 bellga01 1960 1 ALS196007110 AL   0.0 0.0 -4.2604698 0 2.0 0.0 0.0 -0.042604697999999996 -0.042604697999999996
1517 wynnea01 1959 1 NLS195907070 AL 1 0.0 0.0 -2.267733694 0 3.0 0.0 0.0 -0.038268006 -0.038268006
2904 andujjo01 1979 0 ALS197907170 NL   0.0 0.0 -3.656107825 0 2.0 0.0 0.0 -0.036561078 -0.036561078
2491 greenty01 1995 0 ALS199507110 NL   0.0 0.0 -7.207556327000001 0 1.0 0.0 0.0 -0.036037782000000004 -0.036037782000000004
2719 howelja01 1987 0 ALS198707140 AL   0.0 0.0 -4.665105528 0 2.0 0.0 0.0 -0.032296884 -0.032296884
1203 osteecl01 1970 0 NLS197007140 NL   0.0 0.0 -2.828085853 0 3.0 0.0 0.0 -0.031815966 -0.031815966
1708 brisslo01 1949 0 NLS194907120 AL   0.0 0.0 -2.004021137 0 3.0 0.0 0.0 -0.030060317000000003 -0.030060317000000003
2743 ryanno01 1985 0 ALS198507160 NL   0.0 0.0 -1.922880044 0 3.0 0.0 0.0 -0.028843201000000002 -0.028843201000000002
3096 ellisdo01 1971 0 ALS197107130 NL 1 0.0 0.0 -1.557609054 0 3.0 0.0 0.0 -0.026284652999999998 -0.026284652999999998
1202 merriji01 1970 0 NLS197007140 NL   0.0 0.0 -3.456750923 0 2.0 0.0 0.0 -0.025925632 -0.025925632
1478 mclisca01 1959 2 NLS195908030 AL   0.0 0.0 -2.510442551 0 2.0 0.0 0.0 -0.025104426000000003 -0.025104426000000003
3768 leonadu02 1943 0 ALS194307130 AL 1 0.0 0.0 -1.650704533 0 3.0 0.0 0.0 -0.024760567999999997 -0.024760567999999997
1688 bickfve01 1949 0 NLS194907120 NL   0.0 0.0 -4.792924918 0 1.0 0.0 0.0 -0.023964625 -0.023964625
382 loaizes01 2004 0 NLS200407130 AL   0.0 0.0 -4.709837183 0 1.0 0.0 0.0 -0.023549186 -0.023549186
1477 wynnea01 1959 2 NLS195908030 AL   0.0 0.0 -2.267733694 0 2.0 0.0 0.0 -0.022677337000000002 -0.022677337000000002
3409 bellga01 1960 2 ALS196007130 AL   0.0 0.0 -4.2604698 0 1.0 0.0 0.0 -0.021302348999999998 -0.021302348999999998
3754 javeral01 1943 0 ALS194307130 NL   0.0 0.0 -1.887534342 0 2.0 0.0 0.0 -0.021234761 -0.021234761
1274 odombl01 1968 0 NLS196807090 AL   0.0 0.0 -1.788518129 0 2.0 0.0 0.0 -0.020120829 -0.020120829
3490 wynnea01 1958 0 ALS195807080 AL   0.0 0.0 -3.787040647 0 1.0 0.0 0.0 -0.018935203 -0.018935203
785 kneppbo01 1988 0 NLS198807120 NL   0.0 0.0 -3.704446715 0 1.0 0.0 0.0 -0.018522234 -0.018522234
3250 grantmu01 1965 0 ALS196507130 AL   0.0 0.0 -1.7173469590000001 0 2.0 0.0 0.0 -0.01717347 -0.01717347
2850 ruthvdi01 1981 0 ALS198108090 NL   0.0 0.0 -9.88452324 0 0.33299999999999996 0.0 0.0 -0.016457731 -0.016457731
2438 jonesbo03 1997 0 ALS199707080 NL   0.0 0.0 -2.848412783 0 1.0 0.0 0.0 -0.016022322 -0.016022322
1618 dicksmu01 1953 0 NLS195307140 NL   0.0 0.0 -1.5881145280000002 0 2.0 0.0 0.0 -0.015881145 -0.015881145
1247 reedro01 1968 0 NLS196807090 NL   0.0 0.0 -4.239589381 0 0.667 0.0 0.0 -0.014139031000000002 -0.014139031000000002
3708 sewelri01 1946 0 ALS194607090 NL   0.0 0.0 -2.483276664 0 1.0 0.0 0.0 -0.013968431000000002 -0.013968431000000002
2541 burkejo03 1993 0 ALS199307130 NL   0.0 0.0 -3.4234534130000003 0 0.667 0.0 0.0 -0.012844369 -0.012844369
170 leagubr01 2011 0 NLS201107120 AL   0.0 0.0 -2.210403119 0 1.0 0.0 0.0 -0.012433518000000001 -0.012433518000000001
2463 rosadjo01 1997 0 ALS199707080 AL   0.0 0.0 -2.189824342 0 1.0 0.0 0.0 -0.010949122 -0.010949122
1947 ruffire01 1934 0 NLS193407100 AL   0.0 0.0 -2.147340626 0 1.0 0.0 0.0 -0.010736703 -0.010736703
3116 cuellmi01 1971 0 ALS197107130 AL   0.0 0.0 -0.9976109209999999 0 2.0 0.0 0.0 -0.009976109 -0.009976109
3526 wilsoji02 1956 0 ALS195607100 AL   0.0 0.0 -1.977852832 0 1.0 0.0 0.0 -0.009889264 -0.009889264
1395 pappami01 1962 2 NLS196207300 AL   0.0 0.0 -1.9374640459999999 0 1.0 0.0 0.0 -0.00968732 -0.00968732
3329 pappami01 1962 1 ALS196207100 AL   0.0 0.0 -1.9374640459999999 0 1.0 0.0 0.0 -0.00968732 -0.00968732
3072 hunteca01 1973 0 ALS197307240 AL 1 0.0 0.0 -1.385163138 0 1.3330000000000002 0.0 0.0 -0.009232111999999999 -0.009232111999999999
2902 lacosmi01 1979 0 ALS197907170 NL   0.0 0.0 -1.31767422 0 1.3330000000000002 0.0 0.0 -0.008782299 -0.008782299
2330 sheetbe01 2001 0 ALS200107100 NL   0.0 0.0 -4.502789781000001 0 0.33299999999999996 0.0 0.0 -0.008435343 -0.008435343
1226 hunteca01 1970 0 NLS197007140 AL   0.0 0.0 -6.1122511710000005 0 0.33299999999999996 0.0 0.0 -0.007850526 -0.007850526
2275 wolfra02 2003 0 ALS200307150 NL   0.0 0.0 -1.376996785 0 1.0 0.0 0.0 -0.007745607 -0.007745607
3473 frienbo01 1958 0 ALS195807080 NL   0.0 0.0 -0.589703945 0 2.333 0.0 0.0 -0.0077387590000000004 -0.0077387590000000004
3210 mcgloji01 1967 0 ALS196707110 AL   0.0 0.0 -1.2103710220000001 0 2.0 0.0 0.0 -0.007262226 -0.007262226
3345 purkebo01 1961 2 ALS196107310 NL 1 0.0 0.0 -0.6732568720000001 0 2.0 0.0 0.0 -0.006732569 -0.006732569
2008 kazmisc01 2014 0 ALS201407150 AL   0.0 0.0 -1.9856887490000001 0 0.667 0.0 0.0 -0.006622271999999999 -0.006622271999999999
2878 norrimi01 1981 0 ALS198108090 AL   0.0 0.0 -1.2997276420000001 0 1.0 0.0 0.0 -0.006498638 -0.006498638
1413 purkebo01 1961 1 NLS196107110 NL   0.0 0.0 -0.6732568720000001 0 2.0 0.0 0.0 -0.006059312 -0.006059312
1113 brettke01 1974 0 NLS197407230 NL   0.0 0.0 -0.593641015 0 2.0 0.0 0.0 -0.00593641 -0.00593641
1246 carltst01 1968 0 NLS196807090 NL   0.0 0.0 -1.1819290359999999 0 1.0 0.0 0.0 -0.005909645 -0.005909645
3687 colemjo04 1948 0 ALS194807130 AL   0.0 0.0 -0.35359209700000005 0 3.0 0.0 0.0 -0.005303881 -0.005303881
3810 hudsosi01 1941 0 ALS194107080 AL   0.0 0.0 -0.998299356 0 1.0 0.0 0.0 -0.004991497 -0.004991497
1557 loesbi01 1957 0 NLS195707090 AL   0.0 0.0 -0.317292511 0 3.0 0.0 0.0 -0.004759388 -0.004759388
1067 rhoderi01 1976 0 NLS197607130 NL   0.0 0.0 -0.846772657 0 1.0 0.0 0.0 -0.004233863 -0.004233863
902 morrija02 1984 0 NLS198407100 AL   0.0 0.0 -0.350342827 0 2.0 0.0 0.0 -0.003941357 -0.003941357
1579 haddiha01 1955 0 NLS195507120 NL   0.0 0.0 -0.33352461 0 3.0 0.0 0.0 -0.003752152 -0.003752152
1577 newcodo01 1955 0 NLS195507120 NL   0.0 0.0 -0.918871995 0 1.0 0.0 0.0 -0.00344577 -0.00344577
3070 holtzke01 1973 0 ALS197307240 AL   0.0 0.0 -1.014683724 0 0.667 0.0 0.0 -0.00338397 -0.00338397
627 myersra01 1994 0 NLS199407120 NL   0.0 0.0 -0.7439933329999999 0 1.0 0.0 0.0 -0.003347635 -0.003347635
3406 wynnea01 1960 2 ALS196007130 AL   0.0 0.0 -0.330356163 0 2.0 0.0 0.0 -0.003303562 -0.003303562
1177 mcnalda01 1972 0 NLS197207250 AL   0.0 0.0 -1.991462815 0 0.33299999999999996 0.0 0.0 -0.003197479 -0.003197479
3268 culpra01 1963 0 ALS196307090 NL   0.0 0.0 -0.537708958 0 1.0 0.0 0.0 -0.002688545 -0.002688545
2158 wilsobr01 2008 0 ALS200807150 NL   0.0 0.0 -0.915233835 0 0.667 0.0 0.0 -0.0018729629999999998 -0.0018729629999999998
3857 waltebu01 1937 0 ALS193707070 NL   0.0 0.0 -0.283872423 0 1.0 0.0 0.0 -0.0015967820000000001 -0.0015967820000000001
168 waldejo01 2011 0 NLS201107120 AL   0.0 0.0 -0.239273713 0 1.0 0.0 0.0 -0.001345915 -0.001345915
1575 conlege01 1955 0 NLS195507120 NL   0.0 0.0 -0.35019030100000004 0 1.0 0.0 0.0 -0.001313214 -0.001313214
2098 cappsma01 2010 0 ALS201007130 NL   0.0 0.0 -0.695158849 0 0.33299999999999996 0.0 0.0 -0.001157439 -0.001157439
2487 myersra01 1995 0 ALS199507110 NL   0.0 0.0 -0.18992278699999998 0 1.0 0.0 0.0 -0.000949614 -0.000949614
1778 newsobo01 1944 0 NLS194407110 AL   0.0 0.0 -0.436663046 0 0.33299999999999996 0.0 0.0 -0.0008179239999999999 -0.0008179239999999999
3164 odombl01 1969 0 ALS196907230 AL   0.0 0.0 -0.139815911 0 0.33299999999999996 0.0 0.0 -0.000232793 -0.000232793
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

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