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

NBA SDQL Access

team=Celtics and o:team=Pistons
SU: 23-36 (-2.2) ATS: 30-28-1 (-0.2) avg line: 2.0 O/U: 27-32-0 (0.5) avg total: 187.6
Q1 Q2 Q3 Q4 Final Team:   22.8     23.5     22.2     23.5     92.9 Opp:   22.6     23.6     23.3     24.5     95.2
Field Goals Threes Free Throws Blocks O Rbnds Rbnds Fouls Assists TrnOvrs Team: 34.6-77.1 (45.0%) 5.4-15.4 (35.2%) 18.2-24.0 (75.2%) 3.5 11.2 41.2 23.7 20.8 15.2 Opp: 34.1-76.9 (44.5%) 5.7-16.1 (35.0%) 21.2-28.4 (74.7%) 5.2 10.8 40.4 21.1 20.4 13.5
Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 19951129 Celtics Pistons home 100-96 2&1 45-39 -1 +197 4 3.0 -1.0 1.0 -2.0 W W U 19960407 Celtics Pistons home 98-97 2&1 43-43 +5 +192' 1 6.0 2.5 4.2 -1.8 W W O 19960414 Celtics Pistons away 96-105 1&0 39-44 +10 +197 -9 1.0 4.0 2.5 1.5 L W O 19961120 Celtics Pistons home 83-108 3&3 40-51 +6' +183' -25 -18.5 7.5 -5.5 13.0 L L O 19961215 Celtics Pistons away 89-99 1&2 44-51 +10 +187' -10 0.0 0.5 0.2 0.2 L P O 19970102 Celtics Pistons away 87-99 2&2 43-43 +11 +189' -12 -1.0 -3.5 -2.2 -1.2 L L U 19970228 Celtics Pistons home 100-106 1&1 43-51 +9' +199 -6 3.5 7.0 5.2 1.8 L W O 19971123 Celtics Pistons home 90-86 1&0 40-41 +5 +185 4 9.0 -9.0 0.0 -9.0 W W U 19971213 Celtics Pistons away 77-93 0&1 42-50 +10 +187' -16 -6.0 -17.5 -11.8 -5.8 L L U 19980313 Celtics Pistons home 92-96 1&1 43-42 -1' +200' -4 -5.5 -12.5 -9.0 -3.5 L L U 19980403 Celtics Pistons away 101-100 1&1 48-49 +8 +198' 1 9.0 2.5 5.8 -3.2 W W O 19990312 Celtics Pistons away 83-93 0&1 43-48 +9' +190 -10 -0.5 -14.0 -7.2 -6.8 L L U 19990331 Celtics Pistons home 72-87 0&0 41-44 +2 +184' -15 -13.0 -25.5 -19.2 -6.2 L L U 19990427 Celtics Pistons home 85-92 1&1 41-47 +3 +179 -7 -4.0 -2.0 -3.0 1.0 L L U 19991110 Celtics Pistons home 92-110 3&3 41-46 -3' +211 -18 -21.5 -9.0 -15.2 6.2 L L U 20000313 Celtics Pistons away 115-124 0&1 44-56 +6' +206 -9 -2.5 33.0 15.2 17.8 L L O 20000405 Celtics Pistons away 106-111 0&0 47-46 +8 +212 -5 3.0 5.0 4.0 1.0 L W O 20001101 Celtics Pistons home 103-83 -&0 41-35 -6' +200 20 13.5 -14.0 -0.2 -13.8 W W U 20001226 Celtics Pistons away 96-101 2&2 38-52 +4' +196 -5 -0.5 1.0 0.2 0.8 L L O Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20010129 Celtics Pistons home 99-87 2&1 47-43 -5 +198 12 7.0 -12.0 -2.5 -9.5 W W U 20010202 Celtics Pistons away 102-95 1&1 52-41 +4' +194 7 11.5 3.0 7.2 -4.2 W W O 20020111 Celtics Pistons home 104-90 1&2 51-36 -5 +187 14 9.0 7.0 8.0 -1.0 W W O 20020119 Celtics Pistons away 91-94 0&0 43-39 +2 +188 -3 -1.0 -3.0 -2.0 -1.0 L L U 20020308 Celtics Pistons home 117-92 1&0 54-39 -4' +190 25 20.5 19.0 19.8 -0.8 W W O 20020324 Celtics Pistons away 101-109 1&1 46-46 +3 +188 -8 -5.0 22.0 8.5 13.5 L L O 20030128 Celtics Pistons away 83-86 1&2 38-42 +8 +176 -3 5.0 -7.0 -1.0 -6.0 L W U 20030131 Celtics Pistons home 66-118 2&2 29-51 -3 +177' -52 -55.0 6.5 -24.2 30.8 L L O 20030315 Celtics Pistons away 81-71 1&0 44-34 +4' +174' 10 14.5 -22.5 -4.0 -18.5 W W U 20030416 Celtics Pistons home 99-92 2&1 51-39 -5 +182 7 2.0 9.0 5.5 3.5 W W O Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20031105 Celtics Pistons away 88-96 3&3 47-41 +6 +176' -8 -2.0 7.5 2.8 4.8 L L O 20040105 Celtics Pistons home 68-78 1&1 29-40 -2 +179' -10 -12.0 -33.5 -22.8 -10.8 L L U 20040128 Celtics Pistons home 103-106 2&2 43-44 +2' +181 -3 -0.5 28.0 13.8 14.2 L L O 20050102 Celtics Pistons away 88-100 1&2 43-49 +7 +190' -12 -5.0 -2.5 -3.8 1.2 L L U 20050107 Celtics Pistons home 104-110 1&0 59-49 0 +188' -6 -6.0 25.5 9.8 15.8 L L O 20050311 Celtics Pistons home 115-113 1&1 43-42 +2 +188 2 4.0 40.0 22.0 18.0 W W O 2 20050326 Celtics Pistons away 99-105 0&0 46-42 +5' +188' -6 -0.5 15.5 7.5 8.0 L L O 1 20051104 Celtics Pistons home 81-82 1&1 39-39 +3' +188 -1 2.5 -25.0 -11.2 -13.8 L W U 20051115 Celtics Pistons away 100-115 1&3 53-50 +9 +187' -15 -6.0 27.5 10.8 16.8 L L O 20060116 Celtics Pistons away 84-94 2&1 44-50 +10' +200' -10 0.5 -22.5 -11.0 -11.5 L W U Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20061103 Celtics Pistons home 88-101 1&1 45-42 +2 +193 -13 -11.0 -4.0 -7.5 3.5 L L U 20070113 Celtics Pistons away 73-81 0&0 35-34 +11' +184' -8 3.5 -30.5 -13.5 -17.0 L W U 20070206 Celtics Pistons away 102-109 3&1 56-57 +10' +188 -7 3.5 23.0 13.2 9.8 L W O 20070418 Celtics Pistons home 89-91 1&0 43-46 -2' +188' -2 -4.5 -8.5 -6.5 -2.0 L L U 20071219 Celtics Pistons home 85-87 2&2 49-40 -6 +181' -2 -8.0 -9.5 -8.8 -0.8 L L U 20080105 Celtics Pistons away 92-85 0&0 41-39 +2 +181' 7 9.0 -4.5 2.2 -6.8 W W U 20080305 Celtics Pistons home 90-78 2&0 46-36 -4 +183' 12 8.0 -15.5 -3.8 -11.8 W W U 20080520 Celtics Pistons home 88-79 1&6 52-42 -4' +173 9 4.5 -6.0 -0.8 -5.2 W W U 20080522 Celtics Pistons home 97-103 1&1 48-49 -4 +173 -6 -10.0 27.0 8.5 18.5 L L O 20080524 Celtics Pistons away 94-80 1&1 46-38 +5 +175 14 19.0 -1.0 9.0 -10.0 W W U Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20080526 Celtics Pistons away 75-94 1&1 31-51 +6 +176 -19 -13.0 -7.0 -10.0 3.0 L L U 20080528 Celtics Pistons home 106-102 1&1 50-46 -5' +173 4 -1.5 35.0 16.8 18.2 W L O 20080530 Celtics Pistons away 89-81 1&1 44-42 +5' +175' 8 13.5 -5.5 4.0 -9.5 W W U 20081109 Celtics Pistons away 88-76 1&1 44-34 +1' +185 12 13.5 -21.0 -3.8 -17.2 W W U 20081120 Celtics Pistons home 98-80 1&0 49-42 -7 +183' 18 11.0 -5.5 2.8 -8.2 W W U 20090130 Celtics Pistons away 86-78 1&1 45-40 -5' +180' 8 2.5 -16.5 -7.0 -9.5 W W U 20090301 Celtics Pistons home 95-105 1&1 46-48 -9 +180 -10 -19.0 20.0 0.5 19.5 L L O 20100120 Celtics Pistons away 86-92 1&1 42-42 -5 +187 -6 -11.0 -9.0 -10.0 1.0 L L U 20100302 Celtics Pistons away 105-100 2&2 46-46 -4' +189 5 0.5 16.0 8.2 7.8 W W O 20100315 Celtics Pistons home 119-93 0&1 62-48 -9' +195 26 16.5 17.0 16.8 0.2 W W O

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