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 rating_value = 2 and venue_type = "catering"

This data as json, CSV (advanced)

Suggested facets: name, capacity_persons, city, municipality, valid_until, valid_until (date)

venue_type 1

  • catering · 10 ✖

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
14267 14267 TRIGRADSKI SKALI BG eat_drink fastfood_catering catering normal 2 star 2 50   Trigrad Devin obshtina Devin, Rodopi, turisticheska hizha Trigradski skali     2030-08-04T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0787
14291 14291   BG eat_drink fastfood_catering catering normal 2 star 2 20   Dobrostan Asenovgrad hizha Martsiganitsa     2029-12-09T22:00:00Z   BG-NTR Touristic buffet 2 РК-22-0731
14297 14297 BALCHIK-SHUMEN BG eat_drink fastfood_catering catering normal 2 star 2 50   Balchik Balchik ul. Albenski pat № 23, turisticheski ucheben tsentar Balchik-Shumen     2029-09-18T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0720
14299 14299 OBZOR-VELIKO TARNOVO BG eat_drink fastfood_catering catering normal 2 star 2 50   Obzor Nesebar mestnost Efrem cheshma, turisticheski ucheben tsentar Obzor-Veliko Tarnovo     2029-09-18T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0716
14303 14303 SVETA GORA BG eat_drink fastfood_catering catering normal 2 star 2 50   Veliko Tarnovo Veliko Tarnovo Park Sveta gora, turisticheski ucheben tsentar Sveta gora     2029-09-18T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0706
14304 14304 SV. SV. KONSTANTIN I ELENA BG eat_drink fastfood_catering catering normal 2 star 2 50   Varna Varna k.k. Konstantin i Elena, Turisticheski ucheben tsentar Sv. Sv. Konstantin i Elena-Razgrad     2029-09-18T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0704
14342 14342 NEVEN BG eat_drink fastfood_catering catering normal 2 star 2 20   Kranevo Balchik Turisticheski ucheben tsentar Neven     2028-08-06T21:00:00Z   BG-NTR Touristic buffet 2 РК-22-0600
14357 14357   BG eat_drink fastfood_catering catering normal 2 star 2 25   Pamporovo Smolyan turisticheska hizha Studenets     2027-12-04T22:00:00Z   BG-NTR Touristic buffet 2 РК-22-0568
14362 14362 MOMINA KREPOST BG eat_drink fastfood_catering catering normal 2 star 2 110   Veliko Tarnovo Veliko Tarnovo m-t Ksilifor, turisticheski ucheben tsentar Momina krepost     2026-11-23T22:00:00Z   BG-NTR Touristic buffet 2 РК-22-0558
14367 14367 RILSKI EZERA BG eat_drink fastfood_catering catering normal 2 star 2 40   Panichishte Sapareva banya turisticheska hizha Rilski ezera     2026-11-23T22:00:00Z   BG-NTR Touristic buffet 2 РК-22-0548

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