Name: Caribbean Cup Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Caribbean Cup Data

The Caribbean Cup

🌴 The Caribbean Cup was a championship tournament for national association football teams that are members of the Caribbean Football Union (CFU). The first edition, established by Shell and run by former bowler Fred Rumsey, was contested in 1989 in the island of Barbados. The Caribbean Cup served as qualification for the CONCACAF Gold Cup.

⚽️ Editions Data :

Year - Championship Year
Host - Country where the competition happened
Co-Host - Country where the competition happened (Some countries had 2 hosts)
Winner - Winner of the Competition
Runner-Up - 2nd Place of the Competition
3rd Place - 3rd Place of the Competition
Co-3rd Place - 3rd Place of the Competition (The 1999 edition had 2 third place teams)
4th Place - 4th Place of the Competition

⚽️ Awards Data :

Year - Championship Year
Most Valuable player - MVP of the Edition
MVP Country - Country of the MVP
Top Goalscorer (Finals only) - The top Goalscorer of the finals
Top Goalscorer Goals - Number of goals scored by the top goalscorer
Best goalkeeper - The best goalkeeper of the championship
Fair play award - Team that recieved the Fair Play Award

Tables

Awards

@kaggle.victorcabral_caribbean_cup_data.awards

6.51 kB
18 rows
7 columns

CREATE TABLE awards (
  "year" BIGINT,
  "most_valuable_player" VARCHAR,
  "mvp_country" VARCHAR,
  "top_goalscorer_finals_only" VARCHAR  -- Top Goalscorer (Finals Only),
  "top_goalscorer_goals" DOUBLE,
  "best_goalkeeper" VARCHAR,
  "fair_play_award" VARCHAR
);

Editions

@kaggle.victorcabral_caribbean_cup_data.editions

6.73 kB
19 rows
8 columns

CREATE TABLE editions (
  "year" BIGINT,
  "host" VARCHAR,
  "co_host" VARCHAR,
  "winner" VARCHAR,
  "runner_up" VARCHAR,
  "n_3rd_place" VARCHAR  -- 3rd Place,
  "co_3rd_place" VARCHAR,
  "n_4th_place" VARCHAR  -- 4th Place
);