A crowd-sourced stats provider.
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

team = Astros and season = 2019 and month > 5
SU: 79-43 (1.52, 64.8%)   avg line: -227.2 / 199.6   on / against: +$156 / -$907   ROI: +0.6% / -7.3%
RL: 66-56 (0.20, 54.1%)   avg line: -131.4 / 109.7   on / against: -$255 / -$720   ROI: -1.5% / -5.2%
OU: 59-60-3 (0.76, 49.6%)   avg total: 9.1   over / under: -$721 / -$523   ROI: -5.4% / -3.9%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.68 4.08 7.52 9.42 2.12 1.79 2.95 1.50 4.88 15.62 7.39 0.92 2.33 4.31
Opp 4.16 2.98 10.54 7.82 1.51 1.46 2.34 0.98 2.57 12.94 6.24 0.69 3.20 4.53
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 26, 2019 box Wed home Astros Framber Valdez - L Pirates Dario Agrazal - R 2-14 -12 L 6.5 O 9-15 1-0 0-12 -230 9.5 9
Jun 27, 2019 box Thu home Astros Brad Peacock - R Pirates Joe Musgrove - R 0-10 -10 L 0.5 O 9-14 1-0 0-10 -185 9.5 9
Jun 28, 2019 box Fri home Astros Wade Miley - L Mariners Matt Carasiti - R 2-1 1 W -6.5 U 9-5 0-0 1-1 -230 9.5 10+
Jun 29, 2019 box Sat home Astros Justin Verlander - R Mariners Yusei Kikuchi - L 6-5 1 W 1.5 O 8-7 0-1 3-2 -320 9.5 10+
Jun 30, 2019 box Sun home Astros Gerrit Cole - R Mariners Marco Gonzales - L 6-1 5 W -1.5 U 12-6 0-1 5-1 -300 8.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
Jul 03, 2019 box Wed away Astros Wade Miley - L Rockies Peter Lambert - R 4-2 2 W -7.5 U 6-7 0-0 3-0 -135 13.5 9
Jul 05, 2019 box Fri home Astros Justin Verlander - R Angels Noe Ramirez - R 4-5 -1 L 0.0 P 6-9 0-0 1-3 -205 9.0 9
Jul 06, 2019 box Sat home Astros Gerrit Cole - R Angels Andrew Heaney - L 4-0 4 W -4.5 U 10-4 0-0 4-0 -230 8.5 9
Jul 07, 2019 box Sun home Astros Jose Urquidy - R Angels Jose Suarez - L 11-10 1 W 11.0 O 19-16 1-0 2-5 -165 10.0 10+
Jul 11, 2019 box Thu away Astros Framber Valdez - L Rangers Lance Lynn - R 0-5 -5 L -5.5 U 7-11 0-0 0-5 -125 10.5 9
Jul 12, 2019 box Fri away Astros Gerrit Cole - R Rangers Jesse Chavez - R 8-9 -1 L 7.0 O 9-10 2-1 4-1 -190 10.0 9
Jul 13, 2019 box Sat away Astros Wade Miley - L Rangers Mike Minor - L 7-6 1 W 3.0 O 13-6 3-1 2-1 -133 10.0 10+
Jul 14, 2019 box Sun away Astros Justin Verlander - R Rangers Ariel Jurado - R 12-4 8 W 5.5 O 12-5 0-2 10-0 -220 10.5 9
Jul 15, 2019 box Mon away Astros Josh James - R Angels Griffin Canning - R 6-9 -3 L 5.0 O 9-10 2-0 3-4 -116 10.0 9
Jul 16, 2019 box Tue away Astros Hector Rondon - R Angels Andrew Heaney - L 2-7 -5 L -1.5 U 13-9 0-1 0-6 -114 10.5 9
Jul 17, 2019 box Wed away Astros Gerrit Cole - R Angels Felix Pena - R 11-2 9 W 4.0 O 12-9 0-0 11-0 -200 9.0 9
Jul 18, 2019 box Thu away Astros Wade Miley - L Angels Matt Harvey - R 6-2 4 W -2.0 U 8-7 1-0 6-0 -160 10.0 9
Jul 19, 2019 box Fri home Astros Justin Verlander - R Rangers Mike Minor - L 4-3 1 W -1.0 U 7-10 2-0 4-0 -215 8.0 9
Jul 20, 2019 box Sat home Astros Jose Urquidy - R Rangers Ariel Jurado - R 6-1 5 W -3.0 U 11-2 0-0 5-0 -190 10.0 9
Jul 21, 2019 box Sun home Astros Rogelio Armenteros - R Rangers Lance Lynn - R 5-3 2 W -1.0 U 9-6 0-0 3-0 -140 9.0 9
Jul 22, 2019 box Mon home Astros Gerrit Cole - R Athletics Homer Bailey - R 11-1 10 W 3.0 O 13-2 1-0 11-0 -270 9.0 9
Jul 23, 2019 box Tue home Astros Wade Miley - L Athletics Mike Fiers - R 3-4 -1 L -2.5 U 8-8 0-2 2-1 -152 9.5 10+
Jul 24, 2019 box Wed home Astros Justin Verlander - R Athletics Chris Bassitt - R 4-2 2 W -2.5 U 6-6 2-0 3-1 -220 8.5 9
Jul 26, 2019 box Fri away Astros Jose Urquidy - R Cardinals Jack Flaherty - R 3-5 -2 L -1.0 U 5-8 0-0 2-2 -110 9.0 9
Jul 27, 2019 box Sat away Astros Gerrit Cole - R Cardinals Daniel Ponce de Leon - ? 8-2 6 W 1.5 O 11-7 1-0 7-0 -200 8.5 9
Jul 28, 2019 box Sun away Astros Wade Miley - L Cardinals Dakota Hudson - R 6-2 4 W -1.0 U 13-9 1-2 5-0 -130 9.0 9
Jul 30, 2019 box Tue away Astros Justin Verlander - R Indians Shane Bieber - R 2-0 2 W -6.5 U 9-2 0-0 2-0 -135 8.5 9
Jul 31, 2019 box Wed away Astros Jose Urquidy - R Indians Zach Plesac - R 4-10 -6 L 4.0 O 6-11 0-1 1-6 -125 10.0 9
Aug 01, 2019 box Thu away Astros Gerrit Cole - R Indians Danny Salazar - R 7-1 6 W -0.5 U 11-6 0-0 6-0 -190 8.5 9
Aug 02, 2019 box Fri home Astros Wade Miley - L Mariners Yusei Kikuchi - L 10-2 8 W 2.0 O 12-3 0-1 9-0 -275 10.0 9
Aug 03, 2019 box Sat home Astros Aaron Sanchez - R Mariners Marco Gonzales - L 9-0 9 W -1.5 U 15-0 0-1 9-0 -215 10.5 9
Aug 04, 2019 box Sun home Astros Justin Verlander - R Mariners Sam Tuivailala - R 3-1 2 W -5.0 U 5-4 0-1 2-0 -450 9.0 9
Aug 06, 2019 box Tue home Astros Zack Greinke - R Rockies German Marquez - R 11-6 5 W 8.5 O 13-8 1-1 5-0 -225 8.5 9
Aug 07, 2019 box Wed home Astros Gerrit Cole - R Rockies Peter Lambert - R 14-3 11 W 8.0 O 12-8 0-0 12-1 -380 9.0 9
Aug 09, 2019 box Fri away Astros Wade Miley - L Orioles Dylan Bundy - R 3-2 1 W -5.5 U 8-8 0-1 2-0 -270 10.5 9
Aug 10, 2019 box Sat away Astros Aaron Sanchez - R Orioles Aaron Brooks - R 23-2 21 W 13.5 O 25-6 1-1 21-0 -270 11.5 9
Aug 11, 2019 box Sun away Astros Justin Verlander - R Orioles Asher Wojciechowski - R 7-8 -1 L 5.0 O 11-16 1-1 2-2 -430 10.0 9
Aug 13, 2019 box Tue away Astros Zack Greinke - R White Sox Dylan Cease - R 6-2 4 W -1.0 U 9-7 0-0 4-0 -360 9.0 9
Aug 13, 2019 box Tue away Astros Chris Devenski - R White Sox Ivan Nova - R 1-4 -3 L -4.5 U 4-10 1-1 0-3 -190 9.5 9
Aug 14, 2019 box Wed away Astros Wade Miley - L White Sox Ross Detwiler - L 9-13 -4 L 11.0 O 15-15 2-1 2-4 -290 11.0 9
Aug 15, 2019 box Thu away Astros Aaron Sanchez - R Athletics Mike Fiers - R 6-7 -1 L 3.0 O 7-8 0-0 2-2 -120 10.0 9
Aug 16, 2019 box Fri away Astros Justin Verlander - R Athletics Tanner Roark - R 2-3 -1 L -4.0 U 9-8 1-2 1-1 -180 9.0 10+
Aug 17, 2019 box Sat away Astros Rogelio Armenteros - R Athletics Chris Bassitt - R 4-8 -4 L 1.5 O 10-13 0-0 2-5 -120 10.5 9
Aug 18, 2019 box Sun away Astros Zack Greinke - R Athletics Brett Anderson - L 4-1 3 W -4.5 U 10-6 0-1 3-1 -185 9.5 9
Aug 19, 2019 box Mon home Astros Wade Miley - L Tigers Edwin Jackson - R 5-4 1 W -0.5 U 8-14 1-2 3-1 -420 9.5 9
Aug 20, 2019 box Tue home Astros Aaron Sanchez - R Tigers Spencer Turnbull - R 6-3 3 W -0.5 U 8-10 0-0 4-1 -310 9.5 9
Aug 21, 2019 box Wed home Astros Justin Verlander - R Tigers Daniel Norris - L 1-2 -1 L -5.5 U 6-2 0-0 0-1 -470 8.5 9
Aug 22, 2019 box Thu home Astros Gerrit Cole - R Tigers Jordan Zimmermann - R 6-3 3 W 1.0 O 9-5 0-0 6-0 -530 8.0 9
Aug 23, 2019 box Fri home Astros Zack Greinke - R Angels Jose Suarez - L 5-4 1 W -0.5 U 13-11 1-0 2-2 -290 9.5 9
Aug 24, 2019 box Sat home Astros Wade Miley - L Angels Dillon Peters - L 5-2 3 W -3.0 U 8-7 0-0 5-0 -220 10.0 9
Aug 25, 2019 box Sun home Astros Framber Valdez - L Angels Jaime Barria - R 11-2 9 W 2.5 O 10-4 0-0 10-0 -200 10.5 9
Aug 27, 2019 box Tue home Astros Justin Verlander - R Rays Charlie Morton - R 15-1 14 W 8.0 O 18-7 0-2 14-0 -195 8.0 9
Aug 28, 2019 box Wed home Astros Gerrit Cole - R Rays Ryan Yarbrough - L 8-6 2 W 6.0 O 10-7 0-1 4-3 -215 8.0 9
Aug 29, 2019 box Thu home Astros Zack Greinke - R Rays Andrew Kittredge - R 8-9 -1 L 8.0 O 8-14 0-2 1-2 -230 9.0 9
Aug 30, 2019 box Fri away Astros Wade Miley - L Blue Jays Trent Thornton - R 7-4 3 W 0.5 O 13-8 1-1 5-1 -200 10.5 9
Aug 31, 2019 box Sat away Astros Framber Valdez - L Blue Jays Clay Buchholz - R 4-6 -2 L -0.5 U 6-10 0-0 1-4 -165 10.5 9
Sep 01, 2019 box Sun away Astros Justin Verlander - R Blue Jays Wilmer Font - R 2-0 2 W -7.0 U 5-0 0-0 2-0 -300 9.0 9
Sep 02, 2019 box Mon away Astros Gerrit Cole - R Brewers Adrian Houser - R 3-2 1 W -3.5 U 10-6 1-0 1-1 -175 8.5 10+
Sep 03, 2019 box Tue away Astros Zack Greinke - R Brewers Jordan Lyles - R 2-4 -2 L -3.0 U 6-9 0-0 1-3 -140 9.0 9
Sep 05, 2019 box Thu home Astros Wade Miley - L Mariners Marco Gonzales - L 11-9 2 W 10.5 O 11-12 0-1 2-7 -260 9.5 10+
Sep 06, 2019 box Fri home Astros Framber Valdez - L Mariners Reggie McClain - R 7-4 3 W 0.5 O 9-4 1-1 3-2 -250 10.5 9
Sep 07, 2019 box Sat home Astros Justin Verlander - R Mariners Yusei Kikuchi - L 2-1 1 W -5.5 U 6-6 1-0 1-1 -430 8.5 9
Sep 08, 2019 box Sun home Astros Gerrit Cole - R Mariners Felix Hernandez - R 21-1 20 W 13.0 O 22-1 0-1 20-0 -450 9.0 9
Sep 09, 2019 box Mon home Astros Wade Miley - R Athletics Mike Fiers - R 15-0 15 W 5.5 O 17-3 1-1 15-0 -185 9.5 9
Sep 10, 2019 box Tue home Astros Wade Miley - L Athletics Tanner Roark - R 7-21 -14 L 18.0 O 12-25 0-0 0-17 -150 10.0 9
Sep 11, 2019 box Wed home Astros Jose Urquidy - R Athletics Brett Anderson - L 3-5 -2 L -3.0 U 8-7 0-0 1-3 -150 11.0 9
Sep 12, 2019 box Thu home Astros Justin Verlander - R Athletics Homer Bailey - R 2-3 -1 L -4.0 U 6-6 0-1 0-3 -290 9.0 9
Sep 13, 2019 box Fri away Astros Gerrit Cole - R Royals Danny Duffy - L 4-1 3 W -3.5 U 7-5 1-0 3-0 -365 8.5 9
Sep 14, 2019 box Sat away Astros Zack Greinke - R Royals Mike Montgomery - L 6-1 5 W -2.5 U 10-8 0-1 5-1 -350 9.5 9
Sep 15, 2019 box Sun away Astros Wade Miley - L Royals Jakob Junis - R 12-3 9 W 4.5 O 16-12 0-0 10-1 -250 10.5 9
Sep 17, 2019 box Tue home Astros Justin Verlander - R Rangers Lance Lynn - R 4-1 3 W -3.0 U 7-6 0-0 3-0 -350 8.0 9
Sep 18, 2019 box Wed home Astros Gerrit Cole - R Rangers Kolby Allard - L 3-2 1 W -3.5 U 6-7 1-1 2-0 -500 8.5 9
Sep 20, 2019 box Fri home Astros Zack Greinke - R Angels Jaime Barria - R 6-4 2 W 1.0 O 10-8 0-0 5-0 -370 9.0 9
Sep 21, 2019 box Sat home Astros Wade Miley - L Angels Patrick Sandoval - R 4-8 -4 L 2.5 O 6-12 1-1 0-4 -300 9.5 9
Sep 22, 2019 box Sun home Astros Justin Verlander - R Angels Jose Rodriguez - R 13-5 8 W 9.5 O 15-8 1-0 11-0 -525 8.5 9
Sep 24, 2019 box Tue away Astros Gerrit Cole - R Mariners Justin Dunn - R 3-0 3 W -6.0 U 5-4 0-0 3-0 -480 9.0 9
Sep 25, 2019 box Wed away Astros Zack Greinke - R Mariners Yusei Kikuchi - L 3-0 3 W -6.0 U 7-2 0-0 3-0 -380 9.0 9
Sep 26, 2019 box Thu away Astros Wade Miley - L Angels Jaime Barria - R 3-4 -1 L -2.5 U 12-7 1-0 0-3 -200 9.5 10+
Sep 27, 2019 box Fri away Astros Jose Urquidy - R Angels Patrick Sandoval - R 4-0 4 W -5.5 U 4-3 0-0 4-0 -220 9.5 9
Sep 28, 2019 box Sat away Astros Justin Verlander - R Angels Jose Suarez - L 6-3 3 W 0.5 O 6-5 0-0 3-3 -450 8.5 9
Sep 29, 2019 box Sun away Astros Gerrit Cole - R Angels Dillon Peters - L 8-5 3 W 4.5 O 13-8 0-0 7-0 -400 8.5 9
Oct 04, 2019 box Fri home Astros Justin Verlander - R Rays Tyler Glasnow - R 6-2 4 W 1.0 O 9-5 0-1 6-0 -250 7.0 9
Oct 05, 2019 box Sat home Astros Gerrit Cole - R Rays Blake Snell - L 3-1 2 W -3.5 U 10-6 0-1 3-0 -320 7.5 9
Oct 07, 2019 box Mon away Astros Zack Greinke - R Rays Charlie Morton - R 3-10 -7 L 5.0 O 7-12 1-1 1-7 -120 8.0 9
Oct 08, 2019 box Tue away Astros Justin Verlander - R Rays Diego Castillo - R 1-4 -3 L -2.5 U 6-13 0-0 0-4 -250 7.5 9
Oct 10, 2019 box Thu home Astros Gerrit Cole - R Rays Tyler Glasnow - R 6-1 5 W 0.0 P 8-2 0-0 5-0 -280 7.0 9
Oct 12, 2019 box Sat home Astros Zack Greinke - R Yankees Masahiro Tanaka - R 0-7 -7 L -2.0 U 3-13 1-0 0-7 -145 9.0 9
Oct 13, 2019 box Sun home Astros Justin Verlander - R Yankees James Paxton - L 3-2 1 W -2.5 U 7-6 0-0 1-1 -170 7.5 10+
Oct 15, 2019 box Tue away Astros Gerrit Cole - R Yankees Luis Severino - R 4-1 3 W -2.5 U 7-5 0-1 4-0 -150 7.5 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 18, 2019 box Fri away Astros Justin Verlander - R Yankees James Paxton - L 1-4 -3 L -2.5 U 5-5 0-0 1-3 -140 7.5 9
Oct 19, 2019 box Sat home Astros Brad Peacock - R Yankees Chad Green - R 6-4 2 W 1.0 O 6-10 0-0 3-0 -130 9.0 9
Oct 22, 2019 box Tue home Astros Gerrit Cole - R Nationals Max Scherzer - R 4-5 -1 L 2.0 O 10-9 0-0 2-3 -190 7.0 9
Oct 23, 2019 box Wed home Astros Justin Verlander - R Nationals Stephen Strasburg - R 3-12 -9 L 8.0 O 9-14 1-2 0-10 -180 7.0 9
Oct 25, 2019 box Fri away Astros Zack Greinke - R Nationals Anibal Sanchez - R 4-1 3 W -2.5 U 11-9 0-2 3-0 -130 7.5 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
Oct 27, 2019 box Sun away Astros Gerrit Cole - R Nationals Joe Ross - R 7-1 6 W 0.5 O 10-4 0-0 6-0 -240 7.5 9
Oct 29, 2019 box Tue home Astros Justin Verlander - R Nationals Stephen Strasburg - R 2-7 -5 L 1.5 O 6-9 0-0 1-5 -175 7.5 9
Oct 30, 2019 box Wed home Astros Zack Greinke - R Nationals Max Scherzer - R 2-6 -4 L 0.5 O 9-9 1-0 2-4 -135 7.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, 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).