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 Diamondbacks are 23-35-4 AGAINST since Jul 12, 2019 on the road.
SU: 24-38 (-0.63, 38.7%)   avg line: 121.9 / -133.8   on / against: -$1,178 / +$904   ROI: -17.7% / +10.5%
RL: 30-32 (0.19, 48.4%)   avg line: -139.3 / 118.6   on / against: -$1,415 / +$815   ROI: -15.7% / +11.8%
OU: 23-35-4 (-0.24, 39.7%)   avg total: 9.0   over / under: -$1,609 / +$1,025   ROI: -23.2% / +15.3%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.08 3.13 8.82 7.66 1.58 1.11 2.18 1.02 2.97 14.06 None 0.77 2.95 4.50
Opp 4.71 3.50 8.40 8.27 1.87 1.56 2.68 1.18 4.50 13.95 None 0.81 2.16 4.56
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 12, 2019 box Fri away Diamondbacks Robbie Ray - L Cardinals Daniel Ponce de Leon - ? 4-2 2 W -2.5 U 6-4 1-1 3-0 100 8.5 9
Jul 13, 2019 box Sat away Diamondbacks Merrill Kelly - R Cardinals Dakota Hudson - R 2-4 -2 L -2.5 U 4-7 3-0 0-3 125 8.5 9
Jul 14, 2019 box Sun away Diamondbacks Zack Greinke - R Cardinals Adam Wainwright - R 2-5 -3 L -0.5 U 8-9 1-0 0-5 -115 7.5 9
Jul 16, 2019 box Tue away Diamondbacks Alex Young - L Rangers Lance Lynn - R 9-2 7 W 1.0 O 10-5 0-2 7-0 145 10.0 9
Jul 17, 2019 box Wed away Diamondbacks Robbie Ray - L Rangers Jesse Chavez - R 19-4 15 W 12.5 O 21-7 1-1 15-0 -125 10.5 9
Jul 26, 2019 box Fri away Diamondbacks Zack Greinke - R Marlins Sandy Alcantara - R 2-3 -1 L -2.5 U 6-7 0-1 1-1 -170 7.5 9
Jul 27, 2019 box Sat away Diamondbacks Alex Young - L Marlins Jordan Yamamoto - R 9-2 7 W 3.0 O 7-9 0-1 7-1 -122 8.0 9
Jul 28, 2019 box Sun away Diamondbacks Robbie Ray - L Marlins Elieser Hernandez - R 1-5 -4 L -1.5 U 4-9 1-1 0-4 -145 7.5 9
Jul 29, 2019 box Mon away Diamondbacks Merrill Kelly - R Marlins Caleb Smith - L 6-11 -5 L 9.0 O 7-10 2-0 0-7 -102 8.0 9
Jul 30, 2019 box Tue away Diamondbacks Taylor Clarke - R Yankees JA Happ - L 4-2 2 W -5.5 U 11-5 1-0 3-0 195 11.5 9
Jul 31, 2019 box Wed away Diamondbacks Zack Greinke - R Yankees Masahiro Tanaka - R 5-7 -2 L 2.0 O 9-8 0-1 1-4 120 10.0 9
Aug 09, 2019 box Fri away Diamondbacks Robbie Ray - L Dodgers Walker Buehler - R 3-2 1 W -2.5 U 12-2 0-0 1-2 170 7.5 10+
Aug 10, 2019 box Sat away Diamondbacks Alex Young - L Dodgers Kenta Maeda - R 0-4 -4 L -4.5 U 4-6 0-0 0-4 170 8.5 9
Aug 11, 2019 box Sun away Diamondbacks Mike Leake - R Dodgers Hyun Jin Ryu - L 3-9 -6 L 4.0 O 9-14 0-0 0-8 210 8.0 9
Aug 12, 2019 box Mon away Diamondbacks Merrill Kelly - R Rockies Peter Lambert - R 8-6 2 W 0.0 P 11-11 0-0 2-4 100 14.0 9
Aug 13, 2019 box Tue away Diamondbacks Zac Gallen - R Rockies Jeff Hoffman - R 9-3 6 W -1.0 U 11-13 0-0 7-0 -135 13.0 9
Aug 14, 2019 box Wed away Diamondbacks Robbie Ray - L Rockies Kyle Freeland - L 6-7 -1 L 0.0 P 12-10 4-0 3-1 -150 13.0 9
Aug 23, 2019 box Fri away Diamondbacks Merrill Kelly - R Brewers Jordan Lyles - R 1-6 -5 L -3.0 U 2-11 0-0 0-6 140 10.0 9
Aug 24, 2019 box Sat away Diamondbacks Zac Gallen - R Brewers Chase Anderson - R 0-4 -4 L -4.5 U 4-7 1-0 0-4 120 8.5 9
Aug 25, 2019 box Sun away Diamondbacks Robbie Ray - L Brewers Zach Davies - R 5-2 3 W -2.0 U 9-7 0-1 5-0 102 9.0 9
Aug 26, 2019 box Mon away Diamondbacks Alex Young - L Giants Tyler Beede - R 6-4 2 W 1.5 O 11-9 3-1 4-1 -106 8.5 9
Aug 27, 2019 box Tue away Diamondbacks Mike Leake - R Giants Jeff Samardzija - R 3-2 1 W -3.0 U 7-5 1-0 2-1 130 8.0 9
Sep 06, 2019 box Fri away Diamondbacks Robbie Ray - L Reds Tyler Mahle - R 7-5 2 W 2.5 O 12-7 0-0 4-1 -118 9.5 9
Sep 07, 2019 box Sat away Diamondbacks Alex Young - L Reds Sonny Gray - R 2-0 2 W -6.5 U 4-3 0-2 2-0 140 8.5 9
Sep 08, 2019 box Sun away Diamondbacks Mike Leake - R Reds Anthony DeSclafani - R 3-4 -1 L -2.5 U 3-12 0-1 1-1 115 9.5 9
Sep 09, 2019 box Mon away Diamondbacks Merrill Kelly - R Mets Jacob deGrom - R 1-3 -2 L -3.5 U 3-9 0-1 0-2 210 7.5 9
Sep 10, 2019 box Tue away Diamondbacks Zac Gallen - R Mets Zack Wheeler - R 2-3 -1 L -3.0 U 10-5 0-0 1-2 115 8.0 9
Sep 11, 2019 box Wed away Diamondbacks Robbie Ray - L Mets Steven Matz - L 0-9 -9 L 0.5 O 7-11 0-0 0-9 105 8.5 9
Sep 12, 2019 box Thu away Diamondbacks Alex Young - L Mets Marcus Stroman - R 1-11 -10 L 4.0 O 4-11 1-0 0-10 135 8.0 9
Sep 20, 2019 box Fri away Diamondbacks Merrill Kelly - R Padres Eric Lauer - L 9-0 9 W 0.5 O 7-3 1-2 9-0 100 8.5 9
Sep 21, 2019 box Sat away Diamondbacks Luke Weaver - R Padres Cal Quantrill - R 4-2 2 W -2.0 U 8-5 2-0 3-0 -130 8.0 9
Sep 22, 2019 box Sun away Diamondbacks Robbie Ray - L Padres Garrett Richards - R 4-6 -2 L 1.5 O 8-10 0-0 4-2 -125 8.5 10+
Jul 24, 2020 box Fri away Diamondbacks Madison Bumgarner - L Padres Chris Paddack - R 2-7 -5 L 1.0 O 7-8 0-0 0-6 135 8.0 9
Jul 25, 2020 box Sat away Diamondbacks Robbie Ray - L Padres Dinelson Lamet - R 1-5 -4 L -2.0 U 5-7 0-1 1-4 118 8.0 9
Jul 26, 2020 box Sun away Diamondbacks Zac Gallen - R Padres Garrett Richards - R 4-3 1 W -1.5 U 7-6 1-1 2-1 108 8.5 9
Jul 27, 2020 box Mon away Diamondbacks Luke Weaver - R Padres Joey Lucchesi - L 2-6 -4 L 0.0 P 6-7 0-1 1-4 125 8.0 9
Jul 28, 2020 box Tue away Diamondbacks Merrill Kelly - R Rangers Kyle Gibson - R 4-1 3 W -4.0 U 8-3 1-1 4-0 -105 9.0 9
Jul 29, 2020 box Wed away Diamondbacks Madison Bumgarner - L Rangers Lance Lynn - R 4-7 -3 L 3.0 O 6-9 0-0 2-3 105 8.0 9
Aug 07, 2020 box Fri away Diamondbacks Luke Weaver - R Padres Zach Davies - R 0-3 -3 L -5.5 U 4-5 0-1 0-3 114 8.5 9
Aug 08, 2020 box Sat away Diamondbacks Merrill Kelly - R Padres Chris Paddack - R 3-2 1 W -4.0 U 5-7 0-1 2-1 150 9.0 9
Aug 09, 2020 box Sun away Diamondbacks Madison Bumgarner - L Padres Dinelson Lamet - R 5-9 -4 L 6.0 O 5-11 0-0 0-9 160 8.0 9
Aug 10, 2020 box Mon away Diamondbacks Robbie Ray - L Rockies Jon Gray - R 12-8 4 W 8.5 O 18-14 0-2 5-0 112 11.5 9
Aug 11, 2020 box Tue away Diamondbacks Zac Gallen - R Rockies Kyle Freeland - L 7-8 -1 L 4.0 O 13-14 1-0 1-6 -108 11.0 9
Aug 12, 2020 box Wed away Diamondbacks Luke Weaver - R Rockies Antonio Senzatela - R 13-7 6 W 7.5 O 18-16 0-1 8-2 -110 12.5 9
Aug 19, 2020 box Wed away Diamondbacks Merrill Kelly - R Athletics Jesus Luzardo - L 1-4 -3 L -3.5 U 6-6 0-0 0-4 160 8.5 9
Aug 20, 2020 box Thu away Diamondbacks Alex Young - L Athletics Sean Manaea - L 1-5 -4 L -3.0 U 6-8 0-0 0-4 150 9.0 9
Aug 21, 2020 box Fri away Diamondbacks Robbie Ray - L Giants Logan Webb - R 2-6 -4 L -1.5 U 7-10 0-0 0-4 -105 9.5 9
Aug 22, 2020 box Sat away Diamondbacks Zac Gallen - R Giants Tyler Anderson - L 1-5 -4 L -2.5 U 3-5 0-1 0-4 -160 8.5 9
Aug 23, 2020 box Sun away Diamondbacks Luke Weaver - R Giants Trevor Cahill - R 1-6 -5 L -2.0 U 5-10 0-1 0-5 -120 9.0 9
Sep 01, 2020 box Tue away Diamondbacks Alex Young - L Dodgers Julio Urias - L 3-6 -3 L 0.5 O 5-8 2-0 0-5 195 8.5 9
Sep 02, 2020 box Wed away Diamondbacks Zac Gallen - R Dodgers Walker Buehler - R 2-3 -1 L -3.0 U 5-4 1-1 1-0 180 8.0 9
Sep 03, 2020 box Thu away Diamondbacks Luke Weaver - R Dodgers Clayton Kershaw - L 1-5 -4 L -2.5 U 4-11 1-0 0-4 245 8.5 9
Sep 04, 2020 box Fri away Diamondbacks Taylor Clarke - R Giants Tyler Anderson - L 6-5 1 W 2.5 O 12-12 1-0 3-0 115 8.5 9
Sep 05, 2020 box Sat away Diamondbacks Madison Bumgarner - L Giants Trevor Cahill - R 3-4 -1 L -2.0 U 6-9 0-0 1-3 115 9.0 9
Sep 06, 2020 box Sun away Diamondbacks Alex Young - L Giants Johnny Cueto - R 2-4 -2 L -3.5 U 8-10 0-0 2-2 125 9.5 9
Sep 07, 2020 box Mon away Diamondbacks Zac Gallen - R Giants Kevin Gausman - R 2-4 -2 L -2.0 U 3-6 1-1 1-3 108 8.0 9
Sep 15, 2020 box Tue away Diamondbacks Madison Bumgarner - L Angels Julio Teheran - R 9-8 1 W 7.0 O 11-13 0-0 7-0 130 10.0 9
Sep 16, 2020 box Wed away Diamondbacks Caleb Smith - L Angels Dylan Bundy - R 9-6 3 W 6.0 O 11-11 1-1 5-0 170 9.0 9
Sep 17, 2020 box Thu away Diamondbacks Alex Young - L Angels Griffin Canning - R 3-7 -4 L 0.0 P 8-14 0-2 0-6 145 10.0 9
Sep 18, 2020 box Fri away Diamondbacks Zac Gallen - R Astros Zack Greinke - R 6-3 3 W 1.0 O 11-7 2-0 3-2 155 8.0 9
Sep 19, 2020 box Sat away Diamondbacks Luke Weaver - R Astros Cristian Javier - R 2-3 -1 L -4.0 U 4-6 1-0 2-1 160 9.0 9
Sep 20, 2020 box Sun away Diamondbacks Madison Bumgarner - L Astros Jose Urquidy - R 2-3 -1 L -4.5 U 7-5 1-0 2-1 180 9.5 9

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