European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Corner Detail

@kaggle.jiezi2004_soccer.corner_detail

1.14 MB
87839 rows
20 columns

elapsed Elapsed	event_incident_typefk Event Incident Typefk	id Id	match_id Match Id	n N	player1 Player1	sortorder Sortorder	stats Stats	subtype Subtype	team Team	type Type
19	329	378960	1729	280	38807		nan	cross	10261	corner
22	330	378992	1729	263	40565		nan	short	10261	corner
22	329	378996	1729	293	38807	4	nan	cross	10261	corner
48	329	379352	1729	300	24154	2	nan	cross	10260	corner
51	329	379366	1729	301	38807		nan	cross	10261	corner
58	329	379403	1729	307	24148	1	nan	cross	10260	corner
59	330	379411	1729	309	24148	2	nan	short	10260	corner
62	329	379420	1729	317	40565	2	nan	cross	10261	corner
66	329	379429	1729	322	38807	1	nan	cross	10261	corner
67	329	379435	1729	326	24148	1	nan	cross	10260	corner


CREATE TABLE corner_detail (
  "coordinates" VARCHAR,
  "corner" VARCHAR,
  "corners" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "id" BIGINT,
  "match_id" BIGINT,
  "n" BIGINT,
  "player1" DOUBLE,
  "pos_x" DOUBLE,
  "pos_y" DOUBLE,
  "sortorder" BIGINT,
  "spectators" DOUBLE,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR
);