Name: Clermont Foot FC/2022-23
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Clermont Foot FC/2022-23

i scraped this data from fbref to work on finding exciting new talent from ligue 1. it contains statistics about different aspects of the team.

please feel free to use it as per your needs.

happy coding!

Tables

Clermontfoot 2223 Defensiveactions

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_defensiveactions

16.81 kB
28 rows
22 columns

CREATE TABLE clermontfoot_2223_defensiveactions (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "tkl" BIGINT,
  "tklw" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "tkl_1" BIGINT,
  "att" BIGINT,
  "tkl_6c6d02" DOUBLE  -- Tkl%,
  "lost" BIGINT,
  "blocks" BIGINT,
  "sh" BIGINT,
  "pass" BIGINT,
  "int" BIGINT,
  "tkl_int" BIGINT,
  "clr" BIGINT,
  "err" BIGINT,
  "matches" VARCHAR
);

Clermontfoot 2223 Goalshotcreation

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_goalshotcreation

16.18 kB
28 rows
22 columns

CREATE TABLE clermontfoot_2223_goalshotcreation (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "sca" BIGINT,
  "sca90" DOUBLE,
  "passlive" BIGINT,
  "passdead" BIGINT,
  "to" BIGINT,
  "sh" BIGINT,
  "fld" BIGINT,
  "def" BIGINT,
  "gca" BIGINT,
  "gca90" DOUBLE,
  "passlive_1" BIGINT,
  "passdead_1" BIGINT,
  "to_1" BIGINT,
  "sh_1" BIGINT,
  "fld_1" BIGINT,
  "def_1" BIGINT,
  "matches" VARCHAR
);

Clermontfoot 2223 Passing

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_passing

22.57 kB
28 rows
29 columns

CREATE TABLE clermontfoot_2223_passing (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE  -- Cmp%,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "cmp_1" BIGINT,
  "att_1" BIGINT,
  "cmp_1_c8ea36" DOUBLE  -- Cmp%.1,
  "cmp_2" BIGINT,
  "att_2" BIGINT,
  "cmp_2_b6e57c" DOUBLE  -- Cmp%.2,
  "cmp_3" BIGINT,
  "att_3" BIGINT,
  "cmp_3_98370a" DOUBLE  -- Cmp%.3,
  "ast" BIGINT,
  "xag" DOUBLE,
  "xa" DOUBLE,
  "a_xag" DOUBLE,
  "kp" BIGINT,
  "n_1_3" BIGINT  -- 1/3,
  "ppa" BIGINT,
  "crspa" BIGINT,
  "prgp" BIGINT,
  "matches" VARCHAR
);

Clermontfoot 2223 Passtypes

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_passtypes

15.65 kB
28 rows
21 columns

CREATE TABLE clermontfoot_2223_passtypes (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "att" BIGINT,
  "live" BIGINT,
  "dead" BIGINT,
  "fk" BIGINT,
  "tb" BIGINT,
  "sw" BIGINT,
  "crs" BIGINT,
  "ti" BIGINT,
  "ck" BIGINT,
  "in" BIGINT,
  "out" BIGINT,
  "str" BIGINT,
  "cmp" BIGINT,
  "off" BIGINT,
  "blocks" BIGINT,
  "matches" VARCHAR
);

Clermontfoot 2223 Playingtime

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_playingtime

21.32 kB
33 rows
27 columns

CREATE TABLE clermontfoot_2223_playingtime (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "mp" BIGINT,
  "min" DOUBLE,
  "mn_mp" DOUBLE,
  "min_59d8e8" DOUBLE  -- Min%,
  "n_90s" DOUBLE  -- 90s,
  "starts" BIGINT,
  "mn_start" DOUBLE,
  "compl" BIGINT,
  "subs" BIGINT,
  "mn_sub" DOUBLE,
  "unsub" BIGINT,
  "ppm" DOUBLE,
  "ong" DOUBLE,
  "onga" DOUBLE,
  "n__error" DOUBLE  -- #ERROR!,
  "n__error_1" DOUBLE  -- #ERROR!.1,
  "on_off" DOUBLE,
  "onxg" DOUBLE,
  "onxga" DOUBLE,
  "xg" DOUBLE  -- XG+/-,
  "xg_90" DOUBLE  -- XG+/-90,
  "on_off_1" DOUBLE,
  "matches" VARCHAR
);

Clermontfoot 2223 Possession

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_possession

21.86 kB
28 rows
28 columns

CREATE TABLE clermontfoot_2223_possession (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "touches" BIGINT,
  "def_pen" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "att_pen" BIGINT,
  "live" BIGINT,
  "att" BIGINT,
  "succ" BIGINT,
  "succ_c8ffb4" DOUBLE  -- Succ%,
  "tkld" BIGINT,
  "tkld_a3c7ed" DOUBLE  -- Tkld%,
  "carries" BIGINT,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "prgc" BIGINT,
  "n_1_3" BIGINT  -- 1/3,
  "cpa" BIGINT,
  "mis" BIGINT,
  "dis" BIGINT,
  "rec" BIGINT,
  "prgr" BIGINT,
  "matches" VARCHAR
);

Clermontfoot 2223 Shooting

@kaggle.throughabrokenvisor_clermont_foot_fc2022_23.clermontfoot_2223_shooting

17.39 kB
28 rows
23 columns

CREATE TABLE clermontfoot_2223_shooting (
  "player" VARCHAR,
  "nation" VARCHAR,
  "pos" VARCHAR,
  "age" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "gls" BIGINT,
  "sh" BIGINT,
  "sot" BIGINT,
  "sot_d2d6f4" DOUBLE  -- SoT%,
  "sh_90" DOUBLE,
  "sot_90" DOUBLE,
  "g_sh" DOUBLE,
  "g_sot" DOUBLE,
  "dist" DOUBLE,
  "fk" BIGINT,
  "pk" BIGINT,
  "pkatt" BIGINT,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "npxg_sh" DOUBLE,
  "g_xg" DOUBLE,
  "np_g_xg" DOUBLE,
  "matches" VARCHAR
);