Here's what I use: CREATE TABLE subs ( GAME_ID VARCHAR2(12) ,INN_CT INTEGER ,BAT_HOME_ID INTEGER ,SUB_ID VARCHAR2(8) ,SUB_HOME_ID INTEGER ,SUB_LINEUP_ID...
263
Brian L Cartwright
brianlcartwr...
Apr 13, 2009 5:40 am
Here's what I used for a data dictionary CREATE TABLE subs ( GAME_ID varchar(12) ,INN_CT int(2) ,BAT_HOME_ID int(1) ,SUB_ID varchar(8) ,BAT_LAST_ID int(1) ...
262
Brian L Cartwright
brianlcartwr...
Apr 13, 2009 12:24 am
... Colin had an article last Fall on StatSpeak which gave links to a $cwsub.bat, but there's no .sql data definition file, and I didn't find anything at...
261
Theodore Turocy
arb1ter
Apr 12, 2009 11:48 pm
On Sun, Apr 12, 2009 at 6:36 PM, Brian L Cartwright ... Your best bet is to use the output of the 'cwsub' program in Chadwick. It'll give you exactly that...
260
Brian L Cartwright
brianlcartwr...
Apr 12, 2009 11:37 pm
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...
259
Theodore Turocy
arb1ter
Apr 1, 2009 2:13 am
... I agree. In fact, I'd just start with EVENT_CD. First, because I think it's quite unlikely you'll get too many games which are that close using that as a...
258
Larry Granillo
lgranill
Apr 1, 2009 2:09 am
Thanks, Tom. I had noticed those fields before, but I dismissed them too early and then forgot to revisit them. It looks like that's exactly what I'm looking...
257
tangotiger
Apr 1, 2009 1:59 am
I'd suggest you use EVENT_CD, and FLD_CD. That will tell you what happened and who fielded it. Tom ... Tim Raines, Hall of Fame 2008 http://www.raines30.com/ ...
256
Larry Granillo
lgranill
Apr 1, 2009 1:47 am
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...
255
tangotiger
Mar 31, 2009 3:59 pm
... John, There are multiple ways to download, and IDA is one such way. Do you have this software? Tom...
254
tangotiger
Mar 31, 2009 3:57 pm
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...
253
w1nterl0ng
Mar 30, 2009 1:59 pm
Thanks For the info Tom. Where can I find a table description for Events and Games, I am not sure what the difference is between BAT_ID and RESP_BAT_ID Thanks,...
252
tangotiger
Mar 30, 2009 1:31 pm
Let me give you a general one to get the idea: select curr.resp_bat_id, curr.year_id , sum(prev.h_ct)/sum(prev.ab_ct) as bavg from events curr left join events...
251
w1nterl0ng
Mar 30, 2009 4:50 am
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...
250
tangotiger
Mar 11, 2009 2:04 am
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 ...
249
tangotiger
Mar 2, 2009 12:57 pm
str ... Tim Raines, Hall of Fame 2008 http://www.raines30.com/ ... From: Brian L Cartwright <brian.cartwright2@...> Subject: [RetroSQL] Date Formatting...
248
Brian L Cartwright
brianlcartwr...
Mar 2, 2009 7:50 am
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...
247
tangotiger
Feb 26, 2009 3:20 am
Wunderground.com .... missed the w. Tom ... Tim Raines, Hall of Fame 2008 http://www.raines30.com/...
246
tangotiger
Feb 26, 2009 3:16 am
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...
245
Kyle W. Willkomm
willkoky
Feb 1, 2009 11:27 pm
I know Tango said he doesn't mind postings going here but I have to think there are a lot of people on the list who are not interested in BBOS issues and so I...
244
Brian L Cartwright
brianlcartwr...
Feb 1, 2009 7:36 pm
Narrowing thnigs down.... I manually loaded the createMLB.sql using the MySQL source command There is a syntax error in the gameday.pitches table definition ...
243
Brian L Cartwright
brianlcartwr...
Feb 1, 2009 5:45 pm
Sent: Sunday, February 01, 2009 10:03 AM ... I had thought that install ran properly, but after running it from the command prompt I saw the error (which was...
242
Kyle W. Willkomm
willkoky
Feb 1, 2009 3:03 pm
If you don't see any new DB's then I think you skipped a step from the instructions in Install.txt. In the bin directory the first thing you have to do after...
241
Brian L Cartwright
brianlcartwr...
Feb 1, 2009 9:59 am
... INFO 2009-02-01 04:03:39 log.init.20 Logging to c:\temp\bbos.py.log INFO 2009-02-01 04:03:39 loggingsetup.initializeLogging.7 INFO 2009-02-01 04:03:39...
240
KY
willkoky
Feb 1, 2009 5:01 am
There is a new version of Baseball on a Stick out. In December I got some feedback here and I have addressed some of the issues mentioned. ...
239
tangotiger
Jan 24, 2009 3:35 am
(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...
238
tangotiger
Jan 16, 2009 11:06 pm
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...
237
Theodore Turocy
arb1ter
Jan 16, 2009 4:41 am
... Minor correction: it's currently set to 'F' in all records. Ted...
236
tangotiger
Jan 16, 2009 4:28 am
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,...
235
tangotiger
Jan 15, 2009 5:22 pm
(Cross-posted to multiple yahoo groups.) This is the complete ID mappings for all MLB players in the 2008 season: ...
