To be able to get consecutive outs you need play-by-play. We don't have that for every game back to 1911, do we? I thought there were missing games.
Replies
There are games where we don’t have all the details on the put-outs, like 63 or 31. But those are known outs and are coded “99” for missing play (but still outs). So you can run the analysis here I believe! (Using the latest @retrosheet.bsky.social release from a week or so ago)
aug 16, 2025, 1:03 pm • 1 0 • view
I use cwevent to split the files into event files to query and there are lots of games not in the event files. Is cwevent skipping games that BEVENT wouldn't? That seems weird. I'll admit that I don't know how to do something like this from the raw files.
aug 16, 2025, 1:16 pm • 0 0 • view
I suspect that you aren’t running CWEVENT on the deduced games, which are in separate files? There is also a CSV version of ALL game events available here (which saves you the CWEVENT work): www.retrosheet.org/downloads/cs...
aug 16, 2025, 1:21 pm • 1 0 • view
I. DID. NOT. KNOW. THAT. EXISTED. Thank you. I will explore these today!
aug 16, 2025, 1:25 pm • 1 0 • view
Yes, I can import the latest data into a SQL database in no time now—so much easier than running BEVENT or its cousin!
aug 16, 2025, 1:27 pm • 0 0 • view
Thank you for pointing this stuff out! I'm excited to dig into it. Also, good to know that I was skipping the deduced files. This is part of the problem with teaching yourself something. No matter how long you use it, you may not know what you don't know.
aug 16, 2025, 1:44 pm • 1 0 • view
I’m always excited to hear about when someone learns new ways to use the Retrosheet data! I’m happy to answer further questions either this way or via email jaywigley@mac.com
aug 16, 2025, 1:48 pm • 0 0 • view
So the plays file is not structured the same as BEVENT's output though, right? This may be an offseason task then...
aug 16, 2025, 1:31 pm • 0 0 • view
It is nearly identical to CWEVENT’s output, but may be in a different order (column order, I mean). There’s a field map (from one to the other) here: retrosheet.org/downloads/pb...
aug 16, 2025, 2:41 pm • 1 0 • view
Sweet! Now I don't have to change my entire process!
aug 16, 2025, 2:48 pm • 1 0 • view
This is a response I wish I could heart a hundred times
aug 16, 2025, 3:02 pm • 0 0 • view
I actually just did a check, and there are definitely games that aren't in the event files. For instance, I specifically checked 'BSN195007090' and 'BOS195004191' just to check 2 games that weren't in my event table.
aug 16, 2025, 1:19 pm • 0 0 • view