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
315 rows where country = "RO", family = "hotels" and rating_value = 2
This data as json, CSV (advanced)
Suggested facets: rating_scheme, rating_label, source_type, source_category
venue_type 3
- hotel 222
- motel 91
- aparthotel 2
group 1
- stay 315
family 1
- hotels · 315 ✖
country 1
- RO · 315 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39186 | 39186 | GELA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 20 | 11 | Com. Mirăslău, Sat Decea | ALBA | 46.3824267 | 23.764068 | 19.01.2011 | RO-SITUR | MOTEL | 2 - STELE | 11499/7250 | ||
| 39416 | 39416 | HANUL CU BERZE | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 39 | 20 | Mun. Alba Iulia | ALBA | STR. Strada Regimentul V Vânători , NR. 83 - 85 | 46.0412652 | 23.5623064 | 03.12.2018 | RO-SITUR | MOTEL | 2 - STELE | 11696/7545 | |
| 39505 | 39505 | TARNAVELE | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 40 | 20 | Mun. Blaj | ALBA | STR. Bulevardul Republicii , NR. 1 | 46.176657 | 23.922037 | 12.11.2010 | RO-SITUR | HOTEL | 2 - STELE | 7575/7165 | |
| 39540 | 39540 | BIP | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 22 | 10 | Oraş Câmpeni | ALBA | STR. Strada Libertăţii , NR. 19A | 46.3618 | 23.04885 | 02.04.2014 | RO-SITUR | HOTEL | 2 - STELE | 27859 | |
| 39543 | 39543 | TULNIC | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 37 | 18 | Oraş Câmpeni | ALBA | STR. Strada Revoluţiei 1848 , NR. 1 | 46.3628153 | 23.0459729 | 24.03.2011 | RO-SITUR | HOTEL | 2 - STELE | 9637/7428 | |
| 39549 | 39549 | DRAGANA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 30 | 15 | Oraş Cugir | ALBA | STR. Strada Alexandru Sahia , NR. 20 | 45.8424343 | 23.3612944 | 21.07.2009 | RO-SITUR | HOTEL | 2 - STELE | 6277/3818 | |
| 39718 | 39718 | AS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 36 | 18 | Mun. Arad | ARAD | STR. Calea Timişorii , NR. 212 | 46.1373519 | 21.3198328 | 25.01.2021 | RO-SITUR | HOTEL | 2 - STELE | 10956/6978 | |
| 39793 | 39793 | LOTUS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 23 | 11 | Mun. Arad | ARAD | STR. Strada Nicolae Ştefu , NR. 8 | 46.1847585 | 21.312928 | 07.09.2009 | RO-SITUR | HOTEL | 2 - STELE | 9644/6270 | |
| 39858 | 39858 | VOINICUL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 34 | 14 | Mun. Arad | ARAD | STR. Strada Voinicilor , NR. 34 | 46.1714047 | 21.3556087 | 18.10.2019 | RO-SITUR | HOTEL | 2 - STELE | 12998/6979 | |
| 39896 | 39896 | TAVERNA PECICANĂ | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 54 | 20 | Oraş Pecica, Sat Pecica | ARAD | STR. Strada 501 , NR. 1 | 46.1689414 | 21.0678377 | 04.04.2022 | RO-SITUR | HOTEL | 2 - STELE | 18013 | |
| 40003 | 40003 | VALEA URSULUI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 32 | 16 | Com. Bascov, Sat Valea Ursului | ARGEŞ | 44.8895874 | 24.7660705 | 02.12.2015 | RO-SITUR | MOTEL | 2 - STELE | 11750/7865 | ||
| 40014 | 40014 | VULTURUL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 34 | 17 | Com. Bradu, Sat Geamăna | ARGEŞ | NR. 21 | 44.828632 | 24.8934015 | 12.10.2011 | RO-SITUR | HOTEL | 2 - STELE | 11946/8141 | |
| 40124 | 40124 | STILL | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 10 | 5 | Com. Cotmeana, Sat Linteşti | ARGEŞ | 45.0041958 | 24.6118153 | 03.02.2012 | RO-SITUR | MOTEL | 2 - STELE | 16489 | ||
| 40125 | 40125 | TRAFFIC | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 29 | 12 | Com. Cotmeana, Sat Linteşti | ARGEŞ | STR. Strada Principală , NR. 11 | 44.8503164 | 24.7899365 | 11.04.2022 | RO-SITUR | MOTEL | 2 - STELE | 15996 | |
| 40262 | 40262 | LA CETATE | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 48 | 23 | Com. Priboieni, Sat Valea Mare | ARGEŞ | NR. 38 | 44.8718371 | 24.9097698 | 21.03.2011 | RO-SITUR | HOTEL | 2 - STELE | 14044A | |
| 40391 | 40391 | MUSCELUL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 178 | 75 | Mun. Câmpulung | ARGEŞ | STR. Strada Negru Vodă , NR. 164 | 45.2720478 | 25.0456364 | 14.02.2011 | RO-SITUR | HOTEL | 2 - STELE | 2173/299 | |
| 40505 | 40505 | METROPOL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 28 | 16 | Mun. Piteşti | ARGEŞ | STR. Strada Panselelor , NR. 1 | 44.856933 | 24.870475 | 07.04.2011 | RO-SITUR | HOTEL | 2 - STELE | 3351/1272 | |
| 40518 | 40518 | REHOMA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 30 | 14 | Mun. Piteşti | ARGEŞ | STR. Bulevardul Nicolae Bălcescu , NR. 54 | 44.8792281 | 24.8249046 | 12.11.2020 | RO-SITUR | HOTEL | 2 - STELE | 3347/1360 | |
| 40544 | 40544 | VALENTINO | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 22 | 11 | Oraş Mioveni, Loc. Mioveni | ARGEŞ | NR. 47 | 44.9511242 | 24.9258795 | 03.07.2023 | RO-SITUR | HOTEL | 2 - STELE | 11155/7108 | |
| 40569 | 40569 | KM. 17 | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 20 | 10 | Com. Căiuţi, Sat Popeni | BACĂU | 46.1781255 | 26.9367076 | 17.09.2012 | RO-SITUR | MOTEL | 2 - STELE | 5328/3781 | ||
| 40770 | 40770 | BUCOVINA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 44 | 21 | Mun. Oneşti | BACĂU | STR. Strada Emil Rebreanu , NR. 11A | 46.2429402 | 26.7556116 | 16.11.2021 | RO-SITUR | MOTEL | 2 - STELE | 7220/5090 | |
| 40778 | 40778 | KM & GI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 24 | 12 | Mun. Oneşti | BACĂU | STR. Bulevardul Mărăşeşti , NR. 79 | 46.2530659 | 26.7936392 | 28.12.2021 | RO-SITUR | MOTEL | 2 - STELE | 12002/7573 | |
| 40779 | 40779 | LA STRADA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 14 | 7 | Mun. Oneşti | BACĂU | NR. 1 A. | 46.2437167 | 26.7543595 | 27.07.2012 | RO-SITUR | MOTEL | 2 - STELE | 18196 | |
| 40788 | 40788 | PARC | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 98 | 37 | Mun. Oneşti | BACĂU | STR. Bulevardul Republicii , NR. 43 | 46.2543239 | 26.771443 | 13.01.2022 | RO-SITUR | HOTEL | 2 - STELE | 13350 | |
| 40925 | 40925 | MAGURA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 360 | 165 | Oraş Târgu Ocna | BACĂU | STR. Strada Trandafirilor , NR. 2 | 46.2793783 | 26.6058858 | 15.12.2009 | RO-SITUR | HOTEL | 2 - STELE | 1372/521 | |
| 40927 | 40927 | MINERVA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 49 | 22 | Oraş Târgu Ocna | BACĂU | STR. Strada Costache Negri , NR. 217A | 46.2737907 | 26.6407513 | 26.04.2022 | RO-SITUR | MOTEL | 2 - STELE | 16061 | |
| 41284 | 41284 | MUNCEL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 486 | 243 | Com. Sânmartin, Sat Băile Felix | BIHOR | 46.988122 | 21.9824821 | 07.06.2010 | RO-SITUR | HOTEL | 2 - STELE | 2638/712 | ||
| 41285 | 41285 | MURES | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 650 | 360 | Com. Sânmartin, Sat Băile Felix | BIHOR | 46.9899236 | 21.9803673 | 24.11.2009 | RO-SITUR | HOTEL | 2 - STELE | 2328/696 | ||
| 41481 | 41481 | SÂNTANA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 124 | 42 | Com. Sânmartin, Sat Sânmartin | BIHOR | 47.0025773 | 21.9770794 | 24.09.2014 | RO-SITUR | HOTEL | 2 - STELE | 16041/8924 | ||
| 41486 | 41486 | DODO | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 67 | 26 | Com. Sântandrei, Sat Sântandrei | BIHOR | NR. 180. | 47.0670543 | 21.8517806 | 27.06.2012 | RO-SITUR | MOTEL | 2 - STELE | 18089 | |
| 41571 | 41571 | TERMAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 96 | 42 | Mun. Marghita | BIHOR | STR. Strada Eroilor , NR. 1 | 46.7695224 | 23.5911179 | 09.09.2011 | RO-SITUR | HOTEL | 2 - STELE | 1512/326 | |
| 41855 | 41855 | TERRA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 40 | 20 | Mun. Oradea | BIHOR | STR. Strada Făcliei , NR. 29 | 47.0523878 | 21.9611791 | RO-SITUR | HOTEL | 2 - STELE | |||
| 42177 | 42177 | DECEBAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 54 | 28 | Mun. Bistriţa | BISTRIŢA-NĂSĂUD | STR. Strada Cuza Vodă , NR. 2B | 47.1381978 | 24.4931589 | 18.10.2022 | RO-SITUR | HOTEL | 2 - STELE | 2344/466 | |
| 42316 | 42316 | RAREȘ | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 48 | 24 | Mun. Botoşani | BOTOŞANI | STR. Strada 1 Decembrie , NR. 65 | 47.7410956 | 26.6684327 | 01.10.2025 | RO-SITUR | HOTEL | 2 - STELE | 1964/1071 | |
| 42335 | 42335 | FLORA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 212 | 106 | Com. Chiscani, Sat Lacu Sărat | BRĂILA | 45.220328 | 27.8851026 | 06.09.2010 | RO-SITUR | HOTEL | 2 - STELE | 2954/935 | ||
| 42392 | 42392 | REGAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 62 | 30 | Mun. Brăila | BRĂILA | STR. Strada Mihail Sebastian , NR. 21 | 45.2716978 | 27.9705117 | 07.04.2011 | RO-SITUR | HOTEL | 2 - STELE | 14155 | |
| 42400 | 42400 | SPORT | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 49 | 27 | Mun. Brăila | BRĂILA | STR. Strada Dimitrie Bolintineanu , NR. 2 | 45.2731246 | 27.9747303 | 07.06.2012 | RO-SITUR | HOTEL | 2 - STELE | 3752/1512 | |
| 42693 | 42693 | SOFIA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 34 | 15 | Com. Bran, Sat Sohodol | BRAŞOV | STR. Strada Bradul Înalt , NR. 41 | 45.5153387 | 25.386097 | 29.09.2023 | RO-SITUR | HOTEL | 2 - STELE | 6210/3858 | |
| 43260 | 43260 | DOMENIUL BOGDAN | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 30 | 15 | Com. Prejmer, Sat Lunca Calnicului | BRAŞOV | STR. Strada Principală | 45.7562022 | 25.7781632 | 23.03.2026 | RO-SITUR | MOTEL | 2 - STELE | 46230 | |
| 43383 | 43383 | CIUCAS | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 31 | 14 | Com. Tărlungeni, Sat Cărpiniş | BRAŞOV | NR. 976C | 45.6623253 | 25.7669396 | 09.07.2010 | RO-SITUR | MOTEL | 2 - STELE | 13571 | |
| 43596 | 43596 | ASTRA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 125 | 48 | Mun. Braşov | BRAŞOV | STR. Strada Carpaţilor , NR. 60 | 45.6414274 | 25.6264872 | 05.04.2023 | RO-SITUR | HOTEL | 2 - STELE | 17950 | |
| 43886 | 43886 | DECEBAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 192 | 96 | Mun. Braşov | BRAŞOV | STR. Strada Lunii , NR. 3 | 45.6451505 | 25.6239453 | 15.06.2011 | RO-SITUR | HOTEL | 2 - STELE | 12443/7784 | |
| 44000 | 44000 | HELIS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 42 | 21 | Mun. Braşov | BRAŞOV | STR. Strada Memorandumului , NR. 29 | 45.6533886 | 25.5823066 | 07.11.2011 | RO-SITUR | HOTEL | 2 - STELE | 16118 | |
| 44637 | 44637 | CARAIMAN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 132 | 66 | Mun. Braşov, Loc. Poiana Braşov | BRAŞOV | 45.5934656 | 25.5488208 | 18.10.2010 | RO-SITUR | HOTEL | 2 - STELE | 6534/7117 | ||
| 44664 | 44664 | OLIMPIC | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 98 | 49 | Mun. Braşov, Loc. Poiana Braşov | BRAŞOV | 45.5955044 | 25.5513291 | 09.11.2009 | RO-SITUR | HOTEL | 2 - STELE | 6535/4124 | ||
| 44832 | 44832 | BUCEGI PORŢILE REGATULUI | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 52 | 26 | Oraş Predeal | BRAŞOV | STR. Strada Valea Râşnoavei , NR. 10 | 45.511684 | 25.508917 | 11.08.2015 | RO-SITUR | HOTEL | 2 - STELE | 557/381 | |
| 44894 | 44894 | DANA | RO | stay | hotels | hotel | normal | 2 | flower | 2 - MARGARETE | 14 | 6 | Oraş Predeal | BRAŞOV | STR. Strada Clăbucet | 45.4989363 | 25.5796118 | 08.03.2024 | RO-SITUR | HOTEL | 2 - MARGARETE | 7071/5332A | |
| 45018 | 45018 | PIATRA CRAIULUI | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 44 | 22 | Oraş Predeal, Loc. Pârâul Rece | BRAŞOV | NR. 10 | 45.5119484 | 25.5100822 | 19.12.2011 | RO-SITUR | HOTEL | 2 - STELE | 559/382 | |
| 45020 | 45020 | ALL TIMES | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 36 | 20 | Oraş Predeal, Loc. Timişu de Jos | BRAŞOV | NR. 32 | 45.4793067 | 25.5644985 | 16.02.2011 | RO-SITUR | HOTEL | 2 - STELE | 11365/7275 | |
| 45022 | 45022 | TIMTUR | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 33 | 15 | Oraş Predeal, Loc. Timişu de Jos | BRAŞOV | NR. 22-A | 45.4738044 | 25.562702 | 20.09.2011 | RO-SITUR | MOTEL | 2 - STELE | 7090/5680 | |
| 45343 | 45343 | 2D | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 58 | 26 | Com. Cislău, Sat Cislău | BUZĂU | 45.2450915 | 26.3766644 | 20.11.2013 | RO-SITUR | MOTEL | 2 - STELE | 11469 | ||
| 45351 | 45351 | HANUL OVIDIU | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 36 | 16 | Com. Glodeanu Sărat, Sat Căldăruşeanca | BUZĂU | STR. CALEA BUZAULUI | 44.8809172 | 26.6909244 | 13.01.2026 | RO-SITUR | MOTEL | 2 - STELE | 12109/8630 | |
| 45408 | 45408 | MONTANA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 80 | 40 | Com. Merei, Sat Sărata-Monteoru | BUZĂU | STR. Aleea Ştrandului , NR. 1 | 45.1475653 | 26.6409383 | 10.07.2025 | RO-SITUR | HOTEL | 2 - STELE | 12113/6717 | |
| 45409 | 45409 | MONTEORU | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 76 | 33 | Com. Merei, Sat Sărata-Monteoru | BUZĂU | STR. Aleea Ştrandului , NR. 3 | 45.1475653 | 26.6409383 | 10.07.2025 | RO-SITUR | HOTEL | 2 - STELE | 7234/4913 | |
| 45477 | 45477 | AQUA MAX | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 34 | 17 | Mun. Buzău | BUZĂU | STR. UNIRII NORD | 45.155891 | 26.816742 | 04.07.2025 | RO-SITUR | MOTEL | 2 - STELE | 9930/6250 | |
| 45482 | 45482 | BUCEGI | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 54 | 26 | Mun. Buzău | BUZĂU | STR. Bulevardul Gării , NR. 47 | 45.1437815 | 26.8259002 | 18.02.2026 | RO-SITUR | HOTEL | 2 - STELE | 2364/343 | |
| 45531 | 45531 | ILEANA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 83 | 34 | Mun. Buzău | BUZĂU | STR. Strada Drăgăicii , NR. 2B | 45.1353351 | 26.8451557 | 26.03.2026 | RO-SITUR | MOTEL | 2 - STELE | 17061 | |
| 45542 | 45542 | MUŞATINII | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 44 | 24 | Mun. Buzău | BUZĂU | STR. Şoseaua Brăilei , NR. 17 | 45.134541 | 26.8573778 | 25.06.2012 | RO-SITUR | HOTEL | 2 - STELE | 10813/5283 | |
| 45550 | 45550 | SPORT B90 | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 68 | 34 | Mun. Buzău | BUZĂU | STR. Strada Mesteacănului , NR. 1 | 45.1571537 | 26.8273389 | 02.12.2009 | RO-SITUR | HOTEL | 2 - STELE | 1792/584 | |
| 45598 | 45598 | DRAJNA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 30 | 15 | Com. Dragalina, Sat Drajna Nouă | CĂLĂRAŞI | 44.4202922 | 27.3796468 | 14.06.2011 | RO-SITUR | MOTEL | 2 - STELE | 9081/7778 | ||
| 45847 | 45847 | RANDUNICA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 84 | 42 | Com. Văliug, Sat Văliug | CARAŞ-SEVERIN | 45.1973861 | 22.0149645 | 19.08.2010 | RO-SITUR | HOTEL | 2 - STELE | 10921/7038 | ||
| 45928 | 45928 | INTIM | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 19 | 9 | Mun. Reşiţa | CARAŞ-SEVERIN | STR. Bulevardul Republicii , NR. 2 | 45.3187373 | 21.8799736 | 24.05.2012 | RO-SITUR | HOTEL | 2 - STELE | 12084/8596 | |
| 45943 | 45943 | TURIST | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 43 | 21 | Mun. Reşiţa, Loc. Secu | CARAŞ-SEVERIN | 45.2712461 | 21.9793796 | 15.12.2009 | RO-SITUR | HOTEL | 2 - STELE | 6510/6510 | ||
| 45959 | 45959 | ARTEMIS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 64 | 34 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Castanilor , NR. 2 | 44.8765824 | 22.4134237 | 15.04.2019 | RO-SITUR | HOTEL | 2 - STELE | 9654/6081 | |
| 46020 | 46020 | HERCULES | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 236 | 126 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Izvorului , NR. 7 | 44.8831227 | 22.4172846 | 18.11.2010 | RO-SITUR | HOTEL | 2 - STELE | 973/768 | |
| 46050 | 46050 | ROMAN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 364 | 182 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Romană , NR. 1 | 44.8952556 | 22.4282187 | 14.01.2026 | RO-SITUR | HOTEL | 2 - STELE | 977/769 | |
| 46066 | 46066 | TRANDAFIRUL GALBEN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 54 | 27 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Trandafirilor , NR. 76 | 44.8629882 | 22.4043204 | 29.04.2011 | RO-SITUR | HOTEL | 2 - STELE | 5052/3005A | |
| 46122 | 46122 | VICTORIA APAHIDA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 24 | 12 | Com. Apahida, Sat Apahida | CLUJ | STR. Strada Libertăţii , NR. 63 | 46.7928151 | 23.74433 | 06.11.2013 | RO-SITUR | MOTEL | 2 - STELE | 16575 | |
| 46401 | 46401 | GILĂU | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 110 | 55 | Com. Gilău, Sat Gilău | CLUJ | STR. Strada Pădurii , NR. 1 | 46.7468131 | 23.3697768 | 27.11.2023 | RO-SITUR | MOTEL | 2 - STELE | 4659/3126 | |
| 46509 | 46509 | CIPRIAN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 38 | 19 | Com. Mihai Viteazu, Sat Corneşti | CLUJ | NR. 266 | 47.0348851 | 23.6786044 | 10.01.2011 | RO-SITUR | HOTEL | 2 - STELE | 10251/7242 | |
| 46706 | 46706 | TIVER | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 54 | 26 | Mun. Câmpia Turzii | CLUJ | STR. Strada Poet Andrei Mureşanu , NR. 1 | 46.545425 | 23.8856396 | 19.05.2010 | RO-SITUR | HOTEL | 2 - STELE | 3876/2064 | |
| 46769 | 46769 | BETA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 65 | 30 | Mun. Cluj-Napoca | CLUJ | STR. Strada Giordano Bruno , NR. 1-3 | 46.7866543 | 23.580851 | 11.04.2016 | RO-SITUR | HOTEL | 2 - STELE | 7592/5189 | |
| 47109 | 47109 | LUCY STAR | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 56 | 28 | Mun. Cluj-Napoca | CLUJ | STR. Strada Giordano Bruno , NR. 25-27 | 46.788313 | 23.5793046 | 05.05.2011 | RO-SITUR | HOTEL | 2 - STELE | 14454A | |
| 47425 | 47425 | ZIMBRU | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 46 | 23 | Mun. Cluj-Napoca | CLUJ | STR. Strada Bucureşti , NR. 73 | 46.7813245 | 23.6077737 | 17.11.2010 | RO-SITUR | HOTEL | 2 - STELE | 7591/5138 | |
| 47518 | 47518 | PALACE | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 24 | 13 | Mun. Turda | CLUJ | STR. Piaţa Republicii , NR. 31 | 46.5721169 | 23.7859703 | 20.03.2014 | RO-SITUR | HOTEL | 2 - STELE | 27803 | |
| 47696 | 47696 | POIENIȚA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 124 | 48 | Com. Costineşti | CONSTANŢA | 43.9532157 | 28.6366706 | 27.08.2025 | RO-SITUR | HOTEL | 2 - STELE | 14617 | ||
| 47707 | 47707 | ALEX | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 104 | 52 | Com. Costineşti, Sat Costineşti | CONSTANŢA | NR. 1 | 43.9470874 | 28.6325451 | 04.01.2022 | RO-SITUR | HOTEL | 2 - STELE | 12747/8676 | |
| 47737 | 47737 | AZUR | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 150 | 75 | Com. Costineşti, Sat Costineşti | CONSTANŢA | 43.9420709 | 28.6377492 | 16.11.2011 | RO-SITUR | HOTEL | 2 - STELE | 527/3106 | ||
| 47921 | 47921 | CRIS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 97 | 46 | Com. Costineşti, Sat Costineşti | CONSTANŢA | STR. ZONA STADION , NR. 8 | 43.9569653 | 28.6380974 | 30.09.2024 | RO-SITUR | HOTEL | 2 - STELE | 39038 | |
| 47955 | 47955 | FORUM | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 293 | 139 | Com. Costineşti, Sat Costineşti | CONSTANŢA | 43.9412307 | 28.6376361 | 02.10.2020 | RO-SITUR | HOTEL | 2 - STELE | 180/3018 | ||
| 48381 | 48381 | PRINCIPAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 52 | 26 | Com. Costineşti, Sat Schitu | CONSTANŢA | STR. Strada Principală | 43.9414118 | 28.6271651 | 25.01.2011 | RO-SITUR | HOTEL | 2 - STELE | 13826 | |
| 48556 | 48556 | BLUE NIGHT LA JOHN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 140 | 51 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Falezei , NR. 8 | 43.7542935 | 28.5741015 | 21.05.2025 | RO-SITUR | HOTEL | 2 - STELE | 9034/5703 | |
| 48649 | 48649 | LAGUNA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 52 | 26 | Com. Limanu, Sat Vama Veche | CONSTANŢA | 43.7529244 | 28.5725487 | 27.03.2023 | RO-SITUR | HOTEL | 2 - STELE | 8353/6246 | ||
| 48716 | 48716 | WAVES | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 70 | 35 | Com. Limanu, Sat Vama Veche | CONSTANŢA | STR. Strada Mihail Kogălniceanu , NR. 50 | 43.7539476 | 28.5713849 | 26.10.2022 | RO-SITUR | HOTEL | 2 - STELE | 20905 | |
| 48822 | 48822 | CALLA INN | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 45 | 16 | Mun. Constanţa | CONSTANŢA | STR. Aleea Ciuleandra , NR. 8 | 44.2165543578278 | 28.6305070932541 | 07.08.2023 | RO-SITUR | HOTEL | 2 - STELE | 14833 | |
| 48868 | 48868 | CIREȘICA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 27 | 12 | Mun. Constanţa | CONSTANŢA | STR. Strada Dispensarului , NR. 10A | 44.2126058 | 28.6247208 | 06.04.2010 | RO-SITUR | HOTEL | 2 - STELE | 10262/6541 | |
| 48886 | 48886 | CORA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 38 | 19 | Mun. Constanţa | CONSTANŢA | STR. Bulevardul Mamaia , NR. 201 | 44.2004298 | 28.6462692 | 06.07.2009 | RO-SITUR | HOTEL | 2 - STELE | 6643/3184 | |
| 48906 | 48906 | DOBROGEA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 20 | 10 | Mun. Constanţa | CONSTANŢA | STR. Bulevardul Alexandru Lăpuşneanu , NR. 194 | 44.2155608 | 28.6292348 | 12.07.2012 | RO-SITUR | HOTEL | 2 - STELE | 2056/127 | |
| 49211 | 49211 | AURORA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 682 | 341 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2232454 | 28.6316764 | 24.11.2011 | RO-SITUR | HOTEL | 2 - STELE | 23/153 | ||
| 49283 | 49283 | JIJO`S | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 96 | 48 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2627817 | 28.6201169 | 15.07.2014 | RO-SITUR | HOTEL | 2 - STELE | 3239/1119 | ||
| 49304 | 49304 | METROPOL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 430 | 215 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2521063 | 28.6185411 | 24.05.2012 | RO-SITUR | HOTEL | 2 - STELE | 44/412 | ||
| 49315 | 49315 | NAŢIONAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 320 | 160 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2393548 | 28.6223906 | 09.09.2025 | RO-SITUR | HOTEL | 2 - STELE | 37/599 | ||
| 49323 | 49323 | OLT BY VENTURA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 144 | 66 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2513593 | 28.6197735 | 23.07.2024 | RO-SITUR | HOTEL | 2 - STELE | 2045/118 | ||
| 49333 | 49333 | PESCARUŞ | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 176 | 109 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | 44.2183634 | 28.6372122 | 09.05.2024 | RO-SITUR | HOTEL | 2 - STELE | 17/370 | ||
| 49547 | 49547 | CRISTAL | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 194 | 97 | Mun. Mangalia, Loc. Cap Aurora | CONSTANŢA | 43.8526635 | 28.6018804 | 14.09.2010 | RO-SITUR | HOTEL | 2 - STELE | 129/416 | ||
| 49551 | 49551 | SAFIR | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 212 | 106 | Mun. Mangalia, Loc. Cap Aurora | CONSTANŢA | 43.8526635 | 28.6018804 | 14.04.2011 | RO-SITUR | HOTEL | 2 - STELE | 128/394A | ||
| 49554 | 49554 | CAMELIA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 108 | 54 | Mun. Mangalia, Loc. Jupiter | CONSTANŢA | STR. Strada Gala Galaction | 43.8564851 | 28.6034964 | 23.07.2018 | RO-SITUR | HOTEL | 2 - STELE | 6651/5038 | |
| 49596 | 49596 | VIOLETA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 108 | 54 | Mun. Mangalia, Loc. Jupiter | CONSTANŢA | STR. Strada Gala Galaction , NR. 23 | 43.8560663 | 28.6049861 | 03.07.2023 | RO-SITUR | HOTEL | 2 - STELE | 10979/6560 | |
| 49620 | 49620 | CALLATIS | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 192 | 96 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Trandafirilor | 43.8098909 | 28.5835736 | 14.05.2026 | RO-SITUR | HOTEL | 2 - STELE | 3734/892 | |
| 49641 | 49641 | DACIA | RO | stay | hotels | hotel | normal | 2 | star | 2 - STELE | 328 | 164 | Mun. Mangalia, Loc. Neptun | CONSTANŢA | STR. Strada Trandafirilor , NR. 12 | 43.8668754 | 28.5976195 | 06.04.2026 | RO-SITUR | HOTEL | 2 - STELE | 121/165 |
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");