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 23-38-1 AGAINST since Sep 28, 2019.
SU: 27-35 (-0.39, 43.5%)   avg line: 141.8 / -156.3   on / against: +$235 / -$545   ROI: +3.6% / -5.5%
RL: 33-29 (0.68, 53.2%)   avg line: -115.5 / -104.1   on / against: $0 / -$560   ROI: 0.0% / -7.9%
OU: 23-38-1 (-0.38, 37.7%)   avg total: 9.0   over / under: -$1,931 / +$1,365   ROI: -27.7% / +20.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.13 2.87 8.84 8.11 1.60 1.02 2.45 0.97 2.98 13.87 None 0.61 2.60 4.89
Opp 4.52 3.42 8.56 8.29 1.35 1.24 2.37 1.16 4.35 14.13 None 1.02 2.29 4.56
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 28, 2019 box Sat home Royals Glenn Sparkman - R Twins Cody Stashak - R 3-4 -1 L -3.5 U 7-9 0-0 1-2 175 10.5 9
Sep 29, 2019 box Sun home Royals Jorge Lopez - R Twins Martin Perez - L 5-4 1 W -2.0 U 9-6 0-0 1-3 125 11.0 9
Jul 24, 2020 box Fri away Royals Danny Duffy - L Indians Shane Bieber - R 0-2 -2 L -6.0 U 4-5 0-0 0-2 185 8.0 9
Jul 25, 2020 box Sat away Royals Brady Singer - R Indians Mike Clevinger - R 3-2 1 W -4.0 U 5-4 0-0 2-0 200 9.0 10+
Jul 26, 2020 box Sun away Royals Ronald Bolanos - R Indians Carlos Carrasco - R 2-9 -7 L 2.0 O 6-13 2-0 0-7 190 9.0 9
Jul 27, 2020 box Mon away Royals Mike Montgomery - L Tigers Michael Fulmer - R 14-6 8 W 10.5 O 13-9 2-0 8-4 110 9.5 9
Jul 28, 2020 box Tue away Royals Kyle Zimmer - R Tigers Rony Garcia - R 3-4 -1 L -3.5 U 5-6 1-3 3-1 100 10.5 9
Jul 29, 2020 box Wed away Royals Danny Duffy - L Tigers Matthew Boyd - L 4-5 -1 L -1.0 U 9-4 1-0 4-1 118 10.0 9
Jul 30, 2020 box Thu away Royals Brady Singer - R Tigers Ivan Nova - R 5-3 2 W -2.0 U 13-8 0-1 3-0 -135 10.0 9
Jul 31, 2020 box Fri home Royals Kris Bubic - L White Sox Dallas Keuchel - L 2-3 -1 L -4.5 U 8-4 2-1 0-3 155 9.5 9
Aug 01, 2020 box Sat home Royals Ronald Bolanos - R White Sox Gio Gonzalez - L 5-11 -6 L 5.5 O 15-21 4-0 0-7 128 10.5 9
Aug 02, 2020 box Sun home Royals Jakob Junis - R White Sox Dylan Cease - R 2-9 -7 L 0.5 O 6-14 2-0 1-7 110 10.5 9
Aug 03, 2020 box Mon away Royals Danny Duffy - L Cubs Alec Mills - R 0-2 -2 L -6.0 U 5-4 0-0 0-2 135 8.0 9
Aug 04, 2020 box Tue away Royals Brady Singer - R Cubs Kyle Hendricks - R 4-5 -1 L 1.0 O 10-9 0-1 1-3 175 8.0 9
Aug 05, 2020 box Wed home Royals Kris Bubic - L Cubs Yu Darvish - R 1-6 -5 L -2.0 U 5-10 2-1 1-5 175 9.0 9
Aug 06, 2020 box Thu home Royals Brad Keller - R Cubs Tyler Chatwood - R 13-2 11 W 6.0 O 18-7 0-0 13-0 155 9.0 9
Aug 07, 2020 box Fri home Royals Jakob Junis - R Twins Devin Smeltzer - L 3-2 1 W -4.5 U 8-5 0-0 1-1 140 9.5 9
Aug 08, 2020 box Sat home Royals Danny Duffy - L Twins Jake Odorizzi - R 9-6 3 W 5.5 O 12-9 0-0 4-2 145 9.5 9
Aug 09, 2020 box Sun home Royals Brady Singer - R Twins Jose Berrios - R 4-2 2 W -3.5 U 8-7 1-0 2-0 155 9.5 9
Aug 11, 2020 box Tue away Royals Kris Bubic - L Reds Tyler Mahle - R 5-6 -1 L 2.5 O 11-10 0-3 0-4 165 8.5 10+
Aug 12, 2020 box Wed away Royals Brad Keller - R Reds Wade Miley - L 5-4 1 W -0.5 U 5-6 0-0 5-0 105 9.5 9
Aug 15, 2020 box Sat away Royals Ian Kennedy - R Twins Jake Odorizzi - R 2-4 -2 L -2.0 U 5-8 1-0 0-3 170 8.0 7
Aug 15, 2020 box Sat away Royals Danny Duffy - L Twins Jose Berrios - R 4-2 2 W -1.5 U 8-2 1-0 3-1 170 7.5 7
Aug 16, 2020 box Sun away Royals Brady Singer - R Twins Randy Dobnak - R 2-4 -2 L -3.0 U 5-6 0-0 2-2 175 9.0 9
Aug 17, 2020 box Mon away Royals Kris Bubic - L Twins Matt Wisler - R 1-4 -3 L -4.5 U 7-9 0-0 0-4 160 9.5 9
Aug 19, 2020 box Wed home Royals Brad Keller - R Reds Luis Castillo - R 4-0 4 W -2.5 U 7-3 0-1 4-0 140 6.5 7
Aug 19, 2020 box Wed home Royals Matt Harvey - R Reds Trevor Bauer - R 0-5 -5 L -1.5 U 1-7 0-0 0-5 180 6.5 7
Aug 21, 2020 box Fri home Royals Danny Duffy - L Twins Jake Odorizzi - R 7-2 5 W 0.5 O 10-6 0-0 6-0 130 8.5 9
Aug 22, 2020 box Sat home Royals Brady Singer - R Twins Randy Dobnak - R 2-7 -5 L 0.0 P 10-10 0-2 0-5 150 9.0 9
Aug 23, 2020 box Sun home Royals Kris Bubic - L Twins Matt Wisler - R 4-5 -1 L -1.0 U 9-13 0-1 0-4 135 10.0 9
Aug 24, 2020 box Mon away Royals Brad Keller - R Cardinals Jack Flaherty - R 3-9 -6 L 4.0 O 4-12 0-3 0-6 160 8.0 9
Aug 25, 2020 box Tue away Royals Matt Harvey - R Cardinals Adam Wainwright - R 5-4 1 W -0.5 U 10-8 1-1 2-2 175 9.5 9
Aug 26, 2020 box Wed away Royals Jakob Junis - R Cardinals Dakota Hudson - R 5-6 -1 L 2.0 O 7-9 1-1 3-1 170 9.0 9
Aug 28, 2020 box Fri away Royals Danny Duffy - L White Sox Reynaldo Lopez - R 5-6 -1 L 1.5 O 11-11 0-1 1-2 135 9.5 9
Aug 29, 2020 box Sat away Royals Brady Singer - R White Sox Dylan Cease - R 9-6 3 W 5.5 O 11-10 2-0 6-2 150 9.5 9
Aug 30, 2020 box Sun away Royals Kris Bubic - L White Sox Dane Dunning - R 2-5 -3 L -3.0 U 5-8 1-0 0-2 175 10.0 9
Aug 31, 2020 box Mon home Royals Brad Keller - R Indians Shane Bieber - R 2-1 1 W -4.5 U 4-6 0-0 1-1 210 7.5 9
Sep 01, 2020 box Tue home Royals Jakob Junis - R Indians Zach Plesac - R 1-10 -9 L 2.0 O 7-17 0-0 0-9 180 9.0 9
Sep 02, 2020 box Wed home Royals Jakob Junis - R Indians Triston Mckenzie - R 0-5 -5 L -4.0 U 3-10 0-0 0-5 150 9.0 9
Sep 03, 2020 box Thu home Royals Danny Duffy - L White Sox Dylan Cease - R 6-11 -5 L 7.5 O 9-13 0-1 1-7 132 9.5 9
Sep 04, 2020 box Fri home Royals Brady Singer - R White Sox Dane Dunning - R 4-7 -3 L 1.5 O 9-14 2-0 0-4 155 9.5 9
Sep 05, 2020 box Sat home Royals Kris Bubic - L White Sox Lucas Giolito - R 3-5 -2 L -1.0 U 6-5 1-0 0-4 195 9.0 9
Sep 06, 2020 box Sun home Royals Matt Harvey - R White Sox Dallas Keuchel - L 2-8 -6 L -0.5 U 8-13 0-2 0-6 200 10.5 9
Sep 07, 2020 box Mon away Royals Brad Keller - R Indians Zach Plesac - R 2-5 -3 L -1.5 U 9-8 2-0 0-4 180 8.5 9
Sep 08, 2020 box Tue away Royals Jakob Junis - R Indians Triston Mckenzie - R 8-6 2 W 5.0 O 10-9 0-1 3-3 195 9.0 9
Sep 09, 2020 box Wed away Royals Danny Duffy - L Indians Carlos Carrasco - R 3-0 3 W -5.0 U 10-6 0-2 3-0 195 8.0 9
Sep 10, 2020 box Thu away Royals Brady Singer - R Indians Aaron Civale - R 11-1 10 W 4.0 O 13-3 0-0 11-0 180 8.0 9
Sep 11, 2020 box Fri home Royals Kris Bubic - L Pirates Steven Brault - L 4-3 1 W -2.0 U 7-7 0-0 3-0 -140 9.0 9
Sep 12, 2020 box Sat home Royals Carlos Hernandez - R Pirates Trevor Williams - R 7-4 3 W 2.0 O 13-8 0-1 4-2 -120 9.0 9
Sep 13, 2020 box Sun home Royals Brad Keller - R Pirates Chad Kuhl - R 11-0 11 W 2.5 O 12-5 0-1 11-0 -145 8.5 9
Sep 15, 2020 box Tue away Royals Jakob Junis - L Tigers Matthew Boyd - L 0-6 -6 L -3.5 U 5-14 0-0 0-6 100 9.5 9
Sep 16, 2020 box Wed away Royals Brady Singer - R Tigers Tarik Skubal - L 4-0 4 W -5.0 U 6-2 0-2 4-0 -123 9.0 9
Sep 18, 2020 box Fri away Royals Danny Duffy - L Brewers Adrian Houser - R 5-9 -4 L 5.0 O 11-14 0-2 4-5 150 9.0 9
Sep 19, 2020 box Sat away Royals Kris Bubic - L Brewers Corbin Burnes - R 0-5 -5 L -3.5 U 4-4 2-1 0-5 190 8.5 9
Sep 20, 2020 box Sun away Royals Brad Keller - R Brewers Josh Lindblom - R 3-5 -2 L -0.5 U 6-7 0-0 0-4 150 8.5 9
Sep 21, 2020 box Mon home Royals Carlos Hernandez - R Cardinals Adam Wainwright - R 4-1 3 W -4.0 U 8-6 0-0 3-1 170 9.0 9
Sep 22, 2020 box Tue home Royals Brady Singer - R Cardinals Austin Gomber - L 0-5 -5 L -4.0 U 6-7 0-2 0-5 102 9.0 9
Sep 23, 2020 box Wed home Royals Danny Duffy - L Cardinals Carlos Martinez - R 12-3 9 W 6.0 O 14-9 0-0 11-0 115 9.0 9
Sep 24, 2020 box Thu home Royals Jorge Lopez - L Tigers Michael Fulmer - R 8-7 1 W 5.5 O 11-14 0-0 4-0 -165 9.5 9
Sep 25, 2020 box Fri home Royals Brad Keller - R Tigers Spencer Turnbull - R 3-2 1 W -3.5 U 8-8 0-2 3-0 -150 8.5 9
Sep 26, 2020 box Sat home Royals Carlos Hernandez - R Tigers Matthew Boyd - L 3-4 -1 L -2.5 U 7-10 1-1 0-3 -130 9.5 9
Sep 27, 2020 box Sun home Royals Brady Singer - R Tigers Jordan Zimmermann - R 3-1 2 W -4.0 U 5-3 0-0 2-1 -170 8.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).