De Kuip

Identity

City

Rotterdam

Nation

Holland

Capacity

51,177

Seating capacity

51,137

Expansion capacity

60,000

Built

—

Owner club

—

Ownership type

Not set

Nearby stadium

—

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

199

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

51.894093, 4.523168

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.