Indian Super League

ISL Season 6 & 7 Player Stats

@kaggle.amaanafif_indian_super_league

Table List

1 table(126.61 KB)

Isl Player Final

@kaggle.amaanafif_indian_super_league.isl_player_final

126.61 KB
563 rows
93 columns

tour_id Tour Id	tour_name Tour Name	id Id	jersey_no Jersey No	name Name	short_name Short Name	position_id Position Id	position Position	position_short Position Short	team_id Team Id	team_name Team Name	team_short_name Team Short Name	is_started Is Started	is_onbench Is Onbench	is_goalkeeper Is Goalkeeper	is_substitute Is Substitute	minutes_played Minutes Played	injury_minutes_played Injury Minutes Played	actual_minutes_played Actual Minutes Played	events_goals Events.goals	events_assists Events.assists	events_key_passes Events.key Passes	events_chances_created Events.chances Created	events_shots Events.shots	events_shots_on_target Events.shots On Target	events_shots_off_target Events.shots Off Target	events_fouls_committed Events.fouls Committed	events_fouls_suffered Events.fouls Suffered	events_yellow_cards Events.yellow Cards	events_offsides Events.offsides	events_corner_kicks Events.corner Kicks	events_crosses Events.crosses	events_free_kicks Events.free Kicks	events_throw_in Events.throw In	events_punches Events.punches	events_catches Events.catches	events_goals_conceded Events.goals Conceded	events_cleansheet Events.cleansheet	events_fantasy_assists Events.fantasy Assists	events_blocked_shots Events.blocked Shots	events_penalty_kicks_total Events.penalty Kicks.total	events_penalty_kicks_goals Events.penalty Kicks.goals	touches_total Touches.total	touches_total_passes Touches.total Passes	touches_good_passes Touches.good Passes	touches_bad_passes Touches.bad Passes	touches_interceptions Touches.interceptions	touches_blocks Touches.blocks	touches_tackles Touches.tackles	touches_successful_tackles Touches.successful Tackles	touches_unsuccessful_tackles Touches.unsuccessful Tackles	touches_clearance Touches.clearance	touches_saves Touches.saves	touches_take_on_total Touches.take On Total	touches_take_on_successful Touches.take On Successful	touches_take_on_unsuccessful Touches.take On Unsuccessful	touches_aerial_duel_total Touches.aerial Duel.total	touches_aerial_duel_won Touches.aerial Duel.won	touches_aerial_duel_lost Touches.aerial Duel.lost	touches_ground_duel_total Touches.ground Duel.total	touches_ground_duel_won Touches.ground Duel.won	goaltenders_shots_faced Goaltenders.shots Faced	goaltenders_shots_on_goal_faced Goaltenders.shots On Goal Faced	goaltenders_goals_allowed Goaltenders.goals Allowed	goaltenders_saves Goaltenders.saves	goaltenders_catches Goaltenders.catches	goaltenders_penalty_kicks_shots_faced Goaltenders.penalty Kicks.shots Faced	goaltenders_penalty_kicks_goals_allowed Goaltenders.penalty Kicks.goals Allowed	country_id Country Id	country_name Country Name	dob Dob	player_foot Player Foot	height Height
148	ISL6	1514	3	Asamoah Gyan	Asamoah Gyan	2	Forward	FWD	504	NorthEast United FC	NEUFC	8	4		4	592	21	613	4	1	9	10	18	9	9	9	18	2	6		2	2				6	2	1		1	1	252	175	90	85	5	3	5	2	3	11		3		2	36	22	14	1	1								43	Ghana	nan	nan
148	ISL6	2475	26	Deshorn Dwayne Brown	Deshorn Brown	2	Forward	FWD	656	Bengaluru FC	BFC	6	7		7	379	6	385	3		3	3	19	8	10	7	5	2	3		3					2	5		1			135	91	49	42	1	2	8	5	3	4		17	8	4	10	1	9										56	Jamaica	12/22/1990	Right	187
148	ISL6	2900	9	Amine Chermiti	Amine Chermiti	2	Forward	FWD	506	Mumbai City FC	MCFC	16	6		5	1352	47	1415	6		16	16	22	10	11	31	26	4	20		13	3				11	3		1			391	291	162	129	6	6	26	5	21	15		14		3	22	10	12										106	Tunisia	12/26/1987	left	177
148	ISL6	3753	7	Francisco Medina Luna	Piti	3	Midfielder	MF	1159	Jamshedpur FC	JFC	6	5		5	416		421	1	2	7	9	16	7	6	6	19	1		14	10	22				2		3	3	1	1	247	207	133	74	5	5	9	4	5			19	11	4	4	1	3										19	Spain	5/26/1981	left	179
148	ISL6	3809	4	Rafael Lopez Gomez	Rafael Lopez Gomez	1	Defender	DEF	1536	Hyderabad FC	HFC	6	5		4	395	21	410			3	3	2		2	6	6					4	3			2	2					217	141	111	30	8	11	30	7	23	16		17	2		5	3	2										19	Spain	4/9/1985	right	183
148	ISL6	3982	30	Anas Edathodika	Anas Edathodika	1	Defender	DEF	499	ATK FC	ATK	7	5		4	534	31	577								9	4	2			2	4	33			1	6					277	151	102	49	11	12	18	7	11	51		14	1		8	7	1										1	India	2/15/1987	Right	181
148	ISL6	3984	17	Dhanpal Ganesh	Dhanpal Ganesh	3	Midfielder	MF	505	Chennaiyin FC	CFC	5	8		2	398	11	414			2	2	4		4	7	5	1				2				6	2					200	150	114	36	8	5	11	4	7	9		9			14	11	3										1	India	6/13/1994	Right	185
148	ISL6	3985	18	Thongkhosiem Haokip	Semboi Haokip	2	Forward	FWD	656	Bengaluru FC	BFC	1	5		14	250	68	320	1				7	2	4	5	10		1							3	9		1			109	76	40	36	2	1	5	2	3	1		7			15	4	11										1	India	0000-00-00	nan
148	ISL6	3989	13	Lalrempuia Fanai	Lalrempuia Fanai	3	Midfielder	MF	504	NorthEast United FC	NEUFC	1	2		1	58		58								1	1									4						40	35	29	6	1	1	2		2	1		4															1	India	5/11/1996	Right	172
148	ISL6	3997	1	Amrinder Ranjit Singh	Amrinder Singh	4	Goalkeeper	GK	506	Mumbai City FC	MCFC	18		18		1620	89	1725									2	2				62		24	34	18	2					601	261	167	94						55	49	26			1	1				165	69	29	42	30	3	3	1	India	5/27/1993	Right	183


CREATE TABLE isl_player_final (
  "tour_id" BIGINT,
  "tour_name" VARCHAR,
  "id" BIGINT,
  "jersey_no" BIGINT,
  "name" VARCHAR,
  "short_name" VARCHAR,
  "position_id" BIGINT,
  "position" VARCHAR,
  "position_short" VARCHAR,
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "team_short_name" VARCHAR,
  "is_started" BIGINT,
  "is_onbench" BIGINT,
  "is_goalkeeper" BIGINT,
  "is_substitute" BIGINT,
  "minutes_played" BIGINT,
  "bonus_points" BIGINT,
  "injury_minutes_played" BIGINT,
  "actual_minutes_played" BIGINT,
  "goaltenders" BIGINT,
  "events_goals" BIGINT,
  "events_own_goals" BIGINT,
  "events_assists" BIGINT,
  "events_key_passes" BIGINT,
  "events_chances_created" BIGINT,
  "events_shots" BIGINT,
  "events_shots_on_target" BIGINT,
  "events_shots_off_target" BIGINT,
  "events_fouls_committed" BIGINT,
  "events_fouls_suffered" BIGINT,
  "events_yellow_cards" BIGINT,
  "events_red_cards" BIGINT,
  "events_is_second_yellow_card" BIGINT,
  "events_offsides" BIGINT,
  "events_corner_kicks" BIGINT,
  "events_crosses" BIGINT,
  "events_free_kicks" BIGINT,
  "events_throw_in" BIGINT,
  "events_punches" BIGINT,
  "events_catches" BIGINT,
  "events_goals_conceded" BIGINT,
  "events_clean_sheet" BIGINT,
  "events_cleansheet" BIGINT,
  "events_fantasy_assists" BIGINT,
  "events_penalties_saved" BIGINT,
  "events_penalties_earned" BIGINT,
  "events_penalties_conceded" BIGINT,
  "events_penalties_missed" BIGINT,
  "events_freekicks_conceded_goal" BIGINT,
  "events_freekicks_earned_goal" BIGINT,
  "events_blocked_shots" BIGINT,
  "events_defensive_blocked_shots" BIGINT,
  "events_penalty_kicks_total" BIGINT,
  "events_penalty_kicks_goals" BIGINT,
  "touches_total" BIGINT,
  "touches_total_passes" BIGINT,
  "touches_good_passes" BIGINT,
  "touches_bad_passes" BIGINT,
  "touches_interceptions" BIGINT,
  "touches_blocks" BIGINT,
  "touches_tackles" BIGINT,
  "touches_successful_tackles" BIGINT,
  "touches_unsuccessful_tackles" BIGINT,
  "touches_clearance" BIGINT,
  "touches_saves" BIGINT,
  "touches_take_on_total" BIGINT,
  "touches_take_on_successful" BIGINT,
  "touches_take_on_unsuccessful" BIGINT,
  "touches_last_man_tackle_successful" BIGINT,
  "touches_last_man_tackle_unsuccessful" BIGINT,
  "touches_successful_passes" BIGINT,
  "touches_interceptions_won" BIGINT,
  "touches_aerial_duel_total" BIGINT,
  "touches_aerial_duel_won" BIGINT,
  "touches_aerial_duel_lost" BIGINT,
  "touches_ground_duel_total" BIGINT,
  "touches_ground_duel_won" BIGINT,
  "touches_ground_duel_lost" BIGINT,
  "goaltenders_shots_faced" BIGINT,
  "goaltenders_shots_on_goal_faced" BIGINT,
  "goaltenders_goals_allowed" BIGINT,
  "goaltenders_saves" BIGINT,
  "goaltenders_catches" BIGINT,
  "goaltenders_punches" BIGINT,
  "goaltenders_penalty_kicks_shots_faced" BIGINT,
  "goaltenders_penalty_kicks_goals_allowed" BIGINT,
  "goaltenders_penalty_kicks_saves" BIGINT,
  "country_id" BIGINT,
  "country_name" VARCHAR,
  "dob" VARCHAR,
  "player_foot" VARCHAR,
  "height" DOUBLE
);