{"id":67,"date":"2017-09-21T16:17:39","date_gmt":"2017-09-21T16:17:39","guid":{"rendered":"http:\/\/www.ootp.cavebutter.net\/blog\/?p=67"},"modified":"2017-09-21T16:17:39","modified_gmt":"2017-09-21T16:17:39","slug":"tables-7-player-career-fielding-stats","status":"publish","type":"post","link":"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/67","title":{"rendered":"<font color='#1e73be'>Tables 7: Player Career Fielding Stats<\/font>"},"content":{"rendered":"<p>Fielding stats are the last group of stats I am going to look at, so I don&#8217;t have all that much to say about this table at the moment. \u00a0I set up indexes on the same fields as I did for the <a href=\"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/64\">Career Batting Stats<\/a> table.<\/p>\n<p>There are a few columns that I need to understand still:<\/p>\n<ul>\n<li>&#8216;rto&#8217;<\/li>\n<li>&#8216;ipf&#8217;<\/li>\n<li>We also have a calculated stat for <a href=\"http:\/\/www.fangraphs.com\/tht\/what-is-zone-rating\/\">Zone Rating<\/a>. \u00a0This one, too, would be pretty hard to calculate on our own (though I would like to try!) \u00a0There&#8217;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. \u00a0It&#8217;s likely that it&#8217;s in the data dump options somewhere, but I haven&#8217;t looked hard enough yet to say.<\/li>\n<\/ul>\n<pre class=\"line-numbers\"><code class=\"language-sql\">CREATE TABLE `players_career_fielding_stats` (\r\n  `pcfs_id` int(11) NOT NULL Auto_Increment,    \r\n  `player_id` int(11) NOT NULL,\r\n  `year` smallint(6) NOT NULL,\r\n  `team_id` int(11) NOT NULL,\r\n  `league_id` int(11) DEFAULT NULL,\r\n  `level_id` smallint(6) DEFAULT NULL,\r\n  `split_id` smallint(6) DEFAULT NULL,\r\n  `position` smallint(6) NOT NULL,\r\n  `tc` smallint(6) DEFAULT NULL,\r\n  `a` smallint(6) DEFAULT NULL,\r\n  `po` smallint(6) DEFAULT NULL,\r\n  `er` smallint(6) DEFAULT NULL,\r\n  `ip` smallint(6) DEFAULT NULL,\r\n  `g` smallint(6) DEFAULT NULL,\r\n  `gs` smallint(6) DEFAULT NULL,\r\n  `e` smallint(6) DEFAULT NULL,\r\n  `dp` smallint(6) DEFAULT NULL,\r\n  `tp` smallint(6) DEFAULT NULL,\r\n  `pb` smallint(6) DEFAULT NULL,\r\n  `sba` smallint(6) DEFAULT NULL,\r\n  `rto` smallint(6) DEFAULT NULL,\r\n  `ipf` smallint(6) DEFAULT NULL,\r\n  `plays` smallint(6) DEFAULT NULL,\r\n  `plays_base` smallint(6) DEFAULT NULL,\r\n  `roe` smallint(6) DEFAULT NULL,\r\n  `zr` double DEFAULT NULL,\r\n  PRIMARY KEY (`pcfs_id`),\r\n  INDEX `pcfs_ix1` (`league_id`),\r\n  INDEX `pcfs_ix2` (year),\r\n  INDEX `pcfs_ix3` (`player_id`),\r\n  INDEX `pcfs_ix4` (`team_id`),\r\n  INDEX `pcfs_ix5` (`split_id`) \r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Fielding stats are the last group of stats I am going to look at, so I don&#8217;t have all that much to say about this table at the moment. \u00a0I 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&hellip; <a class=\"more-link\" href=\"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/67\">Continue reading <span class=\"screen-reader-text\">Tables 7: Player Career Fielding Stats<\/span> <span class=\"meta-nav\" aria-hidden=\"true\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[10],"tags":[16,7,4,22],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-tables","tag-fielding","tag-mysql","tag-ootp","tag-players"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9cxb5-15","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":1,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":68,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions\/68"}],"wp:attachment":[{"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ootp.cavebutter.net\/blog\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}