Dataset: La Liga Stats 2021-2022

About this Dataset

La Liga Stats 2021-2022

Context

LaLiga is the trademark behind the Spanish Football Competitions and their data can be viewed on laliga.com but there is no way to download a csv file with the whole information.

To that end, I've built a Python scraper to retrieve and public these data. Data is updated weekly.

Content

So far, here you have the available contents:

Player Data: You'll find all available player data from LaLiga with a huge amount of columns for these competitions: female first division, male first division and male second division. Each file is identified by SXX-YY at the beginning meaning the season XX-YY.

Acknowledgements

Thanks Python!

Tables

S2122 Laliga Players

@kaggle.sdelquin_laliga_data.s2122_laliga_players

498.44 KB
1994 rows
150 columns


CREATE TABLE s2122_laliga_players (
  "competition" VARCHAR,
  "player_url" VARCHAR,
  "id" BIGINT,
  "slug" VARCHAR,
  "name" VARCHAR,
  "nickname" VARCHAR,
  "firstname" VARCHAR,
  "lastname" VARCHAR,
  "gender" VARCHAR,
  "date_of_birth" VARCHAR,
  "place_of_birth" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "international" BOOLEAN,
  "twitter" VARCHAR,
  "instagram" VARCHAR,
  "country" VARCHAR,
  "team" VARCHAR,
  "team_shortname" VARCHAR,
  "team_foundation" VARCHAR,
  "team_shield" VARCHAR,
  "shirt_number" DOUBLE,
  "position" VARCHAR,
  "photo" VARCHAR,
  "stadium" VARCHAR,
  "stadium_image" VARCHAR,
  "aerial_duels" DOUBLE,
  "aerial_duels_lost" DOUBLE,
  "aerial_duels_won" DOUBLE,
  "appearances" DOUBLE,
  "assists_intentional" DOUBLE,
  "attempts_from_set_pieces" DOUBLE,
  "away_goals" DOUBLE,
  "backward_passes" DOUBLE,
  "blocked_shots" DOUBLE,
  "blocks" DOUBLE,
  "catches" DOUBLE,
  "clean_sheets" DOUBLE,
  "clearances_off_the_line" DOUBLE,
  "corners_taken_incl_short_corners" DOUBLE,
  "corners_won" DOUBLE,
  "crosses_not_claimed" DOUBLE,
  "drops" DOUBLE,
  "duels" DOUBLE,
  "duels_lost" DOUBLE,
  "duels_won" DOUBLE,
  "fifty_fifty" DOUBLE,
  "forward_passes" DOUBLE,
  "foul_attempted_tackle" DOUBLE,
  "foul_won_penalty" DOUBLE,
  "games_played" DOUBLE,
  "gk_successful_distribution" DOUBLE,
  "gk_unsuccessful_distribution" DOUBLE,
  "goal_assists" DOUBLE,
  "goalkeeper_smother" DOUBLE,
  "goals" DOUBLE,
  "goals_conceded" DOUBLE,
  "goals_conceded_inside_box" DOUBLE,
  "goals_conceded_outside_box" DOUBLE,
  "goals_from_inside_box" DOUBLE,
  "goals_from_outside_box" DOUBLE,
  "ground_duels" DOUBLE,
  "ground_duels_lost" DOUBLE,
  "ground_duels_won" DOUBLE,
  "handballs_conceded" DOUBLE,
  "headed_goals" DOUBLE,
  "hit_woodwork" DOUBLE,
  "home_goals" DOUBLE,
  "index" DOUBLE,
  "interceptions" DOUBLE,
  "key_passes_attempt_assists" DOUBLE,
  "last_man_tackle" DOUBLE,
  "left_foot_goals" DOUBLE,
  "leftside_passes" DOUBLE,
  "offsides" DOUBLE,
  "open_play_passes" DOUBLE,
  "other_goals" DOUBLE,
  "own_goal_scored" DOUBLE,
  "penalties_conceded" DOUBLE,
  "penalties_faced" DOUBLE,
  "penalties_off_target" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_taken" DOUBLE,
  "penalty_goals" DOUBLE,
  "penalty_goals_conceded" DOUBLE,
  "punches" DOUBLE,
  "putthrough_blocked_distribution" DOUBLE,
  "putthrough_blocked_distribution_won" DOUBLE,
  "recoveries" DOUBLE,
  "red_cards_2nd_yellow" DOUBLE,
  "right_foot_goals" DOUBLE,
  "rightside_passes" DOUBLE,
  "saves_from_penalty" DOUBLE,
  "saves_made" DOUBLE,
  "saves_made_caught" DOUBLE,
  "saves_made_from_inside_box" DOUBLE,
  "saves_made_from_outside_box" DOUBLE,
  "saves_made_parried" DOUBLE,
  "second_goal_assists" DOUBLE,
  "set_pieces_goals" DOUBLE
);