venues
Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · IE · HR · PT)
- 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)
- cert_number
- Certificate / registration number in the national register
- source
- Source register the row came from
223 rows where country = "RO", group = "stay" and rating_value = 5
This data as json, CSV (advanced)
Suggested facets: rating_scheme, rating_label, source_type, source_category
venue_type 6
- guesthouse 100
- villa 47
- hotel 44
- rural_agritourism 29
- aparthotel 2
- boat_lodging 1
family 5
- guesthouses 100
- self_catering_villas 47
- hotels 46
- rural 29
- other_stay 1
group 1
- stay · 223 ✖
country 1
- RO · 223 ✖
| Link | rowid ▼ | name | country | group | family | venue_type | type_granularity | rating_value | rating_scheme | rating_label | capacity_persons | rooms | city | municipality | address | lat | lng | valid_until | stop_date | source | source_type | source_category | cert_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39299 | 39299 | PERLA MĂRTINIEI | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 24 | 12 | Com. Şugag, Sat Mărtinie | ALBA | STR. Strada Valea Mărtiniei , NR. 81A | 45.792978 | 23.6022296 | 06.12.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 31129 | |
| 39438 | 39438 | MEDIEVAL | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 44 | 22 | Mun. Alba Iulia | ALBA | STR. Strada Militari , NR. 2 | 46.0671679 | 23.5722201 | 08.08.2018 | RO-SITUR | HOTEL | 5 - STELE | 17946 | |
| 39503 | 39503 | PARADISUL TRANSILVANIEI | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 16 | 8 | Mun. Blaj | ALBA | STR. Strada Horea , NR. 43 | 46.2002006 | 23.9470361 | 02.09.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 20771 | |
| 39530 | 39530 | CASA LA MESTECENI | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 10 | 5 | Mun. Sebeş, Sat Răhău | ALBA | STR. Strada Principală , NR. 1A | 45.9025466 | 23.6193564 | 16.12.2014 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 8985/6017 | |
| 39577 | 39577 | ROZSA | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 16 | 8 | Com. Dorobanţi, Sat Dorobanţi | ARAD | NR. 409 | 46.3468867 | 21.2410945 | 09.03.2021 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 22847 | |
| 39688 | 39688 | ANIROC SIGNATURE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 160 | 80 | Mun. Arad | ARAD | STR. Strada Vasile Goldiş , NR. 5 | 46.1709468 | 21.3134831 | 31.08.2023 | RO-SITUR | HOTEL | 5 - STELE | 35816 | |
| 39773 | 39773 | GRANT | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 20 | 10 | Mun. Arad | ARAD | STR. Strada Fulgerului , NR. 24 | 46.1967998 | 21.3036726 | 05.04.2022 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 24626 | |
| 40053 | 40053 | CASA BOIERULUI | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 6 | 3 | Com. Călineşti, Sat Călineşti | ARGEŞ | NR. 181 | 44.8290314 | 25.0402574 | 28.03.2016 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 29685 | |
| 40253 | 40253 | FLOAREA DE COLŢ | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 30 | 15 | Com. Nucşoara, Sat Nucşoara | ARGEŞ | 45.3743825 | 24.8051066 | 19.12.2016 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 30441 | ||
| 40682 | 40682 | CHARLOTTE BOUTIQUE | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 12 | 6 | Mun. Bacău | BACĂU | STR. Strada Cornişa Bistriţei , NR. 21D | 46.5510492 | 26.917063 | 19.12.2022 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 33126 | |
| 40886 | 40886 | SIAM | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 14 | 8 | Oraş Slănic Moldova | BACĂU | STR. Strada Porumbeilor , NR. 13 | 46.2041466 | 26.4331439 | 16.10.2023 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 15507 | |
| 41059 | 41059 | RAY | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - MARGARETE | 12 | 6 | Com. Cefa, Sat Cefa | BIHOR | NR. 488B | 46.917301 | 21.7114739 | 11.03.2025 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - MARGARETE | 41742 | |
| 41093 | 41093 | ACOM | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 16 | 8 | Com. Hidişelu de Sus, Sat Şumugiu | BIHOR | NR. 259B | 46.8895138 | 21.9712475 | 20.12.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 37371 | |
| 41176 | 41176 | DEXTRA | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 10 | 5 | Com. Sâniob, Sat Sâniob | BIHOR | 47.2683976 | 22.1359485 | 04.12.2020 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 22435 | ||
| 41268 | 41268 | LOTUS THERM | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 262 | 172 | Com. Sânmartin, Sat Băile Felix | BIHOR | STR. Strada Victoria , NR. 20 | 46.9895138 | 21.9758953 | 17.11.2015 | RO-SITUR | HOTEL | 5 - STELE | 1006/797 | |
| 41467 | 41467 | JOY | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 10 | 5 | Com. Sânmartin, Sat Sânmartin | BIHOR | STR. Strada Muntele Carmel , NR. 13 | 46.9996144 | 21.9630918 | 03.10.2023 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 36406 | |
| 41893 | 41893 | ANCORA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 16 | 8 | Mun. Salonta | BIHOR | STR. Strada Aradului | 46.7972612 | 21.6420096 | 02.05.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 34339 | |
| 41960 | 41960 | CONON | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 12 | 6 | Com. Bistriţa Bârgăului, Sat Bistriţa Bârgăului | BISTRIŢA-NĂSĂUD | NR. 1066 | 47.2093087 | 24.7608299 | 05.07.2021 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 23369 | |
| 42025 | 42025 | CURTEA LUI TOADER | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 12 | 6 | Com. Budacu de Jos, Sat Simioneşti | BISTRIŢA-NĂSĂUD | NR. 98 | 47.0662711 | 24.49882 | 06.10.2020 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 29311 | |
| 42056 | 42056 | EVA | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 10 | 5 | Com. Livezile, Sat Cuşma | BISTRIŢA-NĂSĂUD | NR. 29A | 47.1299206 | 24.705807 | 31.07.2023 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 35124 | |
| 42089 | 42089 | IMPERIAL | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 12 | 6 | Com. Rebra, Sat Rebra | BISTRIŢA-NĂSĂUD | NR. 255 | 47.33309 | 24.4946186 | 07.07.2021 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 23390 | |
| 42090 | 42090 | IZVORUL TAUSOARELOR | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 8 | 4 | Com. Rebrişoara, Sat Gersa II | BISTRIŢA-NĂSĂUD | NR. 47/C | 47.3696674 | 24.4679612 | 12.11.2021 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 24063 | |
| 42268 | 42268 | CONACUL SANCT GURGH | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 14 | 7 | Oraş Sângeorz-Băi | BISTRIŢA-NĂSĂUD | STR. Cartier Cormaia , NR. 117A | 47.400517 | 24.6661568 | 07.02.2022 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 24443 | |
| 42488 | 42488 | LE PROVENCE | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 20 | 10 | Com. Bran, Sat Bran | BRAŞOV | NR. 318A | 45.4968239 | 25.3901947 | 27.10.2010 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 10849/7139 | |
| 42747 | 42747 | AMBIENT | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 12 | 6 | Com. Cristian, Sat Cristian | BRAŞOV | STR. Strada Griviţei , NR. 9 | 45.6228507 | 25.4760748 | 02.06.2016 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 29913 | |
| 42752 | 42752 | CASA AMBIENT | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 8 | 5 | Com. Cristian, Sat Cristian | BRAŞOV | STR. Strada Griviţei , NR. 2 | 45.6238568 | 25.4760257 | 07.12.2023 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 37167 | |
| 42759 | 42759 | CONACUL AMBIENT | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 26 | 13 | Com. Cristian, Sat Cristian | BRAŞOV | STR. Strada Griviţei , NR. 1-5 | 45.6240017 | 25.4765658 | 27.10.2014 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 28040 | |
| 42760 | 42760 | CONACUL AMBIENT 2 | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 16 | 8 | Com. Cristian, Sat Cristian | BRAŞOV | STR. Strada Griviţei , NR. 1-5 | 45.6240017 | 25.4765658 | 08.12.2021 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 24158 | |
| 42775 | 42775 | RESORT AMBIENT | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 24 | 12 | Com. Cristian, Sat Cristian | BRAŞOV | STR. Strada Morii , NR. 23 | 45.6266464 | 25.4783281 | 02.10.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 30842 | |
| 42845 | 42845 | EUROPARK 1 | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 10 | 5 | Com. Fundata, Sat Fundăţica | BRAŞOV | NR. 219B | 45.433257 | 25.2978499 | 03.12.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 12079/7234 | |
| 42846 | 42846 | EUROPARK 2 | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 8 | 4 | Com. Fundata, Sat Fundăţica | BRAŞOV | NR. 219B | 45.433257 | 25.2978499 | 03.12.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 13808 | |
| 42867 | 42867 | DOMENIUL BURZENLAND | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 14 | 7 | Com. Hălchiu | BRAŞOV | STR. Noului , NR. 172, 173, 174 | 45.7612886 | 25.5404864 | 13.01.2026 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 45433 | |
| 43586 | 43586 | ARO PALACE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 396 | 198 | Mun. Braşov | BRAŞOV | STR. Bulevardul Eroilor , NR. 27 | 45.6453981 | 25.5910919 | 01.09.2011 | RO-SITUR | HOTEL | 5 - STELE | 1713/751 | |
| 43590 | 43590 | ARTEMIS | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 30 | 15 | Mun. Braşov | BRAŞOV | STR. Strada Fântâniţa Călugărului , NR. 5 | 45.596419 | 25.5552457 | 05.04.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 11803/7872 | |
| 44199 | 44199 | MONTI CHALET | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 20 | 10 | Mun. Braşov | BRAŞOV | STR. Strada Fântâniţa Călugărului | 45.5961843 | 25.555907 | 05.04.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 34258 | |
| 44317 | 44317 | RADISSON BLU AURUM BRAŞOV | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 220 | 110 | Mun. Braşov | BRAŞOV | STR. Bulevardul Eroilor , NR. 23 | 45.6449623 | 25.593145 | 20.12.2022 | RO-SITUR | HOTEL | 5 - STELE | 33196 | |
| 44327 | 44327 | RELAX IN STYLE | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 18 | 9 | Mun. Braşov | BRAŞOV | STR. Strada Stejerişului , NR. 27 | 45.6443349 | 25.5719103 | 14.11.2022 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 11089/7216 | |
| 44648 | 44648 | DENISA | RO | stay | guesthouses | guesthouse | normal | 5 | star | 5 - STELE | 22 | 11 | Mun. Braşov, Loc. Poiana Braşov | BRAŞOV | NR. 158 | 45.635352 | 25.6341924 | 27.09.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - STELE | 12712 | |
| 44675 | 44675 | SWISSOTEL POIANA BRAȘOV | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 144 | 64 | Mun. Braşov, Loc. Poiana Braşov | BRAŞOV | STR. DRUMUL SULINAR , NR. 9 | 45.5886111 | 25.5533668 | 17.01.2025 | RO-SITUR | HOTEL | 5 - STELE | 41121 | |
| 44706 | 44706 | IMPERIAL ONE LUXURY | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 20 | 10 | Mun. Făgăraş | BRAŞOV | STR. Strada Republicii , NR. 9 | 45.8444292 | 24.9690819 | 28.08.2023 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 35795 | |
| 45104 | 45104 | DAS FORT BOUTIQUE | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 18 | 9 | Oraş Râşnov | BRAŞOV | STR. Strada Ion Luca Caragiale , NR. 1 | 45.578359 | 25.458355 | 19.05.2022 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 24791 | |
| 45127 | 45127 | MAGGIE S RANCH | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 24 | 12 | Oraş Râşnov | BRAŞOV | STR. Strada Glăjăriei | 45.5277195 | 25.4403208 | 12.12.2013 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 27518 | |
| 45720 | 45720 | CASA LA MOARA DIN GRĂDINĂ | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 14 | 7 | Com. Eftimie Murgu, Sat Eftimie Murgu | CARAŞ-SEVERIN | NR. 81 | 44.8387138 | 22.129393 | 30.09.2021 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 20379 | |
| 45721 | 45721 | DANIELI | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 10 | 4 | Com. Eftimie Murgu, Sat Eftimie Murgu | CARAŞ-SEVERIN | NR. 294 | 44.8387138 | 22.129393 | 05.06.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 31601 | |
| 45842 | 45842 | MAPAMONT | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 28 | 14 | Com. Văliug, Sat Văliug | CARAŞ-SEVERIN | NR. 285 | 45.2255518 | 22.0291188 | 28.05.2026 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 47042 | |
| 46025 | 46025 | JOJO IMPERIAL RESORT & SPA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 30 | 15 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Vicol , NR. 48 | 44.8723402 | 22.4110596 | 31.08.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 20727 | |
| 46133 | 46133 | SUNGARDEN RESORT | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 84 | 45 | Com. Baciu, Sat Baciu | CLUJ | 46.8108691 | 23.4856338 | 18.02.2014 | RO-SITUR | HOTEL | 5 - STELE | 27659 | ||
| 46170 | 46170 | SALI CHALET | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 29 | 15 | Com. Băişoara, Sat Muntele Băişorii | CLUJ | NR. 326 F1 | 46.5311793 | 23.3057499 | 24.04.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 34224 | |
| 46173 | 46173 | TRANSILVANIA VILLA & SPA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 20 | 10 | Com. Băişoara, Sat Muntele Băişorii | CLUJ | NR. 327 | 46.5358842 | 23.3056894 | 08.12.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 31141 | |
| 46227 | 46227 | POIANA SOARELUI | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 30 | 15 | Com. Beliş, Sat Smida | CLUJ | NR. 12/A | 46.6414156 | 22.8835002 | 01.10.2019 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 20497 | |
| 46309 | 46309 | GRANDE VISTA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 56 | 25 | Com. Feleacu, Sat Feleacu | CLUJ | NR. 5/h | 46.7139067 | 23.616848 | 17.08.2023 | RO-SITUR | HOTEL | 5 - STELE | 35702 | |
| 46462 | 46462 | MANDALA RETREAT | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 12 | 6 | Com. Mărgău, Sat Răchiţele | CLUJ | NR. 298B , BL. C1 | 46.7152837 | 22.891139 | 05.08.2025 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 43485 | |
| 46594 | 46594 | ROGO CHALET | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - MARGARETE | 12 | 6 | Com. Săcuieu, Sat Rogojel | CLUJ | NR. 164 | 46.7867083 | 22.8482887 | 13.01.2026 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - MARGARETE | 45430 | |
| 46919 | 46919 | COLONIA FAGET SERENA | RO | stay | guesthouses | guesthouse | normal | 5 | star | 5 - STELE | 12 | 6 | Mun. Cluj-Napoca | CLUJ | STR. Strada Dumitru Brăharu | 46.7263162 | 23.5825045 | 03.11.2009 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - STELE | 9978/6407 | |
| 46988 | 46988 | ELANIA RESORT & SPA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 106 | 53 | Mun. Cluj-Napoca | CLUJ | STR. Strada Făgetului , NR. 74 | 46.7251457 | 23.579897864418 | 04.06.2025 | RO-SITUR | HOTEL | 5 - STELE | 42833 | |
| 47042 | 47042 | GRAND HOTEL ITALIA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 378 | 189 | Mun. Cluj-Napoca | CLUJ | STR. Strada Vasile Conta , NR. 2 | 46.7520955 | 23.6060333 | 26.10.2011 | RO-SITUR | HOTEL | 5 - STELE | 16067 | |
| 47199 | 47199 | OPERA PLAZA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 118 | 64 | Mun. Cluj-Napoca | CLUJ | STR. Strada G-ral Traian Moşoiu , NR. 10-12 | 46.7688698 | 23.6005709 | 06.07.2009 | RO-SITUR | HOTEL | 5 - STELE | 9738/6046 | |
| 47233 | 47233 | PLATINIA LUXURY SUITES | RO | stay | hotels | aparthotel | normal | 5 | star | 5 - STELE | 242 | 120 | Mun. Cluj-Napoca | CLUJ | STR. Calea Mănăştur , NR. 2-6 | 46.7703978 | 23.5962422 | 20.06.2022 | RO-SITUR | HOTEL APARTAMENT | 5 - STELE | 31162 | |
| 47251 | 47251 | RADISSON BLUE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 298 | 149 | Mun. Cluj-Napoca | CLUJ | STR. Aleea Stadionului , NR. 1 | 46.7675542 | 23.5735682 | 26.10.2022 | RO-SITUR | HOTEL | 5 - STELE | 1312/540 | |
| 47391 | 47391 | VIBRE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 98 | 49 | Mun. Cluj-Napoca | CLUJ | STR. Strada Constantin Brâncuşi , NR. 48-50 | 46.7652447 | 23.6050962 | 17.08.2023 | RO-SITUR | HOTEL | 5 - STELE | 35696 | |
| 47403 | 47403 | WYNDHAM | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 198 | 107 | Mun. Cluj-Napoca | CLUJ | STR. Calea Turzii , NR. 43-49 | 46.7644779 | 23.5986634 | 02.07.2024 | RO-SITUR | HOTEL | 5 - STELE | 17260 | |
| 47510 | 47510 | ISSA RESORT | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 150 | 75 | Mun. Turda | CLUJ | STR. Aleea Durgăului , NR. 6A | 46.5856067 | 23.7966332 | 18.06.2025 | RO-SITUR | HOTEL | 5 - STELE | 43010 | |
| 47530 | 47530 | SAREA-N BUCATE | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 26 | 13 | Mun. Turda | CLUJ | STR. Strada Dealul Viilor , NR. 2 | 46.5775505 | 23.7853751 | 17.11.2015 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 29018 | |
| 48702 | 48702 | THE PINES | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 16 | 8 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Liliacului , NR. 7B | 43.7966362 | 28.5425243 | 27.10.2020 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 21897 | |
| 48810 | 48810 | BELLE EPOQUE BOUTIQUE VILLA | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 13 | 7 | Mun. Constanţa | CONSTANŢA | STR. Bulevardul Tomis , NR. 16 , ET. 1-2 | 44.2047729 | 28.6200439 | 12.08.2016 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 30053 | |
| 49294 | 49294 | MAMAIA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 46 | 22 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2623995 | 28.6187463 | 28.03.2012 | RO-SITUR | HOTEL | 5 - STELE | 5921/3692 | ||
| 49391 | 49391 | VEGA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 222 | 111 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2572026 | 28.6207986 | 14.06.2011 | RO-SITUR | HOTEL | 5 - STELE | 57/1082 | ||
| 49521 | 49521 | NEW BELVEDERE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 97 | 49 | Mun. Mangalia | CONSTANŢA | STR. Aleea Teilor , NR. 6 | 43.8107589 | 28.5847333 | 25.04.2019 | RO-SITUR | HOTEL | 5 - STELE | 2366/232 | |
| 49663 | 49663 | MEDITERANEO 1 | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 8 | 4 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Trandafirilor , NR. 41B | 43.8660834 | 28.5973042 | 23.05.2019 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 1022/6695 | |
| 49664 | 49664 | MEDITERANEO 2 | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 8 | 4 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Trandafirilor , NR. 41B | 43.8660834 | 28.5973042 | 23.05.2019 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 19796 | |
| 49897 | 49897 | CARMEN INTERNAȚIONAL | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 196 | 98 | Mun. Mangalia, Loc. Venus | CONSTANŢA | STR. Strada Nicolae Iorga , NR. 34 | 43.8441663 | 28.5986112 | 10.06.2024 | RO-SITUR | HOTEL | 5 - STELE | 7831/5558 | |
| 50623 | 50623 | BOUTIQUE CITADEL | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 20 | 10 | Oraş Eforie, Loc. Eforie Sud | CONSTANŢA | STR. Strada Mării , NR. 48 , AP. nr. 1 | 44.0512416 | 28.642773 | 17.05.2022 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 18408 | |
| 50772 | 50772 | SEASCAPE VILLA | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 7 | 4 | Oraş Eforie, Loc. Eforie Sud | CONSTANŢA | STR. Strada Mării , NR. 46 | 44.0498001 | 28.6434201 | 10.06.2022 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 25006 | |
| 50876 | 50876 | ALFA | RO | stay | guesthouses | guesthouse | normal | 5 | star | 5 - STELE | 36 | 18 | Oraş Năvodari | CONSTANŢA | STR. Strada DC86 | 44.2998 | 28.6051 | 01.03.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - STELE | 11086/5392 | |
| 50883 | 50883 | ALMAR | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 16 | 8 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 70 | 44.2881245 | 28.6167283 | 20.09.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 29912 | |
| 51049 | 51049 | ARENA REGIA HOTEL & SPA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 142 | 62 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 77 | 44.2864209 | 28.6177113 | 18.09.2023 | RO-SITUR | HOTEL | 5 - STELE | 14571 | |
| 52199 | 52199 | PHOENICIA BOUTIQUE | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 78 | 39 | Oraş Năvodari | CONSTANŢA | NR. 95BIS | 44.2805663 | 28.6178599 | 19.02.2026 | RO-SITUR | HOTEL | 5 - STELE | 23332 | |
| 52205 | 52205 | PHOENICIA ROYAL | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 244 | 122 | Oraş Năvodari | CONSTANŢA | NR. 91 | 44.2802385 | 28.6201106 | 02.05.2018 | RO-SITUR | HOTEL | 5 - STELE | 30586 | |
| 52488 | 52488 | SIERA | RO | stay | guesthouses | guesthouse | normal | 5 | star | 5 - STELE | 28 | 14 | Oraş Năvodari | CONSTANŢA | STR. Strada C1 | 44.292582 | 28.6190362 | 24.05.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - STELE | 12669 | |
| 52967 | 52967 | CASA ALMAȘ | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 16 | 8 | Com. Barcani, Sat Barcani | COVASNA | STR. Strada Almaş , NR. 26, 28, 30 | 45.7016838 | 26.0900995 | 27.04.2026 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 46489 | |
| 53021 | 53021 | DOMENIUL TOMA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 32 | 15 | Com. Dobârlău, Sat Valea Dobârlăului | COVASNA | NR. 69a | 45.7286524 | 25.9343584 | 01.11.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 36675 | |
| 53045 | 53045 | CONACUL BENKE | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 36 | 15 | Com. Moacşa, Sat Moacşa | COVASNA | NR. 360 | 45.8715616 | 25.9699262 | 18.09.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 25672 | |
| 53108 | 53108 | NEW CASTLE | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 22 | 11 | Com. Zăbala, Sat Zăbala | COVASNA | NR. 437 | 45.887703 | 26.189789 | 25.10.2018 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 19074 | |
| 53282 | 53282 | CHALET ALPINA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 28 | 14 | Com. Moroeni, Sat Dobreşti | DÂMBOVIŢA | NR. 70928 | 45.3906083 | 25.4345338 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 18945 | ||
| 53290 | 53290 | PEȘTERA WELLNESS & SPA | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 172 | 95 | Com. Moroeni, Sat Dobreşti | DÂMBOVIŢA | STR. Strada Orzea , NR. 44 | 45.730116 | 24.983845 | 10.06.2025 | RO-SITUR | HOTEL | 5 - STELE | 3749/1482 | |
| 53292 | 53292 | FERMA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 22 | 11 | Com. Moroeni, Sat Glod | DÂMBOVIŢA | STR. Strada Principală , NR. 6 | 45.1793784 | 25.3858725 | 15.10.2009 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 13118 | |
| 53437 | 53437 | RIXOS | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 10 | 5 | Com. Cârcea, Sat Cârcea | DOLJ | STR. Strada Doljului , NR. 8 | 44.2759263 | 23.8755362 | 21.10.2015 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 28900 | |
| 53681 | 53681 | VALEA NEAGRA | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 6 | 3 | Com. Nămoloasa, Sat Nămoloasa | GALAŢI | 45.5337497 | 27.5520953 | 19.11.2014 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 27362 | ||
| 53682 | 53682 | VALEA NEAGRA | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 6 | 3 | Com. Nămoloasa, Sat Nămoloasa | GALAŢI | 45.5337497 | 27.5520953 | 19.11.2014 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 28229 | ||
| 53788 | 53788 | VIVA CLUB | RO | stay | hotels | hotel | normal | 5 | star | 5 - STELE | 60 | 30 | Mun. Galaţi | GALAŢI | NR. 4 | 45.4726964 | 28.0311562 | 21.02.2011 | RO-SITUR | HOTEL | 5 - STELE | 11485/7328 | |
| 53804 | 53804 | HANUL CĂLUGĂRENILOR | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 20 | 10 | Com. Călugăreni, Sat Călugăreni | GIURGIU | BL. clădire C6 | 44.1834954 | 25.9981703 | 18.07.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 10235/7835 | |
| 53821 | 53821 | BILA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 26 | 13 | Com. Ghimpaţi, Sat Naipu | GIURGIU | STR. Şoseaua Schitu , NR. 9 | 44.1544774 | 25.7597973 | 17.12.2024 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 41023 | |
| 53824 | 53824 | DOMENIUL GREACA | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - FLORI | 30 | 15 | Com. Greaca, Sat Greaca | GIURGIU | NR. 867 | 44.1102883 | 26.3312122 | 22.10.2019 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - FLORI | 16417 | |
| 54215 | 54215 | PARÂNG | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 26 | 13 | Mun. Târgu Jiu | GORJ | STR. Aleea Bicaz , NR. 23A | 45.0501714 | 23.269622 | 28.05.2025 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 42769 | |
| 54310 | 54310 | TRANSALPINA RETREAT | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 20 | 10 | Oraş Novaci | GORJ | STR. Strada Valea Gilortului , NR. 261 | 45.195766 | 23.671027 | 09.12.2025 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 40952 | |
| 54381 | 54381 | TIMIAN CHALET | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - FLORI | 16 | 8 | Com. Ciceu, Sat Ciaracio | HARGHITA | NR. 201 | 46.3763069 | 25.7184485 | 17.05.2023 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - FLORI | 34547 | |
| 55104 | 55104 | STRINDBERG | RO | stay | guesthouses | guesthouse | normal | 5 | flower | 5 - MARGARETE | 30 | 15 | Mun. Topliţa | HARGHITA | STR. Strada Măgura , NR. 24 | 46.9190624 | 25.3483696 | 30.09.2025 | RO-SITUR | PENSIUNE TURISTICĂ | 5 - MARGARETE | 44245 | |
| 55269 | 55269 | COCOȘEL | RO | stay | rural | rural_agritourism | normal | 5 | flower | 5 - MARGARETE | 16 | 8 | Com. Beriu, Sat Căstău | HUNEDOARA | NR. 130B | 45.814921 | 23.2085499 | 04.06.2025 | RO-SITUR | PENSIUNE AGROTURISTICĂ | 5 - MARGARETE | 42841 | |
| 55348 | 55348 | GASTHAUS | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 6 | 3 | Com. Ilia, Sat Ilia | HUNEDOARA | STR. Strada Ştefan cel Mare , NR. 9 | 45.9333186 | 22.6577775 | 26.08.2014 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 18511 | |
| 55599 | 55599 | HEAVEN | RO | stay | self_catering_villas | villa | normal | 5 | star | 5 - STELE | 20 | 10 | Mun. Deva | HUNEDOARA | STR. Strada 16 Februarie , NR. 17 B | 45.8938393 | 22.8987732 | 25.01.2023 | RO-SITUR | VILĂ TURISTICĂ | 5 - STELE | 33568 |
Advanced export
JSON shape: default, array, newline-delimited
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, "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");