Fielding stats are the last group of stats I am going to look at, so I don’t have all that much to say about this table at the moment. I set up indexes on the same fields as I did for the Career Batting Stats table.
There are a few columns that I need to understand still:
- ‘rto’
- ‘ipf’
- We also have a calculated stat for Zone Rating. This one, too, would be pretty hard to calculate on our own (though I would like to try!) There’s definitely not enough of the right data in this table to calculate it or UZR or other advanced defensive metrics without additional gameplay data. It’s likely that it’s in the data dump options somewhere, but I haven’t looked hard enough yet to say.
CREATE TABLE `players_career_fielding_stats` (
`pcfs_id` int(11) NOT NULL Auto_Increment,
`player_id` int(11) NOT NULL,
`year` smallint(6) NOT NULL,
`team_id` int(11) NOT NULL,
`league_id` int(11) DEFAULT NULL,
`level_id` smallint(6) DEFAULT NULL,
`split_id` smallint(6) DEFAULT NULL,
`position` smallint(6) NOT NULL,
`tc` smallint(6) DEFAULT NULL,
`a` smallint(6) DEFAULT NULL,
`po` smallint(6) DEFAULT NULL,
`er` smallint(6) DEFAULT NULL,
`ip` smallint(6) DEFAULT NULL,
`g` smallint(6) DEFAULT NULL,
`gs` smallint(6) DEFAULT NULL,
`e` smallint(6) DEFAULT NULL,
`dp` smallint(6) DEFAULT NULL,
`tp` smallint(6) DEFAULT NULL,
`pb` smallint(6) DEFAULT NULL,
`sba` smallint(6) DEFAULT NULL,
`rto` smallint(6) DEFAULT NULL,
`ipf` smallint(6) DEFAULT NULL,
`plays` smallint(6) DEFAULT NULL,
`plays_base` smallint(6) DEFAULT NULL,
`roe` smallint(6) DEFAULT NULL,
`zr` double DEFAULT NULL,
PRIMARY KEY (`pcfs_id`),
INDEX `pcfs_ix1` (`league_id`),
INDEX `pcfs_ix2` (year),
INDEX `pcfs_ix3` (`player_id`),
INDEX `pcfs_ix4` (`team_id`),
INDEX `pcfs_ix5` (`split_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;