European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Cross Detail

@kaggle.jiezi2004_soccer.cross_detail

3.23 MB
284775 rows
23 columns

elapsed Elapsed	event_incident_typefk Event Incident Typefk	goal_type Goal Type	id Id	match_id Match Id	n N	player1 Player1	sortorder Sortorder	stats Stats	subtype Subtype	team Team	type Type
7	7	nan	378863	1729	265	30829	1	nan	cross	10260	cross
14	7	nan	378921	1729	255	24148		nan	cross	10260	cross
19	329	nan	378960	1729	280	38807		nan	cross	10261	corner
19	7	nan	378970	1729	292	30929	5	nan	cross	10261	cross
20	7	nan	378978	1729	259	24148		nan	cross	10260	cross
22	7	nan	378993	1729	262	38807	1	nan	cross	10261	cross
22	329	nan	378996	1729	293	38807	4	nan	cross	10261	corner
24	7	nan	379012	1729	273	24154		nan	cross	10260	cross
24	7	nan	379018	1729	266	24154	3	nan	cross	10260	cross
28	7	nan	379068	1729	288	38807	2	nan	cross	10261	cross


CREATE TABLE cross_detail (
  "coordinates" VARCHAR,
  "corners" VARCHAR,
  "cross" VARCHAR,
  "crosses" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "goal_type" VARCHAR,
  "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,
  "throwin" VARCHAR,
  "type" VARCHAR,
  "value" VARCHAR
);