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
10,603 rows where country = "RO", family = "guesthouses" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: rating_label, source_type, source_category
venue_type 2
- rooms_to_rent 7,749
- guesthouse 2,854
group 1
- stay 10,603
family 1
- guesthouses · 10,603 ✖
country 1
- RO · 10,603 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38914 | 38914 | POIANA SAŞILOR | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 18 | 9 | 45.4048717 | 25.7678849 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33091 | |||||
| 38922 | 38922 | CASA CRISTALINA & DUMI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 16 | 7 | Com. Albac, Sat Albac | ALBA | STR. Strada Crişan , NR. 74 | 46.4529317 | 22.9546794 | 21.10.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 21746 | |
| 38923 | 38923 | CASA DIN PARC | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Albac, Sat Albac | ALBA | STR. Strada Crişan , NR. 60C | 46.2775979 | 23.06286 | 23.03.2026 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 46227 | |
| 38926 | 38926 | CERNAT | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 4 | Com. Albac, Sat Albac | ALBA | STR. Strada Cloşca , NR. 41 | 46.4417768 | 22.9669298 | 22.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33249 | |
| 38931 | 38931 | MERY | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 10 | 5 | Com. Albac, Sat Albac | ALBA | STR. Strada Horea , NR. 27 | 46.4488841 | 22.9653161 | 17.08.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 8511/5885 | |
| 38932 | 38932 | STEAUA ARIEŞULUI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 52 | 26 | Com. Albac, Sat Albac | ALBA | STR. Strada Crişan , NR. 60 | 46.452808 | 22.954159 | 02.02.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 10155/6236 | |
| 38935 | 38935 | CASA MARIA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Albac, Sat Cioneşti | ALBA | NR. 8 | 46.4517887 | 22.9755255 | 27.11.2015 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 29206 | |
| 38937 | 38937 | CLA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 7 | Com. Albac, Sat Dealu Lămăşoi | ALBA | NR. 8 | 46.4858618 | 22.9836361 | 28.05.2025 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 42780 | |
| 38946 | 38946 | PERLA APUSENILOR | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 98 | 49 | Com. Albac, Sat Pleşeşti | ALBA | NR. 30A | 46.4469616 | 22.9399791 | 26.05.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 23173 | |
| 38948 | 38948 | LA TOPIVAN | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 20 | 10 | Com. Albac, Sat Rogoz | ALBA | NR. 1A | 46.4282075 | 22.9613178 | 07.07.2015 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 11556/8098 | |
| 38950 | 38950 | CASA DAVID | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 8 | Com. Almaşu Mare, Sat Cib | ALBA | NR. 160 | 46.0543933 | 23.1913833 | 13.11.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 12663/2664 | |
| 38956 | 38956 | CASA BINU | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 17 | 46.4766597 | 22.7512398 | 28.10.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20659 | |
| 38958 | 38958 | CASA DE VIS | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Arieşeni, Sat Arieşeni | ALBA | 46.4747681 | 22.7616423 | 16.04.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19599 | ||
| 38967 | 38967 | GIANINA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 20 | 10 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 31A | 46.4767851 | 22.7543707 | 05.10.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 12211/8100 | |
| 38968 | 38968 | LA VASILE | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 29 | 15 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 16 | 46.476397 | 22.7559676 | 22.05.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 12229/8584 | |
| 38970 | 38970 | SARRA VANK | RO | stay | guesthouses | guesthouse | normal | 3 | star | 3 - STELE | 24 | 12 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 29A | 46.4767851 | 22.7543707 | 01.08.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - STELE | 12359/8864 | |
| 38971 | 38971 | SIMONA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 12 | 6 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 3F | 46.4767851 | 22.7543707 | 15.04.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 10135/7549 | |
| 38972 | 38972 | SKY HUB | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 24 | 12 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 352B | 46.4625566 | 22.7776309 | 02.08.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 10082/5379 | |
| 38975 | 38975 | VALEA BRAZILOR | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - MARGARETE | 14 | 8 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 33A | 46.476431 | 22.747297 | 15.04.2024 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - MARGARETE | 25742 | |
| 38976 | 38976 | VANESA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 57 | 46.4762351 | 22.7396601 | 14.02.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 31312 | |
| 38977 | 38977 | VANESA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 8 | Com. Arieşeni, Sat Arieşeni | ALBA | NR. 57 | 46.4762351 | 22.7396601 | 03.01.2017 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 30491 | |
| 38980 | 38980 | ANDREEA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 8 | Com. Arieşeni, Sat Bubeşti | ALBA | 46.506757 | 22.698283 | 21.09.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 15787 | ||
| 38981 | 38981 | ANDREEA - MARIA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 18 | 10 | Com. Arieşeni, Sat Bubeşti | ALBA | 46.4994983 | 22.7065417 | 08.02.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 31302 | ||
| 38984 | 38984 | CASA GYL | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 8 | 4 | Com. Arieşeni, Sat Bubeşti | ALBA | NR. 68 | 46.4994983 | 22.7065417 | 12.05.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 24773 | |
| 38985 | 38985 | COTA 1000 | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Arieşeni, Sat Bubeşti | ALBA | NR. 80 A | 46.5015959 | 22.7032457 | 28.09.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 30231 | |
| 38986 | 38986 | DIANA ŞI LARISA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Arieşeni, Sat Bubeşti | ALBA | NR. 81/C | 46.0852098 | 23.5617656 | 05.08.2015 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 28669 | |
| 38989 | 38989 | VALEA ARIEŞULUI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Arieşeni, Sat Bubeşti | ALBA | NR. 75H | 46.5063228 | 22.6986572 | 27.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33351 | |
| 38991 | 38991 | VRAJA MUNTELUI | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 27 | 12 | Com. Arieşeni, Sat Bubeşti | ALBA | NR. 76A | 46.5051118 | 22.7036806 | 05.05.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 10530/7411 | |
| 38995 | 38995 | CASA DENISA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Arieşeni, Sat Dealu Bajului | ALBA | NR. 252 | 46.4576436 | 22.7780022 | 08.02.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 31301 | |
| 38997 | 38997 | CASA PATRICIA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Arieşeni, Sat Dealu Bajului | ALBA | NR. 229 | 46.4576436 | 22.7780022 | 30.10.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20680 | |
| 39000 | 39000 | CASA CERBU | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 5 | Com. Arieşeni, Sat Faţa Cristesei | ALBA | NR. 315 | 46.4855826 | 22.7496184 | 27.10.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 21887 | |
| 39001 | 39001 | CASA DAN | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 20 | 10 | Com. Arieşeni, Sat Faţa Cristesei | ALBA | NR. 288 | 46.4855826 | 22.7496184 | 18.04.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19660 | |
| 39002 | 39002 | PANTURISM | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 18 | 9 | Com. Arieşeni, Sat Faţa Cristesei | ALBA | NR. 264A | 46.4855826 | 22.7496184 | 27.10.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 28434 | |
| 39003 | 39003 | SOFY | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 20 | 10 | Com. Arieşeni, Sat Faţa Cristesei | ALBA | NR. 288A | 46.4855826 | 22.7496184 | 08.07.2015 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 28435 | |
| 39007 | 39007 | CASA COSMINA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 9 | 6 | Com. Arieşeni, Sat Galbena | ALBA | NR. 424 | 46.4640273 | 22.7349567 | 01.02.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 22691 | |
| 39008 | 39008 | CASA DINTRE BRAZI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Arieşeni, Sat Galbena | ALBA | NR. 414A | 46.4703003 | 22.7378854 | 19.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33136 | |
| 39010 | 39010 | CASA MONA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 6 | Com. Arieşeni, Sat Galbena | ALBA | NR. 383 | 46.4773408 | 22.7340672 | 30.10.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20672 | |
| 39012 | 39012 | CASA NICO NELU DUPLEX | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 1 | Com. Arieşeni, Sat Galbena | ALBA | NR. 426B | 46.4700756 | 22.7379715 | 21.09.2023 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 36126 | |
| 39014 | 39014 | CASA RALUCA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 16 | 8 | Com. Arieşeni, Sat Galbena | ALBA | NR. 392 | 46.4711678 | 22.7300433 | 24.10.2024 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20652 | |
| 39017 | 39017 | IARA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 14 | 7 | Com. Arieşeni, Sat Galbena | ALBA | 46.4767818 | 22.7535599 | 27.09.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 11446/8496 | ||
| 39018 | 39018 | MONTANA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 12 | 6 | Com. Arieşeni, Sat Galbena | ALBA | NR. 424/A | 46.4711678 | 22.7300433 | 12.04.2016 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 29792 | |
| 39020 | 39020 | VALEA GALBENEI | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - MARGARETE | 16 | 8 | Com. Arieşeni, Sat Galbena | ALBA | NR. 397 | 46.4711678 | 22.7300433 | 31.10.2022 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - MARGARETE | 28831 | |
| 39021 | 39021 | ZÂNA VĂII | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 32 | 15 | Com. Arieşeni, Sat Galbena | ALBA | NR. 424B | 46.4641267 | 22.7362814 | 11.11.2015 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 12357 | |
| 39024 | 39024 | CASA NATALIA & RAISA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 13 | 6 | Com. Arieşeni, Sat Izlaz | ALBA | NR. 477 | 46.4829998 | 22.7214604 | 18.04.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19661 | |
| 39031 | 39031 | CASA EMILIA ARIEŞENI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 5 | Com. Arieşeni, Sat Pănteşti | ALBA | NR. 534/A | 46.4758141 | 22.7773594 | 08.12.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 24184 | |
| 39032 | 39032 | WILD ARIESENI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Arieşeni, Sat Ştei-Arieşeni | ALBA | NR. 624 | 46.4688338 | 22.7502658 | 21.09.2023 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 36123 | |
| 39038 | 39038 | POIENIŢA MOŢILOR | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 7 | Com. Avram Iancu, Sat Orgeşti | ALBA | NR. 587 | 46.3819071 | 22.7909331 | 14.03.2022 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 24535 | |
| 39047 | 39047 | CASA MOŢILOR | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 8 | 3 | Com. Bucium, Sat Bucium | ALBA | NR. 43 | 46.2615626 | 23.1209891 | 01.10.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 29789 | |
| 39048 | 39048 | LA MĂTUŞA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 5 | Com. Bucium, Sat Bucium | ALBA | NR. 23 | 46.2615626 | 23.1209891 | 19.10.2016 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 30242 | |
| 39052 | 39052 | GIULIA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 11 | 4 | Com. Bucium, Sat Izbita | ALBA | NR. 368 | 46.2435463 | 23.1403548 | 30.01.2014 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 27613 | |
| 39058 | 39058 | CĂSUȚA CU BRAZI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Ciugud, Sat Şeuşa | ALBA | STR. Strada Ioan Oprean , NR. 120 | 46.0591563 | 23.6274676 | 04.08.2025 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 43471 | |
| 39080 | 39080 | ANA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 18 | 9 | Com. Fărău, Sat Sânbenedic | ALBA | NR. 5 | 46.3149463 | 24.0459518 | 05.04.2016 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 29758 | |
| 39093 | 39093 | CASA BUNĂ | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 28 | 12 | Com. Gârbova, Sat Reciu | ALBA | 45.8650605 | 23.674016 | 04.12.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 13162 | ||
| 39095 | 39095 | CĂPRIOARA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 13 | 5 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 97 E | 46.45434 | 22.8133413 | 08.08.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 17807 | |
| 39096 | 39096 | CASA ALEX | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 15 | 8 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 130A | 46.4708063 | 22.8321845 | 28.10.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20658 | |
| 39098 | 39098 | CASA EDMA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 5 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 142 | 46.471007 | 22.8168923 | 09.08.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 17822 | |
| 39100 | 39100 | CASA IULY | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 8 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 96A | 46.4567265 | 22.80613 | 01.09.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 20732 | |
| 39101 | 39101 | CASA IUNIA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - MARGARETE | 16 | 7 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 94A | 46.4563788 | 22.8102461 | 26.04.2021 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - MARGARETE | 23042 | |
| 39102 | 39102 | CASA NEGOIESCU | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 16 | 8 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 101C | 46.4580358 | 22.800567 | 18.04.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19657 | |
| 39104 | 39104 | DANCIU | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 30 | 15 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 51 | 46.45434 | 22.8133413 | 04.04.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 8507/5391 | |
| 39105 | 39105 | DIGS | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 19 | 8 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 95 | 46.456623 | 22.8092765 | 16.10.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 6549/3893 | |
| 39106 | 39106 | EMANUEL | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 22 | 8 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 131A | 46.45434 | 22.8133413 | 20.12.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 37392 | |
| 39110 | 39110 | MAMA UŢA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 25 | 13 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 97 | 46.4568635 | 22.805182 | 28.09.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 14107 | |
| 39111 | 39111 | MARYDOR | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 21 | 9 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 64 | 46.453097 | 22.822685 | 25.01.2012 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 16470 | |
| 39113 | 39113 | ONELIA | RO | stay | guesthouses | guesthouse | normal | 3 | star | 3 - STELE | 40 | 20 | Com. Gârda de Sus, Sat Gârda de Sus | ALBA | NR. 98B | 46.4563802 | 22.8022573 | 08.04.2016 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - STELE | 16350 | |
| 39116 | 39116 | CASA SUVENIRURILOR | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 5 | Com. Gârda de Sus, Sat Gheţari | ALBA | NR. 235/B | 46.4918026 | 22.8188259 | 05.09.2024 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19628 | |
| 39119 | 39119 | CONACUL SAMFIREI | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 14 | 6 | Com. Gârda de Sus, Sat Izvoarele | ALBA | NR. 8 | 46.4579234 | 22.8470327 | 28.09.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 27552 | |
| 39126 | 39126 | CĂSUŢA DIN POVEŞTI | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 7 | Com. Horea, Sat Horea | ALBA | STR. Strada Nicola Vasile Ursu , NR. 23 | 46.4997283 | 22.9505161 | 01.10.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 30119 | |
| 39131 | 39131 | OLD CHALET | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 4 | 2 | Com. Horea, Sat Horea | ALBA | STR. Strada Nicola Vasile Ursu , NR. 67A | 46.501291 | 22.9491144 | 11.02.2026 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 45628 | |
| 39134 | 39134 | ALEX OLAR NEW ONE | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 20 | 10 | Com. Horea, Sat Mătişeşti | ALBA | NR. 340 A | 46.5046097 | 22.9097164 | 24.11.2023 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 36971 | |
| 39135 | 39135 | ALEXOLAR | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 6 | 3 | Com. Horea, Sat Mătişeşti | ALBA | NR. 340 A | 46.5046097 | 22.9097164 | 08.08.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 17817 | |
| 39136 | 39136 | APUSENI AIR LUNA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 400E | 46.5069962 | 22.9061388 | 25.03.2026 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 46286 | |
| 39137 | 39137 | APUSENI AIR SOARE | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 400E | 46.5069962 | 22.9061388 | 25.03.2026 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 46287 | |
| 39139 | 39139 | CASA ARISTOCRATĂ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 448 | 46.5099297 | 22.9044748 | 07.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32822 | |
| 39140 | 39140 | CASA BOEMA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 448 | 46.5098748 | 22.9045185 | 07.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32824 | |
| 39141 | 39141 | CASA DE PE LAC | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 448 | 46.5136875 | 22.9058125 | 07.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32821 | |
| 39144 | 39144 | CASA NORDICA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 448 | 46.5100276 | 22.9044474 | 07.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32819 | |
| 39145 | 39145 | CASA REINTERPRETATĂ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 2 | 1 | Com. Horea, Sat Mătişeşti | ALBA | NR. 448 | 46.5098203 | 22.9045452 | 07.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32823 | |
| 39151 | 39151 | COTA 1600 PETREASA | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 10 | 5 | Com. Horea, Sat Petreasa | ALBA | NR. 800 | 46.5361053 | 22.9424224 | 27.05.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 23192 | |
| 39154 | 39154 | CASA DE VACANŢĂ LA MOŞU VASILICĂ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 6 | 3 | Com. Ighiu, Sat Bucerdea Vinoasa | ALBA | NR. 104 | 46.162994 | 23.5258832 | 28.02.2023 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33721 | |
| 39156 | 39156 | HANUL SF.GHEORGHE | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 16 | 8 | Com. Ighiu, Sat Ighiu | ALBA | NR. 50 | 46.1456489709292 | 23.5162387221206 | 04.02.2026 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 3991/1648 | |
| 39159 | 39159 | FRIENDLY GREEN | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 8 | 4 | Com. Ighiu, Sat Şard | ALBA | NR. 425 G | 46.12337 | 23.5311306 | 05.09.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32096 | |
| 39166 | 39166 | CASA DINTRE VII | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 8 | Com. Jidvei, Sat Jidvei | ALBA | STR. Strada Gării , NR. 33 | 46.2226645 | 24.1098947 | 01.03.2022 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 27047 | |
| 39170 | 39170 | CASA DE VACANŢĂ VĂLIŞOARA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 6 | 1 | Com. Livezile, Sat Vălişoara | ALBA | NR. 172 | 46.388229 | 23.5607031 | 25.01.2021 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 14229 | |
| 39175 | 39175 | GALAXY | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - MARGARETE | 16 | 8 | Com. Lupşa, Sat Luncă | ALBA | NR. 58 | 46.3798194 | 23.2271817 | 25.07.2013 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - MARGARETE | 27042 | |
| 39176 | 39176 | CASA APUSEANA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 25 | 15 | Com. Lupşa, Sat Mănăstire | ALBA | NR. 1035 | 46.3789596 | 23.1750177 | 28.03.2011 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 8120/7435 | |
| 39178 | 39178 | CASA AMPOIŢANĂ | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 16 | 8 | Com. Meteş, Sat Ampoiţa | ALBA | NR. 13C | 46.1182608 | 23.4735226 | 29.05.2023 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 10105/7355 | |
| 39179 | 39179 | CĂSUŢA DE SUB PĂDURE | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 4 | 1 | Com. Meteş, Sat Ampoiţa | ALBA | NR. 199 D | 46.1184403 | 23.4638471 | 08.09.2020 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 20876 | |
| 39196 | 39196 | STONE GARDEN | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 8 | 4 | Com. Ocoliş, Sat Vidolm | ALBA | NR. 42 | 46.4801084 | 23.5117947 | 01.10.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 21344 | |
| 39203 | 39203 | IEDERA | RO | stay | guesthouses | guesthouse | normal | 3 | flower | 3 - FLORI | 10 | 5 | Com. Pianu, Sat Pianu de Sus | ALBA | STR. Strada Principală , NR. 534 | 45.9053678 | 23.4747941 | 08.08.2018 | RO-SITUR | PENSIUNE TURISTICĂ | 3 - FLORI | 13385 | |
| 39212 | 39212 | FRIENDS CHALET | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Râmeţ, Sat Valea Inzelului | ALBA | NR. 64 | 46.333899 | 23.5074715 | 28.05.2025 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 42773 | |
| 39226 | 39226 | AGOTTA 2 | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Rimetea, Sat Rimetea | ALBA | STR. Strada Principală , NR. 278 | 46.4535574 | 23.5671787 | 27.11.2018 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19196 | |
| 39227 | 39227 | ANDRÁS VENDÉGHÁZ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 4 | 2 | Com. Rimetea, Sat Rimetea | ALBA | STR. Strada Principală , NR. 219 | 46.3032584 | 23.1197619 | 04.12.2024 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 40850 | |
| 39229 | 39229 | BITAI | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 4 | 2 | Com. Rimetea, Sat Rimetea | ALBA | NR. 1 | 46.4486122 | 23.5658991 | 01.02.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 22693 | |
| 39232 | 39232 | CASA BOTAR | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 7 | Com. Rimetea, Sat Rimetea | ALBA | NR. 231 | 46.4555745 | 23.5641646 | 16.09.2021 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 23742 | |
| 39233 | 39233 | CASA DE VACANȚĂ "ZABPATAK" | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 6 | 3 | Com. Rimetea, Sat Rimetea | ALBA | STR. Strada Principală , NR. 130 | 46.4537195 | 23.5708645 | 28.05.2025 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 40851 | |
| 39235 | 39235 | CASA EXIGUL | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 6 | 2 | Com. Rimetea, Sat Rimetea | ALBA | NR. 176 | 46.4523988 | 23.5675171 | 06.12.2022 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 32696 | |
| 39236 | 39236 | CASA KIRALY VENDEGHAZ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 17 | 7 | Com. Rimetea, Sat Rimetea | ALBA | NR. 173/A | 46.4568176 | 23.5659942 | 15.05.2019 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 19755 | |
| 39238 | 39238 | CASA RITA & BENCE VENDEGHAZ | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 8 | 4 | Com. Rimetea, Sat Rimetea | ALBA | NR. 172 | 46.4513677 | 23.5682645 | 27.10.2020 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 21688 | |
| 39239 | 39239 | CASA SIMON | RO | stay | guesthouses | rooms_to_rent | normal | 3 | star | 3 - STELE | 14 | 6 | Com. Rimetea, Sat Rimetea | ALBA | NR. 151 | 46.4529846 | 23.566412 | 09.02.2023 | RO-SITUR | CAMERE DE ÎNCHIRIAT | 3 - STELE | 33625 |
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");