Coldstream

Identity

Nation
Scotland
Local region
Scottish Borders
Coordinates
55.651321, -2.253399
Altitude
0
Population band
2
Attraction
2
First language
—
Weather index
7

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
Home Park 500 0 Grass —

People born here

Name Kind Nationality Born
David Lauder Staff Scotland 1943-07-24
Allan Wilson Staff Scotland 1952-06-26
Ben Wright Player Scotland 2003-04-02

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.