Information you need to win
S p o r t s D a t a b a s e . c o m
sdql access to blockchain sports data


name
password


MLB Sport Data Query Language Access. SDB Home     MLB Trends     MLB Query
Numerical options: SU | OU | RL | Invested

The Pirates are 6-2 ON since Sep 23, 2017
SU: 42-42 (0.13, 50.0%)   avg line: -100.0 / -111.0   on / against: +$12 / -$408   ROI: +0.1% / -4.0%
RL: 41-43 (0.27, 48.8%)   avg line: -125.2 / -112.0   on / against: -$565 / +$120   ROI: -4.5% / +1.1%
OU: 37-40-7 (0.80, 48.1%)   avg total: 8.3   over / under: -$580 / -$105   ROI: -6.4% / -1.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.63 3.29 7.54 8.45 1.98 0.98 2.43 1.18 3.57 13.80 6.67 0.83 2.80 4.13
Opp 4.50 3.11 8.32 8.60 2.02 1.06 2.36 1.24 3.71 15.19 6.88 0.77 2.68 4.37
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 23, 2017 box Sat home Pirates Gerrit Cole - R Cardinals Lance Lynn - R 11-6 5 W 9.0 O 14-9 2-0 7-2 -115 8.0 9
Sep 24, 2017 box Sun home Pirates Jameson Taillon - R Cardinals John Gant - R 4-1 3 W -4.0 U 8-4 0-1 3-1 100 9.0 9
Sep 26, 2017 box Tue home Pirates Trevor Williams - R Orioles Kevin Gausman - R 10-1 9 W 2.5 O 11-5 0-1 9-0 102 8.5 9
Sep 27, 2017 box Wed home Pirates Chad Kuhl - R Orioles Gabriel Ynoa - R 5-3 2 W -1.0 U 9-10 0-0 2-2 -130 9.0 9
Sep 28, 2017 box Thu away Pirates Ivan Nova - R Nationals Edwin Jackson - R 4-5 -1 L 0.0 P 6-11 0-0 1-2 120 9.0 9
Sep 29, 2017 box Fri away Pirates Gerrit Cole - R Nationals Stephen Strasburg - R 1-6 -5 L -0.5 U 4-12 0-1 0-6 180 7.5 9
Sep 30, 2017 box Sat away Pirates Jameson Taillon - R Nationals Max Scherzer - R 4-1 3 W -2.0 U 5-4 0-0 3-1 210 7.0 9
Oct 01, 2017 box Sun away Pirates Steven Brault - L Nationals Gio Gonzalez - L 11-6 5 W 9.0 O 14-14 2-0 5-0 155 8.0 9
Mar 30, 2018 box Fri away Pirates Ivan Nova - R Tigers Jordan Zimmermann - R 13-10 3 W 13.5 O 17-14 2-3 4-2 -120 9.5 10+
Apr 01, 2018 box Sun away Pirates Trevor Williams - R Tigers Michael Fulmer - R 1-0 1 W -7.0 U 6-2 0-0 1-0 -101 8.0 9
Apr 01, 2018 box Sun away Pirates Chad Kuhl - R Tigers Ryan Carpenter - L 8-6 2 W 5.0 O 10-12 0-0 5-2 -118 9.0 9
Apr 02, 2018 box Mon home Pirates Jameson Taillon - R Twins Lance Lynn - R 5-4 1 W 0.5 O 5-7 0-0 5-0 -133 8.5 9
Apr 04, 2018 box Wed home Pirates Ivan Nova - R Twins Jake Odorizzi - R 3-7 -4 L 1.5 O 8-9 0-0 2-4 -108 8.5 9
Apr 05, 2018 box Thu home Pirates Steven Brault - L Reds Homer Bailey - R 5-2 3 W -1.5 U 9-5 0-1 4-1 -145 8.5 9
Apr 06, 2018 box Fri home Pirates Trevor Williams - R Reds Luis Castillo - R 14-3 11 W 9.0 O 15-13 1-1 12-0 108 8.0 9
Apr 07, 2018 box Sat home Pirates Chad Kuhl - R Reds Sal Romano - R 4-7 -3 L 2.5 O 8-11 0-1 4-3 -125 8.5 9
Apr 08, 2018 box Sun home Pirates Jameson Taillon - R Reds Tyler Mahle - R 5-0 5 W -2.5 U 11-1 0-0 5-0 -150 7.5 9
Apr 10, 2018 box Tue away Pirates Ivan Nova - R Cubs Tyler Chatwood - R 8-5 3 W 4.0 O 12-10 1-0 6-1 140 9.0 9
Apr 11, 2018 box Wed away Pirates Steven Brault - L Cubs Jon Lester - L 5-13 -8 L 9.5 O 8-16 0-0 3-8 165 8.5 9
Apr 12, 2018 box Thu away Pirates Trevor Williams - R Cubs Kyle Hendricks - R 6-1 5 W -1.5 U 9-7 0-1 5-0 160 8.5 9
Apr 13, 2018 box Fri away Pirates Chad Kuhl - R Marlins Dillon Peters - L 2-7 -5 L 1.0 O 5-14 1-0 1-5 -130 8.0 9
Apr 14, 2018 box Sat away Pirates Jameson Taillon - R Marlins Trevor Richards - R 1-0 1 W -6.5 U 5-6 0-0 1-0 -190 7.5 9
Apr 15, 2018 box Sun away Pirates Ivan Nova - R Marlins Jose Urena - R 7-3 4 W 1.5 O 13-7 1-0 5-1 -140 8.5 9
Apr 16, 2018 box Mon home Pirates Steven Brault - L Rockies German Marquez - R 2-6 -4 L -0.5 U 4-7 0-1 0-5 -120 8.5 9
Apr 17, 2018 box Tue home Pirates Trevor Williams - R Rockies Chad Bettis - R 0-2 -2 L -6.0 U 5-5 0-0 0-2 -135 8.0 9
Apr 18, 2018 box Wed home Pirates Chad Kuhl - R Rockies Kyle Freeland - L 10-2 8 W 3.5 O 13-7 0-0 8-1 -123 8.5 9
Apr 19, 2018 box Thu away Pirates Jameson Taillon - R Phillies Jake Arrieta - R 0-7 -7 L -0.5 U 2-9 0-0 0-7 -105 7.5 9
Apr 20, 2018 box Fri away Pirates Ivan Nova - R Phillies Ben Lively - R 1-2 -1 L -5.0 U 6-8 0-0 1-1 100 8.0 9
Apr 21, 2018 box Sat away Pirates Steven Brault - L Phillies Aaron Nola - R 2-6 -4 L 0.0 P 8-7 2-0 2-4 165 8.0 9
Apr 22, 2018 box Sun away Pirates Trevor Williams - R Phillies Nick Pivetta - R 2-3 -1 L -3.0 U 7-8 2-2 2-1 120 8.0 10+
Apr 25, 2018 box Wed home Pirates Jameson Taillon - R Tigers Jordan Zimmermann - R 10-13 -3 L 15.5 O 14-20 2-1 3-5 -200 7.5 9
Apr 25, 2018 box Wed home Pirates Chad Kuhl - R Tigers Matthew Boyd - L 8-3 5 W 3.0 O 15-7 0-1 5-0 -160 8.0 9
Apr 26, 2018 box Thu home Pirates Ivan Nova - R Tigers Michael Fulmer - R 1-0 1 W -7.0 U 6-8 1-0 1-0 -155 8.0 9
Apr 27, 2018 box Fri home Pirates Steven Brault - L Cardinals Miles Mikolas - R 6-5 1 W 2.5 O 11-7 1-2 1-5 120 8.5 10+
Apr 28, 2018 box Sat home Pirates Trevor Williams - R Cardinals Jack Flaherty - R 6-2 4 W 0.0 P 9-5 1-2 4-1 110 8.0 9
Apr 29, 2018 box Sun home Pirates Nick Kingham - R Cardinals Luke Weaver - R 5-0 5 W -3.0 U 10-3 0-0 5-0 120 8.0 9
Apr 30, 2018 box Mon away Pirates Jameson Taillon - R Nationals Tanner Roark - R 2-3 -1 L -2.5 U 6-9 1-0 0-3 110 7.5 9
May 01, 2018 box Tue away Pirates Chad Kuhl - R Nationals Max Scherzer - R 4-12 -8 L 8.5 O 8-10 2-0 0-12 210 7.5 9
May 02, 2018 box Wed away Pirates Ivan Nova - R Nationals Stephen Strasburg - R 3-9 -6 L 4.0 O 9-14 1-1 1-6 180 8.0 9
May 03, 2018 box Thu away Pirates Trevor Williams - R Nationals Jeremy Hellickson - R 1-3 -2 L -5.5 U 5-4 0-1 0-3 122 9.5 9
May 04, 2018 box Fri away Pirates Nick Kingham - R Brewers Junior Guerra - R 6-4 2 W 1.5 O 9-9 0-1 4-0 108 8.5 9
May 05, 2018 box Sat away Pirates Jameson Taillon - R Brewers Jhoulys Chacin - R 3-5 -2 L -0.5 U 4-9 0-0 0-2 -107 8.5 9
May 06, 2018 box Sun away Pirates Chad Kuhl - R Brewers Chase Anderson - R 9-0 9 W 0.0 P 13-2 0-1 9-0 120 9.0 9
May 08, 2018 box Tue away Pirates Ivan Nova - R White Sox Lucas Giolito - R 10-6 4 W 6.5 O 16-11 0-0 5-4 -140 9.5 9
May 09, 2018 box Wed away Pirates Trevor Williams - R White Sox Reynaldo Lopez - R 6-5 1 W 1.0 O 7-10 0-0 1-4 -114 10.0 9
May 11, 2018 box Fri home Pirates Jameson Taillon - R Giants Andrew Suarez - L 11-2 9 W 5.0 O 15-9 2-0 9-0 -130 8.0 9
May 12, 2018 box Sat home Pirates Chad Kuhl - R Giants Jeff Samardzija - R 6-5 1 W 2.5 O 8-10 0-0 2-1 -126 8.5 9
May 13, 2018 box Sun home Pirates Ivan Nova - R Giants Derek Holland - L 0-5 -5 L -3.5 U 7-13 0-0 0-5 -150 8.5 9
May 15, 2018 box Tue home Pirates Trevor Williams - R White Sox Reynaldo Lopez - R 7-0 7 W -2.0 U 10-7 0-0 7-0 -145 9.0 9
May 16, 2018 box Wed home Pirates Jameson Taillon - R White Sox Hector Santiago - L 3-2 1 W -3.0 U 4-8 0-1 1-1 -175 8.0 9
May 17, 2018 box Thu home Pirates Chad Kuhl - R Padres Eric Lauer - L 5-4 1 W 0.5 O 9-9 0-1 1-2 -145 8.5 9
May 18, 2018 box Fri home Pirates Ivan Nova - R Padres Tyson Ross - R 2-3 -1 L -2.5 U 8-6 1-0 2-1 -120 7.5 9
May 19, 2018 box Sat home Pirates Nick Kingham - R Padres Clayton Richard - L 2-6 -4 L 0.0 P 8-10 2-0 0-4 -128 8.0 9
May 20, 2018 box Sun home Pirates Trevor Williams - R Padres Jordan Lyles - R 5-8 -3 L 5.0 O 10-9 1-0 1-3 -125 8.0 9
May 22, 2018 box Tue away Pirates Jameson Taillon - R Reds Matt Harvey - R 2-7 -5 L -0.5 U 6-9 0-0 0-5 -115 9.5 9
May 23, 2018 box Wed away Pirates Chad Kuhl - R Reds Homer Bailey - R 5-4 1 W -0.5 U 15-11 1-0 4-0 -116 9.5 10+
May 24, 2018 box Thu away Pirates Ivan Nova - R Reds Luis Castillo - R 4-5 -1 L 0.0 P 7-8 1-0 0-5 110 9.0 9
May 25, 2018 box Fri home Pirates Joe Musgrove - R Cardinals John Gant - R 8-1 7 W 0.0 P 12-7 0-0 7-0 -130 9.0 9
May 26, 2018 box Sat home Pirates Trevor Williams - R Cardinals Jack Flaherty - R 1-4 -3 L -3.5 U 6-11 0-0 0-3 100 8.5 9
May 27, 2018 box Sun home Pirates Jameson Taillon - R Cardinals Miles Mikolas - R 4-6 -2 L 2.0 O 5-8 1-0 3-2 -110 8.0 9
May 28, 2018 box Mon home Pirates Chad Kuhl - R Cubs Mike Montgomery - L 0-7 -7 L -2.0 U 2-12 2-0 0-7 105 9.0 9
May 29, 2018 box Tue home Pirates Nick Kingham - R Cubs Jon Lester - L 6-8 -2 L 5.5 O 13-14 0-0 3-4 120 8.5 9
May 30, 2018 box Wed home Pirates Joe Musgrove - R Cubs Kyle Hendricks - R 2-1 1 W -5.0 U 9-9 0-1 1-1 115 8.0 9
May 31, 2018 box Thu away Pirates Trevor Williams - R Cardinals Jack Flaherty - R 8-10 -2 L 9.5 O 12-14 1-3 3-4 140 8.5 9
Jun 01, 2018 box Fri away Pirates Jameson Taillon - R Cardinals Miles Mikolas - R 4-0 4 W -4.0 U 9-4 0-1 4-0 110 8.0 9
Jun 02, 2018 box Sat away Pirates Chad Kuhl - R Cardinals Luke Weaver - R 2-3 -1 L -3.5 U 5-5 0-0 0-1 130 8.5 9
Jun 03, 2018 box Sun away Pirates Nick Kingham - R Cardinals Michael Wacha - R 0-5 -5 L -3.5 U 2-6 2-0 0-5 125 8.5 9
Jun 05, 2018 box Tue home Pirates Joe Musgrove - R Dodgers Ross Stripling - R 0-5 -5 L -2.5 U 7-7 1-1 0-5 110 7.5 9
Jun 06, 2018 box Wed home Pirates Trevor Williams - R Dodgers Caleb Ferguson - L 11-9 2 W 11.5 O 10-8 0-1 4-0 102 8.5 9
Jun 07, 2018 box Thu home Pirates Jameson Taillon - R Dodgers Daniel Hudson - R 7-8 -1 L 7.0 O 9-13 0-1 0-5 -135 8.0 9
Jun 08, 2018 box Fri away Pirates Chad Kuhl - R Cubs Mike Montgomery - L 1-3 -2 L -4.0 U 9-9 0-0 1-2 160 8.0 9
Jun 09, 2018 box Sat away Pirates Nick Kingham - R Cubs Jon Lester - L 0-2 -2 L -5.5 U 1-6 0-0 0-2 165 7.5 9
Jun 10, 2018 box Sun away Pirates Ivan Nova - R Cubs Kyle Hendricks - R 7-1 6 W -1.0 U 9-4 2-0 6-0 170 9.0 9
Jun 11, 2018 box Mon away Pirates Joe Musgrove - R Diamondbacks Patrick Corbin - L 5-9 -4 L 6.0 O 8-9 1-1 5-4 145 8.0 9
Jun 12, 2018 box Tue away Pirates Trevor Williams - R Diamondbacks Clay Buchholz - R 8-13 -5 L 12.5 O 12-11 3-1 0-8 140 8.5 9
Jun 13, 2018 box Wed away Pirates Jameson Taillon - R Diamondbacks Zack Greinke - R 5-4 1 W 1.0 O 6-8 0-0 3-2 130 8.0 9
Jun 15, 2018 box Fri home Pirates Chad Kuhl - R Reds Matt Harvey - R 3-2 1 W -4.0 U 6-7 3-0 1-1 -140 9.0 9
Jun 16, 2018 box Sat home Pirates Ivan Nova - R Reds Luis Castillo - R 6-2 4 W -0.5 U 10-7 1-0 5-0 -108 8.5 9
Jun 17, 2018 box Sun home Pirates Joe Musgrove - R Reds Anthony DeSclafani - R 6-8 -2 L 5.5 O 11-13 0-0 1-5 -140 8.5 9
Jun 18, 2018 box Mon home Pirates Trevor Williams - R Brewers Jhoulys Chacin - R 1-0 1 W -7.5 U 7-2 0-0 1-0 105 8.5 9
Jun 19, 2018 box Tue home Pirates Jameson Taillon - R Brewers Freddy Peralta - R 2-3 -1 L -3.0 U 5-9 0-1 0-3 -110 8.0 9
Jun 21, 2018 box Thu home Pirates Chad Kuhl - R Diamondbacks Zack Godley - R 3-9 -6 L 4.0 O 8-10 1-0 0-8 -110 8.0 9
Jun 22, 2018 box Fri home Pirates Ivan Nova - R Diamondbacks Patrick Corbin - L 1-2 -1 L -4.5 U 4-8 3-1 0-2 110 7.5 10+
Jun 23, 2018 box Sat home Pirates Joe Musgrove - R Diamondbacks Zack Greinke - R 2-7 -5 L 1.0 O 7-10 1-0 0-6 108 8.0 9
Jun 24, 2018 box Sun home Pirates Trevor Williams - R Diamondbacks Clay Buchholz - R -105 8.5
Jun 25, 2018 box Mon away Pirates Jameson Taillon - R Mets Seth Lugo - R
Jun 26, 2018 box Tue away Pirates Chad Kuhl - R Mets Seth Lugo - R
Jun 27, 2018 box Wed away Pirates Mets
Jun 29, 2018 box Fri away Pirates Padres
Jun 30, 2018 box Sat away Pirates Padres
Jul 01, 2018 box Sun away Pirates Padres
Jul 02, 2018 box Mon away Pirates Dodgers
Jul 03, 2018 box Tue away Pirates Dodgers
Jul 04, 2018 box Wed away Pirates Dodgers

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, 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).