Winning Picks, Guaranteed
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

The Royals are 0-5-1 AGAINST since Jul 07, 2017
SU: 36-42 (-0.91, 46.2%)   avg line: 105.6 / -117.4   on / against: -$681 / +$346   ROI: -7.4% / +3.4%
RL: 32-46 (-0.76, 41.0%)   avg line: -110.5 / -109.8   on / against: -$1,925 / +$1,330   ROI: -19.5% / +13.5%
OU: 36-41-1 (0.52, 46.8%)   avg total: 9.3   over / under: -$840 / +$105   ROI: -9.9% / +1.2%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.45 2.42 6.78 9.29 1.69 1.13 2.24 1.03 3.27 13.83 6.26 1.18 3.37 4.55
Opp 5.36 3.06 7.23 9.45 2.22 1.32 2.85 1.31 4.00 13.90 6.71 0.83 2.71 4.26
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 07, 2017 box Fri away Royals Jason Hammel - R Dodgers Kenta Maeda - R 1-4 -3 L -4.0 U 5-10 0-0 1-3 185 9.0 9
Jul 08, 2017 box Sat away Royals Ian Kennedy - R Dodgers Brandon McCarthy - R 4-5 -1 L 0.0 P 11-8 0-1 1-3 178 9.0 10+
Jul 09, 2017 box Sun away Royals Danny Duffy - L Dodgers Clayton Kershaw - L 2-5 -3 L -0.5 U 6-6 0-0 0-4 275 7.5 9
Jul 14, 2017 box Fri home Royals Jason Hammel - R Rangers Martin Perez - L 3-5 -2 L -1.5 U 8-7 1-0 3-2 -115 9.5 9
Jul 15, 2017 box Sat home Royals Danny Duffy - L Rangers Cole Hamels - L 0-1 -1 L -8.0 U 4-5 0-0 0-1 -120 9.0 9
Jul 16, 2017 box Sun home Royals Ian Kennedy - R Rangers Yu Darvish - R 4-3 1 W -1.5 U 10-7 0-2 1-0 110 8.5 9
Jul 17, 2017 box Mon home Royals Jason Vargas - L Tigers Jordan Zimmermann - R 2-10 -8 L 2.0 O 8-14 1-0 0-8 -145 10.0 9
Jul 18, 2017 box Tue home Royals Travis Wood - L Tigers Matthew Boyd - L 3-9 -6 L 1.5 O 10-16 1-0 3-6 -112 10.5 9
Jul 19, 2017 box Wed home Royals Jason Hammel - R Tigers Justin Verlander - R 4-3 1 W -3.0 U 8-7 0-0 1-1 -103 10.0 9
Jul 20, 2017 box Thu home Royals Danny Duffy - L Tigers Michael Fulmer - R 16-4 12 W 11.0 O 19-11 0-3 12-0 -102 9.0 9
Jul 21, 2017 box Fri home Royals Ian Kennedy - R White Sox James Shields - R 7-6 1 W 2.5 O 14-10 3-0 1-4 -178 10.5 10+
Jul 22, 2017 box Sat home Royals Jason Vargas - L White Sox Mike Pelfrey - R 7-2 5 W -1.0 U 9-8 0-0 5-2 -180 10.0 9
Jul 23, 2017 box Sun home Royals Travis Wood - L White Sox Derek Holland - L 5-4 1 W -1.5 U 8-10 0-0 3-1 -135 10.5 9
Jul 24, 2017 box Mon away Royals Jason Hammel - R Tigers Justin Verlander - R 5-3 2 W -1.0 U 8-7 0-0 3-0 128 9.0 10+
Jul 25, 2017 box Tue away Royals Danny Duffy - L Tigers Michael Fulmer - R 3-1 2 W -4.5 U 8-8 0-0 3-0 110 8.5 9
Jul 26, 2017 box Wed away Royals Ian Kennedy - R Tigers Anibal Sanchez - R 16-2 14 W 8.0 O 22-7 1-0 14-0 100 10.0 9
Jul 28, 2017 box Fri away Royals Jason Vargas - L Red Sox Rick Porcello - R 4-2 2 W -3.5 U 8-7 0-0 4-0 145 9.5 9
Jul 29, 2017 box Sat away Royals Trevor Cahill - R Red Sox Eduardo Rodriguez - L 8-9 -1 L 7.5 O 14-13 1-3 2-2 140 9.5 10+
Jul 30, 2017 box Sun away Royals Jason Hammel - R Red Sox Drew Pomeranz - L 5-3 2 W -1.0 U 12-9 1-2 2-2 155 9.0 9
Jul 31, 2017 box Mon away Royals Danny Duffy - L Orioles Ubaldo Jimenez - R 1-2 -1 L -6.5 U 5-10 0-1 1-1 -106 9.5 9
Aug 01, 2017 box Tue away Royals Ian Kennedy - R Orioles Dylan Bundy - R 2-7 -5 L -1.0 U 5-15 0-1 0-6 114 10.0 9
Aug 02, 2017 box Wed away Royals Jason Vargas - L Orioles Jeremy Hellickson - R 0-6 -6 L -4.0 U 5-7 0-0 0-6 120 10.0 9
Aug 03, 2017 box Thu home Royals Trevor Cahill - R Mariners Yovani Gallardo - R 6-4 2 W 0.5 O 8-10 1-1 3-2 -135 9.5 9
Aug 04, 2017 box Fri home Royals Jason Hammel - R Mariners James Paxton - L 2-5 -3 L -1.0 U 4-9 0-0 1-3 157 8.0 9
Aug 06, 2017 box Sun home Royals Danny Duffy - L Mariners Marco Gonzales - L 7-8 -1 L 6.0 O 10-11 0-0 0-7 -138 9.0 9
Aug 06, 2017 box Sun home Royals Jake Junis - ? Mariners Erasmo Ramirez - R 9-1 8 W 0.5 O 13-4 0-1 8-1 -108 9.5 9
Aug 07, 2017 box Mon home Royals Ian Kennedy - R Cardinals Carlos Martinez - R 3-11 -8 L 5.0 O 8-10 2-0 0-9 115 9.0 9
Aug 08, 2017 box Tue home Royals Jason Vargas - L Cardinals Michael Wacha - R 3-10 -7 L 4.0 O 6-14 1-0 2-7 120 9.0 9
Aug 09, 2017 box Wed away Royals Trevor Cahill - R Cardinals Mike Leake - R 5-8 -3 L 4.5 O 15-11 1-1 3-3 132 8.5 9
Aug 10, 2017 box Thu away Royals Jason Hammel - R Cardinals Lance Lynn - R 6-8 -2 L 5.0 O 12-9 3-1 3-4 135 9.0 9
Aug 11, 2017 box Fri away Royals Danny Duffy - L White Sox Reynaldo Lopez - R 3-6 -3 L -0.5 U 7-9 1-0 0-4 -135 9.5 9
Aug 12, 2017 box Sat away Royals Ian Kennedy - R White Sox James Shields - R 5-4 1 W -1.0 U 10-9 0-0 3-1 -150 10.0 9
Aug 13, 2017 box Sun away Royals Jason Vargas - L White Sox Derek Holland - L 14-6 8 W 9.5 O 16-9 1-2 9-0 -137 10.5 9
Aug 14, 2017 box Mon away Royals Jake Junis - ? Athletics Jharel Cotton - R 6-2 4 W -1.0 U 10-5 1-0 5-0 -103 9.0 9
Aug 15, 2017 box Tue away Royals Jason Hammel - R Athletics Chris Smith - R 8-10 -2 L 9.0 O 8-14 0-0 4-2 -117 9.0 9
Aug 16, 2017 box Wed away Royals Danny Duffy - L Athletics Paul Blackburn - R 7-6 1 W 3.5 O 14-12 1-1 3-1 -125 9.5 9
Aug 18, 2017 box Fri home Royals Ian Kennedy - R Indians Corey Kluber - R 1-10 -9 L 2.5 O 9-13 0-0 0-9 190 8.5 9
Aug 19, 2017 box Sat home Royals Jason Vargas - L Indians Trevor Bauer - R 0-5 -5 L -4.5 U 7-9 0-0 0-5 130 9.5 9
Aug 20, 2017 box Sun home Royals Jason Hammel - R Indians Danny Salazar - R 7-4 3 W 2.0 O 15-8 1-0 4-1 155 9.0 9
Aug 22, 2017 box Tue home Royals Danny Duffy - L Rockies Jon Gray - R 3-2 1 W -3.5 U 6-2 1-1 3-0 -125 8.5 9
Aug 23, 2017 box Wed home Royals Ian Kennedy - R Rockies Antonio Senzatela - R 6-4 2 W 0.5 O 14-9 0-1 2-2 -125 9.5 9
Aug 24, 2017 box Thu home Royals Jake Junis - ? Rockies German Marquez - R 2-3 -1 L -3.5 U 9-11 0-0 2-1 -109 8.5 9
Aug 25, 2017 box Fri away Royals Jason Vargas - L Indians Ryan Merritt - L 0-4 -4 L -5.5 U 8-10 1-1 0-4 125 9.5 9
Aug 26, 2017 box Sat away Royals Jason Hammel - R Indians Mike Clevinger - R 0-4 -4 L -5.0 U 4-6 1-1 0-4 142 9.0 9
Aug 27, 2017 box Sun away Royals Eric Skoglund - L Indians Carlos Carrasco - R 0-12 -12 L 3.0 O 6-17 1-0 0-12 210 9.0 9
Aug 28, 2017 box Mon home Royals Ian Kennedy - R Rays Austin Pruitt - R 0-12 -12 L 2.0 O 2-12 0-0 0-12 -105 10.0 9
Aug 29, 2017 box Tue home Royals Jake Junis - ? Rays Alex Cobb - R 6-2 4 W -1.0 U 10-5 0-1 4-0 -107 9.0 9
Aug 30, 2017 box Wed home Royals Jason Vargas - L Rays Jake Odorizzi - R 3-5 -2 L -1.5 U 5-8 0-0 0-3 -127 9.5 9
Sep 01, 2017 box Fri away Royals Jason Hammel - R Twins Dillon Gee - R 7-6 1 W 3.5 O 12-9 1-0 4-2 -105 9.5 9
Sep 02, 2017 box Sat away Royals Onelki Garcia - L Twins Kyle Gibson - R 0-17 -17 L 7.0 O 7-14 0-0 0-17 130 10.0 9
Sep 03, 2017 box Sun away Royals Ian Kennedy - R Twins Ervin Santana - R 5-4 1 W -0.5 U 9-5 3-0 1-1 145 9.5 9
Sep 04, 2017 box Mon away Royals Jake Junis - ? Tigers Artie Lewicki - R 7-6 1 W 3.5 O 16-12 2-0 5-0 -150 9.5 9
Sep 05, 2017 box Tue away Royals Jason Vargas - L Tigers Anibal Sanchez - R 2-13 -11 L 5.0 O 5-15 0-1 1-11 -120 10.0 9
Sep 06, 2017 box Wed away Royals Jason Hammel - R Tigers Matthew Boyd - L 13-2 11 W 5.5 O 18-10 1-0 11-0 -142 9.5 9
Sep 07, 2017 box Thu home Royals Sam Gaviglio - R Twins Kyle Gibson - R 2-4 -2 L -3.5 U 9-10 0-0 1-2 100 9.5 9
Sep 08, 2017 box Fri home Royals Ian Kennedy - R Twins Ervin Santana - R 5-8 -3 L 4.0 O 9-10 1-0 0-4 115 9.0 9
Sep 09, 2017 box Sat home Royals Jake Junis - ? Twins Jose Berrios - R 5-2 3 W -2.0 U 11-9 0-0 3-1 -105 9.0 9
Sep 10, 2017 box Sun home Royals Jason Vargas - L Twins Bartolo Colon - R 11-3 8 W 4.0 O 17-8 1-0 10-1 -135 10.0 9
Sep 11, 2017 box Mon home Royals Jason Hammel - R White Sox Reynaldo Lopez - R 3-11 -8 L 5.0 O 9-17 1-0 0-8 -175 9.0 9
Sep 12, 2017 box Tue home Royals Sam Gaviglio - R White Sox Dylan Covey - R 4-3 1 W -3.0 U 4-13 0-0 4-0 -190 10.0 9
Sep 13, 2017 box Wed home Royals Eric Skoglund - L White Sox Lucas Giolito - R 3-5 -2 L -2.0 U 8-10 0-1 0-3 -145 10.0 9
Sep 14, 2017 box Thu away Royals Jakob Junis - R Indians Josh Tomlin - R 2-3 -1 L -4.0 U 9-12 0-0 1-1 178 9.0 10+
Sep 15, 2017 box Fri away Royals Jason Vargas - L Indians Trevor Bauer - R 4-3 1 W -2.5 U 11-6 0-1 1-2 190 9.5 9
Sep 16, 2017 box Sat away Royals Jason Hammel - R Indians Carlos Carrasco - R 4-8 -4 L 3.5 O 9-13 1-0 0-5 210 8.5 9
Sep 17, 2017 box Sun away Royals Danny Duffy - L Indians Corey Kluber - R 2-3 -1 L -2.5 U 7-3 2-1 0-3 220 7.5 9
Sep 19, 2017 box Tue away Royals Ian Kennedy - R Blue Jays Marcus Stroman - R 2-5 -3 L -2.0 U 6-8 1-0 0-4 160 9.0 9
Sep 20, 2017 box Wed away Royals Jakob Junis - R Blue Jays Brett Anderson - L 15-5 10 W 10.5 O 18-6 1-1 13-0 105 9.5 9
Sep 21, 2017 box Thu away Royals Jason Vargas - L Blue Jays JA Happ - L 1-0 1 W -8.0 U 8-2 0-1 1-0 140 9.0 9
Sep 22, 2017 box Fri away Royals Jason Hammel - R White Sox Reynaldo Lopez - R 6-7 -1 L 3.0 O 13-10 1-2 4-2 -135 10.0 9
Sep 23, 2017 box Sat away Royals Danny Duffy - L White Sox Dylan Covey - R 8-2 6 W 0.5 O 12-8 0-0 6-1 -175 9.5 9
Sep 24, 2017 box Sun away Royals Ian Kennedy - R White Sox Lucas Giolito - R 1-8 -7 L -0.5 U 5-10 3-1 0-7 -110 9.5 9
Sep 25, 2017 box Mon away Royals Jakob Junis - R Yankees CC Sabathia - L 3-11 -8 L 5.0 O 6-15 1-0 0-8 185 9.0 9
Sep 26, 2017 box Tue home Royals Jason Vargas - L Tigers Anibal Sanchez - R 2-1 1 W -6.0 U 8-6 0-0 1-1 -170 9.0 9
Sep 27, 2017 box Wed home Royals Jason Hammel - R Tigers Jordan Zimmermann - R 7-4 3 W 2.0 O 9-10 0-0 4-3 -172 9.0 9
Sep 28, 2017 box Thu home Royals Danny Duffy - L Tigers Daniel Norris - L 1-4 -3 L -3.5 U 5-8 0-0 0-4 -185 8.5 9
Sep 29, 2017 box Fri home Royals Ian Kennedy - R Diamondbacks Zack Greinke - R 2-1 1 W -6.0 U 9-6 0-0 1-0 135 9.0 9
Sep 30, 2017 box Sat home Royals Jakob Junis - R Diamondbacks Taijuan Walker - R 4-3 1 W -2.0 U 7-8 0-0 2-1 -105 9.0 9
Oct 01, 2017 box Sun home Royals Jason Vargas - L Diamondbacks Robbie Ray - L 2-14 -12 L 7.0 O 6-16 1-3 1-12 115 9.0 9

Game Parameters: at bats, attendance, biggest lead, 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, 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).