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)
Bookings
@kaggle.joshfjelstul_world_cup_database.bookings
- 117.78 KB
- 2466 rows
- 26 columns
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
);