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.

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:

Read the rest of this entry

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.)

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

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).

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).

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!

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 |

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

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:

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.