Dati SofaScore

sofascore (~8.200 righe)

Statistiche stagionali aggregate per giocatore. Una riga = un giocatore in una stagione.

Il campo league (VARCHAR 20) indica la lega di appartenenza (es. 'seriea').

Colonne chiave (raggruppate per categoria):

Categoria	Colonne principali
Gol	goals, penalty_goals, free_kick_goal, headed_goals, left_foot_goals, right_foot_goals, goals_from_inside_the_box, goals_from_outside_the_box
Tiri	total_shots, shots_on_target, shots_off_target, blocked_shots, shot_from_set_piece, goal_conversion_percentage, hit_woodwork
Passaggi	assists, big_chances_created, key_passes, accurate_passes, total_passes, accurate_passes_percentage, accurate_final_third_passes, accurate_crosses, accurate_long_balls, pass_to_assist
Dribbling	successful_dribbles, successful_dribbles_percentage
Difesa	tackles, interceptions, clearances, error_lead_to_goal, error_lead_to_shot, dribbled_past
Portiere	clean_sheet, saves, penalty_save, punches, runs_out, high_claims, saved_shots_from_inside_the_box
Duelli	ground_duels_won, aerial_duels_won, total_duels_won + rispettive percentuali
Disciplina	yellow_cards, red_cards, fouls, was_fouled, offsides
Minutaggio	minutes_played, appearances, matches_started, rating
Possesso	dispossessed, possession_lost, penalties_taken

rating è il rating medio SofaScore (scala ~5-10).

---

ss_matches (~171.000 righe)

Statistiche per giocatore per partita. Una riga = un giocatore in una singola partita. Join chiave: sofascore_event_id + player_id.

Colonna	Descrizione
sofascore_event_id	ID partita su SofaScore
player_id	FK verso players
sofascore_team_id	ID squadra su SofaScore (confronta con ss_match_meta.home_team_id per sapere se home/away)
season / match_day	Stagione e giornata
substitute	1 = entrato dalla panchina
position	Ruolo in campo: G, D, M, F
shirt_number	Numero di maglia
minutes_played	Minuti giocati
rating	Rating SofaScore per la partita
alternative_rating	Rating alternativo (disponibile da stagioni recenti)
expected_assists	xA per la partita
goals_prevented	Gol evitati (solo portieri)
possession_lost_ctrl	Palloni persi con controllo

Statistiche complete (tutte presenti):

Categoria	Colonne
Passaggi	total_pass, accurate_pass, total_long_balls, accurate_long_balls, accurate_own_half_passes, total_own_half_passes, accurate_opposition_half_passes, total_opposition_half_passes, total_cross, accurate_cross, key_pass
Duelli/Aerei	aerial_lost, aerial_won, duel_lost, duel_won, challenge_lost
Possesso	dispossessed, total_contest, won_contest, unsuccessful_touch, touches, ball_recovery, possession_lost_ctrl
Tiri	shot_off_target, on_target_scoring_attempt, blocked_scoring_attempt, total_shots, goals, big_chance_missed
Attacco	goal_assist, big_chance_created, expected_assists
Difesa	total_clearance, outfielder_block, clearance_off_line, interception_won, total_tackle
Disciplina	was_fouled, fouls, total_offside
Portiere	saved_shots_from_inside_the_box, saves, good_high_claim, error_lead_to_a_shot, goals_prevented

---

ss_match_meta (~3.800 righe)

Metadati per partita (una riga per partita). Join chiave: sofascore_event_id.

Colonna	Descrizione
sofascore_event_id	ID partita su SofaScore (PK logico)
season / match_day	Stagione e giornata
start_timestamp	Timestamp Unix inizio partita
home_team_id / away_team_id	ID SofaScore delle squadre
home_score / away_score	Risultato finale
home_score_ht / away_score_ht	Risultato a fine primo tempo
winner_code	1 = casa, 2 = trasferta, 3 = pareggio
home_formation / away_formation	Modulo di gioco (es. "3-5-2")
home_manager_id / home_manager_name	Allenatore squadra casa
away_manager_id / away_manager_name	Allenatore squadra ospite
referee_id / referee_name	Arbitro
venue_id / venue_name	Stadio
attendance	Spettatori
injury_time_1 / injury_time_2	Minuti di recupero 1° e 2° tempo

Nota: home_manager_name può essere NULL per partite delle stagioni 2017–2019 — SofaScore non restituisce il dato per match storici.