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 Giants are 21-45 AGAINST since Jun 28, 2018 as a home dog.
SU: 21-45 (-1.86, 31.8%)   avg line: 126.5 / -138.1   on / against: -$1,966 / +$1,756   ROI: -29.7% / +19.3%
RL: 28-38 (-0.45, 42.4%)   avg line: -139.1 / 119.0   on / against: -$2,505 / +$1,830   ROI: -26.4% / +25.7%
OU: 27-37-2 (-0.36, 42.2%)   avg total: 7.7   over / under: -$1,301 / +$797   ROI: -17.9% / +11.0%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 2.74 2.64 8.86 7.03 1.70 0.53 1.67 0.64 2.23 13.41 6.42 0.85 2.74 4.45
Opp 4.61 3.05 8.24 8.77 1.56 1.11 2.53 1.14 4.68 14.29 6.85 0.88 1.77 4.12
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 28, 2018 box Thu home Giants Chris Stratton - R Rockies Jon Gray - R 8-9 -1 L 9.5 O 12-14 1-1 1-3 107 7.5 9
Jul 07, 2018 box Sat home Giants Jeff Samardzija - R Cardinals Carlos Martinez - R 2-3 -1 L -3.0 U 8-7 0-1 0-3 105 8.0 9
Jul 10, 2018 box Tue home Giants Derek Holland - L Cubs Jose Quintana - L 0-2 -2 L -6.0 U 3-6 1-0 0-2 108 8.0 9
Jul 11, 2018 box Wed home Giants Johnny Cueto - R Cubs Mike Montgomery - L 5-4 1 W 1.0 O 14-11 0-2 4-0 -103 8.0 10+
Jul 28, 2018 box Sat home Giants Johnny Cueto - R Brewers Jhoulys Chacin - R 1-7 -6 L 0.5 O 4-14 1-0 0-6 105 7.5 9
Aug 06, 2018 box Mon home Giants Dereck Rodriguez - R Astros Charlie Morton - R 1-3 -2 L -3.0 U 4-4 0-0 1-2 138 7.0 9
Aug 27, 2018 box Mon home Giants Chris Stratton - R Diamondbacks Patrick Corbin - L 2-0 2 W -5.5 U 4-5 0-0 2-0 150 7.5 9
Aug 29, 2018 box Wed home Giants Dereck Rodriguez - R Diamondbacks Zack Godley - R 1-3 -2 L -3.5 U 3-5 1-0 0-3 110 7.5 9
Sep 02, 2018 box Sun home Giants Chris Stratton - R Mets Noah Syndergaard - R 1-4 -3 L -2.5 U 2-7 0-1 0-3 135 7.5 9
Sep 10, 2018 box Mon home Giants Dereck Rodriguez - R Braves Sean Newcomb - L 1-4 -3 L -2.5 U 3-7 1-0 1-3 105 7.5 9
Sep 11, 2018 box Tue home Giants Andrew Suarez - L Braves Mike Foltynewicz - R 1-4 -3 L -2.5 U 6-9 2-0 0-4 123 7.5 9
Sep 12, 2018 box Wed home Giants Derek Holland - L Braves Anibal Sanchez - R 1-2 -1 L -4.5 U 7-8 0-1 1-1 125 7.5 9
Sep 14, 2018 box Fri home Giants Chris Stratton - R Rockies Tyler Anderson - L 2-0 2 W -5.5 U 8-2 0-0 2-0 110 7.5 9
Sep 15, 2018 box Sat home Giants Madison Bumgarner - L Rockies German Marquez - R 3-0 3 W -4.0 U 8-7 1-0 3-0 125 7.0 9
Sep 16, 2018 box Sun home Giants Dereck Rodriguez - R Rockies Antonio Senzatela - R 2-3 -1 L -2.5 U 7-7 1-0 0-3 110 7.5 9
Sep 28, 2018 box Fri home Giants Madison Bumgarner - L Dodgers Hyun Jin Ryu - L 1-3 -2 L -3.0 U 6-9 1-1 1-2 170 7.0 9
Sep 29, 2018 box Sat home Giants Dereck Rodriguez - R Dodgers Clayton Kershaw - L 6-10 -4 L 9.0 O 9-18 1-0 1-5 240 7.0 9
Sep 30, 2018 box Sun home Giants Andrew Suarez - L Dodgers Rich Hill - L 0-15 -15 L 7.5 O 2-16 0-0 0-15 210 7.5 9
Apr 05, 2019 box Fri home Giants Dereck Rodriguez - R Rays Tyler Glasnow - R 2-5 -3 L 0.0 P 8-11 1-2 0-5 115 7.0 9
Apr 06, 2019 box Sat home Giants Jeff Samardzija - R Rays Ryne Stanek - R 6-4 2 W 2.5 O 8-9 0-1 3-1 117 7.5 9
Apr 07, 2019 box Sun home Giants Drew Pomeranz - L Rays Yonny Chirinos - R 0-3 -3 L -4.5 U 5-10 0-0 0-3 103 7.5 9
Apr 09, 2019 box Tue home Giants Derek Holland - L Padres Joey Lucchesi - L 7-2 5 W 1.5 O 7-7 0-0 7-0 110 7.5 9
Apr 10, 2019 box Wed home Giants Dereck Rodriguez - R Padres Nick Margevicius - L 1-3 -2 L -4.0 U 7-6 1-0 0-2 100 8.0 9
Apr 11, 2019 box Thu home Giants Jeff Samardzija - R Rockies Jon Gray - R 1-0 1 W -6.0 U 6-3 0-0 1-0 100 7.0 9
Apr 14, 2019 box Sun home Giants Derek Holland - L Rockies German Marquez - R 0-4 -4 L -3.0 U 1-5 1-0 0-4 -103 7.0 9
Apr 26, 2019 box Fri home Giants Madison Bumgarner - L Yankees James Paxton - L 3-7 -4 L 3.5 O 5-15 2-0 0-4 110 6.5 9
Apr 28, 2019 box Sun home Giants Dereck Rodriguez - R Yankees Domingo German - R 5-11 -6 L 8.5 O 6-14 2-1 0-8 115 7.5 9
Apr 29, 2019 box Mon home Giants Jeff Samardzija - R Dodgers Kenta Maeda - R 3-2 1 W -2.5 U 11-9 0-0 1-2 137 7.5 9
Apr 30, 2019 box Tue home Giants Drew Pomeranz - L Dodgers Walker Buehler - R 3-10 -7 L 5.5 O 6-10 0-0 1-8 140 7.5 9
May 01, 2019 box Wed home Giants Madison Bumgarner - L Dodgers Hyun Jin Ryu - L 2-1 1 W -4.0 U 7-6 2-0 1-0 130 7.0 9
May 10, 2019 box Fri home Giants Dereck Rodriguez - R Reds Luis Castillo - R 0-7 -7 L -0.5 U 4-9 2-0 0-7 140 7.5 9
May 11, 2019 box Sat home Giants Jeff Samardzija - R Reds Anthony DeSclafani - R 4-5 -1 L 1.5 O 9-10 0-1 1-3 120 7.5 9
May 20, 2019 box Mon home Giants Andrew Suarez - L Braves Mike Soroka - R 1-4 -3 L -2.5 U 2-6 1-1 0-3 135 7.5 9
May 21, 2019 box Tue home Giants Shaun Anderson - R Braves Julio Teheran - R 4-3 1 W -0.5 U 9-11 0-1 1-2 -103 7.5 9
May 22, 2019 box Wed home Giants Jeff Samardzija - R Braves Max Fried - L 2-9 -7 L 3.5 O 6-7 1-0 0-7 145 7.5 9
May 23, 2019 box Thu home Giants Madison Bumgarner - L Braves Kevin Gausman - R 4-5 -1 L 1.5 O 7-11 0-0 2-1 105 7.5 10+
May 24, 2019 box Fri home Giants Drew Pomeranz - L Diamondbacks Robbie Ray - L 2-18 -16 L 12.5 O 7-21 1-0 1-16 125 7.5 9
May 26, 2019 box Sun home Giants Shaun Anderson - R Diamondbacks Luke Weaver - R 2-6 -4 L 0.5 O 10-10 2-0 0-5 110 7.5 9
Jun 07, 2019 box Fri home Giants Drew Pomeranz - L Dodgers Clayton Kershaw - L 2-1 1 W -4.5 U 7-6 0-0 2-0 200 7.5 9
Jun 08, 2019 box Sat home Giants Jeff Samardzija - R Dodgers Rich Hill - L 2-7 -5 L 1.0 O 8-11 1-0 1-5 210 8.0 9
Jun 09, 2019 box Sun home Giants Madison Bumgarner - L Dodgers Walker Buehler - R 0-1 -1 L -6.5 U 5-5 1-0 0-1 145 7.5 9
Jun 11, 2019 box Tue home Giants Tyler Beede - R Padres Chris Paddack - R 6-5 1 W 3.5 O 9-7 0-1 2-1 140 7.5 9
Jun 12, 2019 box Wed home Giants Shaun Anderson - R Padres Joey Lucchesi - L 4-2 2 W -1.5 U 8-5 1-3 2-1 120 7.5 9
Jun 14, 2019 box Fri home Giants Drew Pomeranz - L Brewers Zach Davies - R 5-3 2 W -0.5 U 10-8 1-1 3-1 130 8.5 9
Jun 16, 2019 box Sun home Giants Jeff Samardzija - R Brewers Chase Anderson - R 3-5 -2 L -0.5 U 7-12 0-0 0-2 145 8.5 9
Jun 24, 2019 box Mon home Giants Drew Pomeranz - L Rockies Jon Gray - R 0-2 -2 L -5.5 U 6-5 1-0 0-2 115 7.5 9
Jun 26, 2019 box Wed home Giants Jeff Samardzija - R Rockies German Marquez - R 3-6 -3 L 1.5 O 8-7 1-1 2-3 130 7.5 9
Jun 28, 2019 box Fri home Giants Shaun Anderson - R Diamondbacks Merrill Kelly - R 6-3 3 W 1.0 O 12-11 0-1 4-0 -104 8.0 9
Jun 29, 2019 box Sat home Giants Drew Pomeranz - L Diamondbacks Zack Greinke - R 3-4 -1 L -0.5 U 7-11 2-1 0-4 145 7.5 9
Jun 30, 2019 box Sun home Giants Madison Bumgarner - L Diamondbacks Robbie Ray - L 10-4 6 W 6.5 O 13-8 0-1 9-0 100 7.5 9
Jul 07, 2019 box Sun home Giants Jeff Samardzija - R Cardinals Jack Flaherty - R 1-0 1 W -7.0 U 2-6 0-0 1-0 110 8.0 9
Jul 19, 2019 box Fri home Giants Tyler Beede - R Mets Jacob deGrom - R 1-0 1 W -6.5 U 3-3 0-1 1-0 160 7.5 10+
Jul 22, 2019 box Mon home Giants Shaun Anderson - R Cubs Alec Mills - R 5-4 1 W 0.5 O 13-6 0-0 1-3 102 8.5 9
Jul 24, 2019 box Wed home Giants Tyler Beede - R Cubs Tyler Chatwood - R 1-4 -3 L -4.0 U 7-11 1-0 0-3 105 9.0 9
Aug 06, 2019 box Tue home Giants Conner Menez - L Nationals Anibal Sanchez - R 3-5 -2 L -0.5 U 8-8 1-1 0-4 107 8.5 9
Aug 07, 2019 box Wed home Giants Shaun Anderson - R Nationals Joe Ross - R 1-4 -3 L -4.0 U 6-9 0-0 0-4 104 9.0 9
Aug 08, 2019 box Thu home Giants Madison Bumgarner - L Phillies Aaron Nola - R 5-0 5 W -2.5 U 10-1 0-1 5-0 -103 7.5 9
Aug 09, 2019 box Fri home Giants Tyler Beede - R Phillies Drew Smyly - L 6-9 -3 L 6.5 O 11-10 1-1 1-3 112 8.5 9
Aug 11, 2019 box Sun home Giants Conner Menez - L Phillies Jake Arrieta - R 9-6 3 W 6.0 O 12-10 0-0 3-3 -104 9.0 9
Aug 14, 2019 box Wed home Giants Tyler Beede - R Athletics Homer Bailey - R 5-9 -4 L 5.0 O 7-15 0-0 0-7 110 9.0 9
Aug 26, 2019 box Mon home Giants Tyler Beede - R Diamondbacks Alex Young - L 4-6 -2 L 1.5 O 9-11 1-3 1-4 -104 8.5 9
Aug 29, 2019 box Thu home Giants Dereck Rodriguez - R Padres Chris Paddack - R 3-5 -2 L 0.0 P 8-8 0-0 0-5 117 8.0 9
Aug 31, 2019 box Sat home Giants Logan Webb - R Padres Joey Lucchesi - L 1-4 -3 L -3.0 U 9-11 0-0 1-3 106 8.0 9
Sep 27, 2019 box Fri home Giants Johnny Cueto - R Dodgers Walker Buehler - R 2-9 -7 L 3.5 O 8-9 0-2 0-7 180 7.5 9
Sep 28, 2019 box Sat home Giants Logan Webb - R Dodgers Hyun Jin Ryu - L 0-2 -2 L -6.5 U 7-7 0-0 0-2 190 8.5 9
Sep 29, 2019 box Sun home Giants Dereck Rodriguez - R Dodgers Rich Hill - L 0-9 -9 L 0.5 O 3-12 0-0 0-9 160 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, 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).