Winning picks from SDQL masters.
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 69-88-8 AGAINST since Apr 05, 2017 on the road
SU: 97-96 (-0.05, 50.3%)   avg line: 121.2 / -132.7   on / against: +$1,955 / -$3,048   ROI: +9.5% / -11.6%
RL: 110-83 (0.58, 57.0%)   avg line: -135.2 / 114.9   on / against: +$402 / -$1,870   ROI: +1.4% / -8.3%
OU: 82-100-11 (0.04, 45.1%)   avg total: 8.3   over / under: -$2,775 / +$953   ROI: -13.1% / +4.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.13 2.95 9.53 8.10 1.70 1.07 2.32 1.04 3.60 13.59 6.46 0.74 2.73 4.21
Opp 4.18 3.28 8.16 8.05 1.70 1.11 2.38 1.06 3.62 13.76 6.55 0.87 2.77 4.38
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
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
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 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 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 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 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 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 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 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 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 Godley - 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
Oct 01, 2018 box Mon away Rockies German Marquez - R Dodgers Walker Buehler - R 2-5 -3 L 0.0 P 4-9 0-0 0-5 160 7.0 9
Oct 02, 2018 box Tue away Rockies Kyle Freeland - L Cubs Jon Lester - L 2-1 1 W -4.0 U 11-6 1-0 1-0 125 7.0 10+
Oct 04, 2018 box Thu away Rockies Antonio Senzatela - R Brewers Brandon Woodruff - R 2-3 -1 L -3.5 U 4-7 0-1 0-2 155 8.5 10+
Oct 05, 2018 box Fri away Rockies Tyler Anderson - L Brewers Jhoulys Chacin - R 0-4 -4 L -4.0 U 6-9 0-1 0-4 150 8.0 9
Mar 28, 2019 box Thu away Rockies Kyle Freeland - L Marlins Jose Urena - R 6-3 3 W 1.0 O 9-4 1-2 6-0 -145 8.0 9
Mar 29, 2019 box Fri away Rockies German Marquez - R Marlins Trevor Richards - R 6-1 5 W 0.0 P 11-2 0-0 5-1 -155 7.0 9
Mar 30, 2019 box Sat away Rockies Tyler Anderson - L Marlins Pablo Lopez - R 3-7 -4 L 2.5 O 8-16 1-0 0-4 -130 7.5 9
Mar 31, 2019 box Sun away Rockies Jon Gray - R Marlins Sandy Alcantara - R 0-3 -3 L -4.5 U 5-5 0-0 0-3 -145 7.5 9
Apr 01, 2019 box Mon away Rockies Chad Bettis - R Rays Ryne Stanek - R 1-7 -6 L -0.5 U 6-9 1-0 0-6 145 8.5 9
Apr 02, 2019 box Tue away Rockies Kyle Freeland - L Rays Blake Snell - L 0-4 -4 L -3.0 U 2-8 1-0 0-4 160 7.0 9
Apr 03, 2019 box Wed away Rockies German Marquez - R Rays Charlie Morton - R 1-0 1 W -5.5 U 5-6 1-0 1-0 112 6.5 10+
Apr 11, 2019 box Thu away Rockies Jon Gray - R Giants Jeff Samardzija - R 0-1 -1 L -6.0 U 3-6 0-0 0-1 -110 7.0 9
Apr 12, 2019 box Fri away Rockies Chad Bettis - R Giants Drew Pomeranz - L 2-3 -1 L -3.0 U 11-8 0-2 2-1 130 8.0 10+
Apr 13, 2019 box Sat away Rockies Kyle Freeland - L Giants Madison Bumgarner - L 2-5 -3 L 0.0 P 6-11 0-1 0-3 110 7.0 9
Apr 14, 2019 box Sun away Rockies German Marquez - R Giants Derek Holland - L 4-0 4 W -3.0 U 5-1 0-1 4-0 -107 7.0 9
Apr 15, 2019 box Mon away Rockies Antonio Senzatela - R Padres Joey Lucchesi - L 5-2 3 W -0.5 U 8-8 0-1 4-0 150 7.5 9
Apr 16, 2019 box Tue away Rockies Jon Gray - R Padres Nick Margevicius - L 8-2 6 W 2.5 O 12-5 1-1 7-0 100 7.5 9
Apr 26, 2019 box Fri away Rockies Antonio Senzatela - R Braves Max Fried - L 8-4 4 W 3.0 O 12-10 1-1 5-1 150 9.0 9
Apr 27, 2019 box Sat away Rockies Jon Gray - R Braves Mike Foltynewicz - R 9-5 4 W 5.5 O 9-9 0-0 4-3 100 8.5 9
Apr 28, 2019 box Sun away Rockies Tyler Anderson - L Braves Kevin Gausman - R 7-8 -1 L 5.5 O 9-10 1-1 2-3 155 9.5 9
Apr 29, 2019 box Mon away Rockies Kyle Freeland - L Brewers Matt Garza - R 1-5 -4 L -2.5 U 4-8 0-1 0-5 110 8.5 9
Apr 30, 2019 box Tue away Rockies German Marquez - R Brewers Jhoulys Chacin - R 3-4 -1 L -1.0 U 4-6 0-0 0-4 -110 8.0 9
May 01, 2019 box Wed away Rockies Antonio Senzatela - R Brewers Jacob Barnes - R 11-4 7 W 6.0 O 10-8 0-0 7-1 -105 9.0 9
May 02, 2019 box Thu away Rockies Jon Gray - R Brewers Freddy Peralta - R 11-6 5 W 8.0 O 14-10 0-2 7-0 103 9.0 9
May 14, 2019 box Tue away Rockies Kyle Freeland - L Red Sox Chris Sale - L 5-4 1 W 0.5 O 6-9 2-0 1-3 200 8.5 10+
May 15, 2019 box Wed away Rockies German Marquez - R Red Sox Eduardo Rodriguez - L 5-6 -1 L 2.0 O 11-13 0-0 0-5 138 9.0 10+
May 17, 2019 box Fri away Rockies Jon Gray - R Phillies Cole Irvin - L 4-5 -1 L 0.0 P 5-8 0-2 2-3 115 9.0 9
May 18, 2019 box Sat away Rockies Antonio Senzatela - R Phillies Aaron Nola - R 1-2 -1 L -6.5 U 9-6 2-0 0-2 162 9.5 9
May 19, 2019 box Sun away Rockies Kyle Freeland - L Phillies Jerad Eickhoff - R 5-7 -2 L 2.0 O 7-9 1-1 2-2 130 10.0 9
May 21, 2019 box Tue away Rockies German Marquez - R Pirates Chris Archer - R 5-0 5 W -2.5 U 10-3 1-1 5-0 -120 7.5 9
May 22, 2019 box Wed away Rockies Jon Gray - R Pirates Montana DuRapau - R 9-3 6 W 3.5 O 16-8 0-0 7-0 -120 8.5 9
May 23, 2019 box Thu away Rockies Antonio Senzatela - R Pirates Jordan Lyles - R 6-14 -8 L 11.0 O 11-15 1-1 0-8 120 9.0 9
Jun 04, 2019 Tue away Rockies Cubs
Jun 05, 2019 Wed away Rockies Cubs
Jun 06, 2019 Thu away Rockies Cubs
Jun 07, 2019 Fri away Rockies Mets
Jun 08, 2019 Sat away Rockies Mets
Jun 09, 2019 Sun away Rockies Mets
Jun 18, 2019 Tue away Rockies Diamondbacks
Jun 19, 2019 Wed away Rockies Diamondbacks
Jun 20, 2019 Thu away Rockies Diamondbacks
Jun 21, 2019 Fri 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).