You Are Here > Sports-Reference.com > Blog

Blog Archives: MLB · NFL · NBA · NHL · CFB · CBB · Olympics

Archive for the 'Trivia' Category

Where Does Florida State Rank Entering the BCS Championship Game?

Posted by Neil on December 9, 2013

Chase asked where FSU's +42.3 pre-bowl PPG differential ranked among all BCS-bowl teams historically, so I thought I'd run a quick database search:

Year School Pre-Bowl MOV Bowl
2013 Florida State (acc) +42.3 BCSCG (vs. Auburn)
2005 Texas (big-12) +36.3 Rose (W 41-38 vs. Southern California)
2001 Miami (FL) (big-east) +33.8 Rose (W 37-14 vs. Nebraska)
2008 Florida (sec) +32.3 BCSCG (W 24-14 vs. Oklahoma)
2000 Florida State (acc) +32.2 Orange (L 2-13 vs. Oklahoma)
2013 Baylor (big-12) +32.1 Fiesta (vs. Central Florida)
2010 Texas Christian (mwc) +31.9 Rose (W 21-19 vs. Wisconsin)
2010 Oregon (pac-10) +30.9 BCSCG (L 19-22 vs. Auburn)
1999 Virginia Tech (big-east) +30.8 Sugar (L 29-46 vs. Florida State)
2003 Oklahoma (big-12) +30.3 Sugar (L 14-21 vs. Louisiana State)
2008 Southern California (pac-10) +29.8 Rose (W 38-24 vs. Penn State)
2001 Florida (sec) +29.7 Orange (W 56-23 vs. Maryland)
2008 Oklahoma (big-12) +29.5 BCSCG (L 14-24 vs. Florida)
2012 Oregon (pac-12) +28.8 Fiesta (W 35-17 vs. Kansas State)
2005 Southern California (pac-10) +28.7 Rose (L 38-41 vs. Texas)
2007 Kansas (big-12) +28.3 Orange (W 24-21 vs. Virginia Tech)
2009 Texas Christian (mwc) +28.3 Fiesta (L 10-17 vs. Boise State)
2011 Louisiana State (sec) +27.9 BCSCG (L 0-21 vs. Alabama)
2012 Alabama (sec) +27.8 BCSCG (W 42-14 vs. Notre Dame)
2008 Penn State (big-ten) +27.8 Rose (L 24-38 vs. Southern California)
2011 Wisconsin (big-ten) +27.6 Rose (L 38-45 vs. Oregon)
2013 Alabama (sec) +27.4 Sugar (vs. Oklahoma)
2000 Miami (FL) (big-east) +27.2 Sugar (W 37-20 vs. Florida)
2011 Alabama (sec) +27.2 BCSCG (W 21-0 vs. Louisiana State)
2009 Boise State (wac) +26.5 Fiesta (W 17-10 vs. Texas Christian)
2010 Ohio State (big-ten) +26.1 Sugar (W 31-26 vs. Arkansas)
2006 Ohio State (big-ten) +25.9 BCSCG (L 14-41 vs. Florida)
2004 Utah (mwc) +25.6 Fiesta (W 35-7 vs. Pittsburgh)
2009 Texas (big-12) +25.5 BCSCG (L 21-37 vs. Alabama)
2008 Texas (big-12) +25.3 Fiesta (W 24-21 vs. Ohio State)
2007 Oklahoma (big-12) +25.2 Fiesta (L 28-48 vs. West Virginia)
1998 Ohio State (big-ten) +25.1 Sugar (W 24-14 vs. Texas A&M)
2013 Ohio State (big-ten) +25.0 Orange (vs. Clemson)
2012 Florida State (acc) +24.8 Orange (W 31-10 vs. Northern Illinois)
2004 Southern California (pac-10) +24.3 Orange (W 55-19 vs. Oklahoma)
2003 Louisiana State (sec) +24.2 Sugar (W 21-14 vs. Oklahoma)
2006 Boise State (wac) +23.8 Fiesta (W 43-42 vs. Oklahoma)
2002 Miami (FL) (big-east) +23.8 Fiesta (L 24-31 vs. Ohio State)
2011 Oklahoma State (big-12) +23.5 Fiesta (W 41-38 vs. Stanford)
2002 Oklahoma (big-12) +23.5 Rose (W 34-14 vs. Washington State)
2003 Southern California (pac-10) +23.4 Rose (W 28-14 vs. Michigan)
2011 Stanford (pac-12) +23.3 Fiesta (L 38-41 vs. Oklahoma State)
2009 Florida (sec) +23.2 Sugar (W 51-24 vs. Cincinnati)
2000 Oklahoma (big-12) +23.0 Orange (W 13-2 vs. Florida State)
2010 Wisconsin (big-ten) +22.8 Rose (L 19-21 vs. Texas Christian)
2011 Oregon (pac-12) +22.5 Rose (W 45-38 vs. Wisconsin)
2010 Stanford (pac-10) +22.5 Orange (W 40-12 vs. Virginia Tech)
1999 Wisconsin (big-ten) +22.5 Rose (W 17-9 vs. Stanford)
2004 Oklahoma (big-12) +22.4 Orange (L 19-55 vs. Southern California)
2006 Louisville (big-east) +22.3 Orange (W 24-13 vs. Wake Forest)
2003 Kansas State (big-12) +22.3 Fiesta (L 28-35 vs. Ohio State)
2004 Auburn (sec) +22.3 Sugar (W 16-13 vs. Virginia Tech)
2007 Hawaii (wac) +22.0 Sugar (L 10-41 vs. Georgia)
2012 Northern Illinois (mac) +21.8 Orange (L 10-31 vs. Florida State)
1999 Nebraska (big-12) +21.8 Fiesta (W 31-21 vs. Tennessee)
2007 West Virginia (big-east) +21.7 Fiesta (W 48-28 vs. Oklahoma)
2001 Nebraska (big-12) +21.7 Rose (L 14-37 vs. Miami (FL))
1999 Florida State (acc) +21.6 Sugar (W 46-29 vs. Virginia Tech)
2007 Ohio State (big-ten) +21.3 BCSCG (L 24-38 vs. Louisiana State)
2003 Michigan (big-ten) +21.3 Rose (L 14-28 vs. Southern California)
1998 Wisconsin (big-ten) +21.1 Rose (W 38-31 vs. UCLA)
2002 Iowa (big-ten) +20.8 Orange (L 17-38 vs. Southern California)
2009 Alabama (sec) +20.7 BCSCG (W 37-21 vs. Texas)
2006 Louisiana State (sec) +20.6 Sugar (W 41-14 vs. Notre Dame)
1998 Florida State (acc) +20.6 Fiesta (L 16-23 vs. Tennessee)
2008 Utah (mwc) +20.2 Sugar (W 31-17 vs. Alabama)
2004 Virginia Tech (acc) +19.7 Sugar (L 13-16 vs. Auburn)
2012 Kansas State (big-12) +19.6 Fiesta (L 17-35 vs. Oregon)
1998 Tennessee (sec) +19.6 Fiesta (W 23-16 vs. Florida State)
2009 Cincinnati (big-east) +19.1 Sugar (L 24-51 vs. Florida)
2013 Clemson (acc) +19.1 Orange (vs. Ohio State)
2007 Louisiana State (sec) +19.1 BCSCG (W 38-24 vs. Ohio State)
2004 Texas (big-12) +18.8 Rose (W 38-37 vs. Michigan)
2005 Penn State (big-ten) +18.7 Orange (W 26-23 vs. Florida State)
2010 Auburn (sec) +18.2 BCSCG (W 22-19 vs. Oregon)
2008 Alabama (sec) +18.2 Sugar (L 17-31 vs. Utah)
1998 Syracuse (big-east) +18.1 Orange (L 10-31 vs. Florida)
2005 Ohio State (big-ten) +17.7 Fiesta (W 34-20 vs. Notre Dame)
2000 Florida (sec) +17.7 Sugar (L 20-37 vs. Miami (FL))
1998 Florida (sec) +17.6 Orange (W 31-10 vs. Syracuse)
2002 Georgia (sec) +17.3 Sugar (W 26-13 vs. Florida State)
2009 Ohio State (big-ten) +17.1 Rose (W 26-17 vs. Oregon)
2013 Michigan State (big-ten) +17.1 Rose (vs. Stanford)
2011 Michigan (big-ten) +17.0 Sugar (W 23-20 vs. Virginia Tech)
2003 Florida State (acc) +17.0 Orange (L 14-16 vs. Miami (FL))
2002 Southern California (pac-10) +17.0 Orange (W 38-17 vs. Iowa)
2002 Ohio State (big-ten) +16.9 Fiesta (W 31-24 vs. Miami (FL))
1999 Tennessee (sec) +16.8 Fiesta (L 21-31 vs. Nebraska)
2010 Virginia Tech (acc) +16.5 Orange (L 12-40 vs. Stanford)
2012 Notre Dame (independent) +16.4 BCSCG (L 14-42 vs. Alabama)
2001 Maryland (acc) +16.4 Orange (L 23-56 vs. Florida)
2013 Auburn (sec) +16.2 BCSCG (vs. Florida State)
2006 Michigan (big-ten) +15.6 Rose (L 18-32 vs. Southern California)
2006 Southern California (pac-10) +15.4 Rose (W 32-18 vs. Michigan)
2006 Florida (sec) +15.4 BCSCG (W 41-14 vs. Ohio State)
2007 Southern California (pac-10) +15.3 Rose (W 49-17 vs. Illinois)
2005 West Virginia (big-east) +15.3 Sugar (W 38-35 vs. Georgia)
2008 Ohio State (big-ten) +15.1 Fiesta (L 21-24 vs. Texas)
2013 Stanford (pac-12) +14.6 Rose (vs. Michigan State)
2010 Arkansas (sec) +14.6 Sugar (L 26-31 vs. Ohio State)
2005 Notre Dame (independent) +14.5 Fiesta (L 20-34 vs. Ohio State)
2005 Georgia (sec) +14.5 Sugar (L 35-38 vs. West Virginia)
2010 Oklahoma (big-12) +14.5 Fiesta (W 48-20 vs. Connecticut)
2000 Oregon State (pac-10) +14.2 Fiesta (W 41-9 vs. Notre Dame)
2009 Oregon (pac-10) +14.1 Rose (L 17-26 vs. Ohio State)
2006 Oklahoma (big-12) +14.1 Fiesta (L 42-43 vs. Boise State)
2007 Virginia Tech (acc) +13.8 Orange (L 21-24 vs. Kansas)
2012 Florida (sec) +13.8 Sugar (L 23-33 vs. Louisville)
2003 Miami (FL) (big-east) +13.6 Orange (W 16-14 vs. Florida State)
2013 Central Florida (american) +13.6 Fiesta (vs. Baylor)
1998 UCLA (pac-10) +13.0 Rose (L 31-38 vs. Wisconsin)
2002 Washington State (pac-10) +12.9 Rose (L 14-34 vs. Oklahoma)
2001 Oregon (pac-10) +12.2 Fiesta (W 38-16 vs. Colorado)
2012 Wisconsin (big-ten) +11.7 Rose (L 14-20 vs. Stanford)
2000 Purdue (big-ten) +11.4 Rose (L 24-34 vs. Washington)
2011 Virginia Tech (acc) +11.3 Sugar (L 20-23 vs. Michigan)
2012 Stanford (pac-12) +11.0 Rose (W 20-14 vs. Wisconsin)
2007 Georgia (sec) +10.9 Sugar (W 41-10 vs. Hawaii)
2002 Florida State (acc) +10.8 Sugar (L 13-26 vs. Georgia)
2001 Illinois (big-ten) +10.7 Sugar (L 34-47 vs. Louisiana State)
2000 Notre Dame (independent) +10.7 Fiesta (L 9-41 vs. Oregon State)
2013 Oklahoma (big-12) +10.5 Sugar (vs. Alabama)
2009 Georgia Tech (acc) +10.5 Orange (L 14-24 vs. Iowa)
1999 Michigan (big-ten) +10.3 Orange (W 35-34 vs. Alabama)
1998 Texas A&M (big-12) +10.1 Sugar (L 14-24 vs. Ohio State)
2006 Notre Dame (independent) +10.0 Sugar (L 14-41 vs. Louisiana State)
2000 Washington (pac-10) +9.7 Rose (W 34-24 vs. Purdue)
2001 Colorado (big-12) +9.7 Fiesta (L 16-38 vs. Oregon)
1999 Alabama (sec) +9.5 Orange (L 34-35 vs. Michigan)
2007 Illinois (big-ten) +9.3 Rose (L 17-49 vs. Southern California)
2011 West Virginia (big-east) +8.7 Orange (W 70-33 vs. Clemson)
2001 Louisiana State (sec) +8.6 Sugar (W 47-34 vs. Illinois)
2004 Michigan (big-ten) +8.4 Rose (L 37-38 vs. Texas)
2005 Florida State (acc) +7.8 Orange (L 23-26 vs. Penn State)
2009 Iowa (big-ten) +7.6 Orange (W 24-14 vs. Georgia Tech)
2006 Wake Forest (acc) +7.5 Orange (L 13-24 vs. Louisville)
2011 Clemson (acc) +7.5 Orange (L 33-70 vs. West Virginia)
2012 Louisville (big-east) +7.2 Sugar (W 33-23 vs. Florida)
2003 Ohio State (big-ten) +7.2 Fiesta (W 35-28 vs. Kansas State)
2008 Cincinnati (big-east) +7.2 Orange (L 7-20 vs. Virginia Tech)
2010 Connecticut (big-east) +7.1 Fiesta (L 20-48 vs. Oklahoma)
2004 Pittsburgh (big-east) +5.9 Fiesta (L 7-35 vs. Utah)
1999 Stanford (pac-10) +5.6 Rose (L 9-17 vs. Wisconsin)
2008 Virginia Tech (acc) +4.8 Orange (W 20-7 vs. Cincinnati)

6 Comments | Posted in Advanced Stats, Announcement, CFB at Sports Reference, History, Pro-Football-Reference.com, SRS, Stat Questions, Statgeekery, Trivia

Historical Western Conference vs Eastern Conference Disparity

Posted by Neil on December 5, 2013

In light of the Eastern Conference's "embarrassing" showing in games against the West so far this year, here's a rundown of how each conference has fared against the other for every year since 1951 (before 1971, the NBA had Eastern and Western "divisions" which were de facto conferences):

+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
| year_id | east_w | east_l | east_wpct | west_w | west_l | west_wpct | e_vs_w | w_vs_e | e_h2h | w_h2h |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
|    2014 |    118 |    155 | 43.2%     |    157 |    120 | 56.7%     |     26 |     63 | 29.2% | 70.8% |
|    2013 |    577 |    651 | 47.0%     |    652 |    578 | 53.0%     |    188 |    262 | 41.8% | 58.2% |
|    2012 |    474 |    516 | 47.9%     |    516 |    474 | 52.1%     |    114 |    156 | 42.2% | 57.8% |
|    2011 |    579 |    651 | 47.1%     |    651 |    579 | 52.9%     |    189 |    261 | 42.0% | 58.0% |
|    2010 |    594 |    636 | 48.3%     |    636 |    594 | 51.7%     |    204 |    246 | 45.3% | 54.7% |
|    2009 |    621 |    609 | 50.5%     |    609 |    621 | 49.5%     |    231 |    219 | 51.3% | 48.7% |
|    2008 |    582 |    648 | 47.3%     |    648 |    582 | 52.7%     |    192 |    258 | 42.7% | 57.3% |
|    2007 |    583 |    647 | 47.4%     |    647 |    583 | 52.6%     |    193 |    257 | 42.9% | 57.1% |
|    2006 |    588 |    642 | 47.8%     |    642 |    588 | 52.2%     |    198 |    252 | 44.0% | 56.0% |
|    2005 |    584 |    646 | 47.5%     |    646 |    584 | 52.5%     |    194 |    256 | 43.1% | 56.9% |
|    2004 |    559 |    671 | 45.4%     |    630 |    518 | 54.9%     |    154 |    266 | 36.7% | 63.3% |
|    2003 |    575 |    655 | 46.7%     |    614 |    534 | 53.5%     |    170 |    250 | 40.5% | 59.5% |
|    2002 |    593 |    637 | 48.2%     |    596 |    552 | 51.9%     |    188 |    232 | 44.8% | 55.2% |
|    2001 |    566 |    664 | 46.0%     |    623 |    525 | 54.3%     |    161 |    259 | 38.3% | 61.7% |
|    2000 |    598 |    632 | 48.6%     |    591 |    557 | 51.5%     |    193 |    227 | 46.0% | 54.0% |
|    1999 |    379 |    371 | 50.5%     |    346 |    354 | 49.4%     |     46 |     38 | 54.8% | 45.2% |
|    1998 |    648 |    582 | 52.7%     |    541 |    607 | 47.1%     |    243 |    177 | 57.9% | 42.1% |
|    1997 |    647 |    583 | 52.6%     |    542 |    606 | 47.2%     |    242 |    178 | 57.6% | 42.4% |
|    1996 |    619 |    611 | 50.3%     |    570 |    578 | 49.7%     |    214 |    206 | 51.0% | 49.0% |
|    1995 |    550 |    598 | 47.9%     |    557 |    509 | 52.3%     |    158 |    206 | 43.4% | 56.6% |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
| year_id | east_w | east_l | east_wpct | west_w | west_l | west_wpct | e_vs_w | w_vs_e | e_h2h | w_h2h |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
|    1994 |    562 |    586 | 49.0%     |    545 |    521 | 51.1%     |    170 |    194 | 46.7% | 53.3% |
|    1993 |    583 |    565 | 50.8%     |    524 |    542 | 49.2%     |    191 |    173 | 52.5% | 47.5% |
|    1992 |    573 |    575 | 49.9%     |    534 |    532 | 50.1%     |    181 |    183 | 49.7% | 50.3% |
|    1991 |    521 |    545 | 48.9%     |    586 |    562 | 51.0%     |    170 |    194 | 46.7% | 53.3% |
|    1990 |    517 |    549 | 48.5%     |    590 |    558 | 51.4%     |    166 |    198 | 45.6% | 54.4% |
|    1989 |    522 |    462 | 53.0%     |    503 |    563 | 47.2%     |    186 |    126 | 59.6% | 40.4% |
|    1988 |    464 |    438 | 51.4%     |    479 |    505 | 48.7%     |    145 |    119 | 54.9% | 45.1% |
|    1987 |    465 |    437 | 51.6%     |    478 |    506 | 48.6%     |    146 |    118 | 55.3% | 44.7% |
|    1986 |    460 |    442 | 51.0%     |    483 |    501 | 49.1%     |    141 |    123 | 53.4% | 46.6% |
|    1985 |    462 |    440 | 51.2%     |    481 |    503 | 48.9%     |    143 |    121 | 54.2% | 45.8% |
|    1984 |    461 |    441 | 51.1%     |    482 |    502 | 49.0%     |    142 |    122 | 53.8% | 46.2% |
|    1983 |    458 |    444 | 50.8%     |    485 |    499 | 49.3%     |    139 |    125 | 52.7% | 47.3% |
|    1982 |    461 |    441 | 51.1%     |    482 |    502 | 49.0%     |    142 |    122 | 53.8% | 46.2% |
|    1981 |    466 |    436 | 51.7%     |    477 |    507 | 48.5%     |    147 |    117 | 55.7% | 44.3% |
|    1980 |    454 |    448 | 50.3%     |    448 |    454 | 49.7%     |    124 |    118 | 51.2% | 48.8% |
|    1979 |    425 |    477 | 47.1%     |    477 |    425 | 52.9%     |    205 |    257 | 44.4% | 55.6% |
|    1978 |    428 |    474 | 47.5%     |    474 |    428 | 52.5%     |    208 |    254 | 45.0% | 55.0% |
|    1977 |    436 |    466 | 48.3%     |    466 |    436 | 51.7%     |    216 |    246 | 46.8% | 53.2% |
|    1976 |    388 |    350 | 52.6%     |    350 |    388 | 47.4%     |    181 |    143 | 55.9% | 44.1% |
|    1975 |    378 |    360 | 51.2%     |    360 |    378 | 48.8%     |    171 |    153 | 52.8% | 47.2% |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
| year_id | east_w | east_l | east_wpct | west_w | west_l | west_wpct | e_vs_w | w_vs_e | e_h2h | w_h2h |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
|    1974 |    315 |    341 | 48.0%     |    382 |    356 | 51.8%     |    131 |    157 | 45.5% | 54.5% |
|    1973 |    318 |    338 | 48.5%     |    379 |    359 | 51.4%     |    134 |    154 | 46.5% | 53.5% |
|    1972 |    283 |    373 | 43.1%     |    414 |    324 | 56.1%     |    125 |    215 | 36.8% | 63.2% |
|    1971 |    291 |    365 | 44.4%     |    406 |    332 | 55.0%     |    139 |    213 | 39.5% | 60.5% |
|    1970 |    309 |    265 | 53.8%     |    265 |    309 | 46.2%     |    169 |    125 | 57.5% | 42.5% |
|    1969 |    314 |    260 | 54.7%     |    260 |    314 | 45.3%     |    176 |    122 | 59.1% | 40.9% |
|    1968 |    274 |    218 | 55.7%     |    218 |    274 | 44.3%     |    154 |     98 | 61.1% | 38.9% |
|    1967 |    223 |    182 | 55.1%     |    182 |    223 | 44.9%     |    133 |     92 | 59.1% | 40.9% |
|    1966 |    184 |    136 | 57.5%     |    176 |    224 | 44.0%     |    124 |     76 | 62.0% | 38.0% |
|    1965 |    181 |    139 | 56.6%     |    179 |    221 | 44.8%     |    121 |     79 | 60.5% | 39.5% |
|    1964 |    170 |    150 | 53.1%     |    190 |    210 | 47.5%     |     98 |     78 | 55.7% | 44.3% |
|    1963 |    169 |    151 | 52.8%     |    191 |    209 | 47.8%     |     97 |     79 | 55.1% | 44.9% |
|    1962 |    179 |    141 | 55.9%     |    181 |    219 | 45.3%     |    107 |     69 | 60.8% | 39.2% |
|    1961 |    162 |    154 | 51.3%     |    154 |    162 | 48.7%     |     84 |     76 | 52.5% | 47.5% |
|    1960 |    180 |    120 | 60.0%     |    120 |    180 | 40.0%     |    102 |     42 | 70.8% | 29.2% |
|    1959 |    159 |    129 | 55.2%     |    129 |    159 | 44.8%     |     87 |     57 | 60.4% | 39.6% |
|    1958 |    162 |    126 | 56.3%     |    126 |    162 | 43.8%     |     90 |     54 | 62.5% | 37.5% |
|    1957 |    155 |    133 | 53.8%     |    133 |    155 | 46.2%     |     83 |     61 | 57.6% | 42.4% |
|    1956 |    154 |    134 | 53.5%     |    134 |    154 | 46.5%     |     82 |     62 | 56.9% | 43.1% |
|    1955 |    150 |    138 | 52.1%     |    138 |    150 | 47.9%     |     78 |     66 | 54.2% | 45.8% |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
| year_id | east_w | east_l | east_wpct | west_w | west_l | west_wpct | e_vs_w | w_vs_e | e_h2h | w_h2h |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+
|    1954 |    173 |    187 | 48.1%     |    151 |    137 | 52.4%     |     73 |     87 | 45.6% | 54.4% |
|    1953 |    168 |    183 | 47.9%     |    183 |    168 | 52.1%     |     67 |     82 | 45.0% | 55.0% |
|    1952 |    169 |    161 | 51.2%     |    161 |    169 | 48.8%     |     79 |     71 | 52.7% | 47.3% |
|    1951 |    181 |    187 | 49.2%     |    173 |    167 | 50.9%     |     80 |     86 | 48.2% | 51.8% |
+---------+--------+--------+-----------+--------+--------+-----------+--------+--------+-------+-------+

In the early stages of 2013-14, we are indeed seeing an historic level of inter-conference imbalance. The West's 70.8% winning percentage vs. the East is tied for the highest by one conference/division vs the other, matching the mark set by the Eastern Division in 1960.

Powered by the transcendent 59-16 Celtics (who won 10 more games than any other team), the 49-26 Philadelphia Warriors, and the 45-30 Syracuse Nationals, the East dominated a Western Division that boasted only one team -- the 46-29 St. Louis Hawks -- with a record anywhere near .500. (Aside from St. Louis, the other West teams had a combined 74-151 record that season.)

10 Comments | Posted in Announcement, Basketball-Reference.com, History, Trivia

NFL Team Records vs. Each Division Since 2002

Posted by Neil on October 24, 2013

A user wrote in asking how many games each team has played vs. every division since the 2002 expansion set up the NFL's current 8-division alignment. Since we don't currently have that function in the Team Game Finder (though we might someday), I figured I'd just run a quick database search on the subject...

First, records vs. the AFC divisions:

+---------+-----------+--------------+--------------+--------------+--------------+
| team_id | division  |   AFC East   |  AFC North   |  AFC South   |   AFC West   |
+---------+-----------+--------------+--------------+--------------+--------------+
| atl     | NFC South | 11 (6-5-0)   | 12 (7-4-1)   | 12 (5-7-0)   | 12 (10-2-0)  |
| buf     | AFC East  | 69 (23-46-0) | 23 (11-12-0) | 23 (8-15-0)  | 23 (11-12-0) |
| car     | NFC South |  9 (3-6-0)   | 12 (5-7-0)   | 12 (5-7-0)   | 12 (7-5-0)   |
| chi     | NFC North | 12 (6-6-0)   | 10 (5-5-0)   | 12 (6-6-0)   | 12 (7-5-0)   |
| cin     | AFC North | 22 (6-16-0)  | 68 (32-36-0) | 23 (10-13-0) | 23 (11-12-0) |
| cle     | AFC North | 22 (12-10-0) | 68 (17-51-0) | 23 (10-13-0) | 23 (9-14-0)  |
| clt     | AFC South | 24 (13-11-0) | 23 (18-5-0)  | 67 (49-18-0) | 23 (15-8-0)  |
| crd     | NFC West  | 12 (5-7-0)   | 12 (5-7-0)   |  8 (3-5-0)   | 12 (2-10-0)  |
| dal     | NFC East  | 12 (7-5-0)   | 12 (6-6-0)   | 12 (7-5-0)   | 11 (4-7-0)   |
| den     | AFC West  | 23 (12-11-0) | 24 (18-6-0)  | 22 (9-13-0)  | 67 (39-28-0) |
| det     | NFC North | 12 (2-10-0)  | 10 (4-6-0)   | 12 (2-10-0)  | 12 (8-4-0)   |
| gnb     | NFC North | 12 (6-6-0)   | 11 (4-7-0)   | 12 (5-7-0)   | 12 (10-2-0)  |
| htx     | AFC South | 23 (12-11-0) | 24 (10-14-0) | 67 (26-41-0) | 22 (11-11-0) |
| jax     | AFC South | 23 (9-14-0)  | 23 (9-14-0)  | 67 (26-41-0) | 24 (13-11-0) |
| kan     | AFC West  | 23 (8-15-0)  | 23 (9-14-0)  | 23 (11-12-0) | 67 (30-37-0) |
| mia     | AFC East  | 67 (26-41-0) | 22 (7-15-0)  | 24 (8-16-0)  | 23 (16-7-0)  |
| min     | NFC North | 12 (2-10-0)  | 10 (5-5-0)   | 12 (8-4-0)   | 12 (4-8-0)   |
| nor     | NFC South | 10 (7-3-0)   | 12 (5-7-0)   | 12 (6-6-0)   | 12 (7-5-0)   |
| nwe     | AFC East  | 69 (55-14-0) | 21 (15-6-0)  | 23 (17-6-0)  | 23 (14-9-0)  |
| nyg     | NFC East  | 12 (8-4-0)   | 12 (5-7-0)   | 12 (5-7-0)   | 10 (5-5-0)   |
| nyj     | AFC East  | 69 (33-36-0) | 21 (9-12-0)  | 24 (14-10-0) | 23 (12-11-0) |
| oti     | AFC South | 24 (13-11-0) | 24 (13-11-0) | 67 (33-34-0) | 22 (7-15-0)  |
| phi     | NFC East  | 12 (8-4-0)   | 12 (6-5-1)   | 12 (5-7-0)   | 11 (5-6-0)   |
| pit     | AFC North | 21 (14-7-0)  | 68 (47-21-0) | 24 (12-12-0) | 23 (11-12-0) |
| rai     | AFC West  | 23 (8-15-0)  | 23 (9-14-0)  | 22 (7-15-0)  | 69 (24-45-0) |
| ram     | NFC West  | 12 (2-10-0)  | 12 (5-7-0)   | 10 (5-5-0)   | 12 (6-6-0)   |
| rav     | AFC North | 22 (13-9-0)  | 68 (40-28-0) | 24 (12-12-0) | 24 (15-9-0)  |
| sdg     | AFC West  | 23 (11-12-0) | 23 (11-12-0) | 24 (18-6-0)  | 67 (42-25-0) |
| sea     | NFC West  | 12 (5-7-0)   | 12 (5-7-0)   | 12 (7-5-0)   | 12 (5-7-0)   |
| sfo     | NFC West  | 12 (6-6-0)   | 12 (5-7-0)   | 11 (4-7-0)   | 12 (6-6-0)   |
| tam     | NFC South | 10 (2-8-0)   | 12 (7-5-0)   | 12 (3-9-0)   | 12 (5-7-0)   |
| was     | NFC East  | 12 (4-8-0)   | 12 (3-9-0)   | 12 (7-5-0)   |  9 (3-6-0)   |
+---------+-----------+--------------+--------------+--------------+--------------+

And the NFC divisions:

+---------+-----------+--------------+--------------+--------------+--------------+
| team_id | division  |   NFC East   |  NFC North   |  NFC South   |   NFC West   |
+---------+-----------+--------------+--------------+--------------+--------------+
| atl     | NFC South | 23 (12-11-0) | 23 (13-10-0) | 68 (34-34-0) | 21 (15-6-0)  |
| buf     | AFC East  | 12 (5-7-0)   | 12 (6-6-0)   | 9 (3-6-0)    | 12 (7-5-0)   |
| car     | NFC South | 24 (8-16-0)  | 24 (12-12-0) | 66 (34-32-0) | 23 (15-8-0)  |
| chi     | NFC North | 22 (10-12-0) | 68 (37-31-0) | 24 (13-11-0) | 23 (12-11-0) |
| cin     | AFC North | 12 (8-3-1)   | 11 (9-2-0)   | 12 (4-8-0)   | 12 (6-6-0)   |
| cle     | AFC North | 12 (2-10-0)  | 11 (3-8-0)   | 12 (5-7-0)   | 12 (6-6-0)   |
| clt     | AFC South | 12 (7-5-0)   | 12 (9-3-0)   | 12 (7-5-0)   | 10 (9-1-0)   |
| crd     | NFC West  | 23 (10-13-0) | 24 (10-14-0) | 23 (8-15-0)  | 69 (30-39-0) |
| dal     | NFC East  | 69 (35-34-0) | 20 (10-10-0) | 23 (15-8-0)  | 24 (14-10-0) |
| den     | AFC West  | 11 (8-3-0)   | 12 (4-8-0)   | 12 (9-3-0)   | 12 (6-6-0)   |
| det     | NFC North | 21 (8-13-0)  | 69 (16-53-0) | 23 (8-15-0)  | 24 (7-17-0)  |
| gnb     | NFC North | 21 (12-9-0)  | 67 (48-19-0) | 23 (12-11-0) | 24 (17-7-0)  |
| htx     | AFC South | 12 (3-9-0)   | 12 (6-6-0)   | 12 (7-5-0)   | 11 (4-7-0)   |
| jax     | AFC South | 12 (6-6-0)   | 12 (5-7-0)   | 12 (6-6-0)   | 10 (4-6-0)   |
| kan     | AFC West  | 11 (5-6-0)   | 12 (7-5-0)   | 12 (3-9-0)   | 12 (10-2-0)  |
| mia     | AFC East  | 12 (4-8-0)   | 12 (7-5-0)   | 10 (5-5-0)   | 12 (7-5-0)   |
| min     | NFC North | 21 (10-11-0) | 68 (35-33-0) | 24 (9-15-0)  | 23 (15-8-0)  |
| nor     | NFC South | 23 (15-8-0)  | 24 (12-12-0) | 68 (37-31-0) | 21 (13-8-0)  |
| nwe     | AFC East  | 12 (10-2-0)  | 12 (11-1-0)  | 11 (9-2-0)   | 12 (9-3-0)   |
| nyg     | NFC East  | 68 (37-31-0) | 22 (11-11-0) | 24 (12-12-0) | 23 (15-8-0)  |
| nyj     | AFC East  | 12 (2-10-0)  | 12 (8-4-0)   | 10 (5-5-0)   | 12 (7-5-0)   |
| oti     | AFC South | 12 (8-4-0)   | 12 (7-5-0)   | 12 (9-3-0)   | 10 (5-5-0)   |
| phi     | NFC East  | 69 (41-28-0) | 20 (12-8-0)  | 24 (15-9-0)  | 23 (14-9-0)  |
| pit     | AFC North | 12 (9-3-0)   | 10 (7-3-0)   | 12 (8-3-1)   | 12 (7-5-0)   |
| rai     | AFC West  | 9 (3-6-0)    | 12 (3-9-0)   | 12 (3-9-0)   | 12 (5-7-0)   |
| ram     | NFC West  | 24 (7-17-0)  | 23 (8-15-0)  | 22 (8-14-0)  | 68 (25-42-1) |
| rav     | AFC North | 12 (8-4-0)   | 9 (4-5-0)    | 12 (6-6-0)   | 12 (9-3-0)   |
| sdg     | AFC West  | 10 (8-2-0)   | 12 (5-7-0)   | 12 (4-8-0)   | 12 (8-4-0)   |
| sea     | NFC West  | 23 (9-14-0)  | 23 (13-10-0) | 21 (12-9-0)  | 68 (42-26-0) |
| sfo     | NFC West  | 23 (8-15-0)  | 24 (12-12-0) | 20 (5-15-0)  | 69 (39-29-1) |
| tam     | NFC South | 24 (9-15-0)  | 23 (15-8-0)  | 68 (30-38-0) | 21 (10-11-0) |
| was     | NFC East  | 68 (24-44-0) | 23 (12-11-0) | 23 (8-15-0)  | 23 (16-7-0)  |
+---------+-----------+--------------+--------------+--------------+--------------+

Comments Off | Posted in Announcement, Data, Pro-Football-Reference.com, Stat Questions, Trivia

Worst. Monday Night Football Matchup. Ever. (By combined winning percentage)

Posted by Neil on October 21, 2013

Just a quick hit of a post to let you know that tonight's MNF matchup between the 0-6 Giants and the 1-4 Vikings is, in fact, the worst ever this late in the season by combined winning percentage:

+--------------+------+---+----+---+-----+-----+------+---+----+---+-----+-----+---------+----------+------------+-----------+--------------+-------------+
|   game_id    | home | W | L  | T | PF  | PA  | road | W | L  | T | PF  | PA  | year_id | week_num | game_date  | comb_wpct | comb_pt_diff |   winner    |
+--------------+------+---+----+---+-----+-----+------+---+----+---+-----+-----+---------+----------+------------+-----------+--------------+-------------+
| 201310210nyg | nyg  | 0 |  6 | 0 | 103 | 209 | min  | 1 |  4 | 0 | 125 | 158 |    2013 |        7 | 10/21/2013 | .091      | -12.6        | NULL        |
| 197512150sdg | sdg  | 1 | 11 | 0 | 148 | 282 | nyj  | 3 |  9 | 0 | 221 | 378 |    1975 |       13 | 12/15/1975 | .167      | -12.1        | sdg, 24-16  |
| 199411210oti | oti  | 1 |  9 | 0 | 147 | 218 | nyg  | 3 |  7 | 0 | 171 | 220 |    1994 |       12 | 11/21/1994 | .200      | -6.0         | nyg, 13-10  |
| 197211060nwe | nwe  | 2 |  5 | 0 |  92 | 220 | clt  | 1 |  6 | 0 |  94 | 145 |    1972 |        8 | 11/6/1972  | .214      | -12.8        | clt, 24-17  |
| 197011020pit | pit  | 2 |  4 | 0 |  71 |  94 | cin  | 1 |  5 | 0 |  93 | 156 |    1970 |        7 | 11/2/1970  | .250      | -7.2         | pit, 21-10  |
| 198110190det | det  | 2 |  4 | 0 | 118 | 126 | chi  | 1 |  5 | 0 |  89 | 133 |    1981 |        7 | 10/19/1981 | .250      | -4.3         | det, 48-17  |
| 199710200clt | clt  | 0 |  6 | 0 |  88 | 155 | buf  | 3 |  3 | 0 | 122 | 159 |    1997 |        8 | 10/20/1997 | .250      | -8.7         | buf, 9-6    |
| 201211260phi | phi  | 3 |  7 | 0 | 162 | 252 | car  | 2 |  8 | 0 | 184 | 243 |    2012 |       12 | 11/26/2012 | .250      | -7.5         | car, 30-22  |
| 200001030atl | atl  | 4 | 11 | 0 | 251 | 351 | sfo  | 4 | 11 | 0 | 266 | 419 |    1999 |       17 | 1/3/2000   | .267      | -8.4         | atl, 34-29  |
| 200512190rav | rav  | 4 |  9 | 0 | 171 | 253 | gnb  | 3 | 10 | 0 | 255 | 255 |    2005 |       15 | 12/19/2005 | .269      | -3.2         | rav, 48-3   |
| 198310240crd | crd  | 2 |  5 | 0 | 137 | 218 | nyg  | 2 |  5 | 0 | 126 | 156 |    1983 |        8 | 10/24/1983 | .286      | -7.9         | tie (20-20) |
| 201112120sea | sea  | 5 |  7 | 0 | 216 | 246 | ram  | 2 | 10 | 0 | 140 | 296 |    2011 |       14 | 12/12/2011 | .292      | -7.8         | sea, 30-13  |
| 201011290crd | crd  | 3 |  7 | 0 | 188 | 292 | sfo  | 3 |  7 | 0 | 160 | 219 |    2010 |       12 | 11/29/2010 | .300      | -8.2         | sfo, 27-6   |
| 200911160cle | cle  | 1 |  7 | 0 |  78 | 209 | rav  | 4 |  4 | 0 | 206 | 154 |    2009 |       10 | 11/16/2009 | .313      | -4.9         | rav, 16-0   |
| 198011240nor | nor  | 0 | 11 | 0 | 181 | 341 | ram  | 7 |  4 | 0 | 294 | 228 |    1980 |       12 | 11/24/1980 | .318      | -4.3         | ram, 27-7   |
| 201112050jax | jax  | 3 |  8 | 0 | 138 | 200 | sdg  | 4 |  7 | 0 | 249 | 275 |    2011 |       13 | 12/5/2011  | .318      | -4.0         | sdg, 38-14  |
| 198312120tam | tam  | 2 | 12 | 0 | 212 | 345 | gnb  | 7 |  7 | 0 | 396 | 407 |    1983 |       15 | 12/12/1983 | .321      | -5.1         | gnb, 12-9   |
| 198711020dal | dal  | 3 |  3 | 0 | 135 | 134 | nyg  | 1 |  5 | 0 |  99 | 142 |    1987 |        7 | 11/2/1987  | .333      | -3.5         | dal, 33-24  |
| 199910250pit | pit  | 3 |  3 | 0 | 117 |  93 | atl  | 1 |  5 | 0 |  74 | 153 |    1999 |        7 | 10/25/1999 | .333      | -4.6         | pit, 13-9   |
| 200211180ram | ram  | 4 |  5 | 0 | 194 | 196 | chi  | 2 |  7 | 0 | 182 | 232 |    2002 |       11 | 11/18/2002 | .333      | -2.9         | ram, 21-16  |
| 200511210gnb | gnb  | 2 |  7 | 0 | 201 | 184 | min  | 4 |  5 | 0 | 154 | 228 |    2005 |       11 | 11/21/2005 | .333      | -3.2         | min, 20-17  |
| 200012040nwe | nwe  | 3 |  9 | 0 | 192 | 253 | kan  | 5 |  7 | 0 | 283 | 274 |    2000 |       14 | 12/4/2000  | .333      | -2.2         | nwe, 30-24  |
| 200412130oti | oti  | 4 |  8 | 0 | 231 | 294 | kan  | 4 |  8 | 0 | 341 | 326 |    2004 |       14 | 12/13/2004 | .333      | -2.0         | kan, 49-38  |
| 200712100atl | atl  | 3 |  9 | 0 | 171 | 272 | nor  | 5 |  7 | 0 | 266 | 279 |    2007 |       14 | 12/10/2007 | .333      | -4.8         | nor, 34-14  |
| 199112090mia | mia  | 7 |  6 | 0 | 256 | 275 | cin  | 2 | 11 | 0 | 211 | 374 |    1991 |       15 | 12/9/1991  | .346      | -7.0         | mia, 37-13  |
| 197311260sfo | sfo  | 3 |  7 | 0 | 180 | 232 | gnb  | 3 |  5 | 2 | 138 | 198 |    1973 |       11 | 11/26/1973 | .350      | -5.6         | sfo, 20-6   |
| 197811130cin | cin  | 1 |  9 | 0 | 110 | 184 | rai  | 6 |  4 | 0 | 193 | 164 |    1978 |       11 | 11/13/1978 | .350      | -2.3         | rai, 34-21  |
| 200711260pit | pit  | 7 |  3 | 0 | 269 | 145 | mia  | 0 | 10 | 0 | 183 | 274 |    2007 |       12 | 11/26/2007 | .350      | +1.7         | pit, 3-0    |
| 199311290clt | clt  | 3 |  7 | 0 | 154 | 233 | sdg  | 4 |  6 | 0 | 164 | 195 |    1993 |       13 | 11/29/1993 | .350      | -5.5         | sdg, 31-0   |
| 198010270nyj | nyj  | 1 |  6 | 0 | 114 | 164 | mia  | 4 |  3 | 0 |  99 | 144 |    1980 |        8 | 10/27/1980 | .357      | -6.8         | nyj, 17-14  |
+--------------+------+---+----+---+-----+-----+------+---+----+---+-----+-----+---------+----------+------------+-----------+--------------+-------------+

It is not, however, the worst by combined PPG margin. That honor belongs to this 1972 game between the 2-5 Patriots and the 1-6 Colts (Baltimore ended up winning 24-17).

4 Comments | Posted in Announcement, History, Pro-Football-Reference.com, Trivia

Stat Questions: Team Passing Yards vs Individual Passing Yards

Posted by Neil on October 16, 2013

This is a question we get ALL the time... In fact, it's come up twice in my inbox over the last 2 days:

"How is a total of -11 (-1 Dallas and -10 Green Bay) passing yards figured in the Oct 24, 1965 game when Individual stats show Craig Morton for 61 yards and Bart Starr for 42 yards?"

"This query should return this game [...] Elvis Grbac threw for 504 yards, and the Raiders scored 49 points. That game was not returned by the query[.]"

In both cases, it's a question of individual passing totals seemingly not matching up to team totals. And that's because the NFL doesn't define "passing yards" in the same way for teams as it does for individuals.

Confusingly, sack yards do not count against the "passing yards" you see listed next to individual players, but they do count against "passing yards" at the team level. To put it another way, individual passing yards are always presented as GROSS yards (with sack yards not subtracted out), while team passing yards are always presented as NET yards (meaning sack yards are subtracted out).

So despite Morton & Starr's combined GROSS pass yards, there were also 114 combined sack yards in that game, leading to a record -11 total combined NET passing yards in the game. And despite Grbac's 504 GROSS pass yards, he was sacked 4 times for 30 yards, meaning KC only had 474 NET passing yards in the game.

This probably doesn't make a great deal of sense in 2013, but it does come in handy for years before QB sack data was tracked (a.k.a. the history of football up until 1969). Because of this practice, we know how many gross yards a quarterback -- and, therefore, a team -- had, as well as how many net yards they had, since sack totals were recorded for teams (but not players) before 1969. It would make for even more confusion if, starting in 1969, we all of a sudden began defining yardage for individuals differently than it had been defined in the past (though as we saw yesterday, this didn't stop the NBA from abruptly changing how team rebound totals were defined).

So it's a minor inconvenience now, but probably a necessary one from an historical perspective. And hopefully this post will reduce some of the confusion going forward (though I doubt it).

Comments Off | Posted in Announcement, Pro-Football-Reference.com, Stat Questions, Trivia

Stat Questions: Why Do Pre-1970s Team Rebound Totals Not Match the Sums of Individual Players?

Posted by Neil on October 15, 2013

Recently, a BBR user posed a question we get on occasion:

"[I] noticed that the team rebound totals for every team appear to be incorrect from 1956-57 to 1967-68. They are correct in 1968-69. For example in 1956-57 it shows the Celtics led the league in rebounds with 4963. When you add up the rebounds for every player on their roster the total comes to 4578. The points and assists totals match exactly. [...] It is only the rebound total that is off, and it is off for every team by a significant margin."

He's right -- you can see this by adding up the team rebound totals for each league-season and comparing it to the sum of individual player rebounds... It changes around 1968:

+---------+-------+----------+------------+
| year_id | lg_id | team_trb | player_trb |
+---------+-------+----------+------------+
|    2013 | NBA   |   103575 |     103575 |
|    2012 | NBA   |    83513 |      83513 |
|    2011 | NBA   |   101816 |     101816 |
|    2010 | NBA   |   102640 |     102640 |
|    2009 | NBA   |   101586 |     101586 |
|    2008 | NBA   |   103271 |     103271 |
|    2007 | NBA   |   100994 |     100994 |
|    2006 | NBA   |   100754 |     100754 |
|    2005 | NBA   |   102970 |     102970 |
|    2004 | NBA   |   100361 |     100361 |
|    2003 | NBA   |   100604 |     100604 |
|    2002 | NBA   |   100829 |     100829 |
|    2001 | NBA   |   100988 |     100988 |
|    2000 | NBA   |   102062 |     102062 |
|    1999 | NBA   |    60395 |      60395 |
|    1998 | NBA   |    98798 |      98798 |
|    1997 | NBA   |    97703 |      97703 |
|    1996 | NBA   |    98099 |      98099 |
|    1995 | NBA   |    92006 |      92006 |
|    1994 | NBA   |    95192 |      95192 |
|    1993 | NBA   |    95504 |      95504 |
|    1992 | NBA   |    96680 |      96680 |
|    1991 | NBA   |    95776 |      95776 |
|    1990 | NBA   |    95518 |      95518 |
|    1989 | NBA   |    90031 |      90031 |
|    1988 | NBA   |    81828 |      81828 |
|    1987 | NBA   |    83020 |      83020 |
|    1986 | NBA   |    82161 |      82161 |
|    1985 | NBA   |    82008 |      82008 |
|    1984 | NBA   |    81150 |      81150 |
|    1983 | NBA   |    83853 |      83853 |
|    1982 | NBA   |    81987 |      81987 |
|    1981 | NBA   |    82010 |      82010 |
|    1980 | NBA   |    81065 |      81065 |
|    1979 | NBA   |    81564 |      81564 |
|    1978 | NBA   |    84984 |      84984 |
|    1977 | NBA   |    84886 |      84886 |
|    1976 | NBA   |    69960 |      69960 |
|    1976 | ABA   |    30815 |      30815 |
|    1975 | NBA   |    69468 |      69468 |
|    1975 | ABA   |    40239 |      40239 |
|    1974 | NBA   |    67230 |      67230 |
|    1974 | ABA   |    40705 |      40705 |
|    1973 | NBA   |    70555 |      70555 |
|    1973 | ABA   |    41062 |      41062 |
|    1972 | NBA   |    71299 |      71299 |
|    1972 | ABA   |    48429 |      48429 |
|    1971 | NBA   |    74059 |      74059 |
|    1971 | ABA   |    50234 |      50234 |
|    1970 | NBA   |    60697 |      60697 |
|    1970 | ABA   |    49991 |      49991 |
|    1969 | NBA   |    65324 |      65324 |
|    1969 | ABA   |    46674 |      46674 |
|    1968 | NBA   |    65166 |      56999 |
|    1968 | ABA   |    46957 |      46957 |
|    1967 | NBA   |    54536 |      48095 |
|    1966 | NBA   |    49118 |      43250 |
|    1965 | NBA   |    48433 |      42563 |
|    1964 | NBA   |    47423 |      41894 |
|    1963 | NBA   |    48044 |      41418 |
|    1962 | NBA   |    51415 |      43183 |
|    1961 | NBA   |    46314 |      40732 |
|    1960 | NBA   |    44104 |      37401 |
|    1959 | NBA   |    40343 |      34794 |
|    1958 | NBA   |    41279 |      35814 |
|    1957 | NBA   |    35948 |      32136 |
|    1956 | NBA   |    34616 |      31395 |
|    1955 | NBA   |    32292 |      28777 |
|    1954 | NBA   |    32987 |      29808 |
|    1953 | NBA   |    36168 |      32314 |
|    1952 | NBA   |    35977 |      31209 |
|    1951 | NBA   |    35019 |      30621 |
+---------+-------+----------+------------+

So what's the deal? Is this a bug in our database?

Actually, no. It's just a matter of accounting by the official scorer, because technically speaking, for every missed shot there has to be a rebound.

Starting in 1968-69 (1967-68 in the ABA), so-called "team" rebounds (rebounds where there was no clear individual who should receive credit) were no longer counted toward a team's overall rebounding total. Before that, "team rebounds" were credited at the team level, but they (obviously) didn't make it into individual rebounding totals. This is what caused the massive discrepancies between teams' rebounds and the sum of their individual players' rebounds.

Nowadays, those "team rebounds" are thrown into their own bucket, neither allocated to individuals nor to teams for the purpose of overall stat totals.

Mystery solved!

1 Comment | Posted in Announcement, Basketball-Reference.com, Stat Questions, Trivia

Grand Slams with 4 Pitchers Receiving Earned Runs

Posted by admin on October 14, 2013

Last night's Ortiz Grand Slam was the first in the postseason and 8th time in the RetroSheet canon (but probably overall) that four pitchers received earned runs on one play.

| game_id      | result_batter | batting_team_id | pitching_team_id | event_text           | home      | first     | second    | third     |
+--------------+---------------+-----------------+------------------+----------------------+-----------+-----------+-----------+-----------+
| BOS201310130 | ortizda01     | BOS             | DET              | HR/9/L9D.3-H;2-H;1-H | benoijo01 | albural01 | smylydr01 | verasjo01 |
+--------------+---------------+-----------------+------------------+----------------------+-----------+-----------+-----------+-----------+
+--------------+---------------+-----------------+------------------+-------------------------+-----------+-----------+-----------+-----------+
| game_id      | result_batter | batting_team_id | pitching_team_id | event_text              | home      | first     | second    | third     |
+--------------+---------------+-----------------+------------------+-------------------------+-----------+-----------+-----------+-----------+
| MIN196107041 | becquju01     | MIN             | CHW              | HR/9D.3-H;2-H;1-H       | hackewa02 | baumafr01 | kemmeru01 | piercbi02 |
| SEA198208060 | jacksre01     | CAL             | SEA              | HR/9.3-H;2-H;1-H        | vandeed01 | stantmi01 | anderla02 | bannifl01 |
| DET198307100 | parrila02     | DET             | OAK              | HR/7.3-H(UR);2-H;1-H    | jonesje01 | beardda01 | burgmto01 | codirch01 |
| SFN198709200 | esaskni01     | CIN             | SFG              | HR/7D.3-H;2-H;1-H       | perlmjo01 | leffecr01 | downske01 | robindo01 |
| SEA198805060 | sheripa01     | DET             | SEA              | HR/9.3-H;2-H;1-H        | jacksmi02 | solanju01 | powelde01 | mooremi01 |
| SDN200109010 | lankfra01     | SDP             | ARI              | HR/89.3-H;2-H;1-H       | kimby01   | sabeler01 | knotter01 | batismi01 |
| LAN200410020 | finlest01     | LAD             | SFG              | HR/89/F.3-H;2-H(UR);1-H | frankwa01 | hergema01 | chrisja01 | hermadu01 |

6 Comments | Posted in Advanced Stats, Announcement, Baseball-Reference.com, History, Stat Questions, Statgeekery, Trivia

P-F-R Position Abbreviation Glossary

Posted by Neil on October 1, 2013

We often get emails about some of the more... let's say "esoteric" positional abbreviations in the P-F-R database (the most confusing of which date back to the earliest days of professional football). Here's a handy guide in case you ever get stuck wondering what in the world some of these positions are:

Comments Off | Posted in Announcement, FAQ, Pro-Football-Reference.com, Stat Questions, Trivia

World Series Winners Who Finished Last the Following Season

Posted by Neil on August 13, 2013

With San Francisco currently in the basement of the NL West, a Giants fan wrote to us this week wondering how many times a World Series win was followed with a last-place finish. I ran the query in our database:

WS Winner Following Season Last Place?
2012 San Francisco Giants 5th place out of 5 teams *
2011 St. Louis Cardinals 2nd place out of 6 teams
2010 San Francisco Giants 2nd place out of 5 teams
2009 New York Yankees 2nd place out of 5 teams
2008 Philadelphia Phillies 1st place out of 5 teams
2007 Boston Red Sox 2nd place out of 5 teams
2006 St. Louis Cardinals 3rd place out of 6 teams
2005 Chicago White Sox 3rd place out of 5 teams
2004 Boston Red Sox 2nd place out of 5 teams
2003 Florida Marlins 3rd place out of 5 teams
2002 Anaheim Angels 3rd place out of 4 teams
2001 Arizona Diamondbacks 1st place out of 5 teams
2000 New York Yankees 1st place out of 5 teams
1999 New York Yankees 1st place out of 5 teams
1998 New York Yankees 1st place out of 5 teams
1997 Florida Marlins 5th place out of 5 teams *
1996 New York Yankees 2nd place out of 5 teams
1995 Atlanta Braves 1st place out of 5 teams
1993 Toronto Blue Jays 3rd place out of 5 teams
1992 Toronto Blue Jays 1st place out of 7 teams
WS Winner Following Season Last Place?
1991 Minnesota Twins 2nd place out of 7 teams
1990 Cincinnati Reds 5th place out of 6 teams
1989 Oakland Athletics 1st place out of 7 teams
1988 Los Angeles Dodgers 4th place out of 6 teams
1987 Minnesota Twins 2nd place out of 7 teams
1986 New York Mets 2nd place out of 6 teams
1985 Kansas City Royals 3rd place out of 7 teams
1984 Detroit Tigers 3rd place out of 7 teams
1983 Baltimore Orioles 5th place out of 7 teams
1982 St. Louis Cardinals 4th place out of 6 teams
1981 Los Angeles Dodgers 2nd place out of 6 teams
1980 Philadelphia Phillies 3rd place out of 6 teams
1979 Pittsburgh Pirates 3rd place out of 6 teams
1978 New York Yankees 4th place out of 7 teams
1977 New York Yankees 1st place out of 7 teams
1976 Cincinnati Reds 2nd place out of 6 teams
1975 Cincinnati Reds 1st place out of 6 teams
1974 Oakland Athletics 1st place out of 6 teams
1973 Oakland Athletics 1st place out of 6 teams
1972 Oakland Athletics 1st place out of 6 teams
WS Winner Following Season Last Place?
1971 Pittsburgh Pirates 1st place out of 6 teams
1970 Baltimore Orioles 1st place out of 6 teams
1969 New York Mets 3rd place out of 6 teams
1968 Detroit Tigers 2nd place out of 6 teams
1967 St. Louis Cardinals 1st place out of 10 teams
1966 Baltimore Orioles 6th place out of 10 teams
1965 Los Angeles Dodgers 1st place out of 10 teams
1964 St. Louis Cardinals 7th place out of 10 teams
1963 Los Angeles Dodgers 6th place out of 10 teams
1962 New York Yankees 1st place out of 10 teams
1961 New York Yankees 1st place out of 10 teams
1960 Pittsburgh Pirates 6th place out of 8 teams
1959 Los Angeles Dodgers 4th place out of 8 teams
1958 New York Yankees 3rd place out of 8 teams
1957 Milwaukee Braves 1st place out of 8 teams
1956 New York Yankees 1st place out of 8 teams
1955 Brooklyn Dodgers 1st place out of 8 teams
1954 New York Giants 3rd place out of 8 teams
1953 New York Yankees 2nd place out of 8 teams
1952 New York Yankees 1st place out of 8 teams
WS Winner Following Season Last Place?
1951 New York Yankees 1st place out of 8 teams
1950 New York Yankees 1st place out of 8 teams
1949 New York Yankees 1st place out of 8 teams
1948 Cleveland Indians 3rd place out of 8 teams
1947 New York Yankees 3rd place out of 8 teams
1946 St. Louis Cardinals 2nd place out of 8 teams
1945 Detroit Tigers 2nd place out of 8 teams
1944 St. Louis Cardinals 2nd place out of 8 teams
1943 New York Yankees 3rd place out of 8 teams
1942 St. Louis Cardinals 1st place out of 8 teams
1941 New York Yankees 1st place out of 8 teams
1940 Cincinnati Reds 3rd place out of 8 teams
1939 New York Yankees 3rd place out of 8 teams
1938 New York Yankees 1st place out of 8 teams
1937 New York Yankees 1st place out of 8 teams
1936 New York Yankees 1st place out of 8 teams
1935 Detroit Tigers 2nd place out of 8 teams
1934 St. Louis Cardinals 2nd place out of 8 teams
1933 New York Giants 2nd place out of 8 teams
1932 New York Yankees 2nd place out of 8 teams
WS Winner Following Season Last Place?
1931 St. Louis Cardinals 6th place out of 8 teams
1930 Philadelphia Athletics 1st place out of 8 teams
1929 Philadelphia Athletics 1st place out of 8 teams
1928 New York Yankees 2nd place out of 8 teams
1927 New York Yankees 1st place out of 8 teams
1926 St. Louis Cardinals 2nd place out of 8 teams
1925 Pittsburgh Pirates 3rd place out of 8 teams
1924 Washington Senators 1st place out of 8 teams
1923 New York Yankees 2nd place out of 8 teams
1922 New York Giants 1st place out of 8 teams
1921 New York Giants 1st place out of 8 teams
1920 Cleveland Indians 2nd place out of 8 teams
1919 Cincinnati Reds 3rd place out of 8 teams
1918 Boston Red Sox 6th place out of 8 teams
1917 Chicago White Sox 6th place out of 8 teams
1916 Boston Red Sox 2nd place out of 8 teams
1915 Boston Red Sox 1st place out of 8 teams
1914 Boston Braves 2nd place out of 8 teams
1913 Philadelphia Athletics 1st place out of 8 teams
1912 Boston Red Sox 4th place out of 8 teams
WS Winner Following Season Last Place?
1911 Philadelphia Athletics 3rd place out of 8 teams
1910 Philadelphia Athletics 1st place out of 8 teams
1909 Pittsburgh Pirates 3rd place out of 8 teams
1908 Chicago Cubs 2nd place out of 8 teams
1907 Chicago Cubs 1st place out of 8 teams
1906 Chicago White Sox 3rd place out of 8 teams
1905 New York Giants 2nd place out of 8 teams
1903 Boston Americans 1st place out of 8 teams

As it turns out, if the Giants "hang on" to the bottom spot in the West, it will mark only the second time in the World Series era (1903-present) that a champion went on to finish last the following season. The only other team to do that were the 1998 Florida Marlins, who infamously jettisoned all of their talent a year after winning it all.

8 Comments | Posted in Announcement, Baseball-Reference.com, History, Trivia

Errata: Minor Stats Corrections Coming to the Site

Posted by admin on July 15, 2013

By the nature of our update process these will take a week or two to roll out to the site, but they'll get there eventually. This note below is from one of our data producers and represent a set of updates we'll be incorporating into the site.

One of the great aspects of the baseball research community is their dogged determination to get things right even it is a mixup between Tom Maher and Frank Mahar in 1902.

1 Comment | Posted in Advanced Stats, Announcement, Baseball-Reference.com, expire40d, Statgeekery, Trivia

Page 1 of 212
Part of the Network