Winning picks from SDQL masters.
S p o r t s D a t a b a s e . c o m
agile access to sports data


name
password


MLB Sport Data Query Language Access. SDB Home     MLB Trends     MLB Query
Numerical options: SU | OU | RL | Invested

The Rockies are 34-50-2 AGAINST since Aug 02, 2016 as a home dog.
SU: 39-47 (-0.65, 45.3%)   avg line: 129.1 / -139.8   on / against: +$260 / -$663   ROI: +3.0% / -5.5%
RL: 42-44 (0.85, 48.8%)   avg line: -127.7 / 110.5   on / against: -$1,422 / +$677   ROI: -12.9% / +7.5%
OU: 34-50-2 (-0.10, 40.5%)   avg total: 11.4   over / under: -$2,079 / +$1,370   ROI: -21.8% / +14.6%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.31 3.13 8.12 9.67 2.19 1.26 2.62 1.26 3.24 14.47 6.83 1.05 3.38 4.67
Opp 5.97 3.85 7.94 9.62 2.41 1.56 3.07 1.58 4.20 14.91 7.01 1.09 3.27 4.58
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 02, 2016 box Tue home Rockies Jon Gray - R Dodgers Brandon McCarthy - R 7-3 4 W -0.5 U 11-5 0-1 7-0 120 10.5 9
Aug 04, 2016 box Thu home Rockies Tyler Chatwood - R Dodgers Kenta Maeda - R 2-4 -2 L -4.5 U 5-11 1-0 1-2 150 10.5 9
Aug 05, 2016 box Fri home Rockies Jorge De La Rosa - L Marlins David Phelps - R 3-5 -2 L -3.5 U 11-8 2-1 2-2 105 11.5 9
Aug 08, 2016 box Mon home Rockies Tyler Anderson - L Rangers Cole Hamels - L 3-4 -1 L -3.5 U 8-6 0-0 2-1 108 10.5 9
Aug 15, 2016 box Mon home Rockies Jorge De La Rosa - L Nationals Max Scherzer - R 4-5 -1 L -1.5 U 10-10 0-0 3-1 177 10.5 9
Aug 16, 2016 box Tue home Rockies Chad Bettis - R Nationals Gio Gonzalez - L 6-2 4 W -3.5 U 9-9 0-0 4-2 125 11.5 9
Aug 17, 2016 box Wed home Rockies Jon Gray - R Nationals Stephen Strasburg - R 12-10 2 W 11.5 O 11-13 1-0 7-0 145 10.5 9
Aug 19, 2016 box Fri home Rockies Tyler Anderson - L Cubs Kyle Hendricks - R 7-6 1 W 3.0 O 11-12 0-2 1-4 122 10.0 10+
Aug 20, 2016 box Sat home Rockies Jeff Hoffman - R Cubs Mike Montgomery - L 2-9 -7 L -1.0 U 5-15 2-0 0-7 135 12.0 9
Aug 21, 2016 box Sun home Rockies Jorge De La Rosa - L Cubs Jason Hammel - R 11-4 7 W 2.0 O 14-7 0-4 10-0 150 13.0 9
Aug 29, 2016 box Mon home Rockies Jon Gray - R Dodgers Kenta Maeda - R 8-1 7 W -1.0 U 12-5 1-0 8-0 115 10.0 9
Aug 31, 2016 box Wed home Rockies Jeff Hoffman - R Dodgers Bud Norris - R 8-10 -2 L 6.5 O 12-10 1-2 6-2 135 11.5 9
Sep 02, 2016 box Fri home Rockies Jorge De La Rosa - L Diamondbacks Robbie Ray - L 14-7 7 W 9.5 O 14-10 2-2 7-5 115 11.5 9
Sep 05, 2016 box Mon home Rockies Chad Bettis - R Giants Matt Moore - L 6-0 6 W -6.0 U 6-2 0-0 6-0 101 12.0 9
Sep 19, 2016 box Mon home Rockies Tyler Anderson - L Cardinals Carlos Martinez - R 3-5 -2 L -3.0 U 8-11 1-0 1-3 105 11.0 9
Sep 20, 2016 box Tue home Rockies Jorge De La Rosa - L Cardinals Adam Wainwright - R 5-10 -5 L 3.0 O 12-14 1-0 1-6 120 12.0 9
Sep 21, 2016 box Wed home Rockies German Marquez - R Cardinals Luke Weaver - R 11-1 10 W -0.5 U 12-8 0-2 10-0 123 12.5 9
Apr 07, 2017 box Fri home Rockies Kyle Freeland - L Dodgers Hyun Jin Ryu - L 2-1 1 W -9.0 U 6-5 0-2 1-0 132 12.0 9
Apr 08, 2017 box Sat home Rockies Jon Gray - R Dodgers Clayton Kershaw - L 4-2 2 W -3.0 U 9-7 0-0 3-0 190 9.0 9
Apr 09, 2017 box Sun home Rockies Tyler Anderson - L Dodgers Kenta Maeda - R 6-10 -4 L 6.0 O 9-15 2-1 0-6 115 10.0 9
Apr 21, 2017 box Fri home Rockies Tyler Chatwood - R Giants Johnny Cueto - R 6-5 1 W 1.0 O 9-11 0-0 3-3 110 10.0 9
Apr 25, 2017 box Tue home Rockies German Marquez - R Nationals Joe Ross - R 12-15 -3 L 16.0 O 15-14 2-0 0-10 106 11.0 9
Apr 27, 2017 box Thu home Rockies Antonio Senzatela - R Nationals Gio Gonzalez - L 5-16 -11 L 10.0 O 10-19 1-1 1-14 110 11.0 9
May 05, 2017 box Fri home Rockies German Marquez - R Diamondbacks Zack Greinke - R 3-6 -3 L -1.5 U 9-8 0-0 0-5 -102 10.5 9
May 09, 2017 box Tue home Rockies Antonio Senzatela - R Cubs Jake Arrieta - R 10-4 6 W 3.5 O 15-8 0-1 8-1 125 10.5 9
May 09, 2017 box Tue home Rockies Kyle Freeland - L Cubs John Lackey - R 1-8 -7 L -1.5 U 6-8 2-1 0-7 132 10.5 9
May 10, 2017 box Wed home Rockies German Marquez - R Cubs Kyle Hendricks - R 3-0 3 W -7.0 U 6-3 0-1 3-0 120 10.0 9
May 11, 2017 box Thu home Rockies Tyler Anderson - R Dodgers Hyun Jin Ryu - L 10-7 3 W 6.5 O 12-14 0-1 10-0 105 10.5 9
May 12, 2017 box Fri home Rockies Tyler Chatwood - R Dodgers Clayton Kershaw - L 2-6 -4 L -1.5 U 7-9 0-1 0-5 180 9.5 9
May 13, 2017 box Sat home Rockies Tyler Anderson - L Dodgers Alex Wood - L 0-4 -4 L -6.5 U 7-7 0-0 0-4 108 10.5 9
May 14, 2017 box Sun home Rockies Antonio Senzatela - R Dodgers Julio Urias - L 9-6 3 W 4.5 O 13-12 0-1 3-2 122 10.5 9
May 26, 2017 box Fri home Rockies Antonio Senzatela - R Cardinals Carlos Martinez - R 10-0 10 W -0.5 U 14-5 0-0 10-0 103 10.5 9
Jun 07, 2017 box Wed home Rockies Kyle Freeland - L Indians Trevor Bauer - R 8-1 7 W -2.0 U 11-7 0-1 7-0 104 11.0 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
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
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 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
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 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
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 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 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 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
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 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
Apr 05, 2019 box Fri home Rockies Tyler Anderson - L Dodgers Kenta Maeda - R 6-10 -4 L 5.0 O 10-13 1-1 0-8 120 11.0 9
Apr 06, 2019 box Sat home Rockies Jon Gray - R Dodgers Walker Buehler - R 2-7 -5 L -1.0 U 6-11 0-0 0-5 125 10.0 9
Apr 07, 2019 box Sun home Rockies Chad Bettis - R Dodgers Julio Urias - L 6-12 -6 L 6.5 O 10-12 2-0 0-8 155 11.5 9
Apr 20, 2019 box Sat home Rockies Antonio Senzatela - R Phillies Aaron Nola - R 5-8 -3 L 2.5 O 14-14 0-1 2-4 105 10.5 9
Apr 23, 2019 box Tue home Rockies Jeff Hoffman - R Nationals Patrick Corbin - L 3-6 -3 L -2.0 U 6-10 0-1 2-3 150 11.0 9
May 03, 2019 box Fri home Rockies Tyler Anderson - L Diamondbacks Robbie Ray - L 9-10 -1 L 8.0 O 10-12 0-3 0-4 102 11.0 9
May 29, 2019 box Wed home Rockies Jeff Hoffman - R Diamondbacks Robbie Ray - L 5-4 1 W -2.0 U 10-11 0-1 2-1 108 11.0 9
Jun 11, 2019 box Tue home Rockies Peter Lambert - R Cubs Jose Quintana - L 10-3 7 W 1.0 O 13-6 0-1 9-0 118 12.0 9
Jun 12, 2019 box Wed home Rockies Antonio Senzatela - R Cubs Cole Hamels - L 1-10 -9 L -0.5 U 7-12 1-0 0-10 117 11.5 9
Jun 27, 2019 box Thu home Rockies Peter Lambert - R Dodgers Walker Buehler - R 8-12 -4 L 7.5 O 16-17 1-1 2-4 190 12.5 9
Jun 28, 2019 box Fri home Rockies Antonio Senzatela - R Dodgers Hyun Jin Ryu - L 13-9 4 W 9.5 O 18-10 2-3 5-3 175 12.5 9
Jun 29, 2019 box Sat home Rockies Jon Gray - R Dodgers Clayton Kershaw - L 5-3 2 W -4.5 U 7-8 1-1 2-1 130 12.5 9
Jun 30, 2019 box Sun home Rockies Chi Chi Gonzalez - R Dodgers Kenta Maeda - R 5-10 -5 L 1.5 O 9-14 1-1 1-6 150 13.5 9
Jul 03, 2019 box Wed home Rockies Peter Lambert - R Astros Wade Miley - L 2-4 -2 L -7.5 U 7-6 0-0 0-3 125 13.5 9
Jul 29, 2019 box Mon home Rockies Jon Gray - R Dodgers Kenta Maeda - R 9-1 8 W -2.5 U 11-4 0-2 8-0 115 12.5 9
Jul 30, 2019 box Tue home Rockies Kyle Freeland - L Dodgers Julio Urias - L 4-9 -5 L -1.0 U 10-9 1-1 0-7 135 14.0 9
Jul 31, 2019 box Wed home Rockies German Marquez - R Dodgers Hyun Jin Ryu - L 1-5 -4 L -6.0 U 6-8 1-0 0-5 125 12.0 9
Aug 13, 2019 box Tue home Rockies Jeff Hoffman - R Diamondbacks Zac Gallen - R 3-9 -6 L -1.0 U 13-11 0-0 0-7 125 13.0 9
Aug 14, 2019 box Wed home Rockies Kyle Freeland - L Diamondbacks Robbie Ray - L 7-6 1 W 0.0 P 10-12 0-4 1-3 140 13.0 9
Aug 26, 2019 box Mon home Rockies Timothy Melville - R Braves Julio Teheran - R 3-1 2 W -9.0 U 6-6 1-0 2-0 138 13.0 9
Aug 27, 2019 box Tue home Rockies Rico Garcia - R Red Sox Rick Porcello - R 6-10 -4 L 2.5 O 15-10 3-0 0-8 131 13.5 9
Aug 28, 2019 box Wed home Rockies Peter Lambert - R Red Sox Eduardo Rodriguez - L 4-7 -3 L -2.5 U 11-12 1-0 0-4 165 13.5 9
Aug 31, 2019 box Sat home Rockies Tim Melville - R Pirates Joe Musgrove - R 4-11 -7 L 1.5 O 9-17 3-0 0-7 120 13.5 9
Sep 10, 2019 box Tue home Rockies Chi Chi Gonzalez - R Cardinals Michael Wacha - R 2-1 1 W -10.5 U 7-6 1-0 2-0 132 13.5 9
Sep 11, 2019 box Wed home Rockies Antonio Senzatela - R Cardinals Dakota Hudson - R 2-1 1 W -10.5 U 6-6 2-0 1-1 135 13.5 9
Sep 12, 2019 box Thu home Rockies Tim Melville - R Cardinals Miles Mikolas - R 3-10 -7 L 0.5 O 7-11 0-0 0-7 170 12.5 9
Sep 13, 2019 box Fri home Rockies Jeff Hoffman - R Padres Joey Lucchesi - L 10-8 2 W 5.0 O 14-9 1-1 6-0 110 13.0 9
Sep 16, 2019 box Mon home Rockies Antonio Senzatela - R Mets Steven Matz - L 9-4 5 W -1.0 U 13-9 0-1 5-3 135 14.0 9
Sep 17, 2019 box Tue home Rockies Tim Melville - R Mets Marcus Stroman - R 1-6 -5 L -6.5 U 6-11 0-0 0-6 145 13.5 9
Sep 18, 2019 box Wed home Rockies Jeff Hoffman - R Mets Noah Syndergaard - R 4-7 -3 L -2.0 U 11-10 0-1 2-3 140 13.0 9
Sep 27, 2019 box Fri home Rockies Antonio Senzatela - R Brewers Zach Davies - R 11-7 4 W 4.5 O 11-14 0-1 9-1 150 13.5 9
Sep 28, 2019 box Sat home Rockies Chi Chi Gonzalez - R Brewers Gio Gonzalez - L 3-2 1 W -7.0 U 10-8 0-0 1-2 130 12.0 10+
Sep 29, 2019 box Sun home Rockies Jeff Hoffman - R Brewers Adrian Houser - R 4-3 1 W -6.0 U 8-7 1-2 1-3 165 13.0 10+

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