venues

Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · PT · PL · IE · HR · GR · ME)

group
Top group: Stay / Eat & Drink / Other
family
Simplified family (Hotels, Guesthouses, Restaurants, Bars & Pubs…)
venue_type
Detailed canonical type (see the venue_types table)
type_granularity
'coarse' when the source lumps several real types (e.g. UK FSA)
rating_value
Normalized 1–5 grade, or blank if unrated
rating_scheme
star / key / flower / approved / none (see rating_schemes)
rating_label
Original rating string from the source (provenance)
source_type
Original type string from the national register (provenance)
source_category
Original category/rating field from the register
capacity_persons
Comparable headline capacity — beds/guests (stay) or seats (food)
rooms
Number of rooms / units (accommodation)
best_for
The single event this venue is best suited to (blank = not an event venue)
fit_wedding
Wedding-suitability score 0–100 (type + capacity + rating)
fit_conference
Conference-suitability score 0–100
fit_banquet
Banquet-suitability score 0–100
fit_spa
Spa-retreat-suitability score 0–100
fit_party
Party/celebration-suitability score 0–100
common_areas
On-site shared function space, from the register only (event_venue) — blank = not stated, never inferred
reachability_score
How easy to reach 0–100 (nearer airport + city = higher)
isolation_score
How remote 0–100 (farther from towns + fewer nearby venues = higher)
airport_km
Distance to nearest airport (km)
nearest_airport
Nearest airport (IATA or name)
city_km
Distance to nearest city ≥15k people (km)
town_km
Distance to nearest settlement ≥500 people (km)
venues_5km
Number of other venues within 5 km (local density)
cert_number
Certificate / registration number in the national register
source
Source register the row came from

55 rows where best_for = "wedding", family = "self_catering_villas" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, rating_label, fit_wedding, reachability_score, isolation_score, nearest_airport, town_km, city, municipality, source, source_type, source_category

country 3

rating_value 1

group 1

family 1

  • self_catering_villas · 55 ✖

best_for 1

  • wedding · 55 ✖

common_areas 0

Link rowid ▼ name country group family venue_type type_granularity rating_value rating_scheme rating_label capacity_persons rooms best_for fit_wedding fit_conference fit_banquet fit_spa fit_party common_areas reachability_score isolation_score airport_km nearest_airport city_km town_km venues_5km city municipality address lat lng valid_until stop_date source source_type source_category cert_number
23472 23472 DIAKONIA RO stay self_catering_villas villa normal 2 star 2 - STELE 99 35 wedding 55 0 0 0 0   80 0 6.8 CLJ 1.2 1.2 1234 Mun. Cluj-Napoca CLUJ STR. Strada Ponorului , NR. 1 46.7575538 23.6072588 06.07.2015   RO-SITUR VILĂ TURISTICĂ 2 - STELE 6045/5965
469962 469962 DREAM PARK ES stay self_catering_villas self_catering normal 2 star 2 191   wedding 65 0 0 0 0   80 0 7.1 VIT 1.8 1.8 49 Vitoria-Gasteiz Araba/Álava   42.850100103165 -2.65018405095321     ES-EUS Apartamentos 2 TVI00009
470012 470012 IRENAZ VITORIA ES stay self_catering_villas self_catering normal 2 star 2 208   wedding 65 0 0 0 0   80 10 3.1 VIT 2.5 2.5 53 Vitoria-Gasteiz Araba/Álava   42.8653011183222 -2.69498900655657     ES-EUS Apartamentos 2 TVI00012
470054 470054 SPIRIT APARTAMENTOS ATXURI ES stay self_catering_villas self_catering normal 2 star 2 222   wedding 65 0 0 0 0   80 0 5.8 BIO 0.6 0.6 180 Bilbao Bizkaia   43.2493799858494 -2.92024751993812     ES-EUS Apartamentos 2 TBI00011
470401 470401 APARTAMENTOS DIVAN ES stay self_catering_villas self_catering normal 2 star 2 160   wedding 65 0 0 0 0   80 10 3.5 VIT 2.1 2.1 53 Vitoria-Gasteiz Araba/Álava   42.8614682078712 -2.69352205146485     ES-EUS Apartamentos 2 TVI00020
470815 470815 COPLA BILBAO ES stay self_catering_villas self_catering normal 2 star 2 165   wedding 65 0 0 0 0   80 0 4.4 BIO 0.5 0.5 190 Bilbao Bizkaia   43.26472986 -2.93048095     ES-EUS Apartamentos 2 TBI00118
562547 562547 MAGALLUF PLAYA III ES stay self_catering_villas self_catering normal 2 key 2 claus 189 54 wedding 65 0 0 0 0   80 0 18.3 PMI 6.6 0.2 112 Magaluf CALVIÀ GALIO, 9. 07182 Magaluf, CALVIÀ, Mallorca 39.50994596009981 2.5329193699624604     ES-BAL Apartaments turístics 2 claus AT/1046
562549 562549 PARQUE MAR ES stay self_catering_villas self_catering normal 2 key 2 claus 544 150 wedding 65 0 0 0 0   55 0 47.1 PMI 13.8 1.8 82 Cala D´Or SANTANYÍ PARC DE LA MAR, S/N. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.36244870707152 3.229977371452841     ES-BAL Apartaments turístics 2 claus AT/1048
562552 562552 LAS PALOMAS APARTAMENTOS ECONOTELS ES stay self_catering_villas self_catering normal 2 key 2 claus 135 64 wedding 55 0 0 0 0   80 0 17.8 PMI 5.9 0.8 114 Palmanova CALVIÀ Carrer DUC D´EXTREMERA-SON MATIAS, 7. 07181 Palmanova, CALVIÀ, Mallorca 39.518148896074564 2.5354956253042378     ES-BAL Apartaments turístics 2 claus AT/1117
562572 562572 CALA BLANCA ES stay self_catering_villas self_catering normal 2 key 2 claus 84 30 wedding 55 0 0 0 0   80 0 17.7 PMI 6.1 0.6 113 Palmanova CALVIÀ DUC D´EXTREMERA, 8. 07181 Palmanova, CALVIÀ, Mallorca 39.51666417040613 2.5368509684666054     ES-BAL Apartaments turístics 2 claus AT/1258
562576 562576 HELIOS ES stay self_catering_villas self_catering normal 2 key 2 claus 108 36 wedding 55 0 0 0 0                 Can Pastilla PALMA CARABELA S/N, S/N         ES-BAL Apartaments turístics 2 claus AT/1266
562585 562585 LAS PIRAMIDES ES stay self_catering_villas self_catering normal 2 key 2 claus 282 94 wedding 65 0 0 0 0   65 0 45.7 PMI 1.8 0.4 98 Port D´Alcúdia ALCÚDIA Carrer MINERVA, 24. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca 39.83730938828573 3.122658315207254     ES-BAL Apartaments turístics 2 claus AT/1309
562589 562589 ALDEA CALA FORNELLS II ES stay self_catering_villas self_catering normal 2 key 2 claus 120 40 wedding 55 0 0 0 0   80 0 25.1 PMI 6.1 0.2 105 Peguera CALVIÀ Carrer L´ESPIGA, 9. 07160 Peguera, CALVIÀ, Mallorca 39.536011613577024 2.4464639853493497     ES-BAL Apartaments turístics 2 claus AT/1335
562595 562595 SIESTA I ES stay self_catering_villas self_catering normal 2 key 2 claus 436 166 wedding 65 0 0 0 0   65 0 44.3 PMI 2.8 1.1 104 Port D´Alcúdia ALCÚDIA Avinguda PERE MAS REUS, 23. 07400 Port D´Alcúdia, ALCÚDIA, Mallorca 39.830035491474796 3.1089855441052863     ES-BAL Apartaments turístics 2 claus AT/1357
562596 562596 VICTORIA ES stay self_catering_villas self_catering normal 2 key 2 claus 86 27 wedding 55 0 0 0 0                 Port D´Alcúdia ALCÚDIA Avinguda Minerva, 13. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1360
562597 562597 APARTAMENTOS MAC SURFING PLAYA ES stay self_catering_villas self_catering normal 2 key 2 claus 222 74 wedding 65 0 0 0 0                 Santa Ponça CALVIÀ Avinguda REI JAUME I, 83. 07180 Santa Ponça, CALVIÀ, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1362
562603 562603 Apartamentos Cristina I ES stay self_catering_villas self_catering normal 2 key 2 claus 160 40 wedding 65 0 0 0 0   55 0 55.1 PMI 15.0 0.7 123 Cala Millor SON SERVERA Carrer S´AMETLER, 21. 07560 Cala Millor, SON SERVERA, Mallorca 39.60426457958191 3.3782139456157725     ES-BAL Apartaments turístics 2 claus AT/1427
562604 562604 Apartamentos Cristina II ES stay self_catering_villas self_catering normal 2 key 2 claus 168 34 wedding 65 0 0 0 0   55 0 55.1 PMI 15.0 0.7 123 Cala Millor SON SERVERA Carrer S´AMETLER, 21. 07560 Cala Millor, SON SERVERA, Mallorca 39.60426457958191 3.3782139456157725     ES-BAL Apartaments turístics 2 claus AT/1428
562606 562606 DON QUIJOTE ES stay self_catering_villas self_catering normal 2 key 2 claus 124 24 wedding 55 0 0 0 0   55 0 61.1 PMI 23.4 0.9 99 Cala Rajada CAPDEPERA CALA AGULLA, 117. 07590 Cala Rajada, CAPDEPERA, Mallorca 39.69703116581444 3.4273579135649506     ES-BAL Apartaments turístics 2 claus AT/1460
562607 562607 Apartamentos R2 Cala Millor ES stay self_catering_villas self_catering normal 2 key 2 claus 111 20 wedding 55 0 0 0 0   55 0 55.5 PMI 15.3 0.6 122 Cala Millor SON SERVERA Carrer SOL NAIXENT, S/N, S/N. 07560 Cala Millor, SON SERVERA, Mallorca 39.60067058961981 3.383389488649412     ES-BAL Apartaments turístics 2 claus AT/1462
562610 562610 APARTAMENTOS MARINA PALMANOVA ES stay self_catering_villas self_catering normal 2 key 2 claus 96 20 wedding 55 0 0 0 0   80 0 17.7 PMI 5.6 0.5 114 Palmanova CALVIÀ GERMANS MONCADA, 11. 07181 Palmanova, CALVIÀ, Mallorca 39.52073368489146 2.536095309801492     ES-BAL Apartaments turístics 2 claus AT/1490
562614 562614 FERRER TAMARINDOS ES stay self_catering_villas self_catering normal 2 key 2 claus 88 44 wedding 55 0 0 0 0   65 0 45.5 PMI 1.8 0.3 98 Port D´Alcúdia ALCÚDIA Carrer CIBELES, 1. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca 39.83688332737392 3.12059066706489     ES-BAL Apartaments turístics 2 claus AT/1522
562620 562620 CASA VIDA ES stay self_catering_villas self_catering normal 2 key 2 claus 109 45 wedding 55 0 0 0 0   80 0 22.5 PMI 6.2 0.7 157 Santa Ponça CALVIÀ VIA REY SANCHO,10, S/N. 07180 Santa Ponça, CALVIÀ, Mallorca 39.5132828925812 2.4815259506025833     ES-BAL Apartaments turístics 2 claus AT/1544
562621 562621 BELLAMAR ES stay self_catering_villas self_catering normal 2 key 2 claus 81 27 wedding 55 0 0 0 0   65 0 48.1 PMI 5.8 1.2 56 Port De Pollença POLLENÇA Passeig LONDRES, 56. 07470 Port De Pollença, POLLENÇA, Mallorca 39.89677546122196 3.0785280176501035     ES-BAL Apartaments turístics 2 claus AT/1546
562623 562623 CALA DOR PARK ES stay self_catering_villas self_catering normal 2 key 2 claus 218 73 wedding 65 0 0 0 0   55 0 46.7 PMI 12.7 0.4 93 Cala D´Or SANTANYÍ RAVELL, S/N, S/N. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.375327992834116 3.23252197725693     ES-BAL Apartaments turístics 2 claus AT/1550
562641 562641 PINOS MAR III ES stay self_catering_villas self_catering normal 2 key 2 claus 85 17 wedding 55 0 0 0 0   80 0 17.7 PMI 5.5 0.4 114 Palmanova CALVIÀ Carrer COSTA I LLOBERA, 1. 07181 Palmanova, CALVIÀ, Mallorca 39.52161651771559 2.5360182950142227     ES-BAL Apartaments turístics 2 claus AT/1640
562645 562645 CLUB SA COMA ES stay self_catering_villas self_catering normal 2 key 2 claus 126 52 wedding 55 0 0 0 0   55 10 54.5 PMI 14.1 3.2 114 Coma (La) SANT LLORENÇ DES CARDASSAR CARDS, 63. 07560 Coma (La), SANT LLORENÇ DES CARDASSAR, Mallorca 39.57821728435168 3.3736471967506105     ES-BAL Apartaments turístics 2 claus AT/1656
562651 562651 FLOR LOS ALMENDROS ES stay self_catering_villas self_catering normal 2 key 2 claus 150 60 wedding 65 0 0 0 0   80 0 25.1 PMI 6.0 0.1 105 Peguera CALVIÀ PAGUERA, 34. 07160 Peguera, CALVIÀ, Mallorca 39.537004690476884 2.447006456856714     ES-BAL Apartaments turístics 2 claus AT/1686
562652 562652 PLAYAMAR ES stay self_catering_villas self_catering normal 2 key 2 claus 93 31 wedding 55 0 0 0 0   55 10 54.3 PMI 13.9 4.3 104 Illot (L´) SANT LLORENÇ DES CARDASSAR PONENT S/N, S/N. 07687 Illot (L´), SANT LLORENÇ DES CARDASSAR, Mallorca 39.56764564670292 3.3719055886656943     ES-BAL Apartaments turístics 2 claus AT/1692
562655 562655 EMBAT ES stay self_catering_villas self_catering normal 2 key 2 claus 105 40 wedding 55 0 0 0 0   80 0 2.9 PMI 6.7 0.3 134 Can Pastilla PALMA Carrer NANSES, 7. 07610 Can Pastilla, PALMA, Mallorca 39.5343493951466 2.714387115516954     ES-BAL Apartaments turístics 2 claus AT/1703
562658 562658 SUN CLUB EL DORADO ES stay self_catering_villas self_catering normal 2 key 2 claus 120 40 wedding 55 0 0 0 0                 Tolleric LLUCMAJOR Carrer Cap Blanc, KM 11. 07609 Tolleric, LLUCMAJOR, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1710
562682 562682 PINS D´OR ES stay self_catering_villas self_catering normal 2 key 2 claus 103 41 wedding 55 0 0 0 0   55 0 46.5 PMI 12.6 0.5 90 Cala D´Or SANTANYÍ ARIEL, 3. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.37561747195265 3.230080227592677     ES-BAL Apartaments turístics 2 claus AT/1788
562683 562683 Playa Moreia ES stay self_catering_villas self_catering normal 2 key 2 claus 385 169 wedding 65 0 0 0 0                 L´Illot-Cala Morlanda MANACOR Camí DE LA MAR, 2. 07687 L´Illot-Cala Morlanda, MANACOR, Mallorca         ES-BAL Apartaments turístics 2 claus AT/1789
562689 562689 Apartamentos Vista Alegre ES stay self_catering_villas self_catering normal 2 key 2 claus 163 49 wedding 65 0 0 0 0   55 20 49.7 PMI 10.6 2.2 16 Cala Anguila-Cala Mendia MANACOR Avinguda MARCO POLO, S/N. 07689 Cala Anguila-Cala Mendia, MANACOR, Mallorca 39.52372415058657 3.3173893570314497     ES-BAL Apartaments turístics 2 claus AT/1811
562690 562690 SOLECITO ES stay self_catering_villas self_catering normal 2 key 2 claus 105 32 wedding 55 0 0 0 0   65 0 45.2 PMI 1.8 0.8 96 Port D´Alcúdia ALCÚDIA TUCAN, 31. 07410 ALCÚDIA, Mallorca 39.83861546086485 3.1129953421228262     ES-BAL Apartaments turístics 2 claus AT/1813
562693 562693 Apartamentos R2 Cala Millor II ES stay self_catering_villas self_catering normal 2 key 2 claus 94 20 wedding 55 0 0 0 0   55 0 55.5 PMI 15.3 0.6 122 Cala Millor SON SERVERA Carrer SOL NAIXENT, S/N, S/N. 07560 Cala Millor, SON SERVERA, Mallorca 39.60067058961981 3.383389488649412     ES-BAL Apartaments turístics 2 claus AT/1820
562720 562720 PALM GARDEN ES stay self_catering_villas self_catering normal 2 key 2 claus 166 83 wedding 65 0 0 0 0   65 0 44.3 PMI 2.8 1.1 104 Port D´Alcúdia ALCÚDIA REINA SOFIA S/N, S/N. 07410 Port D´Alcúdia, ALCÚDIA, Mallorca 39.830035491474796 3.1089855441052863     ES-BAL Apartaments turístics 2 claus AT/1913
562729 562729 PLAYAMAR II ES stay self_catering_villas self_catering normal 2 key 2 claus 85 40 wedding 55 0 0 0 0   55 10 54.3 PMI 13.9 4.3 104 Illot (L´) SANT LLORENÇ DES CARDASSAR PONENT, S/N. 07687 Illot (L´), SANT LLORENÇ DES CARDASSAR, Mallorca 39.56764564670292 3.3719055886656943     ES-BAL Apartaments turístics 2 claus AT/1950
562730 562730 SUN BEACH ES stay self_catering_villas self_catering normal 2 key 2 claus 212 106 wedding 65 0 0 0 0   80 0 22.5 PMI 5.6 1.2 150 Santa Ponça CALVIÀ Carrer RAMON MONCADA, 25. 07180 Santa Ponça, CALVIÀ, Mallorca 39.51941930223986 2.4800893959759502     ES-BAL Apartaments turístics 2 claus AT/1964
562735 562735 BQ ALCUDIA SUN VILLAGE ES stay self_catering_villas self_catering normal 2 key 2 claus 358 165 wedding 65 0 0 0 0   65 10 43.0 PMI 4.6 2.5 101 Platja De Muro MURO CIRCUIT DEL LLAC, LAS GAVIOTAS, 60. 07440 Platja De Muro, MURO, Mallorca 39.812519109244185 3.110574373827398     ES-BAL Apartaments turístics 2 claus AT/1988
562739 562739 EUROPA ES stay self_catering_villas self_catering normal 2 key 2 claus 84 40 wedding 55 0 0 0 0   55 10 54.4 PMI 14.0 3.4 113 Coma (La) SANT LLORENÇ DES CARDASSAR Carrer DÀLIES, 30. 07560 Coma (La), SANT LLORENÇ DES CARDASSAR, Mallorca 39.576192395965336 3.3722923816123034     ES-BAL Apartaments turístics 2 claus AT/2000
562740 562740 SOL DE ALCUDIA ES stay self_catering_villas self_catering normal 2 key 2 claus 318 144 wedding 65 0 0 0 0   65 0 44.8 PMI 2.3 0.6 98 Port D´Alcúdia ALCÚDIA Carrer TORTORA, 1. 07400 Port D´Alcúdia, ALCÚDIA, Mallorca 39.832929752655794 3.113665716720843     ES-BAL Apartaments turístics 2 claus AT/2010
562757 562757 GRAN BAHIA ES stay self_catering_villas self_catering normal 2 key 2 claus 98 46 wedding 55 0 0 0 0   55 0 42.7 PMI 10.1 0.2 62 Can Picafort SANTA MARGALIDA Carrer ALMIRANTE CERVERA, 2. 07458 Can Picafort, SANTA MARGALIDA, Mallorca 39.76535686920324 3.15276277662137     ES-BAL Apartaments turístics 2 claus AT/2071
562762 562762 HOLIDAY PARK ES stay self_catering_villas self_catering normal 2 key 2 claus 240 120 wedding 65 0 0 0 0   80 0 22.1 PMI 5.4 1.4 163 Santa Ponça CALVIÀ RAMON DE MONCADA, 35. 07180 Santa Ponça, CALVIÀ, Mallorca 39.5201794678382 2.4842470531653187     ES-BAL Apartaments turístics 2 claus AT/2087
562777 562777 PLAYA FERRERA ES stay self_catering_villas self_catering normal 2 key 2 claus 209 57 wedding 65 0 0 0 0   55 0 46.8 PMI 12.5 0.3 99 Cala Ferrera FELANITX CALA FERRERA,SOL.72, S/N. 07200 Cala Ferrera, FELANITX, Mallorca 39.38024607081473 3.2362587000533134     ES-BAL Apartaments turístics 2 claus AT/2139
562802 562802 VILLA REAL ES stay self_catering_villas self_catering normal 2 key 2 claus 98 32 wedding 55 0 0 0 0   80 0 27.2 PMI 7.7 0.4 86 Camp De Mar ANDRATX Via FRANCISCA CAPLLONCH PLOMER, 6. 07160 Camp De Mar, ANDRATX, Mallorca 39.541328762934185 2.422357622404522     ES-BAL Apartaments turístics 2 claus AT/2180
562830 562830 PLAYA DOR ES stay self_catering_villas self_catering normal 2 key 2 claus 162 27 wedding 65 0 0 0 0   55 0 46.9 PMI 13.0 0.5 90 Cala D´Or SANTANYÍ S´ESTEL,S/N, S/N. 07660 Cala D´Or, SANTANYÍ, Mallorca 39.37336645537579 3.2340630158931862     ES-BAL Apartaments turístics 2 claus AT/588
562833 562833 SOL Y VERA ES stay self_catering_villas self_catering normal 2 key 2 claus 265 91 wedding 65 0 0 0 0   80 0 18.5 PMI 6.9 0.6 107 Magaluf CALVIÀ S´OLIVERA, 5. 07181 Magaluf, CALVIÀ, Mallorca 39.5064545289283 2.531750742654123     ES-BAL Apartaments turístics 2 claus AT/634
562838 562838 MAGALLUF PLAYA I ES stay self_catering_villas self_catering normal 2 key 2 claus 216 54 wedding 65 0 0 0 0   80 0 18.1 PMI 6.7 0.2 110 Magaluf CALVIÀ Carrer GALIO, 3. 07182 Magaluf, CALVIÀ, Mallorca 39.509686561129385 2.534405592575529     ES-BAL Apartaments turístics 2 claus AT/809
725756 725756 MARINA REY ES stay self_catering_villas self_catering normal 2 key 2 Llaves 788 203 wedding 65 0 0 0 0   55 10 64.0 LEI 23.0 3.2 3024 VERA ALMERÍA PARCELA R1 Y R2 PERI COSTA REY Compl.Dom. CALLE SOTAVENTO NUM. 2 37.20947973735327 -1.813881903507484     ES-AND Conjunto 2 Llaves A/AL/00254
725757 725757 FINESTHOMES MARBELLA ES stay self_catering_villas self_catering normal 2 key 2 Llaves 127 17 wedding 55 0 0 0 0   65 0 37.7 AGP 1.9 1.9 5045 MARBELLA MÁLAGA CALLE TALES DE MILETO Nº 1 36.508759 -4.866671000000001     ES-AND Conjunto 2 Llaves A/MA/01498
820923 820923 Astra HR stay self_catering_villas self_catering normal 2 star 2* 488   wedding 65 0 0 0 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Zelena Laguna 18 45.2305 13.7186     HR-MINT Turistički apartmani 2*  
820924 820924 Horizont (ex Horizont-Splendid) HR stay self_catering_villas self_catering normal 2 star 2* 540   wedding 65 0 0 0 0   80 0 2.8 PUY 5.4 0.0 33 Pula Istarska Verudella 6b 44.8689 13.9161     HR-MINT Turistički apartmani 2*  
820925 820925 Lanterna Sunny Resort by Valamar (ex Lanterna) HR stay self_catering_villas self_catering normal 2 star 2* 2277   wedding 65 0 0 0 0   70 20 20.1 POW 29.9 1.4 5 Vabriga Istarska Ulica Lanterna 11 45.29167 13.61333     HR-MINT Turistički apartmani 2*  
821760 821760 Klek HR stay self_catering_villas self_catering normal 2 star 2* 188   wedding 65 0 0 0 0   45 30 44.0 OMO 48.6 4.8 3 Klek Dubrovačko-neretvanska Trg palmi 1 42.94472 17.56389     HR-MINT Turistički apartmani 2*  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE venues ("name" TEXT, "country" TEXT, "group" TEXT, "family" TEXT, "venue_type" TEXT, "type_granularity" TEXT, "rating_value" INTEGER, "rating_scheme" TEXT, "rating_label" TEXT, "capacity_persons" INTEGER, "rooms" INTEGER, "best_for" TEXT, "fit_wedding" INTEGER, "fit_conference" INTEGER, "fit_banquet" INTEGER, "fit_spa" INTEGER, "fit_party" INTEGER, "common_areas" TEXT, "reachability_score" INTEGER, "isolation_score" INTEGER, "airport_km" REAL, "nearest_airport" TEXT, "city_km" REAL, "town_km" REAL, "venues_5km" INTEGER, "city" TEXT, "municipality" TEXT, "address" TEXT, "lat" REAL, "lng" REAL, "valid_until" TEXT, "stop_date" TEXT, "source" TEXT, "source_type" TEXT, "source_category" TEXT, "cert_number" TEXT);
CREATE INDEX idx_country ON venues("country");
CREATE INDEX idx_group ON venues("group");
CREATE INDEX idx_family ON venues("family");
CREATE INDEX idx_venue_type ON venues("venue_type");
CREATE INDEX idx_rating_value ON venues("rating_value");
CREATE INDEX idx_rating_scheme ON venues("rating_scheme");
CREATE INDEX idx_city ON venues("city");
CREATE INDEX idx_best_for ON venues("best_for");
CREATE INDEX idx_common_areas ON venues("common_areas");