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

The Phillies are 16-30-1 AGAINST since Sep 17, 2012 as a road favorite
SU: 26-22 (0.38, 54.2%)   avg line: -127.9 / 117.8   on / against: -$243 / +$17   ROI: -4.0% / +0.4%
RL: 19-29 (-0.88, 39.6%)   avg line: 120.5 / -133.1   on / against: -$573 / +$347   ROI: -11.0% / +5.2%
OU: 16-31-1 (-0.61, 34.0%)   avg total: 7.5   over / under: -$1,752 / +$1,300   ROI: -33.7% / +24.2%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 3.65 2.52 6.79 8.67 1.67 0.81 2.08 0.81 3.31 14.56 7.21 1.02 2.35 3.56
Opp 3.27 2.69 7.56 8.12 1.75 0.50 2.04 0.77 3.23 13.56 6.71 1.02 2.25 4.60
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
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 19, 2012 box Wed away Phillies Cole Hamels - L Mets Matt Harvey - R 3-2 1 W -2.0 U 3-9 0-0 1-1 -130 7.0 9
Sep 20, 2012 box Thu away Phillies Tyler Cloyd - R Mets Jeremy Hefner - R 16-1 15 W 9.0 O 21-3 0-0 15-0 -125 8.0 9
Sep 28, 2012 box Fri away Phillies Cliff Lee - L Marlins Mark Buehrle - L 1-2 -1 L -4.0 U 7-6 0-0 0-1 -150 7.0 9
Sep 29, 2012 box Sat away Phillies Roy Halladay - R Marlins Ricky Nolasco - R 9-5 4 W 6.0 O 15-10 1-1 4-3 -130 8.0 9
Sep 30, 2012 box Sun away Phillies Cole Hamels - L Marlins Nathan Eovaldi - R 4-1 3 W -2.5 U 9-7 2-0 3-0 -165 7.5 9
Oct 03, 2012 box Wed away Phillies Cliff Lee - L Nationals Edwin Jackson - R 1-5 -4 L -1.5 U 6-11 0-0 1-4 -110 7.5 9
Apr 12, 2013 box Fri away Phillies John Lannan - L Marlins Ricky Nolasco - R 3-1 2 W -3.5 U 10-4 0-1 2-0 -120 7.5 10+
Apr 13, 2013 box Sat away Phillies Cole Hamels - L Marlins Jose Fernandez - R 1-2 -1 L -4.0 U 5-5 0-2 0-1 -142 7.0 9
Apr 14, 2013 box Sun away Phillies Roy Halladay - R Marlins Kevin Slowey - R 2-1 1 W -4.5 U 12-5 0-0 1-0 -137 7.5 9
Apr 15, 2013 box Mon away Phillies Cliff Lee - L Reds Bronson Arroyo - R 2-4 -2 L -1.5 U 5-9 1-0 0-2 -122 7.5 9
Apr 28, 2013 box Sun away Phillies Cole Hamels - L Mets Jon Niese - L 5-1 4 W -1.0 U 10-3 0-2 4-1 -110 7.0 9
Apr 30, 2013 box Tue away Phillies Roy Halladay - R Indians Zach McAllister - R 2-14 -12 L 8.0 O 5-17 0-0 0-12 -110 8.0 9
May 01, 2013 box Wed away Phillies Cliff Lee - L Indians Trevor Bauer - R 0-6 -6 L -1.5 U 3-14 1-0 0-6 -132 7.5 9
May 20, 2013 box Mon away Phillies Cole Hamels - L Marlins Alex Sanabia - R 1-5 -4 L -1.0 U 7-11 2-0 0-4 -168 7.0 9
May 21, 2013 box Tue away Phillies Tyler Cloyd - R Marlins Jose Fernandez - R 7-3 4 W 3.0 O 15-10 0-1 5-0 -110 7.0 9
May 22, 2013 box Wed away Phillies Cliff Lee - L Marlins Kevin Slowey - R 3-0 3 W -3.5 U 12-3 0-1 3-0 -167 6.5 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 11, 2013 box Tue away Phillies Cole Hamels - L Twins PJ Walters - R 2-3 -1 L -3.0 U 7-9 0-1 1-1 -120 8.0 9
Jun 13, 2013 box Thu away Phillies Cliff Lee - L Twins Kevin Correia - R 3-2 1 W -2.5 U 16-3 0-2 1-1 -135 7.5 9
Jun 24, 2013 box Mon away Phillies Cliff Lee - L Padres Eric Stults - L 3-4 -1 L 0.5 O 11-10 0-2 3-1 -115 6.5 10+
Jun 26, 2013 box Wed away Phillies Cole Hamels - L Padres Robbie Erlin - L 7-5 2 W 4.5 O 10-9 1-3 2-3 -120 7.5 10+
Jul 20, 2013 box Sat away Phillies Cole Hamels - L Mets Zack Wheeler - R 4-5 -1 L 1.0 O 10-9 0-1 1-3 -130 8.0 9
Aug 10, 2013 box Sat away Phillies Cliff Lee - L Nationals Taylor Jordan - R 5-8 -3 L 5.5 O 8-11 0-1 4-4 -107 7.5 9
Aug 26, 2013 box Mon away Phillies Cliff Lee - L Mets Zack Wheeler - R 2-1 1 W -4.0 U 6-5 0-0 1-1 -133 7.0 9
Aug 28, 2013 box Wed away Phillies Cole Hamels - L Mets Daisuke Matsuzaka - R 6-2 4 W 0.5 O 12-9 0-3 4-1 -155 7.5 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 25, 2013 box Wed away Phillies Cole Hamels - L Marlins Brad Hand - L 2-3 -1 L -2.0 U 10-6 1-0 0-2 -155 7.0 9
Apr 05, 2014 box Sat away Phillies Cliff Lee - L Cubs Jeff Samardzija - R 2-0 2 W -4.5 U 7-10 0-0 2-0 -118 6.5 9
Apr 06, 2014 box Sun away Phillies AJ Burnett - R Cubs Carlos Villanueva - R 3-8 -5 L 3.5 O 8-6 1-1 0-7 -125 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 22, 2014 box Thu away Phillies Cole Hamels - L Marlins Henderson Alvarez - R 3-4 -1 L -0.5 U 8-10 0-2 0-3 -110 7.5 9
Jul 02, 2014 box Wed away Phillies Cole Hamels - L Marlins Tom Koehler - R 0-5 -5 L -2.0 U 5-9 0-0 0-5 -118 7.0 9
Jul 29, 2014 box Tue away Phillies Cole Hamels - L Mets Dillon Gee - R 6-0 6 W -1.0 U 7-7 0-1 6-0 -120 7.0 9
Sep 17, 2014 box Wed away Phillies Cole Hamels - L Padres Eric Stults - L 5-2 3 W 0.5 O 9-9 0-1 4-1 -140 6.5 9
Sep 23, 2014 box Tue away Phillies Cole Hamels - L Marlins Henderson Alvarez - R 0-2 -2 L -4.5 U 8-7 0-0 0-2 -135 6.5 9
May 18, 2015 box Mon away Phillies Cole Hamels - L Rockies Jordan Lyles - R 4-3 1 W -2.0 U 10-10 1-1 3-0 -110 9.0 9
May 08, 2016 box Sun away Phillies Aaron Nola - R Marlins Justin Nicolino - L 6-5 1 W 3.5 O 10-10 1-1 1-3 -117 7.5 9
May 11, 2016 box Wed away Phillies Jerad Eickhoff - R Braves Williams Perez - R 1-5 -4 L -1.5 U 4-10 3-0 0-4 -117 7.5 9
May 12, 2016 box Thu away Phillies Vince Velasquez - R Braves Aaron Blair - R 7-4 3 W 4.0 O 10-7 1-1 4-0 -128 7.0 10+
Jul 28, 2016 box Thu away Phillies Aaron Nola - R Braves Matt Wisler - R 7-5 2 W 4.0 O 10-13 0-1 7-0 -123 8.0 9
Jul 29, 2016 box Fri away Phillies Vince Velasquez - R Braves Tyrell Jenkins - R 1-2 -1 L -5.0 U 5-9 1-1 1-1 -147 8.0 9
Jul 31, 2016 box Sun away Phillies Jerad Eickhoff - R Braves Joel De La Cruz - R 1-2 -1 L -5.0 U 5-6 0-1 0-2 -130 8.0 9
Aug 24, 2016 box Wed away Phillies Jerad Eickhoff - R White Sox James Shields - R 5-3 2 W -1.5 U 10-7 0-0 4-0 -107 9.5 9
Sep 05, 2016 box Mon away Phillies Jerad Eickhoff - R Marlins Jake Esch - R 6-2 4 W -0.5 U 8-6 0-3 4-2 -110 8.5 9
May 21, 2017 box Sun away Phillies Aaron Nola - R Pirates Chad Kuhl - R 0-1 -1 L -7.5 U 3-5 0-1 0-1 -120 8.5 9
Jun 06, 2017 box Tue away Phillies Aaron Nola - R Braves Jaime Garcia - L 3-1 2 W -4.5 U 9-7 0-0 2-1 -107 8.5 9
Jul 18, 2017 box Tue away Phillies Vince Velasquez - R Marlins Adam Conley - L 5-2 3 W -2.0 U 13-5 1-0 3-1 -128 9.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, 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).