St. Andrews

Identity

Nation
England
Capacity
29,409
Seating capacity
29,409
Expansion capacity
46,000
Built
1906-07-01
Owner club
Birmingham City
Ownership type
—
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
—
Pitch length
110 11 m, derived
Pitch width
70 7 m, derived
Pitch condition
1
Covered
No
Under-soil heating
Yes
Retractable roof
No

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

Name City Division Reputation
Birmingham City Birmingham Sky Bet Championship 109

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.

Teams based here

Team Container Reputation
Birmingham City Birmingham City 109

Teams come from club_team.stadium_uid, which only a small minority of squads populate. The container column reads club_team.national first and then shows whichever of club_uid or nation_uid that flag says is the populated one.