|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Global Moderator
Join Date: Nov 2002
Location: Brooklyn, NY
Posts: 9,701
Thanks: 38
Thanked 91x in 51 posts
|
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?
__________________
THE VERY US ARTISTS - A project for musicians and visual artists My music Currently reading: Thirteen by Richard Morgan "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 |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|