For the stat geeks
I was playing around with some of the boxscore data that Baseball Reference has available (much of the actual raw data is courtesy of Retrosheet). I’m amazed what you can find out these days.
There’s a boxscore video tutorial narrated by none other than B-R founder Sean Forman. It gives you an idea what’s out there.
For the real number crunchers, try B-R’s Play Index, a set of data tools that allow you to find streaks, events, totals etc. Some of the more involved searches using the Play Index do require a paid subscription.