Name: La Liga Results 1929-30 To 2019-20
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

La Liga Results 1929-30 To 2019-20

Plug: Check out the Tableau Visualization I made using this data.

It's nothing groundbreaking, but it was satisfying and bit challenging to make.
Oh, and it sometimes tends to break for seasons with number of clubs < 20.
Shhhh.

Tip: Although you can use Python to scrape this data (as I did in first few attempts), a better and more feasible method in my opinion would be to use `IMPORTHTML` tool in G-Sheets.

The dataset contains league table and match results of all seasons in the Spanish Football League, or LaLiga as it's known.

All seasons are included, starting from the inaugural 1929-30 to the recently wrapped 2019-20.
Exceptions: 1936-37, 1937-38, 1938-39 due to the Spanish Civil War.

Data was scraped from Wikipedia, and is as error-proof as humanly possible.

Tables

La Liga

@kaggle.dxtnikhil_la_liga_historical.la_liga

53.84 kB
1,522 rows
30 columns

CREATE TABLE la_liga (
  "season" VARCHAR,
  "s_no" BIGINT  -- S. No.,
  "home_away" VARCHAR  -- Home \\ Away,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "position" BIGINT,
  "played" BIGINT,
  "won" BIGINT,
  "draw" BIGINT,
  "lost" BIGINT
);