107,357 rows sorted by G_batting

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
50828 1973 OAK AL abbotgl01 5 3 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
50834 1973 MIN AL alburvi01 14 0 0 14 14 0 0 0 0 0 0 0 0 0 0 0 0
50835 1973 BAL AL alexado01 29 26 0 29 29 0 0 0 0 0 0 0 0 0 0 0 0
50841 1973 CAL AL allenll01 5 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
50842 1973 TEX AL allenll01 23 5 0 23 23 0 0 0 0 0 0 0 0 0 0 0 0
50872 1973 CHA AL baldwda01 3 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0
50874 1973 MIN AL baneed01 23 6 0 23 23 0 0 0 0 0 0 0 0 0 0 0 0
50876 1973 CAL AL barbest01 50 1 0 50 50 0 0 0 0 0 0 0 0 0 0 0 0
50884 1973 NYA AL beenefr01 19 4 0 19 19 0 0 0 0 0 0 0 0 0 0 0 0
50887 1973 ML4 AL bellje01 31 25 0 31 31 0 0 0 0 0 0 0 0 0 0 0 0
50903 1973 MIN AL blylebe01 40 40 0 40 40 0 0 0 0 0 0 0 0 0 0 0 0
50905 1973 BOS AL bolinbo01 39 0 0 39 39 0 0 0 0 0 0 0 0 0 0 0 0
50911 1973 CLE AL bosmadi01 22 17 0 22 22 0 0 0 0 0 0 0 0 0 0 0 0
50912 1973 TEX AL bosmadi01 7 7 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0
50936 1973 TEX AL brownja01 25 3 0 25 25 0 0 0 0 0 0 0 0 0 0 0 0
50944 1973 KCA AL burgmto01 6 0 0 6 6 0 0 0 0 0 0 0 0 0 0 0 0
50948 1973 NYA AL busketo01 8 0 0 8 8 0 0 0 0 0 0 0 0 0 0 0 0
50956 1973 MIN AL campbbi02 28 2 0 28 28 0 0 0 0 0 0 0 0 0 0 0 0
50993 1973 TEX AL clydeda01 18 18 0 18 18 0 0 0 0 0 0 0 0 0 0 0 0
50996 1973 ML4 AL colboji01 43 36 0 43 43 0 0 0 0 0 0 0 0 0 0 0 0
50997 1973 DET AL colemjo05 40 40 0 40 40 0 0 0 0 0 0 0 0 0 0 0 0
51002 1973 MIN AL corbira01 51 7 0 51 51 0 0 0 0 0 0 0 0 0 0 0 0
51006 1973 NYA AL coxca01 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
51017 1973 BAL AL cuellmi01 38 38 0 38 38 0 0 0 0 0 0 0 0 0 0 0 0
51018 1973 BOS AL culpra01 10 9 0 10 10 0 0 0 0 0 0 0 0 0 0 0 0
51021 1973 BOS AL curtijo01 35 30 0 35 35 0 0 0 0 0 0 0 0 0 0 0 0
51033 1973 MIN AL deckejo01 29 24 0 29 29 0 0 0 0 0 0 0 0 0 0 0 0
51042 1973 OAK AL dobsoch01 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
51044 1973 NYA AL dobsopa01 22 21 0 22 22 0 0 0 0 0 0 0 0 0 0 0 0
51052 1973 CLE AL dunnist01 4 3 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0
51071 1973 CLE AL farmeed01 16 0 0 16 16 0 0 0 0 0 0 0 0 0 0 0 0
51072 1973 DET AL farmeed01 24 0 0 24 24 0 0 0 0 0 0 0 0 0 0 0 0
51076 1973 MIN AL fifeda01 10 7 0 10 10 0 0 0 0 0 0 0 0 0 0 0 0
51078 1973 CHA AL fisheed02 26 16 0 26 26 0 0 0 0 0 0 0 0 0 0 0 0
51081 1973 KCA AL fitzmal01 15 13 0 15 15 0 0 0 0 0 0 0 0 0 0 0 0
51096 1973 CHA AL frailke01 10 0 0 10 10 0 0 0 0 0 0 0 0 0 0 0 0
51103 1973 DET AL frymawo01 34 29 0 34 34 0 0 0 0 0 0 0 0 0 0 0 0
51114 1973 ML4 AL gardnro01 10 0 0 10 10 0 0 0 0 0 0 0 0 0 0 0 0
51115 1973 OAK AL gardnro01 3 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0
51116 1973 BAL AL garlawa01 4 1 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0
51117 1973 BOS AL garmami01 12 0 0 12 12 0 0 0 0 0 0 0 0 0 0 0 0
51124 1973 CHA AL geddeji01 6 1 0 6 6 0 0 0 0 0 0 0 0 0 0 0 0
51135 1973 MIN AL goltzda01 32 10 0 32 32 0 0 0 0 0 0 0 0 0 0 0 0
51142 1973 NYA AL grangwa01 7 0 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0
51162 1973 OAK AL hamilda01 16 11 0 16 16 0 0 0 0 0 0 0 0 0 0 0 0
51163 1973 CAL AL handri01 16 6 0 16 16 0 0 0 0 0 0 0 0 0 0 0 0
51164 1973 TEX AL handri01 8 7 0 8 8 0 0 0 0 0 0 0 0 0 0 0 0
51165 1973 MIN AL handsbi01 39 15 0 39 39 0 0 0 0 0 0 0 0 0 0 0 0
51177 1973 CAL AL hasslan01 7 4 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0
51189 1973 TEX AL henniri01 6 2 0 6 6 0 0 0 0 0 0 0 0 0 0 0 0
51196 1973 CLE AL hilgeto01 48 1 0 48 48 0 0 0 0 0 0 0 0 0 0 0 0
51197 1973 DET AL hillejo01 65 0 0 65 65 0 0 0 0 0 0 0 0 0 0 0 0
51205 1973 DET AL holdsfr01 5 2 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
51208 1973 BAL AL hooddo01 8 4 0 8 8 0 0 0 0 0 0 0 0 0 0 0 0
51223 1973 TEX AL hudsoch01 25 4 0 25 25 0 0 0 0 0 0 0 0 0 0 0 0
51231 1973 DET AL ignasga01 3 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0
51232 1973 BAL AL jacksgr01 45 0 0 45 45 0 0 0 0 0 0 0 0 0 0 0 0
51233 1973 CLE AL jacksmi01 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
51234 1973 KCA AL jacksmi01 9 0 0 9 9 0 0 0 0 0 0 0 0 0 0 0 0
51239 1973 BAL AL jeffeje01 18 15 0 18 18 0 0 0 0 0 0 0 0 0 0 0 0
51243 1973 CHA AL johnsba01 22 9 0 22 22 0 0 0 0 0 0 0 0 0 0 0 0
51250 1973 CLE AL johnsje01 39 1 0 39 39 0 0 0 0 0 0 0 0 0 0 0 0
51258 1973 CHA AL kaatji01 7 7 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0
51261 1973 CHA AL kealest01 7 0 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0
51263 1973 NYA AL kekicmi01 5 4 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
51272 1973 CLE AL kilkemi01 5 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
51279 1973 NYA AL klinest01 14 13 0 14 14 0 0 0 0 0 0 0 0 0 0 0 0
51282 1973 ML4 AL kobelke01 2 1 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0
51288 1973 TEX AL kremmji01 4 2 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0
51295 1973 DET AL lagrole01 21 3 0 21 21 0 0 0 0 0 0 0 0 0 0 0 0
51298 1973 CLE AL lambra01 32 1 0 32 32 0 0 0 0 0 0 0 0 0 0 0 0
51300 1973 CAL AL langedi01 17 4 0 17 17 0 0 0 0 0 0 0 0 0 0 0 0
51306 1973 DET AL lemanda01 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
51311 1973 OAK AL lindbpa01 36 3 0 36 36 0 0 0 0 0 0 0 0 0 0 0 0
51315 1973 KCA AL littema01 8 7 0 8 8 0 0 0 0 0 0 0 0 0 0 0 0
51320 1973 ML4 AL lockwsk01 37 15 0 37 37 0 0 0 0 0 0 0 0 0 0 0 0
51321 1973 DET AL lolicmi01 42 42 0 42 42 0 0 0 0 0 0 0 0 0 0 0 0
51330 1973 NYA AL lylesp01 51 0 0 51 51 0 0 0 0 0 0 0 0 0 0 0 0
51336 1973 NYA AL magnuji01 8 0 0 8 8 0 0 0 0 0 0 0 0 0 0 0 0
51371 1973 NYA AL mcdowsa01 16 15 0 16 16 0 0 0 0 0 0 0 0 0 0 0 0
51373 1973 CHA AL mcgloji01 5 1 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
51375 1973 BOS AL mcgloly01 6 3 0 6 6 0 0 0 0 0 0 0 0 0 0 0 0
51381 1973 BAL AL mcnalda01 38 38 0 38 38 0 0 0 0 0 0 0 0 0 0 0 0
51384 1973 NYA AL medicdo01 34 32 0 34 34 0 0 0 0 0 0 0 0 0 0 0 0
51389 1973 TEX AL merriji01 35 19 0 35 35 0 0 0 0 0 0 0 0 0 0 0 0
51394 1973 DET AL millebo04 22 0 0 22 22 0 0 0 0 0 0 0 0 0 0 0 0
51402 1973 CLE AL mingost01 5 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0
51403 1973 KCA AL mingost01 19 1 0 19 19 0 0 0 0 0 0 0 0 0 0 0 0
51411 1973 CAL AL monteau01 15 0 0 15 15 0 0 0 0 0 0 0 0 0 0 0 0
51423 1973 BOS AL moretro01 30 15 0 30 30 0 0 0 0 0 0 0 0 0 0 0 0
51441 1973 BOS AL newhado01 9 0 0 9 9 0 0 0 0 0 0 0 0 0 0 0 0
51442 1973 ML4 AL newmara01 11 0 0 11 11 0 0 0 0 0 0 0 0 0 0 0 0
51462 1973 CHA AL otoolde01 6 0 0 6 6 0 0 0 0 0 0 0 0 0 0 0 0
51464 1973 NYA AL paganda01 4 1 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0
51466 1973 BAL AL palmeji01 38 37 0 38 38 0 0 0 0 0 0 0 0 0 0 0 0
51472 1973 ML4 AL parsobi01 20 17 0 20 20 0 0 0 0 0 0 0 0 0 0 0 0
51476 1973 TEX AL paulmi01 36 10 0 36 36 0 0 0 0 0 0 0 0 0 0 0 0
51477 1973 BAL AL penaor01 11 2 0 11 11 0 0 0 0 0 0 0 0 0 0 0 0
51484 1973 CLE AL perryga01 41 41 0 41 41 0 0 0 0 0 0 0 0 0 0 0 0
51485 1973 DET AL perryji01 35 34 0 35 35 0 0 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
);