Bruchwegstadion

Identity

City

Mainz

Nation

Germany

Capacity

20,300

Seating capacity

14,500

Expansion capacity

20,300

Built

1950-07-01

Owner club

1. FSV Mainz 05

Ownership type

Club

Nearby stadium

MEWA Arena

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

Pitch length

1050 105 m, derived

Pitch width

680 68 m, derived

Pitch condition

200

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

50.000923, 8.245717

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.

Teams based here

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.

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.