Winning Picks, Guaranteed
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 9-11 AGAINST since Aug 15, 2017 as a home favorite
SU: 47-31 (1.44, 60.3%)   avg line: -158.3 / 146.6   on / against: -$8 / -$324   ROI: -0.1% / -4.2%
RL: 37-40 (-0.14, 48.1%)   avg line: 118.2 / -137.9   on / against: +$260 / -$945   ROI: +3.3% / -8.9%
OU: 27-50-1 (-0.79, 35.1%)   avg total: 11.2   over / under: -$2,711 / +$1,967   ROI: -32.2% / +22.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.91 3.44 7.72 9.87 2.41 1.53 2.85 1.50 4.73 13.95 6.72 1.06 2.65 4.45
Opp 4.47 3.06 9.03 9.17 2.14 1.09 2.51 1.13 2.77 14.21 6.96 1.19 3.54 4.62
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 15, 2017 box Tue home Rockies Kyle Freeland - L Braves Sean Newcomb - L 3-4 -1 L -4.0 U 6-6 1-0 1-1 -170 11.0 9
Aug 16, 2017 box Wed home Rockies Jon Gray - R Braves Mike Foltynewicz - R 17-2 15 W 7.5 O 18-7 0-0 15-0 -185 11.5 9
Aug 17, 2017 box Thu home Rockies Jeff Hoffman - R Braves Lucas Sims - R 4-10 -6 L 2.0 O 9-12 0-1 1-8 -175 12.0 9
Aug 18, 2017 box Fri home Rockies German Marquez - R Brewers Matt Garza - R 8-4 4 W -0.5 U 9-9 1-1 6-1 -175 12.5 9
Aug 19, 2017 box Sat home Rockies Chad Bettis - R Brewers Brandon Woodruff - R 3-6 -3 L -3.5 U 11-10 0-0 0-3 -140 12.5 9
Aug 20, 2017 box Sun home Rockies Kyle Freeland - L Brewers Chase Anderson - R 4-8 -4 L -0.5 U 8-12 4-0 1-6 -120 12.5 9
Aug 28, 2017 box Mon home Rockies Antonio Senzatela - R Tigers Jordan Zimmermann - R 3-4 -1 L -5.5 U 13-9 0-0 1-2 -190 12.5 9
Aug 29, 2017 box Tue home Rockies German Marquez - R Tigers Michael Fulmer - R 7-3 4 W -1.0 U 9-7 0-0 4-0 -180 11.0 9
Aug 30, 2017 box Wed home Rockies Chad Bettis - R Tigers Justin Verlander - R 2-6 -4 L -3.5 U 6-11 0-0 0-5 -140 11.5 9
Sep 02, 2017 box Sat home Rockies Jon Gray - R Diamondbacks Patrick Corbin - L 2-6 -4 L -3.5 U 4-8 1-1 0-4 -115 11.5 9
Sep 03, 2017 box Sun home Rockies German Marquez - R Diamondbacks Zack Godley - R 1-5 -4 L -5.5 U 5-9 1-0 0-4 -110 11.5 9
Sep 04, 2017 box Mon home Rockies Chad Bettis - R Giants Chris Stratton - R 4-3 1 W -5.0 U 9-7 0-1 1-2 -170 12.0 9
Sep 05, 2017 box Tue home Rockies Tyler Chatwood - R Giants Ty Blach - L 9-6 3 W 3.0 O 13-12 0-0 5-0 -185 12.0 9
Sep 06, 2017 box Wed home Rockies Kyle Freeland - L Giants Johnny Cueto - R 3-11 -8 L 2.0 O 8-17 1-1 0-8 -180 12.0 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 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
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 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
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 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 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 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 10-8 2 W 6.5 O 12-13 0-2 2-3 -110 11.5 9
Jun 21, 2018 box Thu home Rockies Kyle Freeland - L Mets Steven Matz - L 6-4 2 W -1.0 U 9-11 0-0 4-1 -158 11.0 9
Jun 22, 2018 box Fri home Rockies Jon Gray - R Marlins Wei Yin Chen - L 11-3 8 W 2.5 O 15-10 1-1 9-0 -220 11.5 9
Jun 23, 2018 box Sat home Rockies Tyler Anderson - L Marlins Trevor Richards - R 2-6 -4 L -3.5 U 4-9 0-0 0-5 -210 11.5 9
Jun 24, 2018 box Sun home Rockies German Marquez - R Marlins Caleb Smith - L 5-8 -3 L 2.0 O 6-12 2-0 0-3 -165 11.0 9
Jul 03, 2018 box Tue home Rockies Antonio Senzatela - R Giants Chris Stratton - R 8-1 7 W -3.5 U 12-6 0-1 8-0 -135 12.5 9
Jul 04, 2018 box Wed home Rockies Tyler Anderson - L Giants Andrew Suarez - L 1-0 1 W -9.5 U 7-3 0-0 1-0 -125 10.5 9
Jul 11, 2018 box Wed home Rockies German Marquez - R Diamondbacks Shelby Miller - R 19-2 17 W 9.0 O 19-6 0-0 18-1 -130 12.0 9
Jul 13, 2018 box Fri home Rockies Jeff Hoffman - R Mariners Christian Bergman - R 10-7 3 W 4.0 O 14-12 1-0 7-2 -150 13.0 9
Jul 14, 2018 box Sat home Rockies Jon Gray - R Mariners Wade LeBlanc - L 4-1 3 W -7.0 U 10-5 0-0 4-0 -170 12.0 9
Jul 15, 2018 box Sun home Rockies Tyler Anderson - L Mariners Mike Leake - R 4-3 1 W -4.0 U 9-9 0-1 1-2 -155 11.0 9
Jul 27, 2018 box Fri home Rockies Kyle Freeland - L Athletics Sean Manaea - L 3-1 2 W -7.5 U 10-9 1-0 3-0 -115 11.5 9
Jul 28, 2018 box Sat home Rockies Antonio Senzatela - R Athletics Brett Anderson - L 4-1 3 W -6.0 U 10-6 0-0 3-1 -125 11.0 9
Jul 29, 2018 box Sun home Rockies German Marquez - R Athletics Frankie Montas - R 3-2 1 W -6.5 U 8-5 0-0 3-0 -135 11.5 9
Aug 06, 2018 box Mon home Rockies Kyle Freeland - L Pirates Joe Musgrove - R 2-0 2 W -8.5 U 5-2 0-1 2-0 -140 10.5 9
Aug 08, 2018 box Wed home Rockies German Marquez - R Pirates Chris Archer - R 3-4 -1 L -2.5 U 9-11 2-0 0-3 -120 9.5 9
Aug 21, 2018 box Tue home Rockies Tyler Anderson - L Padres Robbie Erlin - L 3-4 -1 L -3.0 U 7-11 1-2 0-3 -170 10.0 9
Aug 22, 2018 box Wed home Rockies Jon Gray - R Padres Jacob Nix - R 6-2 4 W -2.5 U 10-5 0-1 4-1 -240 10.5 9
Aug 23, 2018 box Thu home Rockies Kyle Freeland - L Padres Joey Lucchesi - L 4-3 1 W -3.0 U 7-9 1-0 1-1 -190 10.0 9
Aug 25, 2018 box Sat home Rockies German Marquez - R Cardinals John Gant - R 9-1 8 W -1.0 U 13-5 0-2 8-0 -155 11.0 9
Aug 26, 2018 box Sun home Rockies Tyler Anderson - L Cardinals Austin Gomber - L 3-12 -9 L 3.5 O 7-16 2-1 0-10 -135 11.5 9
Sep 03, 2018 box Mon home Rockies Tyler Anderson - L Giants Madison Bumgarner - L 9-8 1 W 7.0 O 11-11 2-1 5-1 -140 10.0 9
Sep 04, 2018 box Tue home Rockies German Marquez - R Giants Dereck Rodriguez - R 6-2 4 W -1.5 U 10-8 0-0 4-1 -195 9.5 9
Sep 05, 2018 box Wed home Rockies Antonio Senzatela - R Giants Andrew Suarez - L 5-3 2 W -2.5 U 7-9 0-0 2-1 -152 10.5 9
Sep 10, 2018 box Mon home Rockies German Marquez - R Diamondbacks Zack Godley - R 13-2 11 W 5.0 O 17-8 1-1 11-1 -140 10.0 9
Sep 13, 2018 box Thu home Rockies Kyle Freeland - L Diamondbacks Matt Koch - R 10-3 7 W 3.0 O 16-7 1-0 7-0 -190 10.0 9
Sep 24, 2018 box Mon home Rockies Jon Gray - R Phillies Zach Eflin - R 10-1 9 W 0.5 O 13-5 0-1 9-0 -185 10.5 9
Sep 25, 2018 box Tue home Rockies Chad Bettis - R Phillies Vince Velasquez - R 10-3 7 W 2.0 O 14-10 1-1 7-1 -155 11.0 9
Sep 26, 2018 box Wed home Rockies German Marquez - R Phillies Nick Pivetta - R 14-0 14 W 3.5 O 16-4 1-0 14-0 -200 10.5 9
Sep 27, 2018 box Thu home Rockies Antonio Senzatela - R Phillies Jake Arrieta - R 5-3 2 W -3.0 U 9-8 0-1 4-0 -175 11.0 9
Sep 28, 2018 box Fri home Rockies Kyle Freeland - L Nationals Joe Ross - R 5-2 3 W -3.5 U 8-12 0-0 3-1 -200 10.5 9
Sep 29, 2018 box Sat home Rockies Jon Gray - R Nationals Stephen Strasburg - R 2-12 -10 L 4.0 O 5-18 1-1 0-10 -110 10.0 9
Sep 30, 2018 box Sun home Rockies Tyler Anderson - L Nationals Erick Fedde - R 12-0 12 W 1.0 O 13-5 0-0 12-0 -190 11.0 9
Oct 07, 2018 box Sun home Rockies German Marquez - R Brewers Wade Miley - L 0-6 -6 L -3.5 U 4-12 0-0 0-6 -150 9.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, 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).