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 5-9 AGAINST since Sep 17, 2017
SU: 91-79 (0.08, 53.5%)   avg line: -106.5 / -104.7   on / against: +$995 / -$1,812   ROI: +4.8% / -8.8%
RL: 86-83 (-0.02, 50.9%)   avg line: -113.8 / -106.6   on / against: -$532 / -$865   ROI: -2.4% / -4.1%
OU: 67-97-6 (-0.15, 40.9%)   avg total: 9.4   over / under: -$3,816 / +$2,206   ROI: -20.7% / +11.6%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.68 3.14 8.59 8.73 1.93 1.21 2.49 1.20 3.89 14.01 6.62 0.92 2.75 4.26
Opp 4.60 3.20 8.56 8.49 1.97 1.11 2.53 1.14 3.42 13.48 6.45 0.95 2.98 4.42
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
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 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
Jun 26, 2018 box Tue away Rockies Chad Bettis - R Giants Derek Holland - L 2-3 -1 L -3.5 U 9-7 0-0 1-1 135 8.5 9
Jun 27, 2018 box Wed away Rockies Kyle Freeland - L Giants Madison Bumgarner - L 0-1 -1 L -6.0 U 2-5 2-0 0-1 150 7.0 9
Jun 28, 2018 box Thu away Rockies Jon Gray - R Giants Chris Stratton - R 9-8 1 W 9.5 O 14-12 1-1 3-1 -117 7.5 9
Jun 29, 2018 box Fri away Rockies Tyler Anderson - L Dodgers Rich Hill - L 3-1 2 W -3.5 U 9-5 0-0 3-0 145 7.5 9
Jun 30, 2018 box Sat away Rockies German Marquez - R Dodgers Kenta Maeda - R 3-1 2 W -3.5 U 6-3 0-0 2-0 160 7.5 9
Jul 01, 2018 box Sun away Rockies Chad Bettis - R Dodgers Ross Stripling - R 4-6 -2 L 1.5 O 9-11 1-0 2-2 200 8.5 9
Jul 02, 2018 box Mon home Rockies Kyle Freeland - L Giants Madison Bumgarner - L 5-2 3 W -3.5 U 10-5 0-1 3-2 -104 10.5 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 06, 2018 box Fri away Rockies German Marquez - R Mariners Felix Hernandez - R 7-1 6 W 0.0 P 13-8 1-1 6-0 108 8.0 9
Jul 07, 2018 box Sat away Rockies Kyle Freeland - L Mariners James Paxton - L 5-1 4 W -1.0 U 10-7 0-0 4-0 180 7.0 9
Jul 08, 2018 box Sun away Rockies Antonio Senzatela - R Mariners Wade LeBlanc - L 4-6 -2 L 1.5 O 5-7 1-0 1-2 132 8.5 9
Jul 10, 2018 box Tue home Rockies Tyler Anderson - L Diamondbacks Patrick Corbin - L 3-5 -2 L -3.0 U 9-8 0-1 1-3 -105 11.0 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 12, 2018 box Thu home Rockies Kyle Freeland - L Diamondbacks Robbie Ray - L 5-1 4 W -5.0 U 9-7 0-0 4-1 -105 11.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 20, 2018 box Fri away Rockies German Marquez - R Diamondbacks Robbie Ray - L 11-10 1 W 13.5 O 12-14 2-1 3-3 132 7.5 9
Jul 21, 2018 box Sat away Rockies Kyle Freeland - L Diamondbacks Zack Godley - R 6-5 1 W 3.0 O 7-8 0-1 1-3 130 8.0 9
Jul 22, 2018 box Sun away Rockies Antonio Senzatela - R Diamondbacks Zack Greinke - R 1-6 -5 L -0.5 U 3-7 1-0 0-5 165 7.5 9
Jul 24, 2018 box Tue home Rockies Tyler Anderson - L Astros Gerrit Cole - R 2-8 -6 L 0.0 P 6-10 2-1 0-6 135 10.0 10+
Jul 25, 2018 box Wed home Rockies Jon Gray - R Astros Charlie Morton - R 3-2 1 W -4.5 U 8-1 2-0 1-1 115 9.5 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
Jul 30, 2018 box Mon away Rockies Tyler Anderson - L Cardinals Carlos Martinez - R 4-5 -1 L 1.0 O 9-7 0-2 4-1 125 8.0 10+
Jul 31, 2018 box Tue away Rockies Jon Gray - R Cardinals Jack Flaherty - R 6-3 3 W 1.5 O 9-4 1-0 5-1 102 7.5 9
Aug 01, 2018 box Wed away Rockies Kyle Freeland - L Cardinals Luke Weaver - R 3-6 -3 L 1.0 O 7-13 0-0 2-4 135 8.0 9
Aug 02, 2018 box Thu away Rockies Antonio Senzatela - R Cardinals Miles Mikolas - R 2-3 -1 L -3.0 U 7-8 1-1 1-1 132 8.0 9
Aug 03, 2018 box Fri away Rockies German Marquez - R Brewers Junior Guerra - R 3-5 -2 L -0.5 U 6-4 0-0 2-2 115 8.5 9
Aug 04, 2018 box Sat away Rockies Tyler Anderson - L Brewers Freddy Peralta - R 4-8 -4 L 3.5 O 7-10 0-0 0-7 130 8.5 9
Aug 05, 2018 box Sun away Rockies Jon Gray - R Brewers Wade Miley - L 5-4 1 W 0.5 O 7-9 1-2 3-1 -103 8.5 10+
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 07, 2018 box Tue home Rockies Chad Bettis - R Pirates Jameson Taillon - R 2-10 -8 L 1.0 O 10-10 1-0 0-10 110 11.0 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 09, 2018 box Thu home Rockies Tyler Anderson - L Dodgers Ross Stripling - R 5-8 -3 L 2.0 O 10-13 1-0 2-3 120 11.0 9
Aug 10, 2018 box Fri home Rockies Jon Gray - R Dodgers Kenta Maeda - R 5-4 1 W -1.5 U 9-10 0-2 2-1 -105 10.5 9
Aug 11, 2018 box Sat home Rockies Kyle Freeland - L Dodgers Walker Buehler - R 3-2 1 W -6.0 U 6-6 0-1 1-2 121 11.0 9
Aug 12, 2018 box Sun home Rockies Chad Bettis - R Dodgers Rich Hill - L 4-3 1 W -4.5 U 5-7 0-3 3-0 155 11.5 9
Aug 14, 2018 box Tue away Rockies German Marquez - R Astros Justin Verlander - R 5-1 4 W -1.0 U 12-3 1-0 4-1 185 7.0 9
Aug 15, 2018 box Wed away Rockies Tyler Anderson - L Astros Gerrit Cole - R 1-12 -11 L 5.5 O 5-11 0-0 0-11 185 7.5 9
Aug 16, 2018 box Thu away Rockies Jon Gray - R Braves Julio Teheran - R 5-3 2 W -0.5 U 6-6 0-1 2-1 -106 8.5 9
Aug 17, 2018 box Fri away Rockies Kyle Freeland - L Braves Sean Newcomb - L 11-5 6 W 7.5 O 16-9 0-0 9-1 116 8.5 9
Aug 18, 2018 box Sat away Rockies Antonio Senzatela - R Braves Mike Foltynewicz - R 5-3 2 W -0.5 U 12-9 0-0 2-3 140 8.5 10+
Aug 19, 2018 box Sun away Rockies German Marquez - R Braves Anibal Sanchez - R 4-2 2 W -2.0 U 8-6 1-0 2-1 118 8.0 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 24, 2018 box Fri home Rockies Antonio Senzatela - R Cardinals Miles Mikolas - R 5-7 -2 L 1.5 O 15-11 1-1 0-7 115 10.5 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
Aug 27, 2018 box Mon away Rockies Jon Gray - R Angels Odrisamer Despaigne - R 7-10 -3 L 9.0 O 11-10 1-0 2-3 -140 8.0 9
Aug 28, 2018 box Tue away Rockies Kyle Freeland - L Angels Noe Ramirez - R 3-2 1 W -3.5 U 5-6 0-0 2-0 -125 8.5 9
Aug 30, 2018 box Thu away Rockies German Marquez - R Padres Eric Lauer - L 2-3 -1 L -2.5 U 3-6 1-4 0-2 -142 7.5 10+
Aug 31, 2018 box Fri away Rockies Antonio Senzatela - R Padres Brett Kennedy - R 0-7 -7 L -1.5 U 5-11 0-0 0-7 -116 8.5 9
Sep 01, 2018 box Sat away Rockies Jon Gray - R Padres Robbie Erlin - L 4-2 2 W -1.0 U 10-7 0-0 2-1 -155 7.0 9
Sep 02, 2018 box Sun away Rockies Kyle Freeland - L Padres Jacob Nix - R 7-3 4 W 2.0 O 9-7 0-1 4-1 -145 8.0 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 07, 2018 box Fri home Rockies Jon Gray - R Dodgers Clayton Kershaw - L 2-4 -2 L -3.0 U 10-8 1-0 0-2 140 9.0 9
Sep 08, 2018 box Sat home Rockies Kyle Freeland - L Dodgers Walker Buehler - R 4-2 2 W -3.5 U 7-6 0-0 3-0 120 9.5 9
Sep 09, 2018 box Sun home Rockies Tyler Anderson - L Dodgers Rich Hill - L 6-9 -3 L 4.5 O 8-14 1-1 0-6 114 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 11, 2018 box Tue home Rockies Antonio Senzatela - R Diamondbacks Zack Greinke - R 3-6 -3 L -1.5 U 9-10 0-0 0-3 110 10.5 9
Sep 12, 2018 box Wed home Rockies Jon Gray - R Diamondbacks Patrick Corbin - L 5-4 1 W -1.0 U 13-4 0-0 1-3 -105 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 14, 2018 box Fri away Rockies Tyler Anderson - L Giants Chris Stratton - R 0-2 -2 L -5.5 U 2-8 0-0 0-2 -120 7.5 9
Sep 15, 2018 box Sat away Rockies German Marquez - R Giants Madison Bumgarner - L 0-3 -3 L -4.0 U 7-8 0-1 0-3 -135 7.0 9
Sep 16, 2018 box Sun away Rockies Antonio Senzatela - R Giants Dereck Rodriguez - R 3-2 1 W -2.5 U 7-7 0-1 3-0 -120 7.5 9
Sep 17, 2018 box Mon away Rockies Jon Gray - R Dodgers Hyun Jin Ryu - L 2-8 -6 L 2.5 O 6-11 0-0 0-8 145 7.5 9
Sep 18, 2018 box Tue away Rockies Kyle Freeland - L Dodgers Clayton Kershaw - L 2-3 -1 L -2.0 U 4-6 2-2 1-1 200 7.0 10+
Sep 19, 2018 box Wed away Rockies Tyler Anderson - L Dodgers Walker Buehler - R 2-5 -3 L -0.5 U 4-5 0-2 2-3 200 7.5 9
Sep 21, 2018 box Fri away Rockies German Marquez - R Diamondbacks Zack Greinke - R 6-2 4 W 0.5 O 8-8 0-0 4-2 105 7.5 9
Sep 22, 2018 box Sat away Rockies Antonio Senzatela - R Diamondbacks Patrick Corbin - L 5-1 4 W -1.5 U 8-3 0-1 4-0 160 7.5 9
Sep 23, 2018 box Sun away Rockies Kyle Freeland - L Diamondbacks Zack Godley - R 2-0 2 W -6.0 U 7-7 1-0 2-0 -104 8.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 -155 11.0
Sep 26, 2018 box Wed home Rockies German Marquez - R Phillies Nick Pivetta - R
Sep 27, 2018 box Thu home Rockies Antonio Senzatela - R Phillies Jake Arrieta - R
Sep 28, 2018 box Fri home Rockies Nationals
Sep 29, 2018 box Sat home Rockies Nationals
Sep 30, 2018 box Sun home Rockies Nationals

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