Name: College Football Team Stats Seasons 2013 To 2023
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

College Football Team Stats Seasons 2013 To 2023

Context

College football is one of the most long-living fascinations in American culture. Its TV rankings routinely dominate the fall TV schedules. . The NCAA has a stats website but it does not have all the team information and uses many acronyms that are obscure.

With the data available, I went ahead and scraped the team statistics for each college football season from 2013 to the present.

Content

Inside the data is the team statistics for all of the FBS level teams at the year of the college season, it includes offensive, defensive, turnover, redzone, special teams, first down, third down, and fourth down stats. There are around 145 differenc team statistics that can be used.

Acknowledgements

All of this information is thanks to the NCAA stats website which makes the data easy to use and find. See more here: https://www.ncaa.com/stats/football/fbs

Inspiration

College Football is the only sport in the world where the college version is much older than the professional version. It has a very storied history and many antidotes about it. Explore the data to learn for yourself the following:

Does defense really does win championships?
What features translate into wins?
Are special teams of particular value for a team's performance?
Which Collegiate Conference is the best?
What's the correlation between offensive and defensive performance?

Tables

Cfb13

@kaggle.jeffgallini_college_football_team_stats_2019.cfb13

164.99 kB
111 rows
146 columns

CREATE TABLE cfb13 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "total_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT,
  "opp_rush_yards_alloweed" BIGINT,
  "yds_rush_allowed" DOUBLE,
  "opp_rush_touchdowns_allowed" BIGINT,
  "rush_yards_per_game_allowed" DOUBLE,
  "sack_rank" BIGINT,
  "sacks" BIGINT
);

Cfb14

@kaggle.jeffgallini_college_football_team_stats_2019.cfb14

166.35 kB
113 rows
146 columns

CREATE TABLE cfb14 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "total_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT,
  "opp_rush_yards_alloweed" BIGINT,
  "yds_rush_allowed" DOUBLE,
  "opp_rush_touchdowns_allowed" BIGINT,
  "rush_yards_per_game_allowed" DOUBLE,
  "sack_rank" BIGINT,
  "sacks" BIGINT
);

Cfb15

@kaggle.jeffgallini_college_football_team_stats_2019.cfb15

167 kB
115 rows
146 columns

CREATE TABLE cfb15 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "total_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT,
  "opp_rush_yards_alloweed" BIGINT,
  "yds_rush_allowed" DOUBLE,
  "opp_rush_touchdowns_allowed" BIGINT,
  "rush_yards_per_game_allowed" DOUBLE,
  "sack_rank" BIGINT,
  "sacks" BIGINT
);

Cfb16

@kaggle.jeffgallini_college_football_team_stats_2019.cfb16

174.74 kB
116 rows
152 columns

CREATE TABLE cfb16 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "n__40" DOUBLE  -- ...40,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb17

@kaggle.jeffgallini_college_football_team_stats_2019.cfb17

180.29 kB
129 rows
152 columns

CREATE TABLE cfb17 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "n__40" DOUBLE  -- ...40,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb18

@kaggle.jeffgallini_college_football_team_stats_2019.cfb18

180.07 kB
129 rows
152 columns

CREATE TABLE cfb18 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "n__40" DOUBLE  -- ...40,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb19

@kaggle.jeffgallini_college_football_team_stats_2019.cfb19

180.22 kB
130 rows
152 columns

CREATE TABLE cfb19 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "n__40" DOUBLE  -- ...40,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb20

@kaggle.jeffgallini_college_football_team_stats_2019.cfb20

179.57 kB
127 rows
152 columns

CREATE TABLE cfb20 (
  "team" VARCHAR,
  "games" BIGINT,
  "win" BIGINT,
  "loss" BIGINT,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "x4th_down_rank" BIGINT,
  "x4th_attempts" BIGINT,
  "x4th_conversions" BIGINT,
  "x4th_percent" DOUBLE,
  "x4rd_down_def_rank" BIGINT,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "n__40" DOUBLE  -- ...40,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb21

@kaggle.jeffgallini_college_football_team_stats_2019.cfb21

180.46 kB
130 rows
152 columns

CREATE TABLE cfb21 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "team" VARCHAR,
  "games" BIGINT,
  "win_loss" VARCHAR,
  "off_rank" BIGINT,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "n_4th_down_rank" BIGINT  -- 4th Down Rank,
  "n_4th_attempts" BIGINT  -- 4th Attempts,
  "n_4th_conversions" BIGINT  -- 4th Conversions,
  "n_4th_percent" DOUBLE  -- 4th Percent,
  "n_4rd_down_def_rank" BIGINT  -- 4rd Down Def Rank,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" BIGINT,
  "na" DOUBLE,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "rushing_off_rank" BIGINT,
  "rush_attempts" BIGINT,
  "rush_yds" BIGINT,
  "yards_rush" DOUBLE,
  "rushing_td" BIGINT,
  "rushing_yards_per_game" DOUBLE,
  "rushing_def_rank" BIGINT,
  "opp_rush_attempts" BIGINT
);

Cfb22

@kaggle.jeffgallini_college_football_team_stats_2019.cfb22

180.81 kB
131 rows
151 columns

CREATE TABLE cfb22 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "off_rank" BIGINT,
  "team" VARCHAR,
  "games" BIGINT,
  "win_loss" VARCHAR,
  "off_plays" BIGINT,
  "off_yards" BIGINT,
  "off_yards_play" DOUBLE,
  "off_tds" BIGINT,
  "off_yards_per_game" DOUBLE,
  "def_rank" BIGINT,
  "def_plays" BIGINT,
  "yards_allowed" BIGINT,
  "yards_play_allowed" DOUBLE,
  "off_tds_allowed" BIGINT,
  "total_tds_allowed" BIGINT,
  "yards_per_game_allowed" DOUBLE,
  "n_3rd_down_rank" BIGINT  -- 3rd Down Rank,
  "n_3rd_attempts" BIGINT  -- 3rd Attempts,
  "n_3rd_conversions" BIGINT  -- 3rd Conversions,
  "n_3rd_percent" DOUBLE  -- 3rd Percent,
  "n_3rd_down_def_rank" BIGINT  -- 3rd Down Def Rank,
  "opp_3rd_conversion" BIGINT,
  "opp_3rd_attempt" BIGINT,
  "opponent_3rd_percent" DOUBLE,
  "n_4th_down_rank" BIGINT  -- 4th Down Rank,
  "n_4th_attempts" BIGINT  -- 4th Attempts,
  "n_4th_conversions" BIGINT  -- 4th Conversions,
  "n_4th_percent" DOUBLE  -- 4th Percent,
  "n_4rd_down_def_rank" BIGINT  -- 4rd Down Def Rank,
  "opp_4th_conversion" BIGINT,
  "opp_4th_attempt" BIGINT,
  "opponent_4th_percent" DOUBLE,
  "penalty_rank" BIGINT,
  "penalties" BIGINT,
  "penalty_yards" BIGINT,
  "penalty_yards_per_game" DOUBLE,
  "first_down_def_rank" BIGINT,
  "opp_first_down_runs" BIGINT,
  "opp_first_down_passes" BIGINT,
  "opp_first_down_penalties" BIGINT,
  "opp_first_downs" BIGINT,
  "first_down_rank" BIGINT,
  "first_down_runs" BIGINT,
  "first_down_passes" BIGINT,
  "first_down_penalties" BIGINT,
  "first_downs" BIGINT,
  "kickoff_return_def_rank" BIGINT,
  "opp_kickoff_returns" BIGINT,
  "kickoff_touchbacks" BIGINT,
  "opponent_kickoff_return_yards" BIGINT,
  "opp_kickoff_return_touchdowns_allowed" BIGINT,
  "avg_yards_per_kickoff_return_allowed" DOUBLE,
  "kickoff_return_rank" BIGINT,
  "kickoffs_returned" BIGINT,
  "kickoff_return_yards" BIGINT,
  "kickoff_return_touchdowns" BIGINT,
  "avg_yard_per_kickoff_return" DOUBLE,
  "passing_off_rank" BIGINT,
  "pass_attempts" BIGINT,
  "pass_completions" BIGINT,
  "interceptions_thrown_x" BIGINT,
  "pass_yards" BIGINT,
  "pass_yards_attempt" DOUBLE,
  "yards_completion" DOUBLE,
  "pass_touchdowns" BIGINT,
  "pass_yards_per_game" DOUBLE,
  "pass_def_rank" BIGINT,
  "opp_completions_allowed" BIGINT,
  "opp_pass_attempts" BIGINT,
  "opp_pass_yds_allowed" BIGINT,
  "opp_pass_tds_allowed" BIGINT,
  "yards_attempt_allowed" DOUBLE,
  "yards_completion_allowed" DOUBLE,
  "pass_yards_per_game_allowed" DOUBLE,
  "punt_return_def_rank" BIGINT,
  "opp_punt_returns" BIGINT,
  "opp_net_punt_return_yards" BIGINT,
  "opp_punt_return_touchdowns_allowed" BIGINT,
  "avg_yards_allowed_per_punt_return" DOUBLE,
  "punt_return_rank" BIGINT,
  "punt_returns" BIGINT,
  "net_punt_return_yards" BIGINT,
  "punt_return_touchdowns" BIGINT,
  "avg_yards_per_punt_return" DOUBLE,
  "redzone_def_rank" BIGINT,
  "opp_redzone_attempts" BIGINT,
  "opp_redzone_rush_td_allowed" BIGINT,
  "opp_redzone_pass_touchdowns_allowed" BIGINT,
  "opp_redzone_field_goals_made" BIGINT,
  "opp_redzone_scores" BIGINT,
  "redzone_points_allowed" DOUBLE,
  "redzone_off_rank" BIGINT,
  "redzone_attempts" BIGINT,
  "redzone_rush_td" BIGINT,
  "redzone_pass_td" BIGINT,
  "redzone_field_goals_made" BIGINT,
  "redzone_scores" BIGINT,
  "redzone_points" DOUBLE,
  "rushing_def_rank" BIGINT
);

Cfb23

@kaggle.jeffgallini_college_football_team_stats_2019.cfb23

174.96 kB
134 rows
152 columns

CREATE TABLE cfb23 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "off_rank" VARCHAR,
  "team" VARCHAR,
  "games" VARCHAR,
  "win_loss" VARCHAR,
  "off_plays" VARCHAR,
  "off_yards" VARCHAR,
  "off_yards_play" VARCHAR,
  "off_tds" VARCHAR,
  "off_yards_per_game" VARCHAR,
  "def_rank" VARCHAR,
  "def_plays" VARCHAR,
  "yards_allowed" VARCHAR,
  "yards_play_allowed" VARCHAR,
  "off_tds_allowed" VARCHAR,
  "total_tds_allowed" VARCHAR,
  "yards_per_game_allowed" VARCHAR,
  "n_3rd_down_rank" VARCHAR  -- 3rd Down Rank,
  "n_3rd_attempts" VARCHAR  -- 3rd Attempts,
  "n_3rd_conversions" VARCHAR  -- 3rd Conversions,
  "n_3rd_percent" VARCHAR  -- 3rd Percent,
  "n_3rd_down_def_rank" VARCHAR  -- 3rd Down Def Rank,
  "opp_3rd_conversion" VARCHAR,
  "opp_3rd_attempt" VARCHAR,
  "opponent_3rd_percent" VARCHAR,
  "n_4th_down_rank" VARCHAR  -- 4th Down Rank,
  "n_4th_attempts" VARCHAR  -- 4th Attempts,
  "n_4th_conversions" VARCHAR  -- 4th Conversions,
  "n_4th_percent" VARCHAR  -- 4th Percent,
  "n_4rd_down_def_rank" VARCHAR  -- 4rd Down Def Rank,
  "opp_4th_conversion" VARCHAR,
  "opp_4th_attempt" VARCHAR,
  "opponent_4th_percent" VARCHAR,
  "penalty_rank" VARCHAR,
  "penalties" VARCHAR,
  "penalty_yards" VARCHAR,
  "penalty_yards_per_game" VARCHAR,
  "first_down_def_rank" VARCHAR,
  "opp_first_down_runs" VARCHAR,
  "opp_first_down_passes" VARCHAR,
  "opp_first_down_penalties" VARCHAR,
  "opp_first_downs" VARCHAR,
  "first_down_rank" VARCHAR,
  "first_down_runs" VARCHAR,
  "first_down_passes" VARCHAR,
  "first_down_penalties" VARCHAR,
  "first_downs" VARCHAR,
  "kickoff_return_def_rank" VARCHAR,
  "opp_kickoff_returns" VARCHAR,
  "kickoff_touchbacks_x" VARCHAR,
  "opponent_kickoff_return_yards" VARCHAR,
  "opp_kickoff_return_touchdowns_allowed" VARCHAR,
  "avg_yards_per_kickoff_return_allowed" VARCHAR,
  "kickoff_return_rank" VARCHAR,
  "kickoffs_returned" VARCHAR,
  "kickoff_touchbacks_y" VARCHAR,
  "kickoff_return_yards" VARCHAR,
  "kickoff_return_touchdowns" VARCHAR,
  "avg_yard_per_kickoff_return" VARCHAR,
  "passing_off_rank" VARCHAR,
  "pass_attempts" VARCHAR,
  "pass_completions" VARCHAR,
  "interceptions_thrown_x" VARCHAR,
  "pass_yards" VARCHAR,
  "pass_yards_attempt" VARCHAR,
  "yards_completion" VARCHAR,
  "pass_touchdowns" VARCHAR,
  "pass_yards_per_game" VARCHAR,
  "pass_def_rank" VARCHAR,
  "opp_completions_allowed" VARCHAR,
  "opp_pass_attempts" VARCHAR,
  "opp_pass_yds_allowed" VARCHAR,
  "opp_pass_tds_allowed" VARCHAR,
  "yards_attempt_allowed" VARCHAR,
  "yards_completion_allowed" VARCHAR,
  "pass_yards_per_game_allowed" VARCHAR,
  "punt_return_def_rank" VARCHAR,
  "opp_punt_returns" VARCHAR,
  "opp_net_punt_return_yards" VARCHAR,
  "opp_punt_return_touchdowns_allowed" VARCHAR,
  "avg_yards_allowed_per_punt_return" VARCHAR,
  "punt_return_rank" VARCHAR,
  "punt_returns" VARCHAR,
  "net_punt_return_yards" VARCHAR,
  "punt_return_touchdowns" VARCHAR,
  "avg_yards_per_punt_return" VARCHAR,
  "redzone_def_rank" VARCHAR,
  "opp_redzone_attempts" VARCHAR,
  "opp_redzone_rush_td_allowed" VARCHAR,
  "opp_redzone_pass_touchdowns_allowed" VARCHAR,
  "opp_redzone_field_goals_made" VARCHAR,
  "opp_redzone_scores" VARCHAR,
  "redzone_points_allowed" VARCHAR,
  "redzone_off_rank" VARCHAR,
  "redzone_attempts" VARCHAR,
  "redzone_rush_td" VARCHAR,
  "redzone_pass_td" VARCHAR,
  "redzone_field_goals_made" VARCHAR,
  "redzone_scores" VARCHAR,
  "redzone_points" VARCHAR
);