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

17 rows where rating_value = 4 and venue_type = "boat_lodging"

This data as json, CSV (advanced)

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

venue_type 1

  • boat_lodging · 17 ✖

rating_value 1

group 1

family 1

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
66550 66550 DANUBIUS PONTIC RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Oraş Zimnicea TELEORMAN STR. Strada Portului , NR. 1 43.648962 25.3686501 12.09.2012   RO-SITUR PONTON PLUTITOR 4 - STELE 25639
67244 67244 BELLA MARINA RO stay other_stay boat_lodging normal 4 star 4 - STELE 114 53 Com. Beştepe, Sat Beştepe TULCEA   45.1016804 29.0116156 01.09.2022   RO-SITUR PONTON PLUTITOR 4 - STELE 30190
67321 67321 SINCRON DELTA PD 7620 RO stay other_stay boat_lodging normal 4 star 4 - STELE 16 8 Com. Crişan, Sat Crişan TULCEA   45.1743855 29.3851996 05.07.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 6585/4940
67504 67504 SĂGEATA APEI RO stay other_stay boat_lodging normal 4 star 4 - STELE 16 8 Com. Mahmudia, Sat Mahmudia TULCEA   45.0880812 29.0949815 04.08.2015   RO-SITUR PONTON PLUTITOR 4 - STELE 10283/6118
67520 67520 PD 2178 ARCA RO stay other_stay boat_lodging normal 4 star 4 - STELE 16 8 Com. Maliuc, Sat Maliuc TULCEA BL. 2 , ET. 2 , AP. 9 45.1764537 29.1136044 13.11.2012   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 25870
67677 67677 MAGIA DELTEI RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Com. Murighiol, Sat Murighiol TULCEA   45.0436993 29.1918835 24.08.2017   RO-SITUR PONTON PLUTITOR 4 - STELE 30691
67685 67685 PARADISUL DELTEI RO stay other_stay boat_lodging normal 4 star 4 - STELE 16 8 Com. Murighiol, Sat Murighiol TULCEA   45.0436993 29.1918835 24.08.2017   RO-SITUR PONTON PLUTITOR 4 - STELE 30692
67713 67713 PD 1444 RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Com. Murighiol, Sat Uzlina TULCEA   45.073084 29.2261849 23.02.2011   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 13876
67889 67889 ANDA RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Mun. Tulcea TULCEA STR. Strada Portului , NR. 40 45.1802242 28.7945243 16.06.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 7236/5174
67933 67933 FINESSE RO stay other_stay boat_lodging normal 4 star 4 - STELE 20 10 Mun. Tulcea TULCEA   45.1716165 28.7914439 26.09.2011   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 8874/5758
67950 67950 MILENA NR. 2846 RO stay other_stay boat_lodging normal 4 star 4 - STELE 20 10 Mun. Tulcea TULCEA NR. 3 45.1716165 28.7914439 24.04.2012   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 17265
67954 67954 P/D 1986 RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Mun. Tulcea TULCEA   45.1716165 28.7914439 09.07.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 13569
67955 67955 PD 2069 RO stay other_stay boat_lodging normal 4 star 4 - STELE 21 11 Mun. Tulcea TULCEA   45.0450565 29.0324912 09.07.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 8338/1461
67956 67956 PD 2129 RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Mun. Tulcea TULCEA   45.1801628 28.7997673 21.02.2011   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 8340/5366A
67964 67964 SERANO RO stay other_stay boat_lodging normal 4 star 4 - STELE 10 10 Mun. Tulcea TULCEA   45.1716165 28.7914439 06.10.2015   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 28842
67966 67966 SINCRON DELTA PD 7620 RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Mun. Tulcea TULCEA   45.1801628 28.7997673 02.09.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 7348/7053
67969 67969 STEAUA DELTEI PD 2168 RO stay other_stay boat_lodging normal 4 star 4 - STELE 18 9 Mun. Tulcea TULCEA   45.1801628 28.7997673 09.07.2010   RO-SITUR NAVĂ FLUVIALĂ 4 - STELE 9297/1462

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