{"field":"mfl_id","data_type":"character","description":"MyFantasyLeague.com ID - this is the primary key for this table and is unique and complete. Usually an integer of 5 digits."} {"field":"sportradar_id","data_type":"character","description":"SportRadar ID - often also called sportsdata_id by other services. A UUID."} {"field":"fantasypros_id","data_type":"character","description":"FantasyPros.com ID - usually an integer of 5 digits."} {"field":"gsis_id","data_type":"character","description":"NFL Game Stats and Information Services - usually starts with 00- and is followed by a series of integers."} {"field":"pff_id","data_type":"character","description":"Pro Football Focus ID - usually an integer with between 3 and 6 digits."} {"field":"sleeper_id","data_type":"character","description":"Sleeper ID - usually an integer with ~4 digits."} {"field":"nfl_id","data_type":"character","description":"NFL.com ID - usual format fullname/integers"} {"field":"espn_id","data_type":"character","description":"ESPN ID - usual format is an integer with ~5 digits"} {"field":"yahoo_id","data_type":"character","description":"Yahoo ID - usual format is an integer with ~5 digits"} {"field":"fleaflicker_id","data_type":"character","description":"Fleaflicker ID - usual format is an integer with ~4 digits. Fleaflicker API also has sportradar and that's generally preferred."} {"field":"cbs_id","data_type":"character","description":"CBS ID - usual format is an integer with ~ 7 digits."} {"field":"rotowire_id","data_type":"character","description":"Rotowire ID - usual format is an integer with ~four digits. Not to be confused with rotowire_id."} {"field":"rotoworld_id","data_type":"character","description":"Rotoworld ID - usual format is an integer with ~four digits. Not to be confused with rotowire_id."} {"field":"ktc_id","data_type":"character","description":"KeepTradeCut ID - usual format is an integer with ~four digits."} {"field":"pfr_id","data_type":"character","description":"Pro Football Reference ID - usual format is first four characters of last name, first two characters of first name, and an integer"} {"field":"cfbref_id","data_type":"character","description":"College Football Reference ID - usual format is firstname-lastname-integer"} {"field":"stats_id","data_type":"character","description":"Stats ID - usual format is five digit integer"} {"field":"stats_global_id","data_type":"character","description":"Stats Global ID - usual format is a six digit integer"} {"field":"fantasy_data_id","data_type":"character","description":"FantasyData ID - usual format five digit integer"} {"field":"name","data_type":"character","description":"Name, as reported by MFL but reordered into FirstName LastName instead of Last, First"} {"field":"merge_name","data_type":"character","description":"Name but formatted for name joins via ffscrapr::dp_cleannames() - coerced to lowercase, stripped of punctuation and suffixes, and common substitutions performed."} {"field":"position","data_type":"character","description":"Position as reported by MFL"} {"field":"team","data_type":"character","description":"Team as reported by MFL"} {"field":"birthdate","data_type":"date","description":"Birthdate"} {"field":"age","data_type":"numeric","description":"Age as of last pipeline build, rounded to one decimal. Pipeline is built on a weekly basis."} {"field":"draft_year","data_type":"numeric","description":"Year of draft. Zero if unknown/undrafted."} {"field":"draft_round","data_type":"numeric","description":"Round of draft."} {"field":"draft_pick","data_type":"numeric","description":"Draft pick within round, i.e. 32nd pick of second round."} {"field":"draft_ovr","data_type":"character","description":"Overall draft pick selection. This can be a little bit patchy, since MFL does not report this number."} {"field":"twitter_username","data_type":"character","description":"Official twitter handle, if known"} {"field":"height","data_type":"numeric","description":"height in inches"} {"field":"weight","data_type":"numeric","description":"weight in pounds"} {"field":"college","data_type":"character","description":"College attended"} {"field":"db_season","data_type":"numeric","description":"Year of database build. Previous years may also be available via dynastyprocess."} {"field":"swish_id","data_type":"character","description":"Player ID for Swish Analytics"}