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

team = Rockies and season = 2019 and month > 5
SU: 42-64 (-1.24, 39.6%)   avg line: 136.4 / -152.7   on / against: -$1,216 / +$685   ROI: -10.2% / +4.0%
RL: 44-62 (-0.58, 41.5%)   avg line: -108.0 / -112.3   on / against: -$2,470 / +$1,635   ROI: -19.2% / +12.5%
OU: 47-54-5 (0.24, 46.5%)   avg total: 10.9   over / under: -$1,160 / +$255   ROI: -10.0% / +2.2%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.97 2.92 9.13 9.27 2.07 1.40 2.77 1.19 3.03 13.67 None 0.84 3.53 4.65
Opp 6.21 3.69 7.59 9.82 2.37 1.75 3.06 1.57 4.25 14.61 None 1.03 3.00 4.46
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 08, 2019 box Sat away Rockies Jon Gray - R Mets Steven Matz - L 3-5 -2 L 0.0 P 7-9 0-1 0-2 108 8.0 9
Jun 09, 2019 box Sun away Rockies Jeff Hoffman - R Mets Noah Syndergaard - R 1-6 -5 L -1.0 U 2-8 0-0 0-6 170 8.0 9
Jun 10, 2019 box Mon home Rockies German Marquez - R Cubs Yu Darvish - R 6-5 1 W 0.0 P 10-7 1-0 1-4 -135 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 13, 2019 box Thu home Rockies Jon Gray - R Padres Matt Strahm - L 9-6 3 W 3.5 O 13-13 1-1 4-2 -148 11.5 9
Jun 14, 2019 box Fri home Rockies Jeff Hoffman - R Padres Cal Quantrill - R 12-16 -4 L 15.5 O 18-21 0-1 7-5 -110 12.5 10+
Jun 15, 2019 box Sat home Rockies German Marquez - R Padres Eric Lauer - L 14-8 6 W 10.0 O 19-13 2-0 7-3 -175 12.0 9
Jun 16, 2019 box Sun home Rockies Peter Lambert - R Padres Nick Margevicius - L 13-14 -1 L 14.0 O 19-15 1-1 5-3 -135 13.0 9
Jun 18, 2019 box Tue away Rockies Antonio Senzatela - R Diamondbacks Merrill Kelly - R 8-1 7 W -1.0 U 12-7 1-2 7-0 125 10.0 9
Jun 19, 2019 box Wed away Rockies Jon Gray - R Diamondbacks Zack Greinke - R 6-4 2 W 1.0 O 14-10 2-0 3-2 130 9.0 9
Jun 20, 2019 box Thu away Rockies Jeff Hoffman - R Diamondbacks Robbie Ray - L 6-4 2 W 1.0 O 7-10 1-0 2-1 150 9.0 10+
Jun 21, 2019 box Fri away Rockies German Marquez - R Dodgers Walker Buehler - R 2-4 -2 L -1.5 U 3-6 1-0 0-2 170 7.5 9
Jun 22, 2019 box Sat away Rockies Peter Lambert - R Dodgers Hyun Jin Ryu - L 4-5 -1 L 0.5 O 8-14 1-1 2-1 230 8.5 10+
Jun 23, 2019 box Sun away Rockies Antonio Senzatela - R Dodgers Kenta Maeda - R 3-6 -3 L 0.0 P 10-8 0-0 2-3 220 9.0 9
Jun 24, 2019 box Mon away Rockies Jon Gray - R Giants Drew Pomeranz - L 2-0 2 W -5.5 U 5-6 0-1 2-0 -125 7.5 9
Jun 25, 2019 box Tue away Rockies Chi Chi Gonzalez - R Giants Madison Bumgarner - L 2-4 -2 L -1.5 U 3-8 1-0 0-2 145 7.5 9
Jun 26, 2019 box Wed away Rockies German Marquez - R Giants Jeff Samardzija - R 6-3 3 W 1.5 O 7-8 1-1 3-2 -140 7.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 02, 2019 box Tue home Rockies German Marquez - R Astros Jose Urquidy - R 8-9 -1 L 4.0 O 14-13 1-1 3-3 -126 13.0 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 05, 2019 box Fri away Rockies Antonio Senzatela - R Diamondbacks Zack Greinke - R 0-8 -8 L -1.0 U 5-9 0-2 0-8 172 9.0 9
Jul 06, 2019 box Sat away Rockies Jon Gray - R Diamondbacks Robbie Ray - L 2-4 -2 L -2.0 U 5-13 1-0 1-3 110 8.0 9
Jul 07, 2019 box Sun away Rockies German Marquez - R Diamondbacks Alex Young - L 3-5 -2 L -0.5 U 4-8 0-0 0-5 -128 8.5 9
Jul 12, 2019 box Fri home Rockies Jon Gray - R Reds Sonny Gray - R 3-2 1 W -6.5 U 8-6 0-2 1-1 -135 11.5 9
Jul 13, 2019 box Sat home Rockies Kyle Freeland - L Reds Tanner Roark - R 9-17 -8 L 12.0 O 15-24 0-2 4-8 -120 14.0 9
Jul 14, 2019 box Sun home Rockies Antonio Senzatela - R Reds Tyler Mahle - R 10-9 1 W 5.0 O 14-9 1-3 5-1 -114 14.0 9
Jul 15, 2019 box Mon home Rockies German Marquez - R Giants Jeff Samardzija - R 2-19 -17 L 8.0 O 6-21 1-0 0-17 -190 13.0 9
Jul 15, 2019 box Mon home Rockies Carlos Gonzalez - R Giants Dereck Rodriguez - R 1-2 -1 L -11.0 U 5-6 0-2 0-2 -135 14.0 9
Jul 16, 2019 box Tue home Rockies Peter Lambert - R Giants Drew Pomeranz - L 4-8 -4 L -2.0 U 7-14 1-0 0-4 -130 14.0 10+
Jul 17, 2019 box Wed home Rockies Jon Gray - R Giants Shaun Anderson - R 8-11 -3 L 5.5 O 11-18 1-0 1-6 -170 13.5 9
Jul 19, 2019 box Fri away Rockies Kyle Freeland - L Yankees JA Happ - L 2-8 -6 L -1.5 U 9-12 1-2 2-6 205 11.5 9
Jul 20, 2019 box Sat away Rockies Antonio Senzatela - R Yankees Masahiro Tanaka - R 5-11 -6 L 4.5 O 7-14 2-0 0-9 220 11.5 9
Jul 21, 2019 box Sun away Rockies German Marquez - R Yankees James Paxton - L 8-4 4 W 1.5 O 10-4 0-1 6-0 170 10.5 9
Jul 23, 2019 box Tue away Rockies Peter Lambert - R Nationals Stephen Strasburg - R 1-11 -10 L 2.5 O 7-17 2-0 0-11 210 9.5 9
Jul 24, 2019 box Wed away Rockies Jon Gray - R Nationals Erick Fedde - R 2-3 -1 L -4.5 U 9-7 0-0 1-1 115 9.5 9
Jul 24, 2019 box Wed away Rockies Kyle Freeland - L Nationals Patrick Corbin - L 0-2 -2 L -7.5 U 5-6 1-0 0-2 200 9.5 9
Jul 25, 2019 box Thu away Rockies Jeff Hoffman - R Nationals Max Scherzer - R 8-7 1 W 6.0 O 11-7 0-0 3-2 260 9.0 9
Jul 26, 2019 box Fri away Rockies German Marquez - R Reds Luis Castillo - R 12-2 10 W 5.5 O 14-8 0-1 10-0 120 8.5 9
Jul 27, 2019 box Sat away Rockies Carlos Gonzalez - R Reds Anthony DeSclafani - R 1-3 -2 L -6.5 U 5-6 0-0 0-3 145 10.5 9
Jul 28, 2019 box Sun away Rockies Peter Lambert - R Reds Alex Wood - L 2-3 -1 L -5.5 U 10-8 0-0 0-2 145 10.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 02, 2019 box Fri home Rockies Peter Lambert - R Giants Shaun Anderson - R 5-4 1 W -4.5 U 12-9 0-0 2-2 -140 13.5 9
Aug 03, 2019 box Sat home Rockies Jon Gray - R Giants Madison Bumgarner - L 5-6 -1 L -0.5 U 12-14 0-1 1-4 -118 11.5 9
Aug 04, 2019 box Sun home Rockies Kyle Freeland - L Giants Tyler Beede - R 6-2 4 W -5.5 U 13-7 0-0 4-1 -132 13.5 9
Aug 06, 2019 box Tue away Rockies German Marquez - R Astros Zack Greinke - R 6-11 -5 L 8.5 O 8-13 1-1 0-5 205 8.5 9
Aug 07, 2019 box Wed away Rockies Peter Lambert - R Astros Gerrit Cole - R 3-14 -11 L 8.0 O 8-12 0-0 1-12 320 9.0 9
Aug 08, 2019 box Thu away Rockies Jon Gray - R Padres Eric Lauer - L 3-9 -6 L 3.5 O 13-8 3-0 1-6 -103 8.5 9
Aug 09, 2019 box Fri away Rockies Kyle Freeland - L Padres Cal Quantrill - R 1-7 -6 L -1.0 U 6-11 0-1 0-7 134 9.0 9
Aug 10, 2019 box Sat away Rockies Chi Chi Gonzalez - R Padres Chris Paddack - R 5-8 -3 L 4.5 O 8-11 1-1 1-3 190 8.5 9
Aug 11, 2019 box Sun away Rockies German Marquez - R Padres Dinelson Lamet - R 8-3 5 W 2.5 O 12-6 0-1 5-2 105 8.5 9
Aug 12, 2019 box Mon home Rockies Peter Lambert - R Diamondbacks Merrill Kelly - R 6-8 -2 L 0.0 P 11-11 0-0 4-2 -110 14.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 16, 2019 box Fri home Rockies Jon Gray - R Marlins Sandy Alcantara - R 3-0 3 W -9.5 U 5-6 0-1 3-0 -240 12.5 9
Aug 17, 2019 box Sat home Rockies German Marquez - R Marlins Hector Noesi - R 11-4 7 W 2.5 O 13-8 0-0 8-1 -270 12.5 9
Aug 18, 2019 box Sun home Rockies Peter Lambert - R Marlins Jordan Yamamoto - R 7-6 1 W -0.5 U 10-11 0-2 1-2 -174 13.5 10+
Aug 19, 2019 box Mon away Rockies Carlos Gonzalez - R Diamondbacks Zac Gallen - R 3-5 -2 L -1.5 U 9-6 1-0 1-3 200 9.5 9
Aug 20, 2019 box Tue away Rockies Kyle Freeland - L Diamondbacks Alex Young - L 7-8 -1 L 5.0 O 13-9 2-1 1-5 130 10.0 9
Aug 21, 2019 box Wed away Rockies Tim Melville - ? Diamondbacks Mike Leake - R 7-2 5 W -0.5 U 13-4 0-0 6-0 162 9.5 9
Aug 22, 2019 box Thu away Rockies German Marquez - R Cardinals Miles Mikolas - R 5-6 -1 L 3.0 O 8-8 1-2 3-1 120 8.0 9
Aug 23, 2019 box Fri away Rockies Peter Lambert - R Cardinals Jack Flaherty - R 3-8 -5 L 2.5 O 5-13 2-0 0-8 220 8.5 9
Aug 24, 2019 box Sat away Rockies Chi Chi Gonzalez - R Cardinals Dakota Hudson - R 0-6 -6 L -3.0 U 4-6 0-0 0-6 170 9.0 9
Aug 25, 2019 box Sun away Rockies Antonio Senzatela - R Cardinals Michael Wacha - R 4-11 -7 L 5.5 O 7-15 0-1 2-7 165 9.5 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 29, 2019 box Thu home Rockies Chi Chi Gonzalez - R Pirates Trevor Williams - R 8-11 -3 L 5.0 O 12-15 0-0 0-8 -106 14.0 9
Aug 30, 2019 box Fri home Rockies Antonio Senzatela - R Pirates Dario Agrazal - R 4-9 -5 L -1.0 U 10-16 2-0 0-5 -120 14.0 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 01, 2019 box Sun home Rockies Jeff Hoffman - R Pirates Steven Brault - L 2-6 -4 L -6.0 U 4-14 3-2 0-4 -110 14.0 9
Sep 02, 2019 box Mon away Rockies Peter Lambert - R Dodgers Walker Buehler - R 9-16 -7 L 16.0 O 12-17 1-0 2-10 300 9.0 9
Sep 03, 2019 box Tue away Rockies Chi Chi Gonzalez - R Dodgers Julio Urias - L 3-5 -2 L -1.5 U 8-6 0-0 2-3 270 9.5 9
Sep 04, 2019 box Wed away Rockies Antonio Senzatela - R Dodgers Hyun Jin Ryu - L 3-7 -4 L 0.5 O 7-7 0-0 0-5 270 9.5 9
Sep 06, 2019 box Fri away Rockies Tim Melville - R Padres Dinelson Lamet - R 3-2 1 W -4.0 U 7-5 0-1 3-0 150 9.0 9
Sep 07, 2019 box Sat away Rockies Jeff Hoffman - R Padres Joey Lucchesi - L 0-3 -3 L -6.0 U 3-6 0-0 0-3 155 9.0 9
Sep 08, 2019 box Sun away Rockies Peter Lambert - R Padres Eric Lauer - L 1-2 -1 L -6.0 U 4-7 0-0 1-1 150 9.0 10+
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 14, 2019 box Sat home Rockies Peter Lambert - R Padres Eric Lauer - L 11-10 1 W 8.0 O 12-10 1-2 7-2 -105 13.0 9
Sep 15, 2019 box Sun home Rockies Chi Chi Gonzalez - R Padres Cal Quantrill - R 10-5 5 W 1.5 O 12-8 0-0 7-1 -113 13.5 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 20, 2019 box Fri away Rockies Peter Lambert - R Dodgers Clayton Kershaw - L 5-12 -7 L 8.5 O 10-13 1-0 3-8 330 8.5 9
Sep 21, 2019 box Sat away Rockies Kyle Freeland - L Dodgers Walker Buehler - R 4-2 2 W -2.5 U 7-6 1-0 3-0 350 8.5 9
Sep 22, 2019 box Sun away Rockies Antonio Senzatela - R Dodgers Hyun Jin Ryu - L 4-7 -3 L 2.0 O 8-11 0-1 1-4 320 9.0 9
Sep 24, 2019 box Tue away Rockies Jeff Hoffman - R Giants Madison Bumgarner - L 8-5 3 W 5.0 O 12-8 1-1 3-2 160 8.0 10+
Sep 25, 2019 box Wed away Rockies Tim Melville - R Giants Jeff Samardzija - R 1-2 -1 L -6.0 U 8-7 0-2 0-1 150 9.0 9
Sep 26, 2019 box Thu away Rockies Kyle Freeland - L Giants Tyler Beede - R 3-8 -5 L 2.5 O 8-12 1-1 0-5 112 8.5 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, d2020, 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, 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).