The Pro Football Dataset

This is a description of the pro-football-reference.com dataset (up to 2006). For further details see README.

You can run SQL SKYLINE OF queries on this dataset here.

            Table "football.master"
   Column   |         Type          | Modifiers
------------+-----------------------+-----------
 id         | character varying(8)  |
 last name  | character varying(16) |
 first name | character varying(16) |
 position   | character varying(2)  |
 birth year | integer               |
 debut year | integer               |

            Table "football.seasons"
   Column   |         Type          | Modifiers
------------+-----------------------+-----------
 id         | character varying(8)  |
 last name  | character varying(16) |
 first name | character varying(16) |
 year       | integer               |
 team       | character varying(3)  |
 position   | character varying(2)  |
 g          | integer               |
 gs         | integer               |
 comp       | integer               |
 att        | integer               |
 passyd     | integer               |
 passtd     | integer               |
 INT        | integer               |
 rush       | integer               |
 rushyd     | integer               |
 rushtd     | integer               |
 rec        | integer               |
 recyd      | integer               |
 rectd      | integer               |

            Table "football.games"
  Column   |         Type         | Modifiers
-----------+----------------------+-----------
 id        | character varying(8) |
 year      | integer              |
 team      | character varying(3) |
 week      | integer              |
 opp       | character varying(3) |
 comp      | integer              |
 att       | integer              |
 passyd    | integer              |
 passtd    | integer              |
 INT       | integer              |
 rush      | integer              |
 rushyd    | integer              |
 rec       | integer              |
 recyd     | integer              |
 total TDs | integer              |

Hannes Eder
Last modified: 2007-02-08