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

10 rows where country = "BG" and family = "unclassified"

This data as json, CSV (advanced)

Suggested facets: rating_scheme, rating_label, capacity_persons, rooms, source_type, source_category, valid_until (date)

rating_value 3

venue_type 1

group 1

family 1

  • unclassified · 10 ✖

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
6933 6933 "ZHULI" BG other unclassified unknown normal 1 star 1   8 Kavarna Kavarna ul."Dobrotitsa"4A     2021-02-15T10:00:00Z   BG-NTR 1 964
10179 10179   BG other unclassified unknown normal 3 star 3   2 Pomorie Pomorie GR.AHELOY UL. ELHOVO №1     2021-09-13T09:00:00Z   BG-NTR 3 204-С
13783 13783 ZEBRA BG other unclassified unknown normal 2 star 2   8 Valchi dol Valchi dol ul. "Brigadirska"17     2029-04-29T09:00:00Z   BG-NTR 0 2 00087
14097 14097 STAI ZA GOSTI BG other unclassified unknown normal 1 star 1   4 Chernyovo Ihtiman selo Chernyovo     2028-08-22T21:00:00Z   BG-NTR 0 1 00016
19832 19832 MEHANA "IZBATA" BG other unclassified unknown normal 1 star 1     Targovishte Targovishte mestnost Borovo oko     2028-06-19T09:00:00Z   BG-NTR 0 1 850
20458 20458 THE LIFE BG other unclassified unknown normal 1 star 1 40   Dupnitsa Dupnitsa ul. Ivan Vazov № 26     2029-09-15T09:00:00Z   BG-NTR 0 1 687
22576 22576 ZAKUSVALNYA "DREAM FOOD" BG other unclassified unknown normal 1 star 1 48   Mezdra Mezdra ul. "Sv. sv. Kiril i Metodiy" №52V     2029-11-21T10:00:00Z   BG-NTR 0 1 413
28189 28189 KAFE APERITIV BG other unclassified unknown normal 1 star 1 40   Tulovo Maglizh s.Tulovo ul."Bozhur" № 1     2027-09-07T09:00:00Z   BG-NTR 0 1 180
32500 32500 CHARODEYKA BG other unclassified unknown normal 1 star 1 12   Ruse Zh.K.ChARODEYKA, DO PAZARA         BG-NTR 1 1165
38552 38552 SPA TSENTAR MARINA GRAND BIYCH BG other unclassified unknown normal   none       Varna Добрич Hotel MARINA GRAND BIYCh, oblast Varna, obshtina Varna, grad Varna, Rayon Primorski, k.k. Zlatni pyasatsi     2022-08-01T21:00:00Z   BG-NTR     РС-20-45

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