S p o r t s D a t a B a s e . c o m
a sports data query language (SDQL ©) consultancy

Permission is given to quote trends found on SportsDataBase.com provided that a reference and a link to SportsDataBase.com is provided. E.g.: Trend found on SportsDataBase.com


Winning Picks, Guaranteed

NBA SDQL Access

Enter your SDQL in the text box below and click the query button when finished.

t:team=Jazz and 20100123<=date
SU: 33-17 (5.3)
ATS: 31-19-0 (0.9) avg line: -4.4
O/U: 26-22-2 (2.4) avg total: 207.5
Q1Q2Q3Q4Final
Team:   26.8     26.3     27.8     26.4     107.6
Opp:   26.9     24.9     25.6     24.6     102.3
Field GoalsThreesFree ThrowsBlocksO RbndsRbndsFoulsAssistsTrnOvrs
Team:39.8-80.7 (49.7%)6.1-16.5 (35.1%)21.9-29.5 (74.1%)5.011.443.123.926.614.3
Opp:36.2-79.9 (45.5%)7.0-19.5 (35.1%)22.8-29.3 (77.4%)5.610.639.423.520.214.1
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100123 Jazz Nets home 116-83 2&0 61-42 -16' +200' 33 16.5 -1.5 7.5 -9.0 W W U
20100125 Jazz Suns home 124-115 1&1 52-48 -7 +221' 9 2.0 17.5 9.8 7.8 W W O
20100127 Jazz Trailblazers away 106-95 1&1 60-35 -2' +195' 11 8.5 5.5 7.0 -1.5 W W O
20100129 Jazz Kings home 101-94 1&2 48-43 -9 +204 7 -2.0 -9.0 -5.5 -3.5 W L U
20100201 Jazz Mavericks home 104-92 2&1 49-46 -4 +199 12 8.0 -3.0 2.5 -5.5 W W U
20100203 Jazz Trailblazers home 118-105 1&1 62-42 -7' +197 13 5.5 26.0 15.8 10.2 W W O
20100206 Jazz Nuggets home 116-106 2&0 49-44 -9' +208' 10 0.5 13.5 7.0 6.5 W W O
20100209 Jazz Clippers away 109-99 2&2 50-45 -5 +201 10 5.0 7.0 6.0 1.0 W W O
20100210 Jazz Lakers home 81-96 0&1 44-46 -5 +201' -15 -20.0 -24.5 -22.2 -2.2 L L U
20100216 Jazz Rockets away 104-95 5&6 51-40 -3 +202 9 6.0 -3.0 1.5 -4.5 W W U
20100217 Jazz Hornets away 98-90 0&6 54-38 -4 +201' 8 4.0 -13.5 -4.8 -8.8 W W U
20100219 Jazz Warriors away 100-89 1&1 42-37 -6 +219 11 5.0 -30.0 -12.5 -17.5 W W U
20100221 Jazz Trailblazers away 93-89 1&1 39-35 +1 +192 4 5.0 -10.0 -2.5 -7.5 W W U 1
20100222 Jazz Hawks home 100-105 0&0 48-54 -5 +196' -5 -10.0 8.5 -0.8 9.2 L L O
20100224 Jazz Bobcats home 102-93 1&1 47-41 -8 +193 9 1.0 2.0 1.5 0.5 W W O
20100226 Jazz Kings away 99-103 1&2 40-54 -7 +201' -4 -11.0 0.5 -5.2 5.8 L L O
20100227 Jazz Rockets home 133-110 0&0 67-44 -9' +203' 23 13.5 39.5 26.5 13.0 W W O
20100301 Jazz Clippers away 104-108 1&0 42-48 -6 +202 -4 -10.0 10.0 0.0 10.0 L L O
20100304 Jazz Suns away 116-108 2&0 45-57 +1' +213 8 9.5 11.0 10.2 0.8 W W O
20100306 Jazz Clippers home 107-85 1&0 45-40 -14 +205' 22 8.0 -13.5 -2.8 -10.8 W W U
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100309 Jazz Bulls away 132-108 2&2 54-53 -4' +206' 24 19.5 33.5 26.5 7.0 W W O
20100310 Jazz Pistons away 115-104 0&2 56-43 -6 +201 11 5.0 18.0 11.5 6.5 W W O
20100312 Jazz Bucks away 87-95 1&2 41-40 +1 +196' -8 -7.0 -14.5 -10.8 -3.8 L L U
20100314 Jazz Thunder away 111-119 1&1 50-60 +3 +204' -8 -5.0 25.5 10.2 15.2 L L O
20100315 Jazz Wizards home 112-89 0&1 52-36 -11 +205 23 12.0 -4.0 4.0 -8.0 W W U
20100317 Jazz Timberwolves home 122-100 1&0 53-43 -15 +216 22 7.0 6.0 6.5 -0.5 W W O
20100319 Jazz Suns away 100-110 1&2 38-52 +5' +222' -10 -4.5 -12.5 -8.5 -4.0 L L U
20100320 Jazz Hornets home 106-86 0&1 55-43 -10 +212 20 10.0 -20.0 -5.0 -15.0 W W U
20100322 Jazz Celtics home 110-97 1&1 51-44 -4' +200 13 8.5 7.0 7.8 -0.8 W W O
20100324 Jazz Raptors away 113-87 1&1 49-40 -3' +214 26 22.5 -14.0 4.2 -18.2 W W U
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100326 Jazz Pacers away 106-122 1&1 43-50 -5 +211' -16 -21.0 16.5 -2.2 18.8 L L O
20100327 Jazz Wizards away 103-87 0&0 59-38 -9' +198 16 6.5 -8.0 -0.8 -7.2 W W U
20100329 Jazz Knicks home 103-98 1&2 51-45 -11' +216 5 -6.5 -15.0 -10.8 -4.2 W L U
20100331 Jazz Warriors home 128-104 1&2 52-35 -13 +232' 24 11.0 -0.5 5.2 -5.8 W W U
20100402 Jazz Lakers away 92-106 1&1 44-43 +4' +203' -14 -9.5 -5.5 -7.5 2.0 L L U
20100406 Jazz Thunder home 140-139 3&1 52-50 -6 +212' 1 -5.0 66.5 30.8 35.8 W L O 1
20100407 Jazz Rockets away 96-113 0&0 49-48 -4 +215' -17 -21.0 -6.5 -13.8 7.2 L L U
20100409 Jazz Hornets away 114-103 1&1 55-49 -7' +210' 11 3.5 6.5 5.0 1.5 W W O
20100413 Jazz Warriors away 103-94 3&1 48-38 -7' +233 9 1.5 -36.0 -17.2 -18.8 W W U
20100414 Jazz Suns home 86-100 0&0 37-47 -6 +217' -14 -20.0 -31.5 -25.8 -5.8 L L U
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100417 Jazz Nuggets away 113-126 2&3 54-57 +6 +208 -13 -7.0 31.0 12.0 19.0 L L O
20100419 Jazz Nuggets away 114-111 1&1 52-46 +6' +212' 3 9.5 12.5 11.0 1.5 W W O
20100423 Jazz Nuggets home 105-93 3&3 46-43 -2' +217 12 9.5 -19.0 -4.8 -14.2 W W U
20100425 Jazz Nuggets home 117-106 1&1 53-44 -2 +212' 11 9.0 10.5 9.8 0.8 W W O
20100428 Jazz Nuggets away 102-116 2&2 45-50 +7 +215 -14 -7.0 3.0 -2.0 5.0 L L O
20100430 Jazz Nuggets home 112-104 1&1 52-43 -6 +216 8 2.0 0.0 1.0 -1.0 W W P
20100502 Jazz Lakers away 99-104 1&1 44-53 +7 +200' -5 2.0 2.5 2.2 0.2 L W O
20100504 Jazz Lakers away 103-111 1&1 39-50 +6 +199 -8 -2.0 15.0 6.5 8.5 L L O
20100508 Jazz Lakers home 110-111 3&3 48-47 -4 +202' -1 -5.0 18.5 6.8 11.8 L L O
20100510 Jazz Lakers home 96-111 1&1 45-45 -3' +207 -15 -18.5 0.0 -9.2 9.2 L L P

Query Fundamentals:

  A query consists of one or more clauses joined by and or or.
The full format for reference to the SportsDataBase is team name:player name:game reference:parameter.

Examples:

  

The query:
25 < Suns:Leandro Barbosa:p:minutes and site=home
returns home games where the Suns' Barbosa played more than 25 minutes in the Suns' previous game.

If no player is given then results for the team are checked. E.g.
Bulls:p:points < 100 and 0 < line
returns games in which the Bulls are dogs after the scoring fewer than 100 points.

If no team is given then results for any team are checked.
p:points < 100
returns games after teams scored fewer than 100 points.

If no game reference is given then results for the current game are checked.
points < 100
returns games in which teams scored fewer than 100 points.

If no conditional is imposed then the results are grouped by the reference.
points
returns games grouped by all occurrences of points.

Multiple conditions can be imposed using a comma delimited format.
points < 90,100,110
gives results grouped by points < 90, points < 100, and points < 110.

You can also use 70,80,90,100 < points < 90,100,110.

Game Reference:

  p => team's previous game
op => opp's previous game
P => previous match up
n => team's next game
on => opp's next game
N => next match up

Examples:

   The query:
P:points < 80 and PP:points < 80
returns games where team scored fewer than 80 point the past two head-to-head match ups

The query:
2*P:points in the paint < Po:points in the paint
returns games in which the team was outscored in the paint by a factor of 2 in their previous match up.

Adding a condition on season restricts this query to same season match ups:
2*P:points in the paint < Po:points in the paint and P:season=season
returns games in which the team was outscored in the paint by a factor of 2 in their previous same season match up.

Parameters:

  Prest, assists, ats margin, ats streak, attendance, biggest lead, blocks, conference, date, day, defensive rebounds, division, dpa, dps, fast break points, field goals attempted, field goals made, fouls, free throws attempted, free throws made, game, line, losses, margin, margin after the first, margin after the third, margin at the half, minutes, month, name, next game, next match up, offensive rebounds, officials, opponents, ou margin, ou streak, overtime, playoffs, points, points in the paint, position, previous game, previous match up, quarter scores, rebounds, rest, round, season, seed, series game, series games, series losses, series wins, site, site streak, stats, steals, streak, team, team rebounds, three pointers attempted, three pointers made, time of game, time zone, total, turnovers, wins

Examples:

   The query:
0.25*p:points <= p:fast break points and po:points < p:points
returns games with a team off a win in which they scored at least 25% of their points from fast breaks.

Short Cuts:

H, A, W, L, F, D, O, U, C are short cuts for home, away, win, loss, favorite, dog, over the total,under the total, and conference. As with the parameter prefixex, these can be strung together without limit.

In addition to the above single letter short cuts the following abbreviations are available:

M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
S1 - points in the first
S2 - total points after the second
S3 - total points after the third
FGA - field goals attempted
FGM - field goals made
FTA - free throws attempted
FTM - free throws made
TPA - three pointers attempted
TPM - three pointers made
FGP - field goal percentage
TPP - three point percentage
FTP - free throw percentage
PFT - percentage of points from free throws
PTP - percentage of points from three pointers
WP - team winning percentage
TO - turnovers
AST - assists

e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this is generated using the Sports Data Query Language (SDQL).
Google Groups
Subscribe to SportsDataBase
Email:
Visit this group