European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Card Detail

@kaggle.jiezi2004_soccer.card_detail

957.28 KB
62114 rows
22 columns

card_type Card Type	comment Comment	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
y	y	78	73	nan	379481	1729	342	24157.0	1	nan	serious_fouls	10260	card
y	y	82	73	nan	379503	1729	346	30362.0	1	nan	serious_fouls	10260	card
y	y	90	70	nan	379547	1729	353	30829.0	1	nan	nan	10260	card
y	y	56	73	nan	377978	1731	327	37442.0	5	nan	serious_fouls	8650	card
y	y	90	25	nan	378060	1731	353	46621.0	3	nan	stall_time	8650	card
y	y	39	73	nan	376643	1732	278	24223.0	1	nan	serious_fouls	8654	card
y	y	49	77	nan	376951	1732	298	37277.0	1	nan	shirt_pull	8654	card
y	y	68	70	nan	377290	1732	323	97988.0	2	nan	nan	8528	card
y	y	34	73	nan	378719	1733	233	23939.0		nan	serious_fouls	8456	card
y	y	45	73	nan	376743	1734	271	24136.0	1	nan	serious_fouls	8655	card


CREATE TABLE card_detail (
  "card" VARCHAR,
  "card_type" VARCHAR,
  "comment" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "goal_type" VARCHAR,
  "id" BIGINT,
  "match_id" BIGINT,
  "n" BIGINT,
  "player1" VARCHAR,
  "pos_x" VARCHAR,
  "pos_y" VARCHAR,
  "rcards" VARCHAR,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR,
  "ycards" VARCHAR
);