The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

Data Dictionary - Players

field data_type description
gsis_id character GSIS ID for player. Primary key for all data.
display_name character Full name of player
common_first_name character Common first name of player
first_name character First name of player
last_name character Last name of player
short_name character Player short name (i.e. F.Last)
football_name character Common player name (i.e. in most cases common_first_name last_name)
suffix character Name suffix of player
esb_id character ESB ID of player
nfl_id character NFL ID of player (this is used in Big Data Bowl Data)
pfr_id character Pro-Football-Reference ID for player
pff_id character PFF ID for player
otc_id character Over the Cap ID for player
espn_id character ESPN ID for player
smart_id character SMART ID for player (that’s in raw pbp. It includes a hashed ESB_ID)
birth_date character Player birth date (sourced from NFL. Other sources may differ)
position_group character Postion group of player as listed by NFL
position character Position of player as listed by NFL
ngs_position_group character Position group of player as listed by Next Gen Stats
ngs_position character Position of player as listed by Next Gen Stats
headshot character NFL headshot url for player
college_name character Official college (usually the last one attended)
college_conference character Conference of college
jersey_number character Latest jersey number of player
latest_team character Latest team the player was listed in
status character Roster status: describes things like Active, Inactive, Injured Reserve, Practice Squad etc
ngs_status character Next Gen Stats variant of status
ngs_status_short_description character Next Gen Stats status description
pff_position character Position of player as listed by PFF
pff_status character Roster status as listed by PFF
draft_team character Team that drafted player
height numeric Height of player (inches)
weight numeric Weight of player (lbs)
rookie_season numeric 4 digit number indicating which season the player was a rookie
last_season numeric 4 digit number indicating which season the player was active the last time
years_of_experience numeric Years played in league
draft_year numeric Year that player was drafted
draft_round numeric Round that player was drafted in
draft_pick numeric Pick number of player

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.