LaLiga Player Stats

CREATE TABLE laliga_player_stats_english (
  "team" VARCHAR,
  "position" VARCHAR,
  "shirt_number" DOUBLE,
  "name" VARCHAR,
  "minutes_played" DOUBLE,
  "games_played" BIGINT,
  "percentage_of_games_played" VARCHAR,
  "full_games_played" BIGINT,
  "percentage_of_full_games_played" VARCHAR,
  "games_started" BIGINT,
  "percentage_of_games_started" VARCHAR,
  "games_where_substituted" BIGINT,
  "percentage_of_games_where_substituted" VARCHAR,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "second_yellows" BIGINT,
  "goals_scored" BIGINT,
  "penalties_scored" BIGINT,
  "own_goals" BIGINT,
  "goals_conceded_while_player_on_pitch" BIGINT,
  "tackles" BIGINT,
  "interceptions" BIGINT,
  "recoveries" BIGINT,
  "clearances" BIGINT,
  "successful_tackles" BIGINT,
  "unssuccessful_tackles" BIGINT,
  "last_man" BIGINT,
  "successful_duels" BIGINT,
  "duels_lost" BIGINT,
  "successful_aerial_challenges" BIGINT,
  "unsuccessful_aerial_challenges" BIGINT,
  "offsides" BIGINT,
  "fouls_suffered" BIGINT,
  "fouls_committed" BIGINT,
  "penalties_won" BIGINT,
  "penalties_given_away" BIGINT,
  "handballs_committed" BIGINT,
  "fouls_committed_per_card" BIGINT,
  "shots" BIGINT,
  "shots_on_target" BIGINT,
  "assists" BIGINT,
  "successful_dribbles" BIGINT,
  "unsuccessful_dribbles" BIGINT,
  "goals_scored_1" BIGINT,
  "from_inside_the_area" BIGINT,
  "from_outside_the_area" BIGINT,
  "goals_with_left_foot" BIGINT,
  "goals_with_right_foot" BIGINT,
  "penalties_scored_1" BIGINT,
  "goals_scored_with_header" BIGINT,
  "goals_from_set_piece" BIGINT,
  "crosses" BIGINT,
  "corners" BIGINT,
  "tackles_1" BIGINT,
  "duels" BIGINT,
  "man_to_man_duels" BIGINT,
  "aerial_duels" BIGINT,
  "passes" DOUBLE,
  "short_passes" DOUBLE,
  "long_passes" BIGINT,
  "through_balls" BIGINT,
  "goals_scored_per_attempt" BIGINT
);