NFL Offensive Stats 2019 - 2022

CREATE TABLE nfl_offensive_stats (
  "game_id" VARCHAR,
  "player_id" VARCHAR,
  "position" VARCHAR,
  "player" VARCHAR,
  "team" VARCHAR,
  "pass_cmp" BIGINT,
  "pass_att" BIGINT,
  "pass_yds" BIGINT,
  "pass_td" BIGINT,
  "pass_int" BIGINT,
  "pass_sacked" BIGINT,
  "pass_sacked_yds" BIGINT,
  "pass_long" BIGINT,
  "pass_rating" DOUBLE,
  "rush_att" BIGINT,
  "rush_yds" BIGINT,
  "rush_td" BIGINT,
  "rush_long" BIGINT,
  "targets" BIGINT,
  "rec" BIGINT,
  "rec_yds" BIGINT,
  "rec_td" BIGINT,
  "rec_long" BIGINT,
  "fumbles_lost" BIGINT,
  "rush_scrambles" BIGINT,
  "designed_rush_att" BIGINT,
  "comb_pass_rush_play" BIGINT,
  "comb_pass_play" BIGINT,
  "comb_rush_play" BIGINT,
  "team_abbrev" VARCHAR,
  "opponent_abbrev" VARCHAR,
  "two_point_conv" BIGINT,
  "total_ret_td" BIGINT,
  "offensive_fumble_recovery_td" BIGINT,
  "pass_yds_bonus" BIGINT,
  "rush_yds_bonus" BIGINT,
  "rec_yds_bonus" BIGINT,
  "total_dkp" DOUBLE,
  "off_dkp" DOUBLE,
  "total_fdp" DOUBLE,
  "off_fdp" DOUBLE,
  "total_sdp" DOUBLE,
  "off_sdp" DOUBLE,
  "pass_target_yds" BIGINT,
  "pass_poor_throws" BIGINT,
  "pass_blitzed" BIGINT,
  "pass_hurried" BIGINT,
  "rush_yds_before_contact" BIGINT,
  "rush_yac" BIGINT,
  "rush_broken_tackles" BIGINT,
  "rec_air_yds" DOUBLE,
  "rec_yac" BIGINT,
  "rec_drops" BIGINT,
  "offense" BIGINT,
  "off_pct" BIGINT,
  "vis_team" VARCHAR,
  "home_team" VARCHAR,
  "vis_score" BIGINT,
  "home_score" BIGINT,
  "ot" BOOLEAN,
  "roof" VARCHAR,
  "surface" VARCHAR,
  "temperature" BIGINT,
  "humidity" BIGINT,
  "wind_speed" BIGINT,
  "vegas_line" DOUBLE,
  "vegas_favorite" VARCHAR,
  "over_under" DOUBLE,
  "game_date" TIMESTAMP
);