NFL Game Data: Scores & Plays (2017-2024)
Scores and plays of every game from every season on NFL.com
@kaggle.keonim_nfl_game_scores_dataset_2017_2023
Scores and plays of every game from every season on NFL.com
@kaggle.keonim_nfl_game_scores_dataset_2017_2023
CREATE TABLE n_2017_2024_scores (
"season" BIGINT,
"week" VARCHAR,
"gamestatus" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"awayrecord" VARCHAR,
"awayscore" DOUBLE,
"awaywin" DOUBLE,
"hometeam" VARCHAR,
"homerecord" VARCHAR,
"homescore" DOUBLE,
"homewin" DOUBLE,
"awayseeding" DOUBLE,
"homeseeding" DOUBLE,
"postseason" BIGINT
);
CREATE TABLE n_2017_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2018_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2019_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2020_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2021_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2022_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2023_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
CREATE TABLE n_2024_plays (
"season" BIGINT,
"week" VARCHAR,
"day" VARCHAR,
"date" VARCHAR,
"awayteam" VARCHAR,
"hometeam" VARCHAR,
"quarter" VARCHAR,
"drivenumber" BIGINT,
"teamwithpossession" VARCHAR,
"isscoringdrive" BIGINT,
"playnumberindrive" BIGINT,
"isscoringplay" BIGINT,
"playoutcome" VARCHAR,
"playdescription" VARCHAR,
"playstart" VARCHAR
);
Anyone who has the link will be able to view this.