SELECT a.*,p.*,cast(concat(b.firstname,' ',b.lastname) AS CHAR(100)) BatterName,b.bats,b.borndate BatterBorn ,if(battingteam=0,'V','H') batterVH,if(battingTeam=0,'H','V') pitcherVH ,if(battingteam=0,visTeam,left(A.gameid,3)) BatterTeam,if(battingteam=0,left(A.gameid,3),visTeam) PitcherTeam ,cast(concat(c.firstname,' ',c.lastname) AS CHAR(100)) PitcherName,c.throws,c.borndate PitcherBorn,a.eventtext,a.pitches,a.inning,a.outs,a.batterhand bats,a.pitcherHand throws,cast(concat(a.balls,'-',a.strikes) AS CHAR(4)) BalStr,b.playerid battertbcid,c.playerid pitchertbcid,(((if(batterdest<4,0,1) + if(runner1dest<4,0,1) + if(runner2dest<4,0,1) + if(runner3dest<4,0,1)))) Runs FROM PLAY A ,Play_Description P ,DIM_Players B ,DIM_Players C WHERE 1=1 and a.gameid=p.gameid and a.seq=p.seq and a.batter=b.retroid and a.pitcher=c.retroid LIMIT 100 Play Finder - Research Application - The Baseball Cube
Page Notes  
The Play Finder serves as your doorway to historical event data for every batting event since 1957. This page is functional as a stand-alone application and it will also serve as an interface for other sections of the site for specific reports. Like all applications, it is only available to TBC PREMIUM subscribers.

This application will output a maximum of 100 records.
Subscribe to TBC PREMIUM

Here's what you get:
  • Ad-Free Surfing.
  • Access to Research Applications
  • 25% discount in Data Store
  • $5 Sponsorship
  • Some site-wide options.
  • Get TBC PREMIUM and remove ads, cleaner display, access to research applications, data store discounts and more!
    The TBC Newsletter will keep you periodically up-to-date on what is happening at The Baseball Cube.

    Application Filters

    Reset Form
    Player Info
    Batter Name
    Pitcher Name
    Position
    Lineup Slot
    Pitcher Type
    Bats
    Throws
    Batter Age Pitcher Age
    Game Data
    Years
    Month
    Batter Team Pitcher Team
    Vis/Home
    Day/Night
    Surface
    Win/Loss
    Situation
    Inning
    Outs
    Count
    Runners
    Situation
    Winning/Losing
    Score Differential
    Event Info
    Event Flag
    Event Result
    Event Code
    Batted Ball Type
    Location
    Outs on Play
    Runs
    RBIs