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
1,089 rows where country = "RO", family = "hotels" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: rating_label, source_type, source_category
venue_type 3
- hotel 966
- motel 113
- aparthotel 10
group 1
- stay 1,089
family 1
- hotels · 1,089 ✖
country 1
- RO · 1,089 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39083 | 39083 | BLEUMARIN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 22 | 11 | Com. Galda de Jos, Sat Galda de Jos | ALBA | 46.1816893 | 23.6566509 | 07.04.2011 | RO-SITUR | MOTEL | 3 - STELE | 11697/7475 | ||
| 39273 | 39273 | ASTORIA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 69 | 30 | Com. Sântimbru, Sat Sântimbru | ALBA | STR. Drumul DN 1 | 46.1395397 | 23.6376987 | 23.05.2012 | RO-SITUR | HOTEL | 3 - STELE | 12724/8710 | |
| 39298 | 39298 | NEDEI HOTEL & SPA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 80 | 40 | Com. Şugag, Sat Mărtinie | ALBA | STR. Strada Luncii , NR. 42B | 45.7973968 | 23.6148127 | 29.07.2021 | RO-SITUR | HOTEL | 3 - STELE | 23547 | |
| 39389 | 39389 | CAROLINA HERITAGE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 27 | 15 | Mun. Alba Iulia | ALBA | STR. Piaţa Unirii , NR. 11 | 46.0691156 | 23.5705453 | 15.02.2023 | RO-SITUR | HOTEL | 3 - STELE | 33703 | |
| 39397 | 39397 | CETATE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 216 | 104 | Mun. Alba Iulia | ALBA | STR. Piaţa Unirii , NR. 3 | 46.0699016 | 23.5696515 | 09.07.2024 | RO-SITUR | HOTEL | 3 - STELE | 921 | |
| 39411 | 39411 | ELISABETA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 92 | 49 | Mun. Alba Iulia | ALBA | STR. Strada Aleea Vilelor , NR. 4 | 46.0860794 | 23.5617206 | 21.05.2021 | RO-SITUR | HOTEL | 3 - STELE | 30672 | |
| 39419 | 39419 | HERMES | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 42 | 19 | Mun. Alba Iulia | ALBA | STR. Strada Toporaşilor , NR. 20 | 46.0753981 | 23.5595508 | 14.09.2012 | RO-SITUR | HOTEL | 3 - STELE | 11404/7890 | |
| 39433 | 39433 | MARISS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 57 | 28 | Mun. Alba Iulia | ALBA | STR. Strada Viilor , NR. 39 | 46.0535521 | 23.5701201 | 24.03.2014 | RO-SITUR | HOTEL | 3 - STELE | 27811 | |
| 39517 | 39517 | FAN | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 84 | 36 | Mun. Sebeş | ALBA | STR. Strada Drumul Sibiului , NR. 45 | 45.9476014 | 23.5874321 | 16.11.2021 | RO-SITUR | HOTEL | 3 - STELE | 12497/7477 | |
| 39525 | 39525 | YVY | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 57 | 29 | Mun. Sebeş | ALBA | STR. Strada Mihail Kogălniceanu , NR. 61 | 45.9764178 | 23.5566242 | 18.08.2023 | RO-SITUR | HOTEL | 3 - STELE | 35710 | |
| 39526 | 39526 | ALLEGRIA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 124 | 63 | Mun. Sebeş, Loc. Lancrăm | ALBA | NR. 9 | 45.9849776 | 23.5554968 | 14.01.2016 | RO-SITUR | HOTEL | 3 - STELE | 27380 | |
| 39600 | 39600 | CODRU MOMA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 204 | 102 | Com. Moneasa, Sat Moneasa | ARAD | 46.4603468 | 22.2535709 | 12.09.2019 | RO-SITUR | HOTEL | 3 - STELE | 1024/321 | ||
| 39614 | 39614 | PANORAMIC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 46 | 23 | Com. Moneasa, Sat Moneasa | ARAD | 46.4603468 | 22.2535709 | 23.03.2011 | RO-SITUR | HOTEL | 3 - STELE | 14056 | ||
| 39615 | 39615 | PARC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 102 | 47 | Com. Moneasa, Sat Moneasa | ARAD | 46.4624161 | 22.2603649 | 08.07.2015 | RO-SITUR | HOTEL | 3 - STELE | 5046/3308 | ||
| 39618 | 39618 | SÂNTANA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 84 | 41 | Com. Moneasa, Sat Moneasa | ARAD | NR. 74 | 46.4603468 | 22.2535709 | 25.07.2013 | RO-SITUR | HOTEL | 3 - STELE | 27036 | |
| 39667 | 39667 | IOANIS | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 42 | 20 | Com. Vladimirescu, Sat Mândruloc | ARAD | NR. 379/A | 46.144684 | 21.4624123 | 06.07.2015 | RO-SITUR | MOTEL | 3 - STELE | 7610/5209 | |
| 39686 | 39686 | ANA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 32 | 16 | Mun. Arad | ARAD | STR. Calea Radnei , NR. 133 | 46.1790234 | 21.3511016 | 30.03.2011 | RO-SITUR | HOTEL | 3 - STELE | 14115 | |
| 39692 | 39692 | ARAD | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 49 | 24 | Mun. Arad | ARAD | STR. Bulevardul Decebal , NR. 9 | 46.1731963 | 21.3189087 | 23.08.2021 | RO-SITUR | HOTEL | 3 - STELE | 4837/3054 | |
| 39741 | 39741 | COANDI | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 99 | 51 | Mun. Arad | ARAD | STR. Calea Romanilor , NR. 47 | 46.1612414 | 21.3231912 | 07.09.2009 | RO-SITUR | HOTEL | 3 - STELE | 9408/5261 | |
| 39745 | 39745 | CRISANA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 42 | 21 | Mun. Arad | ARAD | STR. Strada Petru Rareş , NR. 24 | 46.1921158 | 21.3312212 | 18.02.2011 | RO-SITUR | HOTEL | 3 - STELE | 13247/7305 | |
| 39749 | 39749 | DAROSY | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 34 | 17 | Mun. Arad | ARAD | STR. Calea Victoriei , NR. 2C | 46.183611 | 21.309606 | 01.11.2018 | RO-SITUR | HOTEL | 3 - STELE | 6194/3868 | |
| 39772 | 39772 | GIO | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 75 | 36 | Mun. Arad | ARAD | NR. 3 | 46.1679216 | 21.3182705 | 25.08.2011 | RO-SITUR | HOTEL | 3 - STELE | 11338/7936 | |
| 39776 | 39776 | HANUL DE LA RĂSCRUCE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 69 | 32 | Mun. Arad | ARAD | NR. F.N. | 46.2054786 | 21.1906356 | 06.11.2025 | RO-SITUR | HOTEL | 3 - STELE | 18018 | |
| 39779 | 39779 | IBIS STYLES ARAD | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 144 | 72 | Mun. Arad | ARAD | STR. Calea Aurel Vlaicu , NR. 306 | 46.2032504 | 21.2478826 | 05.09.2018 | RO-SITUR | HOTEL | 3 - STELE | 18916 | |
| 39781 | 39781 | IRIS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 54 | 26 | Mun. Arad | ARAD | NR. 1 | 46.1715719 | 21.3042347 | 12.10.2012 | RO-SITUR | HOTEL | 3 - STELE | 8582/5940 | |
| 39795 | 39795 | M CITY | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 20 | 10 | Mun. Arad | ARAD | STR. Calea Radnei , NR. 163 | 46.177532 | 21.356598 | 29.11.2023 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 37118 | |
| 39802 | 39802 | MAXIM | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 64 | 32 | Mun. Arad | ARAD | STR. Calea Radnei , NR. 122 | 46.1803396 | 21.3433137 | 11.03.2021 | RO-SITUR | HOTEL | 3 - STELE | 10804/7033 | |
| 39803 | 39803 | MIKY | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 76 | 38 | Mun. Arad | ARAD | STR. Calea Radnei , NR. 231 | 46.1759734 | 21.3655141 | 27.08.2014 | RO-SITUR | HOTEL | 3 - STELE | 18454 | |
| 39820 | 39820 | PRESIDENT | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 58 | 29 | Mun. Arad | ARAD | STR. Calea Timişorii , NR. 164 | 46.1422618 | 21.3208731 | 01.08.2011 | RO-SITUR | HOTEL | 3 - STELE | 5145/5369 | |
| 39863 | 39863 | XE-MAR | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 31 | 16 | Mun. Arad | ARAD | STR. Piaţa Eroilor , NR. 1 | 46.1583565 | 21.3221171 | 18.02.2011 | RO-SITUR | HOTEL | 3 - STELE | 11336/7310 | |
| 39867 | 39867 | CRIS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 55 | 25 | Oraş Chişineu-Criş | ARAD | STR. Strada Înfrăţirii | 46.5239525 | 21.5180281 | 12.01.2022 | RO-SITUR | HOTEL | 3 - STELE | 13369 | |
| 39871 | 39871 | CENTRAL | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 48 | 24 | Oraş Ineu | ARAD | STR. Calea Republicii , NR. 21 | 46.4248845 | 21.8346096 | 02.12.2011 | RO-SITUR | HOTEL | 3 - STELE | 11885/8447 | |
| 39873 | 39873 | HANUL MOARA CU NOROC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 41 | 23 | Oraş Ineu | ARAD | 46.4310262 | 21.840539 | 06.07.2015 | RO-SITUR | HOTEL | 3 - STELE | 27376 | ||
| 39877 | 39877 | STEJARII | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 46 | 23 | Oraş Ineu | ARAD | STR. Strada Lacului , NR. 3 | 46.4105515 | 21.8225233 | 11.03.2021 | RO-SITUR | HOTEL | 3 - STELE | 17975 | |
| 39891 | 39891 | JACKSON | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 49 | 23 | Oraş Nădlac | ARAD | 46.166437 | 20.7237905 | 30.09.2020 | RO-SITUR | HOTEL | 3 - STELE | 21319 | ||
| 39944 | 39944 | PÂRÂUL CAPRA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 36 | 18 | Com. Arefu, Sat Arefu | ARGEŞ | 45.3355809 | 24.5996176 | 20.08.2021 | RO-SITUR | HOTEL | 3 - STELE | 1663/819 | ||
| 39945 | 39945 | PISCUL NEGRU | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 108 | 54 | Com. Arefu, Sat Arefu | ARGEŞ | 45.5546062990405 | 24.6008747219513 | 12.02.2026 | RO-SITUR | HOTEL | 3 - STELE | 13000 | ||
| 39949 | 39949 | SIESTA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 35 | 18 | Com. Arefu, Sat Arefu | ARGEŞ | 45.329334248848 | 24.6216094482299 | 18.10.2011 | RO-SITUR | HOTEL | 3 - STELE | 8076/7796 | ||
| 39996 | 39996 | NET | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 28 | 15 | Com. Bascov, Sat Bascov | ARGEŞ | 44.8902101 | 24.8195596 | 14.12.2016 | RO-SITUR | HOTEL | 3 - STELE | 30424 | ||
| 39998 | 39998 | SORELO | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 54 | 27 | Com. Bascov, Sat Bascov | ARGEŞ | NR. 7 | 44.8892515 | 24.8230993 | 11.08.2010 | RO-SITUR | HOTEL | 3 - STELE | 10933/7003 | |
| 40237 | 40237 | MAGIC TRAVALE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 38 | 19 | Com. Moşoaia, Sat Smeura | ARGEŞ | 44.8480956 | 24.8502118 | 27.04.2011 | RO-SITUR | HOTEL | 3 - STELE | 11933/7586 | ||
| 40442 | 40442 | THR CENTER | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 32 | 16 | Mun. Curtea de Argeş | ARGEŞ | STR. Bulevardul Basarabilor , NR. 125 | 45.1426903 | 24.6762267 | 27.10.2020 | RO-SITUR | HOTEL | 3 - STELE | 21921 | |
| 40450 | 40450 | ARGES | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 92 | 46 | Mun. Piteşti | ARGEŞ | STR. Piaţa Muntenia , NR. 3 | 44.856343 | 24.8733322 | 22.11.2010 | RO-SITUR | HOTEL | 3 - STELE | 779/334 | |
| 40461 | 40461 | CARMEN | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 46 | 21 | Mun. Piteşti | ARGEŞ | STR. Bulevardul Republicii , NR. 84 | 44.8563696 | 24.8717678 | 14.04.2021 | RO-SITUR | HOTEL | 3 - STELE | 6662/4054 | |
| 40464 | 40464 | CELLY | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 64 | 32 | Mun. Piteşti | ARGEŞ | 44.8582938 | 24.8915751 | 13.08.2009 | RO-SITUR | HOTEL | 3 - STELE | 9636/6241 | ||
| 40466 | 40466 | COMPLEX HOTELIER ALCADIBO CENTER | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 72 | 36 | Mun. Piteşti | ARGEŞ | NR. 70 | 44.8578413 | 24.8732255 | 26.10.2011 | RO-SITUR | HOTEL | 3 - STELE | 8303/5545 | |
| 40472 | 40472 | CORNUL VÂNĂTORULUI BUSINESS CLASS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 76 | 50 | Mun. Piteşti | ARGEŞ | STR. Strada Trivale , NR. 75 | 44.8539111 | 24.8360768 | 12.08.2010 | RO-SITUR | HOTEL | 3 - STELE | 15653/7021 | |
| 40479 | 40479 | DUET | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 28 | 16 | Mun. Piteşti | ARGEŞ | STR. Intrarea Rahovei , NR. 27 | 44.8555653 | 24.8660965 | 17.09.2010 | RO-SITUR | HOTEL | 3 - STELE | 10932/7079 | |
| 40490 | 40490 | HONOR | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 44 | 22 | Mun. Piteşti | ARGEŞ | STR. Aleea Negoiul , NR. 2 | 44.8704409 | 24.856133 | 21.09.2017 | RO-SITUR | HOTEL | 3 - STELE | 13236 | |
| 40503 | 40503 | MAGIC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 30 | 15 | Mun. Piteşti | ARGEŞ | STR. Strada Armand Călinescu , NR. 16 | 44.857444 | 24.8689782 | 22.11.2010 | RO-SITUR | HOTEL | 3 - STELE | 6374/5149 | |
| 40517 | 40517 | REGAT | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 29 | 15 | Mun. Piteşti | ARGEŞ | STR. Bulevardul Republicii , NR. 7 | 44.8608188 | 24.8662856 | 19.10.2011 | RO-SITUR | HOTEL | 3 - STELE | 9084/5783 | |
| 40537 | 40537 | YAKY CENTER | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 90 | 45 | Mun. Piteşti | ARGEŞ | STR. Bulevardul Republicii , NR. 57 | 44.8559049 | 24.8731618 | 12.06.2012 | RO-SITUR | HOTEL | 3 - STELE | 12748/8763 | |
| 40541 | 40541 | GRANDIS APULUM | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 50 | 25 | Oraş Mioveni, Loc. Mioveni | ARGEŞ | NR. 144 | 44.9507843 | 24.9255937 | 25.05.2010 | RO-SITUR | HOTEL | 3 - STELE | 13458 | |
| 40628 | 40628 | LA CAPU DACULUI | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 29 | 13 | Com. Orbeni, Sat Orbeni | BACĂU | 46.282463 | 26.9870163 | 22.12.2010 | RO-SITUR | MOTEL | 3 - STELE | 8601/5394 | ||
| 40646 | 40646 | LEVISTICUM | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 69 | 34 | Com. Sărata, Sat Sărata | BACĂU | 46.5031154 | 26.8704878 | 18.06.2012 | RO-SITUR | MOTEL | 3 - STELE | 12107/8766 | ||
| 40669 | 40669 | BISTRIŢA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 75 | 49 | Mun. Bacău | BACĂU | STR. Strada Luminii , NR. 3 | 46.5646912 | 26.912392 | 08.09.2020 | RO-SITUR | HOTEL | 3 - STELE | 9939/4912 | |
| 40671 | 40671 | BOHEMIA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 48 | 24 | Mun. Bacău | BACĂU | NR. 2 Bis | 46.5681696 | 26.8907926 | 29.08.2017 | RO-SITUR | HOTEL | 3 - STELE | 29362 | |
| 40674 | 40674 | C&C RESIDENCE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 29 | 16 | Mun. Bacău | BACĂU | STR. Calea Mărăşeşti , NR. 108 | 46.5492025 | 26.9134898 | 28.12.2016 | RO-SITUR | HOTEL | 3 - STELE | 30435 | |
| 40687 | 40687 | DECEBAL | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 186 | 92 | Mun. Bacău | BACĂU | STR. Bulevardul Ioniţă Sandu Sturza , NR. 2 | 46.5655773 | 26.9113495 | 18.10.2011 | RO-SITUR | HOTEL | 3 - STELE | 3471/210 | |
| 40693 | 40693 | ELLERO | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 34 | 17 | Mun. Bacău | BACĂU | STR. Calea Dr. Alexandru Şafran , NR. 10 | 46.5397576 | 26.9046059 | 03.02.2021 | RO-SITUR | HOTEL | 3 - STELE | 16192 | |
| 40725 | 40725 | SELENA MOTOR SPORT | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 34 | 17 | Mun. Bacău | BACĂU | STR. Strada Chimiei , NR. 12 | 46.53329 | 26.92462 | 22.12.2009 | RO-SITUR | MOTEL | 3 - STELE | 6613/4027 | |
| 40843 | 40843 | DOBRU | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 86 | 43 | Oraş Slănic Moldova | BACĂU | STR. Strada Armoniei , NR. 2 | 46.2036377 | 26.4369276 | 27.10.2016 | RO-SITUR | HOTEL | 3 - STELE | 1079/39 | |
| 40854 | 40854 | EUROSANCLINIC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 32 | 16 | Oraş Slănic Moldova | BACĂU | STR. Strada Ion Creangă , NR. 1 | 46.2074735 | 26.4369461 | 23.03.2026 | RO-SITUR | HOTEL | 3 - STELE | 38114 | |
| 40869 | 40869 | MONTANA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 54 | 25 | Oraş Slănic Moldova | BACĂU | STR. Strada Nicolae Bălcescu , NR. 92 | 46.2231445 | 26.4741057 | 20.08.2018 | RO-SITUR | MOTEL | 3 - STELE | 11557/7604 | |
| 40874 | 40874 | PALAS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 56 | 28 | Oraş Slănic Moldova | BACĂU | STR. Strada Mihail Eminescu , NR. 1 | 46.2065312 | 26.4354254 | 30.09.2024 | RO-SITUR | HOTEL | 3 - STELE | 8088 | |
| 40875 | 40875 | PANORAMIC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 76 | 37 | Oraş Slănic Moldova | BACĂU | STR. Strada Vasile Alecsandri , NR. 22 | 46.2060089 | 26.435173 | 28.05.2021 | RO-SITUR | HOTEL | 3 - STELE | 25744 | |
| 40891 | 40891 | VENUS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 385 | 190 | Oraş Slănic Moldova | BACĂU | STR. Strada Mihail Eminescu , NR. 1 | 46.2073804 | 26.4374755 | 19.02.2024 | RO-SITUR | HOTEL | 3 - STELE | 1790/530 | |
| 40921 | 40921 | HAVANA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 50 | 25 | Oraş Târgu Ocna | BACĂU | STR. Strada Costache Negri , NR. 110 | 46.2771809 | 26.6265366 | 08.11.2016 | RO-SITUR | HOTEL | 3 - STELE | 30317 | |
| 40990 | 40990 | IRIS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 82 | 41 | Com. Borş, Sat Borş | BIHOR | STR. Şoseaua Şoseaua Borşului , NR. 400 | 47.1091519 | 21.8196493 | 30.03.2022 | RO-SITUR | HOTEL | 3 - STELE | 6377/3906 | |
| 41003 | 41003 | APUSENI PARK | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 52 | 26 | Com. Budureasa, Sat Budureasa | BIHOR | STR. Zona Padiș , NR. CF 50560-C1 | 46.5969458223121 | 22.7364776626221 | 02.12.2024 | RO-SITUR | HOTEL | 3 - STELE | 40797 | |
| 41008 | 41008 | IADOLINA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 112 | 56 | Com. Budureasa, Sat Budureasa | BIHOR | 46.6909491 | 22.6223191 | 03.07.2023 | RO-SITUR | HOTEL | 3 - STELE | 2205/969 | ||
| 41035 | 41035 | CARPATHIA REMEŢI | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 90 | 42 | Com. Bulz, Sat Remeţi | BIHOR | NR. 205 | 46.8359642 | 22.6232509 | 25.08.2021 | RO-SITUR | HOTEL | 3 - STELE | 14469 | |
| 41080 | 41080 | ORIZONT | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 16 | 9 | Com. Gepiu, Sat Gepiu | BIHOR | NR. 606 | 46.928816 | 21.7877715 | 16.09.2010 | RO-SITUR | MOTEL | 3 - STELE | 10486/7076 | |
| 41100 | 41100 | MILLENIUM | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 41 | 20 | Com. Mădăras, Sat Mădăras | BIHOR | NR. 189 | 46.8264916 | 21.690417 | 03.05.2016 | RO-SITUR | MOTEL | 3 - STELE | 6307/3007 | |
| 41112 | 41112 | SOLAY | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 30 | 15 | Com. Oşorhei, Sat Cheriu | BIHOR | NR. 400 | 47.0113918 | 22.0237037 | 03.12.2020 | RO-SITUR | HOTEL | 3 - STELE | 22421 | |
| 41178 | 41178 | CERES | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 460 | 230 | Com. Sânmartin | BIHOR | 46.9958478 | 21.9994371 | 10.03.2014 | RO-SITUR | HOTEL | 3 - STELE | 1510/970 | ||
| 41185 | 41185 | AMI | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 56 | 28 | Com. Sânmartin, Sat Băile Felix | BIHOR | NR. 112 A | 46.9899236 | 21.9803673 | 30.08.2012 | RO-SITUR | HOTEL | 3 - STELE | 12427 | |
| 41258 | 41258 | HYPERION | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 117 | 59 | Com. Sânmartin, Sat Băile Felix | BIHOR | STR. Calea Beiuşului , NR. 56 | 46.9833685 | 21.9853527 | 21.08.2014 | RO-SITUR | HOTEL | 3 - STELE | 18469 | |
| 41287 | 41287 | NICOLETA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 95 | 46 | Com. Sânmartin, Sat Băile Felix | BIHOR | STR. Strada Primăverii , NR. 74A/B | 46.9866279 | 21.9833523 | 04.08.2022 | RO-SITUR | HOTEL | 3 - STELE | 6986/7934 | |
| 41291 | 41291 | NUFARUL | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 148 | 76 | Com. Sânmartin, Sat Băile Felix | BIHOR | 46.992518 | 21.9776 | 17.02.2011 | RO-SITUR | HOTEL | 3 - STELE | 1009/697 | ||
| 41295 | 41295 | PADIS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 392 | 196 | Com. Sânmartin, Sat Băile Felix | BIHOR | 46.9869978 | 21.9786095 | 20.07.2017 | RO-SITUR | HOTEL | 3 - STELE | 967/711 | ||
| 41303 | 41303 | POIENITA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 302 | 158 | Com. Sânmartin, Sat Băile Felix | BIHOR | STR. Calea Beiuşului , NR. 26 | 47.04365 | 21.93964 | 07.07.2015 | RO-SITUR | HOTEL | 3 - STELE | 1004/693 | |
| 41317 | 41317 | TERMAL | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 303 | 183 | Com. Sânmartin, Sat Băile Felix | BIHOR | 46.991786 | 21.977312 | 27.04.2010 | RO-SITUR | HOTEL | 3 - STELE | 1008/695 | ||
| 41330 | 41330 | VITAL | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 58 | 29 | Com. Sânmartin, Sat Băile Felix | BIHOR | NR. 5 | 46.9882568 | 21.9775896 | 12.04.2012 | RO-SITUR | HOTEL | 3 - STELE | 12586/8606 | |
| 41386 | 41386 | ALLEGRIA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 36 | 19 | Com. Sânmartin, Sat Haieu | BIHOR | NR. 88G | 46.996816 | 21.9981855 | 20.12.2023 | RO-SITUR | HOTEL | 3 - STELE | 9890/7092 | |
| 41388 | 41388 | AQUA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 48 | 24 | Com. Sânmartin, Sat Haieu | BIHOR | STR. Cartier Băile 1 Mai , NR. 11B | 46.9936729 | 21.9977638 | 02.08.2010 | RO-SITUR | HOTEL | 3 - STELE | 12339/6974 | |
| 41432 | 41432 | ABI | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 74 | 37 | Com. Sânmartin, Sat Sânmartin | BIHOR | STR. Bulevardul Felix , NR. 213 | 46.9989661 | 21.9796414 | 25.03.2024 | RO-SITUR | HOTEL | 3 - STELE | 20493 | |
| 41531 | 41531 | PARC | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 180 | 90 | Com. Tinca, Sat Tinca | BIHOR | STR. Strada Avram Iancu , NR. 164 | 46.7745391 | 21.9516683 | 16.11.2017 | RO-SITUR | HOTEL | 3 - STELE | 529/1571 | |
| 41555 | 41555 | LAGUNA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 24 | 12 | Mun. Beiuş | BIHOR | STR. Strada Pandurilor , NR. 59 | 46.6556674 | 22.3676069 | 28.12.2021 | RO-SITUR | MOTEL | 3 - STELE | 11813 | |
| 41581 | 41581 | ALIVE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 32 | 16 | Mun. Oradea | BIHOR | STR. Calea Clujului , NR. 12 | 47.0536922 | 21.9426367 | 18.07.2024 | RO-SITUR | HOTEL | 3 - STELE | 38998 | |
| 41601 | 41601 | ART S LUXURY BOUTIQUE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 46 | 23 | Mun. Oradea | BIHOR | STR. Strada Gen. Henri Mathias Berthelot , NR. 15 | 47.0571227 | 21.9416893 | 09.01.2023 | RO-SITUR | HOTEL | 3 - STELE | 33487 | |
| 41610 | 41610 | B4 | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 29 | 15 | Mun. Oradea | BIHOR | STR. Strada Constantin Brâncoveanu , NR. 4 | 47.0624145 | 21.9186102 | 13.03.2023 | RO-SITUR | HOTEL | 3 - STELE | 31945 | |
| 41614 | 41614 | BIADOR APARTMENTS | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 36 | 18 | Mun. Oradea | BIHOR | STR. Strada Gheorghe Doja , NR. 182A | 47.0660646 | 21.9605911 | 07.06.2021 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 23237 | |
| 41663 | 41663 | CETATE | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 33 | 15 | Mun. Oradea | BIHOR | STR. Piaţa Emanuil Gojdu , NR. 39-41 | 47.052062 | 21.938946 | 12.07.2017 | RO-SITUR | HOTEL | 3 - STELE | 30585 | |
| 41671 | 41671 | CITY ORADEA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 54 | 25 | Mun. Oradea | BIHOR | STR. Strada Bucegi , NR. 1 | 47.06487 | 21.9375038 | 17.12.2024 | RO-SITUR | HOTEL | 3 - STELE | 12604 | |
| 41672 | 41672 | CLASS | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 50 | 30 | Mun. Oradea | BIHOR | STR. Strada Meziadului , NR. 2B | 47.062055 | 21.9117861 | 01.08.2011 | RO-SITUR | HOTEL | 3 - STELE | 11614/7878 | |
| 41679 | 41679 | COROLA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 28 | 14 | Mun. Oradea | BIHOR | STR. Strada Meşteşugarilor , NR. 110 | 47.0659581 | 21.9005454 | 03.09.2009 | RO-SITUR | HOTEL | 3 - STELE | 4841/3034 | |
| 41729 | 41729 | IMPERO | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 155 | 81 | Mun. Oradea | BIHOR | STR. Strada Octavian Goga , NR. 1 | 47.051401 | 21.9178641 | 12.07.2012 | RO-SITUR | HOTEL | 3 - STELE | 12861/8829 | |
| 41754 | 41754 | LIVING INN | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 32 | 12 | Mun. Oradea | BIHOR | STR. Strada Făcliei , NR. 2A | 47.0532631 | 21.9559955 | 04.12.2018 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 12862/8827 | |
| 41763 | 41763 | LYRA | RO | stay | hotels | hotel | normal | 3 | star | 3 - STELE | 48 | 24 | Mun. Oradea | BIHOR | STR. Calea Clujului , NR. 195 | 47.0444169 | 21.969092 | 01.08.2011 | RO-SITUR | HOTEL | 3 - STELE | 15317 |
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");