Loading ...
Sorry, an error occurred while loading the content.

Re: Beta version of database available

Expand Messages
  • timmermant
    team file is still missing HBP and SF data pre-2000. Thanks for your hard work, Tom
    Message 1 of 17 , Jan 1, 2012
    • 0 Attachment
      team file is still missing HBP and SF data pre-2000.

      Thanks for your hard work,
      Tom

      --- In baseball-databank@yahoogroups.com, "anson2995" <slahman@...> wrote:
      >
      > Just posted a beta version of the updated baseball database. It's just the CSV version. Please let me know if you find any issues with it.
      >
      > http://baseball1.com/files/database/lahman59-beta.zip
      >
    • Jeff
      Any chance of including singles/doubles/triples against for pitchers in this release?
      Message 2 of 17 , Jan 4, 2012
      • 0 Attachment
        Any chance of including singles/doubles/triples against for pitchers in this release?


        --- In baseball-databank@yahoogroups.com, "anson2995" <slahman@...> wrote:
        >
        > Just posted a beta version of the updated baseball database. It's just the CSV version. Please let me know if you find any issues with it.
        >
        > http://baseball1.com/files/database/lahman59-beta.zip
        >
      • crimson14g
        I posted an update of a lot of profile information on the master file for this version of the Lahman database. It includes changes to birth dates, death dates,
        Message 3 of 17 , Jan 9, 2012
        • 0 Attachment
          I posted an update of a lot of profile information on the master file for this version of the Lahman database. It includes changes to birth dates, death dates, full given names for players missing them, and any other changes provided by the SABR biographical research project from the past few years--back to 2007 when the data seems to split from the Lahman info.

          Feel free to use it in the updated database. It's availabe in the files section of this group under the name: updatedplayerinfoMaster.csv

          Please note that I've also changed some "use names" when I thought it appropriate (dropping middle initials because I've never seen them used except to distinguish them among statheads--for example, Mark L. Johnson is just now Mark Johnson.) Certain players who were known to use Jr. have that added to their last name (i.e. Ken Griffey Jr., Sandy Alomar Jr., Tim Raines Jr., etc.) Additionally, I changed one or two use names to something used by baseball-reference or in the SABR biographical research project. Feel free to change them back or whatever.
        • Alberto Perdomo
          Hi, all: For all rows for the 2011 season, Stint column is always 1 in Fielding table. If Stint=1, then it s not possible to identify the correct team order
          Message 4 of 17 , Jan 22, 2012
          • 0 Attachment
            Hi, all:

            For all rows for the 2011 season, Stint column is always 1 in Fielding table.   If Stint=1, then it's not possible to identify the correct team order for those players that were traded during the past season.   Think I fixed those records.  If you need my fixed table, please let me know.

            Some example rows: 

            adamsmi03,2011,1,SDN,NL,P,48,0,144,1,3,0,0,,,,,
            adamsmi03,2011,1,TEX,AL,P,27,0,77,3,2,0,0,,,,,

            allenbr01,2011,1,ARI,NL,1B,10,9,255,77,5,0,9,,,,,
            allenbr01,2011,1,OAK,AL,1B,41,40,1066,334,19,4,24,,,,,

            billibr02,2011,1,COL,NL,P,1,0,6,1,1,0,1,,,,,
            billibr02,2011,1,OAK,AL,P,3,0,15,0,0,0,0,,,,,


            branyru01,2011,1,ARI,NL,1B,14,12,324,103,6,0,6,,,,,
            branyru01,2011,1,LAA,AL,1B,11,6,153,47,4,1,11,,,,,

            buentja01,2011,1,FLO,NL,P,1,1,9,0,0,0,0,,,,,
            buentja01,2011,1,TBA,AL,P,1,0,6,1,1,0,0,,,,

            cabreor01,2011,1,SFN,NL,2B,2,1,27,1,3,0,1,,,,,
            cabreor01,2011,1,CLE,AL,3B,4,4,84,2,2,0,0,,,,,
            cabreor01,2011,1,SFN,NL,3B,1,0,3,0,0,0,0,,,,,
            cabreor01,2011,1,CLE,AL,SS,3,1,45,3,4,0,0,,,,,
            cabreor01,2011,1,SFN,NL,SS,36,33,883,52,91,5,19,,,,,


            ellisma01,2011,1,OAK,AL,1B,2,2,44,15,3,0,2,,,,,
            ellisma01,2011,1,OAK,AL,2B,59,56,1504,127,189,2,50,,,,,
            ellisma01,2011,1,COL,NL,2B,64,63,1660,123,194,1,42,,,,,

            fukudko01,2011,1,CHN,NL,CF,1,1,18,1,1,0,0,,,,,
            fukudko01,2011,1,CLE,AL,CF,12,11,295,28,0,1,0,,,,,
            fukudko01,2011,1,CHN,NL,RF,82,71,1890,150,4,2,0,,,,,
            fukudko01,2011,1,CLE,AL,RF,49,46,1293,115,2,1,2,,,,,

            harrelu01,2011,1,CHA,AL,P,3,0,15,1,0,0,0,,,,,
            harrelu01,2011,1,HOU,NL,P,6,2,39,1,4,1,0,,,,,



            On Mon, Jan 9, 2012 at 7:56 PM, crimson14g <crimson14g@...> wrote:
             

            I posted an update of a lot of profile information on the master file for this version of the Lahman database. It includes changes to birth dates, death dates, full given names for players missing them, and any other changes provided by the SABR biographical research project from the past few years--back to 2007 when the data seems to split from the Lahman info.

            Feel free to use it in the updated database. It's availabe in the files section of this group under the name: updatedplayerinfoMaster.csv

            Please note that I've also changed some "use names" when I thought it appropriate (dropping middle initials because I've never seen them used except to distinguish them among statheads--for example, Mark L. Johnson is just now Mark Johnson.) Certain players who were known to use Jr. have that added to their last name (i.e. Ken Griffey Jr., Sandy Alomar Jr., Tim Raines Jr., etc.) Additionally, I changed one or two use names to something used by baseball-reference or in the SABR biographical research project. Feel free to change them back or whatever.


          • Alberto Perdomo
            These records in the pitchingpost table have an inf value schleda01,2011,ALCS,DET,AL,0,0,1,0,0,0,0,0,1,1,,0,0,inf,,,,,,,,,,,
            Message 5 of 17 , Jan 22, 2012
            • 0 Attachment
              These records in the pitchingpost table have an "inf" value

              schleda01,2011,ALCS,DET,AL,0,0,1,0,0,0,0,0,1,1,,0,0,inf,,,,,,,,,,,
              ueharko01,2011,ALDS2,TEX,AL,0,0,1,0,0,0,0,0,2,3,,1,0,inf,,,,,,,,,,,

              In the same table, row 4329 is wrong because belongs to Teixeira and this is a pitching table.

              teixema01,2011,ALDS1,NYA,AL,3,2,5,18,0,0,0,3,2,5,,0.167,0.286,2,,,,,,,,,,,


              On Sun, Jan 22, 2012 at 10:41 PM, Alberto Perdomo <aperdomo@...> wrote:
              Hi, all:

              The last of Master table is for Pat Gillick (ex-GM) who wasnt a baseball player.   Why this record is there?

              19205,gillipa9901,,gillipa9901h,1937,8,22,USA,CA,Chico,,,,,,,Pat,Gillick,,Lawrence Patrick David,,,,,,,,,,,,,gillipa9901

              Regards,

              Alberto.


              On Sun, Jan 22, 2012 at 10:09 PM, Alberto Perdomo <aperdomo@...> wrote:
              Hi, all:

              For all rows for the 2011 season, Stint column is always 1 in Fielding table.   If Stint=1, then it's not possible to identify the correct team order for those players that were traded during the past season.   Think I fixed those records.  If you need my fixed table, please let me know.

              Some example rows: 

              adamsmi03,2011,1,SDN,NL,P,48,0,144,1,3,0,0,,,,,
              adamsmi03,2011,1,TEX,AL,P,27,0,77,3,2,0,0,,,,,

              allenbr01,2011,1,ARI,NL,1B,10,9,255,77,5,0,9,,,,,
              allenbr01,2011,1,OAK,AL,1B,41,40,1066,334,19,4,24,,,,,

              billibr02,2011,1,COL,NL,P,1,0,6,1,1,0,1,,,,,
              billibr02,2011,1,OAK,AL,P,3,0,15,0,0,0,0,,,,,


              branyru01,2011,1,ARI,NL,1B,14,12,324,103,6,0,6,,,,,
              branyru01,2011,1,LAA,AL,1B,11,6,153,47,4,1,11,,,,,

              buentja01,2011,1,FLO,NL,P,1,1,9,0,0,0,0,,,,,
              buentja01,2011,1,TBA,AL,P,1,0,6,1,1,0,0,,,,

              cabreor01,2011,1,SFN,NL,2B,2,1,27,1,3,0,1,,,,,
              cabreor01,2011,1,CLE,AL,3B,4,4,84,2,2,0,0,,,,,
              cabreor01,2011,1,SFN,NL,3B,1,0,3,0,0,0,0,,,,,
              cabreor01,2011,1,CLE,AL,SS,3,1,45,3,4,0,0,,,,,
              cabreor01,2011,1,SFN,NL,SS,36,33,883,52,91,5,19,,,,,


              ellisma01,2011,1,OAK,AL,1B,2,2,44,15,3,0,2,,,,,
              ellisma01,2011,1,OAK,AL,2B,59,56,1504,127,189,2,50,,,,,
              ellisma01,2011,1,COL,NL,2B,64,63,1660,123,194,1,42,,,,,

              fukudko01,2011,1,CHN,NL,CF,1,1,18,1,1,0,0,,,,,
              fukudko01,2011,1,CLE,AL,CF,12,11,295,28,0,1,0,,,,,
              fukudko01,2011,1,CHN,NL,RF,82,71,1890,150,4,2,0,,,,,
              fukudko01,2011,1,CLE,AL,RF,49,46,1293,115,2,1,2,,,,,

              harrelu01,2011,1,CHA,AL,P,3,0,15,1,0,0,0,,,,,
              harrelu01,2011,1,HOU,NL,P,6,2,39,1,4,1,0,,,,,



              On Mon, Jan 9, 2012 at 7:56 PM, crimson14g <crimson14g@...> wrote:
               

              I posted an update of a lot of profile information on the master file for this version of the Lahman database. It includes changes to birth dates, death dates, full given names for players missing them, and any other changes provided by the SABR biographical research project from the past few years--back to 2007 when the data seems to split from the Lahman info.

              Feel free to use it in the updated database. It's availabe in the files section of this group under the name: updatedplayerinfoMaster.csv

              Please note that I've also changed some "use names" when I thought it appropriate (dropping middle initials because I've never seen them used except to distinguish them among statheads--for example, Mark L. Johnson is just now Mark Johnson.) Certain players who were known to use Jr. have that added to their last name (i.e. Ken Griffey Jr., Sandy Alomar Jr., Tim Raines Jr., etc.) Additionally, I changed one or two use names to something used by baseball-reference or in the SABR biographical research project. Feel free to change them back or whatever.




            • Clay Dreslough
              Alberto - I would love a copy of your fixed Fielding.csv table. Thanks! Clay ... --
              Message 6 of 17 , Jan 23, 2012
              • 0 Attachment
                Alberto - I would love a copy of your fixed Fielding.csv table.

                Thanks!

                Clay

                On 1/22/2012 10:09 PM, Alberto Perdomo wrote:
                > Hi, all:
                >
                > For all rows for the 2011 season, Stint column is always 1 in Fielding
                > table. If Stint=1, then it's not possible to identify the correct
                > team order for those players that were traded during the past season.
                > Think I fixed those records. If you need my fixed table, please let
                > me know.
                >
                > Some example rows:
                >
                > adamsmi03,2011,1,SDN,NL,P,48,0,144,1,3,0,0,,,,,
                > adamsmi03,2011,1,TEX,AL,P,27,0,77,3,2,0,0,,,,,
                >
                > allenbr01,2011,1,ARI,NL,1B,10,9,255,77,5,0,9,,,,,
                > allenbr01,2011,1,OAK,AL,1B,41,40,1066,334,19,4,24,,,,,
                >
                > billibr02,2011,1,COL,NL,P,1,0,6,1,1,0,1,,,,,
                > billibr02,2011,1,OAK,AL,P,3,0,15,0,0,0,0,,,,,
                >
                >
                > branyru01,2011,1,ARI,NL,1B,14,12,324,103,6,0,6,,,,,
                > branyru01,2011,1,LAA,AL,1B,11,6,153,47,4,1,11,,,,,
                >
                > buentja01,2011,1,FLO,NL,P,1,1,9,0,0,0,0,,,,,
                > buentja01,2011,1,TBA,AL,P,1,0,6,1,1,0,0,,,,
                >
                > cabreor01,2011,1,SFN,NL,2B,2,1,27,1,3,0,1,,,,,
                > cabreor01,2011,1,CLE,AL,3B,4,4,84,2,2,0,0,,,,,
                > cabreor01,2011,1,SFN,NL,3B,1,0,3,0,0,0,0,,,,,
                > cabreor01,2011,1,CLE,AL,SS,3,1,45,3,4,0,0,,,,,
                > cabreor01,2011,1,SFN,NL,SS,36,33,883,52,91,5,19,,,,,
                >
                >
                > ellisma01,2011,1,OAK,AL,1B,2,2,44,15,3,0,2,,,,,
                > ellisma01,2011,1,OAK,AL,2B,59,56,1504,127,189,2,50,,,,,
                > ellisma01,2011,1,COL,NL,2B,64,63,1660,123,194,1,42,,,,,
                >
                > fukudko01,2011,1,CHN,NL,CF,1,1,18,1,1,0,0,,,,,
                > fukudko01,2011,1,CLE,AL,CF,12,11,295,28,0,1,0,,,,,
                > fukudko01,2011,1,CHN,NL,RF,82,71,1890,150,4,2,0,,,,,
                > fukudko01,2011,1,CLE,AL,RF,49,46,1293,115,2,1,2,,,,,
                >
                > harrelu01,2011,1,CHA,AL,P,3,0,15,1,0,0,0,,,,,
                > harrelu01,2011,1,HOU,NL,P,6,2,39,1,4,1,0,,,,,
                >
                >
                >
                > On Mon, Jan 9, 2012 at 7:56 PM, crimson14g <crimson14g@...
                > <mailto:crimson14g@...>> wrote:
                >
                > I posted an update of a lot of profile information on the master
                > file for this version of the Lahman database. It includes changes
                > to birth dates, death dates, full given names for players missing
                > them, and any other changes provided by the SABR biographical
                > research project from the past few years--back to 2007 when the
                > data seems to split from the Lahman info.
                >
                > Feel free to use it in the updated database. It's availabe in the
                > files section of this group under the name:
                > updatedplayerinfoMaster.csv
                >
                > Please note that I've also changed some "use names" when I thought
                > it appropriate (dropping middle initials because I've never seen
                > them used except to distinguish them among statheads--for example,
                > Mark L. Johnson is just now Mark Johnson.) Certain players who
                > were known to use Jr. have that added to their last name (i.e. Ken
                > Griffey Jr., Sandy Alomar Jr., Tim Raines Jr., etc.) Additionally,
                > I changed one or two use names to something used by
                > baseball-reference or in the SABR biographical research project.
                > Feel free to change them back or whatever.
                >
                >
                >

                --
              • Clay Dreslough
                Here s the line to add to BattingPost.csv for Teixeira: 2011,ALDS1,teixema01,NYA,AL,5,18,2,3,2,0,1,1,0,0,2,5,,1,,, Then just delete his row from
                Message 7 of 17 , Jan 23, 2012
                • 0 Attachment
                  Here's the line to add to BattingPost.csv for Teixeira:

                  2011,ALDS1,teixema01,NYA,AL,5,18,2,3,2,0,1,1,0,0,2,5,,1,,,

                  Then just delete his row from PitchingPost.csv.

                  Clay

                  On 1/22/2012 11:22 PM, Alberto Perdomo wrote:
                  >
                  > In the same table, row 4329 is wrong because belongs to Teixeira and
                  > this is a pitching table.
                  >
                  > teixema01,2011,ALDS1,NYA,AL,3,2,5,18,0,0,0,3,2,5,,0.167,0.286,2,,,,,,,,,,,
                  >
                • chrislambrou
                  I didn t see a response on this... Will DH no longer be included in the fielding table? Thanks. -Chris
                  Message 8 of 17 , Apr 17 6:34 AM
                  • 0 Attachment
                    I didn't see a response on this... Will DH no longer be included in the fielding table? Thanks.

                    -Chris

                    --- In baseball-databank@yahoogroups.com, John Rickert <rickert@...> wrote:
                    >
                    > In the Fielding.csv file previous seasons have totals for games played at DH, but 2011 does not.
                    >
                  Your message has been successfully submitted and would be delivered to recipients shortly.