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 10-22-2 AGAINST since Jul 15, 2019 at home.
SU: 17-18 (-1.03, 48.6%)   avg line: -101.6 / -110.1   on / against: -$39 / -$157   ROI: -0.9% / -3.6%
RL: 14-21 (-0.90, 40.0%)   avg line: 101.9 / -121.9   on / against: -$795 / +$535   ROI: -20.3% / +12.3%
OU: 11-22-2 (-1.76, 33.3%)   avg total: 13.2   over / under: -$1,261 / +$1,025   ROI: -33.0% / +26.4%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.23 3.17 8.26 9.69 2.14 1.77 3.03 1.17 3.09 13.77 7.09 0.86 3.51 5.06
Opp 6.26 3.86 7.80 10.51 2.66 1.91 3.11 1.66 4.37 16.00 7.26 1.29 2.94 4.71
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
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 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 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 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 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 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).