Same breakdown here as the previous career stats tables, with indexes on player_id, year, split_id, stint, and team_id. Similar to the batting stats table, we have a couple calculated statistics here: WPA (though I am not sure how this works for pitchers…is it per AB?), and WAR. We also have a column that I haven’t been able to identify: ‘li’.
I will come back to this in another section, but this is the table we’ll reference when aggregating data for Run Environments as we don’t have a reliable way to group league history pitching data by subleague or of calculating outs. On this table, outs are conveniently recorded in the ‘outs’ column.
CREATE TABLE `players_career_pitching_stats` (
`pcps_id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`year` smallint(6) NOT NULL,
`team_id` int(11) NOT NULL,
`game_id` int(11) DEFAULT NULL,
`league_id` int(11) DEFAULT NULL,
`level_id` smallint(6) DEFAULT NULL,
`split_id` smallint(6) NOT NULL,
`ip` smallint(6) DEFAULT NULL,
`ab` smallint(6) DEFAULT NULL,
`tb` smallint(6) DEFAULT NULL,
`ha` smallint(6) DEFAULT NULL,
`k` smallint(6) DEFAULT NULL,
`bf` smallint(6) DEFAULT NULL,
`rs` smallint(6) DEFAULT NULL,
`bb` smallint(6) DEFAULT NULL,
`r` smallint(6) DEFAULT NULL,
`er` smallint(6) DEFAULT NULL,
`gb` smallint(6) DEFAULT NULL,
`fb` smallint(6) DEFAULT NULL,
`pi` smallint(6) DEFAULT NULL,
`ipf` smallint(6) DEFAULT NULL,
`g` smallint(6) DEFAULT NULL,
`gs` smallint(6) DEFAULT NULL,
`w` smallint(6) DEFAULT NULL,
`l` smallint(6) DEFAULT NULL,
`s` smallint(6) DEFAULT NULL,
`sa` smallint(6) DEFAULT NULL,
`da` smallint(6) DEFAULT NULL,
`sh` smallint(6) DEFAULT NULL,
`sf` smallint(6) DEFAULT NULL,
`ta` smallint(6) DEFAULT NULL,
`hra` smallint(6) DEFAULT NULL,
`bk` smallint(6) DEFAULT NULL,
`ci` smallint(6) DEFAULT NULL,
`iw` smallint(6) DEFAULT NULL,
`wp` smallint(6) DEFAULT NULL,
`hp` smallint(6) DEFAULT NULL,
`gf` smallint(6) DEFAULT NULL,
`dp` smallint(6) DEFAULT NULL,
`qs` smallint(6) DEFAULT NULL,
`svo` smallint(6) DEFAULT NULL,
`bs` smallint(6) DEFAULT NULL,
`ra` smallint(6) DEFAULT NULL,
`cg` smallint(6) DEFAULT NULL,
`sho` smallint(6) DEFAULT NULL,
`sb` smallint(6) DEFAULT NULL,
`cs` smallint(6) DEFAULT NULL,
`hld` smallint(6) DEFAULT NULL,
`ir` double DEFAULT NULL,
`irs` double DEFAULT NULL,
`wpa` double DEFAULT NULL,
`li` double DEFAULT NULL,
`stint` smallint(6) NOT NULL,
`outs` smallint(6) DEFAULT NULL,
`war` double DEFAULT NULL,
PRIMARY KEY (`pcps_id`),
INDEX `pcps_ix1` (`league_id`),
INDEX `pcps_ix2` (year),
INDEX `pcps_ix3` (`player_id`),
INDEX `pcps_ix4` (`team_id`),
INDEX `pcps_ix5` (`split_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;