Winning Picks, Guaranteed
S p o r t s D a t a b a s e . c o m
tools    for    the    objective    handicapper


name
password


MLB Sport Data Query Language Access. SDB Home     MLB Trends     MLB Query
Numerical options: SU | OU | RL | Invested

p:inning runs [4 : 7] = [2 , 2 , 2]
date team o:team Final
20040610 Padres Red Sox 3-9
20040703 Mets Yankees 10-9
20050518 Indians Angels 1-2
20070731 Braves Astros 12-4
20070825 Rays Athletics 14-3
20080806 Astros Cubs 4-11
20090422 Orioles White Sox 2-8
20090727 Phillies Diamondbacks 6-2
20090823 Royals Twins 3-10
20100722 Pirates Brewers 2-3
20100724 Brewers Nationals 4-3
20110904 Brewers Astros 4-0
20120415 Royals Indians 7-13
20120419 Braves Diamondbacks 10-2
20120910 Phillies Marlins 3-1
20121019 Cardinals Giants 0-5
20140826 Tigers Yankees 5-2
20150426 Twins Mariners 4-2
20150630 Diamondbacks Dodgers 4-6
20150917 Nationals Marlins 4-6
20150929 Marlins Rays 2-4
20170407 Mets Marlins 2-7
20170417 Braves Padres 5-4

Game Parameters: at bats, attendance, biggest lead, date, day, division, double header, double plays, earned runs, errors, game number, hit batters, hit by pitchers, hits, inning runs, innings led, innings tied, league, left on base, line, location, losses, margin, matchup losses, matchup wins, month, opponents, ou margin, ou streak, over, pitchers used, playoffs, profit, rest, run line, run line runs, run line streak, runs, scored first, season, series game, series games, site, site streak, start time, starter, starter losses, starter matchup losses, starter matchup wins, starter rest, starter throws, starter wins, streak, strike outs, team, team left on base, temperature, times tied, total, umpires, under, walks, wins

Pitcher Parameters: batters faced, earned runs, era, fly balls, ground balls, hit batters, hits allowed, home runs allowed, innings pitched, name, order, pitches, result, runs allowed, strike outs thrown, strikes, walks allowed

Batter Parameters: at bats, average, doubles, hit by pitchers, hits, home runs, left on base, name, position, rbi, runs, sacrifice flies, strike outs, triples, walks


How to Query:

The syntax for access to the MLB team database is: game reference:parameter. To see the date, team, and opponent where the team scored 12 runs after scoring 11 runs in the previous game use the SDQL: date,team,o:team@runs=12 and p:runs=11

The syntax for access to the MLB batters and pitchers databases is: team:player name:game reference:parameter. To see the date, team, opponent and number of hits by Arron Hill in the game after Arron Hill got 4 hits use the SDQL: date,team,o:team,Blue Jays:Aaron Hill:hits@Blue Jays:Aaron Hill:p:hits=4

The SDQL strives to be flexible in isolating batters and pitchers and all these formats for setting Arron Hill's previous hits to 4 are acceptable: Aaron Hill:p:hits=4, AaHi:p:hits=4, and AHill:p:hits=4
e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this site is generated using the Sports Data Query Language (SDQL).