European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Shotoff Detail

@kaggle.jiezi2004_soccer.shotoff_detail

1.38 MB
95303 rows
19 columns

card_type Card Type	elapsed Elapsed	event_incident_typefk Event Incident Typefk	id Id	match_id Match Id	n N	player1 Player1	sortorder Sortorder	stats Stats	subtype Subtype	team Team	type Type
nan	4	9	378835	1729	264	30373	1	nan	distance	10260	shotoff
nan	5	9	378845	1729	257	37799	2	nan	distance	10261	shotoff
nan	22	317	378995	1729	269	24228	3	nan	deflected	10261	shotoff
nan	31	9	379075	1729	278	38807		nan	distance	10261	shotoff
nan	34	47	379111	1729	281	24154	2	nan	header	10260	shotoff
nan	37	9	379140	1729	291	30373	2	nan	distance	10260	shotoff
nan	53	9	379378	1729	320	40565	1	nan	distance	10261	shotoff
nan	60	9	379415	1729	315	37799	1	nan	distance	10261	shotoff
nan	62	317	379419	1729	316	38807	1	nan	deflected	10261	shotoff
nan	62	47	379421	1729	318	37799	3	nan	header	10261	shotoff


CREATE TABLE shotoff_detail (
  "card_type" VARCHAR,
  "coordinates" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "id" BIGINT,
  "match_id" BIGINT,
  "n" BIGINT,
  "player1" DOUBLE,
  "pos_x" DOUBLE,
  "pos_y" DOUBLE,
  "shotoff" VARCHAR,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR
);