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

Issues found in latest DB version.

Expand Messages
  • Alberto Perdomo
    Hi, all: Uploaded the latest release of Lahman database (591) and found a lot of errors. [00] Stint column in Fielding table must have a different value for
    Message 1 of 1 , Mar 10, 2012
    • 0 Attachment
      Hi, all:

      Uploaded the latest release of Lahman database (591) and found a lot of errors.  

      [00] Stint column in Fielding table must have a different value for each team any player played with in the same season.
      [06]  There are 2 rows  (season 2011) that are  in Appearances but not in Master. .
      [09] There are 78 rows (season 2011)  that are  in the Batting table but not in the Appearances.
      [10] There are 10 rows  (season 2011) that are  in Appearances but not in Batting.
      [12] There are 45 rows  (season 2011) that are  in Pitching but not in Appearances.
      [16] There are 4  rows (season 2011) that are in FieldingPost but not in Master.
      [17] There are 40 rows (seasons 2000+) that are in Fielding but not in Master.
      [21] There are 2  rows (season 2011) that are in HallOfFame but not in Master.
      [24] There are 3 rows (seasons 2000+) that are in AllStarFull but not in Master.
      [25] There are 2 rows (seasons 2000+) that are in AwardsPlayers but not in Master
      [27] There are 3 rows (seasons 2000+) that are in AwardsSharedPlayers but not in Master
      [47] There are 8 rows (seasons 2000+) that are in listed as Pitchers in Fielding but not in Pitching table.
      [48] There are 19 rows (seasons 2000+) that are in listed as non-Pitchers in Fielding but not in Batting table.
      [49] There are 93 rows (season 2011) that are in Fielding but not in Appearances table.
      [68] There are 9 rows (season 2005+) that are in the Salaries table but not in the Master table.
      [66] There is 1 row that are in the SchoolsPlayers but not in the Master table.

      Tables without rows for 2011 season: FieldingOF, ManagersHalf, Salaries and TeamsHalf 

      Regards,

      Alberto.
    Your message has been successfully submitted and would be delivered to recipients shortly.