Dataset: World Cup

About this Dataset

World Cup

Data from all World Cup results (1930-2014), details for each match (Date, Stage, City, Ref, Home Team, Away Team, Goals, Goals at Half, etc), and details for events (goals, assists, etc) by athlete.

Recommended Analysis
Dig into attendance data...
How has attendance trended over time? (both average per game and total per year)
Do certain cities tend to draw bigger crowds?
Do certain teams see larger attendance?
Which teams have won the most games? How has number of wins by country trended over time?

Based on the Home Team and Away Team columns, does there seem to be a "home team advantage"?

Do any teams seem to be stronger in either the first half or the second half? (think about both offense and defense)

Which players had the most successful scoring careers? How about the longest careers?

Tables

Worldcupmatches

@kaggle.mysarahmadbhat_world_cup.worldcupmatches

67.23 KB
852 rows
20 columns


CREATE TABLE worldcupmatches (
  "year" BIGINT,
  "datetime" TIMESTAMP,
  "stage" VARCHAR,
  "stadium" VARCHAR,
  "city" VARCHAR,
  "home_team_name" VARCHAR,
  "home_team_goals" BIGINT,
  "away_team_goals" BIGINT,
  "away_team_name" VARCHAR,
  "win_conditions" VARCHAR,
  "attendance" DOUBLE,
  "half_time_home_goals" BIGINT,
  "half_time_away_goals" BIGINT,
  "referee" VARCHAR,
  "assistant_1" VARCHAR,
  "assistant_2" VARCHAR,
  "roundid" BIGINT,
  "matchid" BIGINT,
  "home_team_initials" VARCHAR,
  "away_team_initials" VARCHAR
);

Worldcupplayers

@kaggle.mysarahmadbhat_world_cup.worldcupplayers

244.27 KB
37784 rows
9 columns


CREATE TABLE worldcupplayers (
  "roundid" BIGINT,
  "matchid" BIGINT,
  "team_initials" VARCHAR,
  "coach_name" VARCHAR,
  "line_up" VARCHAR,
  "shirt_number" BIGINT,
  "player_name" VARCHAR,
  "position" VARCHAR,
  "event" VARCHAR
);

Worldcups Preview

@kaggle.mysarahmadbhat_world_cup.worldcups_preview

8.12 KB
20 rows
10 columns


CREATE TABLE worldcups_preview (
  "year" BIGINT,
  "country" VARCHAR,
  "winner" VARCHAR,
  "runners_up" VARCHAR,
  "third" VARCHAR,
  "fourth" VARCHAR,
  "goalsscored" BIGINT,
  "qualifiedteams" BIGINT,
  "matchesplayed" BIGINT,
  "attendance" VARCHAR
);