GSP

Identity

City

Nicosia

Nation

Cyprus

Capacity

22,859

Seating capacity

22,859

Expansion capacity

80,000

Built

1999-10-06

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

169

Covered

No

Under-soil heating

No

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

0, 0 recorded at 0, 0

The stored coordinates are exactly zero. Roughly one stadium in four carries that value, which is a point in the Atlantic rather than a ground, but zero is what the column holds and it is shown as stored and flagged rather than blanked or replaced with the city's position.

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.