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
Data on teams, players, managers, refs, matches, goals, cards, subs, and more!
@kaggle.joshfjelstul_world_cup_database
CREATE TABLE awards (
"key_id" BIGINT,
"award_id" VARCHAR,
"award_name" VARCHAR,
"award_description" VARCHAR,
"year_introduced" BIGINT
);
CREATE TABLE award_winners (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"award_id" VARCHAR,
"award_name" VARCHAR,
"shared" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR
);
CREATE TABLE bookings (
"key_id" BIGINT,
"booking_id" VARCHAR,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"minute_label" VARCHAR,
"minute_regulation" BIGINT,
"minute_stoppage" BIGINT,
"match_period" VARCHAR,
"yellow_card" BIGINT,
"red_card" BIGINT,
"second_yellow_card" BIGINT,
"sending_off" BIGINT
);
CREATE TABLE confederations (
"key_id" BIGINT,
"confederation_id" VARCHAR,
"confederation_name" VARCHAR,
"confederation_code" VARCHAR,
"confederation_wikipedia_link" VARCHAR
);
CREATE TABLE goals (
"key_id" BIGINT,
"goal_id" VARCHAR,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"player_team_id" VARCHAR,
"player_team_name" VARCHAR,
"player_team_code" VARCHAR,
"minute_label" VARCHAR,
"minute_regulation" BIGINT,
"minute_stoppage" BIGINT,
"match_period" VARCHAR,
"own_goal" BIGINT,
"penalty" BIGINT
);
CREATE TABLE groups (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"stage_number" BIGINT,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"count_teams" BIGINT
);
CREATE TABLE group_standings (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"stage_number" BIGINT,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"position" BIGINT,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"played" BIGINT,
"wins" BIGINT,
"draws" BIGINT,
"losses" BIGINT,
"goals_for" BIGINT,
"goals_against" BIGINT,
"goal_difference" BIGINT,
"points" BIGINT,
"advanced" BIGINT
);
CREATE TABLE host_countries (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"performance" VARCHAR
);
CREATE TABLE managers (
"key_id" BIGINT,
"manager_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR,
"manager_wikipedia_link" VARCHAR
);
CREATE TABLE manager_appearances (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"manager_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR
);
CREATE TABLE manager_appointments (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"manager_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR
);
CREATE TABLE matches (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"group_stage" BIGINT,
"knockout_stage" BIGINT,
"replayed" BIGINT,
"replay" BIGINT,
"match_date" TIMESTAMP,
"match_time" VARCHAR,
"stadium_id" VARCHAR,
"stadium_name" VARCHAR,
"city_name" VARCHAR,
"country_name" VARCHAR,
"home_team_id" VARCHAR,
"home_team_name" VARCHAR,
"home_team_code" VARCHAR,
"away_team_id" VARCHAR,
"away_team_name" VARCHAR,
"away_team_code" VARCHAR,
"score" VARCHAR,
"home_team_score" BIGINT,
"away_team_score" BIGINT,
"home_team_score_margin" BIGINT,
"away_team_score_margin" BIGINT,
"extra_time" BIGINT,
"penalty_shootout" BIGINT,
"score_penalties" VARCHAR,
"home_team_score_penalties" BIGINT,
"away_team_score_penalties" BIGINT,
"result" VARCHAR,
"home_team_win" BIGINT,
"away_team_win" BIGINT,
"draw" BIGINT
);
CREATE TABLE penalty_kicks (
"key_id" BIGINT,
"penalty_kick_id" VARCHAR,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"converted" BIGINT
);
CREATE TABLE players (
"key_id" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"birth_date" VARCHAR,
"goal_keeper" BIGINT,
"defender" BIGINT,
"midfielder" BIGINT,
"forward" BIGINT,
"count_tournaments" BIGINT,
"list_tournaments" VARCHAR,
"player_wikipedia_link" VARCHAR
);
CREATE TABLE player_appearances (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"position_name" VARCHAR,
"position_code" VARCHAR,
"starter" BIGINT,
"substitute" BIGINT,
"captain" BIGINT
);
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
);
CREATE TABLE referees (
"key_id" BIGINT,
"referee_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR,
"confederation_id" VARCHAR,
"confederation_name" VARCHAR,
"confederation_code" VARCHAR,
"referee_wikipedia_link" VARCHAR
);
CREATE TABLE referee_appearances (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"referee_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR,
"confederation_id" VARCHAR,
"confederation_name" VARCHAR,
"confederation_code" VARCHAR
);
CREATE TABLE referee_appointments (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"referee_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"country_name" VARCHAR,
"confederation_id" VARCHAR,
"confederation_name" VARCHAR,
"confederation_code" VARCHAR
);
CREATE TABLE squads (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"position_name" VARCHAR,
"position_code" VARCHAR
);
CREATE TABLE stadiums (
"key_id" BIGINT,
"stadium_id" VARCHAR,
"stadium_name" VARCHAR,
"city_name" VARCHAR,
"country_name" VARCHAR,
"stadium_capacity" BIGINT,
"stadium_wikipedia_link" VARCHAR,
"city_wikipedia_link" VARCHAR
);
CREATE TABLE substitutions (
"key_id" BIGINT,
"substitution_id" VARCHAR,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"match_date" TIMESTAMP,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"player_id" VARCHAR,
"family_name" VARCHAR,
"given_name" VARCHAR,
"shirt_number" BIGINT,
"minute_label" VARCHAR,
"minute_regulation" BIGINT,
"minute_stoppage" BIGINT,
"match_period" VARCHAR,
"going_off" BIGINT,
"coming_on" BIGINT
);
CREATE TABLE teams (
"key_id" BIGINT,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"federation_name" VARCHAR,
"region_name" VARCHAR,
"confederation_id" VARCHAR,
"confederation_name" VARCHAR,
"confederation_code" VARCHAR,
"team_wikipedia_link" VARCHAR,
"federation_wikipedia_link" VARCHAR
);
CREATE TABLE team_appearances (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"match_id" VARCHAR,
"match_name" VARCHAR,
"stage_name" VARCHAR,
"group_name" VARCHAR,
"group_stage" BIGINT,
"knockout_stage" BIGINT,
"replayed" BIGINT,
"replay" BIGINT,
"match_date" TIMESTAMP,
"match_time" VARCHAR,
"stadium_id" VARCHAR,
"stadium_name" VARCHAR,
"city_name" VARCHAR,
"country_name" VARCHAR,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR,
"opponent_id" VARCHAR,
"opponent_name" VARCHAR,
"opponent_code" VARCHAR,
"home_team" BIGINT,
"away_team" BIGINT,
"goals_for" BIGINT,
"goals_against" BIGINT,
"goal_differential" BIGINT,
"extra_time" BIGINT,
"penalty_shootout" BIGINT,
"penalties_for" BIGINT,
"penalties_against" BIGINT,
"result" VARCHAR,
"win" BIGINT,
"lose" BIGINT,
"draw" BIGINT
);
CREATE TABLE tournaments (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"year" BIGINT,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"host_country" VARCHAR,
"winner" VARCHAR,
"host_won" BIGINT,
"count_teams" BIGINT,
"group_stage" BIGINT,
"second_group_stage" BIGINT,
"final_round" BIGINT,
"round_of_16" BIGINT,
"quarter_finals" BIGINT,
"semi_finals" BIGINT,
"third_place_match" BIGINT,
"final" BIGINT
);
CREATE TABLE tournament_stages (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"stage_number" BIGINT,
"stage_name" VARCHAR,
"group_stage" BIGINT,
"knockout_stage" BIGINT,
"unbalanced_groups" BIGINT,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"count_matches" BIGINT,
"count_teams" BIGINT,
"count_scheduled" BIGINT,
"count_replays" BIGINT,
"count_playoffs" BIGINT,
"count_walkovers" BIGINT
);
CREATE TABLE tournament_standings (
"key_id" BIGINT,
"tournament_id" VARCHAR,
"tournament_name" VARCHAR,
"position" BIGINT,
"team_id" VARCHAR,
"team_name" VARCHAR,
"team_code" VARCHAR
);
Anyone who has the link will be able to view this.