Soccer Universe
Football Dataset: Insights, Structure, and Analysis Guide
@kaggle.willianoliveiragibin_soccer_universe
Games New
@kaggle.willianoliveiragibin_soccer_universe.games_new
- 6.32 MB
- 61538 rows
- 2 columns
game_id_competition_id_season_round_date_home_club_id__196af9e0Game Id,competition Id,season,round,date,home Club Id,away Club Id,home Club Goals,away Club Goals,home Club Position,away Club Position,home Club Manager Name,away Club Manager Name,stadium,attendance,referee,url,home Club Name,away Club Name,aggregate,competition Type | unnamed_1Unnamed: 1 |
|---|---|
| 2222539,L1,2012,1. Matchday,2012-08-25,60,39,1,1,11,10,Christian Streich,Thomas Tuchel,Dreisamstadion,22500,Deniz Aytekin,https://www.transfermarkt.co.uk/sc-freiburg_1-fsv-mainz-05/index/spielbericht/2222539,SC Freiburg,1.FSV Mainz 05,1:1,domestic_league | |
| 2222541,L1,2012,1. Matchday,2012-08-25,41,4,0,1,15,6,Thorsten Fink,Dieter Hecking,Volksparkstadion,50123,Marco Fritz,https://www.transfermarkt.co.uk/hamburger-sv_1-fc-nuremberg/index/spielbericht/2222541,null,null,0:1,domestic_league | |
| 2222542,L1,2012,1. Matchday,2012-08-25,24,15,2,1,5,12,Armin Veh,Sascha Lewandowski,Commerzbank Arena,27950,Thorsten Kinhöfer,https://www.transfermarkt.co.uk/eintracht-frankfurt_bayer-04-leverkusen/index/spielbericht/2222542,Eintracht Frankfurt,Bayer 04 Leverkusen,2:1,domestic_league | |
| 2222595,RU1,2012,3. Matchday,2012-08-05,2700,4128,1,0,3,12,Guus Hiddink,Rustem Khuzin,Dinamo,14000,Vladislav Bezborodov,https://www.transfermarkt.co.uk/anzhi-makhachkala-2022-_amkar-perm/index/spielbericht/2222595,null,null,1:0,domestic_league | |
| 2222636,RU1,2012,4. Matchday,2012-08-12,1083,2696,1,2,15,6,Miodrag Bozovic,Andrey Kobelev,Olimp-2,6800,Vitali Meshkov,https://www.transfermarkt.co.uk/fk-rostov_krylya-sovetov-samara/index/spielbericht/2222636,FK Rostov,Krylya Sovetov Samara,1:2,domestic_league | |
| 2222651,RU1,2012,11. Matchday,2012-10-06,12438,11126,0,2,16,15,Gadzhi Gadzhiev,Fedor Shcherbachenko,Zentralstadion Lokomotiv,3100,Sergey Karasev,https://www.transfermarkt.co.uk/volga-nizhniy-novgorod-2016-_mordovia-saransk-2020-/index/spielbericht/2222651,null,null,0:2,domestic_league | |
| 2222652,RU1,2012,11. Matchday,2012-10-07,121,2700,0,2,14,1,Dan Petrescu,Guus Hiddink,Arena Khimki,7712,Aleksandr Egorov,https://www.transfermarkt.co.uk/dinamo-moscow_anzhi-makhachkala-2022-/index/spielbericht/2222652,Dynamo Moscow,null,0:2,domestic_league | |
| 2222675,RU1,2012,12. Matchday,2012-10-21,2410,2698,2,0,2,8,Leonid Slutski,Kurban Berdyev,Arena Khimki,8764,Aleksandr Egorov,https://www.transfermarkt.co.uk/cska-moscow_rubin-kazan/index/spielbericht/2222675,CSKA Moscow,null,2:0,domestic_league | |
| 2222676,RU1,2012,8. Matchday,2012-09-16,2700,16704,5,2,3,13,Guus Hiddink,Slavoljub Muslin,Dinamo,15000,Vitali Meshkov,https://www.transfermarkt.co.uk/anzhi-makhachkala-2022-_fk-krasnodar/index/spielbericht/2222676,null,FK Krasnodar,5:2,domestic_league | |
| 2222695,RU1,2012,14. Matchday,2012-11-02,964,1083,2,1,3,15,Luciano Spalletti,Miodrag Bozovic,Petrovsky,20000,Maksim Layushkin,https://www.transfermarkt.co.uk/zenit-st-petersburg_fk-rostov/index/spielbericht/2222695,Zenit St. Petersburg,FK Rostov,2:1,domestic_league |
CREATE TABLE games_new (
"game_id_competition_id_season_round_date_home_club_id__196af9e0" VARCHAR,
"unnamed_1" VARCHAR
);