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-21-1 AGAINST since Jun 13, 2017
SU: 125-128 (-0.13, 49.4%)   avg line: 101.5 / -112.5   on / against: +$86 / -$1,125   ROI: +0.3% / -3.6%
RL: 130-122 (0.11, 51.6%)   avg line: -123.0 / -103.3   on / against: -$885 / -$1,010   ROI: -2.5% / -3.1%
OU: 99-141-12 (0.05, 41.2%)   avg total: 8.5   over / under: -$5,464 / +$3,353   ROI: -19.7% / +12.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.19 2.94 7.61 8.34 1.87 0.96 2.33 1.06 3.56 13.57 6.64 0.88 2.71 4.04
Opp 4.33 3.21 8.17 8.60 1.98 1.08 2.36 1.12 3.65 15.21 7.08 0.85 2.62 4.33
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
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 0-3 -3 L -5.5 U 5-6 1-0 0-3 -110 8.5 9
Jun 25, 2018 box Mon away Pirates Jameson Taillon - R Mets Seth Lugo - R 6-4 2 W 2.5 O 7-6 1-3 5-0 -110 7.5 9
Jun 26, 2018 box Tue away Pirates Chad Kuhl - R Mets Steven Matz - L 3-4 -1 L -1.0 U 8-8 3-0 1-2 104 8.0 10+
Jun 27, 2018 box Wed away Pirates Ivan Nova - R Mets Zack Wheeler - R 5-3 2 W 0.5 O 12-6 0-0 2-3 100 7.5 9
Jun 29, 2018 box Fri away Pirates Joe Musgrove - R Padres Eric Lauer - L 6-3 3 W 1.5 O 11-12 0-2 6-0 -105 7.5 9
Jun 30, 2018 box Sat away Pirates Trevor Williams - R Padres Joey Lucchesi - L 3-4 -1 L -0.5 U 7-5 0-0 0-4 120 7.5 9
Jul 01, 2018 box Sun away Pirates Jameson Taillon - R Padres Tyson Ross - R 7-5 2 W 4.5 O 9-9 1-1 3-2 -116 7.5 9
Jul 02, 2018 box Mon away Pirates Nick Kingham - R Dodgers Alex Wood - L 1-17 -16 L 10.5 O 9-21 3-1 0-16 200 7.5 9
Jul 03, 2018 box Tue away Pirates Ivan Nova - R Dodgers Clayton Kershaw - L 3-8 -5 L 3.5 O 5-11 0-0 0-6 220 7.5 9
Jul 04, 2018 box Wed away Pirates Clay Holmes - R Dodgers Rich Hill - L 4-6 -2 L 1.5 O 9-9 0-0 1-4 200 8.5 9
Jul 06, 2018 box Fri home Pirates Trevor Williams - R Phillies Nick Pivetta - R 5-17 -12 L 13.5 O 12-18 1-1 1-13 100 8.5 9
Jul 07, 2018 box Sat home Pirates Jameson Taillon - R Phillies Jake Arrieta - R 2-3 -1 L -3.0 U 8-9 0-0 2-1 -126 8.0 9
Jul 08, 2018 box Sun home Pirates Nick Kingham - R Phillies Drew Anderson - ? 4-1 3 W -4.0 U 9-4 0-1 3-0 -150 9.0 9
Jul 09, 2018 box Mon home Pirates Ivan Nova - R Nationals Jefry Rodriguez - R 6-3 3 W 0.0 P 8-10 0-0 5-0 -103 9.0 9
Jul 10, 2018 box Tue home Pirates Joe Musgrove - R Nationals Jeremy Hellickson - R 1-5 -4 L -3.0 U 7-12 0-1 0-5 107 9.0 9
Jul 11, 2018 box Wed home Pirates Trevor Williams - R Nationals Gio Gonzalez - L 2-0 2 W -7.0 U 7-5 0-0 2-0 120 9.0 9
Jul 12, 2018 box Thu home Pirates Jameson Taillon - R Brewers Wade Miley - L 6-3 3 W 0.5 O 9-9 1-2 5-0 -128 8.5 9
Jul 13, 2018 box Fri home Pirates Nick Kingham - R Brewers Junior Guerra - R 7-3 4 W 2.0 O 12-9 0-2 5-0 -115 8.0 9
Jul 14, 2018 box Sat home Pirates Ivan Nova - R Brewers Chase Anderson - R 2-1 1 W -5.5 U 7-9 0-0 2-0 -105 8.5 9
Jul 14, 2018 box Sat home Pirates Clay Holmes - R Brewers Brent Suter - L 6-2 4 W -1.0 U 8-9 0-0 6-0 125 9.0 9
Jul 15, 2018 box Sun home Pirates Joe Musgrove - R Brewers Jhoulys Chacin - R 7-6 1 W 4.5 O 9-9 1-2 1-3 -115 8.5 10+
Jul 20, 2018 box Fri away Pirates Jameson Taillon - R Reds Tyler Mahle - R 12-1 11 W 4.0 O 16-9 0-2 11-0 -105 9.0 9
Jul 21, 2018 box Sat away Pirates Nick Kingham - R Reds Anthony DeSclafani - R 6-2 4 W -1.0 U 12-6 1-0 5-0 102 9.0 9
Jul 22, 2018 box Sun away Pirates Ivan Nova - R Reds Matt Harvey - R 9-2 7 W 2.0 O 15-6 0-0 9-0 105 9.0 9
Jul 23, 2018 box Mon away Pirates Trevor Williams - R Indians Corey Kluber - R 7-0 7 W 10-4 0-1 7-0 240 9
Jul 24, 2018 box Tue away Pirates Joe Musgrove - R Indians Shane Bieber - R 9-4 5 W 3.5 O 14-9 0-0 7-0 160 9.5 9
Jul 25, 2018 box Wed away Pirates Jameson Taillon - R Indians Trevor Bauer - R 0-4 -4 L -4.0 U 3-8 1-1 0-4 185 8.0 9
Jul 26, 2018 box Thu home Pirates Nick Kingham - R Mets Steven Matz - L 6-12 -6 L 9.5 O 7-14 3-1 0-7 -140 8.5 9
Jul 27, 2018 box Fri home Pirates Ivan Nova - R Mets Jason Vargas - L 5-4 1 W 0.0 P 10-9 2-0 1-3 -150 9.0 9
Jul 28, 2018 box Sat home Pirates Trevor Williams - R Mets Jacob deGrom - R 5-0 5 W -2.5 U 11-6 0-0 5-0 120 7.5 9
Jul 29, 2018 box Sun home Pirates Joe Musgrove - R Mets Zack Wheeler - R 0-1 -1 L -7.0 U 6-5 0-0 0-1 -135 8.0 9
Jul 31, 2018 box Tue home Pirates Jameson Taillon - R Cubs Jon Lester - L 5-4 1 W 1.0 O 8-9 0-0 3-0 -108 8.0 9
Aug 01, 2018 box Wed home Pirates Nick Kingham - R Cubs Cole Hamels - L 2-9 -7 L 3.0 O 7-15 2-3 0-8 118 8.0 9
Aug 03, 2018 box Fri home Pirates Chris Archer - R Cardinals John Gant - R 7-6 1 W 5.0 O 12-15 1-0 4-1 -152 8.0 9
Aug 04, 2018 box Sat home Pirates Ivan Nova - R Cardinals Austin Gomber - L 4-8 -4 L 3.5 O 8-14 1-0 1-4 -115 8.5 9
Aug 05, 2018 box Sun home Pirates Trevor Williams - R Cardinals Jack Flaherty - R 1-2 -1 L -5.5 U 5-10 1-0 0-2 105 8.5 9
Aug 06, 2018 box Mon away Pirates Joe Musgrove - R Rockies Kyle Freeland - L 0-2 -2 L -8.5 U 2-5 1-0 0-2 130 10.5 9
Aug 07, 2018 box Tue away Pirates Jameson Taillon - R Rockies Chad Bettis - R 10-2 8 W 1.0 O 10-10 0-1 10-0 -120 11.0 9
Aug 08, 2018 box Wed away Pirates Chris Archer - R Rockies German Marquez - R 4-3 1 W -2.5 U 11-9 0-2 3-0 110 9.5 9
Aug 09, 2018 box Thu away Pirates Ivan Nova - R Giants Andrew Suarez - L 10-5 5 W 7.0 O 13-6 1-3 8-0 125 8.0 9
Aug 10, 2018 box Fri away Pirates Clay Holmes - R Giants Derek Holland - L 10-13 -3 L 15.0 O 17-16 0-0 0-8 120 8.0 9
Aug 11, 2018 box Sat away Pirates Trevor Williams - R Giants Ty Blach - L 4-0 4 W -4.5 U 6-6 0-0 4-0 100 8.5 9
Aug 12, 2018 box Sun away Pirates Joe Musgrove - R Giants Dereck Rodriguez - R 3-4 -1 L -0.5 U 4-7 2-0 1-3 100 7.5 9
Aug 14, 2018 box Tue away Pirates Jameson Taillon - R Twins Jake Odorizzi - R 2-5 -3 L -1.5 U 7-10 0-0 2-3 -121 8.5 9
Aug 15, 2018 box Wed away Pirates Chris Archer - R Twins Jose Berrios - R 4-6 -2 L 2.0 O 12-9 1-2 2-2 112 8.0 9
Aug 16, 2018 box Thu home Pirates Ivan Nova - R Cubs Jon Lester - L 0-1 -1 L -7.5 U 6-7 0-0 0-1 110 8.5 9
Aug 17, 2018 box Fri home Pirates Trevor Williams - R Cubs Cole Hamels - L 0-1 -1 L -7.0 U 7-6 3-0 0-1 120 8.0 9
Aug 18, 2018 box Sat home Pirates Joe Musgrove - R Cubs Tyler Chatwood - R 3-1 2 W -4.5 U 8-6 2-0 3-0 -140 8.5 9
Aug 19, 2018 box Sun home Pirates Jameson Taillon - R Cubs Jose Quintana - L 2-1 1 W -4.5 U 8-8 1-2 1-1 -121 7.5 10+
Aug 20, 2018 box Mon home Pirates Chris Archer - R Braves Bryse Wilson - R 0-1 -1 L -7.0 U 7-10 0-0 0-1 -128 8.0 9
Aug 21, 2018 box Tue home Pirates Ivan Nova - R Braves Kevin Gausman - R 1-6 -5 L -0.5 U 5-8 0-0 0-6 110 7.5 9
Aug 22, 2018 box Wed home Pirates Trevor Williams - R Braves Julio Teheran - R 1-2 -1 L -5.0 U 3-3 0-0 0-1 -107 8.0 9
Aug 24, 2018 box Fri away Pirates Joe Musgrove - R Brewers Wade Miley - L 6-7 -1 L 4.5 O 17-13 1-2 2-4 120 8.5 10+
Aug 25, 2018 box Sat away Pirates Jameson Taillon - R Brewers Jhoulys Chacin - R 9-1 8 W 1.5 O 14-6 0-1 8-1 125 8.5 9
Aug 26, 2018 box Sun away Pirates Chris Archer - R Brewers Chase Anderson - R 4-7 -3 L 2.5 O 8-8 2-2 0-6 124 8.5 9
Aug 28, 2018 box Tue away Pirates Ivan Nova - R Cardinals Jack Flaherty - R 2-5 -3 L -1.0 U 6-10 0-0 0-4 155 8.0 9
Aug 29, 2018 box Wed away Pirates Trevor Williams - R Cardinals Miles Mikolas - R 2-0 2 W -5.5 U 10-5 1-2 2-0 145 7.5 9
Aug 30, 2018 box Thu away Pirates Joe Musgrove - R Cardinals John Gant - R 0-5 -5 L -3.0 U 6-7 0-1 0-5 110 8.0 9
Aug 31, 2018 box Fri away Pirates Jameson Taillon - R Braves Anibal Sanchez - R 3-2 1 W -3.0 U 7-7 0-2 2-0 110 8.0 9
Sep 01, 2018 box Sat away Pirates Chris Archer - R Braves Kevin Gausman - R 3-5 -2 L 0.0 P 5-6 1-1 3-2 130 8.0 9
Sep 02, 2018 box Sun away Pirates Nick Kingham - R Braves Julio Teheran - R 1-5 -4 L -2.5 U 5-9 2-1 1-4 155 8.5 9
Sep 03, 2018 box Mon home Pirates Trevor Williams - R Reds Matt Harvey - R 5-1 4 W -2.5 U 9-7 1-1 5-0 -150 8.5 9
Sep 04, 2018 box Tue home Pirates Joe Musgrove - R Reds Cody Reed - L 7-3 4 W 1.5 O 12-6 1-0 6-0 -142 8.5 9
Sep 05, 2018 box Wed home Pirates Jameson Taillon - R Reds Homer Bailey - R 3-2 1 W -3.5 U 6-11 0-0 2-1 -190 8.5 9
Sep 07, 2018 box Fri home Pirates Chris Archer - R Marlins Dan Straily - R 5-3 2 W 0.0 P 9-7 0-0 2-1 -210 8.0 9
Sep 08, 2018 box Sat home Pirates Ivan Nova - R Marlins Wei Yin Chen - L 5-1 4 W -1.5 U 9-5 1-2 5-0 -145 7.5 9
Sep 10, 2018 box Mon away Pirates Trevor Williams - R Cardinals Adam Wainwright - R 7-8 -1 L 6.5 O 13-9 0-1 4-2 120 8.5 9
Sep 11, 2018 box Tue away Pirates Joe Musgrove - R Cardinals Miles Mikolas - R 5-11 -6 L 8.0 O 10-11 1-0 0-10 127 8.0 9
Sep 12, 2018 box Wed away Pirates Jameson Taillon - R Cardinals Daniel Poncedeleon - R 4-3 1 W -1.0 U 10-7 0-0 3-1 100 8.0 9
Sep 14, 2018 box Fri away Pirates Chris Archer - R Brewers Gio Gonzalez - L 4-7 -3 L 2.5 O 7-11 0-0 0-4 130 8.5 9
Sep 15, 2018 box Sat away Pirates Ivan Nova - R Brewers Zach Davies - R 3-1 2 W -4.5 U 5-7 0-1 2-1 150 8.5 9
Sep 16, 2018 box Sun away Pirates Trevor Williams - R Brewers Jhoulys Chacin - R 3-2 1 W -3.5 U 5-5 0-0 3-0 155 8.5 9
Sep 17, 2018 box Mon home Pirates Joe Musgrove - R Royals Brad Keller - R 7-6 1 W 5.0 O 16-10 1-1 2-2 -170 8.0 9
Sep 18, 2018 box Tue home Pirates Jameson Taillon - R Royals Eric Skoglund - L 2-1 1 W -4.5 U 9-7 0-1 1-0 -215 7.5 10+
Sep 19, 2018 box Wed home Pirates Chris Archer - R Royals Heath Fillmyer - R 2-1 1 W -4.5 U 9-6 1-0 1-0 -215 7.5 9
Sep 21, 2018 box Fri home Pirates Ivan Nova - R Brewers Jhoulys Chacin - R 3-8 -5 L 3.0 O 7-10 0-0 2-5 123 8.0 9
Sep 22, 2018 box Sat home Pirates Trevor Williams - R Brewers Zach Davies - R 3-0 3 W -4.5 U 10-5 1-0 3-0 105 7.5 9
Sep 23, 2018 box Sun home Pirates Nick Kingham - R Brewers Wade Miley - L 6-13 -7 L 10.5 O 6-12 2-1 0-9 140 8.5 9
Sep 24, 2018 box Mon away Pirates Jameson Taillon - R Cubs Cole Hamels - L 5-1 4 W -2.0 U 7-7 0-1 4-0 140 8.0 9
Sep 25, 2018 box Tue away Pirates Chris Archer - R Cubs Mike Montgomery - L 130 9.0
Sep 26, 2018 box Wed away Pirates Ivan Nova - R Cubs Jose Quintana - L
Sep 27, 2018 box Thu away Pirates Trevor Williams - R Cubs Jon Lester - L
Sep 28, 2018 box Fri away Pirates Reds
Sep 29, 2018 box Sat away Pirates Reds
Sep 30, 2018 box Sun away Pirates Reds

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