NBA SDQL Query Access - In Testing Your query timeout is 15 seconds.
Content will appear here
W - L- P (marg, %win)
W - L- P (marg, %over)
W - L (marg, %win)
| SDQL |
21524-28471-967 (-2.04, 43.1%)
18842-30429-1691 (-4.49, 38.2%)
21259-29703 (-2.79, 41.7%)
points < 110
11150-20956-598 (-4.24, 34.7%)
8054-23664-986 (-8.99, 25.4%)
10397-22307 (-5.80, 31.8%)
points < 100
3245-10533-230 (-7.46, 23.6%)
1599-12137-272 (-14.96, 11.6%)
2622-11386 (-10.12, 18.7%)
points < 90
Game Parameters: after all star break, 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 number, lead changes, line, losses, margin, margin after the first, margin after the third, margin at the half, matchup losses, matchup wins, minutes, month, offensive rebounds, officials, opponent, opponents, ou margin, ou streak, overtime, playoffs, points, points in the paint, position, quarter scores, rebounds, rest, round, season, seed, series game, series games, series losses, series wins, site, site streak, start time, steals, streak, team, team rebounds, three pointers attempted, three pointers made, time of game, time zone, times tied, total, turnovers, wins
How to Query:
The syntax for access to the NBA team data is: game reference:parameter. To see the date, team, and opponent where the team scored +120 points after scoring +120 runs in the previous game use the SDQL: date,team,o:team@points>120 and p:points>120
The syntax for access to the NBA player data: [team:]player name:game reference:parameter. To see the date, team, opponent and number of points by Kobe Bryant in the game after he scored more than 30 use the SDQL: date,team,o:team,Kobe Bryant:points@Kobe Bryant:p:points>30
A query consists of one or more clauses joined by and or or.
50 < Kobe Bryant:points and site=away
returns home games where Kobe Bryant scored more than 50 points on the road.
If no player is given then results for the team are checked. E.g.
120<Bulls:points and site=home
returns games in which the Bulls scored more than 120 points at home.
returns games when the team scored fewer than 60 points.
If no conditional is imposed then the results are grouped by the reference.
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 comma-group on both sides of the inequality as per:
70,80,90,100 < points < 90,100,110
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
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.
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 prefixes, these can be strung together without limit.
HF and p:HFL and pp:HFL
returns home favorites after they just lost as home favorites their last two games.
P:O and P2:O and P3:O and P4:O and P5:O and P6:O
returns games where teams have gone over the total their last six matchups.
In addition to the above single letter short cuts the following abbreviations are available:
AASB - after the all star break
ATSL - against the spread loss
ATSW - against the spread win
AST - assists
ATR - assist to turnover ratio
AWP - Away Winning Percentage
BAP - Baskets Assisted percentage
BASB - before the all star break
DDS - Double Digit Scorers
DRB - Defensive Rebounds
FBP - fast break points
FGA - field goals attempted
FGM - field goals made
FGP - field goal percentage
FTA - free throws attempted
FTM - free throws made
FTP - free throw percentage
HWP - Home Winning Percentage
LSP - Leading Scorers Points
M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
ORB - Offensive Rebounds
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
PIP - points in the paint
PM - plus / minus (player level parameter)
PFT - percentage of points from free throws
PTP - percentage of points from three pointers
RB - Rebounds
S1 - points in the first
S2 - total points after the second
S3 - total points after the third
TO - turnovers
TPA - three pointers attempted
TPM - three pointers made
TPP - three point percentage
TT - Times Tied
WP - team winning percentage
The information available here is believed, but not guaranteed, to be accurate, is
for recreational purposes only, and is not intended to violate any state, local, or federal laws.