Baselight
Sign In

European Club Football Dataset

Data for over 23k matches from various top football/soccer leagues in Europe

@kaggle.josephvm_european_club_football_dataset

Matches
@kaggle.josephvm_european_club_football_dataset.matches

  • 6.21 MB
  • 25724 rows
  • 210 columns
  • Only the first 100 columns are shown
id

Id

home

Home

away

Away

date

Date

year

Year

time_utc

Time (utc)

attendance

Attendance

venue

Venue

league

League

part_of_competition

Part Of Competition

game_status

Game Status

shootout

Shootout

home_score

Home Score

away_score

Away Score

home_possessionpct

Home PossessionPct

away_possessionpct

Away PossessionPct

home_shotssummary

Home ShotsSummary

away_shotssummary

Away ShotsSummary

home_foulscommitted

Home FoulsCommitted

away_foulscommitted

Away FoulsCommitted

home_yellowcards

Home YellowCards

away_yellowcards

Away YellowCards

home_redcards

Home RedCards

away_redcards

Away RedCards

home_offsides

Home Offsides

away_offsides

Away Offsides

home_woncorners

Home WonCorners

away_woncorners

Away WonCorners

home_saves

Home Saves

away_saves

Away Saves

home_goal_minutes

Home Goal Minutes

home_goal_scorers

Home Goal Scorers

away_goal_minutes

Away Goal Minutes

away_goal_scorers

Away Goal Scorers

home_starting_1_num

Home Starting 1 Num

home_starting_1

Home Starting 1

home_starting_2_num

Home Starting 2 Num

home_starting_2

Home Starting 2

home_starting_3_num

Home Starting 3 Num

home_starting_3

Home Starting 3

home_starting_4_num

Home Starting 4 Num

home_starting_4

Home Starting 4

home_starting_5_num

Home Starting 5 Num

home_starting_5

Home Starting 5

home_starting_6_num

Home Starting 6 Num

home_starting_6

Home Starting 6

home_starting_7_num

Home Starting 7 Num

home_starting_7

Home Starting 7

home_starting_8_num

Home Starting 8 Num

home_starting_8

Home Starting 8

home_starting_9_num

Home Starting 9 Num

home_starting_9

Home Starting 9

home_starting_10_num

Home Starting 10 Num

home_starting_10

Home Starting 10

home_starting_11_num

Home Starting 11 Num

home_starting_11

Home Starting 11

home_bench_1_num

Home Bench 1 Num

home_bench_1

Home Bench 1

home_bench_1_minute

Home Bench 1 Minute

home_bench_2_num

Home Bench 2 Num

home_bench_2

Home Bench 2

home_bench_2_minute

Home Bench 2 Minute

home_bench_3_num

Home Bench 3 Num

home_bench_3

Home Bench 3

home_bench_3_minute

Home Bench 3 Minute

home_bench_4_num

Home Bench 4 Num

home_bench_4

Home Bench 4

home_bench_4_minute

Home Bench 4 Minute

home_bench_5_num

Home Bench 5 Num

home_bench_5

Home Bench 5

home_bench_5_minute

Home Bench 5 Minute

away_starting_1_num

Away Starting 1 Num

away_starting_1

Away Starting 1

away_starting_2_num

Away Starting 2 Num

away_starting_2

Away Starting 2

away_starting_3_num

Away Starting 3 Num

away_starting_3

Away Starting 3

away_starting_4_num

Away Starting 4 Num

away_starting_4

Away Starting 4

away_starting_5_num

Away Starting 5 Num

away_starting_5

Away Starting 5

away_starting_6_num

Away Starting 6 Num

away_starting_6

Away Starting 6

away_starting_7_num

Away Starting 7 Num

away_starting_7

Away Starting 7

away_starting_8_num

Away Starting 8 Num

away_starting_8

Away Starting 8

away_starting_9_num

Away Starting 9 Num

away_starting_9

Away Starting 9

away_starting_10_num

Away Starting 10 Num

away_starting_10

Away Starting 10

away_starting_11_num

Away Starting 11 Num

away_starting_11

Away Starting 11

away_bench_1_num

Away Bench 1 Num

away_bench_1

Away Bench 1

away_bench_1_minute

Away Bench 1 Minute

away_bench_2_num

Away Bench 2 Num

away_bench_2

Away Bench 2

away_bench_2_minute

Away Bench 2 Minute

away_bench_3_num

Away Bench 3 Num

away_bench_3

Away Bench 3

away_bench_3_minute

Away Bench 3 Minute

away_bench_4_num

Away Bench 4 Num

away_bench_4

Away Bench 4

away_bench_4_minute

Away Bench 4 Minute

away_bench_5_num

Away Bench 5 Num

away_bench_5

Away Bench 5

away_bench_5_minute

Away Bench 5 Minute

home_bench_6_num

Home Bench 6 Num

home_bench_6

Home Bench 6

home_bench_6_minute

Home Bench 6 Minute

away_bench_6_num

Away Bench 6 Num

away_bench_6

Away Bench 6

away_bench_6_minute

Away Bench 6 Minute

away_starting_12_num

Away Starting 12 Num

away_starting_12

Away Starting 12

home_starting_12_num

Home Starting 12 Num

home_starting_12

Home Starting 12

home_formation

Home Formation

away_formation

Away Formation

home_bench_7_num

Home Bench 7 Num

home_bench_7

Home Bench 7

home_bench_7_minute

Home Bench 7 Minute

away_bench_7_num

Away Bench 7 Num

away_bench_7

Away Bench 7

away_bench_7_minute

Away Bench 7 Minute

home_bench_8_num

Home Bench 8 Num

home_bench_8

Home Bench 8

home_bench_8_minute

Home Bench 8 Minute

away_bench_8_num

Away Bench 8 Num

away_bench_8

Away Bench 8

away_bench_8_minute

Away Bench 8 Minute

away_bench_9_num

Away Bench 9 Num

away_bench_9

Away Bench 9

away_bench_9_minute

Away Bench 9 Minute

away_starting_13_num

Away Starting 13 Num

away_starting_13

Away Starting 13

home_bench_9_num

Home Bench 9 Num

home_bench_9

Home Bench 9

home_bench_9_minute

Home Bench 9 Minute

home_starting_13_num

Home Starting 13 Num

home_starting_13

Home Starting 13

home_starting_14_num

Home Starting 14 Num

home_starting_14

Home Starting 14

home_bench_10_num

Home Bench 10 Num

home_bench_10

Home Bench 10

home_bench_10_minute

Home Bench 10 Minute

home_bench_11_num

Home Bench 11 Num

home_bench_11

Home Bench 11

home_bench_11_minute

Home Bench 11 Minute

away_bench_10_num

Away Bench 10 Num

away_bench_10

Away Bench 10

away_bench_10_minute

Away Bench 10 Minute

away_starting_14_num

Away Starting 14 Num

away_starting_14

Away Starting 14

league_cc0a84

League

home_starting_15_num

Home Starting 15 Num

home_starting_15

Home Starting 15

away_starting_15_num

Away Starting 15 Num

away_starting_15

Away Starting 15

away_starting_16_num

Away Starting 16 Num

away_starting_16

Away Starting 16

away_starting_17_num

Away Starting 17 Num

away_starting_17

Away Starting 17

away_bench_11_num

Away Bench 11 Num

away_bench_11

Away Bench 11

away_bench_11_minute

Away Bench 11 Minute

away_bench_12_num

Away Bench 12 Num

away_bench_12

Away Bench 12

away_bench_12_minute

Away Bench 12 Minute

away_bench_13_num

Away Bench 13 Num

away_bench_13

Away Bench 13

away_bench_13_minute

Away Bench 13 Minute

home_starting_16_num

Home Starting 16 Num

home_starting_16

Home Starting 16

home_bench_12_num

Home Bench 12 Num

home_bench_12

Home Bench 12

home_bench_12_minute

Home Bench 12 Minute

home_starting_17_num

Home Starting 17 Num

home_starting_17

Home Starting 17

home_bench_13_num

Home Bench 13 Num

home_bench_13

Home Bench 13

home_bench_13_minute

Home Bench 13 Minute

away_starting_18_num

Away Starting 18 Num

away_starting_18

Away Starting 18

away_starting_19_num

Away Starting 19 Num

away_starting_19

Away Starting 19

away_bench_14_num

Away Bench 14 Num

away_bench_14

Away Bench 14

away_bench_14_minute

Away Bench 14 Minute

home_starting_18_num

Home Starting 18 Num

home_starting_18

Home Starting 18

home_starting_19_num

Home Starting 19 Num

home_starting_19

Home Starting 19

home_bench_14_num

Home Bench 14 Num

home_bench_14

Home Bench 14

home_bench_14_minute

Home Bench 14 Minute

away_starting_20_num

Away Starting 20 Num

away_starting_20

Away Starting 20

away_starting_21_num

Away Starting 21 Num

away_starting_21

Away Starting 21

home_starting_20_num

Home Starting 20 Num

home_starting_20

Home Starting 20

home_starting_21_num

Home Starting 21 Num

home_starting_21

Home Starting 21

away_starting_22_num

Away Starting 22 Num

away_starting_22

Away Starting 22

home_bench_15_num

Home Bench 15 Num

home_bench_15

Home Bench 15

home_bench_15_minute

Home Bench 15 Minute

18123Charlton AthleticEvertonSaturday, August 18200114:0020451The Valley, London, England2001-2002 Barclays Premier LeaguenaFT120%0%0 (0)0 (0)358'Jonatan Johansson64' PEN:77'Duncan Ferguson:David Weirnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18124Derby CountyBlackburn RoversSaturday, August 18200114:0028236Pride Park Stadium, England2001-2002 Barclays Premier LeaguenaFT210%0%0 (0)0 (0)145':65'Fabrizio Ravanelli:Malcolm Christie73'Nathan Blakenannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18125Leeds UnitedSouthamptonSaturday, August 18200114:0039715Elland Road, Leeds, England2001-2002 Barclays Premier LeaguenaFT20%0%0 (0)0 (0)12167':81'Lee Bowyer:Alan Smithnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18126Leicester CityBolton WanderersSaturday, August 18200114:0019987Filbert Street, England2001-2002 Barclays Premier LeaguenaFT50%0%0 (0)0 (0)43nannan15': 41':33':45': 83'Kevin Nolan:Kevin Nolan:Michael Ricketts:Per Frandsen:Per Frandsennannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18127LiverpoolWest Ham UnitedSaturday, August 18200114:0043935Anfield, Liverpool, England2001-2002 Barclays Premier LeaguenaFT210%0%0 (0)0 (0)1518': 77'Michael Owen:Michael Owen30' PENPaolo Di Canionannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18128MiddlesbroughArsenalSaturday, August 18200114:0031557The Riverside Stadium, England2001-2002 Barclays Premier LeaguenaFT40%0%0 (0)0 (0)1311nannan43':87' PEN:88': 90'Thierry Henry:Robert Pires:Dennis Bergkamp:Dennis Bergkampnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18129SunderlandIpswich TownSaturday, August 18200114:0047370Stadium of Light, Sunderland, England2001-2002 Barclays Premier LeaguenaFT10%0%0 (0)0 (0)1138' PENKevin Phillipsnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18130Tottenham HotspurAston VillaSaturday, August 18200114:0036059White Hart Lane, England2001-2002 Barclays Premier LeaguenaFT0%0%0 (0)0 (0)32nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18199ChelseaNewcastle UnitedSunday, August 19200113:0040124Stamford Bridge, London, England2001-2002 Barclays Premier LeaguenaFT110%0%0 (0)0 (0)348'Boudewijn Zenden77'Clarence Acunanannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan
18200Manchester UnitedFulhamSunday, August 19200115:0067534Old Trafford, Manchester, England2001-2002 Barclays Premier LeaguenaFT320%0%0 (0)0 (0)135':51': 53'David Beckham:Ruud van Nistelrooy:Ruud van Nistelrooy4': 48'Louis Saha:Louis Sahanannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan

CREATE TABLE matches (
  "id" BIGINT,
  "home" VARCHAR,
  "away" VARCHAR,
  "date" VARCHAR,
  "year" BIGINT,
  "time_utc" VARCHAR,
  "attendance" DOUBLE,
  "venue" VARCHAR,
  "league" VARCHAR,
  "part_of_competition" VARCHAR,
  "game_status" VARCHAR,
  "shootout" BOOLEAN,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "home_possessionpct" VARCHAR,
  "away_possessionpct" VARCHAR,
  "home_shotssummary" VARCHAR,
  "away_shotssummary" VARCHAR,
  "home_foulscommitted" DOUBLE,
  "away_foulscommitted" DOUBLE,
  "home_yellowcards" DOUBLE,
  "away_yellowcards" DOUBLE,
  "home_redcards" DOUBLE,
  "away_redcards" DOUBLE,
  "home_offsides" DOUBLE,
  "away_offsides" DOUBLE,
  "home_woncorners" DOUBLE,
  "away_woncorners" DOUBLE,
  "home_saves" DOUBLE,
  "away_saves" DOUBLE,
  "home_goal_minutes" VARCHAR,
  "home_goal_scorers" VARCHAR,
  "away_goal_minutes" VARCHAR,
  "away_goal_scorers" VARCHAR,
  "home_starting_1_num" VARCHAR,
  "home_starting_1" VARCHAR,
  "home_starting_2_num" VARCHAR,
  "home_starting_2" VARCHAR,
  "home_starting_3_num" VARCHAR,
  "home_starting_3" VARCHAR,
  "home_starting_4_num" VARCHAR,
  "home_starting_4" VARCHAR,
  "home_starting_5_num" VARCHAR,
  "home_starting_5" VARCHAR,
  "home_starting_6_num" VARCHAR,
  "home_starting_6" VARCHAR,
  "home_starting_7_num" VARCHAR,
  "home_starting_7" VARCHAR,
  "home_starting_8_num" VARCHAR,
  "home_starting_8" VARCHAR,
  "home_starting_9_num" VARCHAR,
  "home_starting_9" VARCHAR,
  "home_starting_10_num" VARCHAR,
  "home_starting_10" VARCHAR,
  "home_starting_11_num" VARCHAR,
  "home_starting_11" VARCHAR,
  "home_bench_1_num" VARCHAR,
  "home_bench_1" VARCHAR,
  "home_bench_1_minute" VARCHAR,
  "home_bench_2_num" VARCHAR,
  "home_bench_2" VARCHAR,
  "home_bench_2_minute" VARCHAR,
  "home_bench_3_num" VARCHAR,
  "home_bench_3" VARCHAR,
  "home_bench_3_minute" VARCHAR,
  "home_bench_4_num" VARCHAR,
  "home_bench_4" VARCHAR,
  "home_bench_4_minute" VARCHAR,
  "home_bench_5_num" VARCHAR,
  "home_bench_5" VARCHAR,
  "home_bench_5_minute" VARCHAR,
  "away_starting_1_num" VARCHAR,
  "away_starting_1" VARCHAR,
  "away_starting_2_num" VARCHAR,
  "away_starting_2" VARCHAR,
  "away_starting_3_num" VARCHAR,
  "away_starting_3" VARCHAR,
  "away_starting_4_num" VARCHAR,
  "away_starting_4" VARCHAR,
  "away_starting_5_num" VARCHAR,
  "away_starting_5" VARCHAR,
  "away_starting_6_num" VARCHAR,
  "away_starting_6" VARCHAR,
  "away_starting_7_num" VARCHAR,
  "away_starting_7" VARCHAR,
  "away_starting_8_num" VARCHAR,
  "away_starting_8" VARCHAR,
  "away_starting_9_num" VARCHAR,
  "away_starting_9" VARCHAR,
  "away_starting_10_num" VARCHAR,
  "away_starting_10" VARCHAR,
  "away_starting_11_num" VARCHAR,
  "away_starting_11" VARCHAR,
  "away_bench_1_num" VARCHAR,
  "away_bench_1" VARCHAR,
  "away_bench_1_minute" VARCHAR,
  "away_bench_2_num" VARCHAR,
  "away_bench_2" VARCHAR,
  "away_bench_2_minute" VARCHAR,
  "away_bench_3_num" VARCHAR
);

Share link

Anyone who has the link will be able to view this.