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.47 MB
12114 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" VARCHAR,
  "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

35.81 MB
1546773 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" DOUBLE,
  "cbs_id" DOUBLE,
  "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

34.83 KB
631 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
);