National Football League (NFL)

CREATE TABLE pbp (
  "play_id" DOUBLE,
  "game_id" VARCHAR,
  "old_game_id" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "season_type" VARCHAR,
  "week" INTEGER,
  "posteam" VARCHAR,
  "posteam_type" VARCHAR,
  "defteam" VARCHAR,
  "side_of_field" VARCHAR,
  "yardline_100" DOUBLE,
  "game_date" TIMESTAMP,
  "quarter_seconds_remaining" DOUBLE,
  "half_seconds_remaining" DOUBLE,
  "game_seconds_remaining" DOUBLE,
  "game_half" VARCHAR,
  "quarter_end" DOUBLE,
  "drive" DOUBLE,
  "sp" DOUBLE,
  "qtr" DOUBLE,
  "down" DOUBLE,
  "goal_to_go" DOUBLE,
  "time" VARCHAR,
  "yrdln" VARCHAR,
  "ydstogo" DOUBLE,
  "ydsnet" DOUBLE,
  "desc" VARCHAR,
  "play_type" VARCHAR,
  "yards_gained" DOUBLE,
  "shotgun" DOUBLE,
  "no_huddle" DOUBLE,
  "qb_dropback" DOUBLE,
  "qb_kneel" DOUBLE,
  "qb_spike" DOUBLE,
  "qb_scramble" DOUBLE,
  "pass_length" VARCHAR,
  "pass_location" VARCHAR,
  "air_yards" DOUBLE,
  "yards_after_catch" DOUBLE,
  "run_location" VARCHAR,
  "run_gap" VARCHAR,
  "field_goal_result" VARCHAR,
  "kick_distance" DOUBLE,
  "extra_point_result" VARCHAR,
  "two_point_conv_result" VARCHAR,
  "home_timeouts_remaining" DOUBLE,
  "away_timeouts_remaining" DOUBLE,
  "timeout" DOUBLE,
  "timeout_team" VARCHAR,
  "td_team" VARCHAR,
  "td_player_name" VARCHAR,
  "td_player_id" VARCHAR,
  "posteam_timeouts_remaining" DOUBLE,
  "defteam_timeouts_remaining" DOUBLE,
  "total_home_score" DOUBLE,
  "total_away_score" DOUBLE,
  "posteam_score" DOUBLE,
  "defteam_score" DOUBLE,
  "score_differential" DOUBLE,
  "posteam_score_post" DOUBLE,
  "defteam_score_post" DOUBLE,
  "score_differential_post" DOUBLE,
  "no_score_prob" DOUBLE,
  "opp_fg_prob" DOUBLE,
  "opp_safety_prob" DOUBLE,
  "opp_td_prob" DOUBLE,
  "fg_prob" DOUBLE,
  "safety_prob" DOUBLE,
  "td_prob" DOUBLE,
  "extra_point_prob" DOUBLE,
  "two_point_conversion_prob" DOUBLE,
  "ep" DOUBLE,
  "epa" DOUBLE,
  "total_home_epa" DOUBLE,
  "total_away_epa" DOUBLE,
  "total_home_rush_epa" DOUBLE,
  "total_away_rush_epa" DOUBLE,
  "total_home_pass_epa" DOUBLE,
  "total_away_pass_epa" DOUBLE,
  "air_epa" DOUBLE,
  "yac_epa" DOUBLE,
  "comp_air_epa" DOUBLE,
  "comp_yac_epa" DOUBLE,
  "total_home_comp_air_epa" DOUBLE,
  "total_away_comp_air_epa" DOUBLE,
  "total_home_comp_yac_epa" DOUBLE,
  "total_away_comp_yac_epa" DOUBLE,
  "total_home_raw_air_epa" DOUBLE,
  "total_away_raw_air_epa" DOUBLE,
  "total_home_raw_yac_epa" DOUBLE,
  "total_away_raw_yac_epa" DOUBLE,
  "wp" DOUBLE,
  "def_wp" DOUBLE,
  "home_wp" DOUBLE,
  "away_wp" DOUBLE,
  "wpa" DOUBLE,
  "vegas_wpa" DOUBLE,
  "vegas_home_wpa" DOUBLE,
  "home_wp_post" DOUBLE
);

CREATE TABLE snap_counts (
  "game_id" VARCHAR,
  "pfr_game_id" VARCHAR,
  "season" INTEGER,
  "game_type" VARCHAR,
  "week" INTEGER,
  "player" VARCHAR,
  "pfr_player_id" VARCHAR,
  "position" VARCHAR,
  "team" VARCHAR,
  "opponent" VARCHAR,
  "offense_snaps" DOUBLE,
  "offense_pct" DOUBLE,
  "defense_snaps" DOUBLE,
  "defense_pct" DOUBLE,
  "st_snaps" DOUBLE,
  "st_pct" DOUBLE
);

CREATE TABLE draft_picks (
  "season" INTEGER,
  "round" INTEGER,
  "pick" INTEGER,
  "team" VARCHAR,
  "gsis_id" VARCHAR,
  "pfr_player_id" VARCHAR,
  "cfb_player_id" VARCHAR,
  "pfr_player_name" VARCHAR,
  "hof" BOOLEAN,
  "position" VARCHAR,
  "category" VARCHAR,
  "side" VARCHAR,
  "college" VARCHAR,
  "age" INTEGER,
  "to" INTEGER,
  "allpro" INTEGER,
  "probowls" INTEGER,
  "seasons_started" INTEGER,
  "w_av" INTEGER,
  "car_av" VARCHAR,
  "dr_av" INTEGER,
  "games" INTEGER,
  "pass_completions" INTEGER,
  "pass_attempts" INTEGER,
  "pass_yards" INTEGER,
  "pass_tds" INTEGER,
  "pass_ints" INTEGER,
  "rush_atts" INTEGER,
  "rush_yards" INTEGER,
  "rush_tds" INTEGER,
  "receptions" INTEGER,
  "rec_yards" INTEGER,
  "rec_tds" INTEGER,
  "def_solo_tackles" INTEGER,
  "def_ints" INTEGER,
  "def_sacks" DOUBLE
);

CREATE TABLE players (
  "college_conference" VARCHAR,
  "college_name" VARCHAR,
  "current_team_id" DOUBLE,
  "display_name" VARCHAR,
  "draft_club" VARCHAR,
  "draft_number" INTEGER,
  "draftround" INTEGER,
  "entry_year" INTEGER,
  "esb_id" VARCHAR,
  "first_name" VARCHAR,
  "football_name" VARCHAR,
  "gsis_id" VARCHAR,
  "gsis_it_id" INTEGER,
  "jersey_number" INTEGER,
  "last_name" VARCHAR,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "rookie_year" INTEGER,
  "short_name" VARCHAR,
  "status" VARCHAR,
  "status_description_abbr" VARCHAR,
  "status_short_description" VARCHAR,
  "team_abbr" VARCHAR,
  "uniform_number" VARCHAR,
  "height" DOUBLE,
  "weight" INTEGER,
  "headshot" VARCHAR,
  "smart_id" VARCHAR,
  "years_of_experience" DOUBLE,
  "birth_date" TIMESTAMP,
  "team_seq" INTEGER,
  "suffix" VARCHAR
);

CREATE TABLE player_stats_weekly (
  "player_id" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "recent_team" VARCHAR,
  "season" INTEGER,
  "week" INTEGER,
  "season_type" VARCHAR,
  "opponent_team" VARCHAR,
  "completions" INTEGER,
  "attempts" INTEGER,
  "passing_yards" DOUBLE,
  "passing_tds" INTEGER,
  "interceptions" DOUBLE,
  "sacks" DOUBLE,
  "sack_yards" DOUBLE,
  "sack_fumbles" INTEGER,
  "sack_fumbles_lost" INTEGER,
  "passing_air_yards" DOUBLE,
  "passing_yards_after_catch" DOUBLE,
  "passing_first_downs" DOUBLE,
  "passing_epa" DOUBLE,
  "passing_2pt_conversions" INTEGER,
  "pacr" DOUBLE,
  "dakota" DOUBLE,
  "carries" INTEGER,
  "rushing_yards" DOUBLE,
  "rushing_tds" INTEGER,
  "rushing_fumbles" DOUBLE,
  "rushing_fumbles_lost" DOUBLE,
  "rushing_first_downs" DOUBLE,
  "rushing_epa" DOUBLE,
  "rushing_2pt_conversions" INTEGER,
  "receptions" INTEGER,
  "targets" INTEGER,
  "receiving_yards" DOUBLE,
  "receiving_tds" INTEGER,
  "receiving_fumbles" DOUBLE,
  "receiving_fumbles_lost" DOUBLE,
  "receiving_air_yards" DOUBLE,
  "receiving_yards_after_catch" DOUBLE,
  "receiving_first_downs" DOUBLE,
  "receiving_epa" DOUBLE,
  "receiving_2pt_conversions" INTEGER,
  "racr" DOUBLE,
  "target_share" DOUBLE,
  "air_yards_share" DOUBLE,
  "wopr" DOUBLE,
  "special_teams_tds" DOUBLE,
  "fantasy_points" DOUBLE,
  "fantasy_points_ppr" DOUBLE
);

CREATE TABLE player_stats_season (
  "season" INTEGER,
  "season_type" VARCHAR,
  "player_id" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "games" INTEGER,
  "recent_team" VARCHAR,
  "completions" INTEGER,
  "attempts" INTEGER,
  "passing_yards" DOUBLE,
  "passing_tds" INTEGER,
  "interceptions" DOUBLE,
  "sacks" DOUBLE,
  "sack_yards" DOUBLE,
  "sack_fumbles" INTEGER,
  "sack_fumbles_lost" INTEGER,
  "passing_air_yards" DOUBLE,
  "passing_yards_after_catch" DOUBLE,
  "passing_first_downs" DOUBLE,
  "passing_epa" DOUBLE,
  "passing_2pt_conversions" INTEGER,
  "pacr" DOUBLE,
  "dakota" DOUBLE,
  "carries" INTEGER,
  "rushing_yards" DOUBLE,
  "rushing_tds" INTEGER,
  "rushing_fumbles" DOUBLE,
  "rushing_fumbles_lost" DOUBLE,
  "rushing_first_downs" DOUBLE,
  "rushing_epa" DOUBLE,
  "rushing_2pt_conversions" INTEGER,
  "receptions" INTEGER,
  "targets" INTEGER,
  "receiving_yards" DOUBLE,
  "receiving_tds" INTEGER,
  "receiving_fumbles" DOUBLE,
  "receiving_fumbles_lost" DOUBLE,
  "receiving_air_yards" DOUBLE,
  "receiving_yards_after_catch" DOUBLE,
  "receiving_first_downs" DOUBLE,
  "receiving_epa" DOUBLE,
  "receiving_2pt_conversions" INTEGER,
  "racr" DOUBLE,
  "target_share" DOUBLE,
  "air_yards_share" DOUBLE,
  "wopr" DOUBLE,
  "special_teams_tds" DOUBLE,
  "fantasy_points" DOUBLE,
  "fantasy_points_ppr" DOUBLE
);

CREATE TABLE player_stats_def_weekly (
  "season" INTEGER,
  "week" INTEGER,
  "season_type" VARCHAR,
  "player_id" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "team" VARCHAR,
  "def_tackles" INTEGER,
  "def_tackles_solo" INTEGER,
  "def_tackles_with_assist" INTEGER,
  "def_tackle_assists" INTEGER,
  "def_tackles_for_loss" INTEGER,
  "def_tackles_for_loss_yards" DOUBLE,
  "def_fumbles_forced" INTEGER,
  "def_sacks" DOUBLE,
  "def_sack_yards" DOUBLE,
  "def_qb_hits" DOUBLE,
  "def_interceptions" DOUBLE,
  "def_interception_yards" DOUBLE,
  "def_pass_defended" DOUBLE,
  "def_tds" DOUBLE,
  "def_fumbles" DOUBLE,
  "def_fumble_recovery_own" DOUBLE,
  "def_fumble_recovery_yards_own" DOUBLE,
  "def_fumble_recovery_opp" DOUBLE,
  "def_fumble_recovery_yards_opp" DOUBLE,
  "def_safety" INTEGER,
  "def_penalty" DOUBLE,
  "def_penalty_yards" DOUBLE
);

CREATE TABLE player_stats_def_season (
  "season" INTEGER,
  "season_type" VARCHAR,
  "player_id" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "games" INTEGER,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "team" VARCHAR,
  "def_tackles" INTEGER,
  "def_tackles_solo" INTEGER,
  "def_tackles_with_assist" INTEGER,
  "def_tackle_assists" INTEGER,
  "def_tackles_for_loss" INTEGER,
  "def_tackles_for_loss_yards" DOUBLE,
  "def_fumbles_forced" INTEGER,
  "def_sacks" DOUBLE,
  "def_sack_yards" DOUBLE,
  "def_qb_hits" DOUBLE,
  "def_interceptions" DOUBLE,
  "def_interception_yards" DOUBLE,
  "def_pass_defended" DOUBLE,
  "def_tds" DOUBLE,
  "def_fumbles" DOUBLE,
  "def_fumble_recovery_own" DOUBLE,
  "def_fumble_recovery_yards_own" DOUBLE,
  "def_fumble_recovery_opp" DOUBLE,
  "def_fumble_recovery_yards_opp" DOUBLE,
  "def_safety" INTEGER,
  "def_penalty" DOUBLE,
  "def_penalty_yards" DOUBLE
);

CREATE TABLE player_stats_kicking_weekly (
  "season" INTEGER,
  "week" INTEGER,
  "season_type" VARCHAR,
  "player_id" VARCHAR,
  "team" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "fg_made" INTEGER,
  "fg_att" DOUBLE,
  "fg_missed" INTEGER,
  "fg_blocked" INTEGER,
  "fg_long" DOUBLE,
  "fg_pct" DOUBLE,
  "fg_made_0_19" INTEGER,
  "fg_made_20_29" INTEGER,
  "fg_made_30_39" INTEGER,
  "fg_made_40_49" INTEGER,
  "fg_made_50_59" INTEGER,
  "fg_made_60" INTEGER,
  "fg_missed_0_19" INTEGER,
  "fg_missed_20_29" INTEGER,
  "fg_missed_30_39" INTEGER,
  "fg_missed_40_49" INTEGER,
  "fg_missed_50_59" INTEGER,
  "fg_missed_60" INTEGER,
  "fg_made_list" VARCHAR,
  "fg_missed_list" VARCHAR,
  "fg_blocked_list" VARCHAR,
  "fg_made_distance" DOUBLE,
  "fg_missed_distance" DOUBLE,
  "fg_blocked_distance" DOUBLE,
  "pat_made" INTEGER,
  "pat_att" DOUBLE,
  "pat_missed" INTEGER,
  "pat_blocked" INTEGER,
  "pat_pct" DOUBLE,
  "gwfg_att" INTEGER,
  "gwfg_distance" DOUBLE,
  "gwfg_made" INTEGER,
  "gwfg_missed" INTEGER,
  "gwfg_blocked" INTEGER
);

CREATE TABLE player_stats_kicking_season (
  "season" INTEGER,
  "season_type" VARCHAR,
  "player_id" VARCHAR,
  "team" VARCHAR,
  "player_name" VARCHAR,
  "player_display_name" VARCHAR,
  "games" INTEGER,
  "position" VARCHAR,
  "position_group" VARCHAR,
  "headshot_url" VARCHAR,
  "fg_made" INTEGER,
  "fg_att" DOUBLE,
  "fg_missed" INTEGER,
  "fg_blocked" INTEGER,
  "fg_long" DOUBLE,
  "fg_pct" DOUBLE,
  "fg_made_0_19" INTEGER,
  "fg_made_20_29" INTEGER,
  "fg_made_30_39" INTEGER,
  "fg_made_40_49" INTEGER,
  "fg_made_50_59" INTEGER,
  "fg_made_60" INTEGER,
  "fg_missed_0_19" INTEGER,
  "fg_missed_20_29" INTEGER,
  "fg_missed_30_39" INTEGER,
  "fg_missed_40_49" INTEGER,
  "fg_missed_50_59" INTEGER,
  "fg_missed_60" INTEGER,
  "fg_made_list" VARCHAR,
  "fg_missed_list" VARCHAR,
  "fg_blocked_list" VARCHAR,
  "fg_made_distance" DOUBLE,
  "fg_missed_distance" DOUBLE,
  "fg_blocked_distance" DOUBLE,
  "pat_made" INTEGER,
  "pat_att" DOUBLE,
  "pat_missed" INTEGER,
  "pat_blocked" INTEGER,
  "pat_pct" DOUBLE,
  "gwfg_att" INTEGER,
  "gwfg_distance_list" VARCHAR,
  "gwfg_made" INTEGER,
  "gwfg_missed" INTEGER,
  "gwfg_blocked" INTEGER
);

CREATE TABLE ngs_passing (
  "season" INTEGER,
  "season_type" VARCHAR,
  "week" INTEGER,
  "player_display_name" VARCHAR,
  "player_position" VARCHAR,
  "team_abbr" VARCHAR,
  "avg_time_to_throw" DOUBLE,
  "avg_completed_air_yards" DOUBLE,
  "avg_intended_air_yards" DOUBLE,
  "avg_air_yards_differential" DOUBLE,
  "aggressiveness" DOUBLE,
  "max_completed_air_distance" DOUBLE,
  "avg_air_yards_to_sticks" DOUBLE,
  "attempts" INTEGER,
  "pass_yards" INTEGER,
  "pass_touchdowns" INTEGER,
  "interceptions" INTEGER,
  "passer_rating" DOUBLE,
  "completions" INTEGER,
  "completion_percentage" DOUBLE,
  "expected_completion_percentage" DOUBLE,
  "completion_percentage_above_expectation" DOUBLE,
  "avg_air_distance" DOUBLE,
  "max_air_distance" DOUBLE,
  "player_gsis_id" VARCHAR,
  "player_first_name" VARCHAR,
  "player_last_name" VARCHAR,
  "player_jersey_number" INTEGER,
  "player_short_name" VARCHAR
);

CREATE TABLE ngs_receiving (
  "season" INTEGER,
  "season_type" VARCHAR,
  "week" INTEGER,
  "player_display_name" VARCHAR,
  "player_position" VARCHAR,
  "team_abbr" VARCHAR,
  "avg_cushion" DOUBLE,
  "avg_separation" DOUBLE,
  "avg_intended_air_yards" DOUBLE,
  "percent_share_of_intended_air_yards" DOUBLE,
  "receptions" INTEGER,
  "targets" INTEGER,
  "catch_percentage" DOUBLE,
  "yards" INTEGER,
  "rec_touchdowns" INTEGER,
  "avg_yac" DOUBLE,
  "avg_expected_yac" DOUBLE,
  "avg_yac_above_expectation" DOUBLE,
  "player_gsis_id" VARCHAR,
  "player_first_name" VARCHAR,
  "player_last_name" VARCHAR,
  "player_jersey_number" INTEGER,
  "player_short_name" VARCHAR
);

CREATE TABLE ngs_rushing (
  "season" INTEGER,
  "season_type" VARCHAR,
  "week" INTEGER,
  "player_display_name" VARCHAR,
  "player_position" VARCHAR,
  "team_abbr" VARCHAR,
  "efficiency" DOUBLE,
  "percent_attempts_gte_eight_defenders" DOUBLE,
  "avg_time_to_los" DOUBLE,
  "rush_attempts" INTEGER,
  "rush_yards" INTEGER,
  "avg_rush_yards" DOUBLE,
  "rush_touchdowns" INTEGER,
  "player_gsis_id" VARCHAR,
  "player_first_name" VARCHAR,
  "player_last_name" VARCHAR,
  "player_jersey_number" INTEGER,
  "player_short_name" VARCHAR,
  "expected_rush_yards" DOUBLE,
  "rush_yards_over_expected" DOUBLE,
  "rush_yards_over_expected_per_att" DOUBLE,
  "rush_pct_over_expected" DOUBLE
);

CREATE TABLE injuries (
  "season" DOUBLE,
  "game_type" VARCHAR,
  "team" VARCHAR,
  "week" DOUBLE,
  "gsis_id" VARCHAR,
  "position" VARCHAR,
  "full_name" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "report_primary_injury" VARCHAR,
  "report_secondary_injury" VARCHAR,
  "report_status" VARCHAR,
  "practice_primary_injury" VARCHAR,
  "practice_secondary_injury" VARCHAR,
  "practice_status" VARCHAR,
  "date_modified" TIMESTAMP
);

CREATE TABLE depth_charts (
  "season" INTEGER,
  "club_code" VARCHAR,
  "week" INTEGER,
  "game_type" VARCHAR,
  "depth_team" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "football_name" VARCHAR,
  "formation" VARCHAR,
  "gsis_id" VARCHAR,
  "jersey_number" DOUBLE,
  "position" VARCHAR,
  "elias_id" VARCHAR,
  "depth_position" VARCHAR,
  "full_name" VARCHAR
);

CREATE TABLE combine (
  "season" INTEGER,
  "draft_year" DOUBLE,
  "draft_team" VARCHAR,
  "draft_round" DOUBLE,
  "draft_ovr" DOUBLE,
  "pfr_id" VARCHAR,
  "cfb_id" VARCHAR,
  "player_name" VARCHAR,
  "pos" VARCHAR,
  "school" VARCHAR,
  "ht" VARCHAR,
  "wt" DOUBLE,
  "forty" DOUBLE,
  "bench" DOUBLE,
  "vertical" DOUBLE,
  "broad_jump" DOUBLE,
  "cone" DOUBLE,
  "shuttle" DOUBLE
);

CREATE TABLE rosters (
  "season" INTEGER,
  "team" VARCHAR,
  "position" VARCHAR,
  "depth_chart_position" VARCHAR,
  "jersey_number" INTEGER,
  "status" VARCHAR,
  "full_name" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "height" DOUBLE,
  "weight" INTEGER,
  "college" VARCHAR,
  "gsis_id" VARCHAR,
  "espn_id" DOUBLE,
  "sportradar_id" VARCHAR,
  "yahoo_id" DOUBLE,
  "rotowire_id" DOUBLE,
  "pff_id" DOUBLE,
  "pfr_id" VARCHAR,
  "fantasy_data_id" DOUBLE,
  "sleeper_id" DOUBLE,
  "years_exp" INTEGER,
  "headshot_url" VARCHAR,
  "esb_id" VARCHAR,
  "gsis_it_id" DOUBLE,
  "smart_id" VARCHAR,
  "entry_year" INTEGER,
  "rookie_year" INTEGER,
  "draft_club" VARCHAR
);

CREATE TABLE contracts (
  "player" VARCHAR,
  "position" VARCHAR,
  "team" VARCHAR,
  "is_active" BOOLEAN,
  "year_signed" INTEGER,
  "years" INTEGER,
  "value" DOUBLE,
  "apy" DOUBLE,
  "guaranteed" DOUBLE,
  "apy_cap_pct" DOUBLE,
  "inflated_value" DOUBLE,
  "inflated_apy" DOUBLE,
  "inflated_guaranteed" DOUBLE,
  "player_page" VARCHAR,
  "otc_id" INTEGER,
  "gsis_id" VARCHAR,
  "date_of_birth" VARCHAR,
  "height" VARCHAR,
  "weight" DOUBLE,
  "college" VARCHAR,
  "draft_year" INTEGER,
  "draft_round" INTEGER,
  "draft_overall" INTEGER,
  "draft_team" VARCHAR,
  "cols" VARCHAR
);