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

15 rows where rating_value = 1 and venue_type = "canteen"

This data as json, CSV (advanced)

Suggested facets: rating_label, city, municipality, source_category

venue_type 1

  • canteen · 15 ✖

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
69210 69210 GIONNELI, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
70727 70727 CERES, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Com. Merei, Sat Sărata-Monteoru BUZĂU   45.1495402 26.6328717     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
71310 71310 CHIC, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Cluj-Napoca CLUJ   46.7834039 23.5413486     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
71432 71432 ILINCA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Cluj-Napoca CLUJ   46.7774613 23.5611541     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
71759 71759 10 STEAGURI, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Com. Costineşti CONSTANŢA   43.9482023 28.6372543     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
71834 71834 VICTORIA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Com. Costineşti CONSTANŢA   43.9473528 28.6336244     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
72382 72382 LIVAMAR, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2585817 28.6196999     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
72468 72468 POFTĂ SAU FOAME, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 STEA 160   Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2591124 28.6189467     RO-SITUR RESTAURANT-AUTOSERVIRE 1 STEA  
72580 72580 AYLIN, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Mangalia CONSTANŢA   43.843482 28.5953404     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
72632 72632 LA CANAPELE ROCK, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Mangalia CONSTANŢA   43.8111457 28.5806726     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
72836 72836 MAGNIFICUL, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8643964 28.5971859     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
72954 72954 LA MOSU, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Mangalia, Loc. Saturn CONSTANŢA   43.8152436 28.5741496     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
73185 73185 ONIX, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0719243 28.6378695     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
73646 73646 2 BRAZI, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Târgovişte DÂMBOVIŢA   44.9317356 25.4533205     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  
76317 76317 DOMINO, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 - STELE     Mun. Zalău SĂLAJ   47.1908871 23.0617536     RO-SITUR RESTAURANT-AUTOSERVIRE 1 - STELE  

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