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
Table List
- 27 tables(1.88 MB)
Player Appearances
@kaggle.joshfjelstul_world_cup_database.player_appearances
- 334.48 KB
- 18623 rows
- 22 columns
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
);