Description

Here we have folders with country names on them- representing each country that participated in the 2018 FIFA WC
Each folder contains:

1. TeamLineup: Lineup of the particular team under consideration
2. OppLineup: Opposition Lineup
Lineup-attributes explained

3. MatchEvents:Home and away events happened in the game
Match_Events-attributes explained

4. MatchesPlayed:A file containing information on all the different matches the country played in the tournament
Matches_Played-attributes explained

~please do upvote if you download it or find it useful.

Tables

Belgium Matches Player

@kaggle.blessontomjoseph_fifa_world_cup_2018_complete_teamwise_data.belgium_matches_player

16.04 KB
7 rows
22 columns


CREATE TABLE belgium_matches_player (
  "match_id" BIGINT,
  "match_date" TIMESTAMP,
  "kick_off" VARCHAR,
  "competition" VARCHAR,
  "season" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "match_status" VARCHAR,
  "match_status_360" VARCHAR,
  "last_updated" TIMESTAMP,
  "last_updated_360" TIMESTAMP,
  "match_week" BIGINT,
  "competition_stage" VARCHAR,
  "stadium" VARCHAR,
  "referee" VARCHAR,
  "home_managers" VARCHAR,
  "away_managers" VARCHAR,
  "data_version" VARCHAR,
  "shot_fidelity_version" VARCHAR,
  "xy_fidelity_version" VARCHAR
);