As best as I can find in the @retrosheet.bsky.social data, the Reds tonight are the first team (definitely since 1974, possibly ever) to score 7+ runs in an inning and also have more than 20 batters in a row be retired (Brewers retired the last 23 Reds).
The Orioles earlier this year scored 8 runs in the 2nd inning against the Rays and then finished the game going 0-23, but there was a HBP mixed in so it doesn’t fit the parameters. It definitely fits them in spirit though.
Thanks to some help from @jaywigley.bsky.social, I can confirm that the Reds are the first team since at least 1911 to score 7+ runs in an inning and have more than 20 batters in a row retired in the same game. Yay?
I’m glad you did the analysis but I can’t decide if this is more a Brewers story or a Reds one. . .
What if I told you that the Reds are tied for the most 7+ run innings this season and have the 3rd most 1-2-3 innings by their batters?
Gotta love this game!
This has truly been a historic year it feels like, so many rare occurrences.
I found 4 games where a team scored 7+ runs in one inning and also had exactly 20 batters in a row retired before tonight: 4/9/2000 - Royals against the Twins 9/20/1999 - Cardinals against the Cubs 5/31/1992 - Padres against the Cardinals 8/3/1971 - Yankees against the Indians
The data is not complete prior to 1974, so it's possible we don't have play-by-play for another game where it happened. Will have to depend on Elias to find that, assuming they even care.
When you say the data is not complete before 1974, I’m surprised. For this sort of query, I’d think the data was sufficient back to at least 1911?
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.
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)
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.
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...
I. DID. NOT. KNOW. THAT. EXISTED. Thank you. I will explore these today!
Yes, I can import the latest data into a SQL database in no time now—so much easier than running BEVENT or its cousin!
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.
So the plays file is not structured the same as BEVENT's output though, right? This may be an offseason task then...
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.
"they just werent very good and things got out of hand".
Finding these nuggets of rare ineptitude almost makes it worth it?