Baselight

2024 NFL Play-by-play (weeks 1 - 13)

2024 play by play data with drive ID, and play sequence ID for data analysis

@kaggle.andrewdefraties_2024_nfl_play_by_play_weeks_1_13

Loading...
Loading...

About this Dataset

2024 NFL Play-by-play (weeks 1 - 13)

Base dataset provided by NFLsavant.com.

Additions to the base dataset include the following:

  1. DriveID: a unique Identifier for each drive
  2. PlayID: a unique identifier for each play
  3. IsNewDrive: a new drive identifier
  4. OffenseConference & OffenseDivision
  5. DefenseConference & DefenseDivision
  6. PassType_x & PassType_y: can be used to determine the directional position of plays based on coordinate system (x,y)
  7. PlayDirection & RushDirec_y: can be used to determine the directional position of plays based on coordinate system (x,y)

Tables

N 2024 Pbp Nfl Pbp 2024–5

@kaggle.andrewdefraties_2024_nfl_play_by_play_weeks_1_13.n_2024_pbp_nfl_pbp_2024_5
  • 1.65 MB
  • 36,639 rows
  • 52 columns
Loading...
CREATE TABLE n_2024_pbp_nfl_pbp_2024_5 (
  "gameid" BIGINT,
  "driveid" DOUBLE,
  "playid" BIGINT,
  "isnewdrive" DOUBLE,
  "gamedate" TIMESTAMP,
  "quarter" BIGINT,
  "minute" BIGINT,
  "second" BIGINT,
  "offenseconference" VARCHAR,
  "offensedivision" VARCHAR,
  "offenseteam" VARCHAR,
  "defenseconference" VARCHAR,
  "defensedivision" VARCHAR,
  "defenseteam" VARCHAR,
  "down" BIGINT,
  "togo" BIGINT,
  "yardline" BIGINT,
  "seriesfirstdown" BIGINT,
  "nextscore" BIGINT,
  "teamwin" BIGINT,
  "seasonyear" BIGINT,
  "yards" BIGINT,
  "formation" VARCHAR,
  "playtype" VARCHAR,
  "isrush" BIGINT,
  "ispass" BIGINT,
  "isincomplete" BIGINT,
  "isinterception" BIGINT,
  "istouchdown" BIGINT,
  "passtype" VARCHAR,
  "passtype_x" DOUBLE,
  "passtype_y" DOUBLE,
  "issack" BIGINT,
  "ischallenge" BIGINT,
  "ischallengereversed" BIGINT,
  "challenger" VARCHAR,
  "ismeasurement" BIGINT,
  "isfumble" BIGINT,
  "ispenalty" BIGINT,
  "istwopointconversion" BIGINT,
  "istwopointconversionsuccessful" BIGINT,
  "rushdirection" VARCHAR,
  "playdirection" BIGINT,
  "rushdirec_y" DOUBLE,
  "yardlinefixed" BIGINT,
  "yardlinedirection" VARCHAR,
  "ispenaltyaccepted" BIGINT,
  "penaltyteam" VARCHAR,
  "isnoplay" BIGINT,
  "penaltytype" VARCHAR,
  "penaltyyards" BIGINT,
  "description" VARCHAR
);

Share link

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