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 7-0 since Sep 16, 2016 at home off a road game off a loss
SU: 93-86 (0.26, 52.0%)   avg line: -101.6 / -110.1   on / against: +$725 / -$1,632   ROI: +3.3% / -7.2%
RL: 88-91 (0.24, 49.2%)   avg line: -110.8 / -107.6   on / against: -$1,225 / -$220   ROI: -5.4% / -1.0%
OU: 73-101-5 (-0.13, 42.0%)   avg total: 9.9   over / under: -$3,783 / +$2,184   ROI: -19.1% / +11.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.03 3.08 8.65 9.40 2.02 1.17 2.62 1.24 4.05 13.94 6.72 0.96 2.95 4.35
Opp 4.77 3.28 7.97 9.06 2.12 1.17 2.62 1.23 3.48 14.46 6.92 0.99 3.31 4.42
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 10, 2017 box Sat away Rockies Jeff Hoffman - R Cubs Eddie Butler - R 9-1 8 W -2.5 U 14-5 0-0 8-0 120 12.5 9
Jun 11, 2017 box Sun away Rockies Antonio Senzatela - R Cubs Jake Arrieta - R 5-7 -2 L 0.5 O 8-12 0-0 0-4 190 11.5 9
Jun 12, 2017 box Mon away Rockies Kyle Freeland - L Pirates Jameson Taillon - R 2-7 -5 L 0.5 O 11-11 2-0 0-6 130 8.5 9
Jun 13, 2017 box Tue away Rockies Tyler Chatwood - R Pirates Gerrit Cole - R 2-5 -3 L -1.5 U 4-9 0-2 0-4 105 8.5 9
Jun 14, 2017 box Wed away Rockies German Marquez - R Pirates Chad Kuhl - R 5-1 4 W -2.5 U 8-6 0-1 4-0 -115 8.5 9
Jun 15, 2017 box Thu home Rockies Jeff Hoffman - R Giants Matt Moore - L 10-9 1 W 7.5 O 15-17 0-2 8-0 -170 11.5 9
Jun 16, 2017 box Fri home Rockies Antonio Senzatela - R Giants Jeff Samardzija - R 10-8 2 W 7.0 O 15-11 1-1 5-3 -112 11.0 9
Jun 17, 2017 box Sat home Rockies Kyle Freeland - L Giants Matt Cain - R 5-1 4 W -6.5 U 14-10 1-0 4-0 -175 12.5 9
Jun 18, 2017 box Sun home Rockies Tyler Chatwood - R Giants Ty Blach - L 7-5 2 W 0.5 O 13-9 1-0 2-2 -170 11.5 9
Jun 20, 2017 box Tue home Rockies German Marquez - R Diamondbacks Zack Greinke - R 4-3 1 W -4.0 U 10-6 0-2 2-1 -117 11.0 9
Jun 21, 2017 box Wed home Rockies Jeff Hoffman - R Diamondbacks Taijuan Walker - R 5-16 -11 L 9.0 O 8-20 1-1 1-12 -140 12.0 9
Jun 22, 2017 box Thu home Rockies Antonio Senzatela - R Diamondbacks Zack Godley - R 3-10 -7 L 1.5 O 7-11 0-0 1-9 -120 11.5 9
Jun 23, 2017 box Fri away Rockies Kyle Freeland - L Dodgers Alex Wood - L 1-6 -5 L -1.0 U 3-11 1-0 0-5 200 8.0 9
Jun 24, 2017 box Sat away Rockies Tyler Chatwood - R Dodgers Clayton Kershaw - L 0-4 -4 L -3.0 U 5-6 1-0 0-4 225 7.0 9
Jun 25, 2017 box Sun away Rockies Tyler Anderson - L Dodgers Brandon McCarthy - R 6-12 -6 L 9.5 O 8-13 0-2 5-6 160 8.5 9
Jun 26, 2017 box Mon away Rockies German Marquez - R Giants Jeff Samardzija - R 2-9 -7 L 3.5 O 9-14 1-0 0-7 120 7.5 9
Jun 27, 2017 box Tue away Rockies Jeff Hoffman - R Giants Matt Cain - R 3-4 -1 L -1.5 U 10-12 0-0 2-1 -128 8.5 10+
Jun 28, 2017 box Wed away Rockies Kyle Freeland - L Giants Ty Blach - L 3-5 -2 L -0.5 U 8-7 1-2 2-2 -115 8.5 9
Jun 30, 2017 box Fri away Rockies Jon Gray - R Diamondbacks Robbie Ray - L 6-3 3 W 0.0 P 8-9 1-0 4-0 133 9.0 9
Jul 01, 2017 box Sat away Rockies Tyler Chatwood - R Diamondbacks Zack Greinke - R 2-6 -4 L -0.5 U 6-8 2-0 0-4 150 8.5 9
Jul 02, 2017 box Sun away Rockies German Marquez - R Diamondbacks Taijuan Walker - R 3-4 -1 L -2.5 U 10-8 1-3 1-1 120 9.5 9
Jul 03, 2017 box Mon home Rockies Jeff Hoffman - R Reds Luis Castillo - R 5-3 2 W -4.0 U 10-5 0-0 2-1 -160 12.0 9
Jul 04, 2017 box Tue home Rockies Kyle Freeland - L Reds Homer Bailey - R 1-8 -7 L -3.5 U 10-10 0-0 0-7 -130 12.5 9
Jul 05, 2017 box Wed home Rockies Jon Gray - R Reds Scott Feldman - R 5-3 2 W -3.5 U 6-11 2-0 3-0 -150 11.5 9
Jul 06, 2017 box Thu home Rockies Tyler Chatwood - R Reds Sal Romano - R 3-6 -3 L -3.5 U 8-13 0-3 0-4 -156 12.5 9
Jul 07, 2017 box Fri home Rockies German Marquez - R White Sox Derek Holland - L 12-4 8 W 4.0 O 17-11 1-0 9-0 -170 12.0 9
Jul 08, 2017 box Sat home Rockies Jeff Hoffman - R White Sox Jose Quintana - L 4-5 -1 L -1.5 U 8-9 0-0 0-3 -135 10.5 9
Jul 09, 2017 box Sun home Rockies Kyle Freeland - L White Sox Carlos Rodon - L 10-0 10 W -1.5 U 12-1 0-1 10-0 -125 11.5 9
Jul 14, 2017 box Fri away Rockies Jon Gray - R Mets Jacob deGrom - R 2-14 -12 L 8.5 O 6-19 0-1 1-12 150 7.5 9
Jul 15, 2017 box Sat away Rockies Tyler Chatwood - R Mets Seth Lugo - R 3-9 -6 L 2.5 O 7-8 1-0 0-8 105 9.5 9
Jul 16, 2017 box Sun away Rockies Jeff Hoffman - R Mets Steven Matz - L 13-4 9 W 8.5 O 18-8 0-2 9-0 112 8.5 9
Jul 17, 2017 box Mon home Rockies German Marquez - R Padres Luis Perdomo - R 9-6 3 W 4.0 O 11-13 2-1 5-1 -168 11.0 9
Jul 18, 2017 box Tue home Rockies Antonio Senzatela - R Padres Dinelson Lamet - R 9-7 2 W 4.5 O 11-9 2-1 3-3 -145 11.5 9
Jul 19, 2017 box Wed home Rockies Jon Gray - R Padres Clayton Richard - L 18-4 14 W 10.5 O 21-10 0-0 14-0 -192 11.5 9
Jul 21, 2017 box Fri home Rockies Jeff Hoffman - R Pirates Trevor Williams - R 5-13 -8 L 6.0 O 9-18 1-0 1-8 -130 12.0 9
Jul 22, 2017 box Sat home Rockies German Marquez - R Pirates Chad Kuhl - R 7-3 4 W -1.5 U 13-6 0-0 5-1 -125 11.5 9
Jul 23, 2017 box Sun home Rockies Kyle Freeland - L Pirates Ivan Nova - R 13-3 10 W 3.5 O 15-11 0-0 10-0 -112 12.5 9
Jul 24, 2017 box Mon away Rockies Antonio Senzatela - R Cardinals Mike Leake - R 2-8 -6 L 1.0 O 7-12 1-0 0-6 126 9.0 9
Jul 25, 2017 box Tue away Rockies Jon Gray - R Cardinals Lance Lynn - R 2-3 -1 L -3.5 U 6-12 0-0 0-2 115 8.5 9
Jul 26, 2017 box Wed away Rockies Jeff Hoffman - R Cardinals Carlos Martinez - R 5-10 -5 L 6.5 O 9-15 1-0 2-5 165 8.5 9
Jul 29, 2017 box Sat away Rockies German Marquez - R Nationals Tanner Roark - R 4-2 2 W -2.5 U 6-3 0-0 4-0 132 8.5 9
Jul 30, 2017 box Sun away Rockies Kyle Freeland - L Nationals Erick Fedde - R 1-3 -2 L -6.0 U 4-4 0-0 1-2 110 10.0 9
Jul 30, 2017 box Sun away Rockies Jon Gray - R Nationals Edwin Jackson - R 10-6 4 W 7.0 O 16-13 1-2 5-0 -109 9.0 9
Aug 01, 2017 box Tue home Rockies Jeff Hoffman - R Mets Steven Matz - L 5-4 1 W -3.5 U 12-8 1-0 1-2 -126 12.5 9
Aug 02, 2017 box Wed home Rockies Tyler Chatwood - R Mets Chris Flexen - R 5-10 -5 L 2.5 O 11-12 1-0 5-5 -135 12.5 9
Aug 03, 2017 box Thu home Rockies German Marquez - R Mets Rafael Montero - R 5-4 1 W -2.5 U 12-9 0-0 2-0 -170 11.5 9
Aug 04, 2017 box Fri home Rockies Kyle Freeland - L Phillies Vince Velasquez - R 4-3 1 W -4.5 U 7-10 0-0 2-1 -160 11.5 9
Aug 05, 2017 box Sat home Rockies Jon Gray - R Phillies Nick Pivetta - R 8-5 3 W 1.5 O 10-12 0-1 8-0 -200 11.5 9
Aug 06, 2017 box Sun home Rockies Jeff Hoffman - R Phillies Aaron Nola - R 2-3 -1 L -6.0 U 7-9 0-0 1-1 -107 11.0 9
Aug 08, 2017 box Tue away Rockies German Marquez - R Indians Corey Kluber - R 1-4 -3 L -2.5 U 3-6 0-0 1-3 225 7.5 9
Aug 09, 2017 box Wed away Rockies Antonio Senzatela - R Indians Trevor Bauer - R 3-2 1 W -4.0 U 12-7 0-0 1-1 160 9.0 10+
Aug 11, 2017 box Fri away Rockies Jon Gray - R Marlins Jose Urena - R 3-6 -3 L 0.5 O 7-11 0-0 2-3 -110 8.5 9
Aug 12, 2017 box Sat away Rockies Jeff Hoffman - R Marlins Justin Nicolino - L 3-4 -1 L -2.0 U 9-10 0-2 1-3 -110 9.0 9
Aug 13, 2017 box Sun away Rockies German Marquez - R Marlins Vance Worley - R 3-5 -2 L -0.5 U 10-8 0-0 1-2 -106 8.5 9
Aug 14, 2017 box Mon home Rockies Chad Bettis - R Braves Julio Teheran - R 3-0 3 W -9.0 U 7-7 0-0 3-0 -135 12.0 9
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 22, 2017 box Tue away Rockies Jon Gray - R Royals Danny Duffy - L 2-3 -1 L -3.5 U 2-6 1-1 0-3 115 8.5 9
Aug 23, 2017 box Wed away Rockies Antonio Senzatela - R Royals Ian Kennedy - R 4-6 -2 L 0.5 O 9-14 1-0 2-2 115 9.5 9
Aug 24, 2017 box Thu away Rockies German Marquez - R Royals Jake Junis - ? 3-2 1 W -3.5 U 11-9 0-0 1-2 -101 8.5 9
Aug 25, 2017 box Fri away Rockies Chad Bettis - R Braves Julio Teheran - R 2-5 -3 L -2.0 U 6-7 0-0 0-5 110 9.0 9
Aug 26, 2017 box Sat away Rockies Kyle Freeland - L Braves Sean Newcomb - L 7-6 1 W 4.0 O 12-13 1-0 3-1 105 9.0 9
Aug 27, 2017 box Sun away Rockies Jon Gray - R Braves Mike Foltynewicz - R 3-0 3 W -6.0 U 8-6 0-2 3-0 -125 9.0 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 01, 2017 box Fri home Rockies Kyle Freeland - L Diamondbacks Taijuan Walker - R 5-9 -4 L 2.0 O 8-10 3-1 0-7 -105 12.0 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 07, 2017 box Thu away Rockies Jon Gray - R Dodgers Clayton Kershaw - L 9-1 8 W 3.5 O 16-6 0-1 8-0 270 6.5 9
Sep 08, 2017 box Fri away Rockies German Marquez - R Dodgers Yu Darvish - R 5-4 1 W 1.5 O 6-7 2-0 1-3 190 7.5 9
Sep 09, 2017 box Sat away Rockies Chad Bettis - R Dodgers Alex Wood - L 6-5 1 W 3.0 O 11-8 2-2 4-0 210 8.0 9
Sep 10, 2017 box Sun away Rockies Tyler Chatwood - R Dodgers Rich Hill - L 8-1 7 W 0.5 O 11-8 0-0 8-0 180 8.5 9
Sep 11, 2017 box Mon away Rockies Kyle Freeland - L Diamondbacks Zack Greinke - R 5-4 1 W 0.0 P 8-7 1-0 3-1 178 9.0 9
Sep 12, 2017 box Tue away Rockies Jon Gray - R Diamondbacks Taijuan Walker - R 4-2 2 W -3.0 U 7-8 1-0 2-1 115 9.0 9
Sep 13, 2017 box Wed away Rockies German Marquez - R Diamondbacks Patrick Corbin - L 2-8 -6 L 1.0 O 6-16 1-1 0-7 136 9.0 9
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 1-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

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