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 family = "unclassified" and group = "other"
This data as json, CSV (advanced)
Suggested facets: rating_scheme, rating_label, capacity_persons, rooms, reachability_score, isolation_score, nearest_airport, city_km, town_km, venues_5km, municipality, source, source_type, source_category, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11138 | 11138 | Scotts Holiday Homes | IE | other | unclassified | unknown | normal | none | 8 | 0 | 0 | 0 | 0 | 0 | 45 | 40 | 39.5 | ENK | 41.5 | 7.1 | 1 | Ballintra | Donegal | Murvagh | 54.59594 | -8.15861 | IE-Failte | SCS08530 | |||||||||
| 461115 | 461115 | San Diego | ES | other | unclassified | unknown | normal | 2 | star | Dos Estrellas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Cristobal De La Laguna | Tenerife | Avda. San Diego, 40 | ES-CAN | _U | Dos Estrellas | ||||||||||||||
| 461116 | 461116 | Sin Denominación | ES | other | unclassified | unknown | normal | none | Categoria Unica | 0 | 0 | 0 | 0 | 0 | 0 | 0 | La Orotava | Tenerife | Calle Carrera Escultor Estévez | ES-CAN | _U | Categoria Unica | |||||||||||||||
| 788807 | 788807 | "ZHULI" | BG | other | unclassified | unknown | normal | 1 | star | 1 | 8 | 0 | 0 | 0 | 0 | 0 | 60 | 0 | 12.8 | Balchik Airfield | 42.3 | 0.0 | 207 | Kavarna | Kavarna | ul."Dobrotitsa"4A | 43.43601 | 28.33953 | 2021-02-15T10:00:00Z | BG-NTR | 1 | 964 | |||||
| 792053 | 792053 | BG | other | unclassified | unknown | normal | 3 | star | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 70 | 0 | 9.4 | BOJ | 14.6 | 0.0 | 379 | Pomorie | Pomorie | GR.AHELOY UL. ELHOVO №1 | 42.56326 | 27.62986 | 2021-09-13T09:00:00Z | BG-NTR | 3 | 204-С | ||||||
| 795657 | 795657 | ZEBRA | BG | other | unclassified | unknown | normal | 2 | star | 2 | 8 | 0 | 0 | 0 | 0 | 0 | 70 | 30 | 29.0 | VAR | 29.2 | 0.0 | 0 | Valchi dol | Valchi dol | ul. "Brigadirska"17 | 43.4 | 27.55 | 2029-04-29T09:00:00Z | BG-NTR | 0 | 2 | 00087 | ||||
| 795971 | 795971 | STAI ZA GOSTI | BG | other | unclassified | unknown | normal | 1 | star | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 55 | 40 | 41.3 | SOF | 18.0 | 5.9 | 1 | Chernyovo | Ihtiman | selo Chernyovo | 42.41667 | 23.75 | 2028-08-22T21:00:00Z | BG-NTR | 0 | 1 | 00016 | ||||
| 801706 | 801706 | MEHANA "IZBATA" | BG | other | unclassified | unknown | normal | 1 | star | 1 | 0 | 0 | 0 | 0 | 0 | 65 | 0 | 70.5 | GOZ | 0.0 | 0.0 | 105 | Targovishte | Targovishte | mestnost Borovo oko | 43.2512 | 26.57215 | 2028-06-19T09:00:00Z | BG-NTR | 0 | 1 | 850 | |||||
| 802332 | 802332 | THE LIFE | BG | other | unclassified | unknown | normal | 1 | star | 1 | 40 | 0 | 0 | 0 | 0 | 0 | 65 | 0 | 53.9 | SOF | 0.0 | 0.0 | 130 | Dupnitsa | Dupnitsa | ul. Ivan Vazov № 26 | 42.26478 | 23.11723 | 2029-09-15T09:00:00Z | BG-NTR | 0 | 1 | 687 | ||||
| 804450 | 804450 | ZAKUSVALNYA "DREAM FOOD" | BG | other | unclassified | unknown | normal | 1 | star | 1 | 48 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 55.4 | SOF | 14.3 | 0.0 | 43 | Mezdra | Mezdra | ul. "Sv. sv. Kiril i Metodiy" №52V | 43.1448 | 23.71415 | 2029-11-21T10:00:00Z | BG-NTR | 0 | 1 | 413 | ||||
| 810063 | 810063 | KAFE APERITIV | BG | other | unclassified | unknown | normal | 1 | star | 1 | 40 | 0 | 0 | 0 | 0 | 0 | 55 | 30 | 65.6 | GOZ | 12.8 | 2.9 | 1 | Tulovo | Maglizh | s.Tulovo ul."Bozhur" № 1 | 42.574 | 25.545 | 2027-09-07T09:00:00Z | BG-NTR | 0 | 1 | 180 | ||||
| 814374 | 814374 | CHARODEYKA | BG | other | unclassified | unknown | normal | 1 | star | 1 | 12 | 0 | 0 | 0 | 0 | 0 | Ruse | Zh.K.ChARODEYKA, DO PAZARA | BG-NTR | 1 | 1165 | ||||||||||||||||
| 820426 | 820426 | SPA TSENTAR MARINA GRAND BIYCH | BG | other | unclassified | unknown | normal | none | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 7.0 | VAR | 0.0 | 0.0 | 1513 | Varna | Добрич | Hotel MARINA GRAND BIYCh, oblast Varna, obshtina Varna, grad Varna, Rayon Primorski, k.k. Zlatni pyasatsi | 43.21912 | 27.91024 | 2022-08-01T21:00:00Z | BG-NTR | РС-20-45 |
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");