Loading ...
Sorry, an error occurred while loading the content.
545
Pitch string validation This is the validation I run, and send to Dave. Since I only upload 1993-present data, if someone wants to run it for pre-1993, please do so. And if others
Tangotiger
Mar 8
#545
 
544
BBOS 6.0 Hello, There was a release of BBOS today (Pitch F/X and Retrosheet data database loading tool). Release notes are below. Please post any questions to the
Kyle W. Willkomm
Mar 5
#544
 
543
Re: Inherited runners Here is my final code The first query has a subquery that finds the event_id of the relief pitcher’s batter faced, and then joins back to the events to get
Brian L Cartwright
Dec 23, 2013
#543
 
Fetching Sponsored Content...
542
Re: Inherited runners I believe the RUNx_RESP_PIT_ID takes care of the shifting of pitcher responsibility as described in the Chadwick documentation
Brian L Cartwright
Dec 21, 2013
#542
 
541
Re: Inherited runners Just wondering if you are allowing for the shifting of pitcher responsibility between base runners. For instance, Reliever Face enters game with no out and
Clem Comly
Dec 21, 2013
#541
 
540
Re: Inherited runners Think I got that, looks like I’ll have to make one pass to find the inherited runners and a second to find how many scored. Thanks! Brian Cartwright From:
Brian L Cartwright
Dec 21, 2013
#540
 
539
Re: Inherited runners Use the events where the runs actually score. Select pitcher [not result pitcher] where destination_of_runnner_on_first > 3 and pitcher !=
Clem Comly
Dec 21, 2013
#539
 
538
Inherited runners How can we tell which pitcher was on the mound when a particular runner scored? BASEx_Run_ID during a relief pitcher’s first batter will tell which bases
Brian L Cartwright
Dec 21, 2013
#538
 
537
Learn how to use Retrosheet Gentlemen, I'd really like to learn how to use Retrosheet, and hopefully in the process a database like Access. My business uses a large amount of data, and
ksesquire
Dec 18, 2013
#537
 
536
Re: runs scored from event files ... to pick up PRs who score also use the destination fields instead: Select batter_id WHERE batter destination > 3 UNION ALL Select first runner WHERE runner
Clem Comly
Dec 3, 2013
#536
 
535
Re: bat_fld_cd ... Glad to have you here Clem. I believe you, or someone at Retrosheet, said that "official does not imply right". It is very interesting how silly the
Tangotiger
Dec 3, 2013
#535
 
534
bat_fld_cd I finally got around to joining this group and didn’t see a correct resolution to this thread posted. As if the AL in 1973 wanted its DH stats to be as
Clem Comly
Dec 3, 2013
#534
 
533
Re: Error checking Wonderful, thanks! I forwarded to Dave. Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com
Tangotiger
Oct 6, 2013
#533
 
532
Re: Error checking https://docs.google.com/spreadsheet/ccc?key=0AiJWR6a0B5vndEFtVXZ4Q3JabXIzQUNKa1R2dkVJRGc#gid=0 ... -- -J
James Gentile
Oct 6, 2013
#532
 
531
Error checking I ran this for Dave for 1993-2012. I don't have my DB updated for prior to that. If someone can volunteer to run this for prior to 1993, please post here,
Tangotiger
Oct 6, 2013
#531
 
Fetching Sponsored Content...
530
Re: baseball ID cross reference? The last file posted was in March. Does anyone know when an updated file might be available? Thanks. ---In RetroSQL@yahoogroups.com,
sttfrk
Oct 1, 2013
#530
 
529
Calculating Runs Scored from the Events File I am trying to calculate in-season statistics for players using the Events file from Retrosheet, and have had some trouble calculating the runs scored for
wykim1122
Aug 14, 2013
#529
 
528
Ed Ecklund
Jul 28, 2013
#528
 
527
Re: Bat_fld_cd Thanks, Tom. I'm actually away from my d/b at the moment but will check tonight.
James Gentile
Jul 26, 2013
#527
 
526
Re: Bat_fld_cd I think it was pinch runner? That is, he came into the game as a pinch runner, then his turn came back up in the same inning? Anyway, should be easy enough to
Tangotiger
Jul 26, 2013
#526
 
525
AUTO: Eric Lundeen is out of the office (returning 07/30/2013) I am out of the office until 07/30/2013. I will be out of the office until Tuesday 7/30. You can contact Brett Pennington (blpennin@...) in my absence.
Eric Lundeen
Jul 26, 2013
#525
 
524
Bat_fld_cd To isolate PAs by DH only, you'd use bat_fld_cd = 10, correct? Then what is bat_fld_cd 11? Anyone know?
dangerwhatevs
Jul 26, 2013
#524
 
523
CWEvent / BEvent In the output of bevent or cwevent, what do the values in bat_play_tx mean? It is a text field, but populated with integers. I spy integers above 60, out of
David
Jul 15, 2013
#523
 
522
py-mlb So I'm playing around with Wells Oliver's py-mlb scripts and having some issues (I think) with my db.cfg file. I have
Casey
Jun 17, 2013
#522
 
521
Players ID in Yahoo Hi everybody, Trying to find a table with the Yahoo Players ID. Any ideas? Regards, Freddy
Freddy
Apr 20, 2013
#521
 
520
Re: baseball ID cross reference? Thanks Michael. It's a really good work...
Freddy
Apr 20, 2013
#520
 
519
Re: baseball ID cross reference? Freddy - here's the link: http://chadwick-bureau.com/the-register/ Michael Thain
Michael Thain
Apr 18, 2013
#519
 
Fetching Sponsored Content...
518
Re: baseball ID cross reference? Hello, I was following the thread but it's not clear to me the steps to follow if I will be interested on the Chadwick's master persons register and ID
Freddy
Apr 13, 2013
#518
 
517
Re: Events that comprise an AB? I remember this, I think the discrepancy was a catcher's interference call, but I can't recall the specific event. Doesn't look like I saved my notes when I
Michael Donato
Apr 2, 2013
#517
 
516
Re: Events that comprise an AB? Looking Jeter up on B-Ref, he's credited with 740 PA and 683 AB, so 57 non-AB events - 45 BB, 5 HBP, 6 SH and 1 SF, plus 1 IBB. I have those exact same totals
Brian L Cartwright
Apr 1, 2013
#516
 
View First Topic Go to View Last Topic
Loading 1 - 30 of total 545 messages