Mendrisio — Laravel

Identity

Nation: Switzerland
Local region: Ticino
Coordinates: 45.867, 8.983
Altitude: 386
Population band: —
Attraction: 2
First language: Italian influence 11, difficulty 5
Weather index: 69003592

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
FC Mendrisio-Stabio	Swiss First League Group 3	Campo Sportivo Communale	52
FC Stabio	Swiss Lower Division	Campo Sportivo Communale	18

Stadiums

Name	Capacity	Seating	Pitch	Built
Campo Sportivo Communale	4,260	260	—	—

People born here

Name	Kind	Nationality	Born
Patrick Foletti	Staff	Switzerland	1974-05-27
Pierluigi Tami	Staff	Switzerland	1961-09-12
Nicola Zari	Player	Italy	1984-10-01
Andrea Corrain	Staff	Switzerland	1963-09-15
Mijat Maric	Player	Switzerland	1984-04-30
Sandro Reclari	Player	Switzerland	1984-02-17
Marco Lodigiani	Player	Switzerland	1976-03-22
Mario Bigoni	Player	Switzerland	1984-07-18

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.