Football Data From Transfermarkt
Football (Soccer) data scraped from Transfermarkt website
@kaggle.davidcariboo_player_scores
Table List
- 10 tables(163.99 MB)
Game Lineups
@kaggle.davidcariboo_player_scores.game_lineups
- 85.86 MB
- 2191911 rows
- 10 columns
game_lineups_idGame Lineups Id | dateDate | game_idGame Id | player_idPlayer Id | club_idClub Id | player_namePlayer Name | typeType | positionPosition | numberNumber | team_captainTeam Captain |
|---|---|---|---|---|---|---|---|---|---|
| b2dbe01c3656b06c8e23e9de714e26bb | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 1443 | 610 | Christian Poulsen | substitutes | Defensive Midfield | 5 | |
| b50a3ec6d52fd1490aab42042ac4f738 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 5017 | 610 | Niklas Moisander | starting_lineup | Centre-Back | 4 | |
| 7d890e6d0ff8af84b065839966a0ec81 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 9602 | 1090 | Maarten Martens | substitutes | Left Winger | 11 | |
| 8c355268678b9bbc7084221b1f0fde36 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 12282 | 610 | Daley Blind | starting_lineup | Left-Back | 17 | |
| 76193074d549e5fdce4cdcbba0d66247 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 25427 | 1090 | Roy Beerens | starting_lineup | Right Winger | 23 | |
| e5684d3b01123e27e738a6c7ed1c24cc | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 28815 | 1090 | Jan Wuytens | starting_lineup | Centre-Back | 29 | |
| d196e3ec2f03110a523b6eaa65027f07 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 30290 | 610 | Kenneth Vermeer | starting_lineup | Goalkeeper | 1 | |
| e9e1212e3ba0dabdf39f45ce631799f7 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 34784 | 610 | Lasse Schöne | starting_lineup | Defensive Midfield | 20 | |
| 53ca254113ffc1b2f4533b0e334c9a15 | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 36391 | 1090 | Viktor Elm | starting_lineup | Defensive Midfield | 12 | |
| 03fe553a31b7cc907330b989c060b5cc | Sat Jul 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2317258 | 42266 | 1090 | Yves De Winter | substitutes | Goalkeeper | 16 |
CREATE TABLE game_lineups (
"game_lineups_id" VARCHAR,
"date" TIMESTAMP,
"game_id" BIGINT,
"player_id" BIGINT,
"club_id" BIGINT,
"player_name" VARCHAR,
"type" VARCHAR,
"position" VARCHAR,
"number" VARCHAR,
"team_captain" BIGINT
);