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.
| field | data_type | description |
|---|---|---|
| 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 |
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.