2022 NFL Team Offense
2022 NFL Team Offense (Week 9 - Updated Weekly)
@kaggle.mattop_2022nfl_team_offense
2022 NFL Team Offense (Week 9 - Updated Weekly)
@kaggle.mattop_2022nfl_team_offense
The dataset contains weekly 2022 NFL team offense stats from the current NFL season (week 9).
The data was collected from Sports Reference then cleaned for data analysis.
Tabular data includes:
rankteamgamespoints_scoredtotal_yardsoffensive_playsyards_per_playturnovers_lostfumbles_lost1st_downspasses_completedpasses_attemptedpassing_yardspassing_touchdownspassing_interceptionsnet_yards_per_pass_attemptpassing_1st_downsrushing_attemptsrushing_yardsrushing_touchdownsrushing_yards_per_attemptrushing_1st_downspenalties: Hit batter with pitchpenalty_yards1st_down_penalitespercentage_scoring_drivespercentage_turnover_drivesexpected_pointsCREATE TABLE nfloffenseweek3 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek4 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek5 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek6 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek7 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek8 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);CREATE TABLE nfloffenseweek9 (
"rank" BIGINT,
"team" VARCHAR,
"games" BIGINT,
"points_scored" BIGINT,
"total_yards" BIGINT,
"offensive_plays" BIGINT,
"yards_per_play" DOUBLE,
"turnovers_lost" BIGINT,
"fumbles_lost" BIGINT,
"n_1st_downs" BIGINT -- 1st Downs,
"passes_completed" BIGINT,
"passes_attempted" BIGINT,
"passing_yards" BIGINT,
"passing_touchdowns" BIGINT,
"passing_interceptions" BIGINT,
"net_yards_per_pass_attempt" DOUBLE,
"passing_1st_downs" BIGINT,
"rushing_attempts" BIGINT,
"rushing_yards" BIGINT,
"rushing_touchdowns" BIGINT,
"rushing_yards_per_attempt" DOUBLE,
"rushing_1st_downs" BIGINT,
"penalties" BIGINT,
"penalty_yards" BIGINT,
"n_1st_down_penalties" BIGINT -- 1st Down Penalties,
"percentage_scoring_drives" DOUBLE,
"percentage_turnover_drives" DOUBLE,
"expected_points" DOUBLE
);Anyone who has the link will be able to view this.