European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Shoton Detail

@kaggle.jiezi2004_soccer.shoton_detail

1.37 MB
93755 rows
21 columns

card_type Card Type	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
nan	3	61	nan	378828	1729	253	24154		nan	blocked_shot	10260	shoton
nan	7	154	nan	378866	1729	258	24157	2	nan	header	10260	shoton
nan	14	153	nan	378922	1729	274	30829	1	nan	shot	10260	shoton
nan	14	153	nan	378923	1729	279	30373	2	nan	shot	10260	shoton
nan	17	137	nan	378951	1729	272	30373	3	nan	distance	10260	shoton
nan	43	61	nan	379204	1729	296	24154		nan	blocked_shot	10260	shoton
nan	50	137	nan	379363	1729	302	37799		nan	distance	10261	shoton
nan	58	149	nan	379401	1729	310	24157		nan	distance	10260	shoton
nan	58	61	nan	379406	1729	311	24157	4	nan	blocked_shot	10260	shoton
nan	60	61	nan	379414	1729	314	30829		nan	blocked_shot	10260	shoton


CREATE TABLE shoton_detail (
  "blocked" VARCHAR,
  "card_type" VARCHAR,
  "coordinates" 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,
  "shoton" VARCHAR,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR
);