Trying to get BBOS working. I use SQLyog and I have Python 2.5.2 downloaded on to my desktop. I've tried to follow the BBOS\doc\install.txt directions but I'm...
Greetings, all... Maybe I'm just having SQL fatigue since I use it all day, but I'm stumped on this one... How would I go about finding how many consecutive...
So OK I play video games, and the announcer in the video game said "It's often that the winner scores more runs in an inning than the loser scores in a game."...
Oh I've Googled, but I'm trying to figure out why my Retrosheet database has 'F' for RUN1_SB_FL, etc (when the case is that there's no runner). I know there's...
Reading/working through stuff in Baseball Hacks, and I'm curious about his hit spray charts. Specifically, why he uses the 0-250, -250-0 x/y ranges. Why these...
What's the relationship between the GAME_ID value and the Retrosheet box score URL? e..g http://www.retrosheet.org/boxesetc/2003/B06110NYA2003.htm vs the ...
In terms of what data to actually download, it seems to me that the pbp/batters and pbp/pitchers directories are redundant: the former just contains the...
Can we use this list to discuss Gameday data? I have some questions... if there's a better/different list, please let me know. Thanks! -- Wells Oliver ...
It seems to work moderately well on 2008 data (although I have to run the createMLB.sql file myself) but when I try to use it on earlier seasons the atbats...
I'm building an events table from Gameday data. The base runners are listed in the pitchers table. In joining events to pitches, I want to return on_1b, on_2b...
Running chadwick against the event files, and am getting the following error. command: cwevent -f 0-96 -x 0-52 -y 2006 2006*.EV* > all2006.csv result: ***...
Why are the 'sections' for MySQL all missing? The Oracle schemas of course have much that does not work with MySQL. I'm able to translate them well enough to...
With the release of the '20s data, the Box Score Event Files have suddenly become much more interesting. I was perusing them and trying to figure out the best...
Most of the time, but not always, the FLD_CD (positioned played by the baserunner) is 0 when the runner was a PR or was a PH who reached base, but not always. ...
Which code indicates when a defensive replacement enters the game? When it occurs, I need to know playerID, batting order, and fielding position. thanks Brian...
Does anyone have a standard algorithm/function that they use within an SQL query to read an event field and output a general description of that event? For...
John, I am redirecting your question to RetroSQL (from where I'll reply), as that's the much better audience for this (unless the RetroList mods prefer the...
Hi All RetroSQL members. I am trying to write a SQL statement that will calculate the current Batting Average of a player from the beginning of the season, and...
See related RetroList thread on the subject. End result will give you this: http://tangotiger.net/files/invalid_pitch_codes.html Tom -- clem comly validation ...
All of my db's that have birthdates (Retro, bdb, Lahman), there are three seperate numeric fields, one each for year, month and day. In a query (I'm ussing...
From underground.com, via SABRmatt: http://tangotiger.net/sabrmatt/baseball_weather.csv.zip Now, all we need is for someone to link it with Retrosheet, and...
(Cross-posted to multiple Yahoo groups.) http://tangotiger.net/retrosheet/reports/hands.csv This file shows how many PA for each combination of hitting and...
In Oracle, this command took 90 seconds: create table events_pitch_seq as select seq_Events , pitch_seq_tx , translate(pitch_seq_tx, 'X123+*.>', 'X') as...
PA_TRUNC_FL shows you those plate appearances where the batter did NOT record a PA, because the inning (or game) ended with a runner on base thrown out. So,...
Hello, Thanks for allowing me to join this group. I am a teacher at University of Phoenix and would love to use Retrosheet/Baseball as a way to teach database,...
Has the wind quit blowing in from RF. I did a search on the games database for wind direction and the most recent case of a "7" showing up was in 2003 for any...
I'll be working on CWLOG soon. I know that Mat provided his column names for this table a few months back. I'll go through his list, and the standards I have...
I finally got my new implants, I simply LOVE them but I'm getting mixed reviews from my friends lol maybe they are jealous I'm not sure.. tell me what you...
