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

t:team=Celtics and p:site=away and p:season=season and 20091218<=date
SU: 21-19 (1.0) ATS: 17-23-0 (-1.0) avg line: -1.9 O/U: 19-21-0 (-0.8) avg total: 194.1
Q1 Q2 Q3 Q4 Final Team:   25.2     24.8     24.3     22.7     97.2 Opp:   24.3     24.0     23.6     24.2     96.2
Field Goals Threes Free Throws Blocks O Rbnds Rbnds Fouls Assists TrnOvrs Team: 36.2-76.8 (47.3%) 6.3-17.6 (35.8%) 18.4-25.1 (73.2%) 4.8 9.0 38.5 23.0 22.8 13.7 Opp: 34.9-76.7 (45.4%) 5.8-17.3 (33.7%) 20.6-27.7 (75.0%) 5.2 10.2 40.0 21.8 19.2 14.2
Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20091218 Celtics Seventysixers home 97-98 3&1 45-40 -11' +195' -1 -12.5 -0.5 -6.5 6.0 L L U 20091227 Celtics Clippers away 90-92 1&1 46-50 -8' +190 -2 -10.5 -8.0 -9.2 1.2 L L U 20091228 Celtics Warriors away 99-103 0&1 50-45 -5' +212 -4 -9.5 -10.0 -9.8 -0.2 L L U 20091230 Celtics Suns away 98-116 1&1 42-50 +2' +207' -18 -15.5 6.5 -4.5 11.0 L L O 20100102 Celtics Raptors home 103-96 2&2 51-49 -3' +194' 7 3.5 4.5 4.0 0.5 W W O 20100108 Celtics Hawks away 85-93 1&1 40-49 +3' +195' -8 -4.5 -17.5 -11.0 -6.5 L L U 20100110 Celtics Raptors away 114-107 1&1 50-48 -1 +198 7 6.0 23.0 14.5 8.5 W W O 20100111 Celtics Hawks home 96-102 0&1 55-45 -4 +192 -6 -10.0 6.0 -2.0 8.0 L L O 20100114 Celtics Bulls home 83-96 0&2 45-45 -6' +194' -13 -19.5 -15.5 -17.5 2.0 L L U 20100122 Celtics Trailblazers home 98-95 1&1 48-38 -10' +187 3 -7.5 6.0 -0.8 6.8 W L O 1 20100129 Celtics Hawks away 91-100 0&1 41-47 +4 +190 -9 -5.0 1.0 -2.0 3.0 L L O 20100131 Celtics Lakers home 89-90 1&1 46-47 0 +194' -1 -1.0 -15.5 -8.2 -7.2 L L U 20100203 Celtics Heat home 107-102 1&1 48-52 -6 +183 5 -1.0 26.0 12.5 13.5 W L O 20100216 Celtics Kings away 95-92 5&5 37-38 -5' +199 3 -2.5 -12.0 -7.2 -4.8 W L U 20100218 Celtics Lakers away 87-86 1&1 44-40 +3' +189' 1 4.5 -16.5 -6.0 -10.5 W W U 20100219 Celtics Trailblazers away 96-76 0&2 53-33 +3 +186 20 23.0 -14.0 4.5 -18.5 W W U 20100221 Celtics Nuggets away 105-114 1&1 52-51 +4' +198 -9 -4.5 21.0 8.2 12.8 L L O 20100223 Celtics Knicks home 110-106 1&0 55-52 -9' +199 4 -5.5 17.0 5.8 11.2 W L O 20100303 Celtics Bobcats home 104-80 0&1 53-36 -4' +190 24 19.5 -6.0 6.8 -12.8 W W U 20100307 Celtics Wizards home 86-83 1&1 41-45 -12 +194 3 -9.0 -25.0 -17.0 -8.0 W L U Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20100310 Celtics Grizzlies home 91-111 0&1 43-55 -5 +195 -20 -25.0 7.0 -9.0 16.0 L L 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 20100320 Celtics Mavericks away 102-93 0&2 52-46 +4 +199' 9 13.0 -4.5 4.2 -8.8 W W U 20100322 Celtics Jazz away 97-110 1&1 44-51 +4' +200 -13 -8.5 7.0 -0.8 7.8 L L O 20100324 Celtics Nuggets home 113-99 1&0 48-48 -4' +205' 14 9.5 6.5 8.0 -1.5 W W O 20100407 Celtics Raptors away 115-104 0&0 56-47 -6 +205 11 5.0 14.0 9.5 4.5 W W O 20100409 Celtics Wizards home 96-106 1&1 42-48 -11' +194' -10 -21.5 7.5 -7.0 14.5 L L O 20100413 Celtics Bulls away 93-101 2&1 43-48 +5 +196' -8 -3.0 -2.5 -2.8 0.2 L L U 20100414 Celtics Bucks home 95-106 0&1 47-50 +2' +190 -11 -8.5 11.0 1.2 9.8 L L O 20100425 Celtics Heat away 92-101 1&1 49-50 +1' +185 -9 -7.5 8.0 0.2 7.8 L L O Date Team Opp Site Final Rest FG% Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot 20100427 Celtics Heat home 96-86 1&1 48-39 -6' +188 10 3.5 -6.0 -1.2 -4.8 W W U 20100503 Celtics Cavaliers away 104-86 1&1 51-40 +6' +192' 18 24.5 -2.5 11.0 -13.5 W W U 20100507 Celtics Cavaliers home 95-124 3&3 42-59 0 +193 -29 -29.0 26.0 -1.5 27.5 L L O 20100513 Celtics Cavaliers home 94-85 1&1 44-38 -1 +196 9 8.0 -17.0 -4.5 -12.5 W W U 20100518 Celtics Magic away 95-92 1&1 45-39 +7 +188 3 10.0 -1.0 4.5 -5.5 W W U 20100522 Celtics Magic home 94-71 3&3 46-36 -3' +189' 23 19.5 -24.5 -2.5 -22.0 W W U 20100528 Celtics Magic home 96-84 1&1 42-43 -3' +188' 12 8.5 -8.5 0.0 -8.5 W W U 20100606 Celtics Lakers away 103-94 2&2 42-40 +6 +192' 9 15.0 4.5 9.8 -5.2 W W O 20100608 Celtics Lakers home 84-91 1&1 43-44 -3 +192' -7 -10.0 -17.5 -13.8 -3.8 L L U 20100617 Celtics Lakers away 79-83 1&1 40-32 +7 +187 -4 3.0 -25.0 -11.0 -14.0 L W U

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