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
218 rows where country = "RO" and venue_type = "motel"
This data as json, CSV (advanced)
Suggested facets: rating_label, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | |
| 44757 | 44757 | DÂRSTE | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 47 | 21 | Mun. Săcele | BRAŞOV | STR. Strada Calea Bucureşti , NR. 2A | 45.6086553 | 25.6570928 | 16.01.2023 | RO-SITUR | MOTEL | 3 - STELE | 5379/3681 | |
| 44758 | 44758 | DELOREAN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 38 | 18 | Mun. Săcele | BRAŞOV | STR. Strada Calea Bucureşti | 45.6067291 | 25.6534711 | 08.12.2021 | RO-SITUR | MOTEL | 3 - STELE | 10963/6927 | |
| 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 | |
| 45026 | 45026 | COTUL DONULUI | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 51 | 22 | Oraş Predeal, Loc. Timişu de Sus | BRAŞOV | NR. 76 | 45.524233 | 25.570461 | 23.10.2017 | RO-SITUR | MOTEL | 3 - STELE | 14844A | |
| 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 | |
| 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 | |
| 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 | |
| 45562 | 45562 | EDEN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 25 | 13 | Mun. Râmnicu Sărat | BUZĂU | STR. Strada Constantin Brâncoveanu , NR. 35 | 45.3767212 | 27.0453362 | 02.10.2012 | RO-SITUR | MOTEL | 3 - STELE | 12864 | |
| 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 | ||
| 45609 | 45609 | ALBATROS HORECA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 84 | 43 | Mun. Călăraşi | CĂLĂRAŞI | STR. Şoseaua Chiciului , NR. 7 | 44.1322115 | 27.2691396 | 16.09.2021 | RO-SITUR | MOTEL | 3 - STELE | 3074/4244 | |
| 45624 | 45624 | POEM | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 24 | 12 | Mun. Călăraşi | CĂLĂRAŞI | STR. Strada Varianta Nord , NR. 7C | 44.2701454 | 27.0910242 | 16.04.2014 | RO-SITUR | MOTEL | 3 - STELE | 10975/6956 | |
| 45639 | 45639 | NICOL | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 12 | 6 | Com. Armeniş, Sat Armeniş | CARAŞ-SEVERIN | NR. 215B | 45.2170402 | 22.3015621 | 26.05.2022 | RO-SITUR | MOTEL | 3 - STELE | 24914 | |
| 46058 | 46058 | SFINXUL BĂNĂŢEAN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 36 | 18 | Oraş Băile Herculane | CARAŞ-SEVERIN | STR. Strada Gării | 44.8693542 | 22.3880844 | 04.11.2011 | RO-SITUR | MOTEL | 3 - STELE | 12228/8226 | |
| 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 | |
| 46405 | 46405 | POENARU | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 110 | 47 | Com. Gilău, Sat Gilău | CLUJ | NR. 1311 | 46.7448518 | 23.4499548 | 12.05.2011 | RO-SITUR | MOTEL | 3 - STELE | 14821A | |
| 46697 | 46697 | ANDREI | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 30 | 15 | Mun. Câmpia Turzii | CLUJ | STR. Strada Laminoriştilor , NR. 202 | 46.557315 | 23.869838 | 17.08.2010 | RO-SITUR | MOTEL | 3 - STELE | 13654 | |
| 47447 | 47447 | ETRUSCO | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 26 | 13 | Mun. Gherla | CLUJ | STR. Strada Clujului , NR. 17 | 47.0252665 | 23.8923103 | 03.02.2012 | RO-SITUR | MOTEL | 3 - STELE | 12550/8559 | |
| 47531 | 47531 | SUNGARDEN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 38 | 19 | Mun. Turda | CLUJ | STR. Strada Clujului , NR. 71 | 46.5857753 | 23.759583 | 25.09.2018 | RO-SITUR | MOTEL | 3 - STELE | 18344 | |
| 49523 | 49523 | NORDIANA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 30 | 14 | Mun. Mangalia | CONSTANŢA | STR. Şoseaua Constanţei , NR. 57 C | 43.8227976 | 28.5822179 | 13.09.2011 | RO-SITUR | MOTEL | 3 - STELE | 10710/7990 | |
| 52983 | 52983 | HOTARUL CIUCULUI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 29 | 11 | Com. Bixad, Sat Bixad | COVASNA | 45.9426347 | 25.8918984 | 17.11.2015 | RO-SITUR | MOTEL | 2 - STELE | 29019 | ||
| 52995 | 52995 | BENZ MAR | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 20 | 10 | Com. Breţcu, Sat Breţcu | COVASNA | NR. 828 | 46.0578247 | 26.3528195 | 08.04.2010 | RO-SITUR | MOTEL | 2 - STELE | 8330/6558 | |
| 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 | ||
| 53063 | 53063 | NEMERE | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 16 | 8 | Com. Reci, Sat Reci | COVASNA | 45.8504868 | 25.9058554 | 29.07.2013 | RO-SITUR | MOTEL | 2 - STELE | 6636/5678 | ||
| 53064 | 53064 | NUFARUL | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 42 | 21 | Com. Reci, Sat Reci | COVASNA | 45.8337983 | 25.9633486 | 27.07.2011 | RO-SITUR | MOTEL | 2 - STELE | 15136A | ||
| 53261 | 53261 | DRAGODANA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 32 | 16 | Com. Dragodana, Sat Dragodana | DÂMBOVIŢA | 44.7342665 | 25.3656814 | 11.08.2009 | RO-SITUR | MOTEL | 2 - STELE | 1409/1315 | ||
| 53358 | 53358 | HANUL MĂRULUI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 22 | 11 | Com. Voineşti, Sat Onceşti | DÂMBOVIŢA | 45.1105953 | 25.2092849 | 18.01.2012 | RO-SITUR | MOTEL | 2 - STELE | 16412 | ||
| 53407 | 53407 | CRISGAB | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 18 | 9 | Oraş Găeşti | DÂMBOVIŢA | STR. Strada Nicolae Titulescu , NR. 23B | 44.7206661 | 25.3169645 | 08.02.2011 | RO-SITUR | MOTEL | 2 - STELE | 4523/1818 | |
| 53415 | 53415 | DEBARCADER BLANDA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 20 | 10 | Oraş Pucioasa | DÂMBOVIŢA | STR. Aleea Debarcaderului | 45.0901739 | 25.4304747 | 14.08.2009 | RO-SITUR | MOTEL | 3 - STELE | 12968 | |
| 53479 | 53479 | HANUL VECHI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 16 | 8 | Com. Pieleşti, Sat Pieleşti | DOLJ | STR. Calea Bucureşti , NR. 121 | 44.3136532 | 23.908548 | 19.01.2011 | RO-SITUR | MOTEL | 2 - STELE | 13822 | |
| 53480 | 53480 | IL CAPO TOUR | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 40 | 20 | Com. Pieleşti, Sat Pieleşti | DOLJ | STR. Calea Bucureşti , NR. 125 | 44.3127064 | 23.9036572 | 31.05.2010 | RO-SITUR | MOTEL | 2 - STELE | 6362/4138 | |
| 53595 | 53595 | HANUL DOCTORULUI | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 56 | 28 | Mun. Craiova | DOLJ | STR. Strada Viitorului , NR. 1 | 44.3144231 | 23.8623812 | 10.11.2011 | RO-SITUR | MOTEL | 2 - STELE | 9170/5763 | |
| 53641 | 53641 | STEAUA NORDULUI | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 20 | 10 | Mun. Craiova | DOLJ | STR. Aleea 4 Şimnic , NR. 46 | 44.3391551 | 23.7945678 | 12.04.2011 | RO-SITUR | MOTEL | 3 - STELE | 14201A | |
| 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 | ||
| 53686 | 53686 | DIDONA B | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 37 | 19 | Com. Şendreni, Sat Şendreni | GALAŢI | 45.413858 | 27.9210599 | 22.01.2021 | RO-SITUR | MOTEL | 3 - STELE | 22612 | ||
| 53692 | 53692 | NEF | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 26 | 13 | Com. Tuluceşti, Sat Tuluceşti | GALAŢI | NR. 1520 | 45.5661305 | 28.0435022 | 26.08.2019 | RO-SITUR | MOTEL | 3 - STELE | 20265 | |
| 53703 | 53703 | ANGHEL | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 20 | 10 | Mun. Galaţi | GALAŢI | STR. Strada Theodor Neculuţă , NR. 19 | 45.4424391 | 28.0368463 | 14.03.2011 | RO-SITUR | MOTEL | 3 - STELE | 11413/7387 | |
| 53795 | 53795 | CORAL | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 17 | 9 | Mun. Tecuci | GALAŢI | STR. Strada Tecuciul Nou , NR. 127 | 45.8574799 | 27.4256626 | 13.01.2014 | RO-SITUR | MOTEL | 3 - STELE | 27556 | |
| 53817 | 53817 | ARIS | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 10 | 5 | Com. Frăteşti, Sat Remuş | GIURGIU | STR. Strada Bucureşti , NR. 2 | 43.8965867 | 25.9623202 | 24.11.2020 | RO-SITUR | MOTEL | 2 - STELE | 10002/7506 | |
| 53835 | 53835 | AZUR | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 12 | 6 | Com. Ulmi, Sat Căscioarele | GIURGIU | 44.5191373 | 25.7456057 | 10.10.2011 | RO-SITUR | MOTEL | 2 - STELE | 5134/3545 | ||
| 53840 | 53840 | PRIETENIA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 80 | 39 | Mun. Giurgiu | GIURGIU | STR. Şoseaua Prieteniei , NR. 3 | 43.9086739 | 25.9805875 | 02.04.2012 | RO-SITUR | MOTEL | 3 - STELE | 1593/1683 | |
| 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 | |
| 53846 | 53846 | CASA BOBE 1 | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 34 | 18 | Oraş Bolintin-Vale | GIURGIU | STR. Strada Palanca , NR. 1 | 44.461826 | 25.736085 | 12.10.2011 | RO-SITUR | MOTEL | 3 - STELE | 6044/3699 | |
| 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 | |
| 53973 | 53973 | AZUR | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 14 | 6 | Com. Câlnic, Sat Câlnic | GORJ | 44.9359188 | 23.0347832 | 09.04.2012 | RO-SITUR | MOTEL | 3 - STELE | 12048/8605 | ||
| 54181 | 54181 | DASIANA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 30 | 12 | Mun. Târgu Jiu | GORJ | STR. Strada Jiului | 45.0426612 | 23.2633954 | 09.04.2012 | RO-SITUR | MOTEL | 3 - STELE | 6424/5922 | |
| 54182 | 54182 | DAVIOS | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 26 | 13 | Mun. Târgu Jiu | GORJ | STR. Strada Jiului , NR. 3 | 45.0394597 | 23.262881 | 31.05.2012 | RO-SITUR | MOTEL | 3 - STELE | 12733/8726 | |
| 54205 | 54205 | LA NARCISE | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 47 | 18 | Mun. Târgu Jiu | GORJ | STR. Strada Narciselor , NR. 111 | 45.0549743 | 23.2994773 | 30.11.2010 | RO-SITUR | MOTEL | 2 - STELE | 13778 | |
| 54242 | 54242 | EUROPA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 18 | 9 | Oraş Bumbeşti-Jiu | GORJ | STR. Strada Vişina , NR. 8 | 45.194914 | 23.383797 | 29.11.2011 | RO-SITUR | MOTEL | 2 - STELE | 15313/8429 | |
| 54243 | 54243 | VIŞINA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 40 | 20 | Oraş Bumbeşti-Jiu | GORJ | STR. Strada Vişina , NR. 13 | 45.1935687 | 23.3909673 | 17.02.2021 | RO-SITUR | MOTEL | 2 - STELE | 9464 | |
| 54533 | 54533 | NYIKO | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 56 | 24 | Com. Lupeni, Sat Lupeni | HARGHITA | NR. 644 | 46.378821 | 25.2228259 | 07.06.2011 | RO-SITUR | MOTEL | 2 - STELE | 8484/7194A | |
| 54886 | 54886 | IMOLA | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 44 | 18 | Mun. Gheorgheni | HARGHITA | STR. Strada Nicolae Bălcescu | 46.7248885 | 25.588483 | 09.05.2011 | RO-SITUR | MOTEL | 2 - STELE | 8492/7554A | |
| 54944 | 54944 | CSILLAG | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 50 | 20 | Mun. Miercurea Ciuc | HARGHITA | NR. 172/A | 46.362871 | 25.7998274 | 16.12.2014 | RO-SITUR | MOTEL | 2 - STELE | 8804/6356 | |
| 54983 | 54983 | TRANSILVANIA GARDEN HOUSE | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 16 | 8 | Mun. Miercurea Ciuc | HARGHITA | STR. Strada Zenit , NR. 4 | 46.3753851 | 25.724163 | 03.10.2019 | RO-SITUR | MOTEL | 3 - STELE | 20529 | |
| 55246 | 55246 | CASABLANCA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 24 | 12 | Com. Băcia, Sat Băcia | HUNEDOARA | NR. 69 B | 45.8035396 | 23.00982 | 09.05.2011 | RO-SITUR | MOTEL | 3 - STELE | 11516/7521 | |
| 55248 | 55248 | MAGIC | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 24 | 11 | Com. Băcia, Sat Băcia | HUNEDOARA | NR. 189 BIS | 45.3338035 | 23.1233098 | 17.05.2010 | RO-SITUR | MOTEL | 2 - STELE | 4129/1168 | |
| 55490 | 55490 | CINCIŞ | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 27 | 13 | Com. Teliucu Inferior, Sat Cinciş-Cerna | HUNEDOARA | 45.6967103 | 22.8727815 | 02.04.2012 | RO-SITUR | MOTEL | 3 - STELE | 2101/1398 | ||
| 55504 | 55504 | CINCIŞ | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 36 | 18 | Com. Teliucu Inferior, Sat Teliucu Inferior | HUNEDOARA | 45.6967103 | 22.8727815 | 21.01.2016 | RO-SITUR | MOTEL | 3 - STELE | 29412 | ||
| 55608 | 55608 | MAESTRO | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 41 | 19 | Mun. Deva | HUNEDOARA | NR. 1 | 45.8676338 | 22.9233979 | 12.09.2011 | RO-SITUR | MOTEL | 3 - STELE | 5342/3352 | |
| 55616 | 55616 | PACIFIC | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 52 | 24 | Mun. Deva | HUNEDOARA | STR. Strada Sântuhalm , NR. 69 | 45.8579684 | 22.9435697 | 03.05.2012 | RO-SITUR | MOTEL | 2 - STELE | 6051/3765 | |
| 55636 | 55636 | ALASKA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 14 | 7 | Mun. Deva, Loc. Sântuhalm | HUNEDOARA | 45.8579588 | 22.9436132 | 17.03.2014 | RO-SITUR | MOTEL | 3 - STELE | 7059/5085 | ||
| 55936 | 55936 | HANUL DOMNESC | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 22 | 11 | Oraş Călan | HUNEDOARA | STR. Strada 1 Decembrie , NR. 155 | 45.7310108 | 22.9965116 | 17.12.2020 | RO-SITUR | MOTEL | 3 - STELE | 31144 | |
| 55939 | 55939 | IZVORUL RECE | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 38 | 19 | Oraş Geoagiu, Sat Aurel Vlaicu | HUNEDOARA | 45.8919759 | 22.9044664 | 15.03.2011 | RO-SITUR | MOTEL | 2 - STELE | 13990A | ||
| 55995 | 55995 | DEALUL VIILOR | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 91 | 46 | Oraş Haţeg | HUNEDOARA | STR. Strada Viilor , NR. 40 | 45.6164768 | 22.9644675 | 22.05.2018 | RO-SITUR | MOTEL | 2 - STELE | 31579 | |
| 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 | |
| 56017 | 56017 | VIP | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 24 | 12 | Oraş Haţeg | HUNEDOARA | STR. Strada Nicolae Titulescu , NR. 8 A | 45.6120046 | 22.9546551 | 20.12.2016 | RO-SITUR | MOTEL | 3 - STELE | 30447 | |
| 56026 | 56026 | PRISLOP | RO | stay | hotels | motel | normal | 2 | star | 2 - STELE | 71 | 23 | Oraş Haţeg, Sat Silvaşu de Sus | HUNEDOARA | NR. 68A | 45.6317607 | 22.8503394 | 05.08.2024 | RO-SITUR | MOTEL | 2 - STELE | 30923 | |
| 56060 | 56060 | VALENTINA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 16 | 8 | Com. Ion Roată, Sat Ion Roată | IALOMIŢA | STR. Şoseaua Bucureşti-Constanţa , NR. 151 | 44.6558453 | 26.8052131 | 18.02.2019 | RO-SITUR | MOTEL | 3 - STELE | 12771 | |
| 56063 | 56063 | LA POPESCU | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 52 | 26 | Mun. Feteşti | IALOMIŢA | NR. 55 | 44.3929197 | 27.8507334 | 18.02.2011 | RO-SITUR | MOTEL | 3 - STELE | 13853A | |
| 56073 | 56073 | PRIVGHETOAREA | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 32 | 16 | Mun. Slobozia | IALOMIŢA | 44.5601918 | 27.3741451 | 30.09.2024 | RO-SITUR | MOTEL | 3 - STELE | 10402/7419 | ||
| 56081 | 56081 | RIDEN | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 28 | 14 | Mun. Urziceni | IALOMIŢA | 44.7053505 | 26.6724287 | 24.03.2014 | RO-SITUR | MOTEL | 3 - STELE | 13867/7474 | ||
| 56088 | 56088 | DIAMANT | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 28 | 14 | Oraş Amara, Sat Amara | IALOMIŢA | 44.5726375 | 27.3431306 | 01.03.2011 | RO-SITUR | MOTEL | 3 - STELE | 8341/5424A | ||
| 56096 | 56096 | CARGO | RO | stay | hotels | motel | normal | 3 | star | 3 - STELE | 22 | 10 | Oraş Ţăndărei | IALOMIŢA | NR. 46 | 44.640767 | 27.6543682 | 09.08.2011 | RO-SITUR | MOTEL | 3 - STELE | 15388A | |
| 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 |
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");