Football Players Stats

Comprehensive Football Player Statistics

@kaggle.febinjoy98_football_players_stats

Table List

1 table(12.46 KB)

Football Players Stats

@kaggle.febinjoy98_football_players_stats.football_players_stats

12.46 KB
17 rows
16 columns

player_name Player Name	team Team	position Position	age Age	matches_played Matches Played	goals Goals	assists Assists	yellow_cards Yellow Cards	red_cards Red Cards	minutes_played Minutes Played	pass_accuracy Pass Accuracy (%)	tackles Tackles	interceptions Interceptions	shots_on_target Shots On Target	fouls_won Fouls Won	dribbles_completed Dribbles Completed
Lionel Messi	Inter Miami	Forward	36	25	18	12	3		2250	88.5	5	2	52	30	40
Cristiano Ronaldo	Al-Nassr	Forward	38	22	20	8	2	1	1980	85.1	3	1	48	20	25
Kylian Mbappé	PSG	Forward	24	30	28	10	4		2700	87.2	6	3	62	25	55
Kevin De Bruyne	Man City	Midfielder	32	29	10	16	5		2500	91.3	8	5	24	35	20
Virgil van Dijk	Liverpool	Defender	32	28	3	1	6		2520	89	20	10	5	10	5
Erling Haaland	Man City	Forward	23	27	35	5	2		2500	80.5	4	2	70	15	30
Luka Modrić	Real Madrid	Midfielder	38	28	6	12	2		2400	92	10	7	10	22	12
Mohamed Salah	Liverpool	Forward	31	30	22	12	1		2700	87.5	7	3	55	40	38
Pedri	Barcelona	Midfielder	21	31	9	8	4		2600	90.2	9	6	15	20	18
Declan Rice	Arsenal	Midfielder	24	32	4	3	6		2560	89.7	15	12	8	18	8


CREATE TABLE football_players_stats (
  "player_name" VARCHAR,
  "team" VARCHAR,
  "position" VARCHAR,
  "age" BIGINT,
  "matches_played" BIGINT,
  "goals" BIGINT,
  "assists" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "minutes_played" BIGINT,
  "pass_accuracy" DOUBLE,
  "tackles" BIGINT,
  "interceptions" BIGINT,
  "shots_on_target" BIGINT,
  "fouls_won" BIGINT,
  "dribbles_completed" BIGINT
);