FIFA World Cups

50 Years Of World Cup player stats in every men’s World Cup from 1966 to 2018

@kaggle.joebeachcapital_fifa_world_cups

Table List

1 table(208.73 KB)

World Cup Comparisons

@kaggle.joebeachcapital_fifa_world_cups.world_cup_comparisons

208.73 KB
5886 rows
19 columns

player Player	season Season	team Team	goals_z Goals Z	xg_z Xg Z	crosses_z Crosses Z	boxtouches_z Boxtouches Z	passes_z Passes Z	progpasses_z Progpasses Z	takeons_z Takeons Z	progruns_z Progruns Z	tackles_z Tackles Z	interceptions_z Interceptions Z	clearances_z Clearances Z	blocks_z Blocks Z	aerials_z Aerials Z	fouls_z Fouls Z	fouled_z Fouled Z	nsxg_z Nsxg Z
Cristian Pavón	2018	Argentina	-0.38	-0.51	0.08	-0.25	-0.65	-0.74	-0.08	0.14	0.24	-0.77	-0.81	-0.44	-0.24	-0.4	-0.93	-0.6
Eduardo Salvio	2018	Argentina	-0.38	-0.48	-0.5	0.62	-0.03	-0.49	-0.08	0.46	0.52	0.59	0.32	-0.44	0.19	-1.12	0.62	-0.05
Enzo Pérez	2018	Argentina	-0.38	0.05	-0.5	-0.69	0.2	-0.68	-0.39	-0.35	0.28	-0.24	-0.81	-0.44	-0.89	0.68		-0.68
Federico Fazio	2018	Argentina	-0.38	-0.55	-0.5	-0.69	-1	-0.93	-0.7	-0.84	-0.8	-0.77	-0.65	-0.44	0.19	-1.12	-0.62	-0.79
Franco Armani	2018	Argentina	-0.38	-0.55	-0.5	-0.8	-0.7	0.6	-0.7	-0.68	-0.8	-0.77	-0.65	-0.44	-0.89	-1.12	-0.93	-0.79
Gabriel Mercado	2018	Argentina	1.01	-0.31	0.08	-0.36	0.92	-0.23	-0.39	0.14	1.28	0.7	0.64	0.69	-0.03	1.76	0.62	-0.49
Gonzalo Higuaín	2018	Argentina	-0.38	0.16	-0.5	-0.03	-0.8	-1.12	-0.39	-0.68	-0.8	-0.77	-0.65	-0.44	-0.67	-0.4	-0.62	-0.32
Javier Mascherano	2018	Argentina	-0.38	-0.49	-0.5	-0.8	3.11	0.47	0.23	1.61	3.39	2.54	0.8	-0.44	-0.03	4.29	1.24	-0.32
Lionel Messi	2018	Argentina	1.01	2.58	0.65	1.28	1.08	0.28	6.71	2.1	1.95	-0.77	-0.81	-0.44	-0.89	0.32	4.34	4.5
Lucas Biglia	2018	Argentina	-0.38	-0.48	-0.5	-0.36	-0.62	-0.93	-0.7	-0.84	-0.14	-0.77	-0.81	-0.44	-0.46	-1.12	-0.62	-0.7


CREATE TABLE world_cup_comparisons (
  "player" VARCHAR,
  "season" BIGINT,
  "team" VARCHAR,
  "goals_z" DOUBLE,
  "xg_z" DOUBLE,
  "crosses_z" DOUBLE,
  "boxtouches_z" DOUBLE,
  "passes_z" DOUBLE,
  "progpasses_z" DOUBLE,
  "takeons_z" DOUBLE,
  "progruns_z" DOUBLE,
  "tackles_z" DOUBLE,
  "interceptions_z" DOUBLE,
  "clearances_z" DOUBLE,
  "blocks_z" DOUBLE,
  "aerials_z" DOUBLE,
  "fouls_z" DOUBLE,
  "fouled_z" DOUBLE,
  "nsxg_z" DOUBLE
);