Baseball Box Score Research Database

The database contains data for games played from 1956 through 2006; and can be helpful in narrowing the box scores that you'll need to search through by providing you with a list of games where a certain set of events have occurred.

Here is some of the information that you will get when you query the database
(the information you get is not detailed. Detailed information is available in our box score booklets):
  • Game's line score
  • Final score
  • Starting pitchers
  • Winning, Losing and Saving (when appropriate) pitcher's names - a pitcher who pitched during the game, but was not awarded one of these decisions will not be listed
  • Starting line-ups
  • Officiating umpires
  • Attendance
  • Time it took to complete game

You can query the database in two way: using the predefined CONDITIONS query or in FREEHAND query mode.

Predefined CONDITIONS Query Mode

In predefined CONDITIONS query mode, you choose from a list of CONDITIONS. screen shot

As you pick a condition, you will be prompted to provide a value for that condition. For instance, if you choose Visiting team as a condition, you will be prompted to pick a corresponding value from a list of teams.

The CONDITION and its associated VALUE (i.e.: Visiting Team = 'New York Yankees') will be displayed in the SELECTED CONDITIONS box. screen shot

As you continue to choose CONDITIONS, they will be added to the SELECTED CONDITIONS box.

When you have added all the conditions you need for your query, click the SUBMIT QUERY button to get the results of your query.
Your results will be returned in the format displayed below - one for each game that matches your query.

Screenshot

FREEHAND Query Mode

To use the FREEHAND query mode, you must have an understanding of SQL (Sequential Query Language). This mode will allow you to access all the available fields in the database and perform more complex queries. Your result(s) will be returned in the same format as they are in the CONDITIONS query mode.

Below are a few sample queries that anyone can use in FREEHAND query mode. Just click on the link to go to the FREEHAND query page. Make adjustments to the query there or just click the SUBMIT button to get the results.
  1. 1968 Shutouts by Don Drysdales - including his record-setting six consecutive

    2. ((h_start_pitcher_name = 'Don Drysdale' AND h_pused =1 AND vscore=0) OR (v_start_pitcher_name = 'Don Drysdale' AND v_pused = 1 AND hscore=0)) AND syear = 1968

  2. Game(s) where a team was no-hit, but still won the game.
    (h_hits=0 AND hscore > vscore) OR (v_hits=0 AND vscore > hscore)


  3. Game(s) where a team got 12 or more hits, but was shutout
    (v_hits >=12 AND vscore =0) OR (h_hits >=12 AND hscore =0)


  4. Game(s) where a team fielded 6 or more double-plays
    (v_dp >=6 OR h_dp >=6)


  5. Game(s) where one or more pitchers combined to strikeout 20 or more batters on a team
    (h_so >=20 OR v_so >=20)


  6. Game(s) where a team scored 15 or more runs and still lost
    (vscore >=15 AND hscore > vscore) OR (hscore >=15 AND vscore > hscore)


  7. Game(s) where a team score 15 or more runs and also shutout their opponents
    (vscore=0 AND hscore >= 15) OR (hscore =0 AND vscore >=15)


  8. Game(s) where a no-hitter was pitched
    (v_hits =0 OR h_hits = 0)


  9. Game(s) where a perfect no-hitter was pitched
    ((v_hits = 0 AND vscore = 0 AND v_bb = 0 AND h_error = 0 AND v_hbp = 0) OR (h_hits = 0 AND hscore = 0 AND h_bb = 0 AND v_error = 0 AND h_hbp = 0)) AND game_logs.game_length >= 51

To use your own queries, click the button below to access FREEHAND query mode.