Getafe

Identity

Nation
Spain
Local region
Madrid
Coordinates
40.308, -3.732
Altitude
—
Population band
—
Attraction
8
First language
Spanish influence 18, difficulty 4
Weather index
67015504

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
Coliseum Alfonso Pérez 17,000 17,000 — 1998-08-30
Ciudad Deportiva 5,000 — — —
Polideportivo Juan de la Cierva 5,000 — — —

People born here

Name Kind Nationality Born
Alfonso Staff Spain 1972-09-26
Alberto Lucio Cobo Staff Spain 1974-04-18
Francisco Pavón Barahona Player Spain 1980-01-09
David Gascón Cordero Player Spain 1978-04-11
Roberto Player Spain 1979-05-13
Juan Carlos Arévalo Aguilar Staff Spain 1961-12-09
Manuel García Calderón García Staff Spain 1953-09-28
Luis Sánchez Duque Staff Spain 1956-11-13

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.