Chiclayo — Laravel

Identity

Nation: Peru
Local region: Lambayeque
Coordinates: -6.776566, -79.84648
Altitude: 27
Population band: —
Attraction: 14
First language: —
Weather index: 115815

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

Name	Division	Stadium	Reputation
Club Juan Aurich	Peruvian First Division	Elías Aguirre	116
Club Deportivo Pomalca	Peruvian Copa Peru	Elías Aguirre	10
Club Social Deportivo Atlético Boca Juniors	Peruvian Copa Peru	Elías Aguirre	4

Stadiums

Name	Capacity	Seating	Pitch	Built
Elías Aguirre	23,500	—	—	1968-01-01

People born here

Name	Kind	Nationality	Born
Roberto Merino Ramirez	Player	Peru	1982-05-19
Sergio Hernán Ubillús Segura	Player	Peru	1980-01-01
Juan Carlos Gutiérrez Contreras	Player	Peru	1981-05-21
Juan Carlos La Rosa Llontop	Player	Peru	1980-02-03
José Luis Guevara Tinoco	Player	Peru	1975-10-16
César Alberto Sánchez Aurich	Staff	Peru	1973-03-21
José Ramírez Cubas	Staff	Peru	1962-04-16
César Augusto García Bobadilla	Staff	Peru	1975-04-05
Miguel Angel Huertas del Águila	Player	Peru	1977-06-09
Pedro Gerardo Díaz Ruíz	Staff	Peru	1980-12-05
Wálter Ricardo Vílchez Soto	Player	Peru	1982-02-20
Jorge Alfredo Leiva Urbano	Player	Peru	1981-01-29
Fernando Rafael García López	Player	Peru	1987-07-21
Paul Aaron Pantoja Solano	Player	Peru	1979-11-04
Cruz Rodolfo Chávarry Monja	Staff	Peru	1961-02-05
Iván	Player	Peru	1984-03-07
Gustavo Enrique Vassallo Ferrari	Staff	Peru	1978-09-06
Carlos Miguel Meléndez Vásquez	Player	Peru	1978-09-04
Richard Oncoy	Player	Peru	1983-02-02
Marcos Abner Delgado Ocampo	Player	Peru	1988-02-17
Héctor Becerril Rodríguez	Staff	Peru	—
Hugo Seminario Vinces	Staff	Peru	—
Sinestor Díaz	Player	Peru	1989-07-27
Ronald Quintana	Staff	Peru	1980-07-13
Martín Antonio Valle Palomino	Player	Peru	1986-06-12

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.