47,628 rows sorted by HR

View and edit SQL

stint

  • 1 43,843
  • 2 3,503
  • 3 174
  • 4 7
  • 5 1
Link rowid playerID yearID stint teamID lgID W L G GS CG SHO SV IPouts H ER HR ▼ BB SO BAOpp ERA IBB WP HBP BK BFP GF R SH SF GIDP
189 coreyfr01 1878 1 PRO NL 1 2 5 5 2 0 0 69 22 6 0 7 7   2.35   1   0 95 0 10      
190 ellicjo01 1878 1 ML2 NL 0 1 1 0 0 0 0 9 1 1 0 1 0   3.0   1   0 11 1 1      
191 fishech01 1878 1 PRO NL 0 1 1 1 1 0 0 27 14 4 0 0 2   4.0   1   0 46 0 12      
193 hankifr01 1878 1 CHN NL 0 1 1 1 1 0 0 27 11 6 0 0 4   6.0   1   0 39 0 9      
198 mccorji01 1878 1 IN1 NL 5 8 14 14 12 1 0 351 128 22 0 15 36   1.69   4   0 490 0 47      
201 nichotr01 1878 1 PRO NL 4 7 11 10 10 0 0 294 157 46 0 8 21   4.22   9   0 464 1 98      
203 reisla01 1878 1 CHN NL 1 3 4 4 4 0 0 108 55 13 0 4 8   3.25   0   0 168 0 34      
210 broutda01 1879 1 TRN NL 0 2 3 2 2 0 0 63 35 13 0 8 6   5.57   4   0 110 1 30      
211 dorgami01 1879 1 SR1 NL 0 0 2 0 0 0 0 36 13 3 0 2 8   2.25   2   0 52 0 6      
214 gardngi01 1879 1 TRN NL 0 2 2 2 2 0 0 42 27 9 0 0 3   5.79   7   0 74 0 21      
215 goldsfr01 1879 1 TRN NL 2 4 8 7 7 0 0 189 61 11 0 1 31   1.57   3   0 258 1 38      
216 hankifr01 1879 1 CHN NL 15 10 26 25 25 2 0 692 248 64 0 27 69   2.5   4   0 1000 1 134      
221 mcgunbi01 1879 1 BFN NL 9 5 14 13 13 2 0 360 113 35 0 16 62   2.63   2   0 496 1 66      
225 neaglja01 1879 1 CN1 NL 0 1 2 2 1 0 0 39 13 5 0 5 4   3.46   1   0 59 0 12      
227 purcebl01 1879 2 CN1 NL 0 2 2 2 2 0 0 54 27 8 0 2 3   4.0   3   0 78 0 15      
228 richmle01 1879 1 BSN NL 1 0 1 1 1 0 0 27 4 2 0 1 11   2.0   1   0 36 0 6      
229 salisha01 1879 1 TRN NL 4 6 10 10 9 0 0 267 103 22 0 11 31   2.22   8   0 400 0 72      
230 tyngji01 1879 1 BSN NL 1 2 3 3 3 0 0 81 35 15 0 6 7   5.0   1   0 126 0 25      
232 wheelha01 1879 1 CN1 NL 0 1 1 1 0 0 0 3 6 9 0 4 0   81.0   1   0 13 0 10      
236 burnsto01 1880 1 CHN NL 0 0 1 0 0 0 0 4 2 0 0 2 1   0.0   0   0 10 0 4      
239 dorgami01 1880 1 PRO NL 0 0 1 0 0 0 0 24 4 1 0 0 2   1.13   0   0 29 1 3      
241 evansja01 1880 1 TRN NL 0 0 1 0 0 0 0 12 11 6 0 0 0   13.5   0   0 21 1 8      
246 guthch01 1880 1 CHN NL 1 0 1 1 1 0 0 27 12 5 0 1 7   5.0   4   0 42 0 8      
247 hankifr01 1880 1 CL2 NL 1 1 4 2 2 0 1 75 20 3 0 3 8   1.08   0   0 96 2 10      
248 hornujo01 1880 1 BFN NL 0 0 1 0 0 0 0 9 2 2 0 1 0   6.0   1   0 13 1 2      
249 keefeti01 1880 1 TRN NL 6 6 12 12 12 0 0 315 68 10 0 16 39   0.86   1   0 397 0 27      
250 kellyki01 1880 1 CHN NL 0 0 1 0 0 0 0 9 3 0 0 1 1   0.0   0   0 13 1 2      
252 learyja01 1880 1 BSN NL 0 1 1 1 0 0 0 9 8 5 0 0 1   15.0   0   0 11 0 5      
254 mcgunbi01 1880 1 BFN NL 2 3 5 5 4 1 0 111 43 14 0 8 3   3.41   1   0 162 0 19      
255 morrijo01 1880 1 BSN NL 0 0 3 0 0 0 0 32 9 1 0 1 0   0.84   0   0 34 2 3      
256 mountfr01 1880 1 TRN NL 1 1 2 2 2 0 0 51 23 10 0 6 2   5.29   1   0 81 0 17      
257 nichotr01 1880 1 WOR NL 0 2 2 2 2 0 0 53 29 8 0 4 4   4.08   1   0 85 0 16      
259 poormto01 1880 2 CHN NL 2 0 2 1 0 0 0 45 12 4 0 8 0   2.4   0   0 67 1 5      
262 stoveha01 1880 1 WOR NL 0 0 2 0 0 0 0 18 8 3 0 3 3   4.5   0   0 29 2 4      
273 foxjo01 1881 1 BSN NL 6 8 17 16 12 0 0 373 144 46 0 39 30   3.33   21   0 556 1 90      
277 learyja01 1881 1 DTN NL 0 2 2 2 1 0 0 39 13 6 0 2 2   4.15   0   0 53 0 6      
280 mathebo01 1881 2 BSN NL 1 0 5 1 1 0 2 69 22 6 0 11 5   2.35   2   0 103 4 11      
283 morrijo01 1881 1 BSN NL 0 1 3 0 0 0 1 17 9 4 0 1 0   6.35   0   0 28 2 8      
290 taylobi01 1881 1 WOR NL 0 1 1 1 1 0 0 24 15 7 0 6 0   7.88   2   0 47 0 13      
291 taylobi01 1881 3 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 1 2   0.0   0   0 10 1 0      
294 whitewi01 1881 1 DTN NL 0 2 2 2 2 0 0 54 24 10 0 2 5   5.0   1   0 83 0 18      
297 willine01 1881 1 CHN NL 1 1 3 1 1 0 0 54 14 4 0 0 2   2.0   1   0 67 2 9      
299 bohnch01 1882 1 LS2 AA 1 1 2 2 2 0 0 54 21 6 0 3 1   3.0   0   0 80 0 8      
300 bondto01 1882 1 WOR NL 0 1 2 2 0 0 0 37 12 6 0 7 2   4.38   1   0 62 0 13      
302 browned01 1882 1 SL4 AA 0 0 1 0 0 0 0 6 2 0 0 0 1   0.0   0   0 8 1 1      
303 brownto01 1882 1 BL2 AA 0 0 2 0 0 0 0 25 13 1 0 6 2   1.08   4   0 45 2 7      
305 burkeja01 1882 1 BFN NL 0 1 1 1 0 0 0 12 10 5 0 0 0   11.25   0   0 23 0 9      
306 clarkjo01 1882 1 WOR NL 1 2 3 3 2 0 0 72 49 12 0 2 3   4.5   3   0 127 0 31      
307 comisch01 1882 1 SL4 AA 0 1 2 1 1 0 0 24 12 0 0 3 2   0.0   1   0 40 0 8      
310 critcmo01 1882 1 PT1 AA 1 0 1 1 1 1 0 27 7 0 0 1 3   0.0   0   0 36 0 0      
314 dorrbe01 1882 1 SL4 AA 2 6 8 8 8 0 0 198 53 19 0 1 34   2.59   1   0 259 0 39      
315 doylejo02 1882 1 SL4 AA 0 3 3 3 3 0 0 72 41 7 0 3 5   2.63   1   0 119 0 33      
316 driscde01 1882 1 PT1 AA 13 9 23 23 23 0 0 603 162 27 0 12 59   1.21   7   0 799 0 73      
319 ewingbu01 1882 1 TRN NL 0 0 1 0 0 0 0 3 2 1 0 1 0   9.0   0   0 6 1 1      
320 foleycu01 1882 1 BFN NL 0 0 1 0 0 0 0 3 2 2 0 0 0   18.0   0   0 6 0 2      
321 fusseed01 1882 1 SL4 AA 1 2 4 2 2 0 1 69 34 12 0 2 3   4.7   1   0 108 2 24      
326 heckegu01 1882 1 LS2 AA 6 6 13 11 10 0 0 312 75 15 0 5 33   1.3   7   0 403 1 49      
327 hoganed01 1882 1 SL4 AA 0 1 1 1 1 0 0 24 10 1 0 0 4   1.13   0   0 35 0 7      
331 learyja01 1882 1 PT1 AA 1 0 3 2 1 0 0 56 28 14 0 3 5   6.75   2   0 89 1 22      
337 mitchbo01 1882 1 SL4 AA 0 1 1 1 0 0 0 21 12 6 0 2 2   7.71   2   0 36 0 13      
338 morrijo01 1882 1 BSN NL 0 0 1 0 0 0 0 6 3 0 0 0 2   0.0   0   0 8 1 0      
339 mountfr01 1882 1 WOR NL 0 5 5 5 5 0 0 126 47 14 0 11 5   3.0   8   0 195 0 30      
348 reynoch01 1882 1 PH4 AA 1 1 2 2 1 0 0 36 18 7 0 3 4   5.25   3   0 58 0 11      
350 robinya01 1882 1 DTN NL 0 0 1 0 0 0 0 6 0 0 0 1 0   0.0   0   0 8 1 0      
352 russjo01 1882 1 BL2 AA 0 0 1 0 0 0 0 9 3 1 0 1 0   3.0   0   0 13 1 1      
355 schenbi01 1882 1 LS2 AA 1 0 2 1 1 0 0 30 6 1 0 1 4   0.9   0   0 38 1 2      
356 seymoja01 1882 1 PT1 AA 0 1 1 1 1 0 0 24 16 7 0 2 2   7.88   5   0 43 0 13      
357 snydege01 1882 1 PH4 AA 1 0 1 1 1 0 0 27 4 0 0 2 0   0.0   1   0 34 0 3      
358 striccu01 1882 1 PH4 AA 1 0 2 0 0 0 0 21 3 1 0 1 2   1.29   0   0 26 2 1      
360 taylobi01 1882 1 PT1 AA 0 1 1 0 0 0 0 15 11 9 0 4 1   16.2   3   0 31 1 10      
364 wheelha01 1882 1 CN2 AA 1 2 4 1 1 0 0 65 21 13 0 12 10   5.4   1   0 100 3 17      
371 wolfji01 1882 1 LS2 AA 0 0 1 0 0 0 0 18 11 6 0 3 1   9.0   2   0 33 1 11      
372 allenmy01 1883 1 NY1 NL 0 1 1 1 1 0 0 24 8 1 0 3 0   1.13   1   0 32 0 5      
373 ansonca01 1883 1 CHN NL 0 0 2 0 0 0 1 9 1 0 0 1 0   0.0   0   0 12 2 1      
374 bakelje01 1883 1 PH4 AA 5 3 8 8 7 0 0 184 65 22 0 12 14   3.23   4   0 267 0 47      
375 bakerno01 1883 1 PT1 AA 0 2 3 3 2 0 0 57 24 7 0 11 5   3.32   1   0 94 0 16      
377 battijo01 1883 1 PT1 AA 0 0 2 0 0 0 0 12 9 1 0 1 0   2.25   0   0 22 1 4      
379 breital01 1883 1 PHI NL 0 1 1 1 0 0 0 15 8 5 0 2 0   9.0   1   0 27 0 9      
380 broutda01 1883 1 BFN NL 0 0 1 0 0 0 0 6 9 7 0 3 2   31.5   0   0 17 0 7      
381 brownto01 1883 1 CL5 AA 0 1 3 1 1 0 0 42 14 9 0 10 6   5.79   1   0 67 2 17      
383 burkeja01 1883 1 BFN NL 0 0 1 1 0 0 0 24 9 5 0 3 1   5.63   0   0 40 0 8      
385 cadych01 1883 1 CL2 NL 0 1 1 1 1 0 0 24 13 7 0 4 5   7.88   3   0 40 0 13      
389 cushmed01 1883 1 BFN NL 3 3 7 7 5 0 0 151 61 22 0 17 34   3.93   4   0 231 1 41      
391 deaglre01 1883 1 CN2 AA 10 8 18 18 17 1 0 444 136 38 0 34 48   2.31   9   0 629 0 78      
393 devinji01 1883 1 BL2 AA 1 1 2 2 1 0 0 33 15 9 0 1 3   7.36   3   0 50 0 15      
394 dolanto01 1883 1 SL4 AA 0 0 1 0 0 0 0 12 4 2 0 0 0   4.5   0   0 16 1 3      
395 dorgami01 1883 1 NY1 NL 0 1 1 1 1 0 0 21 8 3 0 6 3   3.86   1   0 34 0 7      
399 evansja01 1883 1 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 0 1   0.0   0   0 9 1 0      
400 fergubo01 1883 1 PHI NL 0 0 1 0 0 0 0 3 2 1 0 0 0   9.0   0   0 7 1 2      
401 foleycu01 1883 1 BFN NL 1 0 1 0 0 0 0 3 0 0 0 4 0   0.0   0   0 6 1 0      
404 gallabi01 1883 1 BL2 AA 0 5 7 5 4 0 0 155 79 31 0 6 19   5.4   3   0 245 2 57      
409 haganar01 1883 2 BFN NL 0 2 2 2 1 0 0 45 17 6 0 6 7   3.6   3   0 69 0 12      
411 hendeha01 1883 1 PHI NL 0 1 1 1 1 0 0 27 26 19 0 2 2   19.0   4   0 56 0 24      
413 hilsech01 1883 1 PHI NL 0 3 3 3 3 0 0 78 36 16 0 4 8   5.54   1   0 122 0 26      
415 huntele01 1883 1 CL2 NL 0 0 1 0 0 0 0 19 10 1 0 2 4   1.42   0   0 29 1 7      
416 jonesja02 1883 1 DTN NL 6 5 12 12 9 1 0 278 103 36 0 19 33   3.5   4   0 416 0 63      
419 kellyki01 1883 1 CHN NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0   0 3 1 0      
420 lilliji01 1883 1 BFN NL 0 1 3 0 0 0 0 36 16 4 0 2 4   3.0   2   0 55 3 12      
427 mcintfr01 1883 1 DTN NL 1 0 1 1 1 0 0 33 11 1 0 1 0   0.82   0   0 48 0 10      
428 mcintfr01 1883 2 CL5 AA 1 1 2 2 2 0 0 57 20 11 0 7 6   5.21   2   0 86 0 19      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Pitching" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "W" INTEGER,
  "L" INTEGER,
  "G" INTEGER,
  "GS" INTEGER,
  "CG" INTEGER,
  "SHO" INTEGER,
  "SV" INTEGER,
  "IPouts" INTEGER,
  "H" INTEGER,
  "ER" INTEGER,
  "HR" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "BAOpp" REAL,
  "ERA" REAL,
  "IBB" INTEGER,
  "WP" INTEGER,
  "HBP" INTEGER,
  "BK" INTEGER,
  "BFP" INTEGER,
  "GF" INTEGER,
  "R" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);