mlb-allstar-teams/allstar_team_talent

172 rows sorted by gameID

View and edit SQL

Suggested facets: gameNum, lgID

Link rowid yearID gameNum gameID ▼ lgID tm_OFF_talent tm_DEF_talent tm_PIT_talent MLB_avg_RPG talent_RSPG talent_RAPG unadj_PYTH timeline_adj SOS adj_PYTH no_1_player no_2_player
16 1933 0 ALS193307060 AL 1.291067447 0.131162071 0.453936381 4.48 5.771067447 3.894901548 0.672504667 0.766824645 0.383412322 0.560808926 ruthba01 grovele01
124 1933 0 ALS193307060 NL 0.853086062 -0.060718015 0.491376914 4.48 5.333086062 4.049341101 0.623384301 0.766824645 0.383412322 0.50721158 warnelo01 kleinch01
24 1935 0 ALS193507080 AL 1.30355425 0.128961678 0.540451796 4.9 6.20355425 4.230586526000001 0.668296537 0.772511848 0.386255924 0.559075963 foxxji01 gehrilo01
134 1935 0 ALS193507080 NL 1.0584755559999999 0.081320827 0.261973613 4.9 5.958475556000001 4.556705561 0.620302654 0.772511848 0.386255924 0.5069383470000001 vaughar01 ottme01
17 1937 0 ALS193707070 NL 1.469974764 0.167561414 0.421938285 4.87 6.339974764 4.2805003 0.6723499740000001 0.7781990520000001 0.38909952600000003 0.566536536 vaughar01 medwijo01
60 1937 0 ALS193707070 AL 1.2697076520000001 0.102857179 0.38258138399999997 4.87 6.139707652 4.3845614369999995 0.649339725 0.7781990520000001 0.38909952600000003 0.541166419 gehrich01 gehrilo01
20 1939 0 ALS193907110 AL 1.083899496 0.17394331600000001 0.637211285 4.82 5.903899496 4.008845399 0.670049937 0.783886256 0.391943128 0.566911044 dimagjo01 fellebo01
100 1939 0 ALS193907110 NL 1.091412518 0.163190673 0.283989305 4.82 5.911412518 4.372820022 0.634530458 0.783886256 0.391943128 0.528108004 ottme01 vaughar01
4 1941 0 ALS194107080 AL 1.4721073169999999 0.090802631 0.616915118 4.49 5.962107317 3.7822822510000003 0.696952227 0.78957346 0.39478673 0.60003026 dimagjo01 willite01
104 1941 0 ALS194107080 NL 0.865196605 0.10929283 0.40968469999999996 4.49 5.355196605 3.9710224710000004 0.633497374 0.78957346 0.39478673 0.529967776 mizejo01 reisepe01
118 1943 0 ALS194307130 NL 0.794005405 0.123842774 0.224699702 3.91 4.704005405 3.5614575239999997 0.624615963 0.7952606640000001 0.39763033200000003 0.523442509 musiast01 coopemo01
168 1943 0 ALS194307130 AL 0.565686742 -0.021919415 0.164706943 3.91 4.475686742 3.7672124719999998 0.578191518 0.7952606640000001 0.39763033200000003 0.475022114 hughste01 doerrbo01
7 1946 0 ALS194607090 AL 0.962761269 0.183703731 0.583348315 4.01 4.972761268999999 3.242947954 0.686178031 0.8037914690000001 0.401895735 0.595015547 willite01 newhoha01
172 1946 0 ALS194607090 NL 0.435360098 0.06455843900000001 0.130359685 4.01 4.445360098 3.8150818760000003 0.569498347 0.8037914690000001 0.401895735 0.470592058 musiast01 kurowwh01
130 1948 0 ALS194807130 NL 0.8232397379999999 0.080752826 0.377922818 4.58 5.403239738 4.121324356000001 0.621426695 0.809478673 0.404739336 0.527435434 musiast01 mizejo01
170 1948 0 ALS194807130 AL 0.538847851 0.14590435300000001 0.08984467900000001 4.58 5.118847851 4.344250968 0.574505863 0.809478673 0.404739336 0.478638756 boudrlo01 henrito01
115 1950 0 ALS195007110 NL 1.0929853170000001 0.034095825 0.33117278699999997 4.85 5.942985317000001 4.484731388 0.626025937 0.815165877 0.40758293799999995 0.535251149 musiast01 kinerra01
160 1950 0 ALS195007110 AL 0.92905268 0.107794343 0.159934797 4.85 5.77905268 4.58227086 0.604593622 0.815165877 0.40758293799999995 0.5126663020000001 dobyla01 willite01
28 1951 0 ALS195107100 NL 1.267046519 0.135941131 0.394343302 4.55 5.817046519 4.0197155669999995 0.662920033 0.8180094790000001 0.409004739 0.576458762 robinja02 musiast01
109 1951 0 ALS195107100 AL 0.880162578 0.089970399 0.399959939 4.55 5.430162577999999 4.060069662 0.62997444 0.8180094790000001 0.409004739 0.540914786 willite01 garvene01
21 1954 0 ALS195407130 NL 1.113185914 0.08980519099999999 0.544959811 4.38 5.493185914 3.7452349989999996 0.6683948160000001 0.826540284 0.413270142 0.586731779 snidedu01 roberro01
31 1954 0 ALS195407130 AL 1.3485066959999998 0.193099623 0.210156722 4.38 5.728506696 3.976743655 0.661040525 0.826540284 0.413270142 0.5787079279999999 mantlmi01 rosenal01
69 1956 0 ALS195607100 AL 1.0562675129999999 0.052171785 0.42711082899999997 4.45 5.506267512999999 3.9707173860000005 0.6452674110000001 0.832227488 0.416113744 0.564526415 mantlmi01 willite01
74 1956 0 ALS195607100 NL 0.837833961 0.217435658 0.39975979 4.45 5.2878339610000005 3.832804552 0.64311634 0.832227488 0.416113744 0.5622179110000001 mayswi01 antonjo02
94 1958 0 ALS195807080 NL 1.0505883 0.213495692 0.14270440199999998 4.28 5.3305883000000005 3.923799906 0.6366177160000001 0.837914692 0.418957346 0.558150394 mayswi01 aaronha01
126 1958 0 ALS195807080 AL 1.054736708 0.07521514 0.150704633 4.28 5.334736708 4.054080228 0.6230146529999999 0.837914692 0.418957346 0.543715265 mantlmi01 willite01
75 1960 1 ALS196007110 NL 1.178929527 0.16070267300000002 0.165485201 4.31 5.488929527000001 3.983812126 0.6425626329999999 0.8436018959999999 0.42180094799999995 0.567367713 mayswi01 bankser01
171 1960 1 ALS196007110 AL 0.6286712170000001 0.08881624 -0.01157894 4.31 4.938671217 4.2327627 0.570100642 0.8436018959999999 0.42180094799999995 0.49172003299999995 mantlmi01 marisro01
64 1960 2 ALS196007130 NL 1.028579076 0.163414699 0.311361672 4.31 5.338579076 3.8352236289999997 0.646854027 0.8436018959999999 0.42180094799999995 0.571960508 mayswi01 bankser01
162 1960 2 ALS196007130 AL 0.743714443 0.16144499199999998 0.095169164 4.31 5.0537144430000005 4.053385844 0.599563062 0.8436018959999999 0.42180094799999995 0.522050735 mantlmi01 marisro01
27 1961 2 ALS196107310 AL 1.156030321 0.22106651600000002 0.403826302 4.53 5.6860303210000005 3.905107182 0.665428508 0.846445498 0.423222749 0.593396213 mantlmi01 cashno01
159 1961 2 ALS196107310 NL 0.91978178 0.05325322 0.157168374 4.53 5.44978178 4.319578406000001 0.6047566520000001 0.846445498 0.423222749 0.5289094679999999 mayswi01 matheed01
132 1962 1 ALS196207100 NL 0.724825442 0.22119381100000002 0.277471058 4.46 5.184825442 3.9613351310000002 0.620707845 0.8492890999999999 0.42464455 0.5470647989999999 mayswi01 drysddo01
140 1962 1 ALS196207100 AL 0.746446677 0.076326062 0.35344539700000005 4.46 5.206446677 4.0302285410000005 0.615056217 0.8492890999999999 0.42464455 0.541127073 pascuca02 mantlmi01
116 1963 0 ALS196307090 NL 0.88756209 0.09270855300000001 0.199336252 3.95 4.83756209 3.657955196 0.625157355 0.8521327009999999 0.426066351 0.553192541 mayswi01 aaronha01
165 1963 0 ALS196307090 AL 0.32920684100000003 0.173255338 0.279704264 3.95 4.279206841000001 3.497040398 0.591310779 0.8521327009999999 0.426066351 0.517859401 kalinal01 radatdi01
11 1965 0 ALS196507130 NL 1.195850758 0.003355371 0.580036695 3.99 5.185850758 3.4066079339999997 0.68330385 0.857819905 0.42890995299999995 0.618384515 mayswi01 maricju01
163 1965 0 ALS196507130 AL 0.651975846 0.025031354 0.23977473800000002 3.99 4.641975846 3.725193908 0.5993214929999999 0.857819905 0.42890995299999995 0.529051962 killeha01 mcdowsa01
29 1967 0 ALS196707110 NL 1.070869316 0.116570874 0.307666422 3.77 4.840869316 3.3457627039999998 0.662845652 0.863507109 0.431753555 0.5990002170000001 clemero01 aaronha01
59 1967 0 ALS196707110 AL 1.02409264 0.190399331 0.161901661 3.77 4.79409264 3.417699008 0.65006001 0.863507109 0.431753555 0.5853081489999999 yastrca01 killeha01
38 1969 0 ALS196907230 NL 0.955592964 0.08107131299999999 0.48245525 4.07 5.025592963999999 3.506473437 0.65896307 0.8691943129999999 0.43459715600000004 0.5976199010000001 mccovwi01 aaronha01
48 1969 0 ALS196907230 AL 1.130014794 0.130412686 0.261701748 4.07 5.200014793999999 3.677885566 0.6533442429999999 0.8691943129999999 0.43459715600000004 0.5916167520000001 petrori01 jacksre01
119 1971 0 ALS197107130 NL 1.030777335 -0.008171438 0.171504847 3.89 4.920777335 3.7266665910000003 0.624490608 0.874881517 0.437440758 0.563922696 benchjo01 clemero01
120 1971 0 ALS197107130 AL 0.828100477 -0.010847288 0.32216181 3.89 4.718100477 3.578685478 0.623828805 0.874881517 0.437440758 0.563228806 yastrca01 bluevi01
58 1973 0 ALS197307240 NL 1.074156644 0.150675624 0.29267437399999996 4.21 5.284156643999999 3.766650002 0.650105834 0.88056872 0.44028436 0.5937516270000001 morgajo02 cedence01
136 1973 0 ALS197307240 AL 0.8144052490000001 0.15133365099999999 0.21284151899999998 4.21 5.024405249 3.84582483 0.619916482 0.88056872 0.44028436 0.5619760570000001 jacksre01 murcebo01
36 1975 0 ALS197507150 AL 1.0143981229999999 0.129187494 0.43632779899999996 4.21 5.224398123 3.6444847069999997 0.659042018 0.8862559240000001 0.44312796200000004 0.606005269 carewro01 jacksre01
55 1975 0 ALS197507150 NL 1.0443694609999998 0.143322863 0.32639720899999997 4.21 5.2543694610000005 3.740279928 0.650676959 0.8862559240000001 0.44312796200000004 0.597134419 morgajo02 benchjo01
41 1977 0 ALS197707190 NL 1.026914672 0.100143064 0.5297740360000001 4.47 5.496914672000001 3.8400828999999996 0.6584530820000001 0.891943128 0.445971564 0.608127347 morgajo02 seaveto01
91 1977 0 ALS197707190 AL 0.774968518 0.256305343 0.357952806 4.47 5.244968518 3.8557418510000003 0.637169895 0.891943128 0.445971564 0.585681425 carewro01 brettge01
121 1979 0 ALS197907170 AL 0.901764275 0.094497835 0.298045199 4.46 5.361764275 4.067456966 0.6237705570000001 0.897630332 0.448815166 0.574472919 brettge01 riceji01
139 1979 0 ALS197907170 NL 0.957583375 0.105601735 0.16962281199999998 4.46 5.417583375 4.184775453 0.615975335 0.897630332 0.448815166 0.566366351 parkeda01 winfida01
98 1981 0 ALS198108090 AL 0.900613112 0.135425179 0.24644750199999998 4.0 4.900613112 3.6181273189999996 0.635347872 0.903317536 0.451658768 0.589344934 brettge01 winfida01
151 1981 0 ALS198108090 NL 0.6430053020000001 0.143997339 0.216713894 4.0 4.643005302 3.639288767 0.609625823 0.903317536 0.451658768 0.562611823 schmimi01 dawsoan01
93 1983 0 ALS198307060 AL 0.915550525 -0.012827452 0.476485518 4.31 5.225550525 3.846341934 0.636633188 0.909004739 0.45450237 0.593459516 yountro01 stiebda01
95 1983 0 ALS198307060 NL 0.852715388 0.19717310899999999 0.31043071899999997 4.31 5.1627153880000005 3.802396172 0.636376452 0.909004739 0.45450237 0.593191768 schmimi01 dawsoan01
57 1985 0 ALS198507160 AL 1.034757154 0.075471416 0.43054629899999997 4.33 5.364757153999999 3.823982284 0.6501190410000001 0.914691943 0.45734597200000005 0.610289836 henderi01 ripkeca01
169 1985 0 ALS198507160 NL 0.5972544679999999 0.12428192699999999 0.04063967 4.33 4.927254468 4.165078403 0.576281198 0.914691943 0.45734597200000005 0.534070591 smithoz01 murphda05
141 1987 0 ALS198707140 NL 0.8305745609999999 0.037266519 0.38542919200000003 4.72 5.550574561 4.2973042889999995 0.6149864629999999 0.920379147 0.46018957299999996 0.576578233 daviser01 raineti01
146 1987 0 ALS198707140 AL 0.8672747129999999 -0.004033881 0.36992878 4.72 5.587274712999999 4.3541051 0.6121483529999999 0.920379147 0.46018957299999996 0.573653277 saberbr01 boggswa01
113 1989 0 ALS198907110 NL 0.947211831 0.054290532 0.24687662300000002 4.13 5.0772118310000005 3.828832846 0.626312627 0.9260663509999999 0.463033175 0.59104632 smithoz01 mitchke01
148 1989 0 ALS198907110 AL 0.706172281 -0.029731933 0.389057064 4.13 4.8361722810000005 3.7706748689999996 0.611929795 0.9260663509999999 0.463033175 0.576224544 boggswa01 puckeki01
123 1991 0 ALS199107090 AL 0.8887552609999999 0.09135856199999999 0.27243305100000004 4.31 5.1987552610000005 3.946208387 0.6235080789999999 0.931753555 0.465876777 0.590917542 ripkeca01 griffke02
145 1991 0 ALS199107090 NL 0.690815705 0.01222347 0.416390065 4.31 5.000815705 3.881386465 0.613900502 0.931753555 0.465876777 0.5810371320000001 glavito02 sandbry01
77 1993 0 ALS199307130 AL 0.8801828209999999 0.075762297 0.544691757 4.6 5.4801828210000005 3.9795459460000004 0.642342641 0.9374407579999999 0.46872037899999996 0.613076885 griffke02 langsma01
110 1993 0 ALS199307130 NL 1.147892873 0.019452419 0.27705077 4.6 5.747892873 4.3034968110000005 0.629392596 0.9374407579999999 0.46872037899999996 0.599727505 bondsba01 larkiba01
42 1995 0 ALS199507110 AL 1.008243665 0.038629643 0.688318352 4.85 5.858243665 4.123052005 0.655385859 0.943127962 0.471563981 0.62923395 johnsra05 loftoke01
143 1995 0 ALS199507110 NL 1.25251296 -0.034988166 0.152659646 4.85 6.10251296 4.73232852 0.614279826 0.943127962 0.471563981 0.586974357 bondsba01 piazzmi01
9 1997 0 ALS199707080 AL 1.25400407 0.10923351099999999 0.716845154 4.77 6.02400407 3.943921335 0.6846328759999999 0.9488151659999999 0.47440758299999997 0.662104362 griffke02 rodrial01
10 1997 0 ALS199707080 NL 1.407035117 0.050811734000000004 0.668059504 4.77 6.177035117000001 4.051128763 0.683947413 0.9488151659999999 0.47440758299999997 0.661394151 bondsba01 maddugr01
52 1999 0 ALS199907130 AL 0.9713613940000001 0.102124479 0.680156781 5.08 6.051361394 4.29771874 0.651632776 0.95450237 0.477251185 0.630687165 martipe02 loftoke01
54 1999 0 ALS199907130 NL 1.184763191 0.014131353000000001 0.609535166 5.08 6.264763191 4.456333481000001 0.6509742629999999 0.95450237 0.477251185 0.630011539 schilcu01 bagweje01
18 2001 0 ALS200107100 NL 1.732530231 -0.110363805 0.49123929200000005 4.78 6.512530231 4.399124513 0.672155473 0.960189573 0.480094787 0.6543661820000001 johnsra05 bondsba01
96 2001 0 ALS200107100 AL 1.164749362 0.030038806 0.364659199 4.78 5.9447493620000005 4.385301995 0.635706536 0.960189573 0.480094787 0.617066232 rodrial01 suzukic01
32 2003 0 ALS200307150 NL 1.27349007 0.142248744 0.41198946 4.73 6.00349007 4.175761796000001 0.660241551 0.9658767770000001 0.48293838899999997 0.6447630560000001 bondsba01 pujolal01
108 2003 0 ALS200307150 AL 1.012007575 -0.08896060800000001 0.532143069 4.73 5.742007575 4.286817538999999 0.6306121 0.9658767770000001 0.48293838899999997 0.61457176 rodrial01 muldema01
103 2005 0 ALS200507120 NL 0.8224174670000001 0.045980764 0.531435294 4.59 5.412417467 4.012583942 0.6335894120000001 0.971563981 0.485781991 0.62028527 pujolal01 clemero02
114 2005 0 ALS200507120 AL 1.091657733 -0.105425984 0.408796719 4.59 5.681657733 4.286629265 0.626115628 0.971563981 0.485781991 0.6127059970000001 rodrial01 guerrvl01
63 2008 0 ALS200807150 NL 1.109584623 0.065292826 0.449417357 4.65 5.759584622999999 4.135289817 0.647094845 0.9800947870000001 0.490047393 0.6379500610000001 pujolal01 wrighda03
152 2008 0 ALS200807150 AL 0.8193948459999999 -0.068336185 0.43018479600000004 4.65 5.469394846 4.288151388999999 0.609512005 0.9800947870000001 0.490047393 0.59999535 sizemgr01 riverma01
23 2010 0 ALS201007130 NL 0.985462955 0.067194745 0.654112406 4.38 5.365462955 3.65869285 0.668335063 0.985781991 0.492890995 0.662001524 johnsjo09 jimenub01
154 2010 0 ALS201007130 AL 0.772858383 -0.023845724 0.35279753 4.38 5.152858383 4.051048194 0.608319539 0.985781991 0.492890995 0.601523244 hamiljo03 longoev01
79 2012 0 ALS201207100 AL 0.948809045 -0.025646633999999998 0.512060124 4.32 5.268809045 3.83358651 0.641515176 0.9914691940000001 0.49573459700000005 0.637581961 troutmi01 beltrad01
81 2012 0 ALS201207100 NL 0.942578925 0.030302795 0.454782625 4.32 5.262578925 3.834914581 0.640871219 0.9914691940000001 0.49573459700000005 0.636934938 braunry02 vottojo01
43 2014 0 ALS201407150 NL 0.9642164040000001 0.105466047 0.41296974799999997 4.07 5.0342164039999995 3.551564206 0.6543988479999999 0.997156398 0.498578199 0.653111494 mccutan01 tulowtr01
85 2014 0 ALS201407150 AL 0.959654351 -0.033185201 0.42747889899999997 4.07 5.0296543510000005 3.675706302 0.63966234 0.997156398 0.498578199 0.6383504289999999 troutmi01 cabremi01
3 1934 0 NLS193407100 AL 1.7786613230000001 0.11665370300000001 0.627668598 4.91 6.688661323 4.165677699 0.704031203 0.769668246 0.384834123 0.598084237 hardeme01 foxxji01
128 1934 0 NLS193407100 NL 0.76890817 0.02850947 0.5609842629999999 4.91 5.67890817 4.320506267 0.622529153 0.769668246 0.384834123 0.507803757 deandi01 hubbeca01
14 1936 0 NLS193607070 AL 1.3491187169999999 0.151146853 0.683351699 5.19 6.539118717000001 4.355501449 0.67779211 0.77535545 0.387677725 0.5711535879999999 grovele01 gehrilo01
125 1936 0 NLS193607070 NL 0.7433054179999999 0.124014205 0.56054366 5.19 5.933305418 4.505442135 0.623349732 0.77535545 0.387677725 0.5116744520000001 hubbeca01 medwijo01
13 1938 0 NLS193807060 AL 1.351551219 0.006992147 0.735384204 4.89 6.241551219 4.147623649 0.678722809 0.7810426540000001 0.39052132700000003 0.57512372 grovele01 dimagjo01
164 1938 0 NLS193807060 NL 0.8871398559999999 0.07783231 0.147711346 4.89 5.777139856 4.6644563439999995 0.596645068 0.7810426540000001 0.39052132700000003 0.486599244 ottme01 medwijo01
5 1940 0 NLS194007090 AL 1.35655725 0.138973429 0.6733283520000001 4.68 6.03655725 3.8676982189999998 0.6931035409999999 0.786729858 0.393364929 0.594229847 dimagjo01 newsobo01
155 1940 0 NLS194007090 NL 0.691021887 0.114941007 0.333660737 4.68 5.371021887 4.231398256 0.60740776 0.786729858 0.393364929 0.500809789 vaughar01 mizejo01
12 1942 0 NLS194207060 AL 1.120247091 0.23040937399999997 0.41741387700000004 4.08 5.2002470910000005 3.43217675 0.681437527 0.7924170620000001 0.39620853100000003 0.583971339 willite01 bentoal01
144 1942 0 NLS194207060 NL 0.6306151879999999 0.07345551 0.351797845 4.08 4.710615188 3.654746645 0.614066673 0.7924170620000001 0.39620853100000003 0.510785991 coopemo01 ottme01
68 1944 0 NLS194407110 NL 1.113287908 0.087423074 0.27880336699999997 4.17 5.283287908 3.803773558 0.645943526 0.798104265 0.399052133 0.547813334 musiast01 galanau01
138 1944 0 NLS194407110 AL 0.699923788 0.067698078 0.372859987 4.17 4.869923788 3.729441935 0.619701164 0.798104265 0.399052133 0.519705761 doerrbo01 johnsbo01
86 1947 0 NLS194707080 AL 0.8492061959999999 0.210757257 0.339454104 4.36 5.209206196 3.8097886389999998 0.639345002 0.806635071 0.40331753600000003 0.545092522 willite01 newhoha01
97 1947 0 NLS194707080 NL 0.64933793 0.068721833 0.5954379 4.36 5.00933793 3.695840267 0.635641246 0.806635071 0.40331753600000003 0.54111556 blackew01 mizejo01

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "mlb-allstar-teams/allstar_team_talent" (
"yearID" INTEGER,
  "gameNum" INTEGER,
  "gameID" TEXT,
  "lgID" TEXT,
  "tm_OFF_talent" REAL,
  "tm_DEF_talent" REAL,
  "tm_PIT_talent" REAL,
  "MLB_avg_RPG" REAL,
  "talent_RSPG" REAL,
  "talent_RAPG" REAL,
  "unadj_PYTH" REAL,
  "timeline_adj" REAL,
  "SOS" REAL,
  "adj_PYTH" REAL,
  "no_1_player" TEXT,
  "no_2_player" TEXT
);
Powered by Datasette · Query took 126.129ms