Name: NFL Fantasy Football
Creator: nflverse
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

NFL Fantasy Football

This dataset provides standardized identifiers, expert consensus rankings, and dynasty trade values for NFL players and rookie draft picks.

It is designed to support fantasy football analysis by enabling consistent player mapping across platforms, tracking shifts in expert sentiment, and quantifying relative player and pick valuations.

Data is curated by the nflverse project and sourced from DynastyProcess, which aggregates FantasyPros rankings and models trade values using established methods.

Tables

FF Player IDs

@nflverse.nfl_fantasy.player_ids

1.61 MB
12,149 rows
35 columns

CREATE TABLE player_ids (
  "mfl_id" BIGINT,
  "sportradar_id" VARCHAR,
  "fantasypros_id" DOUBLE,
  "gsis_id" VARCHAR,
  "pff_id" DOUBLE,
  "sleeper_id" DOUBLE,
  "nfl_id" DOUBLE,
  "espn_id" DOUBLE,
  "yahoo_id" DOUBLE,
  "fleaflicker_id" DOUBLE,
  "cbs_id" DOUBLE,
  "pfr_id" VARCHAR,
  "cfbref_id" VARCHAR,
  "rotowire_id" DOUBLE,
  "rotoworld_id" DOUBLE,
  "ktc_id" DOUBLE,
  "stats_id" DOUBLE,
  "stats_global_id" DOUBLE,
  "fantasy_data_id" DOUBLE,
  "swish_id" DOUBLE,
  "name" VARCHAR,
  "merge_name" VARCHAR,
  "position" VARCHAR,
  "team" VARCHAR,
  "birthdate" TIMESTAMP,
  "age" DOUBLE,
  "draft_year" DOUBLE,
  "draft_round" DOUBLE,
  "draft_pick" DOUBLE,
  "draft_ovr" DOUBLE,
  "twitter_username" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "college" VARCHAR,
  "db_season" BIGINT
);

FF Rankings

@nflverse.nfl_fantasy.rankings

37.79 MB
1,591,470 rows
24 columns

CREATE TABLE rankings (
  "fp_page" VARCHAR,
  "page_type" VARCHAR,
  "player" VARCHAR,
  "id" BIGINT,
  "pos" VARCHAR,
  "team" VARCHAR,
  "ecr" DOUBLE,
  "sd" DOUBLE,
  "best" DOUBLE,
  "worst" DOUBLE,
  "mergename" VARCHAR,
  "tm" VARCHAR,
  "sportsdata_id" VARCHAR,
  "player_filename" VARCHAR,
  "yahoo_id" VARCHAR,
  "cbs_id" VARCHAR,
  "player_owned_avg" DOUBLE,
  "player_owned_espn" DOUBLE,
  "player_owned_yahoo" DOUBLE,
  "player_image_url" VARCHAR,
  "player_square_image_url" VARCHAR,
  "rank_delta" DOUBLE,
  "ecr_type" VARCHAR,
  "scrape_date" TIMESTAMP
);

FF Trade Values

@nflverse.nfl_fantasy.trade_values

27.75 kB
434 rows
12 columns

CREATE TABLE trade_values (
  "player" VARCHAR,
  "pos" VARCHAR,
  "team" VARCHAR,
  "age" DOUBLE,
  "draft_year" DOUBLE,
  "ecr_1qb" DOUBLE,
  "ecr_2qb" DOUBLE,
  "ecr_pos" DOUBLE,
  "value_1qb" BIGINT,
  "value_2qb" BIGINT,
  "scrape_date" TIMESTAMP,
  "fp_id" DOUBLE
);