Information you need to win.
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 4-9-1 AGAINST since Jul 15, 2019 as a favorite.
SU: 6-9 (-1.27, 40.0%)   avg line: -150.5 / 136.7   on / against: -$589 / +$498   ROI: -26.1% / +33.1%
RL: 4-11 (-2.77, 26.7%)   avg line: 119.7 / -139.7   on / against: -$645 / +$580   ROI: -40.2% / +27.2%
OU: 5-9-1 (-1.20, 35.7%)   avg total: 13.4   over / under: -$478 / +$375   ROI: -28.8% / +22.8%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.47 3.40 7.80 9.53 2.00 2.13 3.13 1.53 3.33 13.80 6.73 0.93 3.67 4.80
Opp 6.73 2.93 7.33 11.87 2.87 1.80 3.40 1.67 4.73 15.20 7.20 1.13 3.33 4.67
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
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 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 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
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 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

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