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

Game Events

@kaggle.davidcariboo_player_scores.game_events

40.17 MB
1012265 rows
10 columns

game_event_id Game Event Id	date Date	game_id Game Id	minute Minute	type Type	club_id Club Id	player_id Player Id	description Description	player_in_id Player In Id	player_assist_id Player Assist Id
2f41da30c471492e7d4a984951671677	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	77	Cards	610	4425	1. Yellow card , Mass confrontation
a72f7186d132775f234d3e2f7bc0ed5b	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	77	Cards	383	33210	1. Yellow card , Mass confrontation
b2d721eaed4692a5c59a92323689ef18	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	3	Goals	383	36500	, Header, 1. Tournament Goal Assist: , Corner, 1. Tournament Assist		56416
aef768899cedac0c9a650980219075a2	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	53	Goals	383	36500	, Right-footed shot, 2. Tournament Goal Assist: , Pass, 1. Tournament Assist		146258
5d6d9533023057b6619ecd145a038bbe	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	74	Substitutions	383	36500	, Not reported	49499
eef9c46dd75c3aa4c6a503225427446e	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	11	Goals	383	38497	, Right-footed shot, 1. Tournament Goal Assist: , Goal-kick, 1. Tournament Assist		33210
5d5aef7dedcd5dc9d35dea9438ee35e0	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	90	Cards	610	42710	1. Yellow card
7717860e3b0376b86f445f4749fa2ce5	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	44	Goals	610	42710	, Header, 1. Tournament Goal Assist: , Corner, 1. Tournament Assist		4425
02c708273f4fa2003873ef5908e4e3a6	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	79	Cards	610	45509	1. Yellow card
d1be2ce4bd5f0ca091c1b15a8569301c	Sun Aug 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2211607	90	Goals	383	49499	, Right-footed shot, 1. Tournament Goal Assist: , Pass, 1. Tournament Assist		167850


CREATE TABLE game_events (
  "game_event_id" VARCHAR,
  "date" TIMESTAMP,
  "game_id" BIGINT,
  "minute" BIGINT,
  "type" VARCHAR,
  "club_id" BIGINT,
  "player_id" BIGINT,
  "description" VARCHAR,
  "player_in_id" DOUBLE,
  "player_assist_id" DOUBLE
);