Reconstructing a game from data in the SQL dump

ctorg · 04-22-2011, 12:40 PM

Is this possible? I've been looking over the games, games_score, and players_at_bat_batting_stats tables in Access and trying to figure out how, but there are crucial data elements missing. For instance, if a batter bats twice in the same inning without an out being recorded between his at bats, there doesn't seem to be a way of telling which at bat came first. Also, I don't see a way of telling when a guy steals a base or is caught stealing or is thrown out trying to advance a base (or anything else not necessarily tied to the outcome of an at bat).

I'm doing this because I want to work with the data in Access to create stats like wOBA, leverage-based stats, and so on. I'd been assuming the data would be in there, but if it is I can't find it.

Any input?

04-22-2011, 12:40 PM	#1
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Reconstructing a game from data in the SQL dump Is this possible? I've been looking over the games, games_score, and players_at_bat_batting_stats tables in Access and trying to figure out how, but there are crucial data elements missing. For instance, if a batter bats twice in the same inning without an out being recorded between his at bats, there doesn't seem to be a way of telling which at bat came first. Also, I don't see a way of telling when a guy steals a base or is caught stealing or is thrown out trying to advance a base (or anything else not necessarily tied to the outcome of an at bat). I'm doing this because I want to work with the data in Access to create stats like wOBA, leverage-based stats, and so on. I'd been assuming the data would be in there, but if it is I can't find it. Any input? __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils