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

HF and so:runs > 9 and total >= 9 and line > -135 and p:AL and op:HW
SU: 6-6 (-1.33, 50.0%)   avg line: -120.6 / 109.8   on / against: -$102 / +$44   ROI: -7.0% / +3.7%
RL: 5-5 (-3.30, 50.0%)   avg line: 165.4 / -185.9   on / against: +$314 / -$404   ROI: +31.4% / -21.7%
OU: 9-2-1 (2.67, 81.8%)   avg total: 9.8   over / under: +$695 / -$800   ROI: +53.9% / -59.3%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.58 3.08 7.08 9.33 1.83 1.42 2.58 1.42 4.42 13.67 None 1.00 3.92 4.50
Opp 6.92 4.33 7.17 12.08 3.00 1.58 3.33 1.75 3.83 17.25 None 1.00 3.67 4.25
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Apr 26, 2005 box Tue home Rangers Ryan Drese - R Mariners Joel Pineiro - R 4-7 -3 L 0.5 O 8-15 2-0 0-4 -125 10.5 9
Sep 07, 2006 box Thu home Rockies Aaron Cook - R Nationals Jason Bergmann - R 10-5 5 W 5.0 O 12-10 0-2 5-0 -130 10.0 9
Apr 20, 2007 box Fri home Rangers Brandon McCarthy - R Athletics Joe Blanton - R 4-16 -12 L 10.0 O 10-13 0-0 0-13 -115 10.0 9
Aug 06, 2007 box Mon home Cardinals Braden Looper - R Padres David Wells - L 10-5 5 W 5.5 O 15-9 0-2 7-3 -125 9.5 9
Aug 14, 2007 box Tue home Brewers Chris Capuano - L Cardinals Kip Wells - R 4-12 -8 L 6.5 O 7-19 1-0 3-8 -130 9.5 9
Apr 21, 2008 box Mon home Pirates Matt Morris - R Marlins Mark Hendrickson - L 4-10 -6 L 4.0 O 8-16 0-1 0-8 -110 10.0 9
Apr 08, 2011 box Fri home Red Sox John Lackey - R Yankees Phil Hughes - R 9-6 3 W 5.0 O 12-8 0-2 3-2 -130 10.0 9
Aug 14, 2012 box Tue home Cardinals Joe Kelly - R Diamondbacks Ian Kennedy - R 8-2 6 W 1.0 O 9-7 0-2 6-0 -110 9.0 9
Jul 07, 2016 box Thu home Rangers Chi Chi Gonzalez - R Twins Tyler Duffey - R 1-10 -9 L 0.0 P 4-18 0-0 0-10 -114 11.0 9
Jul 19, 2019 box Fri home Pirates Jordan Lyles - R Phillies Jake Arrieta - R 1-6 -5 L -3.0 U 7-15 1-0 1-5 -108 10.0 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
Sep 15, 2020 box Tue home Tigers Matthew Boyd - L Royals Jakob Junis - L 6-0 6 W -3.5 U 14-5 0-0 6-0 -120 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).