Hamilton

Identity

Local region
—
Coordinates
-37.787001, 175.279253
Altitude
31
Population band
—
Attraction
5
First language
—
Weather index
138222

city.weather_index is a raw index. There is no weather lookup table and no weather entity in the export, so the number is shown as it is stored and is not turned into a climate. Population band and attraction are likewise raw source scales. The local region comes from local_region, which is a separate id space from region and is not interchangeable with it. Altitude is in metres.

Clubs

Stadiums

Name Capacity Seating Pitch Built
Porritt Stadium 5,700 1,000 — —
Gower Park 750 150 — —
Waikato Stadium 25,800 25,800 — —
Galloway Park — — — —
Beetham Park — — — —

People born here

Name Kind Nationality Born
Archibald Gerald Thompson Player Australia 1978-10-23
Chadwick Reuben Coombes Staff New Zealand 1983-09-09
Christopher Grant Wood Player New Zealand 1991-12-07
Aaron Scott Player New Zealand 1986-07-18
Nathan Holten Player New Zealand 1986-05-28
Gareth Morgan Staff New Zealand 1953-02-17
Jordan Casey Player New Zealand 1998-09-08
Michael Built Player New Zealand 1992-11-12
Ryan Thomas Player New Zealand 1994-12-20
Steven John Holloway Player New Zealand 1985-04-10
Daniel Finlay Player New Zealand 1990-08-14
Marco Rodrigo Rojas Player New Zealand 1991-11-05
Sam Margetts Player New Zealand 1990-11-10
Adam Wallis Player New Zealand 1992-08-12
Matt Hastings Staff New Zealand 1986-08-05
Tyler Lissette Player New Zealand 1991-06-23
Peter Overmire Player New Zealand 1993-07-10
Ben Latham Player New Zealand 1990-10-09
Jarrod Young Player New Zealand 1995-07-03
Mark Cossey Staff New Zealand —
Josh Margetts Player New Zealand 1992-11-04
Logan Tipene Rogerson Player New Zealand 1998-05-28
Jarrod Hastings Player New Zealand 1992-08-11
Stafford Dowling Player New Zealand 1999-01-01
Hamish Smylie Player New Zealand 1995-09-03

Born shows the full date where one is recorded and the year alone where only person.year_of_birth is. A person with neither a player nor a staff row is badged unclassified rather than assigned a subtype.