107,357 rows sorted by G_all

View and edit SQL

Link rowid yearID teamID lgID playerID G_all ▼ GS G_batting G_defense G_p G_c G_1b G_2b G_3b G_ss G_lf G_cf G_rf G_of G_dh G_ph G_pr
1 1871 TRO   abercda01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
7 1871 RC1   barkeal01 1 1 1 1 0 0 0 0 0 0 1 0 0 1 0 0 0
9 1871 FW1   barrebi01 1 1 1 1 0 1 0 0 1 0 0 0 0 0 0 0 0
12 1871 CL1   battijo01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
17 1871 PH1   berkena01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
18 1871 PH1   berryto01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
20 1871 FW1   biermch01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
36 1871 CL1   ewellge01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
40 1871 NY2   fleetfr01 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0
80 1871 WS3   nortofr01 1 0 1 1 0 0 0 0 1 0 0 0 1 1 0 0 0
84 1871 FW1   phelpne01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
88 1871 PH1   prattto01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
109 1871 WS3   whitewa01 1 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0
127 1872 WS3   barrebi01 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0
165 1872 BR1   fletcge01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
171 1872 BR2   galvijo01 1 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0
175 1872 WS4   glennjo01 1 1 1 1 0 0 0 0 0 0 0 1 0 1 0 0 0
185 1872 BR2   higby01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
215 1872 BR1   mcdonja01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
221 1872 WS4   millejo01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
225 1872 CL1   mulle01 1 0 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
229 1872 BR1   orour01 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0
244 1872 PH1   senseco01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
249 1872 WS4   spenc01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
265 1872 BR2   worthhe01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
268 1872 WS4   yeatmbi01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
282 1873 BL1   barrebi01 1   1   0 0 0 0 0 1 0 0 1 1 0    
283 1873 PH1   battijo01 1   1   0 0 0 0 0 0 0 1 0 1 0    
300 1873 ELI   cranefr01 1   1   0 0 0 1 0 0 0 0 0 0 0    
307 1873 BR2   doschhe01 1   1   0 0 0 0 0 0 0 1 0 1 0    
309 1873 BL4   eland01 1   1   0 0 0 0 0 0 0 0 1 1 0    
321 1873 BL4   goldswa01 1   1   0 0 0 1 0 0 0 0 0 0 0    
332 1873 BL4   johnsto01 1   1   0 0 0 0 0 0 1 0 0 1 0    
333 1873 BL4   jones01 1   1   0 0 0 0 0 0 0 1 0 1 0    
335 1873 BR2   kesslhe01 1   1   0 0 1 0 0 0 0 0 0 0 0    
340 1873 ELI   lovetle01 1   1   1 0 0 0 0 0 0 0 0 0 0    
347 1873 BL4   mcdoo01 1   1   1 0 0 0 0 0 0 0 0 0 0    
359 1873 NY2   phelpne01 1   1   0 0 1 0 0 0 0 0 1 1 0    
361 1873 BL4   popplge01 1   1   0 0 0 0 1 0 0 1 0 1 0    
364 1873 WS5   reachbo01 1   1   0 0 0 0 0 1 0 0 0 0 0    
370 1873 BL4   selmafr01 1   1   1 0 0 0 0 0 0 0 0 0 0    
383 1873 BS1   sweasch01 1   1   0 0 0 1 0 0 0 0 0 0 0    
385 1873 WS5   wallho01 1   1   0 0 0 0 0 1 0 0 0 0 0    
389 1873 ELI   woltery01 1   1   1 0 0 0 0 0 0 0 0 0 0    
390 1873 BL4   woodhre01 1   1   0 0 0 0 0 1 0 0 0 0 0    
407 1874 BL1   boardfr01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
416 1874 BL1   carlle01 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0
422 1874 CH2   connete01 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0
439 1874 BR2   gaver01 1 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0
459 1874 BR2   ledwimi01 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0
464 1874 HR1   mannija01 1 1 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0
470 1874 PH2   mckenfr01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
478 1874 HR1   oneal01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
481 1874 NY2   patteda01 1 1 1 1 0 0 1 0 0 0 1 0 0 1 0 0 0
486 1874 PH2   quinl01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
489 1874 BL1   reedhu01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
491 1874 BL1   revilhe01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
498 1874 NY2   shaffor01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
501 1874 BR2   snowch01 1 0 1 1 0 0 0 0 0 0 0 1 0 1 0 0 0
515 1874 BL1   wood01 1 0 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0
520 1875 BR2   abadijo01 1   1   0 0 1 0 0 0 0 0 0 0 0    
527 1875 BR2   arundha01 1   1   1 0 0 0 0 0 0 0 1 1 0    
529 1875 BR2   barloto01 1   1   0 0 0 1 0 0 0 0 0 0 0    
530 1875 NH1   barloto01 1   1   0 0 0 0 0 1 0 0 0 0 0    
540 1875 BR2   bolan01 1   1   0 0 0 0 1 0 0 0 0 0 0    
542 1875 NH1   booth01 1   1   0 0 0 0 0 1 0 0 0 0 0    
547 1875 CH2   brady01 1   1   0 0 0 0 0 0 0 1 0 1 0    
548 1875 HR1   bradyst01 1   1   0 0 0 0 0 0 0 1 0 1 0    
553 1875 BR2   bushodo01 1   1   0 1 0 0 0 0 0 0 0 0 0    
574 1875 SL1   dillojo01 1   1   0 0 0 0 0 1 0 0 0 0 0    
576 1875 NH1   dolele01 1   1   0 0 0 0 0 0 0 1 0 1 0    
578 1875 BR2   edwar01 1   1   1 0 0 0 0 0 0 1 0 1 0    
581 1875 NH1   evans01 1   1   0 0 0 0 0 0 1 0 0 1 0    
593 1875 BR2   fulmewa01 1   1   0 0 0 0 0 0 0 1 0 1 0    
604 1875 NH1   goldsfr01 1   1   0 0 0 1 0 0 0 0 0 0 0    
611 1875 KEO   hallji01 1   1   0 0 0 0 0 0 1 0 0 1 0    
613 1875 NH1   harriri01 1   1   0 1 0 0 0 1 0 0 0 0 0    
615 1875 NY2   hatfijo01 1   1   0 0 0 0 0 0 1 0 0 1 0    
618 1875 BR2   helli01 1   1   0 0 0 1 0 0 0 0 0 0 0    
625 1875 HR1   jonesch01 1   1   0 0 0 0 0 0 0 1 0 1 0    
630 1875 NH1   knighge01 1   1   1 0 0 0 0 0 0 0 0 0 0    
664 1875 BR2   munnho01 1   1   0 0 0 1 0 0 0 0 0 0 0    
690 1875 BR2   rextewi01 1   1   0 0 0 0 0 0 0 0 1 1 0    
697 1875 WS6   selmafr01 1   1   0 0 1 0 0 0 0 0 0 0 0    
699 1875 BR2   shaff01 1   1   0 0 0 0 0 0 0 0 1 1 0    
701 1875 BR2   sheri01 1   1   0 0 0 0 0 0 1 0 0 1 0    
703 1875 NH1   smithjo01 1   1   0 0 0 0 0 1 0 0 0 0 0    
711 1875 WS6   stevero01 1   1   0 0 0 0 0 0 0 0 1 1 0    
718 1875 BR2   thompfr01 1   1   0 0 0 0 0 0 0 0 1 1 0    
725 1875 BR2   walkeos01 1   1   0 0 1 0 0 0 0 0 1 1 0    
728 1875 PH2   weavesa01 1   1   1 0 0 0 0 0 0 0 0 0 0    
731 1875 WS6   withech01 1   1   1 0 0 0 0 0 0 0 0 0 0    
733 1875 BS1   wrighha01 1   1   0 0 0 0 0 0 0 0 1 1 0    
747 1876 PHN NL berghjo01 1   1   0 1 0 0 0 0 0 1 0 1 0    
776 1876 NY3 NL fairge01 1   1   0 0 0 1 0 0 0 0 0 0 0    
782 1876 NY3 NL forceda01 1   1   0 0 0 0 0 1 0 0 0 0 0    
794 1876 NY3 NL hatfijo01 1   1   0 0 0 1 0 0 0 0 0 0 0    
796 1876 NY3 NL heubege01 1   1   0 0 1 0 0 0 0 0 0 0 0    
805 1876 PHN NL laffefl01 1   1   1 0 0 0 0 0 0 0 0 0 0    
806 1876 NY3 NL larkite01 1   1   1 0 0 0 0 0 0 0 0 0 0    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Appearances" (
"yearID" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "playerID" TEXT,
  "G_all" INTEGER,
  "GS" INTEGER,
  "G_batting" INTEGER,
  "G_defense" INTEGER,
  "G_p" INTEGER,
  "G_c" INTEGER,
  "G_1b" INTEGER,
  "G_2b" INTEGER,
  "G_3b" INTEGER,
  "G_ss" INTEGER,
  "G_lf" INTEGER,
  "G_cf" INTEGER,
  "G_rf" INTEGER,
  "G_of" INTEGER,
  "G_dh" INTEGER,
  "G_ph" INTEGER,
  "G_pr" INTEGER
);