Manager Timeline

A Gantt chart of every Premier League club's managers since 1992, from the Wikipedia managers list

Each club is a row, with every managerial spell drawn as a bar in that club's colours, divided by white borders. Short spells are easy to miss on the scale, so hover any bar for the manager's name, dates and time in charge — the same manager's spells at other clubs light up too, so you can trace their career around the league. Thin, faded bars are caretakers; spells still running extend to the present day. Where a bar is wide enough, the manager's name is written inside it.

Premier League Managers by Club, 1992 – present

Colour = club · faded = caretaker · white border = spell boundary · hover to highlight a manager across every club

SQL Query Used

-- Manager timeline by club: one row per managerial spell (from the Wikipedia managers list),
-- used to draw the Gantt chart on the "Manager Timeline" page. Open-ended spells are extended
-- to today so their bars reach the present edge of the chart.
copy (
    select
        club_name as team_name,
        manager_name,
        from_date,
        case
            when until_date = date '9999-12-31' then current_date
            else until_date
        end as until_date,
        case when until_date = date '9999-12-31' then 1 else 0 end as present,
        role
    from "premier_league"."main"."fact_manager_dates"
    order by club_name, from_date
)
to 'assets/data/manager_timeline.csv' (header, delimiter ',')