Dove Trovo...
Guida rapida per trovare i dati che cerchi.
| Cerco… | Dove guardare | Colonne chiave |
|---|---|---|
| Voti e fantavoti (singola partita) | fc_player_matches |
vote, fantasy_vote, bonus, malus |
| Voti e fantavoti (media stagionale) | fc_player_seasons |
average_vote, fantasy_average |
| Quotazioni (trend) | fc_quotation_history |
quotation_classic, quotation_mantra |
| Quotazioni (attuali) | fc_player_seasons |
quotation_classic, quotation_mantra |
| FVM (trend) | fc_fvm_history |
fvm_value |
| Ruolo fantacalcio | fc_player_seasons |
role_short (P/D/C/A), role_mantra |
| Expected Goals (xG) | us_players (stagione), us_player_match_details (partita), us_player_shots (tiro) |
xG |
| xG per 90 minuti | bera |
xg_90, npxg_90, xa_90 |
| Expected Assists (xA) | us_players o us_player_match_details |
xA |
| Mappa tiri (coordinate) | us_player_shots |
x_coordinate, y_coordinate, xG, result |
| Rating SofaScore | sofascore |
rating |
| Passaggi precisi % | sofascore |
accurate_passes_percentage |
| Duelli aerei vinti | sofascore |
aerial_duels_won, aerial_duels_won_percentage |
| Trasferimenti | tm_transfers |
fee, market_value, club_from_id, club_to_id |
| Valore di mercato (snapshot storico) | tm_market_value |
market_value, date, age |
| Valore di mercato (al trasferimento) | tm_transfers |
market_value |
| Valore di mercato (stagionale, Bera) | bera |
valore_di_mercato |
| Infortuni | tm_player_injuries (raw), db_player_injuries (puliti) |
from_date, until_date, days |
| Partite saltate per infortunio | db_missed_matches_injury |
collega injury_id a match_id |
| Tipo infortunio | condition_types |
name, type |
| Pressing squadra (PPDA) | us_team_history |
ppda_att, ppda_def |
| xG squadra (partita) | us_team_history o us_matches |
xG, xGA |
| Modulo di gioco | bera |
modulo |
| Allenatore (per partita) | fc_player_matches |
allenatore |
| Allenatore (stagionale, da Bera) | bera |
allenatore |
| Allenatori nella stagione (vista ML) | v_player_season_stats |
Allenatore_1…Allenatore_7, Partite_Allenatore_1…Partite_Allenatore_7 |
| Piede preferito | players |
foot |
| Altezza | players |
height |
| Tutto insieme per ML | v_player_season_stats |
vedi Vista ML |
| Rating SofaScore per partita | ss_matches / player_match_stats |
ss_rating, ss_alternative_rating |
| Statistiche partita per giocatore | ss_matches / player_match_stats |
ss_minutes_played, ss_touches, ss_total_pass, ss_expected_assists, … |
| Modulo di gioco (per partita) | ss_match_meta / player_match_stats |
ss_m_home_formation, ss_m_away_formation |
| Allenatore (per partita, da SofaScore) | ss_match_meta / player_match_stats |
ss_m_home_manager, ss_m_away_manager |
| Arbitro (per partita) | ss_match_meta / player_match_stats |
ss_m_referee |
| Minuti di recupero | ss_match_meta / player_match_stats |
ss_m_injury_time_1, ss_m_injury_time_2 |
| Tiri per tipo/risultato/situazione (partita) | player_match_stats |
us_s_rightfoot, us_s_res_goal, us_s_sit_open_play, … |
| Tutto insieme per ML (partita) | player_match_stats |
vedi Vista ML |