European Soccer Database Supplementary

Data Supplementary to "European Soccer Database"

@kaggle.jiezi2004_soccer

Table List

9 tables(12.36 MB)

Goal Detail

@kaggle.jiezi2004_soccer.goal_detail

738.38 KB
39980 rows
26 columns

comment Comment	elapsed Elapsed	event_incident_typefk Event Incident Typefk	goal_type Goal Type	id Id	match_id Match Id	n N	player1 Player1	player2 Player2	sortorder Sortorder	stats Stats	subtype Subtype	team Team	type Type
n	22	406	n	378998	1729	295	37799	38807	5	nan	header	10261	goal
n	24	393	n	379019	1729	298	24148	24154	4	nan	shot	10260	goal
n	4	393	n	375546	1730	231	26181	39297	2	nan	shot	9825	goal
n	83	407	n	378041	1731	344	30853	30889		nan	distance	8650	goal
n	4	393	n	376060	1732	244	23139	36394	2	nan	shot	8654	goal
n	10	393	n	376165	1732	251	23139	37277	1	nan	shot	8654	goal
n	47	411	n	376929	1732	294	127857	34466	3	nan	volley	8528	goal
n	47	406	n	378837	1733	251	26165	23354	2	nan	header	10252	goal
p	64	20	p	378981	1733	266	40198			nan	nan	8456	goal
n	69	393	n	379030	1733	270	23264	24658	1	nan	shot	10252	goal


CREATE TABLE goal_detail (
  "comment" VARCHAR,
  "coordinates" VARCHAR,
  "del" DOUBLE,
  "elapsed" BIGINT,
  "elapsed_plus" DOUBLE,
  "event_incident_typefk" BIGINT,
  "goal" VARCHAR,
  "goal_type" VARCHAR,
  "goals" VARCHAR,
  "id" BIGINT,
  "match_id" BIGINT,
  "n" BIGINT,
  "owngoals" VARCHAR,
  "penalties" VARCHAR,
  "player1" DOUBLE,
  "player2" DOUBLE,
  "pos_x" DOUBLE,
  "pos_y" DOUBLE,
  "shotoff" VARCHAR,
  "shoton" VARCHAR,
  "sortorder" BIGINT,
  "stats" VARCHAR,
  "subtype" VARCHAR,
  "team" DOUBLE,
  "type" VARCHAR,
  "value" VARCHAR
);