|
||||
| ||||
|
|||||||
| OOTP Mods Logos, roster packs, historical databases, OOTP tools, FaceGen files... it's all here! |
![]() |
|
|
Thread Tools |
|
|
#1 |
|
Major Leagues
Join Date: Jul 2010
Posts: 469
|
Anyone have master.csv info
I was hoping someone could point me in the right direction. I have been in the process of creating my own database for my former DMB fictional league. I need info on the master.csv files fields. What are the fields after "bbrefID - ID used by Baseball Reference website". I searched this site in many different ways and can't find the answer. It looks like it may contain ratings of some kind but I'm not sure.
Thanks |
|
|
|
|
|
#2 |
|
Major Leagues
Join Date: Mar 2003
Location: Newcastle, Australia
Posts: 302
|
From here:
http://baseball1.com/statistics/readme57.txt Code:
2.1 MASTER table
lahmanID Unique number assigned to each player
playerID A unique code asssigned to each player. The playerID links
the data in this file with records in the other files.
managerID An ID for individuals who served as managers
hofID An ID for individuals who are in teh baseball Hall of Fame
birthYear Year player was born
birthMonth Month player was born
birthDay Day player was born
birthCountry Country where player was born
birthState State where player was born
birthCity City where player was born
deathYear Year player died
deathMonth Month player died
deathDay Day player died
deathCountry Country where player died
deathState State where player died
deathCity City where player died
nameFirst Player's first name
nameLast Player's last name
nameNote Note about player's name (usually signifying that they changed
their name or played under two differnt names)
nameGiven Player's given name (typically first and middle)
nameNick Player's nickname
weight Player's weight in pounds
height Player's height in inches
bats Player's batting hand (left, right, or both)
throws Player's throwing hand (left or right)
debut Date that player made first major league appearance
finale Date that player made first major league appearance (blank if still active)
college College attended
lahman40ID ID used in Lahman Database version 4.0
lahman45ID ID used in Lahman database version 4.5
retroID ID used by retrosheet
holtzID ID used by Sean Holtz's Baseball Almanac
bbrefID ID used by Baseball Reference website
Last edited by 21C; 07-18-2010 at 07:58 AM. |
|
|
|
|
|
#3 |
|
All Star Starter
Join Date: May 2006
Posts: 1,417
|
I think this is what he is looking for. The OOTP11 files don't have hearder rows. This is from OOTPX. I don't think it changed to 11. These are not Baseball Reference website or Lahman fields but OOTP unique fields.
DraftValue Fastball Changeup Curve Slider Sinker Splitter Forkball Cutter Knuckleball KnuckleCurve CircleChange Screwball PExp CExp 1bExp 2bExp ssExp 3bExp lfExp cfExp rfExp infRange infError infArm infDP Cability Carm ofRange ofError ofArm
__________________
Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds Last edited by Bristolduke; 07-18-2010 at 10:22 AM. |
|
|
|
|
|
#4 |
|
Major Leagues
Join Date: Jul 2010
Posts: 469
|
Thanks BristolDuke. That is exactly the info I was looking for! Now I just have to figure out how to fill those fields. For example, do you know what the parameters are for figuring out DraftValue?
Thanks again for your reply |
|
|
|
|
|
#5 |
|
All Star Starter
Join Date: May 2006
Posts: 1,417
|
How that data is derived is not known by us mere mortals. I too would be curious.
__________________
Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds |
|
|
|
![]() |
| Bookmarks |
|
|