We'll have a full release shortly.  Here's a list of the players who debuted in
2012 with the assigned IDs.

There are also new IDs for a manager, a HOF member, and a handful of newly
identified 19th century players

---
Sean Lahman
http://seanlahman.com


2012 New Player IDs

lahmanID,playerID,birthYear,birthMonth,birthDay,nameFirst,nameLast,debut
19207,cespeyo01,1985,10,18,Yoenis,Cespedes,3/28/2012
19208,galvifr01,1989,11,14,Freddy,Galvis,4/5/2012
19209,pastoty01,1989,12,13,Tyler,Pastornicky,4/5/2012
19210,aokino01,1982,1,5,Norichika,Aoki,4/6/2012
19211,gonzama01,1989,3,14,Marwin,Gonzalez,4/6/2012
19212,komater01,1987,10,1,Erik,Komatsu,4/6/2012
19213,vogtst01,1984,11,1,Stephen,Vogt,4/6/2012
19214,cruzrh01,1986,11,1,Rhiner,Cruz,4/7/2012
19215,flahery01,1986,7,27,Ryan,Flaherty,4/7/2012
19216,haguema01,1985,8,20,Matt,Hague,4/7/2012
19217,kawasmu01,1981,6,3,Munenori,Kawasaki,4/7/2012
19218,luetglu01,1987,3,24,Lucas,Luetge,4/7/2012
19219,nieuwki01,1987,8,7,Kirk,Nieuwenhuis,4/7/2012
19220,oteroda01,1985,2,19,Dan,Otero,4/7/2012
19221,jonesna01,1986,1,28,Nate,Jones,4/8/2012
19222,phelpda01,1986,10,9,David,Phelps,4/8/2012
19223,rossro01,1989,6,24,Robbie,Ross,4/8/2012
19224,castile01,1989,4,8,Lendy,Castillo,4/9/2012
19225,darviyu01,1986,8,16,Yu,Darvish,4/9/2012
19226,ramirer02,1990,5,2,Erasmo,Ramirez,4/9/2012
19227,chenwe02,1985,7,21,Wei-Yin,Chen,4/10/2012
19228,smylydr01,1989,6,13,Drew,Smyly,4/12/2012
19229,carpeda02,1987,9,1,David,Carpenter,4/13/2012
19230,linch01,1988,9,21,Che-Hsuan,Lin,4/14/2012
19231,wielajo01,1990,1,21,Joe,Wieland,4/14/2012
19232,crawfev01,1986,9,2,Evan,Crawford,4/15/2012
19233,polloaj01,1987,12,5,A. J.,Pollock,4/18/2012
19234,iwakuhi01,1981,4,12,Hisashi,Iwakuma,4/20/2012
19235,figuepe01,1985,11,23,Pedro,Figueroa,4/21/2012
19236,hutchdr01,1990,8,22,Drew,Hutchison,4/21/2012
19237,peralwi01,1989,5,8,Wily,Peralta,4/22/2012
19238,weberth01,1984,9,28,Thad,Weber,4/22/2012
19239,hefneje01,1986,3,11,Jeremy,Hefner,4/23/2012
19240,valdejo02,1987,12,23,Jordany,Valdespin,4/23/2012
19241,lutzza01,1986,6,3,Zach,Lutz,4/24/2012
19242,hoovejj01,1987,8,13,J. J.,Hoover,4/25/2012
19243,harpebr03,1992,10,16,Bryce,Harper,4/28/2012
19244,moorety01,1987,1,30,Tyler,Moore,4/29/2012
19245,putkolu01,1986,5,10,Luke,Putkonen,4/29/2012
19246,corbipa01,1989,7,19,Patrick,Corbin,4/30/2012
19247,jennida01,1987,4,17,Dan,Jennings,4/30/2012
19248,mitchdj01,1987,5,13,D. J.,Mitchell,5/1/2012
19249,middlwi01,1988,9,9,Will,Middlebrooks,5/2/2012
19250,exposlu01,1987,1,20,Luis,Exposito,5/4/2012
19251,mikolmi01,1988,8,23,Miles,Mikolas,5/5/2012
19252,faluir01,1983,6,6,Irving,Falu,5/6/2012
19253,cardead01,1987,10,10,Adrian,Cardenas,5/7/2012
19254,doziebr01,1987,5,15,Brian,Dozier,5/7/2012
19255,pomerst01,1984,12,17,Stuart,Pomeranz,5/7/2012
19256,quintjo01,1989,1,24,Jose,Quintana,5/7/2012
19257,friedch01,1987,7,8,Christian,Friedrich,5/9/2012
19258,vanslsc01,1986,7,24,Scott,Van Slyke,5/9/2012
19259,mattike01,1985,9,20,Kevin,Mattison,5/12/2012
19260,averyxa01,1990,1,1,Xavier,Avery,5/13/2012
19261,costami01,1983,9,9,Mike,Costanzo,5/13/2012
19262,culbech01,1989,4,10,Charlie,Culberson,5/13/2012
19263,gomezma01,1984,9,7,Mauro,Gomez,5/13/2012
19264,leonsa01,1989,3,13,Sandy,Leon,5/14/2012
19265,diekmja01,1987,1,21,Jake,Diekman,5/15/2012
19266,herreel01,1985,2,1,Elian,Herrera,5/15/2012
19267,gomesya01,1987,7,19,Yan,Gomes,5/17/2012
19268,parkebl01,1985,6,19,Blake,Parker,5/17/2012
19269,carsoro01,1989,1,23,Robert,Carson,5/18/2012
19270,lallibl01,1983,5,12,Blake,Lalli,5/18/2012
19271,adamsma01,1988,8,31,Matt,Adams,5/20/2012
19272,hernago01,1987,9,7,Gorkys,Hernandez,5/21/2012
19273,solando01,1987,12,17,Donovan,Solano,5/21/2012
19274,calhoko01,1987,10,14,Kole,Calhoun,5/22/2012
19275,berryqu01,1984,11,21,Quintin,Berry,5/23/2012
19276,smithwi04,1989,7,10,Will,Smith,5/23/2012
19277,devrico01,1985,2,12,Cole,De Vries,5/24/2012
19278,diazju02,1988,12,12,Juan,Diaz,5/25/2012
19279,fickch01,1985,11,20,Chuckie,Fick,5/26/2012
19280,gonzami03,1984,5,27,Miguel,Gonzalez,5/29/2012
19281,mercejo03,1986,8,27,Jordy,Mercer,5/29/2012
19282,solanjh01,1985,8,12,Jhonatan,Solano,5/29/2012
19283,barnesc01,1987,9,5,Scott,Barnes,5/30/2012
19284,casteal01,1986,8,4,Alex,Castellanos,5/31/2012
19285,crosbca01,1988,9,17,Casey,Crosby,6/1/2012
19286,freemsa01,1987,6,24,Sam,Freeman,6/1/2012
19287,grandya01,1988,11,8,Yasmani,Grandal,6/2/2012
19288,pryorst01,1989,7,23,Stephen,Pryor,6/2/2012
19289,simmoan01,1989,9,4,Andrelton,Simmons,6/2/2012
19290,ramirel02,1987,10,10,Elvin,Ramirez,6/3/2012
19291,doolise01,1986,9,26,Sean,Doolittle,6/5/2012
19292,holadbr01,1987,11,19,Bryan,Holaday,6/6/2012
19293,danksjo02,1986,8,7,Jordan,Danks,6/7/2012
19294,negrokr01,1986,2,1,Kristopher,Negron,6/7/2012
19295,schepta01,1987,1,17,Tanner,Scheppers,6/7/2012
19296,tollesh01,1988,1,19,Shawn,Tolleson,6/7/2012
19297,ortegjo01,1988,10,12,Jose,Ortega,6/8/2012
19298,robincl01,1985,2,16,Clint,Robinson,6/8/2012
19299,perezhe01,1991,3,26,Hernan,Perez,6/9/2012
19300,rosenbj01,1985,9,17,B. J.,Rosenberg,6/9/2012
19301,boxbebr01,1988,5,27,Brad,Boxberger,6/10/2012
19302,kellyjo05,1988,6,9,Joe,Kelly,6/10/2012
19303,grimmju01,1988,8,16,Justin,Grimm,6/16/2012
19304,keuchda01,1988,1,1,Dallas,Keuchel,6/17/2012
19305,thornty01,1988,9,29,Tyler,Thornburg,6/19/2012
19306,archech01,1988,9,26,Chris,Archer,6/20/2012
19307,norride01,1989,2,14,Derek,Norris,6/21/2012
19308,griffaj01,1988,1,28,A. J.,Griffin,6/24/2012
19309,roberty01,1987,12,23,Tyler,Robertson,6/26/2012
19310,vinceni01,1986,7,12,Nick,Vincent,6/26/2012
19311,cabreed01,1987,10,20,Edwar,Cabrera,6/27/2012
19312,perezma02,1991,4,4,Martin,Perez,6/27/2012
19313,bauertr01,1991,1,17,Trevor,Bauer,6/28/2012
19314,septile01,1985,7,7,Leyson,Septimo,6/29/2012
19315,warread01,1987,8,25,Adam,Warren,6/29/2012
19316,brownba01,1984,12,28,Barret,Browning,6/30/2012
19317,downsda02,1984,12,26,Darin,Downs,7/3/2012
19318,omogrbr01,1984,4,26,Brian,Omogrosso,7/3/2012
19319,dysonsa01,1988,5,7,Sam,Dyson,7/5/2012
19320,mahonjo01,1987,2,1,Joe,Mahoney,7/7/2012
19321,biancje01,1986,10,5,Jeff,Bianchi,7/13/2012
19322,edginjo01,1986,12,17,Josh,Edgin,7/13/2012
19323,rutlejo01,1989,4,21,Josh,Rutledge,7/13/2012
19324,avilalu01,1989,7,19,Luis,Avilan,7/14/2012
19325,loupaa01,1987,12,19,Aaron,Loup,7/14/2012
19326,socolmi01,1986,7,24,Miguel,Socolovich,7/14/2012
19327,johnsst02,1987,8,31,Steve,Johnson,7/15/2012
19328,fifest01,1986,10,4,Stephen,Fife,7/17/2012
19329,gosean01,1990,8,10,Anthony,Gose,7/17/2012
19330,verdury01,1987,4,10,Ryan,Verdugo,7/17/2012
19331,hernape02,1989,4,12,Pedro,Hernandez,7/18/2012
19332,rosentr01,1990,5,29,Trevor,Rosenthal,7/18/2012
19333,allenco01,1988,11,20,Cody,Allen,7/20/2012
19334,wheelry01,1988,7,10,Ryan,Wheeler,7/20/2012
19335,belivje01,1987,1,17,Jeff,Beliveau,7/22/2012
19336,walljo02,1987,1,21,Josh,Wall,7/22/2012
19337,segurje01,1990,3,17,Jean,Segura,7/24/2012
19338,harvema01,1989,3,27,Matt,Harvey,7/26/2012
19339,hendeji01,1982,10,21,Jim,Henderson,7/26/2012
19340,martest01,1988,10,9,Starling,Marte,7/26/2012
19341,sierrmo01,1988,9,24,Moises,Sierra,7/31/2012
19342,cabreal03,1988,10,25,Alberto,Cabrera,8/1/2012
19343,oltmi01,1988,8,27,Mike,Olt,8/2/2012
19344,rodried04,1985,12,1,Eddy,Rodriguez,8/2/2012
19345,cappsca01,1990,8,7,Carter,Capps,8/3/2012
19346,storemi01,1986,3,16,Mickey,Storey,8/3/2012
19347,straida01,1988,12,1,Dan,Straily,8/3/2012
19348,burnsco01,1987,10,9,Cory,Burns,8/4/2012
19349,hechaad01,1989,4,15,Adeiny,Hechavarria,8/4/2012
19350,mcbrima02,1985,5,23,Matt,McBride,8/4/2012
19351,jacksbr01,1988,8,2,Brett,Jackson,8/5/2012
19352,vittejo01,1989,8,27,Josh,Vitters,8/5/2012
19353,barnebr02,1986,5,15,Brandon,Barnes,8/7/2012
19354,jenkich01,1987,12,22,Chad,Jenkins,8/7/2012
19355,raleybr01,1988,6,29,Brooks,Raley,8/7/2012
19356,machama01,1992,7,6,Manny,Machado,8/9/2012
19357,elmorja01,1987,6,15,Jake,Elmore,8/11/2012
19358,jacksry02,1988,5,10,Ryan,Jackson,8/11/2012
19359,harriwi10,1984,8,28,Will,Harris,8/13/2012
19360,brantro01,1989,7,14,Rob,Brantly,8/14/2012
19361,layneto01,1984,11,2,Tommy,Layne,8/14/2012
19362,geltzst01,1987,11,1,Steve,Geltz,8/16/2012
19363,redmoto01,1985,5,17,Todd,Redmond,8/18/2012
19364,mcpheky01,1987,11,11,Kyle,McPherson,8/20/2012
19365,wilsoju10,1987,8,18,Justin,Wilson,8/20/2012
19366,rusinch01,1986,10,22,Chris,Rusin,8/21/2012
19367,skaggty01,1991,7,13,Tyler,Skaggs,8/22/2012
19368,wernean01,1987,2,25,Andrew,Werner,8/22/2012
19369,aumonph01,1989,1,7,Phillippe,Aumont,8/23/2012
19370,mchugco01,1987,6,19,Collin,McHugh,8/23/2012
19371,peguefr01,1988,6,1,Francisco,Peguero,8/25/2012
19372,kellyca01,1989,10,4,Casey,Kelly,8/27/2012
19373,cloydty01,1987,5,16,Tyler,Cloyd,8/29/2012
19374,lerudst01,1984,10,13,Steven,Lerud,8/30/2012
19375,garciav01,1991,6,12,Avisail,Garcia,8/31/2012
19376,heathde01,1985,8,8,Deunte,Heath,9/1/2012
19377,holtbr01,1988,6,11,Brock,Holt,9/1/2012
19378,loughda01,1986,1,20,David,Lough,9/1/2012
19379,perezeu01,1990,5,30,Eury,Perez,9/1/2012
19380,maronni01,1989,9,5,Nick,Maronde,9/2/2012
19381,nealth01,1987,8,17,Thomas,Neal,9/2/2012
19382,profaju01,1993,2,20,Jurickson,Profar,9/2/2012
19383,rodrihe04,1990,2,9,Henry,Rodriguez,9/2/2012
19384,machije01,1982,2,1,Jean,Machi,9/3/2012
19385,phippde01,1985,7,22,Denis,Phipps,9/3/2012
19386,chapmja02,1987,5,22,Jaye,Chapman,9/4/2012
19387,eatonad02,1988,12,6,Adam,Eaton,9/4/2012
19388,familje01,1989,10,10,Jeurys,Familia,9/4/2012
19389,garcich02,1985,8,24,Christian,Garcia,9/4/2012
19390,jimenlu01,1982,5,7,Luis,Jimenez,9/4/2012
19391,ramosaj01,1986,9,20,A. J.,Ramos,9/4/2012
19392,gregodi01,1990,2,18,Didi,Gregorius,9/5/2012
19393,koehlto01,1986,6,29,Tom,Koehler,9/5/2012
19394,millesh01,1990,10,10,Shelby,Miller,9/5/2012
19395,villape01,1987,12,9,Pedro,Villarreal,9/5/2012
19396,grahaty01,1984,1,25,Tyler,Graham,9/7/2012
19397,triunca01,1990,2,27,Carlos,Triunfel,9/7/2012
19398,cingrto01,1989,7,5,Tony,Cingrani,9/9/2012
19399,rodrist02,1991,4,16,Paco,Rodriguez,9/9/2012
19400,scahiro01,1987,2,15,Rob,Scahill,9/11/2012
19401,morribr01,1987,3,28,Bryan,Morris,9/14/2012
19402,rufda01,1986,7,28,Darin,Ruf,9/14/2012
19403,herrmch01,1987,11,24,Chris,Herrmann,9/16/2012
19404,solisal01,1987,9,29,Ali,Solis,9/16/2012
19405,fontwi01,1990,5,24,Wilmer,Font,9/18/2012
19406,mesame01,1987,1,31,Melky,Mesa,9/22/2012
19407,bundydy01,1992,11,15,Dylan,Bundy,9/23/2012
19408,odorija01,1990,3,27,Jake,Odorizzi,9/23/2012
19409,hoeslj01,1990,3,5,L. J.,Hoes,9/25/2012
19410,tayloan01,1986,8,18,Andrew,Taylor,9/27/2012
19411,ortegra01,1991,5,15,Rafael,Ortega,9/30/2012
19412,brummty01,1984,8,15,Tyson,Brummett,10/3/2012
19413,defrato99,1963,4,24,Tony,DeFrancesco,
19414,mckenfr01,,,,Frank,McKenna,
19415,mckenpa01,,,,Patrick,McKenna,
19416,sulliwi01,,,,William,Sullivan,
19417,gilgahu01,1852,,,Hugh,Gilgan,
19418,crossjo01,1858,1,6,Joe,Cross,
19419,snydech03,1890,8,20,Chubby,Snyder,
19420,ruperja99,1867,8,5,Jacob,Ruppert,
<end of list>

An updated version of the database is now available, in both the CSV and Access
versions. Links are below.

CSV: http://seanlahman.com/files/database/lahman2012_beta.zip
Access: http://seanlahman.com/files/database/lahman2012_beta-MS.zip

Would love to get feedback on any issues that may exist. We'll need to make an
update after the new HOF class is announced next week. Hopefully we can
incorporate any fixes at the same time.

I'm also working on a set of supplementary tables, which in concept would
contain datasets that many analysts would like without cluttering the main
database.  My first iteration will include split stats -- home/road and
left/right for batters and pitchers. Dan Hirsch did the work to create these
tables from the PBP database, and they cover 1945-2012.

I'm open for suggestions on other tables that might be added to the
supplementary collection.

Regards,
Sean Lahman

For the batter's hand:  you should make it as bathand and pithand,
especially notable for someone like JT Snow who used to switch hit, and
then didn't.  We shouldn't infer that the batting hand of switch hitters
always switches.  (Indeed, he may not even be listed as a switch hitter.)

Presuming you want to keep the splits lines to two per split:
-runners: bases empty v runners on

-starting: in starting lineup v sub (applies to both pitchers and
nonpitchers)

Tom

I thought you could be interested

Hans Van Slooten was kind enough to pull together an SQL version of the updated
database, for those who roll that way.  Big thanks to Hans.  Here's a link.

SQL: http://seanlahman.com/files/database/lahman2012_beta-SQL.zip



--- In baseball-databank@yahoogroups.com, "anson2995" <seanlahman@...> wrote:
>
> An updated version of the database is now available, in both the CSV and
Access versions. Links are below.
>
> CSV: http://seanlahman.com/files/database/lahman2012_beta.zip
> Access: http://seanlahman.com/files/database/lahman2012_beta-MS.zip
>
> Would love to get feedback on any issues that may exist. We'll need to make an
update after the new HOF class is announced next week. Hopefully we can
incorporate any fixes at the same time.
>
> I'm also working on a set of supplementary tables, which in concept would
contain datasets that many analysts would like without cluttering the main
database.  My first iteration will include split stats -- home/road and
left/right for batters and pitchers. Dan Hirsch did the work to create these
tables from the PBP database, and they cover 1945-2012.
>
> I'm open for suggestions on other tables that might be added to the
supplementary collection.
>
> Regards,
> Sean Lahman
>

Any chance of getting pitchers' doubles and triples against this year?

-j


--- In baseball-databank@yahoogroups.com, "anson2995"  wrote:
>
> An updated version of the database is now available, in both the CSV and
Access versions. Links are below.
>
> CSV: http://seanlahman.com/files/database/lahman2012_beta.zip
> Access: http://seanlahman.com/files/database/lahman2012_beta-MS.zip
>
> Would love to get feedback on any issues that may exist. We'll need to make an
update after the new HOF class is announced next week. Hopefully we can
incorporate any fixes at the same time.
>
> I'm also working on a set of supplementary tables, which in concept would
contain datasets that many analysts would like without cluttering the main
database.  My first iteration will include split stats -- home/road and
left/right for batters and pitchers. Dan Hirsch did the work to create these
tables from the PBP database, and they cover 1945-2012.
>
> I'm open for suggestions on other tables that might be added to the
supplementary collection.
>
> Regards,
> Sean Lahman
>

A few minor corrections to report:

In the Managers table:
A few new managers have incorrect managerID values:
defrato99  -> defrato99m
venturro01 -> venturo01m

In the HallOfFame table:
A few players have incorrect hofID values:
harrisle01 -> harrile01h
martiti01h -> martiti02h

Also, for all 2011 candidates who were not elected, the inducted column is blank
instead of N.

There are a few problems with the new ID given to Kevin Youkilis last year:

In the AwardsPlayers table (2 entries) and the SchoolsPlayers table:
youkike01 -> youklke01


Overall, this looks like a really release.  Thanks to everyone for all the hard
work that's put into this.  Looking forward to the new data as well.

-Andy


--- In baseball-databank@yahoogroups.com, "anson2995"  wrote:
>
> An updated version of the database is now available, in both the CSV and
Access versions. Links are below.

Group,

Starting in 2013, Chadwick Baseball Bureau will be helping Sean out providing
some logistical support for maintaining the databank.

I have set up a git repository to do proper versioning of the data.  You can
find it at:

https://github.com/chadwickbureau/baseballdatabank

Specifically, all the revisions from yesterday's release are being tracked for
the moment in the '2012update' branch:

https://github.com/chadwickbureau/baseballdatabank/tree/2012update

There's an issue tracker associated with it:

https://github.com/chadwickbureau/baseballdatabank/issues

This is a good place to report bugs you find.  Also, being a proper version
control system, it is straightforward to fork the repository, fix the bugs
yourself, and ship a pull request back upstream.  :)

Ted
--
Dr Theodore L Turocy
Chadwick Baseball Bureau

> Group,
>
> Starting in 2013, Chadwick Baseball Bureau will be helping Sean out
> providing some logistical support for maintaining the databank.
>

Having Lahman continue to be the lead, and now having Ted providing
support on some specific items is wonderful news.

Hopefully, this will spur others to provide dedicated support.  I think
what was lacking in the past is some solid base and some fresh blood.
Sean+Ted can provide that solid base, so any prospective providers should
feel confident that their own efforts can be leveraged.

Tom

Great feedback.  Thanks, Andy.

Chris asked about the stray hexadecimal codes in the CSV version of the master
table.  Those are the SABR-IDs for those new players.  At one point I pondered
adding those for all players but I forgot about it.  Will remove them for now
until we get back to that task.

Also, Jeff asked about adding doubles and triples by pitchers. It's something we
ought to do for all seasons as far back as we are able. It raises the larger
issue of fields that could be added to the main statistical tables, and I
suspect there is also room for this type of improvement in the post-season
tables as well.  This is something I'll commit to tackling, but in as much as it
will entail some changes to the structure of the tables, I'd rather wait until
after we get this update squared away and do it as a separate project.

--Sean

--- In baseball-databank@yahoogroups.com, "abrennan_jaded"  wrote:
>
> A few minor corrections to report:
>
> In the Managers table:
> A few new managers have incorrect managerID values:
> defrato99  -> defrato99m
> venturro01 -> venturo01m
>
> In the HallOfFame table:
> A few players have incorrect hofID values:
> harrisle01 -> harrile01h
> martiti01h -> martiti02h
>
> Also, for all 2011 candidates who were not elected, the inducted column is
blank instead of N.
>
> There are a few problems with the new ID given to Kevin Youkilis last year:
>
> In the AwardsPlayers table (2 entries) and the SchoolsPlayers table:
> youkike01 -> youklke01
>
>
> Overall, this looks like a really release.  Thanks to everyone for all the
hard work that's put into this.  Looking forward to the new data as well.
>
> -Andy
>

--- In baseball-databank@yahoogroups.com, "Tangotiger"  wrote:

> -starting: in starting lineup v sub (applies to both pitchers and
> nonpitchers)

Make it start/relief for pitchers, and PH and either PR or DH for batters.

> --- In baseball-databank@yahoogroups.com, "Tangotiger"  wrote:
>
>> -starting: in starting lineup v sub (applies to both pitchers and
>> nonpitchers)
>
> Make it start/relief for pitchers, and PH and either PR or DH for batters.
>
>

I would include PH, PR, and defensive subs into one.

DH is an in-betweener.

If you want to count it as "starting nine on the field" v "others", that
could be fine.  If you want to count it as "starting nine on batting
lineup" v "others" that would make more sense, especially since we are
talking about batting stats.  So, DH would be part of the starters.

Regardless: defensive sub plate appearances would be part of "others".

Ted's CWEVENT makes the calculation pretty easy (RESP_BAT_START_FL,
RESP_PIT_START_FL), as well as his fantastic CWSUB program.  No point in
complicating things beyond the simple solution: start or not.

Tom


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

On Jan 4, 2013, at 2:07 PM, anson2995 <seanlahman@...> wrote:

> Also, Jeff asked about adding doubles and triples by pitchers. It's something
we ought to do for all seasons as far back as we are able. It raises the larger
issue of fields that could be added to the main statistical tables, and I
suspect there is also room for this type of improvement in the post-season
tables as well. This is something I'll commit to tackling, but in as much as it
will entail some changes to the structure of the tables, I'd rather wait until
after we get this update squared away and do it as a separate project.
>

I do think there are in general a number of design improvements that could be
done -- although I am mindful, in mentioning this, that there are plenty of
downstream applications which depend on the existing format.  We're probably
stuck providing data in the current format for the indefinite future.

On items such as doubles and triples against:  These aren't official statistics.
That doesn't make them unimportant or not useful, or that we shouldn't provide
them.  But there's a distinction to be drawn between official stats and those
that are derived from Retrosheet.  For recent seasons -- most of the last two
decades I expect -- there's not doing to be much, if any, difference.  Before
that, the number of variances between the two start to increase quickly.

A clean way to do this -- which can also accommodate the idea of providing
splits -- is to report separately tables of data derived from Retrosheet.  This
can then leave it to the downstream user whether to adopt categories like
doubles and triples allowed, or other such categories one might dream up.  The
table can then incorporate a suitable set of scoping columns as metadata, so
that there can be "all games", "vs RHP", "vs LHP", "home", "away", etc. as a
scope column.

Ted

Clem,
I'll make this fix.  Your suggestion about adding other awards reminds me that
my late pal, Greg Spira, submitted an expanded list of awards to be added,
including some that are defunct.  It included the TSN awards and many others. I
believe Greg oversaw this section in both the ESPN encyclopedia and later
editions of Total Baseball.

Regards,
Sean Lahman

--- In baseball-databank@yahoogroups.com, "Clem Comly"  wrote:
>
> In  AwardsManagers it appears the 2012 winners have yearID of 2011.
> Also, should the value “Mgr of the year” in AwardID column of
AwardsManagers
> be “BBWAA Mgr of the year”?
> Any thought of adding TSN Mgr of the year winners  which go back to 1936?
BBWAA Mgr of the year only goes back to 1983.
> Clem Comly
>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Manager of the Year.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN Manager of The Year thru 2007

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Mana\
ger%20of%20the%20Year.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Guide MVP.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN Guide MVPs 1929 thru 1945

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Guid\
e%20MVP.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Rookies of the Year 1946_2007.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN Rookies of the Year 46 thru 2007

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Rook\
ies%20of%20the%20Year%201946_2007.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Fireman of the Year.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN Fireman of the Year 1960 thru 2007

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Fire\
man%20of%20the%20Year.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Major League Player of the Year.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN Major League POY 1936 thru 2007

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Majo\
r%20League%20Player%20of%20the%20Year.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Awards Folder/TSN Player of the Year.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : TSN POY 1944 thru 1991

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/Awards%20Folder/TSN%20Play\
er%20of%20the%20Year.xls

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

kjokbaseball <kjokbaseball@...>

I think Ted might have mentioned it, but I'd go with adding identifier
fields, and have one table called SPLITS, with these two key fields (plus
all the other standard key fields, player_id, year_id, team_id, and the
standard fields, like pa, etc):

SPLIT_ID,SPLIT_CD

So:

SPLIT_ID,SPLIT_CD
all,all

runners,bases empty
runners,runner(s) on

location,home
location,away

entrance,start
entrance,substitution

opphand,rhp
opphand,lhp

bathand,lhh
bathand,rhh

batopphand,lhh v lhp
batopphand,lhh v rhp
batopphand,rhh v lhp
batopphand,lhh v rhp

park,BOS
park,BAL
park,...

inning,1
inning,2
inning,...
inning,10+

score,-5 or worse
score,-4
score...
score,0
score...
score,5 or more

And you just keep extending with whatever splits you want to create, like
fielding position, batting lineup slot, etc.

Naturally, that's going to be one biga$$ table.  If that's too much, give
each split its own table, and then the users can merge them easily enough
like so:

select * from SPLIT_RUNNERS
union all
select * from SPLIT_LOCATION
union all
...

Tom

I guess at least three tables: SPLIT_BATTING, SPLIT_PITCHING, SPLIT_FIELDING.

Tom