Data Dictionary - FF Player IDs (original) (raw)

mfl_id

character

MyFantasyLeague.com ID - this is the primary key for this table and is unique and complete. Usually an integer of 5 digits.

sportradar_id

character

SportRadar ID - often also called sportsdata_id by other services. A UUID.

fantasypros_id

character

FantasyPros.com ID - usually an integer of 5 digits.

gsis_id

character

NFL Game Stats and Information Services - usually starts with 00- and is followed by a series of integers.

pff_id

character

Pro Football Focus ID - usually an integer with between 3 and 6 digits.

sleeper_id

character

Sleeper ID - usually an integer with ~4 digits.

nfl_id

character

NFL.com ID - usual format fullname/integers

espn_id

character

ESPN ID - usual format is an integer with ~5 digits

yahoo_id

character

Yahoo ID - usual format is an integer with ~5 digits

fleaflicker_id

character

Fleaflicker ID - usual format is an integer with ~4 digits. Fleaflicker API also has sportradar and that’s generally preferred.

cbs_id

character

CBS ID - usual format is an integer with ~ 7 digits.

rotowire_id

character

Rotowire ID - usual format is an integer with ~four digits. Not to be confused with rotowire_id.

rotoworld_id

character

Rotoworld ID - usual format is an integer with ~four digits. Not to be confused with rotowire_id.

ktc_id

character

KeepTradeCut ID - usual format is an integer with ~four digits.

pfr_id

character

Pro Football Reference ID - usual format is first four characters of last name, first two characters of first name, and an integer

cfbref_id

character

College Football Reference ID - usual format is firstname-lastname-integer

stats_id

character

Stats ID - usual format is five digit integer

stats_global_id

character

Stats Global ID - usual format is a six digit integer

fantasy_data_id

character

FantasyData ID - usual format five digit integer

name

character

Name, as reported by MFL but reordered into FirstName LastName instead of Last, First

merge_name

character

Name but formatted for name joins via ffscrapr::dp_cleannames() - coerced to lowercase, stripped of punctuation and suffixes, and common substitutions performed.

position

character

Position as reported by MFL

team

character

Team as reported by MFL

birthdate

date

Birthdate

age

numeric

Age as of last pipeline build, rounded to one decimal. Pipeline is built on a weekly basis.

draft_year

numeric

Year of draft. Zero if unknown/undrafted.

draft_round

numeric

Round of draft.

draft_pick

numeric

Draft pick within round, i.e. 32nd pick of second round.

draft_ovr

character

Overall draft pick selection. This can be a little bit patchy, since MFL does not report this number.

twitter_username

character

Official twitter handle, if known

height

numeric

height in inches

weight

numeric

weight in pounds

college

character

College attended

db_season

numeric

Year of database build. Previous years may also be available via dynastyprocess.

swish_id

character

Player ID for Swish Analytics