Seaview

Identity

City

Belfast

Nation

Northern Ireland

Capacity

3,208

Seating capacity

3,208

Expansion capacity

5,000

Built

1921-01-01

Owner club

Crusaders

Ownership type

Not set

Nearby stadium

Grove Playing Fields

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

Synthetic soft

Pitch length

960 96 m, derived

Pitch width

594 59.4 m, derived

Pitch condition

200

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

54.624302, -5.921921

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.