Football Data From Transfermarkt

Football (Soccer) data scraped from Transfermarkt website

@kaggle.davidcariboo_player_scores

Table List

10 tables(163.99 MB)

Clubs

Games

Players

Games

@kaggle.davidcariboo_player_scores.games

3.54 MB
72591 rows
23 columns

game_id Game Id	competition_id Competition Id	season Season	round Round	date Date	home_club_id Home Club Id	away_club_id Away Club Id	home_club_goals Home Club Goals	away_club_goals Away Club Goals	home_club_position Home Club Position	away_club_position Away Club Position	home_club_manager_name Home Club Manager Name	away_club_manager_name Away Club Manager Name	stadium Stadium	attendance Attendance	referee Referee	url Url	home_club_formation Home Club Formation	away_club_formation Away Club Formation	home_club_name Home Club Name	away_club_name Away Club Name	aggregate Aggregate	competition_type Competition Type
2321027	L1	2013	1. Matchday	Sun Aug 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	33	41	3	3	8	9	Jens Keller	Thorsten Fink	Veltins-Arena	61973	Manuel Gräfe	https://www.transfermarkt.co.uk/fc-schalke-04_hamburger-sv/index/spielbericht/2321027	4-2-3-1	4-2-3-1	FC Schalke 04	Hamburger SV	3:3	domestic_league
2321033	L1	2013	1. Matchday	Sat Aug 10 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	23	86		1	13	7	Torsten Lieberknecht	Robin Dutt	EINTRACHT-Stadion	23000	Deniz Aytekin	https://www.transfermarkt.co.uk/eintracht-braunschweig_sv-werder-bremen/index/spielbericht/2321033	4-3-2-1	4-3-1-2	Eintracht Braunschweig	Sportverein Werder Bremen von 1899	0:1	domestic_league
2321044	L1	2013	2. Matchday	Sun Aug 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16	23	2	1	1	15	Jürgen Klopp	Torsten Lieberknecht	SIGNAL IDUNA PARK	80200	Peter Sippel	https://www.transfermarkt.co.uk/borussia-dortmund_eintracht-braunschweig/index/spielbericht/2321044	4-2-3-1	4-3-2-1	Borussia Dortmund	Eintracht Braunschweig	2:1	domestic_league
2321060	L1	2013	3. Matchday	Sun Aug 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	23	24		2	18	11	Torsten Lieberknecht	Armin Veh	EINTRACHT-Stadion	23325	Wolfgang Stark	https://www.transfermarkt.co.uk/eintracht-braunschweig_eintracht-frankfurt/index/spielbericht/2321060	4-3-2-1	4-2-3-1	Eintracht Braunschweig	Eintracht Frankfurt Fußball AG	0:2	domestic_league
2321072	L1	2013	5. Matchday	Sat Sep 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16	41	6	2	1	15	Jürgen Klopp	Thorsten Fink	SIGNAL IDUNA PARK	80645	Tobias Welz	https://www.transfermarkt.co.uk/borussia-dortmund_hamburger-sv/index/spielbericht/2321072	4-2-3-1	3-5-2	Borussia Dortmund	Hamburger SV	6:2	domestic_league
2321079	L1	2013	5. Matchday	Sun Sep 15 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	23	4	1	1	18	16	Torsten Lieberknecht	Michael Wiesinger	EINTRACHT-Stadion	22570	Marco Fritz	https://www.transfermarkt.co.uk/eintracht-braunschweig_1-fc-nuremberg/index/spielbericht/2321079	4-4-2 double 6	4-2-3-1	Eintracht Braunschweig	1.FC Nuremberg	1:1	domestic_league
2321086	L1	2013	6. Matchday	Sat Sep 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	4	16	1	1	15	1	Michael Wiesinger	Jürgen Klopp	Max-Morlock-Stadion	50000	Knut Kircher	https://www.transfermarkt.co.uk/1-fc-nuremberg_borussia-dortmund/index/spielbericht/2321086	4-2-3-1	4-2-3-1	1.FC Nuremberg	Borussia Dortmund	1:1	domestic_league
2321152	L1	2013	11. Matchday	Sat Nov 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	44	33		2	7	6	Jos Luhukay	Jens Keller	Olympiastadion Berlin	69277	Günter Perl	https://www.transfermarkt.co.uk/hertha-bsc_fc-schalke-04/index/spielbericht/2321152	4-2-3-1	4-2-3-1	Hertha BSC	FC Schalke 04	0:2	domestic_league
2321205	L1	2013	17. Matchday	Sat Dec 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41	39	2	3	14	9	Bert van Marwijk	Thomas Tuchel	Volksparkstadion	50000	Bastian Dankert	https://www.transfermarkt.co.uk/hamburger-sv_1-fsv-mainz-05/index/spielbericht/2321205	4-2-3-1	4-4-2 Diamond	Hamburger SV	1. Fußball- und Sportverein Mainz 05	2:3	domestic_league
2321233	L1	2013	20. Matchday	Sat Feb 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	41	44		3	17	7	Bert van Marwijk	Jos Luhukay	Volksparkstadion	48593	Deniz Aytekin	https://www.transfermarkt.co.uk/hamburger-sv_hertha-bsc/index/spielbericht/2321233	4-2-3-1	4-1-4-1	Hamburger SV	Hertha BSC	0:3	domestic_league


CREATE TABLE games (
  "game_id" BIGINT,
  "competition_id" VARCHAR,
  "season" BIGINT,
  "round" VARCHAR,
  "date" TIMESTAMP,
  "home_club_id" DOUBLE,
  "away_club_id" DOUBLE,
  "home_club_goals" DOUBLE,
  "away_club_goals" DOUBLE,
  "home_club_position" DOUBLE,
  "away_club_position" DOUBLE,
  "home_club_manager_name" VARCHAR,
  "away_club_manager_name" VARCHAR,
  "stadium" VARCHAR,
  "attendance" DOUBLE,
  "referee" VARCHAR,
  "url" VARCHAR,
  "home_club_formation" VARCHAR,
  "away_club_formation" VARCHAR,
  "home_club_name" VARCHAR,
  "away_club_name" VARCHAR,
  "aggregate" VARCHAR,
  "competition_type" VARCHAR
);