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

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 Royals are 22-17 ON since Jul 20, 2021.
SU: 37-33 (-0.01, 52.9%)   avg line: 133.3 / -147.0   on / against: +$1,535 / -$1,966   ROI: +21.6% / -19.2%
RL: 37-32 (1.08, 53.6%)   avg line: -122.4 / 102.2   on / against: -$45 / -$475   ROI: -0.5% / -6.0%
OU: 24-41-4 (-0.25, 36.9%)   avg total: 9.1   over / under: -$1,985 / +$1,560   ROI: -26.2% / +20.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.41 2.23 7.59 8.57 1.28 1.05 2.71 1.11 3.79 13.38 None 0.36 2.56 4.46
Opp 4.43 3.44 8.38 8.13 1.23 0.97 2.49 1.16 3.86 13.85 None 0.54 2.59 4.23
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 20, 2021 box Tue away Royals Mike Minor - L Brewers Brett Anderson - L 5-2 3 W -2.0 U 6-9 1-0 3-1 143 9.0 9
Jul 21, 2021 box Wed away Royals Brad Keller - R Brewers Eric Lauer - L 6-3 3 W 0.0 P 11-6 0-2 3-1 150 9.0 9
Jul 23, 2021 box Fri home Royals Kris Bubic - L Tigers Wily Peralta - R 5-3 2 W -2.5 U 5-8 1-0 4-1 -125 10.5 9
Jul 24, 2021 box Sat home Royals Carlos Hernandez - R Tigers Casey Mize - R 9-8 1 W 6.5 O 11-7 1-1 3-6 -130 10.5 9
Jul 25, 2021 box Sun home Royals Daniel Lynch - L Tigers Tarik Skubal - L 6-1 5 W -3.0 U 8-8 0-0 6-0 -103 10.0 9
Jul 26, 2021 box Mon home Royals Mike Minor - L White Sox Dallas Keuchel - L 4-3 1 W -2.5 U 8-5 0-1 3-0 110 9.5 9
Jul 27, 2021 box Tue home Royals Brad Keller - R White Sox Dylan Cease - R 3-5 -2 L -1.5 U 6-6 0-1 2-2 140 9.5 9
Jul 28, 2021 box Wed home Royals Kris Bubic - L White Sox Lucas Giolito - R 3-2 1 W -4.5 U 6-5 0-1 0-2 162 9.5 10+
Jul 29, 2021 box Thu home Royals Carlos Hernandez - R White Sox Carlos Rodon - L 5-0 5 W -4.0 U 9-5 0-1 5-0 158 9.0 9
Jul 30, 2021 box Fri away Royals Daniel Lynch - L Blue Jays Ross Stripling - R 4-6 -2 L -0.5 U 7-10 0-1 0-4 190 10.5 9
Jul 31, 2021 box Sat away Royals Mike Minor - L Blue Jays Alek Manoah - R 0-4 -4 L -5.5 U 3-5 1-0 0-4 200 9.5 9
Aug 01, 2021 box Sun away Royals Brad Keller - R Blue Jays Jose Berrios - R 1-5 -4 L -3.0 U 6-8 0-0 0-5 240 9.0 9
Aug 03, 2021 box Tue away Royals Kris Bubic - L White Sox Dylan Cease - R 1-7 -6 L -1.0 U 3-5 1-0 0-6 210 9.0 9
Aug 04, 2021 box Wed away Royals Carlos Hernandez - R White Sox Lucas Giolito - R 9-1 8 W 1.5 O 12-4 0-1 8-0 210 8.5 9
Aug 05, 2021 box Thu away Royals Daniel Lynch - L White Sox Dallas Keuchel - L 3-2 1 W -4.5 U 6-6 0-0 2-0 180 9.5 9
Aug 06, 2021 box Fri away Royals Mike Minor - L Cardinals Adam Wainwright - R 2-4 -2 L -2.0 U 7-9 0-0 0-4 162 8.0 9
Aug 07, 2021 box Sat away Royals Brad Keller - R Cardinals Kwang Hyun Kim - L 2-5 -3 L -1.0 U 5-10 0-0 0-3 160 8.0 9
Aug 08, 2021 box Sun away Royals Kris Bubic - L Cardinals Jon Lester - L 6-5 1 W 1 O 9-9 0-2 4-1 125 10 9
Aug 09, 2021 box Mon home Royals Carlos Hernandez - R Yankees Jameson Taillon - R 6-8 -2 L 4.0 O 10-11 2-1 0-1 155 10.0 10+
Aug 10, 2021 box Tue home Royals Daniel Lynch - L Yankees Nestor Cortes Jr - L 8-4 4 W 1.5 O 10-5 0-4 4-1 140 10.5 9
Aug 11, 2021 box Wed home Royals Brady Singer - R Yankees Lucas Luetge - L 2-5 -3 L -3 U 7-12 1-3 0-4 125 10 9
Aug 13, 2021 box Fri home Royals Mike Minor - L Cardinals Jack Flaherty - R 0-6 -6 L -2.5 U 5-10 0-0 0-6 128 8.5 9
Aug 14, 2021 box Sat home Royals Brad Keller - R Cardinals Jon Lester - L 4-9 -5 L 3.0 O 12-12 1-0 1-8 -110 10.0 9
Aug 15, 2021 box Sun home Royals Kris Bubic - L Cardinals JA Happ - L 2-7 -5 L -1.0 U 9-12 0-0 0-7 111 10.0 9
Aug 16, 2021 box Mon home Royals Carlos Hernandez - R Astros Jake Odorizzi - R 7-6 1 W 3.0 O 12-12 0-0 2-1 142 10.0 9
Aug 17, 2021 box Tue home Royals Daniel Lynch - L Astros Framber Valdez - L 3-1 2 W -5.5 U 9-4 0-0 2-1 160 9.5 9
Aug 18, 2021 box Wed home Royals Brady Singer - R Astros Zack Greinke - R 3-2 1 W -4 U 8-10 0-0 1-1 160 9 9
Aug 19, 2021 box Thu home Royals Mike Minor - L Astros Luis Garcia - R 3-6 -3 L 0.0 P 7-10 0-0 3-0 175 9.0 10+
Aug 20, 2021 box Fri away Royals Brad Keller - R Cubs Zach Davies - R 6-2 4 W -0.5 U 8-5 1-0 4-2 -110 8.5 9
Aug 21, 2021 box Sat away Royals Kris Bubic - L Cubs Keegan Thompson - R 4-2 2 W -3.5 U 9-1 0-1 4-0 -105 9.5 9
Aug 22, 2021 box Sun away Royals Carlos Hernandez - R Cubs Alec Mills - R 9-1 8 W 1.0 O 16-5 0-1 8-0 -102 9.0 9
Aug 23, 2021 box Mon away Royals Daniel Lynch - L Astros Zack Greinke - R 7-1 6 W -1.0 U 13-7 1-1 6-0 190 9.0 9
Aug 24, 2021 box Tue away Royals Brady Singer - R Astros Luis Garcia - R 0-4 -4 L -4.5 U 4-8 2-0 0-4 210 8.5 9
Aug 25, 2021 box Wed away Royals Mike Minor - L Astros Lance McCullers Jr - R 5-6 -1 L 2.0 O 7-12 0-0 2-2 225 9.0 10+
Aug 26, 2021 box Thu away Royals Brad Keller - R Mariners Yusei Kikuchi - L 6-4 2 W 2.0 O 8-9 0-1 2-4 155 8.0 9
Aug 27, 2021 box Fri away Royals Kris Bubic - L Mariners Logan Gilbert - R 8-7 1 W 7.0 O 16-11 0-0 1-4 155 8.0 10+
Aug 28, 2021 box Sat away Royals Daniel Lynch - L Mariners Tyler Anderson - L 4-2 2 W -2.5 U 10-11 0-1 3-0 140 8.5 9
Aug 29, 2021 box Sun away Royals Brady Singer - R Mariners Marco Gonzales - L 3-4 -1 L -1.5 U 8-5 1-0 0-2 145 8.5 9
Aug 31, 2021 box Tue home Royals Jakob Junis - R Indians Zach Plesac - R 2-7 -5 L 0.5 O 5-11 0-0 0-7 -115 8.5 9
Sep 01, 2021 box Wed home Royals Mike Minor - L Indians Logan Allen - L 3-5 -2 L -1.0 U 6-8 1-2 3-0 -130 9.0 9
Sep 02, 2021 box Thu home Royals Kris Bubic - L Indians 2-4 -2 L 6-8 1-1 1-3 9
Sep 03, 2021 box Fri home Royals Carlos Hernandez - R White Sox Dallas Keuchel - L 7-2 5 W 0.0 P 12-6 0-1 7-0 120 9.0 9
Sep 04, 2021 box Sat home Royals Daniel Lynch - L White Sox Reynaldo Lopez - R 7-10 -3 L 8.0 O 8-15 1-0 0-6 140 9.0 9
Sep 05, 2021 box Sun home Royals Brady Singer - R White Sox Dylan Cease - R 6-0 6 W -2.5 U 6-6 1-1 6-0 140 8.5 9
Sep 06, 2021 box Mon away Royals Kris Bubic - L Orioles Zac Lowther - L 3-2 1 W -5 U 8-7 0-0 1-1 -115 10 9
Sep 07, 2021 box Tue away Royals Jackson Kowar - R Orioles Alexander Wells - L 3-7 -4 L 0.5 O 8-6 0-2 0-5 -105 9.5 9
Sep 08, 2021 box Wed away Royals Mike Minor - L Orioles Matt Harvey - R 8-9 -1 L 7.5 O 12-11 2-1 5-4 -125 9.5 9
Sep 09, 2021 box Thu away Royals Carlos Hernandez - R Orioles John Means - L 6-0 6 W -3.0 U 10-3 0-0 6-0 107 9.0 9
Sep 10, 2021 box Fri away Royals Daniel Lynch - L Twins Griffin Jax - R 6-4 2 W 0.5 O 8-7 0-1 3-1 120 9.5 9
Sep 11, 2021 box Sat away Royals Brady Singer - R Twins Griffin Jax - R 2-9 -7 L 1.5 O 10-12 0-0 0-8 122 9.5 9
Sep 12, 2021 box Sun away Royals Kris Bubic - L Twins Bailey Ober - R 5-3 2 W -0.5 U 11-6 1-0 2-0 150 8.5 9
Sep 14, 2021 box Tue home Royals Jackson Kowar - R Athletics Frankie Montas - R 10-7 3 W 8.0 O 14-8 0-0 3-6 155 9.0 9
Sep 15, 2021 box Wed home Royals Carlos Hernandez - R Athletics Sean Manaea - L 10-12 -2 L 13.5 O 17-18 1-0 1-7 127 8.5 9
Sep 16, 2021 box Thu home Royals Daniel Lynch - L Athletics Paul Blackburn - R 2-7 -5 L -0.5 U 9-9 1-0 2-5 110 9.5 9
Sep 17, 2021 box Fri home Royals Jon Heasley - R Mariners Chris Flexen - R 2-6 -4 L -1.0 U 9-10 0-0 0-4 110 9.0 9
Sep 18, 2021 box Sat home Royals Kris Bubic - L Mariners Yusei Kikuchi - L 8-1 7 W 0.0 P 15-3 0-1 7-0 -105 9.0 9
Sep 19, 2021 box Sun home Royals Jackson Kowar - R Mariners Logan Gilbert - R 1-7 -6 L -0.5 U 3-11 0-0 0-6 120 8.5 9
Sep 20, 2021 box Mon away Royals Brady Singer - R Indians Triston Mckenzie - R 7-2 5 W 2.0 O 9-6 0-0 7-0 140 7.0 9
Sep 20, 2021 box Mon away Royals Joel Payamps - R Indians Nick Wittgren - R 4-2 2 W -1.5 U 6-4 0-0 3-0 118 7.5 9
Sep 21, 2021 box Tue away Royals Daniel Lynch - L Indians Cal Quantrill - R 1-4 -3 L -4.0 U 9-5 0-0 0-4 145 9.0 9
Sep 24, 2021 box Fri away Royals Carlos Hernandez - R Tigers Casey Mize - R 3-1 2 W -5.0 U 5-6 0-1 2-0 -103 9.0 9
Sep 25, 2021 box Sat away Royals Jon Heasley - R Tigers Tarik Skubal - L 1-5 -4 L -3.0 U 7-11 0-0 1-4 120 9.0 9
Sep 26, 2021 box Sun away Royals Kris Bubic - L Tigers Wily Peralta - R 2-1 1 W -6.0 U 10-5 1-0 2-0 -105 9.0 9
Sep 27, 2021 box Mon away Royals Jackson Kowar - R Indians Cal Quantrill - R 3-8 -5 L 1.5 O 7-10 2-0 1-5 160 9.5 9
Sep 28, 2021 box Tue home Royals Brady Singer - R Indians Aaron Civale - R 6-4 2 W 1.0 O 6-9 0-1 2-3 -105 9.0 9
Sep 29, 2021 box Wed home Royals Daniel Lynch - L Indians Zach Plesac - R 10-5 5 W 6.0 O 11-11 0-1 5-1 -101 9.0 9
Sep 30, 2021 box Thu home Royals Angel Zerpa - L Indians Shane Bieber - R 1-6 -5 L -1 U 10-9 2-0 1-5 140 8 9
Oct 01, 2021 box Fri home Royals Jon Heasley - R Twins John Gant - R 11-6 5 W 7.5 O 15-13 1-0 7-0 105 9.5 9
Oct 02, 2021 box Sat home Royals Kris Bubic - L Twins Griffin Jax - R 0-4 -4 L -5.5 U 3-9 1-0 0-4 -115 9.5 9
Oct 03, 2021 box Sun home Royals Jackson Kowar - R Twins Charlie Barnes - L 3-7 -4 L -0.5 U 9-9 0-1 0-5 102 10.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).