2012-2022 NFL Defense And Offensive Statistics
The complete offensive and defensive data set for the NFL years 2012-2022
@kaggle.kristofanderson_2012_2022_nfl_defense_and_offensive_statistics
The complete offensive and defensive data set for the NFL years 2012-2022
@kaggle.kristofanderson_2012_2022_nfl_defense_and_offensive_statistics
The dataset contains offensive and defensive statistics for NFL games that were played over the last 10 years and were decided by teams. The statistics cover regular season and playoff games. Offensive statistics include total yards gained, yards per play, rushing yards, passing yards, and points scored. Defensive statistics include total yards allowed, yards per play allowed, rushing yards allowed, passing yards allowed, and points allowed. Additionally, the dataset may include other metrics such as turnovers, time of possession, and red zone efficiency. The data may be organized by game, team, or player and may include metadata such as date, location, and weather conditions. The dataset can be used to analyze team performance over time, compare offensive and defensive strategies, identify trends and patterns, and make predictions for future games.
Please share some of your work. I would love to see how the dataset is used
CREATE TABLE n_2012_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2012_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2013_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2013_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2014_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2014_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2015_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2015_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2016_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2016_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2017_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2017_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2018_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2018_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2019_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2019_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2020_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2020_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2021_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2021_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2022_def (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);CREATE TABLE n_2022_off (
"team" VARCHAR,
"gms" BIGINT,
"tot_pts" BIGINT,
"pts_g" DOUBLE,
"rushyds" BIGINT,
"ryds_g" DOUBLE,
"passyds" BIGINT,
"pyds_g" DOUBLE,
"totyds" BIGINT,
"yds_g" DOUBLE
);Anyone who has the link will be able to view this.