Stadiums

Pitch type

Ownership

Name	City	Nation	Capacity	Seating	Pitch
Dean Court	Bournemouth	England	11,464	11,464	Grass
Moss Lane	Altrincham	England	6,085	1,154	Grass
Highbury	London	England	38,420	38,420	Grass
Villa Park	Birmingham	England	42,777	42,777	Grass/synthetic mix
Sheepy Road	Atherstone	England	3,500	373	Grass
Underhill	London	England	6,023	2,303	Grass
Oakwell	Barnsley	England	23,287	23,287	Grass
Holker Street	Barrow-in-Furness	England	4,416	1,000	Grass
Twerton Park	Bath	England	8,840	1,006	Grass
St Andrew's Trillion Trophy Stadium	Birmingham	England	30,016	30,016	Grass/synthetic mix
Kingsway	Bishop Auckland	England	2,000	600	Grass
The George Wilson Stadium	Bishop's Stortford	England	6,000	270	Unused
Ewood Park	Blackburn	England	31,363	31,363	Grass
Bloomfield Road	Blackpool	England	17,338	17,338	Grass
The University of Bolton Stadium	Bolton	England	28,723	28,723	Grass
York Street	Boston	England	6,643	1,826	Grass
Northern Commercials Stadium - Valley Parade	Bradford	England	25,136	25,136	Grass
Griffin Park	London	England	12,802	8,789	Grass/synthetic mix
The Goldstone Ground	Brighton	England	10,952	10,952	Unused
Ashton Gate	Bristol	England	27,000	27,000	Grass
Turf Moor	Burnley	England	22,546	22,546	Grass/synthetic mix
Energy Check Stadium at Gigg Lane	Bury	England	11,376	11,376	Grass
The Abbey Stadium	Cambridge	England	8,696	4,278	Grass
Ninian Park	Cardiff	Wales	20,592	14,000	Grass
Brunton Park	Carlisle	England	18,046	8,000	Grass

The list is ordered by the primary key. stadium.capacity carries no index, so no capacity sort is offered here — it would be a filesort across 51,000 rows. The pitch type and ownership filters are both index-backed.