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)
- Awards
- Award Winners
- Bookings
- Confederations
- Goals
- Groups
- Group Standings
- Host Countries
- Managers
- Manager Appearances
- Manager Appointments
- Matches
- Penalty Kicks
- Players
- Player Appearances
- Qualified Teams
- Referees
- Referee Appearances
- Referee Appointments
- Squads
- Stadiums
- Substitutions
- Teams
- Team Appearances
- Tournaments
- Tournament Stages
- Tournament Standings
Squads
@kaggle.joshfjelstul_world_cup_database.squads
- 234.31 KB
- 10142 rows
- 12 columns
key_idKey Id | tournament_idTournament Id | tournament_nameTournament Name | team_idTeam Id | team_nameTeam Name | team_codeTeam Code | player_idPlayer Id | family_nameFamily Name | given_nameGiven Name | shirt_numberShirt Number | position_namePosition Name | position_codePosition Code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-01578 | Bossio | Ángel | goal keeper | GK | |
| 2 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-02109 | Botasso | Juan | goal keeper | GK | |
| 3 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-06974 | Cherro | Roberto | forward | FW | |
| 4 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-07975 | Chividini | Alberto | defender | DF | |
| 5 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-06464 | Della Torre | José | defender | DF | |
| 6 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-07083 | Demaría | Attilio | forward | FW | |
| 7 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-00754 | Evaristo | Juan | midfielder | MF | |
| 8 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-06416 | Evaristo | Mario | forward | FW | |
| 9 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-05678 | Ferreira | Manuel | forward | FW | |
| 10 | WC-1930 | 1930 FIFA World Cup | T-03 | Argentina | ARG | P-03789 | Monti | Luis | midfielder | MF |
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
);