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 Rockies are 53-59 AGAINST since Sep 13, 2009 as a road favorite
SU: 53-59 (0.21, 47.3%)   avg line: -126.4 / 116.2   on / against: -$2,133 / +$1,543   ROI: -15.1% / +13.8%
RL: 40-71 (-1.21, 36.0%)   avg line: 132.4 / -145.3   on / against: -$1,826 / +$1,282   ROI: -16.2% / +7.9%
OU: 41-63-7 (-0.32, 39.4%)   avg total: 8.2   over / under: -$2,787 / +$1,777   ROI: -23.0% / +14.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.01 3.25 7.81 8.54 1.74 0.94 2.22 1.06 3.62 14.20 7.12 0.99 2.71 3.92
Opp 3.79 3.40 8.16 7.61 1.76 0.80 2.22 0.95 3.27 13.42 6.52 0.83 2.80 4.15
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
May 09, 2010 box Sun away Rockies Ubaldo Jimenez - R Dodgers Clayton Kershaw - L 0-2 -2 L -5.0 U 4-3 0-0 0-2 -120 7.0 9
May 20, 2010 box Thu away Rockies Ubaldo Jimenez - R Astros Roy Oswalt - R 4-0 4 W -2.0 U 6-3 0-2 4-0 -145 6.0 9
May 21, 2010 box Fri away Rockies Jason Hammel - R Royals Brian Bannister - R 2-9 -7 L 1.5 O 8-10 0-0 0-7 -115 9.5 9
May 22, 2010 box Sat away Rockies Jeff Francis - L Royals Kyle Davies - R 3-0 3 W -6.0 U 8-6 0-0 3-0 -120 9.0 9
Jun 05, 2010 box Sat away Rockies Jhoulys Chacin - R Diamondbacks Dontrelle Willis - L 3-4 -1 L -3.0 U 8-7 2-0 0-4 -120 10.0 9
Jun 06, 2010 box Sun away Rockies Ubaldo Jimenez - R Diamondbacks Rodrigo Lopez - R 3-2 1 W -3.5 U 10-7 1-1 3-0 -210 8.5 9
Jun 17, 2010 box Thu away Rockies Ubaldo Jimenez - R Twins Francisco Liriano - L 5-1 4 W -0.5 U 8-8 0-0 5-0 -115 6.5 9
Jun 28, 2010 box Mon away Rockies Ubaldo Jimenez - R Padres Kevin Correia - R 10-6 4 W 9.5 O 13-8 0-1 8-0 -150 6.5 9
Jul 19, 2010 box Mon away Rockies Ubaldo Jimenez - R Marlins Anibal Sanchez - R 8-9 -1 L 10.0 O 11-11 2-2 2-3 -150 7.0 9
Jul 20, 2010 box Tue away Rockies Jeff Francis - L Marlins Nate Robertson - L 10-0 10 W 0.5 O 9-3 0-1 10-0 -115 9.5 9
Jul 24, 2010 box Sat away Rockies Ubaldo Jimenez - R Phillies Kyle Kendrick - R 2-10 -8 L 4.0 O 8-11 1-0 0-9 -150 8.0 9
Aug 05, 2010 box Thu away Rockies Jeff Francis - L Pirates James McDonald - R 1-5 -4 L -2.5 U 7-11 0-0 0-5 -155 8.5 9
Aug 06, 2010 box Fri away Rockies Jason Hammel - R Pirates Zach Duke - L 6-3 3 W 0.5 O 15-6 1-1 3-0 -135 8.5 9
Aug 07, 2010 box Sat away Rockies Jorge De La Rosa - L Pirates Ross Ohlendorf - R 7-8 -1 L 7.0 O 9-14 0-2 2-3 -140 8.0 10+
Aug 10, 2010 box Tue away Rockies Ubaldo Jimenez - R Mets Mike Pelfrey - R 0-1 -1 L -6.0 U 4-4 0-0 0-1 -155 7.0 9
Aug 21, 2010 box Sat away Rockies Ubaldo Jimenez - R Diamondbacks Barry Enright - R 1-3 -2 L -4.0 U 4-4 0-1 1-2 -165 8.0 9
Sep 01, 2010 box Wed away Rockies Ubaldo Jimenez - R Giants Tim Lincecum - R 1-2 -1 L -3.5 U 5-4 2-1 1-1 -120 6.5 9
Sep 17, 2010 box Fri away Rockies Ubaldo Jimenez - R Dodgers Hiroki Kuroda - R 7-5 2 W 6.0 O 11-11 1-1 3-0 -135 6.0 9
Sep 18, 2010 box Sat away Rockies Jhoulys Chacin - R Dodgers John Ely - R 12-2 10 W 6.0 O 14-12 1-1 12-0 -130 8.0 9
Sep 21, 2010 box Tue away Rockies Jorge De La Rosa - L Diamondbacks Joe Saunders - L 1-3 -2 L -5.5 U 6-6 1-0 0-3 -145 9.5 9
Sep 22, 2010 box Wed away Rockies Ubaldo Jimenez - R Diamondbacks Rodrigo Lopez - R 4-8 -4 L 3.0 O 7-9 0-0 4-4 -185 9.0 9
Oct 02, 2010 box Sat away Rockies Ubaldo Jimenez - R Cardinals Kyle Lohse - R 0-1 -1 L -7.0 U 5-4 3-2 0-1 -170 8.0 10+
Apr 08, 2011 box Fri away Rockies Jorge De La Rosa - L Pirates Ross Ohlendorf - R 3-4 -1 L -1.0 U 9-8 1-2 3-1 -135 8.0 10+
Apr 10, 2011 box Sun away Rockies Jhoulys Chacin - R Pirates James McDonald - R 6-5 1 W 3.5 O 8-7 2-0 4-1 -125 7.5 9
Apr 14, 2011 box Thu away Rockies Jorge De La Rosa - L Mets Chris Capuano - L 9-4 5 W 5.0 O 13-5 1-0 5-2 -110 8.0 9
Apr 22, 2011 box Fri away Rockies Jhoulys Chacin - R Marlins Anibal Sanchez - R 1-4 -3 L -3.5 U 1-9 0-1 1-3 -110 8.5 9
Apr 23, 2011 box Sat away Rockies Jason Hammel - R Marlins Javier Vazquez - R 3-1 2 W -4.5 U 6-7 0-1 2-0 -110 8.5 9
Apr 26, 2011 box Tue away Rockies Jorge De La Rosa - L Cubs James Russell - L 4-3 1 W -4.5 U 9-8 1-0 2-1 -136 11.5 9
May 03, 2011 box Tue away Rockies Jorge De La Rosa - L Diamondbacks Joe Saunders - L 3-4 -1 L -2.5 U 9-8 0-0 1-2 -130 9.5 9
May 04, 2011 box Wed away Rockies Jhoulys Chacin - R Diamondbacks Barry Enright - R 6-4 2 W 0.5 O 9-6 0-0 5-1 -126 9.5 9
May 08, 2011 box Sun away Rockies Jorge De La Rosa - L Giants Ryan Vogelsong - R 0-3 -3 L -4.5 U 3-5 1-1 0-3 -123 7.5 9
May 19, 2011 box Thu away Rockies Jhoulys Chacin - R Phillies Kyle Kendrick - R 7-1 6 W 0.0 P 15-6 0-1 6-0 -130 8.0 9
May 22, 2011 box Sun away Rockies Ubaldo Jimenez - R Brewers Randy Wolf - L 1-3 -2 L -3.5 U 4-2 1-0 1-2 -125 7.5 9
Jun 01, 2011 box Wed away Rockies Ubaldo Jimenez - R Dodgers Jon Garland - R 3-0 3 W -4.0 U 8-4 0-1 3-0 -115 7.0 9
Jun 04, 2011 box Sat away Rockies Jhoulys Chacin - R Giants Madison Bumgarner - L 2-1 1 W -4.0 U 9-4 0-1 2-0 -110 7.0 9
Jun 06, 2011 box Mon away Rockies Clayton Mortensen - R Padres Clayton Richard - L 3-0 3 W -3.5 U 9-9 0-0 3-0 -113 6.5 9
Jun 07, 2011 box Tue away Rockies Ubaldo Jimenez - R Padres Tim Stauffer - R 0-2 -2 L -4.0 U 5-6 0-0 0-2 -149 6.0 9
Jun 08, 2011 box Wed away Rockies Aaron Cook - R Padres Dustin Moseley - R 5-3 2 W 1.0 O 12-9 0-1 2-1 -109 7.0 9
Jun 21, 2011 box Tue away Rockies Jhoulys Chacin - R Indians Mitch Talbot - R 4-3 1 W -1.5 U 11-7 0-0 3-0 -127 8.5 9
Jun 27, 2011 box Mon away Rockies Jhoulys Chacin - R Cubs Matt Garza - R 3-7 -4 L -1.5 U 6-10 0-2 1-5 -120 11.5 9
Jul 09, 2011 box Sat away Rockies Ubaldo Jimenez - R Nationals Jason Marquis - R 2-1 1 W -4.5 U 6-7 0-0 2-0 -115 7.5 9
Jul 24, 2011 box Sun away Rockies Ubaldo Jimenez - R Diamondbacks Micah Owings - R 0-7 -7 L -2.0 U 5-11 0-0 0-7 -134 9.0 9
Jul 30, 2011 box Sat away Rockies Ubaldo Jimenez - R Padres Aaron Harang - R 10-6 4 W 9.5 O 12-4 2-1 5-2 -130 6.5 9
Jul 31, 2011 box Sun away Rockies Juan Nicasio - R Padres Wade LeBlanc - L 3-8 -5 L 4.0 O 10-10 2-0 2-5 -110 7.0 9
Apr 06, 2012 box Fri away Rockies Jeremy Guthrie - R Astros Wandy Rodriguez - L 5-3 2 W 0.0 P 8-5 0-4 2-1 -120 8.0 9
Apr 07, 2012 box Sat away Rockies Jamie Moyer - L Astros Lucas Harrell - R 3-7 -4 L 1.0 O 7-10 3-0 0-6 -118 9.0 9
Apr 08, 2012 box Sun away Rockies Juan Nicasio - R Astros Bud Norris - R 2-3 -1 L -3.0 U 5-8 1-0 2-1 -134 8.0 9
Apr 25, 2012 box Wed away Rockies Juan Nicasio - R Pirates James McDonald - R 2-1 1 W -4.0 U 3-9 0-0 1-0 -120 7.0 9
Apr 25, 2012 box Wed away Rockies Jhoulys Chacin - R Pirates Charlie Morton - R 1-5 -4 L -1.5 U 6-11 0-0 0-5 -120 7.5 9
May 08, 2012 box Tue away Rockies Alex White - R Padres Jeff Suppan - R 1-3 -2 L -3.0 U 9-7 1-1 1-2 -115 7.0 9
Jul 22, 2012 box Sun away Rockies Christian Friedrich - L Padres Ross Ohlendorf - R 2-3 -1 L -2.5 U 5-6 1-0 1-1 -110 7.5 9
Aug 26, 2012 box Sun away Rockies Jhoulys Chacin - R Cubs Chris Volstad - R 0-5 -5 L 4-9 2-0 0-5 -110 9
Apr 13, 2013 box Sat away Rockies Jhoulys Chacin - R Padres Edinson Volquez - R 9-5 4 W 7.0 O 14-10 0-2 7-0 -110 7.0 9
Apr 14, 2013 box Sun away Rockies Jorge De La Rosa - L Padres Clayton Richard - L 2-1 1 W -5.0 U 3-2 0-0 2-0 -110 8.0 9
May 27, 2013 box Mon away Rockies Jhoulys Chacin - R Astros Bud Norris - R 2-3 -1 L -3.5 U 13-9 3-0 2-1 -142 8.5 10+
May 28, 2013 box Tue away Rockies Jorge De La Rosa - L Astros Jordan Lyles - R 2-1 1 W -6.0 U 8-5 0-1 1-0 -165 9.0 9
Aug 20, 2013 box Tue away Rockies Jorge De La Rosa - L Phillies Tyler Cloyd - R 5-3 2 W -0.5 U 10-3 1-0 5-0 -110 8.5 9
Aug 23, 2013 box Fri away Rockies Jhoulys Chacin - R Marlins Tom Koehler - R 3-2 1 W -2.5 U 9-4 0-0 1-1 -137 7.5 9
Aug 25, 2013 box Sun away Rockies Jorge De La Rosa - L Marlins Jacob Turner - R 4-3 1 W -0.5 U 7-5 1-2 3-0 -110 7.5 9
Apr 01, 2014 box Tue away Rockies Brett Anderson - L Marlins Nathan Eovaldi - R 3-4 -1 L 0.0 P 9-5 1-0 0-2 -110 7.0 9
Apr 03, 2014 box Thu away Rockies Franklin Morales - L Marlins Jacob Turner - R 5-8 -3 L 5.5 O 10-13 1-1 3-3 -110 7.5 9
Apr 29, 2014 box Tue away Rockies Tyler Chatwood - R Diamondbacks Michael Bolsinger - ? 5-4 1 W 0.0 P 11-10 1-0 1-2 -108 9.0 9
May 02, 2016 box Mon away Rockies Jon Gray - R Padres James Shields - R 1-2 -1 L -4.0 U 9-6 0-0 0-2 -113 7.0 9
May 04, 2016 box Wed away Rockies Tyler Chatwood - R Padres Cesar Vargas - R 2-0 2 W -5.5 U 8-3 0-1 2-0 -123 7.5 9
Jun 04, 2016 box Sat away Rockies Chad Bettis - R Padres Andrew Cashner - R 3-4 -1 L -1.0 U 9-12 0-1 1-2 -107 8.0 9
Jun 05, 2016 box Sun away Rockies Jon Gray - R Padres Luis Perdomo - R 10-3 7 W 4.5 O 10-6 0-2 8-0 -146 8.5 9
Jul 15, 2016 box Fri away Rockies Jorge De La Rosa - L Braves Lucas Harrell - R 11-2 9 W 4.5 O 10-9 0-2 9-0 -115 8.5 9
Jul 16, 2016 box Sat away Rockies Chad Bettis - R Braves Mike Foltynewicz - R 4-3 1 W -1.0 U 8-7 0-2 1-3 -116 8.0 9
Aug 12, 2016 box Fri away Rockies Jon Gray - R Phillies Jake Thompson - R 6-10 -4 L 7.5 O 8-11 3-1 0-6 -140 8.5 9
Aug 13, 2016 box Sat away Rockies Tyler Anderson - L Phillies Jerad Eickhoff - R 3-6 -3 L 1.0 O 13-6 0-0 0-4 -118 8.0 9
Aug 14, 2016 box Sun away Rockies Tyler Chatwood - R Phillies Adam Morgan - L 6-7 -1 L 4.0 O 12-10 4-1 0-4 -110 9.0 9
Aug 22, 2016 box Mon away Rockies Chad Bettis - R Brewers Jimmy Nelson - R 2-4 -2 L -3.0 U 7-4 2-0 1-3 -108 9.0 9
Aug 23, 2016 box Tue away Rockies Jon Gray - R Brewers Chase Anderson - R 4-6 -2 L 1.0 O 11-8 0-0 2-2 -120 9.0 9
Aug 24, 2016 box Wed away Rockies Tyler Anderson - L Brewers Zach Davies - R 1-7 -6 L -0.5 U 6-10 0-1 1-6 -106 8.5 9
Sep 09, 2016 box Fri away Rockies Tyler Chatwood - R Padres Luis Perdomo - R 4-1 3 W -3.0 U 9-5 0-0 3-1 -116 8.0 9
Sep 10, 2016 box Sat away Rockies Jon Gray - R Padres Christian Friedrich - L 3-6 -3 L 1.0 O 4-8 1-1 0-6 -125 8.0 9
Sep 11, 2016 box Sun away Rockies Chad Bettis - R Padres Edwin Jackson - R 3-2 1 W -4.0 U 7-5 0-0 2-0 -125 9.0 10+
Sep 12, 2016 box Mon away Rockies Tyler Anderson - L Diamondbacks Shelby Miller - R 9-12 -3 L 11.5 O 15-16 1-0 3-5 -135 9.5 9
Apr 03, 2017 box Mon away Rockies Jon Gray - R Brewers Junior Guerra - R 7-5 2 W 4.0 O 10-7 0-3 4-1 -124 8.0 9
Apr 05, 2017 box Wed away Rockies Tyler Chatwood - R Brewers Wily Peralta - R 1-6 -5 L -2.0 U 5-10 0-0 0-6 -117 9.0 9
May 03, 2017 box Wed away Rockies Antonio Senzatela - R Padres Jered Weaver - R 11-3 8 W 6.0 O 14-7 1-3 9-0 -120 8.0 9
May 23, 2017 box Tue away Rockies German Marquez - R Phillies Zach Eflin - R 8-2 6 W 1.5 O 10-8 0-0 7-0 -135 8.5 9
May 24, 2017 box Wed away Rockies Tyler Chatwood - R Phillies Jeremy Hellickson - R 7-2 5 W 0.0 P 12-3 0-1 7-0 -120 9.0 9
May 25, 2017 box Thu away Rockies Tyler Anderson - L Phillies Vince Velasquez - R 1-2 -1 L -5.5 U 10-8 0-0 1-1 -112 8.5 10+
Jun 02, 2017 box Fri away Rockies German Marquez - R Padres Clayton Richard - L 5-8 -3 L 5.5 O 13-14 0-1 3-3 -115 7.5 9
Jun 03, 2017 box Sat away Rockies Tyler Chatwood - R Padres Jhoulys Chacin - R 10-1 9 W 3.0 O 13-4 0-1 9-0 -106 8.0 9
Jun 04, 2017 box Sun away Rockies Jeff Hoffman - R Padres Jarred Cosart - R 3-1 2 W -4.5 U 9-3 0-0 3-0 -130 8.5 9
Jun 14, 2017 box Wed away Rockies German Marquez - R Pirates Chad Kuhl - R 5-1 4 W -2.5 U 8-6 0-1 4-0 -115 8.5 9
Jun 27, 2017 box Tue away Rockies Jeff Hoffman - R Giants Matt Cain - R 3-4 -1 L -1.5 U 10-12 0-0 2-1 -128 8.5 10+
Jun 28, 2017 box Wed away Rockies Kyle Freeland - L Giants Ty Blach - L 3-5 -2 L -0.5 U 8-7 1-2 2-2 -115 8.5 9
Jul 30, 2017 box Sun away Rockies Jon Gray - R Nationals Edwin Jackson - R 10-6 4 W 7.0 O 16-13 1-2 5-0 -109 9.0 9
Aug 11, 2017 box Fri away Rockies Jon Gray - R Marlins Jose Urena - R 3-6 -3 L 0.5 O 7-11 0-0 2-3 -110 8.5 9
Aug 12, 2017 box Sat away Rockies Jeff Hoffman - R Marlins Justin Nicolino - L 3-4 -1 L -2.0 U 9-10 0-2 1-3 -110 9.0 9
Aug 13, 2017 box Sun away Rockies German Marquez - R Marlins Vance Worley - R 3-5 -2 L -0.5 U 10-8 0-0 1-2 -106 8.5 9
Aug 27, 2017 box Sun away Rockies Jon Gray - R Braves Mike Foltynewicz - R 3-0 3 W -6.0 U 8-6 0-2 3-0 -125 9.0 9
Sep 19, 2017 box Tue away Rockies German Marquez - R Giants Johnny Cueto - R 3-4 -1 L -0.5 U 10-12 0-0 2-1 -113 7.5 9
Sep 20, 2017 box Wed away Rockies Tyler Chatwood - R Giants Matt Moore - L 0-4 -4 L -4.0 U 6-7 0-0 0-4 -125 8.0 9
Sep 21, 2017 box Thu away Rockies Tyler Anderson - L Padres Clayton Richard - L 0-3 -3 L -5.5 U 7-7 0-1 0-3 -120 8.5 9
Sep 22, 2017 box Fri away Rockies Jon Gray - R Padres Jordan Lyles - R 4-1 3 W -3.0 U 7-7 0-1 3-0 -165 8.0 9
Sep 24, 2017 box Sun away Rockies German Marquez - R Padres Luis Perdomo - R 8-4 4 W 3.5 O 12-8 0-1 4-1 -130 8.5 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).