European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Foulcommit Detail

@kaggle.jiezi2004_soccer.foulcommit_detail

3.07 MB
219234 rows
23 columns

card_type Card Type	elapsed Elapsed	event_incident_typefk Event Incident Typefk	id Id	match_id Match Id	n N	player1 Player1	player2 Player2	sortorder Sortorder	stats Stats	subtype Subtype	team Team	type Type	venue Venue
nan	1	37	378824	1729	267	25518.0	32569	1	nan	nan	10261	foulcommit	nan
nan	2	37	378826	1729	277	30929.0	24157		nan	nan	10261	foulcommit	nan
nan	3	37	378830	1729	254	29581.0	24148	1	nan	nan	10261	foulcommit	nan
nan	5	37	378841	1729	256	30373.0	40565		nan	nan	10260	foulcommit	nan
nan	10	320	378894	1729	275	29581.0	30829		nan	pushing	10261	foulcommit	nan
nan	13	37	378913	1729	261	24157.0	25518		nan	nan	10260	foulcommit	nan
nan	19	37	378974	1729	260	24228.0	30362	6	nan	nan	10261	foulcommit	nan
nan	27	37	379035	1729	268	24157.0	30360		nan	nan	10260	foulcommit	nan
nan	27	37	379044	1729	282	24154.0	38807	2	nan	nan	10260	foulcommit	nan
nan	33	18	379100	1729	283	34574.0	32569	1	nan	shirt_pull	10261	foulcommit	nan


CREATE TABLE foulcommit_detail (
  "card_type" VARCHAR,
  "coordinates" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "foulcommit" VARCHAR,
  "foulscommitted" VARCHAR,
  "id" BIGINT,
  "injury_time" DOUBLE,
  "match_id" BIGINT,
  "n" BIGINT,
  "player1" VARCHAR,
  "player2" DOUBLE,
  "pos_x" DOUBLE,
  "pos_y" DOUBLE,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR,
  "venue" VARCHAR
);