Information you need to win.
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

team = Phillies and starter = Cliff Lee and s:SHRA = 0 and s:SIP >= 6 and s:W
RL: 27-16 (1.06, 62.8%)   avg line: 111.4 / -123.2   on / against: +$1,665 / -$1,881   ROI: +34.0% / -32.7%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.77 3.16 6.51 8.95 2.00 1.23 2.72 1.21 5.70 14.14 6.91 0.77 2.07 2.67
Opp 2.56 1.74 8.26 7.37 1.47 0.56 1.67 0.56 1.49 12.47 5.86 0.79 3.44 4.05
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 31, 2009 box Fri away Phillies Cliff Lee - L Giants Ryan Sadowski - R 5-1 4 W -2.5 U 8-4 0-1 5-0 -165 8.5 9
Aug 06, 2009 box Thu home Phillies Cliff Lee - L Rockies Aaron Cook - R 3-1 2 W -4.5 U 7-8 1-0 2-1 -160 8.5 9
Aug 13, 2009 box Thu away Phillies Cliff Lee - L Cubs Ryan Dempster - R 6-1 5 W -1.0 U 10-6 0-0 5-0 -130 8.0 9
Aug 19, 2009 box Wed home Phillies Cliff Lee - L Diamondbacks Dan Haren - R 8-1 7 W 1.5 O 13-2 1-0 7-0 -165 7.5 9
Aug 24, 2009 box Mon away Phillies Cliff Lee - L Mets Bobby Parnell - R 6-2 4 W 0.0 P 7-6 2-3 4-0 -270 8.0 9
Aug 29, 2009 box Sat home Phillies Cliff Lee - L Braves Derek Lowe - R 1-9 -8 L 2.0 O 11-14 0-1 1-8 -180 8.0 9
Sep 15, 2009 box Tue home Phillies Cliff Lee - L Nationals Garrett Mock - R 5-0 5 W -4.0 U 10-6 0-1 5-0 -300 9.0 9
Sep 20, 2009 box Sun away Phillies Cliff Lee - L Braves Tommy Hanson - R 4-2 2 W -1.0 U 10-7 1-0 3-1 100 7.0 9
Oct 12, 2009 box Mon away Phillies Cliff Lee - L Rockies Ubaldo Jimenez - R 5-4 1 W 1.0 O 9-9 2-0 2-2 100 8.0 9
Oct 18, 2009 box Sun home Phillies Cliff Lee - L Dodgers Hiroki Kuroda - R 11-0 11 W 3.0 O 11-3 0-0 11-0 -170 8.0 9
Oct 28, 2009 box Wed away Phillies Cliff Lee - L Yankees CC Sabathia - L 6-1 5 W -0.5 U 9-6 1-0 6-0 160 7.5 9
Nov 02, 2009 box Mon home Phillies Cliff Lee - L Yankees AJ Burnett - R 8-6 2 W 5.5 O 9-10 0-0 6-1 -155 8.5 9
Apr 20, 2011 box Wed home Phillies Cliff Lee - L Brewers Chris Narveson - L 4-3 1 W -0.5 U 6-10 1-0 1-3 -200 7.5 9
May 26, 2011 box Thu home Phillies Cliff Lee - L Reds Homer Bailey - R 10-4 6 W 7.0 O 13-10 0-0 6-0 -150 7.0 9
Jun 11, 2011 box Sat home Phillies Cliff Lee - L Cubs Matt Garza - R 7-1 6 W 0.5 O 10-4 0-2 6-0 -195 7.5 9
Jun 16, 2011 box Thu home Phillies Cliff Lee - L Marlins Javier Vazquez - R 3-0 3 W -5.0 U 10-2 0-0 3-0 -230 8.0 9
Jun 22, 2011 box Wed away Phillies Cliff Lee - L Cardinals Kyle Lohse - R 4-0 4 W -3.5 U 8-6 0-0 4-0 -150 7.5 9
Jun 28, 2011 box Tue home Phillies Cliff Lee - L Red Sox Josh Beckett - R 5-0 5 W -2.0 U 6-2 0-1 5-0 -135 7.0 9
Jul 03, 2011 box Sun away Phillies Cliff Lee - L Blue Jays Jo Jo Reyes - L 4-7 -3 L 3.0 O 10-11 2-0 4-3 -180 8.0 9
Aug 09, 2011 box Tue away Phillies Cliff Lee - L Dodgers Ted Lilly - L 2-1 1 W -3.5 U 6-6 0-1 2-0 -180 6.5 9
Aug 17, 2011 box Wed home Phillies Cliff Lee - L Diamondbacks Joe Saunders - L 9-2 7 W 3.5 O 12-3 0-3 7-1 -240 7.5 9
Aug 31, 2011 box Wed away Phillies Cliff Lee - L Reds Dontrelle Willis - L 3-0 3 W -5.0 U 8-6 0-0 3-0 -180 8.0 9
Sep 05, 2011 box Mon home Phillies Cliff Lee - L Braves Derek Lowe - R 9-0 9 W 2.0 O 11-5 0-1 9-0 -215 7.0 9
Sep 10, 2011 box Sat away Phillies Cliff Lee - L Brewers Randy Wolf - L 3-2 1 W -2.0 U 12-7 1-1 1-1 -150 7.0 10+
Sep 15, 2011 box Thu home Phillies Cliff Lee - L Marlins Alex Sanabia - R 2-1 1 W -4.0 U 8-5 0-0 1-0 -340 7.0 10+
Aug 05, 2012 box Sun home Phillies Cliff Lee - L Diamondbacks Trevor Cahill - R 5-4 1 W 1.5 O 12-9 1-1 1-3 -140 7.5 9
Sep 01, 2012 box Sat away Phillies Cliff Lee - L Braves Tim Hudson - R 5-1 4 W -1.0 U 10-7 1-0 5-0 100 7.0 9
Sep 07, 2012 box Fri home Phillies Cliff Lee - L Rockies Jeff Francis - L 3-2 1 W -2.0 U 10-8 1-0 1-2 -210 7.0 9
Sep 12, 2012 box Wed home Phillies Cliff Lee - L Marlins Josh Johnson - R 3-1 2 W -3.0 U 4-4 2-0 2-1 -160 7.0 9
Sep 17, 2012 box Mon away Phillies Cliff Lee - L Mets RA Dickey - R 3-1 2 W -2.5 U 6-7 0-1 2-0 -115 6.5 9
Sep 23, 2012 box Sun home Phillies Cliff Lee - L Braves Tim Hudson - R 1-2 -1 L -4.0 U 2-9 2-1 0-2 -160 7.0 9
Apr 09, 2013 box Tue home Phillies Cliff Lee - L Mets Dillon Gee - R 8-3 5 W 4.0 O 11-8 1-2 7-0 -180 7.0 9
May 17, 2013 box Fri home Phillies Cliff Lee - L Reds Tony Cingrani - L 5-3 2 W 1.0 O 6-8 0-1 3-0 -115 7.0 9
May 28, 2013 box Tue away Phillies Cliff Lee - L Red Sox Ryan Dempster - R 3-1 2 W -4.0 U 9-4 0-0 2-0 120 8.0 9
Jun 02, 2013 box Sun home Phillies Cliff Lee - L Brewers Mike Fiers - R 7-5 2 W 4.0 O 9-10 1-1 7-0 -180 8.0 9
Jun 07, 2013 box Fri away Phillies Cliff Lee - L Brewers Alfredo Figaro - R 4-5 -1 L 1.0 O 7-11 2-0 4-1 -140 8.0 9
Jun 18, 2013 box Tue home Phillies Cliff Lee - L Nationals Ross Detwiler - L 4-2 2 W -1.0 U 9-6 0-0 3-1 -162 7.0 9
Aug 31, 2013 box Sat away Phillies Cliff Lee - L Cubs Christopher Rusin - L 3-4 -1 L 0.0 P 6-11 2-1 1-1 -140 7.0 9
Sep 22, 2013 box Sun home Phillies Cliff Lee - L Mets Carlos Torres - R 3-4 -1 L 0.0 P 9-11 1-0 1-2 -200 7.0 9
Apr 10, 2014 box Thu home Phillies Cliff Lee - L Brewers Marco Estrada - R 2-6 -4 L 0.5 O 6-11 1-0 1-4 -120 7.5 9
Apr 26, 2014 box Sat away Phillies Cliff Lee - L Diamondbacks Bronson Arroyo - R 6-5 1 W 2.5 O 13-10 1-3 1-5 -135 8.5 9
May 02, 2014 box Fri home Phillies Cliff Lee - L Nationals Stephen Strasburg - R 3-5 -2 L 1.5 O 8-10 1-1 3-2 -110 6.5 9
Jul 21, 2014 box Mon home Phillies Cliff Lee - L Giants Ryan Vogelsong - R 4-7 -3 L 4.0 O 14-15 0-1 1-3 -130 7.0 9

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, batting order, 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).