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

A crowd-sourced stats provider.
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 Mariners are 8-17-1 AGAINST since Aug 03, 2021.
SU: 33-22 (-0.02, 60.0%)   avg line: -102.9 / -109.0   on / against: +$1,038 / -$1,353   ROI: +15.1% / -19.2%
RL: 32-23 (0.12, 58.2%)   avg line: -111.6 / -108.3   on / against: +$850 / -$1,180   ROI: +12.8% / -18.0%
OU: 26-27-2 (0.27, 49.1%)   avg total: 8.5   over / under: -$375 / -$7   ROI: -6.1% / -0.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.38 3.31 9.38 7.93 1.23 1.23 2.53 1.18 3.53 13.88 None 0.33 2.50 4.42
Opp 4.40 2.38 7.73 8.45 1.73 1.23 2.35 0.98 3.05 15.00 None 0.35 2.00 4.58
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 03, 2021 box Tue away Mariners Yusei Kikuchi - L Rays Luis Patino - R 4-2 2 W -2.0 U 6-7 1-2 2-1 145 8.0 9
Aug 04, 2021 box Wed away Mariners Logan Gilbert - R Rays Josh Fleming - L 3-4 -1 L -1.0 U 7-5 0-0 1-2 145 8.0 9
Aug 05, 2021 box Thu away Mariners Tyler Anderson - L Yankees Nestor Cortes Jr - L 3-5 -2 L -1.0 U 10-10 0-0 1-2 185 9.0 9
Aug 06, 2021 box Fri away Mariners Marco Gonzales - L Yankees Wandy Peralta - L 2-3 -1 L -5.0 U 9-6 0-0 1-0 160 10.0 10+
Aug 07, 2021 box Sat away Mariners Chris Flexen - R Yankees Andrew Heaney - L 4-5 -1 L -0.5 U 5-11 1-0 3-1 180 9.5 9
Aug 08, 2021 box Sun away Mariners Yusei Kikuchi - L Yankees Luis Gil - R 2-0 2 W -7.0 U 6-6 0-2 2-0 125 9.0 9
Aug 10, 2021 box Tue home Mariners Logan Gilbert - R Rangers Kolby Allard - L 4-5 -1 L 0.5 O 10-8 1-0 1-1 -220 8.5 10+
Aug 11, 2021 box Wed home Mariners Tyler Anderson - L Rangers Spencer Howard - R 2-1 1 W -5.0 U 7-7 0-0 1-1 -195 8.0 9
Aug 12, 2021 box Thu home Mariners Marco Gonzales - L Rangers Mike Foltynewicz - R 3-1 2 W -4.5 U 8-2 0-0 2-1 -215 8.5 9
Aug 13, 2021 box Fri home Mariners Chris Flexen - R Blue Jays Robbie Ray - L 3-2 1 W -3.5 U 6-9 0-0 2-0 150 8.5 9
Aug 14, 2021 box Sat home Mariners Yusei Kikuchi - L Blue Jays Hyun Jin Ryu - L 9-3 6 W 3.5 O 8-7 1-0 6-1 125 8.5 9
Aug 15, 2021 box Sun home Mariners Logan Gilbert - R Blue Jays Steven Matz - L 3-8 -5 L 2 O 7-12 1-0 1-6 110 9 9
Aug 17, 2021 box Tue away Mariners Tyler Anderson - L Rangers Taylor Hearn - L 3-1 2 W -4.5 U 6-6 0-0 2-0 -150 8.5 9
Aug 18, 2021 box Wed away Mariners Marco Gonzales - L Rangers Mike Foltynewicz - R 3-1 2 W -4.5 U 5-8 0-0 2-0 -170 8.5 9
Aug 19, 2021 box Thu away Mariners Chris Flexen - R Rangers Spencer Howard - R 9-8 1 W 8.5 O 12-9 1-0 6-0 -155 8.5 10+
Aug 20, 2021 box Fri away Mariners Yusei Kikuchi - L Astros Lance McCullers Jr - R 3-12 -9 L 6.0 O 6-15 0-0 0-11 170 9.0 9
Aug 21, 2021 box Sat away Mariners Logan Gilbert - R Astros Jake Odorizzi - R 1-15 -14 L 7.0 O 5-15 0-0 0-14 150 9.0 9
Aug 22, 2021 box Sun away Mariners Tyler Anderson - L Astros Framber Valdez - L 6-3 3 W 0.0 P 9-12 1-0 0-2 160 9.0 10+
Aug 23, 2021 box Mon away Mariners Marco Gonzales - L Athletics Paul Blackburn - R 5-3 2 W -1.0 U 10-6 1-0 2-2 102 9.0 9
Aug 24, 2021 box Tue away Mariners Chris Flexen - R Athletics Cole Irvin - L 5-1 4 W -2.5 U 11-8 1-0 4-1 135 8.5 9
Aug 26, 2021 box Thu home Mariners Yusei Kikuchi - L Royals Brad Keller - R 4-6 -2 L 2.0 O 9-8 1-0 4-2 -165 8.0 9
Aug 27, 2021 box Fri home Mariners Logan Gilbert - R Royals Kris Bubic - L 7-8 -1 L 7.0 O 11-16 0-0 4-1 -170 8.0 10+
Aug 28, 2021 box Sat home Mariners Tyler Anderson - L Royals Daniel Lynch - L 2-4 -2 L -2.5 U 11-10 1-0 0-3 -150 8.5 9
Aug 29, 2021 box Sun home Mariners Marco Gonzales - L Royals Brady Singer - R 4-3 1 W -1.5 U 5-8 0-1 2-0 -155 8.5 9
Aug 30, 2021 box Mon home Mariners Chris Flexen - R Astros Luis Garcia - R 3-4 -1 L -1.5 U 6-11 1-2 1-2 145 8.5 9
Aug 31, 2021 box Tue home Mariners Yusei Kikuchi - L Astros Lance McCullers Jr - R 4-0 4 W -4.0 U 6-6 1-0 4-0 147 8.0 9
Sep 01, 2021 box Wed home Mariners Logan Gilbert - R Astros Jake Odorizzi - R 1-0 1 W -7.5 U 3-9 0-0 1-0 125 8.5 9
Sep 03, 2021 box Fri away Mariners Tyler Anderson - L Diamondbacks Madison Bumgarner - L 6-5 1 W 2.5 O 7-7 0-0 4-0 -120 8.5 9
Sep 04, 2021 box Sat away Mariners Marco Gonzales - L Diamondbacks Humberto Castellanos - R 8-5 3 W 4.5 O 14-10 0-0 3-1 -128 8.5 9
Sep 05, 2021 box Sun away Mariners Chris Flexen - R Diamondbacks Tyler Gilbert - L 10-4 6 W 5.0 O 11-6 1-1 2-1 -130 9.0 9
Sep 06, 2021 box Mon away Mariners Yusei Kikuchi - L Astros Lance McCullers Jr - R 2-11 -9 L 4.5 O 5-14 2-0 0-9 185 8.5 9
Sep 07, 2021 box Tue away Mariners Logan Gilbert - R Astros Jake Odorizzi - R 4-5 -1 L 0.5 O 8-12 1-1 2-2 160 8.5 9
Sep 08, 2021 box Wed away Mariners Tyler Anderson - L Astros Jose Urquidy - R 8-5 3 W 4.0 O 13-10 0-0 4-2 165 9.0 9
Sep 10, 2021 box Fri home Mariners Marco Gonzales - L Diamondbacks Madison Bumgarner - L 5-4 1 W 0.5 O 8-5 2-0 2-1 -155 8.5 9
Sep 11, 2021 box Sat home Mariners Chris Flexen - R Diamondbacks Humberto Castellanos - R 3-7 -4 L 1.5 O 6-9 0-0 1-4 -180 8.5 9
Sep 12, 2021 box Sun home Mariners Yusei Kikuchi - L Diamondbacks Tyler Gilbert - L 4-5 -1 L 0.5 O 4-11 0-2 0-3 -165 8.5 9
Sep 13, 2021 box Mon home Mariners Logan Gilbert - R Red Sox Eduardo Rodriguez - L 5-4 1 W 1.0 O 10-7 0-2 3-0 115 8.0 9
Sep 14, 2021 box Tue home Mariners Tyler Anderson - L Red Sox Nathan Eovaldi - R 4-8 -4 L 4.0 O 8-11 1-2 1-6 123 8.0 9
Sep 15, 2021 box Wed home Mariners Marco Gonzales - L Red Sox Tanner Houck - R 4-9 -5 L 4.5 O 6-9 1-2 0-3 117 8.5 9
Sep 17, 2021 box Fri away Mariners Chris Flexen - R Royals Jon Heasley - R 6-2 4 W -1.0 U 10-9 0-0 4-0 -120 9.0 9
Sep 18, 2021 box Sat away Mariners Yusei Kikuchi - L Royals Kris Bubic - L 1-8 -7 L 0.0 P 3-15 1-0 0-7 -105 9.0 9
Sep 19, 2021 box Sun away Mariners Logan Gilbert - R Royals Jackson Kowar - R 7-1 6 W -0.5 U 11-3 0-0 6-0 -130 8.5 9
Sep 20, 2021 box Mon away Mariners Tyler Anderson - L Athletics Sean Manaea - L 4-2 2 W -2.0 U 10-7 0-0 3-0 155 8.0 9
Sep 21, 2021 box Tue away Mariners Marco Gonzales - L Athletics Paul Blackburn - R 5-2 3 W -1.5 U 9-6 0-1 3-1 115 8.5 9
Sep 22, 2021 box Wed away Mariners Chris Flexen - R Athletics Cole Irvin - L 4-1 3 W -3.5 U 9-4 0-0 3-0 127 8.5 9
Sep 23, 2021 box Thu away Mariners Yusei Kikuchi - L Athletics Chris Bassitt - R 6-5 1 W 2.5 O 7-6 1-0 2-3 142 8.5 9
Sep 24, 2021 box Fri away Mariners Logan Gilbert - R Angels Jose Suarez - L 6-5 1 W 2.5 O 7-9 0-1 3-0 -120 8.5 9
Sep 25, 2021 box Sat away Mariners Tyler Anderson - L Angels Jaime Barria - R 1-14 -13 L 6.5 O 6-14 0-1 0-13 -135 8.5 9
Sep 26, 2021 box Sun away Mariners Marco Gonzales - L Angels Shohei Ohtani - R 5-1 4 W -2.5 U 9-3 0-1 4-1 125 8.5 9
Sep 27, 2021 box Mon home Mariners Chris Flexen - R Athletics Cole Irvin - L 13-4 9 W 8.5 O 14-7 0-0 9-3 -113 8.5 9
Sep 28, 2021 box Tue home Mariners Tyler Anderson - L Athletics Chris Bassitt - R 4-2 2 W -2.0 U 9-7 2-2 2-1 110 8.0 9
Sep 29, 2021 box Wed home Mariners Logan Gilbert - R Athletics Frankie Montas - R 4-2 2 W -1.5 U 6-5 0-2 2-1 100 7.5 9
Oct 01, 2021 box Fri home Mariners Marco Gonzales - L Angels Jose Suarez - L 1-2 -1 L -6.0 U 5-4 0-0 1-1 -170 9.0 9
Oct 02, 2021 box Sat home Mariners Chris Flexen - R Angels Jhonathan Diaz - L 6-4 2 W 2.0 O 8-8 0-1 2-1 -170 8.0 9
Oct 03, 2021 box Sun home Mariners Tyler Anderson - L Angels Reid Detmers - R 3-7 -4 L 3.0 O 9-10 2-0 0-5 -170 7.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).