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
36 rows where country = "RO" and venue_type = "aparthotel"
This data as json, CSV (advanced)
Suggested facets: rating_label, capacity_persons, rooms, city, municipality, source_category
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39445 | 39445 | ONE | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 80 | 40 | Mun. Alba Iulia | ALBA | STR. Strada Mitropolit Alexandru Sterca Şuluţiu , NR. 1 | 46.0687094 | 23.5732911 | 31.07.2025 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 42764 | |
| 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 | |
| 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 | |
| 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 | |
| 44932 | 44932 | HERA | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 50 | 25 | Oraş Predeal | BRAŞOV | STR. Strada Trei Brazi , NR. 12 . | 45.5109021 | 25.5718808 | 30.08.2017 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 7093/5122 | |
| 44955 | 44955 | MONTAN | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 36 | 18 | Oraş Predeal | BRAŞOV | STR. Strada Muncii , NR. 2 | 45.5062441 | 25.5799595 | 17.03.2025 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 41898 | |
| 46733 | 46733 | APARTHOTEL NOX | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 64 | 32 | Mun. Cluj-Napoca | CLUJ | STR. Strada Edgar Quinet , NR. 5 | 46.7475958 | 23.5642957 | 18.10.2021 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 23941 | |
| 46979 | 46979 | DOTEL 47 | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 46 | 18 | Mun. Cluj-Napoca | CLUJ | STR. Strada Decebal , NR. 47 | 46.7798352 | 23.5893525 | 20.05.2026 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 44573 | |
| 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 | |
| 47250 | 47250 | RADISSON BLU | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 46 | 22 | Mun. Cluj-Napoca | CLUJ | STR. Aleea Stadionului , NR. 1 | 46.7673687 | 23.5736604 | 23.03.2026 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 46237 | |
| 47367 | 47367 | UBA ACCOMMODATION | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 106 | 44 | Mun. Cluj-Napoca | CLUJ | STR. Calea Turzii , NR. 186-187 | 46.7404093 | 23.5912932 | 30.10.2018 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 30865 | |
| 49080 | 49080 | ROSETTI ONE | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 26 | 10 | Mun. Constanţa | CONSTANŢA | STR. Strada C. A. Rosetti , NR. 1 | 44.174345 | 28.656547 | 15.05.2026 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 35023 | |
| 49352 | 49352 | RIVA MAMAIA | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 34 | 16 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | NR. 9 , ET. 1 | 44.2334022 | 28.626646 | 05.08.2019 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 20175 | |
| 49396 | 49396 | VICTOR | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 58 | 26 | Mun. Constanţa, Loc. Mamaia | CONSTANŢA | NR. 419 | 44.2444477 | 28.6196928 | 30.08.2021 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 23686 | |
| 49946 | 49946 | SAFIR | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 40 | 20 | Mun. Mangalia, Loc. Venus | CONSTANŢA | STR. Strada Nicolae Iorga , NR. 40B | 43.8461586 | 28.5997346 | 03.06.2019 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14440 | |
| 52200 | 52200 | PHOENICIA HOLIDAY RESORT | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 60 | 30 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 109-111 | 44.2793225 | 28.6183522 | 23.05.2011 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14944A | |
| 52201 | 52201 | PHOENICIA HOLIDAY RESORT | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 1032 | 445 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 109-111 | 44.2807964 | 28.6179326 | 24.04.2019 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14944 | |
| 52202 | 52202 | PHOENICIA HOLIDAY RESORT - CORB RUBIN | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 184 | 92 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 109-111 | 44.2807964 | 28.6179326 | 23.05.2011 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14944C1A | |
| 52203 | 52203 | PHOENICIA HOLIDAY RESORT - CORP CORAL | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 184 | 92 | Oraş Năvodari | CONSTANŢA | STR. Bulevardul Mamaia Nord , NR. 109-111 | 44.2807964 | 28.6179326 | 23.05.2011 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14944C2A | |
| 52825 | 52825 | WHITE TOWER MAMAIA | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 48 | 22 | Oraş Năvodari | CONSTANŢA | STR. Strada Lotus , NR. 11 | 44.2732378 | 28.6203514 | 28.04.2023 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 31591 | |
| 53362 | 53362 | ARIA SUITES | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 64 | 28 | Mun. Târgovişte | DÂMBOVIŢA | STR. Calea București , NR. 21 | 44.920434 | 25.475758 | 09.09.2024 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 39489 | |
| 53515 | 53515 | APARTHOTEL CRAIOVA | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 134 | 59 | Mun. Craiova | DOLJ | STR. Calea București , NR. 78E | 44.3130524 | 23.9004607 | 27.02.2025 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 41345 | |
| 54969 | 54969 | MERKUR APARTMENTS | RO | stay | hotels | aparthotel | normal | 2 | star | 2 - STELE | 10 | 5 | Mun. Miercurea Ciuc | HARGHITA | STR. Strada Mihail Sadoveanu , NR. 19 | 46.3591633 | 25.7968991 | 28.03.2022 | RO-SITUR | HOTEL APARTAMENT | 2 - STELE | 24565 | |
| 58685 | 58685 | CASA LOCATO | RO | stay | hotels | aparthotel | normal | 2 | star | 2 - STELE | 42 | 21 | Mun. Bucureşti, Sector 1 | MUNICIPIUL BUCUREŞTI | STR. Bulevardul Ion Mihalache , NR. 125 , BL. 7 | 44.4638118 | 26.0699843 | 02.07.2014 | RO-SITUR | HOTEL APARTAMENT | 2 - STELE | 5336/3342 | |
| 58799 | 58799 | EPOQUE | RO | stay | hotels | aparthotel | normal | 5 | star | 5 - STELE | 92 | 45 | Mun. Bucureşti, Sector 1 | MUNICIPIUL BUCUREŞTI | NR. 17C | 44.4367026 | 26.0866563 | 22.08.2017 | RO-SITUR | HOTEL APARTAMENT | 5 - STELE | 13930A | |
| 59291 | 59291 | ATHINA SUITES HOTEL | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 118 | 43 | Mun. Bucureşti, Sector 2 | MUNICIPIUL BUCUREŞTI | STR. Strada Mihai Eminescu , NR. 92-94 | 44.4478301 | 26.1050621 | 03.12.2018 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 19210 | |
| 60437 | 60437 | CIŞMIGIU | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 120 | 60 | Mun. Bucureşti, Sector 5 | MUNICIPIUL BUCUREŞTI | STR. Bulevardul Regina Elisabeta , NR. 38 | 44.4347999 | 26.0948081 | 18.09.2013 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 27218 | |
| 60674 | 60674 | LE BLANC | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 70 | 35 | Mun. Bucureşti, Sector 6 | MUNICIPIUL BUCUREŞTI | STR. Strada Corvinilor , NR. 1-3 | 44.4429052 | 26.0578485 | 30.09.2020 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 21336 | |
| 60704 | 60704 | ORHIDEEA RESIDENCE & SPA | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 254 | 76 | Mun. Bucureşti, Sector 6 | MUNICIPIUL BUCUREŞTI | STR. Calea Plevnei , NR. 145B | 44.4433153 | 26.0709166 | 09.05.2025 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 16474 | |
| 61922 | 61922 | ATLAS | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 96 | 35 | Mun. Piatra Neamţ | NEAMŢ | STR. Strada Petru Rareş , NR. 9 | 46.9335789 | 26.3719951 | 02.11.2020 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 22002 | |
| 62018 | 62018 | ADORA | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 44 | 12 | Oraş Bicaz | NEAMŢ | STR. Strada Apusului , NR. 26-28 | 46.90124 | 26.07279 | 11.12.2013 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 12533 | |
| 63143 | 63143 | BOUTIQUE BELVEDERE | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 32 | 16 | Oraş Sinaia | PRAHOVA | STR. Strada Opler | 45.3619802 | 25.5422023 | 12.10.2011 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 15979 | |
| 63752 | 63752 | DOME APART | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 32 | 16 | Mun. Satu Mare | SATU MARE | STR. Strada Corneliu Coposu , NR. 5 | 47.7915613 | 22.8733369 | 17.10.2023 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 36494 | |
| 64772 | 64772 | PLAZA N⁰ 35″ | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 66 | 33 | Mun. Sibiu | SIBIU | STR. Strada Oituz , NR. 35D | 45.7826164 | 24.1487646 | 07.08.2018 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 17802 | |
| 66061 | 66061 | ELECTRA | RO | stay | hotels | aparthotel | normal | 3 | star | 3 - STELE | 36 | 18 | Mun. Rădăuţi | SUCEAVA | STR. Strada Volovăţului , NR. 80 | 47.8371559918552 | 25.9098159338379 | 07.04.2025 | RO-SITUR | HOTEL APARTAMENT | 3 - STELE | 42146 | |
| 66965 | 66965 | IOSEFIN RESIDENCE | RO | stay | hotels | aparthotel | normal | 4 | star | 4 - STELE | 50 | 25 | Mun. Timişoara | TIMIŞ | NR. 8 | 45.746735 | 21.215908 | 08.06.2012 | RO-SITUR | HOTEL APARTAMENT | 4 - STELE | 14299/8759 |
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");