Football Match Statistics
This dataset contains 25 years of football match statistics from 18 leagues.
@kaggle.gokhanergul_football_match_statistics
This dataset contains 25 years of football match statistics from 18 leagues.
@kaggle.gokhanergul_football_match_statistics
This dataset, created in collaboration with my classmate Sadık Can Barut, contains detailed match statistics for various football games. It consists of approximately 100,000 rows and 91 columns, offering rich data to analyze team and player performance across multiple dimensions. The columns cover a range of categories such as team names, scores, season years, match dates, and detailed in-game statistics like possession, distance covered, clearances, pass success rates, and much more.
This dataset includes 18 leagues, consisting of 3 leagues from each of the 6 countries:
Germany
France
England
Italy
Spain
Turkey
If you want to fetch more data, I have shared the code and the Streamlit interface on my GitHub.
footballsports analyticsmachine learningsoccerdata sciencefootball statisticsstreamlitdata visualizationfootball datasetThis dataset is ideal for exploring football analytics, developing machine learning models for match prediction, performance analysis, or even deep dives into team dynamics and player contributions throughout the seasons.
We believe that this dataset will be useful for anyone interested in football analytics, machine learning, or data science challenges, and we hope it can serve as a foundation for many exciting analyses and projects.
CREATE TABLE football (
"country" VARCHAR,
"league" VARCHAR,
"home_team" VARCHAR,
"away_team" VARCHAR,
"home_score" VARCHAR,
"away_score" VARCHAR,
"season_year" VARCHAR,
"date_day" DOUBLE,
"date_hour" VARCHAR,
"first_half" VARCHAR,
"second_half" VARCHAR,
"home_team_goals_current_time" VARCHAR,
"home_team_goals_current_score" VARCHAR,
"home_team_goals" VARCHAR,
"home_team_goals_assist" VARCHAR,
"away_team_goals_current_time" VARCHAR,
"away_team_goals_current_score" VARCHAR,
"away_team_goals" VARCHAR,
"away_team_goals_assist" VARCHAR,
"home_team_yellow_card_current_time" VARCHAR,
"home_team_yellow_card" VARCHAR,
"home_team_yellow_card_why" VARCHAR,
"away_team_yellow_card_current_time" VARCHAR,
"away_team_yellow_card" VARCHAR,
"away_team_yellow_card_why" VARCHAR,
"home_team_red_card_current_time" VARCHAR,
"home_team_red_card" VARCHAR,
"home_team_red_card_why" VARCHAR,
"away_team_red_card_current_time" VARCHAR,
"away_team_red_card" VARCHAR,
"away_team_red_card_why" VARCHAR,
"home_team_substitutions_current_time" VARCHAR,
"home_team_substitutions" VARCHAR,
"home_team_substitutions_with" VARCHAR,
"home_team_substitution_why" VARCHAR,
"away_team_substitutions_current_time" VARCHAR,
"away_team_substitutions" VARCHAR,
"away_team_substitutions_with" VARCHAR,
"away_team_substitution_why" VARCHAR,
"expected_goals_xg_home" DOUBLE,
"expected_goals_xg_host" DOUBLE,
"ball_possession_home" VARCHAR,
"ball_possession_host" VARCHAR,
"goal_attempts_home" DOUBLE,
"goal_attempts_host" DOUBLE,
"shots_on_goal_home" DOUBLE,
"shots_on_goal_host" DOUBLE,
"shots_off_goal_home" DOUBLE,
"shots_off_goal_host" DOUBLE,
"blocked_shots_home" DOUBLE,
"blocked_shots_host" DOUBLE,
"free_kicks_home" DOUBLE,
"free_kicks_host" DOUBLE,
"corner_kicks_home" DOUBLE,
"corner_kicks_host" DOUBLE,
"offsides_home" DOUBLE,
"offsides_host" DOUBLE,
"throw_ins_home" DOUBLE,
"throw_ins_host" DOUBLE,
"goalkeeper_saves_home" DOUBLE,
"goalkeeper_saves_host" DOUBLE,
"fouls_home" DOUBLE,
"fouls_host" DOUBLE,
"red_cards_home" DOUBLE,
"red_cards_host" DOUBLE,
"yellow_cards_home" DOUBLE,
"yellow_cards_host" DOUBLE,
"total_passes_home" DOUBLE,
"total_passes_host" DOUBLE,
"completed_passes_home" DOUBLE,
"completed_passes_host" DOUBLE,
"tackles_home" VARCHAR,
"tackles_host" VARCHAR,
"crosses_completed_home" DOUBLE,
"crosses_completed_host" DOUBLE,
"interceptions_home" DOUBLE,
"interceptions_host" DOUBLE,
"attacks_home" DOUBLE,
"attacks_host" DOUBLE,
"dangerous_attacks_home" DOUBLE,
"dangerous_attacks_host" DOUBLE,
"distance_covered_km_home" DOUBLE -- Distance Covered (km) Home,
"distance_covered_km_host" DOUBLE -- Distance Covered (km) Host,
"clearances_completed_home" DOUBLE,
"clearances_completed_host" DOUBLE,
"pass_success_per_home" DOUBLE,
"pass_success_per_host" DOUBLE,
"referee" VARCHAR,
"venue" VARCHAR,
"capacity" VARCHAR,
"attendance" VARCHAR
);Anyone who has the link will be able to view this.