English Premier League Match Events And Results
2001-2002 season onwards
@kaggle.josephvm_english_premier_league_game_events_and_results
Matches
@kaggle.josephvm_english_premier_league_game_events_and_results.matches
- 1.7 MB
- 7979 rows
- 155 columns
- Only the first 100 columns are shown
idId | homeHome | awayAway | dateDate | yearYear | time_utcTime (utc) | attendanceAttendance | venueVenue | leagueLeague | part_of_competitionPart Of Competition | game_statusGame Status | shootoutShootout | home_scoreHome Score | away_scoreAway Score | home_possessionpctHome PossessionPct | away_possessionpctAway PossessionPct | home_shotssummaryHome ShotsSummary | away_shotssummaryAway ShotsSummary | home_foulscommittedHome FoulsCommitted | away_foulscommittedAway FoulsCommitted | home_yellowcardsHome YellowCards | away_yellowcardsAway YellowCards | home_redcardsHome RedCards | away_redcardsAway RedCards | home_offsidesHome Offsides | away_offsidesAway Offsides | home_woncornersHome WonCorners | away_woncornersAway WonCorners | home_savesHome Saves | away_savesAway Saves | home_goal_minutesHome Goal Minutes | home_goal_scorersHome Goal Scorers | away_goal_minutesAway Goal Minutes | away_goal_scorersAway Goal Scorers | home_starting_1_numHome Starting 1 Num | home_starting_1Home Starting 1 | home_starting_2_numHome Starting 2 Num | home_starting_2Home Starting 2 | home_starting_3_numHome Starting 3 Num | home_starting_3Home Starting 3 | home_starting_4_numHome Starting 4 Num | home_starting_4Home Starting 4 | home_starting_5_numHome Starting 5 Num | home_starting_5Home Starting 5 | home_starting_6_numHome Starting 6 Num | home_starting_6Home Starting 6 | home_starting_7_numHome Starting 7 Num | home_starting_7Home Starting 7 | home_starting_8_numHome Starting 8 Num | home_starting_8Home Starting 8 | home_starting_9_numHome Starting 9 Num | home_starting_9Home Starting 9 | home_starting_10_numHome Starting 10 Num | home_starting_10Home Starting 10 | home_starting_11_numHome Starting 11 Num | home_starting_11Home Starting 11 | home_bench_1_numHome Bench 1 Num | home_bench_1Home Bench 1 | home_bench_1_minuteHome Bench 1 Minute | home_bench_2_numHome Bench 2 Num | home_bench_2Home Bench 2 | home_bench_2_minuteHome Bench 2 Minute | home_bench_3_numHome Bench 3 Num | home_bench_3Home Bench 3 | home_bench_3_minuteHome Bench 3 Minute | home_bench_4_numHome Bench 4 Num | home_bench_4Home Bench 4 | home_bench_4_minuteHome Bench 4 Minute | home_bench_5_numHome Bench 5 Num | home_bench_5Home Bench 5 | home_bench_5_minuteHome Bench 5 Minute | away_starting_1_numAway Starting 1 Num | away_starting_1Away Starting 1 | away_starting_2_numAway Starting 2 Num | away_starting_2Away Starting 2 | away_starting_3_numAway Starting 3 Num | away_starting_3Away Starting 3 | away_starting_4_numAway Starting 4 Num | away_starting_4Away Starting 4 | away_starting_5_numAway Starting 5 Num | away_starting_5Away Starting 5 | away_starting_6_numAway Starting 6 Num | away_starting_6Away Starting 6 | away_starting_7_numAway Starting 7 Num | away_starting_7Away Starting 7 | away_starting_8_numAway Starting 8 Num | away_starting_8Away Starting 8 | away_starting_9_numAway Starting 9 Num | away_starting_9Away Starting 9 | away_starting_10_numAway Starting 10 Num | away_starting_10Away Starting 10 | away_starting_11_numAway Starting 11 Num | away_starting_11Away Starting 11 | away_bench_1_numAway Bench 1 Num | away_bench_1Away Bench 1 | away_bench_1_minuteAway Bench 1 Minute | away_bench_2_numAway Bench 2 Num | away_bench_2Away Bench 2 | away_bench_2_minuteAway Bench 2 Minute | away_bench_3_numAway Bench 3 Num | away_bench_3Away Bench 3 | away_bench_3_minuteAway Bench 3 Minute | away_bench_4_numAway Bench 4 Num | away_bench_4Away Bench 4 | away_bench_4_minuteAway Bench 4 Minute | away_bench_5_numAway Bench 5 Num | away_bench_5Away Bench 5 | away_bench_5_minuteAway Bench 5 Minute | home_bench_6_numHome Bench 6 Num | home_bench_6Home Bench 6 | home_bench_6_minuteHome Bench 6 Minute | away_bench_6_numAway Bench 6 Num | away_bench_6Away Bench 6 | away_bench_6_minuteAway Bench 6 Minute | away_starting_12_numAway Starting 12 Num | away_starting_12Away Starting 12 | home_starting_12_numHome Starting 12 Num | home_starting_12Home Starting 12 | home_formationHome Formation | away_formationAway Formation | home_bench_7_numHome Bench 7 Num | home_bench_7Home Bench 7 | home_bench_7_minuteHome Bench 7 Minute | away_bench_7_numAway Bench 7 Num | away_bench_7Away Bench 7 | away_bench_7_minuteAway Bench 7 Minute | home_bench_8_numHome Bench 8 Num | home_bench_8Home Bench 8 | home_bench_8_minuteHome Bench 8 Minute | away_bench_8_numAway Bench 8 Num | away_bench_8Away Bench 8 | away_bench_8_minuteAway Bench 8 Minute | away_bench_9_numAway Bench 9 Num | away_bench_9Away Bench 9 | away_bench_9_minuteAway Bench 9 Minute | away_starting_13_numAway Starting 13 Num | away_starting_13Away Starting 13 | home_bench_9_numHome Bench 9 Num | home_bench_9Home Bench 9 | home_bench_9_minuteHome Bench 9 Minute | home_starting_13_numHome Starting 13 Num | home_starting_13Home Starting 13 | home_starting_14_numHome Starting 14 Num | home_starting_14Home Starting 14 | home_bench_10_numHome Bench 10 Num | home_bench_10Home Bench 10 | home_bench_10_minuteHome Bench 10 Minute | home_bench_11_numHome Bench 11 Num | home_bench_11Home Bench 11 | home_bench_11_minuteHome Bench 11 Minute | away_bench_10_numAway Bench 10 Num | away_bench_10Away Bench 10 | away_bench_10_minuteAway Bench 10 Minute | away_starting_14_numAway Starting 14 Num | away_starting_14Away Starting 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18123 | Charlton Athletic | Everton | Saturday, August 18 | 2001 | 14:00 | 20451 | The Valley, London, England | 2001-2002 Barclays Premier League | na | FT | 1 | 2 | 0% | 0% | 0 (0) | 0 (0) | 3 | 58' | Jonatan Johansson | 64' PEN:77' | Duncan Ferguson:David Weir | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18124 | Derby County | Blackburn Rovers | Saturday, August 18 | 2001 | 14:00 | 28236 | Pride Park Stadium, England | 2001-2002 Barclays Premier League | na | FT | 2 | 1 | 0% | 0% | 0 (0) | 0 (0) | 1 | 45':65' | Fabrizio Ravanelli:Malcolm Christie | 73' | Nathan Blake | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18125 | Leeds United | Southampton | Saturday, August 18 | 2001 | 14:00 | 39715 | Elland Road, Leeds, England | 2001-2002 Barclays Premier League | na | FT | 2 | 0% | 0% | 0 (0) | 0 (0) | 1 | 2 | 1 | 67':81' | Lee Bowyer:Alan Smith | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18126 | Leicester City | Bolton Wanderers | Saturday, August 18 | 2001 | 14:00 | 19987 | Filbert Street, England | 2001-2002 Barclays Premier League | na | FT | 5 | 0% | 0% | 0 (0) | 0 (0) | 4 | 3 | nan | nan | 15': 41':33':45': 83' | Kevin Nolan:Kevin Nolan:Michael Ricketts:Per Frandsen:Per Frandsen | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18127 | Liverpool | West Ham United | Saturday, August 18 | 2001 | 14:00 | 43935 | Anfield, Liverpool, England | 2001-2002 Barclays Premier League | na | FT | 2 | 1 | 0% | 0% | 0 (0) | 0 (0) | 1 | 5 | 18': 77' | Michael Owen:Michael Owen | 30' PEN | Paolo Di Canio | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18128 | Middlesbrough | Arsenal | Saturday, August 18 | 2001 | 14:00 | 31557 | The Riverside Stadium, England | 2001-2002 Barclays Premier League | na | FT | 4 | 0% | 0% | 0 (0) | 0 (0) | 1 | 3 | 1 | 1 | nan | nan | 43':87' PEN:88': 90' | Thierry Henry:Robert Pires:Dennis Bergkamp:Dennis Bergkamp | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18129 | Sunderland | Ipswich Town | Saturday, August 18 | 2001 | 14:00 | 47370 | Stadium of Light, Sunderland, England | 2001-2002 Barclays Premier League | na | FT | 1 | 0% | 0% | 0 (0) | 0 (0) | 1 | 1 | 38' PEN | Kevin Phillips | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18130 | Tottenham Hotspur | Aston Villa | Saturday, August 18 | 2001 | 14:00 | 36059 | White Hart Lane, England | 2001-2002 Barclays Premier League | na | FT | 0% | 0% | 0 (0) | 0 (0) | 3 | 2 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18199 | Chelsea | Newcastle United | Sunday, August 19 | 2001 | 13:00 | 40124 | Stamford Bridge, London, England | 2001-2002 Barclays Premier League | na | FT | 1 | 1 | 0% | 0% | 0 (0) | 0 (0) | 3 | 4 | 8' | Boudewijn Zenden | 77' | Clarence Acuna | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18200 | Manchester United | Fulham | Sunday, August 19 | 2001 | 15:00 | 67534 | Old Trafford, Manchester, England | 2001-2002 Barclays Premier League | na | FT | 3 | 2 | 0% | 0% | 0 (0) | 0 (0) | 1 | 35':51': 53' | David Beckham:Ruud van Nistelrooy:Ruud van Nistelrooy | 4': 48' | Louis Saha:Louis Saha | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan |
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" DOUBLE,
"home_starting_1" VARCHAR,
"home_starting_2_num" DOUBLE,
"home_starting_2" VARCHAR,
"home_starting_3_num" DOUBLE,
"home_starting_3" VARCHAR,
"home_starting_4_num" DOUBLE,
"home_starting_4" VARCHAR,
"home_starting_5_num" DOUBLE,
"home_starting_5" VARCHAR,
"home_starting_6_num" DOUBLE,
"home_starting_6" VARCHAR,
"home_starting_7_num" DOUBLE,
"home_starting_7" VARCHAR,
"home_starting_8_num" DOUBLE,
"home_starting_8" VARCHAR,
"home_starting_9_num" DOUBLE,
"home_starting_9" VARCHAR,
"home_starting_10_num" DOUBLE,
"home_starting_10" VARCHAR,
"home_starting_11_num" DOUBLE,
"home_starting_11" VARCHAR,
"home_bench_1_num" DOUBLE,
"home_bench_1" VARCHAR,
"home_bench_1_minute" VARCHAR,
"home_bench_2_num" DOUBLE,
"home_bench_2" VARCHAR,
"home_bench_2_minute" VARCHAR,
"home_bench_3_num" DOUBLE,
"home_bench_3" VARCHAR,
"home_bench_3_minute" VARCHAR,
"home_bench_4_num" DOUBLE,
"home_bench_4" VARCHAR,
"home_bench_4_minute" VARCHAR,
"home_bench_5_num" DOUBLE,
"home_bench_5" VARCHAR,
"home_bench_5_minute" VARCHAR,
"away_starting_1_num" DOUBLE,
"away_starting_1" VARCHAR,
"away_starting_2_num" DOUBLE,
"away_starting_2" VARCHAR,
"away_starting_3_num" DOUBLE,
"away_starting_3" VARCHAR,
"away_starting_4_num" DOUBLE,
"away_starting_4" VARCHAR,
"away_starting_5_num" DOUBLE,
"away_starting_5" VARCHAR,
"away_starting_6_num" DOUBLE,
"away_starting_6" VARCHAR,
"away_starting_7_num" DOUBLE,
"away_starting_7" VARCHAR,
"away_starting_8_num" DOUBLE,
"away_starting_8" VARCHAR,
"away_starting_9_num" DOUBLE,
"away_starting_9" VARCHAR,
"away_starting_10_num" DOUBLE,
"away_starting_10" VARCHAR,
"away_starting_11_num" DOUBLE,
"away_starting_11" VARCHAR,
"away_bench_1_num" DOUBLE,
"away_bench_1" VARCHAR,
"away_bench_1_minute" VARCHAR,
"away_bench_2_num" DOUBLE,
"away_bench_2" VARCHAR,
"away_bench_2_minute" VARCHAR,
"away_bench_3_num" DOUBLE
);