European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Possession Detail

@kaggle.jiezi2004_soccer.possession_detail

510.92 KB
34815 rows
21 columns

awaypos Awaypos	card_type Card Type	comment Comment	elapsed Elapsed	elapsed_plus Elapsed Plus	event_incident_typefk Event Incident Typefk	goal_type Goal Type	homepos Homepos	id Id	match_id Match Id	n N	sortorder Sortorder	subtype Subtype	type Type
44	nan	56	25		352	nan	56	379029	1729	68	1	possession	special
46	nan	54	45	1	352	nan	54	379251	1729	117	4	possession	special
46	nan	54	70		352	nan	54	379443	1729	190		possession	special
45	nan	55	90	5	352	nan	55	379575	1729	252	1	possession	special
35	nan	65	27		352	nan	65	375608	1730	67		possession	special
39	nan	61	45	2	352	nan	61	375663	1730	114	1	possession	special
35	nan	65	74		352	nan	65	375787	1730	177	3	possession	special
34	nan	66	90	3	352	nan	66	375909	1730	199	2	possession	special
55	nan	45	25		352	nan	45	377876	1731	85		possession	special
57	nan	43	45	1	352	nan	43	377944	1731	144	1	possession	special


CREATE TABLE possession_detail (
  "awaypos" DOUBLE,
  "card_type" VARCHAR,
  "comment" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "goal_type" VARCHAR,
  "homepos" DOUBLE,
  "id" BIGINT,
  "injury_time" DOUBLE,
  "match_id" BIGINT,
  "n" BIGINT,
  "pos_x" VARCHAR,
  "pos_y" VARCHAR,
  "possession" VARCHAR,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "type" VARCHAR,
  "value" VARCHAR
);