View Single Post
Old 04-17-2017, 07:40 PM   #2
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,483
Thanks: 171
Thanked 1,208x in 448 posts
Quote:
Originally Posted by cavebutter View Post
1. On the players_career_batting _stats table, there is a field called split_id, and it effectively breaks a player's season into different records. In most cases, the player is on the same team in the same year for these splits. My question is, how do I interpret these splits? What do they mean?
The split_id field defines the scope of the data and is slightly different depending on the table. The batting and pitching tables both use 1 to define regular season stats.

1 - Regular Season Totals
2 - Regular Season Vs LH
3 - Regular Season Vs RH
21 - Postseason

The fielding table uses 0 for regular season stats and doesn't give you any other splits.

Quote:
Originally Posted by cavebutter View Post
2. Where can I find players' historical salaries? The players_contract table seems to only show the values for their current contracts.
You can't. OOTP doesn't export historical salaries.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Thank you for this post:
cavebutter (04-18-2017)