Baselight
Sign In

Nflfastr

NFL play-by-play data since 1999

@kaggle.benbaldwin_nflfastr

Loading...
Loading...

About this Dataset

Nflfastr

Context

This is NFL play-by-play data obtained from the nflfastR package.

Content

Documentation for the data here.

Tables

Play By Play 1999

@kaggle.benbaldwin_nflfastr.play_by_play_1999
  • 13.13 MB
  • 46137 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_1999 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2000

@kaggle.benbaldwin_nflfastr.play_by_play_2000
  • 13.19 MB
  • 45492 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2000 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2001

@kaggle.benbaldwin_nflfastr.play_by_play_2001
  • 13.23 MB
  • 45435 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2001 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2002

@kaggle.benbaldwin_nflfastr.play_by_play_2002
  • 13.85 MB
  • 47819 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2002 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2003

@kaggle.benbaldwin_nflfastr.play_by_play_2003
  • 13.74 MB
  • 47335 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2003 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2004

@kaggle.benbaldwin_nflfastr.play_by_play_2004
  • 13.72 MB
  • 47203 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2004 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2005

@kaggle.benbaldwin_nflfastr.play_by_play_2005
  • 13.69 MB
  • 47344 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2005 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" VARCHAR,
  "yards_after_catch" VARCHAR,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" VARCHAR,
  "yac_epa" VARCHAR,
  "comp_air_epa" VARCHAR,
  "comp_yac_epa" VARCHAR,
  "total_home_comp_air_epa" VARCHAR,
  "total_away_comp_air_epa" VARCHAR,
  "total_home_comp_yac_epa" VARCHAR,
  "total_away_comp_yac_epa" VARCHAR,
  "total_home_raw_air_epa" VARCHAR,
  "total_away_raw_air_epa" VARCHAR,
  "total_home_raw_yac_epa" VARCHAR,
  "total_away_raw_yac_epa" VARCHAR,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2006

@kaggle.benbaldwin_nflfastr.play_by_play_2006
  • 17.36 MB
  • 46868 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2006 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2007

@kaggle.benbaldwin_nflfastr.play_by_play_2007
  • 17.56 MB
  • 46789 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2007 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2008

@kaggle.benbaldwin_nflfastr.play_by_play_2008
  • 17.43 MB
  • 46445 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2008 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2009

@kaggle.benbaldwin_nflfastr.play_by_play_2009
  • 17.8 MB
  • 47083 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2009 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2010

@kaggle.benbaldwin_nflfastr.play_by_play_2010
  • 17.94 MB
  • 47467 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2010 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" BIGINT,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" BIGINT,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" BIGINT,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2011

@kaggle.benbaldwin_nflfastr.play_by_play_2011
  • 18.86 MB
  • 48200 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2011 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2012

@kaggle.benbaldwin_nflfastr.play_by_play_2012
  • 19.06 MB
  • 48578 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2012 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2013

@kaggle.benbaldwin_nflfastr.play_by_play_2013
  • 19.22 MB
  • 48878 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2013 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2014

@kaggle.benbaldwin_nflfastr.play_by_play_2014
  • 19.14 MB
  • 48418 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2014 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2015

@kaggle.benbaldwin_nflfastr.play_by_play_2015
  • 19.34 MB
  • 48869 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2015 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2016

@kaggle.benbaldwin_nflfastr.play_by_play_2016
  • 19.15 MB
  • 48419 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2016 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2017

@kaggle.benbaldwin_nflfastr.play_by_play_2017
  • 18.89 MB
  • 47997 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2017 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2018

@kaggle.benbaldwin_nflfastr.play_by_play_2018
  • 18.85 MB
  • 47874 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2018 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Play By Play 2019

@kaggle.benbaldwin_nflfastr.play_by_play_2019
  • 18.96 MB
  • 48034 rows
  • 340 columns
Loading... 

CREATE TABLE play_by_play_2019 (
  "play_id" BIGINT,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" BIGINT,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" BIGINT,
  "drive" DOUBLE,
  "sp" BIGINT,
  "qtr" BIGINT,
  "down" DOUBLE,
  "goal_to_go" BIGINT,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" BIGINT,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" BIGINT,
  "no_huddle" BIGINT,
  "qb_dropback" DOUBLE,
  "qb_kneel" BIGINT,
  "qb_spike" BIGINT,
  "qb_scramble" BIGINT,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" BIGINT,
  "away_timeouts_remaining" BIGINT,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" BIGINT,
  "total_away_score" BIGINT,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "home_wp_post" DOUBLE,
  "away_wp_post" DOUBLE,
  "vegas_wp" DOUBLE,
  "vegas_home_wp" DOUBLE,
  "total_home_rush_wpa" DOUBLE
);

Share link

Anyone who has the link will be able to view this.