La Liga Results 1929-30 To 2019-20

Match Result, League Table for each season since the beginning of Spanish League

@kaggle.dxtnikhil_la_liga_historical

Table List

1 table(52.58 KB)

La Liga

@kaggle.dxtnikhil_la_liga_historical.la_liga

52.58 KB
1522 rows
30 columns

season Season	s_no S. No.	home_away Home \\ Away	n_1 1	n_2 2	n_3 3	n_4 4	n_5 5	n_6 6	n_7 7	n_8 8	n_9 9	n_10 10	n_11 11	n_12 12	n_13 13	n_14 14	n_15 15	n_16 16	n_17 17	n_18 18	n_19 19	n_20 20	n_21 21	n_22 22	position Position	played Played	won Won	draw Draw	lost Lost
2019-20	1	Alavés		2–1	1–1	0–5	2–0	2–1	0–0	0–0	0–2	1–1	1–0	2–0	0–1	1–1	1–2	2–0	0–1	1–1	3–0	1–2	nan	nan	16	38	10	9	19
2019-20	2	Athletic Bilbao	2–0		1–1	1–0	1–1	0–0	3–0	0–2	2–0	0–2	2–1	3–1	0–1	1–0	0–1	2–0	1–2	0–1	1–1	1–0	nan	nan	11	38	13	12	13
2019-20	3	Atlético Madrid	2–1	2–0		0–1	0–0	3–2	3–1	1–0	1–0	0–0	2–1	3–0	2–0	1–0	0–0	1–1	2–2	1–1	1–0	3–1	nan	nan	3	38	18	16	4
2019-20	4	Barcelona	4–1	1–0	2–2		4–1	5–0	1–0	2–1	1–0	2–0	2–1	5–2	1–2	5–2	0–0	1–0	4–0	5–2	5–1	2–1	nan	nan	2	38	25	7	6
2019-20	5	Celta Vigo	6–0	1–0	1–1	2–2		0–0	1–1	0–1	0–2	1–0	2–3	2–2	1–1	1–1	1–3	0–1	2–1	1–0	0–0	0–1	nan	nan	17	38	7	16	15
2019-20	6	Eibar	0–2	2–2	2–0	0–3	2–0		1–2	0–1	3–0	0–0	3–0	1–2	0–2	1–1	0–4	1–2	3–2	1–0	3–1	2–1	nan	nan	14	38	11	9	18
2019-20	7	Espanyol	2–0	1–1	1–1	2–2	0–0	0–2		1–1	0–3	0–1	1–3	1–0	2–4	2–2	0–1	1–3	0–2	1–2	0–2	0–1	nan	nan	20	38	5	10	23
2019-20	8	Getafe	1–1	1–1	0–2	0–2	0–0	1–1	0–0		3–1	2–0	4–0	4–2	0–0	1–0	0–3	2–1	0–3	3–0	2–0	1–3	nan	nan	8	38	14	12	12
2019-20	9	Granada	3–0	4–0	1–1	2–0	0–0	1–2	2–1	2–1		1–0	1–2	1–0	1–0	1–0	1–2	1–2	0–1	2–2	2–1	0–1	nan	nan	7	38	16	8	14
2019-20	10	Leganés	1–1	1–1	0–1	1–2	3–2	1–2	2–0	0–3	0–0		1–2	1–0	0–1	0–0	2–2	2–1	0–3	1–0	1–2	0–3	nan	nan	18	38	8	12	18


CREATE TABLE la_liga (
  "season" VARCHAR,
  "s_no" BIGINT,
  "home_away" VARCHAR,
  "n_1" VARCHAR,
  "n_2" VARCHAR,
  "n_3" VARCHAR,
  "n_4" VARCHAR,
  "n_5" VARCHAR,
  "n_6" VARCHAR,
  "n_7" VARCHAR,
  "n_8" VARCHAR,
  "n_9" VARCHAR,
  "n_10" VARCHAR,
  "n_11" VARCHAR,
  "n_12" VARCHAR,
  "n_13" VARCHAR,
  "n_14" VARCHAR,
  "n_15" VARCHAR,
  "n_16" VARCHAR,
  "n_17" VARCHAR,
  "n_18" VARCHAR,
  "n_19" VARCHAR,
  "n_20" VARCHAR,
  "n_21" VARCHAR,
  "n_22" VARCHAR,
  "position" BIGINT,
  "played" BIGINT,
  "won" BIGINT,
  "draw" BIGINT,
  "lost" BIGINT
);