mlb-allstar-teams/allstar_player_talent

3,930 rows sorted by DEFper9innASG

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
2927 baylodo01 1979 0 ALS197907170 AL 7 14.91732218 -17.50239886 0.0 4 0.0 0.085241841 -0.100013708 0.0 -0.014771867
888 winfida01 1984 0 NLS198407100 AL 7 25.16660875 -12.27188135 0.0 4 0.0 0.188749566 -0.09203911 0.0 0.096710455
1192 allendi01 1970 0 NLS197007140 NL 3 26.465388 -18.57228498 0.0 4 0.0 0.127033862 -0.08914696800000001 0.0 0.037886894
1061 luzingr01 1976 0 NLS197607130 NL 7 18.87536801 -15.36616801 0.0 3 0.0 0.106173945 -0.086434695 0.0 0.01973925
2537 sheffga01 1993 0 ALS199307130 NL 5 17.45449407 -16.5490824 0.0 3 0.0 0.08976597 -0.085109567 0.0 0.004656403
3327 wagnele01 1962 1 ALS196207100 AL 7 11.642760899999999 -12.05186788 0.0 4 0.0 0.082184195 -0.085072009 0.0 -0.0028878140000000003
1320 cepedor01 1964 0 NLS196407070 NL 3 26.46250106 -12.75894146 0.0 4 0.0 0.176416674 -0.08505961 0.0 0.091357064
583 belleal01 1996 0 NLS199607090 AL 7 44.56061365 -11.99249102 0.0 4 0.0 0.31454550800000003 -0.084652878 0.0 0.22989263
1338 mantlmi01 1964 0 NLS196407070 AL 8 43.88331709 -12.54705507 0.0 4 0.0 0.29255544699999997 -0.08364703400000001 0.0 0.20890841300000002
198 hawpebr01 2009 0 NLS200907140 NL   13.83524256 -21.71989219 0.0 2 0.0 0.050309973 -0.078981426 0.0 -0.028671453
2363 mcgwima01 1999 0 ALS199907130 NL 3 44.9012848 -15.66039036 0.0 3 0.0 0.22450642399999998 -0.07830195200000001 0.0 0.146204472
1283 mccovwi01 1966 0 NLS196607120 NL 3 27.42044169 -11.36787657 0.0 4 0.0 0.188025886 -0.07795115400000001 0.0 0.110074732
1755 cavarph01 1944 0 NLS194407110 NL 3 19.31808975 -9.82074518 0.0 5 0.0 0.14860069 -0.07554419400000001 0.0 0.073056497
1464 willite01 1959 2 NLS195908030 AL 7 33.21218521 -15.88501935 0.0 3 0.0 0.157320877 -0.075244829 0.0 0.082076049
1486 cepedor01 1959 1 NLS195907070 NL 3 17.17392001 -9.651371854 0.0 4 0.0 0.132959381 -0.074720298 0.0 0.058239083
1394 wagnele01 1962 2 NLS196207300 AL 7 11.642760899999999 -12.05186788 0.0 4 0.0 0.071647759 -0.074165341 0.0 -0.002517581
582 bicheda01 1996 0 NLS199607090 NL 9 5.858151942999999 -14.32590234 0.0 3 0.0 0.030127638999999998 -0.073676069 0.0 -0.043548431
1342 killeha01 1964 0 NLS196407070 AL 7 25.7971049 -11.03765857 0.0 4 0.0 0.171980699 -0.07358439 0.0 0.098396309
2427 gwynnto01 1997 0 ALS199707080 NL 10 23.43468832 -13.17973287 0.0 3 0.0 0.127825573 -0.071889452 0.0 0.055936121
1150 mayle01 1972 0 NLS197207250 NL 3 17.4282647 -10.69341872 0.0 4 0.0 0.116188431 -0.071289458 0.0 0.044898972999999995
83 cuddymi01 2013 0 NLS201307160 NL 0 14.29032129 -18.345854199999998 0.0 2 0.0 0.055317372999999996 -0.07101621 0.0 -0.015698837
763 strawda01 1988 0 NLS198807120 NL 9 34.09527394 -9.939314108 0.0 4 0.0 0.240672522 -0.070159864 0.0 0.170512658
3920 gehrilo01 1933 0 ALS193307060 AL 3 49.77068377 -10.14679686 0.0 4 0.0 0.341284689 -0.069578036 0.0 0.271706653
2665 baineha01 1989 0 ALS198907110 AL 10 11.16961921 -13.89157172 0.0 3 0.0 0.05584809599999999 -0.069457859 0.0 -0.013609763
983 jacksre01 1980 0 NLS198007080 AL 9 28.2082582 -13.10385455 0.0 3 0.0 0.149337838 -0.069373348 0.0 0.07996449
3902 kleinch01 1933 0 ALS193307060 NL 9 40.1483588 -8.983145989 0.0 4 0.0 0.301112691 -0.067373595 0.0 0.233739096
505 mcgwima01 1998 0 NLS199807070 NL 3 50.51167495 -15.69135411 0.0 3 0.0 0.216478607 -0.06724866 0.0 0.149229946
2395 thomeji01 1999 0 ALS199907130 AL 3 31.15723578 -12.6644351 0.0 3 0.0 0.164950072 -0.067047009 0.0 0.097903062
91 davisch02 2013 0 NLS201307160 AL 3 23.8561755 -12.59528528 0.0 3 0.0 0.1262974 -0.066680922 0.0 0.059616478
1593 vernomi01 1955 0 NLS195507120 AL 3 14.9099815 -9.238844324 0.0 6 0.0 0.10735186699999999 -0.066519679 0.0 0.040832188
2474 gwynnto01 1995 0 ALS199507110 NL 9 27.96181872 -16.26983548 0.0 2 0.0 0.111847275 -0.065079342 0.0 0.046767933
3255 davisto02 1963 0 ALS196307090 NL 7 20.61801832 -9.414580062 0.0 4 0.0 0.141380697 -0.06455712 0.0 0.076823577
2863 singlke01 1981 0 ALS198108090 AL 7 20.62733031 -13.60682787 0.0 3 0.0 0.095203063 -0.062800744 0.0 0.032402319
3153 howarfr01 1969 0 ALS196907230 AL 7 36.82573101 -18.28707878 0.0 2 0.0 0.126259649 -0.062698556 0.0 0.063561093
2716 winfida01 1987 0 ALS198707140 AL 9 8.130227685 -8.587055156 0.0 6 0.0 0.058537639 -0.061826797 0.0 -0.003289158
1294 robinfr02 1966 0 NLS196607120 AL 7 37.69375805 -8.801454637 0.0 4 0.0 0.258471484 -0.060352832 0.0 0.198118652
1257 howarfr01 1968 0 NLS196807090 AL 9 27.84440347 -14.90809844 0.0 2 0.0 0.111377614 -0.059632394000000005 0.0 0.05174522
3333 cepedor01 1961 2 ALS196107310 NL 7 28.48118799 -8.686857162 0.0 4 0.0 0.195299575 -0.059567021 0.0 0.135732554
292 hollima01 2006 0 NLS200607110 NL   17.11387354 -10.16765345 0.0 3 0.0 0.09937087900000001 -0.059037988 0.0 0.040332891
251 griffke02 2007 0 NLS200707100 NL 9 4.890930453999999 -13.01107811 0.0 3 0.0 0.022009187000000003 -0.05854985099999999 0.0 -0.036540664
1230 mccovwi01 1968 0 NLS196807090 NL 3 33.73973174 -7.7854837429999995 0.0 4 0.0 0.253047988 -0.058391128 0.0 0.19465686
2851 rosepe01 1981 0 ALS198108090 NL 3 2.402343774 -12.62546221 0.0 3 0.0 0.01108774 -0.058271364000000006 0.0 -0.047183624
1661 robined01 1952 0 NLS195207080 AL 3 16.53199995 -9.105516018 0.0 2 0.0 0.10441263099999999 -0.057508522 0.0 0.046904109000000006
800 winfida01 1988 0 NLS198807120 AL 9 18.88501024 -10.78294134 0.0 3 0.0 0.099979466 -0.05708616 0.0 0.042893306
2225 ortizda01 2005 0 ALS200507120 AL 10 26.81380577 -11.09217649 0.0 3 0.0 0.137899573 -0.057045479 0.0 0.080854093
1092 staubru01 1976 0 NLS197607130 AL 9 12.96547875 -15.19451035 0.0 2 0.0 0.048620545 -0.056979414000000006 0.0 -0.008358869
3118 mccovwi01 1969 0 ALS196907230 NL 3 43.27872019 -9.731735567000001 0.0 4 0.0 0.25333885 -0.056966257 0.0 0.196372593
2573 bonilbo01 1991 0 ALS199107090 NL 10 21.53555162 -8.764464758999999 0.0 4 0.0 0.139690065 -0.056850582000000004 0.0 0.082839482
2814 winfida01 1983 0 ALS198307060 AL 9 19.48081386 -14.16009128 0.0 3 0.0 0.077923255 -0.056640365 0.0 0.02128289
537 gonzaju03 1998 0 NLS199807070 AL 9 24.70849903 -11.63178284 0.0 4 0.0 0.118600795 -0.055832558 0.0 0.062768238
1162 allendi01 1972 0 NLS197207250 AL 3 36.23920494 -10.532477499999999 0.0 3 0.0 0.19185461399999998 -0.055760175 0.0 0.136094439
249 fieldpr01 2007 0 NLS200707100 NL 3 17.65767167 -18.55160336 0.0 2 0.0 0.052973015 -0.05565481 0.0 -0.002681795
172 quentca01 2011 0 NLS201107120 AL   7.469216739 -15.75233897 0.0 2 0.0 0.026361941 -0.05559649 0.0 -0.029234549
2664 jacksbo01 1989 0 ALS198907110 AL 7 7.150177462 -8.258516434 0.0 4 0.0 0.04766785 -0.055056775999999995 0.0 -0.007388926
3614 kinerra01 1950 0 ALS195007110 NL 7 37.63748258 -7.775124487 0.0 6 0.0 0.265676348 -0.054883232000000004 0.0 0.210793116
2290 martied01 2003 0 ALS200307150 AL 10 20.50948474 -10.91242581 0.0 3 0.0 0.102547424 -0.054562129 0.0 0.047985295
3239 colavro01 1965 0 ALS196507130 AL 9 16.16346094 -9.065032409 0.0 4 0.0 0.096980766 -0.054390194 0.0 0.042590570999999994
3284 wagnele01 1963 0 ALS196307090 AL 7 13.30951339 -10.49809978 0.0 3 0.0 0.068448926 -0.053990227 0.0 0.014458698999999998
2790 oliveal01 1983 0 ALS198307060 NL 3 12.41154627 -10.44115059 0.0 3 0.0 0.063830809 -0.05369734599999999 0.0 0.010133464
2230 ramirma02 2005 0 ALS200507120 AL 7 29.28837451 -15.36739772 0.0 2 0.0 0.10041728400000001 -0.05268822099999999 0.0 0.047729062999999995
2605 tartada01 1991 0 ALS199107090 AL 10 24.49470547 -15.80636461 0.0 2 0.0 0.081649018 -0.052687882000000005 0.0 0.028961136000000002
3192 killeha01 1967 0 ALS196707110 AL 3 32.42382258 -7.594244304 0.0 6 0.0 0.224472618 -0.052575537 0.0 0.17189708
947 jacksre01 1982 0 NLS198207130 AL 9 23.02168726 -16.59304121 0.0 2 0.0 0.072700065 -0.052399077 0.0 0.020300988
2460 o'neipa01 1997 0 ALS199707080 AL 9 15.88329662 -13.41424804 0.0 2 0.0 0.061483729 -0.051926121 0.0 0.009557607
3082 torrejo01 1971 0 ALS197107130 NL 5 25.65968591 -9.229179667999999 0.0 3 0.0 0.144335733 -0.051914136 0.0 0.09242159800000001
3052 maybejo01 1973 0 ALS197307240 AL 3 25.63027734 -7.569132442000001 0.0 4 0.0 0.17575047300000002 -0.051902622 0.0 0.123847851
532 thomeji01 1998 0 NLS199807070 AL 3 36.16284475 -10.80493676 0.0 4 0.0 0.173581655 -0.051863695999999994 0.0 0.121717958
2639 guerrpe01 1989 0 ALS198907110 NL 10 17.96869344 -15.535685500000001 0.0 2 0.0 0.059895645 -0.051785618 0.0 0.008110026
903 jacksre01 1984 0 NLS198407100 AL 9 -4.727754143 -13.80702719 0.0 2 0.0 -0.017729078 -0.051776352000000005 0.0 -0.06950543
263 jeterde01 2007 0 NLS200707100 AL 6 22.05371764 -10.63458438 0.0 3 0.0 0.107288356 -0.051735816 0.0 0.05555254
1872 foxxji01 1938 0 NLS193807060 AL 3 36.0090945 -7.277545529 0.0 4 0.0 0.254181844 -0.05137091 0.0 0.202810934
609 gwynnto01 1994 0 NLS199407120 NL 8 25.83439597 -6.637293509 0.0 5 0.0 0.198726123 -0.051056104000000005 0.0 0.147670019
3472 thomafr03 1958 0 ALS195807080 NL 5 6.640849202999999 -7.207630416000001 0.0 4 0.0 0.046876583 -0.050877390999999994 0.0 -0.004000809
1009 luzingr01 1978 0 NLS197807110 NL 7 26.51063515 -10.72749382 0.0 3 0.0 0.12557669300000002 -0.050814444 0.0 0.074762248
2942 luzingr01 1977 0 ALS197707190 NL 7 26.36179037 -15.601816099999999 0.0 2 0.0 0.08549769800000001 -0.050600485 0.0 0.034897213999999996
3299 cepedor01 1962 1 ALS196207100 NL 3 24.093850399999997 -9.551254381 0.0 3 0.0 0.127555679 -0.050565464000000004 0.0 0.076990214
2446 anderbr01 1997 0 ALS199707080 AL 7 21.10515095 -6.527918561 0.0 4 0.0 0.163394717 -0.05053872400000001 0.0 0.112855993
1128 burroje01 1974 0 NLS197407230 AL 7 24.11503828 -15.15933716 0.0 2 0.0 0.08038346099999999 -0.050531124000000004 0.0 0.029852337000000003
2280 delgaca01 2003 0 ALS200307150 AL 3 29.16482837 -10.10600406 0.0 3 0.0 0.145824142 -0.05053002 0.0 0.095294122
1319 willibi01 1964 0 NLS196407070 NL 7 21.81557601 -7.5221322939999995 0.0 4 0.0 0.145437173 -0.05014754900000001 0.0 0.095289625
2623 gwynnto01 1989 0 ALS198907110 NL 9 25.25619172 -10.02821117 0.0 3 0.0 0.126280959 -0.050141055999999996 0.0 0.076139903
3346 whitebi03 1961 2 ALS196107310 NL 3 5.580021656 -7.30747354 0.0 4 0.0 0.038263006 -0.05010839 0.0 -0.011845383999999999
359 guerrvl01 2004 0 NLS200407130 AL 9 33.45892299 -8.764850982999999 0.0 4 0.0 0.19119384600000003 -0.050084863 0.0 0.14110898300000002
3431 skinnbo01 1960 1 ALS196007110 NL 7 7.586656262000001 -7.717044005 0.0 4 0.0 0.049210743 -0.050056502 0.0 -0.0008457580000000001
1216 howarfr01 1970 0 NLS197007140 AL 7 35.89640093 -19.52739933 0.0 2 0.0 0.091650385 -0.04985719 0.0 0.041793196
2756 winfida01 1985 0 ALS198507160 AL 9 19.66058811 -9.691182151 0.0 3 0.0 0.101111596 -0.049840365 0.0 0.051271230999999994
2498 thomafr04 1995 0 ALS199507110 AL 3 48.22584292 -14.95198669 0.0 2 0.0 0.16075281 -0.049839956 0.0 0.110912854
985 carewro01 1980 0 NLS198007080 AL 3 19.62945238 -9.407419743 0.0 3 0.0 0.10392063 -0.049803987 0.0 0.054116643
125 fieldpr01 2011 0 NLS201107120 NL 3 26.56729954 -13.27004361 0.0 2 0.0 0.099627373 -0.049762664000000005 0.0 0.04986471
633 thomafr04 1994 0 NLS199407120 AL 3 50.71091797 -12.69995677 0.0 3 0.0 0.19843402699999999 -0.049695483 0.0 0.148738544
475 giambja01 2000 0 NLS200007110 AL 3 39.58640925 -11.85023236 0.0 3 0.0 0.16571055 -0.049605624 0.0 0.116104927
1783 ottme01 1942 0 NLS194207060 NL 9 28.07987538 -7.0196520389999995 0.0 4 0.0 0.198210885 -0.049550485 0.0 0.1486604
2094 ethiean01 2010 0 ALS201007130 NL 8 17.43167461 -14.37976875 0.0 2 0.0 0.059765742000000004 -0.04930206400000001 0.0 0.010463677
3480 jenseja01 1958 0 ALS195807080 AL 9 16.18651192 -6.690195364 0.0 4 0.0 0.11772008699999999 -0.048655965999999995 0.0 0.06906412
1754 walkedi02 1944 0 NLS194407110 NL 9 26.07413189 -7.905226763 0.0 4 0.0 0.160456196 -0.048647549000000005 0.0 0.111808647
3229 stargwi01 1965 0 ALS196507130 NL 7 9.186368853 -10.51212899 0.0 3 0.0 0.042398625 -0.048517517999999996 0.0 -0.006118893
2613 baineha01 1991 0 ALS199107090 AL   15.14296496 -14.34180485 0.0 2 0.0 0.05047655 -0.04780601599999999 0.0 0.0026705340000000004
879 washicl01 1984 0 NLS198407100 NL   6.7076301229999995 -13.50719516 0.0 2 0.0 0.023673989 -0.047672454 0.0 -0.023998465
1040 ziskri01 1978 0 NLS197807110 AL 9 9.352626073 -8.735854819 0.0 3 0.0 0.05101432400000001 -0.047650117 0.0 0.003364207
1935 gehrilo01 1934 0 NLS193407100 AL 3 55.76547121 -6.983791739 0.0 5 0.0 0.380219122 -0.047616762 0.0 0.33260236

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