Note: This site will be discontinued as of September 1, 2021.
SDQL3 access will continue with user input data at http://s3.sportsdatabase.com.

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

Starter:innings pitched < Closer:innings pitched
SU: 171-754 (-4.17, 18.5%)   avg line: 109.8 / -123.3   on / against: -$66,255 / +$62,030   ROI: -61.2% / +49.5%
RL: 165-611 (-3.83, 21.3%)   avg line: -110.8 / -105.9   on / against: -$58,569 / +$52,358   ROI: -59.2% / +54.1%
OU: 695-200-27 (3.65, 77.7%)   avg total: 8.9   over / under: +$47,623 / -$56,365   ROI: +47.0% / -55.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.21 3.15 8.02 8.56 1.84 1.06 2.34 1.05 1.27 14.68 None 0.91 4.46 4.55
Opp 8.38 4.43 7.09 11.79 2.64 1.71 3.28 1.97 6.98 16.25 None 0.87 2.61 4.03
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 18, 2020 box Tue away Athletics Frankie Montas - R Diamondbacks Luke Weaver - R 1-10 -9 L 2.0 O 4-11 0-0 0-9 -150 9.0 9
Aug 19, 2020 box Wed away Dodgers Julio Urias - L Mariners Taijuan Walker - R 4-6 -2 L 0.5 O 7-9 2-2 2-3 -240 9.5 9
Aug 21, 2020 box Fri away Rangers Kolby Allard - L Mariners Nick Margevicius - L 4-7 -3 L 2.5 O 6-8 3-0 0-6 -120 8.5 9
Aug 22, 2020 box Sat away Marlins Daniel Castano - L Nationals Max Scherzer - R 4-5 -1 L 2.5 O 7-6 2-1 0-5 225 6.5 7
Aug 23, 2020 box Sun away Marlins Humberto Mejia - R Nationals Anibal Sanchez - R 3-9 -6 L 1.5 O 9-11 2-0 0-8 145 10.5 9
Aug 25, 2020 box Tue home Mets Rick Porcello - R Marlins Daniel Castano - L 0-4 -4 L -3.5 U 8-6 1-1 0-4 -195 7.5 7
Aug 25, 2020 box Tue away Angels Jose Suarez - L Astros Cristian Javier - R 3-6 -3 L 1.0 O 4-6 1-0 0-6 130 8.0 7
Aug 27, 2020 box Thu home Padres Garrett Richards - R Mariners Yusei Kikuchi - L 3-8 -5 L 4.5 O 9-9 0-0 0-6 -225 6.5 7
Aug 28, 2020 box Fri home Cardinals Daniel Ponce de Leon - R Indians Triston Mckenzie - R 2-14 -12 L 7.0 O 6-20 1-1 0-12 120 9.0 9
Aug 29, 2020 box Sat home Rockies Ryan Castellani - R Padres Michel Baez - ? 4-3 1 W -5.5 U 12-11 0-0 3-0 116 12.5 9
Sep 01, 2020 box Tue home Reds Sonny Gray - R Cardinals Kwang Hyun Kim - L 2-16 -14 L 9.5 O 8-23 0-0 0-15 -160 8.5 9
Sep 01, 2020 box Tue away Blue Jays Julian Merryweather - R Marlins Elieser Hernandez - R 2-3 -1 L -3.5 U 6-7 1-1 1-1 110 8.5 9
Sep 02, 2020 box Wed home Yankees Jordan Montgomery - L Rays Charlie Morton - R 2-5 -3 L -2.0 U 6-8 1-0 0-5 -130 9.0 9
Sep 02, 2020 box Wed home Pirates Joe Musgrove - R Cubs Kyle Hendricks - R 2-8 -6 L 0.5 O 8-10 3-0 1-6 160 9.5 9
Sep 03, 2020 box Thu home Mets Robert Gsellman - R Yankees JA Happ - L 9-7 2 W 6.5 O 14-8 1-0 0-4 -107 9.5 9
Sep 04, 2020 box Fri away Astros Lance McCullers Jr - R Angels Dylan Bundy - R 5-6 -1 L 2.0 O 13-7 0-1 0-4 -113 9.0 9
Sep 05, 2020 box Sat away Cubs Colin Rea - R Cardinals Austin Gomber - L 1-5 -4 L -1.0 U 3-6 0-0 0-5 -108 7.0 7
Sep 06, 2020 box Sun home Orioles Asher Wojciechowski - R Yankees Masahiro Tanaka - R 5-1 4 W -3.5 U 9-4 1-2 4-0 185 9.5 9
Sep 08, 2020 box Tue away Rockies Chi Chi Gonzalez - R Padres Mike Clevinger - R 5-14 -9 L 10.0 O 9-14 1-0 3-9 210 9.0 9
Sep 09, 2020 box Wed home Braves Tommy Milone - L Marlins Pablo Lopez - R 29-9 20 W 29.0 O 23-13 0-2 20-2 -135 9.0 9
Sep 10, 2020 box Thu away Dodgers Dustin May - R Diamondbacks Madison Bumgarner - L 2-5 -3 L -2.5 U 9-11 2-1 2-3 -230 9.5 9
Sep 11, 2020 box Fri home Marlins Trevor Rogers - L Phillies Aaron Nola - R 0-11 -11 L 5.0 O 3-13 1-0 0-11 148 6.0 7
Sep 11, 2020 box Fri away Red Sox Andrew Triggs - R Rays Blake Snell - L 1-11 -10 L 3.5 O 11-12 0-1 0-11 200 8.5 9
Sep 11, 2020 box Fri away Orioles Keegan Akin - L Yankees Masahiro Tanaka - R 1-10 -9 L 4.5 O 4-10 0-1 1-9 190 6.5 7
Sep 11, 2020 box Fri home Rangers Luis Garcia - R Athletics Mike Fiers - R 6-10 -4 L 6.5 O 8-12 2-0 0-8 165 9.5 9
Sep 14, 2020 box Mon home Mariners Jimmy Yacabonis - R Athletics Mike Minor - L 0-9 -9 L 2.0 O 2-11 0-0 0-9 160 7.0 7
Sep 15, 2020 box Tue away Royals Danny Duffy - L Tigers Matthew Boyd - L 0-6 -6 L -3.5 U 5-14 0-0 0-6 100 9.5 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 17, 2020 box Thu away Blue Jays Julian Merryweather - R Yankees Masahiro Tanaka - R 7-10 -3 L 7.5 O 12-14 1-0 0-7 200 9.5 9
Sep 19, 2020 box Sat away Padres Mike Clevinger - R Mariners Justus Sheffield - L 1-4 -3 L -3.5 U 9-8 0-0 0-3 -160 8.5 9
Sep 22, 2020 box Tue home Diamondbacks Caleb Smith - L Rangers Jordan Lyles - R 7-0 7 W -2.5 U 11-6 0-3 7-0 -140 9.5 9
Sep 23, 2020 box Wed away Orioles Dean Kremer - R Red Sox Nathan Eovaldi - R 1-9 -8 L 1.0 O 11-10 0-0 0-8 150 9.0 9
Sep 25, 2020 box Fri away Rockies Antonio Santos - R Diamondbacks Taylor Clarke - R 5-11 -6 L 8.5 O 8-13 1-0 1-7 140 7.5 7
Sep 26, 2020 box Sat home Rays John Curtiss - R Phillies Zack Wheeler - R 4-3 1 W -1.0 U 7-12 2-0 2-1 -105 8.0 9
Sep 27, 2020 box Sun home White Sox Reynaldo Lopez - R Cubs Adbert Alzolay - R 8-10 -2 L 8.5 O 11-8 1-0 0-9 -137 9.5 9
Sep 27, 2020 box Sun away Mets Seth Lugo - R Nationals Austin Voth - R 5-15 -10 L 11.0 O 12-11 0-0 2-11 -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
Oct 01, 2020 box Thu away White Sox Dane Dunning - R Athletics Mike Fiers - R 4-6 -2 L 1.5 O 12-8 1-1 3-2 -107 8.5 9
Oct 14, 2020 box Wed home Braves Kyle Wright - R Dodgers Julio Urias - L 3-15 -12 L 8.5 O 7-16 0-0 0-15 180 9.5 9
Oct 18, 2020 box Sun home Dodgers Dustin May - R Braves Ian Anderson - R 4-3 1 W -1.0 U 10-3 0-0 1-2 -155 8.0 9
Oct 27, 2020 box Tue home Dodgers Tony Gonsolin - R Rays Blake Snell - L 3-1 2 W -4.0 U 5-5 0-0 2-1 -130 8.0 9
Apr 01, 2021 box Thu away Rangers Kyle Gibson - R Royals Brad Keller - R 10-14 -4 L 15.0 O 15-15 3-0 5-5 150 9.0 9
Apr 03, 2021 box Sat away Diamondbacks Caleb Smith - L Padres Joe Musgrove - R 0-7 -7 L -1.5 U 4-10 2-0 0-7 195 8.5 9
Apr 04, 2021 box Sun away Astros Jose Urquidy - R Athletics Sean Manaea - L 9-2 7 W 2.5 O 11-4 0-1 7-0 -102 8.5 9
Apr 04, 2021 box Sun home Yankees Domingo German - R Blue Jays TJ Zeuch - R 1-3 -2 L -5.5 U 5-5 2-0 0-3 -160 9.5 9
Apr 09, 2021 box Fri home Blue Jays David Phelps - R Angels Andrew Heaney - L 1-7 -6 L -2.5 U 5-9 2-0 0-7 115 10.5 9
Apr 09, 2021 box Fri away Tigers Julio Teheran - R Indians Zach Plesac - R 1-4 -3 L -3.5 U 4-7 1-0 0-4 172 8.5 9
Apr 11, 2021 box Sun away Padres Adrian Morejon - L Rangers Mike Foltynewicz - R 2-0 2 W -7.5 U 5-5 0-0 2-0 -170 9.5 9
Apr 14, 2021 box Wed away Indians Zach Plesac - R White Sox Carlos Rodon - L 0-8 -8 L 0.5 O 0-12 0-0 0-8 107 7.5 9
Apr 16, 2021 box Fri home Yankees Nick Nelson - L Rays Michael Wacha - R 2-8 -6 L 0.5 O 3-11 3-0 0-8 -150 9.5 9
Apr 20, 2021 box Tue away Rays Rich Hill - L Royals Brad Keller - R 14-7 7 W 13.0 O 17-9 1-2 7-0 -110 8.0 9
Apr 23, 2021 box Fri away Brewers Brett Anderson - L Cubs Kyle Hendricks - R 2-15 -13 L 8.0 O 7-17 0-0 0-13 150 9.0 9
Apr 23, 2021 box Fri away Rangers Dane Dunning - R White Sox Dylan Cease - R 7-9 -2 L 8.0 O 10-16 0-2 0-5 130 8.0 9
Apr 24, 2021 box Sat home Astros Jake Odorizzi - R Angels Griffin Canning - R 16-2 14 W 9.0 O 18-5 1-2 14-0 -150 9.0 9
Apr 24, 2021 box Sat home Twins Michael Pineda - R Pirates Trevor Cahill - R 2-6 -4 L 0.0 P 3-7 2-1 0-5 -200 8.0 9
Apr 25, 2021 box Sun away Mariners Nick Margevicius - L Red Sox Eduardo Rodriguez - L 3-5 -2 L -0.5 U 6-5 0-0 1-4 175 8.5 9
May 04, 2021 box Tue away Dodgers Clayton Kershaw - L Cubs Kyle Hendricks - R 1-7 -6 L 2.5 O 7-6 2-3 0-7 -170 5.5 7
May 04, 2021 box Tue away Tigers Michael Fulmer - R Red Sox Nick Pivetta - R 7-11 -4 L 9.0 O 10-14 1-3 0-6 165 9.0 9
May 04, 2021 box Tue home Rockies German Marquez - R Giants Aaron Sanchez - R 4-12 -8 L 8.5 O 7-12 0-1 0-10 -110 7.5 7
May 04, 2021 box Tue away Indians Phil Maton - R Royals Mike Minor - L 7-3 4 W 1.0 O 7-10 0-1 4-3 120 9.0 9
May 07, 2021 box Fri home Braves Charlie Morton - R Phillies Zach Eflin - R 2-12 -10 L 5.5 O 5-16 0-0 0-10 -140 8.5 9
May 13, 2021 box Thu away Royals Daniel Lynch - L Tigers Spencer Turnbull - R 3-4 -1 L -2.0 U 10-10 1-1 0-4 105 9.0 9
May 14, 2021 box Fri away Rangers Wes Benjamin - L Astros Zack Greinke - R 4-10 -6 L 5.0 O 9-10 2-0 0-8 200 9.0 9
May 18, 2021 box Tue home Orioles Matt Harvey - R Rays Luis Patino - R 6-13 -7 L 10.0 O 9-15 0-0 0-9 140 9.0 9
May 21, 2021 box Fri home Marlins John Curtiss - R Mets Marcus Stroman - R 5-6 -1 L 4.0 O 11-8 1-0 0-3 -105 7.0 10+
May 30, 2021 box Sun away Padres Blake Snell - L Astros Zack Greinke - R 4-7 -3 L 3.0 O 9-5 0-0 0-7 105 8.0 9
May 30, 2021 box Sun home Rays Collin Mchugh - R Phillies Zach Eflin - R 6-2 4 W 0.0 P 9-10 0-1 4-0 -140 8.0 9
Jun 02, 2021 box Wed away Mets David Peterson - L Diamondbacks Madison Bumgarner - L 7-6 1 W 4.5 O 16-8 0-1 4-1 -102 8.5 9
Jun 02, 2021 box Wed away Cardinals Carlos Martinez - R Dodgers Walker Buehler - R 3-14 -11 L 9.0 O 7-10 3-2 1-12 210 8.0 9
Jun 04, 2021 box Fri home Pirates Mitch Keller - R Marlins Cody Poteet - R 9-2 7 W 3.0 O 12-5 0-0 7-0 -105 8.0 9
Jun 04, 2021 box Fri away Twins Matt Shoemaker - R Royals Brad Keller - R 5-14 -9 L 9.5 O 11-12 4-0 0-13 117 9.5 9
Jun 05, 2021 box Sat home Orioles John Means - L Indians Aaron Civale - R 4-10 -6 L 5.5 O 11-13 1-0 0-6 -115 8.5 9
Jun 07, 2021 box Mon away Royals Jackson Kowar - R Angels Dylan Bundy - R 3-8 -5 L 2.0 O 9-9 0-0 0-5 137 9.0 9
Jun 09, 2021 box Wed away Indians Jean Carlos Mejia - R Cardinals Adam Wainwright - R 2-8 -6 L 2.0 O 3-10 1-0 2-6 120 8.0 9
Jun 11, 2021 box Fri home Nationals Max Scherzer - R Giants Anthony DeSclafani - R 0-1 -1 L -6.0 U 2-4 0-0 0-1 -175 7.0 9
Jun 12, 2021 box Sat home Indians Triston Mckenzie - R Mariners Yusei Kikuchi - L 5-4 1 W -0.5 U 8-8 0-2 1-4 -123 9.5 10+
Jun 13, 2021 box Sun home Diamondbacks Jon Duplantier - R Angels Patrick Sandoval - L 3-10 -7 L 3.5 O 8-13 1-0 0-8 120 9.5 9
Jun 14, 2021 box Mon away Angels Dylan Bundy - R Athletics Sean Manaea - L 5-8 -3 L 4.5 O 14-9 1-0 1-7 140 8.5 9
Jun 15, 2021 box Tue home Giants Zack Littell - R Diamondbacks Alex Young - L 9-8 1 W 9.0 O 12-12 0-0 1-7 -185 8.0 9
Jun 19, 2021 box Sat away Mets Robert Gsellman - R Nationals Jon Lester - L 2-6 -4 L 1.0 O 8-10 0-0 0-6 -105 7.0 7
Jun 22, 2021 box Tue home Rays Andrew Kittredge - R Red Sox Eduardo Rodriguez - L 5-9 -4 L 6.0 O 9-11 0-2 2-4 -110 8.0 10+
Jun 23, 2021 box Wed away Red Sox Garrett Richards - R Rays Rich Hill - L 2-8 -6 L 1.0 O 6-6 1-0 1-7 137 9.0 9
Jun 24, 2021 box Thu away Orioles Dean Kremer - R Blue Jays Anthony Kay - L 0-9 -9 L -2.0 U 7-10 1-0 0-9 167 11.0 9
Jun 25, 2021 box Fri away Diamondbacks Corbin Martin - R Padres Chris Paddack - R 5-11 -6 L 7.5 O 13-13 0-1 0-6 260 8.5 9
Jun 26, 2021 box Sat away Royals Kyle Zimmer - R Rangers Kyle Gibson - R 0-8 -8 L 0.0 P 3-12 1-0 0-8 140 8.0 9
Jun 29, 2021 box Tue away Orioles Travis Lakins Sr - R Astros Jose Urquidy - R 13-3 10 W 7.0 O 16-7 0-0 10-0 280 9.0 9
Jun 30, 2021 box Wed home Brewers Aaron Ashby - L Cubs Jake Arrieta - R 15-7 8 W 13.5 O 12-8 1-1 8-7 -155 8.5 9
Jun 30, 2021 box Wed away Angels Shohei Ohtani - R Yankees Domingo German - R 11-8 3 W 9.0 O 9-9 0-1 3-5 108 10.0 9
Jul 01, 2021 box Thu away Dodgers Victor Gonzalez - L Nationals Patrick Corbin - L 6-2 4 W -1.5 U 9-4 0-1 4-1 -137 9.5 5
Jul 02, 2021 box Fri away Marlins Pablo Lopez - R Braves Drew Smyly - L 0-1 -1 L -8.0 U 5-2 0-0 0-1 123 9.0 9
Jul 06, 2021 box Tue home Cubs Jake Arrieta - R Phillies Aaron Nola - R 10-15 -5 L 15.0 O 14-16 3-0 0-11 130 10.0 9
Jul 06, 2021 box Tue home Mariners Justus Sheffield - L Yankees Jameson Taillon - R 1-12 -11 L 3.5 O 5-18 0-0 0-11 155 9.5 9
Jul 07, 2021 box Wed away Yankees Nick Nelson - L Mariners Yusei Kikuchi - L 5-4 1 W 0.5 O 10-3 1-0 4-0 110 8.5 9
Jul 10, 2021 box Sat home Orioles Thomas Eshelman - R White Sox Lucas Giolito - R 3-8 -5 L 0.5 O 8-13 0-1 0-6 180 10.5 9
Jul 11, 2021 box Sun away Phillies Brandon Kintzler - R Red Sox Nick Pivetta - R 5-4 1 W -1.5 U 6-11 1-3 4-1 175 10.5 9
Jul 16, 2021 box Fri home Nationals Erick Fedde - R Padres Chris Paddack - R 8-24 -16 L 22.5 O 12-22 3-0 0-16 140 9.5 9
Jul 17, 2021 box Sat home Royals Brady Singer - R Orioles Jorge Lopez - R 4-8 -4 L 2.5 O 9-11 0-0 0-7 -150 9.5 9
Jul 18, 2021 box Sun away Mets Taijuan Walker - R Pirates JT Brubaker - R 7-6 1 W 5.0 O 11-11 2-1 1-6 -132 8.0 9
Jul 19, 2021 box Mon home Blue Jays Ross Stripling - R Red Sox Nick Pivetta - R 4-13 -9 L 6.5 O 11-14 0-0 0-12 -125 10.5 9
Jul 19, 2021 box Mon away Marlins Ross Detwiler - L Nationals Jon Lester - L 1-18 -17 L 9.5 O 9-18 1-0 0-18 105 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).