Baselight
Sign In

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

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-201Alavés 2–11–10–52–02–10–00–00–21–11–02–00–11–11–22–00–11–13–01–2nannan163810919
2019-202Athletic Bilbao2–0 1–11–01–10–03–00–22–00–22–13–10–11–00–12–01–20–11–11–0nannan1138131213
2019-203Atlético Madrid2–12–0 0–10–03–23–11–01–00–02–13–02–01–00–01–12–21–11–03–1nannan33818164
2019-204Barcelona4–11–02–2 4–15–01–02–11–02–02–15–21–25–20–01–04–05–25–12–1nannan2382576
2019-205Celta Vigo6–01–01–12–2 0–01–10–10–21–02–32–21–11–11–30–12–11–00–00–1nannan173871615
2019-206Eibar0–22–22–00–32–0 1–20–13–00–03–01–20–21–10–41–23–21–03–12–1nannan143811918
2019-207Espanyol2–01–11–12–20–00–2 1–10–30–11–31–02–42–20–11–30–21–20–20–1nannan203851023
2019-208Getafe1–11–10–20–20–01–10–0 3–12–04–04–20–01–00–32–10–33–02–01–3nannan838141212
2019-209Granada3–04–01–12–00–01–22–12–1 1–01–21–01–01–01–21–20–12–22–10–1nannan73816814
2019-2010Leganés1–11–10–11–23–21–22–00–30–0 1–21–00–10–02–22–10–31–01–20–3nannan183881218

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
);