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 Astros are 60-80-6 AGAINST since May 26, 2013 as a home dog.
SU: 60-86 (-0.99, 41.1%)   avg line: 130.4 / -140.7   on / against: -$1,057 / +$454   ROI: -7.2% / +2.2%
RL: 77-69 (0.45, 52.7%)   avg line: -128.8 / 117.9   on / against: -$1,152 / +$460   ROI: -6.0% / +3.1%
OU: 60-80-6 (0.05, 42.9%)   avg total: 8.3   over / under: -$2,825 / +$1,455   ROI: -17.5% / +9.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 3.70 2.99 9.48 7.60 1.57 1.08 2.19 0.88 3.44 13.21 None 0.68 2.88 4.05
Opp 4.68 3.33 7.99 8.99 2.10 1.04 2.62 1.16 3.64 15.21 None 0.90 2.51 3.91
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 17, 2013 box Tue home Astros Jordan Lyles - R Reds Mike Leake - R 0-10 -10 L 1.5 O 5-12 1-1 0-10 170 8.5 9
Sep 18, 2013 box Wed home Astros Brad Peacock - R Reds Greg Reynolds - R 5-6 -1 L 2.0 O 13-9 1-0 0-3 137 9.0 10+
Sep 27, 2013 box Fri home Astros Brett Oberholtzer - L Yankees Adam Warren - R 2-3 -1 L -3.5 U 5-6 1-0 0-3 107 8.5 9
Sep 28, 2013 box Sat home Astros Paul Clemens - R Yankees Andy Pettitte - L 1-2 -1 L -5.5 U 5-8 1-0 1-1 155 8.5 9
Sep 29, 2013 box Sun home Astros Erik Bedard - L Yankees David Huff - L 1-5 -4 L -2.5 U 4-12 1-0 1-4 110 8.5 10+
Apr 01, 2014 box Tue home Astros Scott Feldman - R Yankees CC Sabathia - L 6-2 4 W -0.5 U 9-6 0-1 6-0 140 8.5 9
Apr 02, 2014 box Wed home Astros Jarred Cosart - R Yankees Hiroki Kuroda - R 3-1 2 W -4.5 U 4-7 0-1 2-0 145 8.5 9
Apr 03, 2014 box Thu home Astros Brett Oberholtzer - L Yankees Ivan Nova - R 2-4 -2 L -2.0 U 6-7 0-0 1-2 135 8.0 9
Apr 04, 2014 box Fri home Astros Lucas Harrell - R Angels Garrett Richards - R 1-11 -10 L 3.0 O 7-15 0-0 0-10 150 9.0 9
Apr 05, 2014 box Sat home Astros Dallas Keuchel - L Angels Tyler Skaggs - L 1-5 -4 L -3.0 U 4-14 1-2 1-4 140 9.0 9
Apr 06, 2014 box Sun home Astros Scott Feldman - R Angels Jered Weaver - R 7-4 3 W 3.0 O 7-8 0-1 6-0 145 8.0 9
Apr 07, 2014 box Mon home Astros Jarred Cosart - R Angels CJ Wilson - L 1-9 -8 L 1.5 O 4-8 1-0 0-8 145 8.5 9
Apr 15, 2014 box Tue home Astros Lucas Harrell - R Royals Yordano Ventura - R 2-4 -2 L -2.5 U 4-7 1-1 0-3 145 8.5 9
Apr 16, 2014 box Wed home Astros Dallas Keuchel - L Royals Jeremy Guthrie - R 4-6 -2 L 1.5 O 10-13 0-4 2-2 108 8.5 10+
Apr 17, 2014 box Thu home Astros Scott Feldman - R Royals James Shields - R 1-5 -4 L -1.5 U 5-9 1-0 0-5 120 7.5 9
Apr 24, 2014 box Thu home Astros Brett Oberholtzer - L Athletics Scott Kazmir - L 1-10 -9 L 3.5 O 10-14 5-0 0-9 150 7.5 9
Apr 25, 2014 box Fri home Astros Brad Peacock - R Athletics Jesse Chavez - R 5-12 -7 L 8.5 O 11-14 3-1 0-7 170 8.5 9
Apr 26, 2014 box Sat home Astros Dallas Keuchel - L Athletics Daniel Straily - R 7-6 1 W 4.0 O 8-11 0-0 4-2 135 9.0 9
Apr 27, 2014 box Sun home Astros Collin McHugh - R Athletics Tom Milone - L 5-1 4 W -3.0 U 7-2 0-1 5-0 130 9.0 9
Apr 29, 2014 box Tue home Astros Jarred Cosart - R Nationals Gio Gonzalez - L 3-4 -1 L -1.0 U 5-9 1-0 1-2 135 8.0 9
Apr 30, 2014 box Wed home Astros Brett Oberholtzer - L Nationals Jordan Zimmermann - R 0-7 -7 L -1.0 U 9-13 2-0 0-7 135 8.0 9
May 02, 2014 box Fri home Astros Brad Peacock - R Mariners Felix Hernandez - R 5-4 1 W 1.5 O 11-8 1-2 2-1 170 7.5 10+
May 03, 2014 box Sat home Astros Dallas Keuchel - L Mariners Hisashi Iwakuma - R 8-9 -1 L 9.0 O 11-9 2-1 2-7 115 8.0 9
May 12, 2014 box Mon home Astros Brad Peacock - R Rangers Colby Lewis - R 0-4 -4 L -5.0 U 11-10 1-1 0-4 123 9.0 9
May 13, 2014 box Tue home Astros Dallas Keuchel - L Rangers Matt Harrison - L 8-0 8 W -0.5 U 11-7 1-0 8-0 105 8.5 9
May 14, 2014 box Wed home Astros Scott Feldman - R Rangers Nick Tepesch - R 5-4 1 W 0.5 O 11-11 0-0 1-4 100 8.5 9
May 29, 2014 box Thu home Astros Brad Peacock - R Orioles Ubaldo Jimenez - R 3-1 2 W -5.0 U 5-7 0-2 2-0 110 9.0 9
May 30, 2014 box Fri home Astros Brett Oberholtzer - L Orioles Miguel Gonzalez - R 2-1 1 W -6.0 U 5-5 0-0 1-1 100 9.0 9
Jun 01, 2014 box Sun home Astros Scott Feldman - R Orioles Wei Yin Chen - L 4-9 -5 L 4.5 O 8-12 0-0 0-8 104 8.5 9
Jun 03, 2014 box Tue home Astros Collin McHugh - R Angels CJ Wilson - L 7-2 5 W 1.0 O 10-5 2-0 5-0 120 8.0 9
Jun 04, 2014 box Wed home Astros Jarred Cosart - R Angels Garrett Richards - R 0-4 -4 L -4.5 U 4-9 0-0 0-4 115 8.5 9
Jun 05, 2014 box Thu home Astros Brad Peacock - R Angels Tyler Skaggs - L 8-5 3 W 3.5 O 9-9 1-0 5-1 125 9.5 9
Jun 12, 2014 box Thu home Astros Scott Feldman - R Diamondbacks Wade Miley - L 5-4 1 W 0.5 O 11-8 2-0 3-0 -102 8.5 10+
Jun 13, 2014 box Fri home Astros Collin McHugh - R Rays Alex Cobb - R 1-6 -5 L -1.0 U 4-11 1-0 0-5 113 8.0 9
Jun 14, 2014 box Sat home Astros Jarred Cosart - R Rays Chris Archer - R 7-3 4 W 2.0 O 7-10 0-1 6-1 125 8.0 9
Jun 15, 2014 box Sun home Astros Brad Peacock - R Rays David Price - L 3-4 -1 L -0.5 U 6-10 0-0 2-1 150 7.5 9
Jun 25, 2014 box Wed home Astros Collin McHugh - R Braves Alex Wood - L 0-4 -4 L -4.0 U 3-5 0-0 0-4 115 8.0 9
Jun 26, 2014 box Thu home Astros Jarred Cosart - R Braves Mike Minor - L 6-1 5 W -1.0 U 8-6 1-0 5-1 101 8.0 9
Jun 27, 2014 box Fri home Astros Brad Peacock - R Tigers Justin Verlander - R 4-3 1 W -1.5 U 9-8 2-2 1-1 130 8.5 10+
Jun 28, 2014 box Sat home Astros Brett Oberholtzer - L Tigers Max Scherzer - R 3-4 -1 L -1.0 U 8-10 0-0 2-2 150 8.0 9
Jun 29, 2014 box Sun home Astros Scott Feldman - R Tigers Drew Smyly - L 6-4 2 W 1.5 O 14-9 0-0 3-0 120 8.5 9
Jul 01, 2014 box Tue home Astros Jarred Cosart - R Mariners Hisashi Iwakuma - R 2-13 -11 L 7.5 O 11-18 1-1 0-11 115 7.5 9
Jul 02, 2014 box Wed home Astros Brad Peacock - R Mariners Chris Young - R 2-5 -3 L -1.5 U 3-10 0-0 2-3 -102 8.5 9
Jul 11, 2014 box Fri home Astros Scott Feldman - R Red Sox John Lackey - R 3-8 -5 L 3.0 O 7-12 1-1 0-7 125 8.0 9
Jul 12, 2014 box Sat home Astros Brett Oberholtzer - L Red Sox Jake Peavy - R 3-2 1 W -3.5 U 8-13 0-1 2-0 110 8.5 9
Jul 13, 2014 box Sun home Astros Brad Peacock - R Red Sox Clay Buchholz - R 0-11 -11 L 2.5 O 3-16 3-0 0-11 125 8.5 9
Jul 28, 2014 box Mon home Astros Brett Oberholtzer - L Athletics Jesse Chavez - R 7-3 4 W 1.5 O 7-9 0-0 4-2 170 8.5 9
Jul 29, 2014 box Tue home Astros Scott Feldman - R Athletics Jeff Samardzija - R 4-7 -3 L 3.0 O 6-11 0-0 3-3 170 8.0 9
Jul 30, 2014 box Wed home Astros Dallas Keuchel - L Athletics Jason Hammel - R 8-1 7 W 1.0 O 8-4 0-1 7-0 130 8.0 9
Jul 31, 2014 box Thu home Astros Jake Buchanan - R Blue Jays Drew Hutchison - R 5-6 -1 L 2.0 O 8-11 0-1 2-2 140 9.0 9
Aug 02, 2014 box Sat home Astros Brett Oberholtzer - L Blue Jays RA Dickey - R 8-2 6 W 1.5 O 13-6 1-2 6-1 122 8.5 9
Aug 03, 2014 box Sun home Astros Scott Feldman - R Blue Jays Marcus Stroman - R 6-1 5 W -1.5 U 9-8 0-1 5-1 150 8.5 9
Aug 09, 2014 box Sat home Astros Scott Feldman - R Rangers Yu Darvish - R 8-3 5 W 3.5 O 12-10 0-1 6-0 157 7.5 9
Aug 11, 2014 box Mon home Astros Brad Peacock - R Twins Tommy Milone - L 2-4 -2 L -2.5 U 9-11 2-1 0-2 101 8.5 9
Aug 25, 2014 box Mon home Astros Scott Feldman - R Athletics Jeff Samardzija - R 2-8 -6 L 1.5 O 7-9 0-1 0-6 155 8.5 9
Aug 26, 2014 box Tue home Astros Dallas Keuchel - L Athletics Jason Hammel - R 4-2 2 W -2.0 U 4-5 2-1 2-2 107 8.0 9
Aug 27, 2014 box Wed home Astros Brad Peacock - R Athletics Drew Pomeranz - L 4-5 -1 L 0.5 O 9-10 0-1 1-2 155 8.5 9
Sep 02, 2014 box Tue home Astros Brad Peacock - R Angels CJ Wilson - L 8-3 5 W 2.5 O 15-6 1-1 7-0 145 8.5 9
Sep 03, 2014 box Wed home Astros Collin McHugh - R Angels Jered Weaver - R 4-1 3 W -3.0 U 7-4 1-0 3-0 125 8.0 9
Sep 16, 2014 box Tue home Astros Nicholas Tropeano - R Indians Corey Kluber - R 2-4 -2 L -1.5 U 9-7 2-0 0-3 165 7.5 9
Sep 17, 2014 box Wed home Astros Brett Oberholtzer - L Indians Carlos Carrasco - R 0-2 -2 L -5.5 U 2-7 1-1 0-2 120 7.5 9
Sep 18, 2014 box Thu home Astros Scott Feldman - R Indians Danny Salazar - R 1-2 -1 L -5.0 U 8-8 0-1 1-1 125 8.0 10+
Sep 19, 2014 box Fri home Astros Brad Peacock - R Mariners Taijuan Walker - R 5-10 -5 L 6.5 O 13-12 2-0 1-7 135 8.5 9
Sep 21, 2014 box Sun home Astros Collin McHugh - R Mariners Hisashi Iwakuma - R 8-3 5 W 3.5 O 14-7 0-1 5-2 130 7.5 9
Apr 06, 2015 box Mon home Astros Dallas Keuchel - L Indians Corey Kluber - R 2-0 2 W -5.5 U 3-3 0-0 2-0 100 7.5 9
Apr 08, 2015 box Wed home Astros Scott Feldman - R Indians Carlos Carrasco - R 0-2 -2 L -6.0 U 4-7 0-0 0-2 118 8.0 9
Apr 09, 2015 box Thu home Astros Asher Wojciechowski - R Indians Trevor Bauer - R 1-5 -4 L -2.0 U 1-11 1-0 0-5 -102 8.0 9
Apr 13, 2015 box Mon home Astros Scott Feldman - R Athletics Scott Kazmir - L 1-8 -7 L 0.5 O 5-12 2-0 0-7 104 8.5 9
Apr 17, 2015 box Fri home Astros Roberto Hernandez - R Angels Jered Weaver - R 3-6 -3 L 0.0 P 8-6 0-1 0-3 107 9.0 9
Apr 19, 2015 box Sun home Astros Scott Feldman - R Angels Garrett Richards - R 4-3 1 W -1.0 U 6-8 0-2 2-0 108 8.0 9
May 01, 2015 box Fri home Astros Samuel Deduno - R Mariners Roenis Elias - L 4-3 1 W -1.5 U 9-6 0-0 3-0 -102 8.5 9
May 03, 2015 box Sun home Astros Roberto Hernandez - R Mariners JA Happ - L 7-6 1 W 4.5 O 8-10 2-0 5-0 103 8.5 9
May 19, 2015 box Tue home Astros Roberto Hernandez - R Athletics Sonny Gray - R 6-4 2 W 2.0 O 11-10 0-0 4-0 121 8.0 9
Jun 12, 2015 box Fri home Astros Brett Oberholtzer - L Mariners Felix Hernandez - R 10-0 10 W 2.5 O 11-4 1-1 10-0 121 7.5 9
Jun 27, 2015 box Sat home Astros Brett Oberholtzer - L Yankees Masahiro Tanaka - R 6-9 -3 L 7.5 O 10-10 2-0 0-6 115 7.5 9
Aug 22, 2015 box Sat home Astros Scott Kazmir - L Dodgers Zack Greinke - R 3-1 2 W -3.0 U 3-7 0-1 2-0 110 7.0 9
Aug 23, 2015 box Sun home Astros Lance McCullers - R Dodgers Clayton Kershaw - L 3-2 1 W -1.5 U 10-10 0-0 1-2 150 6.5 10+
May 06, 2016 box Fri home Astros Doug Fister - R Mariners Taijuan Walker - R 6-3 3 W 0.0 P 8-5 0-1 5-0 100 9.0 9
May 09, 2016 box Mon home Astros Mike Fiers - R Indians Corey Kluber - R 7-1 6 W 0.5 O 8-3 1-1 6-0 104 7.5 9
May 11, 2016 box Wed home Astros Doug Fister - R Indians Danny Salazar - R 5-3 2 W -0.5 U 10-14 1-0 2-2 120 8.5 10+
May 24, 2016 box Tue home Astros Doug Fister - R Orioles Chris Tillman - R 3-2 1 W -3.5 U 8-8 1-0 1-1 103 8.5 10+
May 25, 2016 box Wed home Astros Collin McHugh - R Orioles Tyler Wilson - R 4-3 1 W -1.5 U 8-11 1-4 2-1 137 8.5 9
Jul 02, 2016 box Sat home Astros Doug Fister - R White Sox Chris Sale - L 6-7 -1 L 5.0 O 7-13 0-1 2-3 -103 8.0 9
Aug 01, 2016 box Mon home Astros Doug Fister - R Blue Jays Marcus Stroman - R 2-1 1 W -5.5 U 7-6 0-1 1-0 102 8.5 10+
Aug 03, 2016 box Wed home Astros Collin McHugh - R Blue Jays Marco Estrada - R 1-3 -2 L -3.5 U 5-7 1-2 0-3 -104 7.5 9
Aug 04, 2016 box Thu home Astros Mike Fiers - R Blue Jays JA Happ - L 1-4 -3 L -3.5 U 5-8 0-0 0-3 107 8.5 9
Aug 07, 2016 box Sun home Astros Joe Musgrove - R Rangers Yu Darvish - R 3-5 -2 L 0.0 P 11-15 1-0 0-3 110 8.0 10+
Sep 09, 2016 box Fri home Astros Joe Musgrove - R Cubs Jon Lester - L 0-2 -2 L -5.5 U 7-5 0-0 0-2 126 7.5 9
Sep 11, 2016 box Sun home Astros Mike Fiers - R Cubs Jake Arrieta - R 5-9 -4 L 6.5 O 7-10 1-0 0-9 137 7.5 9
Sep 28, 2016 box Wed home Astros Doug Fister - R Mariners James Paxton - L 4-12 -8 L 7.5 O 11-15 1-0 0-8 109 8.5 9
Jul 19, 2017 box Wed home Astros Charlie Morton - R Mariners James Paxton - L 1-4 -3 L -3.5 U 8-6 1-1 1-3 -102 8.5 9
Oct 29, 2017 box Sun home Astros Dallas Keuchel - L Dodgers Clayton Kershaw - L 13-12 1 W 18.0 O 14-14 1-1 3-4 115 7.0 10+
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 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
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+
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

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