Jfjelstul Worldcup Data-csv Appearances -

SELECT player_name, team, SUM(minutes_played) as total_minutes FROM appearances WHERE tournament = '2022' GROUP BY player_id ORDER BY total_minutes DESC Goalkeepers and center-backs from finalists dominate. In 2022, Emiliano Martínez (Argentina) or Hugo Lloris (France) would top the list with ~690+ minutes. But the real magic is historical: In 2014, Manuel Neuer played every single minute of Germany’s run, including the final. 3. The Tactical Insight: Substitution Dynamics Over Time The substitute_in and substitute_out columns allow you to map the evolution of tactics. Before 1970, substitutions were practically non-existent (injury only). By 2022, five substitutions were allowed.

Calculate the average minute of the first substitution per decade. jfjelstul worldcup data-csv appearances

# Pseudocode for Python (Pandas) avg_sub_time = df[df['substitute_out'].notnull()].groupby('year')['substitute_out'].mean() In the 1980s, the average sub happened in the 75th minute. By 2022, it’s the 58th minute. This table empirically proves the tactical revolution: managers now treat the bench as a weapon, not a lifeboat. 4. The Anomaly Detection: Own Goals and Disciplinary Records Because appearances.csv includes own_goals and red_cards at the player-match level, you can ask bizarre, wonderful questions. By 2022, five substitutions were allowed