venues
Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · PT · PL · IE · HR · GR · ME)
- 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)
- best_for
- The single event this venue is best suited to (blank = not an event venue)
- fit_wedding
- Wedding-suitability score 0–100 (type + capacity + rating)
- fit_conference
- Conference-suitability score 0–100
- fit_banquet
- Banquet-suitability score 0–100
- fit_spa
- Spa-retreat-suitability score 0–100
- fit_party
- Party/celebration-suitability score 0–100
- common_areas
- On-site shared function space, from the register only (event_venue) — blank = not stated, never inferred
- reachability_score
- How easy to reach 0–100 (nearer airport + city = higher)
- isolation_score
- How remote 0–100 (farther from towns + fewer nearby venues = higher)
- airport_km
- Distance to nearest airport (km)
- nearest_airport
- Nearest airport (IATA or name)
- city_km
- Distance to nearest city ≥15k people (km)
- town_km
- Distance to nearest settlement ≥500 people (km)
- venues_5km
- Number of other venues within 5 km (local density)
- cert_number
- Certificate / registration number in the national register
- source
- Source register the row came from
13 rows where country = "BG", family = "other_stay" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: venue_type, rooms, reachability_score, isolation_score, airport_km, nearest_airport, city_km, town_km, venues_5km, city, municipality, lat, lng, valid_until, source_type, valid_until (date)
| Link | rowid ▼ | name | country | group | family | venue_type | type_granularity | rating_value | rating_scheme | rating_label | capacity_persons | rooms | best_for | fit_wedding | fit_conference | fit_banquet | fit_spa | fit_party | common_areas | reachability_score | isolation_score | airport_km | nearest_airport | city_km | town_km | venues_5km | city | municipality | address | lat | lng | valid_until | stop_date | source | source_type | source_category | cert_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 783923 | 783923 | HRISTO SMIRNENSKI | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 24 | 45 | 0 | 0 | 0 | 0 | 70 | 0 | 11.0 | VAR | 15.0 | 0.0 | 23 | Belovo | Belovo | mestnost Kurtovo | 43.18717 | 27.70352 | 2030-08-04T21:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0775 | ||||
| 783925 | 783925 | NATSIONALEN PESHTEREN DOM PETAR TRANTEEV | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 25 | 45 | 0 | 0 | 0 | 0 | 55 | 40 | 48.3 | PDV | 14.4 | 12.6 | 8 | Karlukovo | Lukovit | mestnost Kaleto | 41.63333 | 24.86667 | 2030-08-04T21:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0771 | ||||
| 783951 | 783951 | NATSIONALEN UCHEBEN TSENTAR NA BCHK PO PLANINSKO SPASYAVANE - BOROVETS | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 12 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 73.3 | SOF | 12.0 | 0.0 | 391 | Borovets | Samokov | Rila planina, k.k. Borovets, kv. 19 | 42.10566 | 23.02003 | 2029-12-09T22:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0728 | ||||
| 783953 | 783953 | OBSHTINSKO PREDPRIYATIE MLADEZHKI TSENTAR PLOVDIV | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 17 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 12.7 | PDV | 0.0 | 0.0 | 1591 | Plovdiv | Plovdiv | ul. Yasna Polyana №18 | 42.15387 | 24.75001 | 2029-12-09T22:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0723 | ||||
| 784017 | 784017 | MAUNTIN SKAY VYU/ MOUNTAIN SKY VIEW | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 17 | 45 | 0 | 0 | 0 | 0 | 65 | 30 | 38.1 | GOZ | 8.5 | 8.5 | 11 | Mezhdeni | Gabrovo | 42.95 | 25.33333 | 2028-09-12T21:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0617 | |||||
| 784052 | 784052 | MOMINA KREPOST | BG | stay | other_stay | other_accommodation | normal | 3 | star | 3 | 75 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 10.4 | GOZ | 0.0 | 0.0 | 594 | Veliko Tarnovo | Veliko Tarnovo | m-t Ksilifor | 43.08124 | 25.62904 | 2026-11-23T22:00:00Z | BG-NTR | Touristic educational center | 3 | РК-22-0557 | ||||
| 786141 | 786141 | CASSA BLANKA | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 45 | 0 | 0 | 0 | 0 | 40 | 30 | 101.5 | SOF | 24.9 | 0.0 | 0 | Stara Kresna | Kresna | S.Oshtava, mestnos Banishteto | 41.8 | 23.18333 | 2030-03-18T10:00:00Z | BG-NTR | Rest homes | 3 | КЛ-ИИХ-А9Х-1К | |||||
| 786436 | 786436 | "DENITSA" | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 40 | 45 | 0 | 0 | 0 | 0 | 60 | 20 | 6.9 | Balchik Airfield | 36.5 | 6.2 | 133 | Topola | Kavarna | kk.Karvuna | 43.41984 | 28.26667 | 2026-09-09T09:00:00Z | BG-NTR | Rest homes | 3 | К1-ИКВ-17Н-1К | ||||
| 786784 | 786784 | KOMPLEX ASENEVTSI | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 22 | 45 | 0 | 0 | 0 | 0 | 55 | 20 | 32.3 | GOZ | 12.6 | 5.6 | 27 | Tsareva livada | Dryanovo | ul. Tsar Asen 4 | 42.93333 | 25.45 | 2028-06-30T09:00:00Z | BG-NTR | Rest homes | 3 | ДЖ-ИКБ-2ЗК-1К | ||||
| 787458 | 787458 | "ZDRAVETS" | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 52 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 7.0 | VAR | 0.0 | 0.0 | 1513 | Varna | Varna | k.k. "Chayka", pozemlen imot pl. № 3420 | 43.21912 | 27.91024 | 2028-07-28T09:00:00Z | BG-NTR | Rest homes | 3 | В1-ИМЩ-5НР-1К | ||||
| 787526 | 787526 | "ROYAL BIYCH" | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 35 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 7.0 | VAR | 0.0 | 0.0 | 1513 | Varna | Varna | k.k. "Chayka", UL. "BOYaN BAChVAROV" № 141 | 43.21912 | 27.91024 | 2027-06-02T09:00:00Z | BG-NTR | Rest homes | 3 | В1-Ж6Ц-9ЖС-1К | ||||
| 787531 | 787531 | „MEZHDUNARODEN DOM NA ZHURNALISTA“ | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 72 | 45 | 0 | 0 | 0 | 0 | 70 | 0 | 18.5 | VAR | 12.9 | 0.0 | 579 | Zlatni pyasatsi | Varna | k.k. Zlatni pyasatsi, PI № 3340, kv. 12, partsel XVI | 43.285 | 28.0418 | 2027-06-01T21:00:00Z | BG-NTR | Rest homes | 3 | В1-Ж12-9ЖС-1К | ||||
| 788601 | 788601 | SANYA | BG | stay | other_stay | rest_home | normal | 3 | star | 3 | 20 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 63.5 | Graf Ignatievo Air Base | 17.5 | 0.0 | 183 | Apriltsi | Apriltsi | kv. Ostrets, ul. "Otdih" №20 | 42.84142 | 24.91759 | 2030-08-21T09:00:00Z | BG-NTR | Rest homes | 3 | А7-ЗШ6-АЗЧ-1К |
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, "best_for" TEXT, "fit_wedding" INTEGER, "fit_conference" INTEGER, "fit_banquet" INTEGER, "fit_spa" INTEGER, "fit_party" INTEGER, "common_areas" TEXT, "reachability_score" INTEGER, "isolation_score" INTEGER, "airport_km" REAL, "nearest_airport" TEXT, "city_km" REAL, "town_km" REAL, "venues_5km" 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");
CREATE INDEX idx_best_for ON venues("best_for");
CREATE INDEX idx_common_areas ON venues("common_areas");