St Andrew's Trillion Trophy Stadium

Identity

City

Birmingham

Nation

England

Capacity

30,016

Seating capacity

30,016

Expansion capacity

38,000

Built

—

Owner club

Birmingham City

Ownership type

Not set

Nearby stadium

Villa Park

A capacity of 0 is a stored zero and is shown as one; a blank is a value the export did not record. Build dates run from the nineteenth century to dates in the game's future, and are shown as stored.

Pitch and roof

Pitch type

Grass/synthetic mix

Pitch length

1000 100 m, derived

Pitch width

650 65 m, derived

Pitch condition

200

Covered

—

Under-soil heating

—

Retractable roof

—

The source stores pitch dimensions in decimetres — Old Trafford, the Camp Nou and Wembley all hold 1050 by 680 — so the stored number is shown first and the metre figure beside it is derived by this application, not something the database contains. A stored 0 means the row has no dimensions and converts to nothing. stadium.pitch_condition is a raw source scale running to 200 with no lookup table, and is printed as stored.

Location

Coordinates

52.475674, -1.868119

Resident clubs

Clubs come from club.stadium_uid. One shared ground in the data carries 119 of them, so the list is paginated rather than loaded whole.

Competition seasons hosted

Seasons come from comp_history.host_stadium_uid. season_end_year is the end year, so 2020 is the 2019–20 season; rows with no end year fall back to the stored season_year. Winners point at club_team rather than club, because an international tournament is won by a national team — and since club_team.name is recorded for under two per cent of squads, the winner is named by its club or nation rather than by an invented team name. comp_history rows carry a synthetic negative uid and never appear in a URL.