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
41 rows where country = "RO", family = "hotels" and rating_value = 1
This data as json, CSV (advanced)
Suggested facets: rooms, municipality, address, source_type
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39515 | 39515 | DACIA | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 100 | 39 | Mun. Sebeş | ALBA | STR. Strada Drumul Sibiului , NR. 42 | 45.950638 | 23.582642 | 16.04.2026 | RO-SITUR | MOTEL | 1 - STELE | 18062 | |
| 40002 | 40002 | SORELO | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 36 | 18 | Com. Bascov, Sat Valea Ursului | ARGEŞ | 44.8895874 | 24.7660705 | 11.08.2010 | RO-SITUR | HOTEL | 1 - STELE | 7010/5052 | ||
| 40633 | 40633 | STANS | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 19 | 8 | Com. Parava, Sat Drăguşani | BACĂU | 46.2964211 | 26.9929444 | 06.09.2011 | RO-SITUR | MOTEL | 1 - STELE | 15546 | ||
| 41554 | 41554 | CRISUL NEGRU | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 25 | 10 | Mun. Beiuş | BIHOR | STR. Strada Ioan Ciordaş , NR. 2 | 46.6664118 | 22.3433405 | 02.08.2010 | RO-SITUR | HOTEL | 1 - STELE | 7523/6977 | |
| 42058 | 42058 | DUMBRAVA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 70 | 30 | Com. Livezile, Sat Dumbrava | BISTRIŢA-NĂSĂUD | NR. 57 | 47.2128415 | 24.6197811 | 07.12.2022 | RO-SITUR | HOTEL | 1 - STELE | 32861 | |
| 42412 | 42412 | MIMI | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 23 | 8 | Oraş Ianca, Sat Oprişeneşti | BRĂILA | 45.1370372 | 27.5478538 | 03.03.2011 | RO-SITUR | MOTEL | 1 - STELE | 13923B1A | ||
| 44562 | 44562 | TRAIAN | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 242 | 78 | Mun. Braşov | BRAŞOV | STR. Strada Lunii , NR. 7 | 45.6457855 | 25.6252161 | 15.06.2011 | RO-SITUR | HOTEL | 1 - STELE | 11363/7783 | |
| 45517 | 45517 | COROANA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 43 | 16 | Mun. Buzău | BUZĂU | STR. Bulevardul Nicolae Bălcescu , NR. 2 , BL. Coroana | 45.1533553 | 26.8198022 | 26.11.2015 | RO-SITUR | HOTEL | 1 - STELE | 1239/256 | |
| 46941 | 46941 | CRAMA HAIDUCILOR | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 16 | 6 | Mun. Cluj-Napoca | CLUJ | STR. Strada Cometei , NR. 12-14 | 46.7532501 | 23.5938999 | 05.04.2022 | RO-SITUR | HOTEL | 1 - STELE | 12685/8737 | |
| 48058 | 48058 | SERENA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 48 | 12 | Com. Costineşti, Sat Costineşti | CONSTANŢA | 43.9569653 | 28.6380974 | 04.10.2011 | RO-SITUR | HOTEL | 1 - STELE | 15885 | ||
| 49879 | 49879 | ADRIANA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 10 | 5 | Mun. Mangalia, Loc. Venus | CONSTANŢA | 43.8517684 | 28.5938525 | 29.09.2009 | RO-SITUR | HOTEL | 1 - STELE | 2421/6354 | ||
| 49995 | 49995 | ADRIANO | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 46 | 23 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Aleea Belona | 44.0583801 | 28.6398766 | 02.03.2023 | RO-SITUR | HOTEL | 1 - STELE | 14897/8835 | |
| 50274 | 50274 | CRISTAL | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 79 | 37 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Bulevardul Republicii , NR. 1 | 44.075128 | 28.6274401 | 08.06.2011 | RO-SITUR | HOTEL | 1 - STELE | 1994/195 | |
| 50275 | 50275 | CRISTAL | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 79 | 37 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Bulevardul Republicii , NR. 1 | 44.075128 | 28.6274401 | 08.06.2011 | RO-SITUR | HOTEL | 1 - STELE | 1944/195 | |
| 50395 | 50395 | LEBADA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 48 | 24 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Strada Mihail Kogălniceanu , NR. 8 | 44.0625143 | 28.6334588 | 06.04.2010 | RO-SITUR | HOTEL | 1 - STELE | 402/1182 | |
| 50510 | 50510 | RYANNA BEACH | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 44 | 22 | Oraş Eforie, Loc. Eforie Nord | CONSTANŢA | STR. Aleea Belona | 44.0585443 | 28.6399417 | 02.03.2023 | RO-SITUR | HOTEL | 1 - STELE | 29192 | |
| 53016 | 53016 | DOZSA | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 13 | 5 | Com. Dalnic, Sat Dalnic | COVASNA | 45.9261609 | 26.019188 | 21.04.2011 | RO-SITUR | MOTEL | 1 - STELE | 12134/7572B1 | ||
| 53382 | 53382 | KING | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 66 | 34 | Mun. Târgovişte | DÂMBOVIŢA | STR. Bulevardul Regele Carol I , NR. 7 | 44.9231332 | 25.4575098 | 05.11.2012 | RO-SITUR | HOTEL | 1 - STELE | 8681/5520 | |
| 53680 | 53680 | SOFIA & CO | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 73 | 22 | Com. Fundeni, Sat Hanu Conachi | GALAŢI | 45.5803451 | 27.6028377 | 07.03.2011 | RO-SITUR | MOTEL | 1 - STELE | 7851/5422A | ||
| 53738 | 53738 | DAS HOTEL | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 33 | 13 | Mun. Galaţi | GALAŢI | STR. Calea Prutului , NR. 55 , BL. Hala 1 | 45.4482613 | 28.0786621 | 02.10.2012 | RO-SITUR | HOTEL | 1 - STELE | 14040A | |
| 53776 | 53776 | SPORT | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 43 | 17 | Mun. Galaţi | GALAŢI | STR. Strada Alexandru Ioan Cuza , NR. 76-78 | 45.4520931 | 28.0366807 | 19.09.2018 | RO-SITUR | HOTEL | 1 - STELE | 7235/4962 | |
| 53845 | 53845 | CASA BOBE | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 16 | 8 | Oraş Bolintin-Vale | GIURGIU | STR. Strada Palanca , NR. 1 | 44.461826 | 25.736085 | 12.10.2011 | RO-SITUR | MOTEL | 1 - STELE | 25201 | |
| 53851 | 53851 | NEXT DOVINOT | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 40 | 20 | Oraş Mihăileşti | GIURGIU | STR. Calea Bucureşti , NR. 491 | 44.3086979 | 25.8941468 | 13.12.2016 | RO-SITUR | MOTEL | 1 - STELE | 18368 | |
| 55831 | 55831 | AUGUSTA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 16 | 8 | Mun. Orăştie | HUNEDOARA | STR. Strada Nicolae Bălcescu | 45.8401764 | 23.1960547 | 02.07.2019 | RO-SITUR | HOTEL | 1 - STELE | 30450 | |
| 56000 | 56000 | HANUL BUCURA | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 39 | 15 | Oraş Haţeg | HUNEDOARA | STR. Strada Viilor , NR. 5 | 45.616166 | 22.9583213 | 15.04.2019 | RO-SITUR | MOTEL | 1 - STELE | 8097/6716 | |
| 56113 | 56113 | TREI IAZURI | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 16 | 8 | Com. Butea, Sat Miclăuşeni | IAŞI | 47.0978288 | 26.9303591 | 20.09.2011 | RO-SITUR | MOTEL | 1 - STELE | 1786/158 | ||
| 58029 | 58029 | BRAD | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 18 | 11 | Oraş Vişeu de Sus | MARAMUREŞ | STR. Strada 22 Decembrie , NR. 50 | 47.7075368 | 24.4323317 | 15.11.2011 | RO-SITUR | HOTEL | 1 - STELE | 6479/5430 | |
| 58678 | 58678 | CARPATI | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 58 | 43 | Mun. Bucureşti, Sector 1 | MUNICIPIUL BUCUREŞTI | NR. 16 | 44.436458 | 26.09504 | 22.11.2009 | RO-SITUR | HOTEL | 1 - STELE | 3240/1123 | |
| 59095 | 59095 | SIR GARA DE NORD | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 128 | 82 | Mun. Bucureşti, Sector 1 | MUNICIPIUL BUCUREŞTI | STR. Bulevardul Dinicu Golescu , NR. 29 | 44.4449399 | 26.0744251 | 01.10.2013 | RO-SITUR | HOTEL | 1 - STELE | 202/758A | |
| 59942 | 59942 | RUBIN | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 230 | 82 | Mun. Bucureşti, Sector 3 | MUNICIPIUL BUCUREŞTI | STR. Şoseaua Gării Căţelu , NR. 170-174 | 44.4269071 | 26.2183973 | 02.04.2010 | RO-SITUR | HOTEL | 1 - STELE | 9285/6536 | |
| 61298 | 61298 | TREI BRAZI | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 42 | 21 | Mun. Târnăveni | MUREŞ | STR. Strada Păltiniş , NR. 1 | 46.3366814 | 24.2923573 | 15.03.2011 | RO-SITUR | HOTEL | 1 - STELE | 3206/1942A | |
| 62180 | 62180 | ROMANESTI II | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 8 | 6 | Com. Bărcăneşti, Sat Româneşti | PRAHOVA | 44.883333 | 26.05 | 27.10.2010 | RO-SITUR | MOTEL | 1 - STELE | 3746/1374 | ||
| 62454 | 62454 | TINERETULUI | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 54 | 27 | Mun. Câmpina | PRAHOVA | STR. Bulevardul Nicolae Bălcescu , NR. 50 | 45.118817 | 25.7414802 | 20.10.2011 | RO-SITUR | HOTEL | 1 - STELE | 2286/234 | |
| 62595 | 62595 | BREAZA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 21 | 14 | Oraş Breaza | PRAHOVA | STR. Aleea Nucilor , NR. 4 | 45.181648 | 25.6696015 | 10.06.2024 | RO-SITUR | HOTEL | 1 - STELE | 15641 | |
| 65042 | 65042 | LA TREI FRATI VLADUT | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 14 | 7 | Oraş Miercurea Sibiului, Sat Apoldu de Sus | SIBIU | 45.8512529 | 23.8253025 | 05.08.2009 | RO-SITUR | MOTEL | 1 - STELE | 10051/6222 | ||
| 66075 | 66075 | MARIA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 13 | 6 | Mun. Rădăuţi | SUCEAVA | STR. Piaţa Unirii , NR. 4 | 47.8445241 | 25.917686 | 15.07.2019 | RO-SITUR | HOTEL | 1 - STELE | 11135/7820 | |
| 66146 | 66146 | SOCIM | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 76 | 34 | Mun. Suceava | SUCEAVA | STR. Strada Jean Bart , NR. 24 | 47.6724528 | 26.2676759 | 16.09.2009 | RO-SITUR | HOTEL | 1 - STELE | 13032 | |
| 68152 | 68152 | TOPOLOG | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 46 | 23 | Com. Milcoiu, Sat Milcoiu | VÂLCEA | 45.0377289 | 24.4742367 | 29.01.2014 | RO-SITUR | MOTEL | 1 - STELE | 1746/202 | ||
| 68254 | 68254 | VIDRUTA | RO | stay | hotels | hotel | normal | 1 | star | 1 - STELE | 320 | 169 | Com. Voineasa, Sat Voineasa | VÂLCEA | STR. Strada Mihai Eminescu , NR. 1 | 45.4190993 | 23.9643306 | 25.05.2010 | RO-SITUR | HOTEL | 1 - STELE | 956/295 | |
| 68290 | 68290 | CAPELA | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 86 | 46 | Mun. Râmnicu Vâlcea | VÂLCEA | STR. Aleea Castanilor , NR. 19 | 45.1076665 | 24.3578848 | 31.10.2011 | RO-SITUR | MOTEL | 1 - STELE | 1873/348 | |
| 68866 | 68866 | HANUL BACHUS | RO | stay | hotels | motel | normal | 1 | star | 1 - STELE | 50 | 19 | Com. Urecheşti, Sat Urecheşti | VRANCEA | 45.610154 | 27.1037048 | 12.08.2010 | RO-SITUR | MOTEL | 1 - STELE | 3100/788 |
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");