home / nfl / players

Query assistant for players

Schema that will be passed to the model
CREATE TABLE "players" (
"player_id" TEXT,
  "player_display_name" TEXT,
  "position" TEXT,
  "recent_team" TEXT,
  "season" INTEGER,
  "week" INTEGER,
  "completions" INTEGER,
  "attempts" INTEGER,
  "passing_yards" REAL,
  "passing_tds" INTEGER,
  "interceptions" REAL,
  "sacks" REAL,
  "sack_yards" REAL,
  "sack_fumbles" INTEGER,
  "sack_fumbles_lost" INTEGER,
  "passing_air_yards" REAL,
  "passing_yards_after_catch" REAL,
  "passing_first_downs" REAL,
  "passing_2pt_conversions" INTEGER,
  "carries" INTEGER,
  "rushing_yards" REAL,
  "rushing_tds" INTEGER,
  "rushing_fumbles" REAL,
  "rushing_fumbles_lost" REAL,
  "rushing_first_downs" REAL,
  "rushing_2pt_conversions" INTEGER,
  "receptions" INTEGER,
  "targets" INTEGER,
  "receiving_yards" REAL,
  "receiving_tds" INTEGER,
  "receiving_fumbles" REAL,
  "receiving_fumbles_lost" REAL,
  "receiving_air_yards" REAL,
  "receiving_yards_after_catch" REAL,
  "receiving_first_downs" REAL,
  "receiving_2pt_conversions" INTEGER,
  "special_teams_tds" REAL,
  "fantasy_points" REAL,
  "fantasy_points_ppr" REAL,
  "opponent_team" TEXT
)
Powered by Datasette