Baselight

A Comprehensive Database On The FIFA World Cup

Data on teams, players, managers, refs, matches, goals, cards, subs, and more!

@kaggle.joshfjelstul_world_cup_database

Qualified Teams
@kaggle.joshfjelstul_world_cup_database.qualified_teams

  • 11.72 KB
  • 457 rows
  • 8 columns
key_id

Key Id

tournament_id

Tournament Id

tournament_name

Tournament Name

team_id

Team Id

team_name

Team Name

team_code

Team Code

count_matches

Count Matches

performance

Performance

1WC-19301930 FIFA World CupT-03ArgentinaARG5final
2WC-19301930 FIFA World CupT-06BelgiumBEL2group stage
3WC-19301930 FIFA World CupT-07BoliviaBOL2group stage
4WC-19301930 FIFA World CupT-09BrazilBRA2group stage
5WC-19301930 FIFA World CupT-13ChileCHL3group stage
6WC-19301930 FIFA World CupT-28FranceFRA3group stage
7WC-19301930 FIFA World CupT-44MexicoMEX3group stage
8WC-19301930 FIFA World CupT-53ParaguayPRY2group stage
9WC-19301930 FIFA World CupT-54PeruPER2group stage
10WC-19301930 FIFA World CupT-58RomaniaROU2group stage

CREATE TABLE qualified_teams (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "count_matches" BIGINT,
  "performance" VARCHAR
);

Share link

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