Football Data From Transfermarkt

Football (Soccer) data scraped from Transfermarkt website

@kaggle.davidcariboo_player_scores

Table List

10 tables(163.99 MB)

Clubs

Games

Players

Competitions

@kaggle.davidcariboo_player_scores.competitions

11.1 KB
44 rows
11 columns

competition_id Competition Id	competition_code Competition Code	name Name	sub_type Sub Type	type Type	country_id Country Id	country_name Country Name	domestic_league_code Domestic League Code	confederation Confederation	url Url	is_major_national_league Is Major National League
CIT	italy-cup	italy-cup	domestic_cup	domestic_cup	75	Italy	IT1	europa	https://www.transfermarkt.co.uk/italy-cup/startseite/wettbewerb/CIT
NLSC	johan-cruijff-schaal	johan-cruijff-schaal	domestic_super_cup	other	122	Netherlands	NL1	europa	https://www.transfermarkt.co.uk/johan-cruijff-schaal/startseite/wettbewerb/NLSC
GRP	kypello-elladas	kypello-elladas	domestic_cup	domestic_cup	56	Greece	GR1	europa	https://www.transfermarkt.co.uk/kypello-elladas/startseite/wettbewerb/GRP
POSU	supertaca-candido-de-oliveira	supertaca-candido-de-oliveira	domestic_super_cup	other	136	Portugal	PO1	europa	https://www.transfermarkt.co.uk/supertaca-candido-de-oliveira/startseite/wettbewerb/POSU
RUSS	russian-super-cup	russian-super-cup	domestic_super_cup	other	141	Russia	RU1	europa	https://www.transfermarkt.co.uk/russian-super-cup/startseite/wettbewerb/RUSS
SUC	supercopa	supercopa	domestic_super_cup	other	157	Spain	ES1	europa	https://www.transfermarkt.co.uk/supercopa/startseite/wettbewerb/SUC
USC	uefa-super-cup	uefa-super-cup	uefa_super_cup	international_cup	-1	nan	nan	europa	https://www.transfermarkt.co.uk/uefa-super-cup/startseite/pokalwettbewerb/USC
DK1	superligaen	superligaen	first_tier	domestic_league	39	Denmark	DK1	europa	https://www.transfermarkt.co.uk/superligaen/startseite/wettbewerb/DK1
EL	europa-league	europa-league	europa_league	international_cup	-1	nan	nan	europa	https://www.transfermarkt.co.uk/europa-league/startseite/pokalwettbewerb/EL
ES1	laliga	laliga	first_tier	domestic_league	157	Spain	ES1	europa	https://www.transfermarkt.co.uk/laliga/startseite/wettbewerb/ES1	true


CREATE TABLE competitions (
  "competition_id" VARCHAR,
  "competition_code" VARCHAR,
  "name" VARCHAR,
  "sub_type" VARCHAR,
  "type" VARCHAR,
  "country_id" BIGINT,
  "country_name" VARCHAR,
  "domestic_league_code" VARCHAR,
  "confederation" VARCHAR,
  "url" VARCHAR,
  "is_major_national_league" BOOLEAN
);