Football Coaches - Stats And Trophies

Coaches -info & trophies - Top 5 Leagues in European football

@kaggle.vaske93_football_coaches_stats_and_tropheys

Table List

1 table(16.86 KB)

All Coaches

@kaggle.vaske93_football_coaches_stats_and_tropheys.all_coaches

16.86 KB
99 rows
13 columns

name Name	club Club	birth_date Birth Date	age Age	place_of_birth Place Of Birth	citizenship Citizenship	appointment_date Appointment Date	contract_until_date Contract Until Date	coaching_licence Coaching Licence	avg_term_as_coach Avg Term As Coach	preffered_formation Preffered Formation	current_league Current League	current_league_country Current League Country
Pep Guardiola	Man City	Mon Jan 18 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	50	Santpedor	Spain	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SEG	3.38 Years	4-3-3 Attacking	Premier League	England
Ole Gunnar Solskjaer	Without Club	Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	48	Kristiansund	Norway			Jim Solbakken	2.05 Years	4-2-3-1	Premier League	England
Thomas Tuchel	Chelsea	Wed Aug 29 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	48	Krumbach	Germany	Tue Jan 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Dr. Olaf Meinking	2.28 Years	3-4-2-1	Premier League	England
Jürgen Klopp	Liverpool	Fri Jun 16 1967 00:00:00 GMT+0000 (Coordinated Universal Time)	54	Stuttgart	Germany	Thu Oct 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	UEFA Pro Licence	5.40 Years	4-3-3 Attacking	Premier League	England
Nuno Espírito Santo	Without Club	Fri Jan 25 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	47	São Tomé	Portugal			Gestifute	1.76 Years	3-4-3	Premier League	England
Brendan Rodgers	Leicester	Fri Jan 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	48	Carnlough	Northern Ireland	Wed Feb 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	UEFA Pro Licence	2.02 Years	4-2-3-1	Premier League	England
Rafael Benítez	Everton	Sat Apr 16 1960 00:00:00 GMT+0000 (Coordinated Universal Time)	61	Madrid	Spain	Thu Jul 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Manuel García ...	1.91 Years	4-2-3-1	Premier League	England
Dean Smith	Norwich	Fri Mar 19 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	50	West Bromwich	England	Mon Nov 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UEFA Pro Licence	2.75 Years	4-2-3-1	Premier League	England
Bruno Lage	Wolves	Wed May 12 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	45	Setúbal	Portugal	Thu Jul 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Gestifute	1.31 Years	5-4-1	Premier League	England
David Moyes	West Ham	Thu Apr 25 1963 00:00:00 GMT+0000 (Coordinated Universal Time)	58	Glasgow	Scotland	Sun Dec 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	UEFA Pro Licence	3.23 Years	4-2-3-1	Premier League	England


CREATE TABLE all_coaches (
  "name" VARCHAR,
  "club" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" BIGINT,
  "place_of_birth" VARCHAR,
  "citizenship" VARCHAR,
  "appointment_date" TIMESTAMP,
  "contract_until_date" TIMESTAMP,
  "coaching_licence" VARCHAR,
  "avg_term_as_coach" VARCHAR,
  "preffered_formation" VARCHAR,
  "current_league" VARCHAR,
  "current_league_country" VARCHAR
);