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

9 rows where country = "RO", family = "resorts" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: capacity_persons, rooms, city, municipality, address, lat, lng, valid_until

venue_type 1

rating_value 1

group 1

family 1

  • resorts · 9 ✖

country 1

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
39660 39660 TAUŢ RO stay resorts holiday_village_resort normal 2 star 2 - STELE 99 30 Com. Tauţ, Sat Tauţ ARAD   46.289918 21.9107523 13.05.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 11147
42670 42670 CLUB VILA BRAN RO stay resorts holiday_village_resort normal 2 star 2 - STELE 48 24 Com. Bran, Sat Sohodol BRAŞOV STR. Strada Aluniş , NR. 13 45.5230653 25.3711609 22.07.2022   RO-SITUR SAT DE VACANȚĂ 2 - STELE 2508/652
44640 44640 CENTRUL DE ECHITAŢIE RO stay resorts holiday_village_resort normal 2 star 2 - STELE 62 10 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.6041286 25.5522439 10.03.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 1646/1246
46456 46456 IC PONOR-PADIŞ RO stay resorts holiday_village_resort normal 2 star 2 - STELE 12 6 Com. Mărgău, Sat Răchiţele CLUJ NR. 333A 46.6397813 22.8183117 13.10.2014   RO-SITUR SAT DE VACANȚĂ 2 - STELE 10397/8930
54498 54498 BOROS RO stay resorts holiday_village_resort normal 2 star 2 - STELE 76 25 Com. Lunca de Jos, Sat Valea Boroş HARGHITA NR. 65 46.5458508 25.9881812 03.09.2020   RO-SITUR SAT DE VACANȚĂ 2 - STELE 12017/7967
60939 60939 INTEGRO VILELE 4,5 RO stay resorts holiday_village_resort normal 2 star 2 - STELE 22 10 Com. Lunca Bradului, Sat Sălard MUREŞ   46.9368484 25.0802795 12.05.2011   RO-SITUR SAT DE VACANȚĂ 2 - STELE 14515A
65188 65188 MĂRŢIŞORUL CACICA RO stay resorts holiday_village_resort normal 2 star 2 - STELE 72 24 Com. Cacica, Sat Cacica SUCEAVA NR. 965 C 47.6359735 25.9015679 14.04.2021   RO-SITUR SAT DE VACANȚĂ 2 - STELE 23028
67741 67741 SAGEATA APEI RO stay resorts holiday_village_resort normal 2 star 2 - STELE 32 16 Com. Nufăru, Sat Nufăru TULCEA   45.148473 28.9252723 02.09.2011   RO-SITUR SAT DE VACANȚĂ 2 - STELE 8287/5097
67742 67742 SĂGEATA APEI RO stay resorts holiday_village_resort normal 2 star 2 - STELE 32 16 Com. Nufăru, Sat Nufăru TULCEA   45.148473 28.9252723 02.09.2011   RO-SITUR SAT DE VACANȚĂ 2 - STELE 25066

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");