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

The Astros are 18-28-3 AGAINST since Oct 31, 2017 as a dog.
SU: 20-29 (0.04, 40.8%)   avg line: 122.4 / -132.7   on / against: -$451 / +$254   ROI: -9.2% / +3.9%
RL: 30-19 (1.48, 61.2%)   avg line: -164.8 / 143.8   on / against: +$45 / -$415   ROI: +0.6% / -8.4%
OU: 18-28-3 (-0.33, 39.1%)   avg total: 8.6   over / under: -$1,262 / +$840   ROI: -23.4% / +15.6%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.16 3.63 8.45 7.80 1.67 1.14 2.14 0.98 2.84 15.43 None 0.76 2.39 4.41
Opp 4.12 3.41 9.16 7.63 1.67 1.31 2.39 1.00 4.41 14.20 None 0.76 2.06 4.69
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Oct 31, 2017 box Tue away Astros Justin Verlander - R Dodgers Rich Hill - L 1-3 -2 L -3.5 U 6-5 0-0 1-2 120 7.5 9
Nov 01, 2017 box Wed away Astros Lance McCullers - R Dodgers Yu Darvish - R 5-1 4 W -1.5 U 5-6 0-1 5-0 135 7.5 9
May 02, 2018 box Wed home Astros Dallas Keuchel - L Yankees Luis Severino - R 0-4 -4 L -3.5 U 5-9 1-0 0-4 115 7.5 9
May 25, 2018 box Fri away Astros Dallas Keuchel - L Indians Corey Kluber - R 11-2 9 W 5.0 O 16-10 0-1 9-2 130 8.0 9
May 30, 2018 box Wed away Astros Dallas Keuchel - L Yankees Luis Severino - R 3-5 -2 L 0.0 P 7-8 0-1 1-3 175 8.0 9
Aug 04, 2018 box Sat away Astros Lance McCullers - R Dodgers Kenta Maeda - R 14-0 14 W 6.5 O 13-3 0-0 14-0 110 7.5 9
Aug 05, 2018 box Sun away Astros Gerrit Cole - R Dodgers Walker Buehler - R 2-3 -1 L -2.5 U 5-7 0-0 1-2 100 7.5 9
Aug 07, 2018 box Tue away Astros Dallas Keuchel - L Giants Madison Bumgarner - L 2-1 1 W -4.0 U 9-4 0-0 1-1 -104 7.0 9
Sep 08, 2018 box Sat away Astros Charlie Morton - R Red Sox Eduardo Rodriguez - L 5-3 2 W -0.5 U 11-10 0-1 4-1 105 8.5 9
Sep 09, 2018 box Sun away Astros Dallas Keuchel - L Red Sox Rick Porcello - R 5-6 -1 L 2.0 O 11-14 0-1 0-4 100 9.0 9
Sep 26, 2018 box Wed away Astros Chris Devenski - R Blue Jays Sean Reid Foley - R 1-3 -2 L -4.0 U 5-3 0-0 0-2 110 8.0 9
Oct 08, 2018 box Mon away Astros Dallas Keuchel - L Indians Mike Clevinger - R 11-3 8 W 5.5 O 13-7 0-3 9-1 112 8.5 9
Oct 13, 2018 box Sat away Astros Justin Verlander - R Red Sox Chris Sale - L 7-2 5 W 2.0 O 5-3 1-1 5-0 113 7.0 9
Apr 17, 2019 box Wed away Astros Wade Miley - L Athletics Frankie Montas - R 1-2 -1 L -6.0 U 4-4 1-2 0-1 100 9.0 9
May 19, 2019 box Sun away Astros Wade Miley - L Red Sox Chris Sale - L 3-4 -1 L -2.5 U 4-11 1-0 2-1 170 9.5 9
May 24, 2019 box Fri home Astros Wade Miley - L Red Sox Chris Sale - L 4-3 1 W -1.5 U 4-7 0-3 4-0 128 8.5 9
May 29, 2019 box Wed home Astros Wade Miley - L Cubs Kyle Hendricks - R 1-2 -1 L -6.0 U 4-7 0-0 0-2 100 9.0 9
Jun 17, 2019 box Mon away Astros Wade Miley - L Reds Luis Castillo - R 2-3 -1 L -3.5 U 4-6 0-1 0-3 110 8.5 9
Jun 20, 2019 box Thu away Astros Framber Valdez - L Yankees Chad Green - R 6-10 -4 L 6.5 O 12-12 0-0 0-7 120 9.5 9
Jun 21, 2019 box Fri away Astros Brad Peacock - R Yankees James Paxton - L 1-4 -3 L -4.5 U 7-8 1-0 0-3 145 9.5 9
Jun 22, 2019 box Sat away Astros Wade Miley - L Yankees Masahiro Tanaka - R 5-7 -2 L 1.5 O 11-7 3-0 1-2 155 10.5 9
Jul 02, 2019 box Tue away Astros Jose Urquidy - R Rockies German Marquez - R 9-8 1 W 4.0 O 13-14 1-1 3-3 116 13.0 9
Oct 17, 2019 box Thu away Astros Zack Greinke - R Yankees Masahiro Tanaka - R 8-3 5 W 2.0 O 8-5 1-4 5-1 120 9.0 9
Oct 26, 2019 box Sat away Astros Jose Urquidy - R Nationals Patrick Corbin - L 8-1 7 W 0.5 O 13-4 1-0 7-0 -102 8.5 9
Jul 28, 2020 box Tue home Astros Framber Valdez - L Dodgers Walker Buehler - R 2-5 -3 L -2.5 U 4-10 2-0 2-3 125 9.5 9
Jul 29, 2020 box Wed home Astros Cristian Javier - R Dodgers Dustin May - R 2-4 -2 L -4.0 U 8-5 0-0 0-3 125 10.0 10+
Aug 06, 2020 box Thu away Astros Brandon Bielak - R Diamondbacks Zac Gallen - R 4-5 -1 L 0.0 P 8-11 0-1 2-1 100 9.0 9
Aug 07, 2020 box Fri away Astros Zack Greinke - R Athletics Chris Bassitt - R 2-3 -1 L -3.5 U 7-10 0-0 1-1 115 8.5 10+
Aug 08, 2020 box Sat away Astros Framber Valdez - L Athletics Frankie Montas - R 1-3 -2 L -4.5 U 5-9 2-0 0-3 130 8.5 9
Aug 09, 2020 box Sun away Astros Cristian Javier - R Athletics Jesus Luzardo - L 2-7 -5 L 1.0 O 6-7 0-0 0-5 145 8.0 9
Aug 20, 2020 box Thu away Astros Cristian Javier - R Rockies German Marquez - R 10-8 2 W 6.5 O 10-14 0-1 7-0 110 11.5 9
Aug 22, 2020 box Sat away Astros Brandon Bielak - R Padres Zach Davies - R 2-13 -11 L 6.0 O 5-14 0-0 1-11 115 9.0 9
Sep 05, 2020 box Sat away Astros Brandon Bielak - R Angels Griffin Canning - R 9-10 -1 L 12.0 O 12-13 0-1 3-1 108 7.0 7
Sep 07, 2020 box Mon away Astros Cristian Javier - R Athletics Chris Bassitt - R 0-6 -6 L -3.0 U 7-8 0-0 0-6 115 9.0 9
Sep 08, 2020 box Tue away Astros Chase De Jong - R Athletics Mike Minor - L 5-4 1 W 1.0 O 6-8 0-1 1-4 135 8.0 7
Sep 09, 2020 box Wed away Astros Luis Garcia - R Athletics Jesus Luzardo - L 2-3 -1 L -4.0 U 4-5 0-0 2-1 155 9.0 9
Sep 10, 2020 box Thu away Astros Jose Urquidy - R Athletics Sean Manaea - L 1-3 -2 L -5.0 U 2-5 0-0 1-2 130 9.0 9
Sep 12, 2020 box Sat away Astros Framber Valdez - L Dodgers Julio Urias - L 7-5 2 W 2.5 O 11-10 0-1 2-4 145 9.5 9
Sep 13, 2020 box Sun away Astros Zack Greinke - R Dodgers Brusdar Graterol - R 1-8 -7 L 0.0 P 4-12 0-0 0-7 120 9.0 9
Sep 29, 2020 box Tue away Astros Zack Greinke - R Twins Kenta Maeda - R 4-1 3 W -2.5 U 8-4 0-1 3-1 153 7.5 9
Sep 30, 2020 box Wed away Astros Jose Urquidy - R Twins Jose Berrios - R 3-1 2 W -3.5 U 5-3 1-0 2-0 140 7.5 9
Oct 05, 2020 box Mon away Astros Lance McCullers Jr - R Athletics Chris Bassitt - R 10-5 5 W 6.5 O 16-8 1-1 5-3 115 8.5 9
Oct 11, 2020 box Sun away Astros Framber Valdez - L Rays Blake Snell - L 1-2 -1 L -5.0 U 9-6 1-0 1-1 125 8.0 9
Oct 12, 2020 box Mon away Astros Lance McCullers Jr - R Rays Charlie Morton - R 2-4 -2 L -2.5 U 10-4 2-0 0-3 120 8.5 9
Oct 13, 2020 box Tue home Astros Jose Urquidy - R Rays Ryan Yarbrough - L 2-5 -3 L -1.5 U 7-8 1-0 1-4 -103 8.5 9
Oct 14, 2020 box Wed home Astros Zack Greinke - R Rays Tyler Glasnow - R 4-3 1 W -1.0 U 9-7 0-0 2-0 130 8.0 9
Oct 15, 2020 box Thu home Astros Luis Garcia - R Rays John Curtiss - R 4-3 1 W -2.0 U 6-7 0-1 2-0 130 9.0 9
Oct 16, 2020 box Fri away Astros Framber Valdez - L Rays Blake Snell - L 7-4 3 W 3.0 O 11-6 0-0 6-1 125 8.0 9
Oct 17, 2020 box Sat away Astros Lance McCullers Jr - R Rays Charlie Morton - R 2-4 -2 L -2.0 U 7-6 0-0 0-4 108 8.0 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).