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 7-0 since Sep 16, 2016 at home off a road game off a loss
SU: 128-124 (-0.02, 50.8%)   avg line: -102.6 / -108.7   on / against: +$288 / -$1,619   ROI: +0.9% / -5.2%
RL: 122-130 (-0.08, 48.4%)   avg line: -110.9 / -108.2   on / against: -$2,142 / +$150   ROI: -6.7% / +0.5%
OU: 107-136-9 (0.03, 44.0%)   avg total: 9.8   over / under: -$4,125 / +$1,836   ROI: -14.9% / +6.6%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.91 3.12 8.71 9.14 1.98 1.19 2.60 1.21 4.11 13.78 6.62 0.94 2.99 4.33
Opp 4.93 3.37 8.15 9.04 2.12 1.20 2.66 1.26 3.47 14.32 6.80 1.00 3.28 4.41
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 14, 2017 box Thu away Rockies Chad Bettis - R Diamondbacks Zack Godley - R 0-7 -7 L -2.5 U 5-9 0-0 0-7 165 9.5 9
Sep 15, 2017 box Fri home Rockies Tyler Chatwood - R Padres Clayton Richard - L 6-1 5 W -5.0 U 9-7 2-0 5-0 -165 12.0 9
Sep 16, 2017 box Sat home Rockies Tyler Anderson - L Padres Jordan Lyles - R 16-0 16 W 4.0 O 17-3 0-0 16-0 -200 12.0 9
Sep 17, 2017 box Sun home Rockies Jon Gray - R Padres Jhoulys Chacin - R 3-4 -1 L -4.5 U 9-8 1-1 3-1 -205 11.5 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 23, 2017 box Sat away Rockies Chad Bettis - R Padres Jhoulys Chacin - R 0-5 -5 L -3.5 U 5-12 1-1 0-5 -103 8.5 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
Sep 25, 2017 box Mon home Rockies Tyler Chatwood - R Marlins Odrisamer Despaigne - R 4-5 -1 L -2.5 U 9-10 12-0 0-4 -160 11.5 9
Sep 26, 2017 box Tue home Rockies Tyler Anderson - L Marlins Jose Urena - R 6-0 6 W -5.0 U 12-5 0-0 6-0 -160 11.0 9
Sep 27, 2017 box Wed home Rockies Jon Gray - R Marlins Adam Conley - L 15-9 6 W 12.5 O 14-14 0-2 11-0 -200 11.5 9
Sep 29, 2017 box Fri home Rockies Chad Bettis - R Dodgers Hyun Jin Ryu - L 9-1 8 W -1.0 U 11-6 0-1 8-0 125 11.0 9
Sep 30, 2017 box Sat home Rockies German Marquez - R Dodgers Clayton Kershaw - L 3-5 -2 L -1.5 U 11-8 0-2 3-2 190 9.5 9
Oct 01, 2017 box Sun home Rockies Kyle Freeland - L Dodgers Ross Stripling - R 3-6 -3 L -2.0 U 10-10 0-0 0-5 140 11.0 9
Oct 04, 2017 box Wed away Rockies Jon Gray - R Diamondbacks Zack Greinke - R 8-11 -3 L 10.5 O 13-17 0-0 0-6 165 8.5 9
Mar 29, 2018 box Thu away Rockies Jon Gray - R Diamondbacks Patrick Corbin - L 2-8 -6 L 1.5 O 9-12 0-0 1-6 102 8.5 9
Mar 30, 2018 box Fri away Rockies Tyler Anderson - L Diamondbacks Robbie Ray - L 8-9 -1 L 8.5 O 10-8 0-1 0-5 140 8.5 9
Mar 31, 2018 box Sat away Rockies German Marquez - R Diamondbacks Zack Greinke - R 2-1 1 W -5.5 U 6-5 1-0 1-1 130 8.5 9
Apr 02, 2018 box Mon away Rockies Chad Bettis - R Padres Bryan Mitchell - R 7-4 3 W 2.5 O 12-8 0-1 5-0 -108 8.5 9
Apr 03, 2018 box Tue away Rockies Kyle Freeland - L Padres Tyson Ross - R 4-8 -4 L 3.5 O 6-8 0-0 2-5 -105 8.5 9
Apr 04, 2018 box Wed away Rockies Jon Gray - R Padres Clayton Richard - L 5-2 3 W 0.0 P 9-6 1-0 5-0 -127 7.0 9
Apr 05, 2018 box Thu away Rockies Tyler Anderson - L Padres Joey Lucchesi - L 3-1 2 W -3.5 U 4-6 0-3 3-0 -110 7.5 9
Apr 06, 2018 box Fri home Rockies German Marquez - R Braves Brandon McCarthy - R 3-8 -5 L 1.5 O 7-11 0-0 0-5 -145 9.5 9
Apr 07, 2018 box Sat home Rockies Chad Bettis - R Braves Anibal Sanchez - R 3-2 1 W -6.0 U 10-8 1-0 2-0 -138 11.0 10+
Apr 08, 2018 box Sun home Rockies Kyle Freeland - L Braves Sean Newcomb - L 0-4 -4 L -7.5 U 6-8 0-0 0-4 -140 11.5 9
Apr 09, 2018 box Mon home Rockies Jon Gray - R Padres Clayton Richard - L 6-7 -1 L 3.0 O 7-13 0-1 0-5 -180 10.0 9
Apr 10, 2018 box Tue home Rockies Tyler Anderson - L Padres Joey Lucchesi - L 2-5 -3 L -3.5 U 5-10 0-1 2-3 -160 10.5 9
Apr 11, 2018 box Wed home Rockies German Marquez - R Padres Luis Perdomo - R 6-4 2 W -1.5 U 9-6 0-2 5-0 -155 11.5 9
Apr 12, 2018 box Thu away Rockies Chad Bettis - R Nationals Gio Gonzalez - L 5-1 4 W -2.5 U 9-4 0-1 4-0 163 8.5 9
Apr 13, 2018 box Fri away Rockies Kyle Freeland - L Nationals Tanner Roark - R 2-1 1 W -5.5 U 5-4 0-1 1-0 155 8.5 9
Apr 14, 2018 box Sat away Rockies Jon Gray - R Nationals Max Scherzer - R 2-6 -4 L 0.5 O 2-12 1-0 2-4 180 7.5 9
Apr 15, 2018 box Sun away Rockies Tyler Anderson - L Nationals Stephen Strasburg - R 6-5 1 W 3.5 O 6-5 1-0 1-2 175 7.5 9
Apr 16, 2018 box Mon away Rockies German Marquez - R Pirates Steven Brault - L 6-2 4 W -0.5 U 7-4 1-0 5-0 110 8.5 9
Apr 17, 2018 box Tue away Rockies Chad Bettis - R Pirates Trevor Williams - R 2-0 2 W -6.0 U 5-5 0-0 2-0 125 8.0 9
Apr 18, 2018 box Wed away Rockies Kyle Freeland - L Pirates Chad Kuhl - R 2-10 -8 L 3.5 O 7-13 0-0 1-8 113 8.5 9
Apr 20, 2018 box Fri home Rockies Jon Gray - R Cubs Kyle Hendricks - R 5-16 -11 L 11.0 O 11-18 2-0 1-12 -105 10.0 9
Apr 21, 2018 box Sat home Rockies Tyler Anderson - L Cubs Yu Darvish - R 5-2 3 W -2.5 U 5-6 0-0 3-2 118 9.5 9
Apr 22, 2018 box Sun home Rockies German Marquez - R Cubs Jose Quintana - L 7-9 -2 L 5.5 O 12-13 0-2 0-6 120 10.5 9
Apr 23, 2018 box Mon home Rockies Chad Bettis - R Padres Bryan Mitchell - R 5-13 -8 L 6.5 O 9-16 0-1 1-8 -165 11.5 9
Apr 24, 2018 box Tue home Rockies Kyle Freeland - L Padres Eric Lauer - L 8-0 8 W -3.0 U 9-4 0-1 8-0 -150 11.0 9
Apr 25, 2018 box Wed home Rockies Jon Gray - R Padres Tyson Ross - R 5-2 3 W -3.0 U 10-4 0-0 4-0 -165 10.0 9
Apr 27, 2018 box Fri away Rockies Tyler Anderson - L Marlins Jose Urena - R 1-0 1 W -7.0 U 7-6 0-0 1-0 -135 8.0 9
Apr 28, 2018 box Sat away Rockies German Marquez - R Marlins Wei Yin Chen - L 1-4 -3 L -3.0 U 4-8 2-0 0-3 -108 8.0 9
Apr 29, 2018 box Sun away Rockies Chad Bettis - R Marlins Caleb Smith - L 0-3 -3 L -4.5 U 4-5 0-0 0-3 -113 7.5 9
Apr 30, 2018 box Mon away Rockies Kyle Freeland - L Cubs Jon Lester - L 2-3 -1 L -4.5 U 7-6 1-2 1-1 170 9.5 9
May 01, 2018 box Tue away Rockies Jon Gray - R Cubs Kyle Hendricks - R 3-1 2 W -6.5 U 4-3 0-0 2-0 145 10.5 9
May 02, 2018 box Wed away Rockies Tyler Anderson - L Cubs Yu Darvish - R 11-2 9 W 2.5 O 15-4 2-2 9-0 177 10.5 9
May 04, 2018 box Fri away Rockies German Marquez - R Mets Zack Wheeler - R 8-7 1 W 6.5 O 11-12 1-0 6-0 105 8.5 9
May 05, 2018 box Sat away Rockies Chad Bettis - R Mets Steven Matz - L 2-0 2 W -6.0 U 6-6 0-0 2-0 115 8.0 9
May 06, 2018 box Sun away Rockies Kyle Freeland - L Mets Noah Syndergaard - R 3-2 1 W -1.5 U 8-5 0-1 3-0 170 6.5 10+
May 08, 2018 box Tue home Rockies Jon Gray - R Angels Andrew Heaney - L 4-2 2 W -4.5 U 7-6 0-0 4-0 -130 10.5 9
May 09, 2018 box Wed home Rockies Tyler Anderson - L Angels Jaime Barria - R 0-8 -8 L -3.5 U 8-12 0-0 0-8 -135 11.5 9
May 10, 2018 box Thu home Rockies German Marquez - R Brewers Jhoulys Chacin - R 2-5 -3 L -4.5 U 5-12 0-1 0-4 -148 11.5 9
May 11, 2018 box Fri home Rockies Chad Bettis - R Brewers Brandon Woodruff - R 10-11 -1 L 9.5 O 16-17 0-0 6-2 -120 11.5 10+
May 12, 2018 box Sat home Rockies Kyle Freeland - L Brewers Brent Suter - L 4-0 4 W -7.0 U 9-5 1-0 4-0 -126 11.0 9
May 13, 2018 box Sun home Rockies Jon Gray - R Brewers Freddy Peralta - R 3-7 -4 L -0.5 U 6-13 0-1 0-7 -150 10.5 9
May 14, 2018 box Mon away Rockies Tyler Anderson - L Padres Joey Lucchesi - L 6-4 2 W 3.0 O 11-8 1-0 3-1 -105 7.0 9
May 15, 2018 box Tue away Rockies German Marquez - R Padres Jordan Lyles - R 0-4 -4 L -3.5 U 1-8 0-0 0-4 -105 7.5 9
May 17, 2018 box Thu away Rockies Chad Bettis - R Giants Jeff Samardzija - R 5-3 2 W 0.0 P 9-7 0-1 3-0 118 8.0 10+
May 18, 2018 box Fri away Rockies Kyle Freeland - L Giants Derek Holland - L 6-1 5 W -1.5 U 10-5 0-0 5-1 100 8.5 9
May 19, 2018 box Sat away Rockies Jon Gray - R Giants Chris Stratton - R 4-9 -5 L 5.0 O 9-17 0-1 2-5 -110 8.0 9
May 20, 2018 box Sun away Rockies Tyler Anderson - L Giants Ty Blach - L 5-9 -4 L 6.0 O 13-13 0-1 3-4 -105 8.0 9
May 21, 2018 box Mon away Rockies German Marquez - R Dodgers Walker Buehler - R 2-1 1 W -4.0 U 3-3 1-3 1-1 166 7.0 9
May 22, 2018 box Tue away Rockies Chad Bettis - R Dodgers Brock Stewart - R 3-5 -2 L 0.0 P 7-6 0-1 1-2 130 8.0 9
May 23, 2018 box Wed away Rockies Kyle Freeland - L Dodgers Kenta Maeda - R 0-3 -3 L -4.5 U 4-6 0-0 0-3 170 7.5 9
May 25, 2018 box Fri home Rockies Jon Gray - R Reds Sal Romano - R 5-4 1 W -2.0 U 8-8 0-0 1-3 -200 11.0 9
May 26, 2018 box Sat home Rockies Tyler Anderson - L Reds Tyler Mahle - R 5-6 -1 L -0.5 U 11-11 0-0 1-2 -150 11.5 9
May 27, 2018 box Sun home Rockies German Marquez - R Reds Matt Harvey - R 8-2 6 W -2.0 U 14-9 0-0 7-1 -160 12.0 9
May 28, 2018 box Mon home Rockies Chad Bettis - R Giants Andrew Suarez - L 6-5 1 W -0.5 U 11-12 1-3 1-2 -118 11.5 10+
May 29, 2018 box Tue home Rockies Kyle Freeland - L Giants Jeff Samardzija - R 11-4 7 W 3.5 O 15-12 0-4 7-0 -145 11.5 9
May 30, 2018 box Wed home Rockies Jon Gray - R Giants Derek Holland - L 4-7 -3 L 0.0 P 11-11 0-0 3-3 -165 11.0 9
Jun 01, 2018 box Fri home Rockies Tyler Anderson - L Dodgers Scott Alexander - L 8-11 -3 L 7.5 O 13-12 0-0 2-4 -105 11.5 9
Jun 02, 2018 box Sat home Rockies German Marquez - R Dodgers Walker Buehler - R 4-12 -8 L 5.5 O 10-13 0-0 2-8 130 10.5 9
Jun 03, 2018 box Sun home Rockies Chad Bettis - R Dodgers Alex Wood - L 7-10 -3 L 5.5 O 8-11 1-2 5-3 135 11.5 9
Jun 05, 2018 box Tue away Rockies Kyle Freeland - L Reds Anthony DeSclafani - R 9-6 3 W 6.0 O 12-17 0-0 8-0 -113 9.0 9
Jun 06, 2018 box Wed away Rockies Jon Gray - R Reds Sal Romano - R 6-3 3 W 0.5 O 8-11 1-1 3-1 -133 8.5 9
Jun 07, 2018 box Thu away Rockies Tyler Anderson - L Reds Tyler Mahle - R 5-7 -2 L 3.0 O 13-10 0-1 3-2 -104 9.0 10+
Jun 08, 2018 box Fri home Rockies German Marquez - R Diamondbacks Zack Greinke - R 4-9 -5 L 2.0 O 10-12 0-1 0-5 -105 11.0 9
Jun 09, 2018 box Sat home Rockies Chad Bettis - R Diamondbacks Matt Koch - R 7-12 -5 L 6.0 O 9-13 2-1 2-5 -140 13.0 9
Jun 10, 2018 box Sun home Rockies Kyle Freeland - L Diamondbacks Zack Godley - R 3-8 -5 L -0.5 U 8-10 0-0 0-6 -145 11.5 9
Jun 12, 2018 box Tue away Rockies Jon Gray - R Phillies Aaron Nola - R 4-5 -1 L 1.5 O 11-4 1-1 0-4 140 7.5 9
Jun 13, 2018 box Wed away Rockies Tyler Anderson - L Phillies Nick Pivetta - R 7-2 5 W 0.5 O 11-7 0-0 6-0 125 8.5 9
Jun 14, 2018 box Thu away Rockies German Marquez - R Phillies Vince Velasquez - R 3-9 -6 L 3.5 O 3-13 0-0 0-6 111 8.5 9
Jun 15, 2018 box Fri away Rockies Chad Bettis - R Rangers Yohander Mendez - L 9-5 4 W 3.0 O 13-6 0-0 4-5 -106 11.0 9
Jun 16, 2018 box Sat away Rockies Kyle Freeland - L Rangers Mike Minor - L 2-5 -3 L -2.5 U 5-10 0-0 2-3 -107 9.5 9
Jun 17, 2018 box Sun away Rockies Jon Gray - R Rangers Yovani Gallardo - R 12-13 -1 L 14.5 O 15-10 2-0 4-1 -120 10.5 9
Jun 18, 2018 box Mon home Rockies Tyler Anderson - L Mets Jacob deGrom - R 2-12 -10 L 4.5 O 5-15 0-1 0-10 110 9.5 9
Jun 19, 2018 box Tue home Rockies German Marquez - R Mets Jason Vargas - L 10-8 2 W 6.5 O 16-9 2-1 7-1 -160 11.5 9
Jun 20, 2018 box Wed home Rockies Chad Bettis - R Mets Seth Lugo - R -115 11.5
Jun 21, 2018 box Thu home Rockies Kyle Freeland - L Mets Steven Matz - L
Jun 22, 2018 box Fri home Rockies Jon Gray - R Marlins Wei Yin Chen - L
Jun 23, 2018 box Sat home Rockies Marlins
Jun 24, 2018 box Sun home Rockies Marlins
Jun 26, 2018 box Tue away Rockies Giants
Jun 27, 2018 box Wed away Rockies Giants
Jun 28, 2018 box Thu away Rockies Giants
Jun 29, 2018 box Fri away Rockies Dodgers
Jun 30, 2018 box Sat away Rockies Dodgers

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).