Sports Reference Blog

Archive for the 'Trivia' Category

A Discussion of WAR Wherein I Ardently Attempt to Avoid any WAR-Related Puns

21st November 2017

This article assumes a lot of prior knowledge about the discussion of Wins Above Replacement, you can catch up here

First off, none of us are here without Bill James. We are all at our very best merely Chaucer or Joyce to his Shakespeare. All sabermetrics predating him flowed into his work and all sabermetrics after him carries echoes of his work.

To the discussion at hand.
Read the rest of this entry

Posted in Academics, Advanced Stats, Baseball-Reference.com, Stat Questions, Statgeekery, Trivia, WAR | 8 Comments »

Find Players Older Than You Are

17th February 2015

With the retirement of Jason Giambi I've seen some talk from people that there are now no longer any MLB players older than them. Since I'm never one to pass up on the opportunity to make a relatively useless tool, I've added a quick Pro Football Reference page to find active NFL players as old or older than you are. Basically, we just need to hope that Adam Vinatieri keeps kicking.

Posted in Announcement, Pro-Football-Reference.com, Trivia | 2 Comments »

Where Does Florida State Rank Entering the BCS Championship Game?

9th December 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)

Read the rest of this entry

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

Historical Western Conference vs Eastern Conference Disparity

5th December 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.)

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

NFL Team Records vs. Each Division Since 2002

24th October 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)  |
+---------+-----------+--------------+--------------+--------------+--------------+

Read the rest of this entry

Posted in Announcement, Data, Pro-Football-Reference.com, Stat Questions, Trivia | Comments Off on NFL Team Records vs. Each Division Since 2002

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

21st October 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).

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

Stat Questions: Team Passing Yards vs Individual Passing Yards

16th October 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).

Posted in Announcement, Pro-Football-Reference.com, Stat Questions, Trivia | Comments Off on Stat Questions: Team Passing Yards vs Individual Passing Yards

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

15th October 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!

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

Grand Slams with 4 Pitchers Receiving Earned Runs

14th October 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 |

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

P-F-R Position Abbreviation Glossary

1st October 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:

Read the rest of this entry

Posted in Announcement, FAQ, Pro-Football-Reference.com, Stat Questions, Trivia | Comments Off on P-F-R Position Abbreviation Glossary