Information you need to win.
S p o r t s D a t a b a s e . c o m
agile access to sports data


name
password


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

HD and p:XL and 8 <= total <= 10 and rest = 0 and C and league = 'AL'
RL: 47-43 (0.08, 52.2%)   avg line: -132.3 / 119.2   on / against: -$909 / +$408   ROI: -7.5% / +4.4%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.26 3.09 7.35 8.94 2.01 0.98 2.35 1.11 3.09 14.88 7.16 1.04 3.55 3.94
Opp 5.62 3.84 7.13 9.74 2.20 1.30 2.93 1.41 4.15 15.63 7.47 1.01 3.07 3.58
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 28, 2005 box Sun home Rangers Chris Young - R Twins Johan Santana - L 2-1 1 W -5.5 U 6-5 0-1 1-0 150 8.5 9
Aug 30, 2005 box Tue home Royals Jose Lima - R Twins Carlos Silva - R 4-7 -3 L 2.0 O 11-11 1-2 0-5 170 9.0 9
Sep 03, 2005 box Sat home Royals DJ Carrasco - L Rangers Juan Dominguez - R 3-5 -2 L -1.5 U 5-10 0-0 0-5 145 9.5 9
Sep 12, 2005 box Mon home Blue Jays Ted Lilly - L Red Sox Bronson Arroyo - R 5-6 -1 L 1.0 O 8-12 0-1 0-5 135 10.0 10+
Sep 13, 2005 box Tue home Blue Jays Scott Downs - L Red Sox Matt Clement - R 9-3 6 W 2.5 O 9-9 0-2 6-0 140 9.5 9
May 04, 2006 box Thu home Rays Doug Waechter - R Yankees Randy Johnson - L 5-10 -5 L 5.0 O 9-10 1-0 2-5 210 10.0 9
May 31, 2006 box Wed home Tigers Nate Robertson - L Yankees Mike Mussina - R 1-6 -5 L -2.5 U 6-11 0-1 0-6 120 9.5 9
Jul 23, 2006 box Sun home Royals Brandon Duckworth - R Angels Jered Weaver - R 1-3 -2 L -5.0 U 4-5 0-1 0-3 170 9.0 9
Aug 24, 2006 box Thu home Royals Mark Redman - L Indians CC Sabathia - L 4-8 -4 L 2.5 O 12-15 1-2 0-4 160 9.5 9
Sep 16, 2006 box Sat home Rangers Adam Eaton - R Angels John Lackey - R 12-6 6 W 8.5 O 18-14 0-5 8-0 115 9.5 9
May 27, 2007 box Sun home Twins Carlos Silva - R Blue Jays AJ Burnett - R 4-2 2 W -2.5 U 3-6 0-1 3-1 115 8.5 9
Jul 01, 2007 box Sun home Royals John Thomson - R White Sox Jon Garland - R 1-3 -2 L -5.5 U 8-11 1-1 1-2 105 9.5 9
Jul 20, 2007 box Fri home Twins Carlos Silva - R Angels John Lackey - R 7-5 2 W 3.5 O 12-10 3-2 3-2 125 8.5 9
Jul 29, 2007 box Sun home Rays Scott Kazmir - L Red Sox Daisuke Matsuzaka - R 5-2 3 W -1.5 U 12-8 0-0 5-0 145 8.5 9
Aug 24, 2007 box Fri home Tigers Andrew Miller - L Yankees Roger Clemens - R 9-6 3 W 5.0 O 11-10 1-0 3-1 140 10.0 10+
Sep 05, 2007 box Wed home Twins Scott Baker - R Indians Fausto Carmona - R 2-6 -4 L -0.5 U 8-15 0-1 0-4 105 8.5 9
Sep 17, 2007 box Mon home Blue Jays Dustin McGowan - R Red Sox Tim Wakefield - R 6-1 5 W -2.5 U 9-5 0-1 5-0 110 9.5 9
May 26, 2008 box Mon home Indians Paul Byrd - R White Sox Javier Vazquez - R 3-6 -3 L 0.5 O 12-17 0-0 2-3 100 8.5 10+
May 31, 2008 box Sat home Orioles Garrett Olson - L Red Sox Jon Lester - L 3-6 -3 L 0.0 P 9-9 2-0 2-3 120 9.0 9
Jun 01, 2008 box Sun home Twins Nick Blackburn - R Yankees Darrell Rasner - R 5-1 4 W -3.0 U 9-8 0-1 4-0 110 9.0 9
Jun 30, 2008 box Mon home Orioles Brian Burres - L Royals Zack Greinke - R 5-6 -1 L 2.0 O 10-14 1-0 4-1 105 9.0 10+
Jul 09, 2008 box Wed home Royals Brian Bannister - R White Sox Javier Vazquez - R 6-7 -1 L 4.0 O 13-5 0-1 5-1 100 9.0 9
Jul 31, 2008 box Thu home Indians Fausto Carmona - R Tigers Justin Verlander - R 9-4 5 W 4.0 O 8-6 3-2 5-1 130 9.0 9
Aug 10, 2008 box Sun home Mariners RA Dickey - R Rays Edwin Jackson - R 3-11 -8 L 5.0 O 11-13 2-0 0-10 120 9.0 9
Aug 15, 2008 box Fri home Athletics Dallas Braden - L White Sox Gavin Floyd - R 6-4 2 W 1.5 O 10-9 1-2 2-3 105 8.5 9
Aug 26, 2008 box Tue home Tigers Chris Lambert - R Indians Cliff Lee - L 4-10 -6 L 5.5 O 8-10 2-0 0-8 150 8.5 9
Jun 10, 2009 box Wed home White Sox John Danks - L Tigers Justin Verlander - R 1-2 -1 L -5.5 U 6-5 0-0 0-2 125 8.5 9
Jul 20, 2009 box Mon home Athletics Gio Gonzalez - L Twins Nick Blackburn - R 14-13 1 W 18.5 O 22-17 1-1 1-10 120 8.5 9
Jul 26, 2009 box Sun home Blue Jays Brett Cecil - L Rays Jeff Niemann - R 5-1 4 W -3.0 U 10-5 0-0 4-0 100 9.0 9
Jul 29, 2009 box Wed home Orioles Chris Tillman - R Royals Zack Greinke - R 7-3 4 W 1.5 O 10-9 0-0 4-1 130 8.5 9
Aug 02, 2009 box Sun home Indians Carl Pavano - R Tigers Armando Galarraga - R 11-1 10 W 2.5 O 13-6 0-2 11-0 105 9.5 9
Aug 15, 2009 box Sat home Athletics Gio Gonzalez - L White Sox Gavin Floyd - R 1-8 -7 L 0.5 O 11-11 1-0 0-7 100 8.5 9
Sep 06, 2009 box Sun home Royals Luke Hochevar - R Angels Joe Saunders - L 2-7 -5 L -0.5 U 12-11 0-1 0-6 155 9.5 9
Apr 10, 2010 box Sat home White Sox Freddy Garcia - R Twins Scott Baker - R 1-2 -1 L -6.0 U 6-5 0-0 1-1 125 9.0 9
Apr 14, 2010 box Wed home Orioles Bradley Bergesen - R Rays David Price - L 1-9 -8 L 1.0 O 6-11 1-1 0-8 145 9.0 9
Apr 25, 2010 box Sun home Royals Brian Bannister - R Twins Kevin Slowey - R 4-3 1 W -2.0 U 9-12 2-0 2-1 130 9.0 9
Jul 02, 2010 box Fri home Twins Scott Baker - R Rays David Price - L 2-1 1 W -5.0 U 4-9 0-1 1-1 105 8.0 9
Jul 20, 2010 box Tue home Tigers Armando Galarraga - R Rangers Tommy Hunter - R 0-8 -8 L -1.5 U 4-13 0-0 0-8 115 9.5 9
Aug 12, 2010 box Thu home Royals Bruce Chen - L Yankees CC Sabathia - L 3-4 -1 L -2.0 U 12-10 2-0 0-3 200 9.0 9
Aug 31, 2010 box Tue home Indians Justin Masterson - R White Sox Edwin Jackson - R 3-4 -1 L -1.5 U 8-5 1-2 1-3 125 8.5 9
Sep 04, 2010 box Sat home Royals Bruce Chen - L Tigers Rick Porcello - R 4-6 -2 L 1.0 O 9-11 1-0 0-3 105 9.0 9
Sep 12, 2010 box Sun home Indians Mitch Talbot - R Twins Kevin Slowey - R 2-6 -4 L -1.0 U 9-7 1-1 0-5 125 9.0 9
May 19, 2011 box Thu home Orioles Bradley Bergesen - R Yankees CC Sabathia - L 2-13 -11 L 6.5 O 10-14 0-2 0-13 150 8.5 9
May 19, 2011 box Thu home Royals Luke Hochevar - R Rangers Derek Holland - L 2-1 1 W -5.5 U 14-6 0-1 1-1 100 8.5 10+
Jul 18, 2011 box Mon home Rays Alex Cobb - R Yankees AJ Burnett - R 4-5 -1 L 0.0 P 9-8 1-1 3-1 120 9.0 9
Aug 06, 2011 box Sat home Royals Daniel Duffy - L Tigers Justin Verlander - R 3-4 -1 L -1.0 U 5-9 0-1 0-3 170 8.0 9
Aug 15, 2011 box Mon home Angels Garrett Richards - R Rangers Alexi Ogando - R 4-8 -4 L 3.5 O 9-14 3-1 0-7 142 8.5 9
Apr 11, 2012 box Wed home Orioles Jake Arrieta - R Yankees CC Sabathia - L 4-6 -2 L 1.5 O 10-10 1-0 1-2 165 8.5 10+
Apr 15, 2012 box Sun home Royals Luis Mendoza - R Indians Ubaldo Jimenez - R 7-13 -6 L 11.5 O 13-15 1-0 3-8 102 8.5 9
May 06, 2012 box Sun home Indians Ubaldo Jimenez - R Rangers Yu Darvish - R 4-2 2 W -2.5 U 6-6 0-1 4-0 155 8.5 9
Jul 14, 2012 box Sat home Royals Luke Hochevar - R White Sox Jake Peavy - R 6-3 3 W 0.5 O 12-8 0-0 3-1 110 8.5 9
Aug 13, 2012 box Mon home Twins Samuel Deduno - R Tigers Anibal Sanchez - R 9-3 6 W 2.5 O 18-6 0-0 7-0 125 9.5 9
Sep 14, 2012 box Fri home Royals Bruce Chen - L Angels CJ Wilson - L 7-9 -2 L 7.5 O 8-12 1-1 3-2 145 8.5 9
Sep 23, 2012 box Sun home Red Sox Felix Doubront - L Orioles Chris Tillman - R 2-1 1 W -6.0 U 9-6 0-1 1-0 125 9.0 9
May 03, 2013 box Fri home Astros Bud Norris - R Tigers Doug Fister - R 3-4 -1 L -1.0 U 9-6 0-1 1-2 170 8.0 9
May 11, 2013 box Sat home Twins Vance Worley - R Orioles Steve Johnson - R 8-5 3 W 4.5 O 10-12 1-0 3-3 100 8.5 9
May 18, 2013 box Sat home Twins Scott Diamond - L Red Sox Ryan Dempster - R 5-12 -7 L 8.0 O 12-13 0-0 0-7 115 9.0 9
Jun 11, 2013 box Tue home Rays Roberto Hernandez - R Red Sox Jon Lester - L 8-3 5 W 3.0 O 10-8 1-1 5-1 110 8.0 9
Jul 12, 2013 box Fri home Mariners Joe Saunders - L Angels Jerome Williams - R 8-3 5 W 3.0 O 11-9 0-0 8-0 110 8.0 9
Aug 14, 2013 box Wed home Blue Jays Esmil Rogers - R Red Sox Jon Lester - L 4-3 1 W -2.5 U 8-8 1-3 2-0 135 9.5 10+
Aug 21, 2013 box Wed home Angels Jerome Williams - R Indians Justin Masterson - R 1-3 -2 L -4.0 U 7-8 0-0 0-2 140 8.0 9
Sep 06, 2013 box Fri home Yankees Andy Pettitte - L Red Sox Felix Doubront - L 8-12 -4 L 11.0 O 7-15 0-0 5-4 105 9.0 9
Sep 12, 2013 box Thu home Rays Jeremy Hellickson - R Red Sox Jake Peavy - R 4-3 1 W -1.0 U 6-6 0-1 2-0 100 8.0 9
Apr 10, 2014 box Thu home Twins Mike Pelfrey - R Athletics Daniel Straily - R 1-6 -5 L -1.5 U 3-13 0-0 1-5 130 8.5 9
Jun 04, 2014 box Wed home Yankees Vidal Nuno - L Athletics Jesse Chavez - R 4-7 -3 L 2.0 O 9-12 1-2 4-3 133 9.0 9
Jun 07, 2014 box Sat home Orioles Kevin Gausman - R Athletics Sonny Gray - R 6-3 3 W 0.5 O 7-7 1-0 5-0 125 8.5 9
Jun 22, 2014 box Sun home Indians Josh Tomlin - R Tigers Max Scherzer - R 4-10 -6 L 5.5 O 11-12 3-0 0-9 105 8.5 9
Jul 06, 2014 box Sun home White Sox Hector Noesi - R Mariners Taijuan Walker - R 1-0 1 W -8.0 U 2-5 1-0 1-0 115 9.0 9
Sep 19, 2014 box Fri home Astros Brad Peacock - R Mariners Taijuan Walker - R 5-10 -5 L 6.5 O 13-12 2-0 1-7 135 8.5 9
Apr 13, 2015 box Mon home Rangers Ross Detwiler - L Angels Matt Shoemaker - R 3-6 -3 L 0.0 P 7-12 0-1 3-3 125 9.0 9
May 13, 2015 box Wed home Rangers Yovani Gallardo - R Royals Yordano Ventura - R 5-2 3 W -1.0 U 11-6 0-0 5-0 108 8.0 9
Aug 08, 2015 box Sat home Yankees Ivan Nova - R Blue Jays David Price - L 0-6 -6 L -2.0 U 3-7 1-0 0-6 135 8.0 9
Aug 17, 2015 box Mon home Red Sox Matt Barnes - R Indians Danny Salazar - R 2-8 -6 L 1.0 O 6-10 1-0 1-7 125 9.0 9
Sep 09, 2015 box Wed home Red Sox Joe Kelly - R Blue Jays Drew Hutchison - R 10-4 6 W 4.0 O 14-9 0-0 9-0 110 10.0 9
Apr 25, 2016 box Mon home Twins Tommy Milone - L Indians Danny Salazar - R 4-3 1 W -1.0 U 5-12 1-0 1-2 134 8.0 9
May 10, 2016 box Tue home Rangers Derek Holland - L White Sox Carlos Rodon - L 13-11 2 W 14.5 O 17-13 1-0 2-5 100 9.5 9
May 20, 2016 box Fri home Twins Tyler Duffey - R Blue Jays Aaron Sanchez - R 3-9 -6 L 3.5 O 10-14 0-2 1-7 112 8.5 9
May 30, 2016 box Mon home Angels Jhoulys Chacin - R Tigers Justin Verlander - R 5-1 4 W -2.0 U 6-4 0-1 5-0 100 8.0 9
Jun 24, 2016 box Fri home White Sox Carlos Rodon - L Blue Jays Aaron Sanchez - R 3-2 1 W -3.5 U 11-8 0-0 1-1 145 8.5 9
Sep 05, 2016 box Mon home Twins Jose Berrios - R Royals Ian Kennedy - R 5-11 -6 L 6.5 O 12-16 1-0 2-7 125 9.5 9
Sep 06, 2016 box Tue home White Sox Miguel Gonzalez - R Tigers Matt Boyd - L 2-0 2 W -7.5 U 8-7 0-0 2-0 102 9.5 9
Sep 21, 2016 box Wed home Athletics Daniel Mengden - R Astros Collin McHugh - R 5-6 -1 L 2.5 O 7-9 0-1 1-3 150 8.5 9
Apr 17, 2017 box Mon home Twins Kyle Gibson - R Indians Danny Salazar - R 1-3 -2 L -4.5 U 9-9 1-0 1-2 138 8.5 9
May 29, 2017 box Mon home Twins Ervin Santana - R Astros Brad Peacock - R 8-16 -8 L 15.0 O 11-18 1-0 6-8 107 9.0 9
Jul 01, 2017 box Sat home Blue Jays Francisco Liriano - L Red Sox Chris Sale - L 1-7 -6 L -0.5 U 6-12 1-0 0-7 153 8.5 9
Jul 28, 2017 box Fri home Athletics Daniel Gossett - R Twins Jaime Garcia - L 3-6 -3 L 0.0 P 8-11 2-0 0-5 -103 9.0 9
Sep 05, 2017 box Tue home Athletics Kendall Graveman - R Angels Garrett Richards - R 7-8 -1 L 5.5 O 13-9 0-0 1-3 130 9.5 10+
Sep 06, 2017 box Wed home Athletics Sean Manaea - L Angels Tyler Skaggs - L 3-0 3 W -6.5 U 5-5 0-1 3-0 116 9.5 9
Sep 20, 2017 box Wed home Orioles Ubaldo Jimenez - L Red Sox Chris Sale - L 0-9 -9 L 0.5 O 6-10 2-0 0-9 210 8.5 9
Apr 28, 2018 box Sat home Angels Garrett Richards - R Yankees Masahiro Tanaka - R 1-11 -10 L 4.0 O 7-14 1-0 0-10 -102 8.0 9
Jun 12, 2018 box Tue home Orioles David Hess - R Red Sox Eduardo Rodriguez - L 4-6 -2 L 0.5 O 11-9 0-2 1-4 160 9.5 9
Jun 28, 2018 box Thu home Orioles Jimmy Yacobonis - R Mariners Mike Leake - R 2-4 -2 L -4.0 U 6-12 2-0 0-2 133 10.0 10+
Jun 29, 2018 box Fri home Orioles David Hess - R Angels Felix Pena - R 1-7 -6 L -2.0 U 7-13 0-0 0-7 140 10.0 9
Aug 08, 2018 box Wed home Blue Jays Mike Hauschild - R Red Sox Brian Johnson - L 5-10 -5 L 5.5 O 9-12 0-1 0-7 140 9.5 9
Aug 08, 2018 box Wed home White Sox Lucas Giolito - R Yankees Luis Severino - R 3-7 -4 L 1.5 O 9-7 1-0 2-5 240 8.5 9
Aug 25, 2018 box Sat home Orioles Jimmy Yacabonis - R Yankees JA Happ - L 3-10 -7 L 4.0 O 8-11 0-1 1-8 220 9.0 9
Sep 13, 2018 box Thu home Royals Heath Fillmyer - R Twins Stephen Gonsalves - L 6-4 2 W 0.5 O 8-7 0-2 3-2 100 9.5 9
Apr 03, 2019 box Wed home Royals Homer Bailey - R Twins Kyle Gibson - R 6-7 -1 L 4.0 O 9-11 0-1 3-2 135 9.0 9
Apr 19, 2019 box Fri home Rays Ryne Stanek - R Red Sox Eduardo Rodriguez - L 4-6 -2 L 1.5 O 7-10 0-1 2-2 100 8.5 9
May 23, 2019 box Thu home Blue Jays Clayton Richard - L Red Sox Ryan Weber - R 2-8 -6 L 0.0 P 5-15 1-0 1-7 145 10.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).