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
13 rows where country = "ES", family = "self_catering_villas" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: name, capacity_persons, city, municipality, address
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107767 | 107767 | Sagrada Família | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Barcelona | Barcelonès | Carrer Rosselló 502-504 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-002091 | ||||||
| 124783 | 124783 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Hospitalet de Llobregat, l' | Barcelonès | Carrer Progrés 78 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-056355 | ||||||
| 124784 | 124784 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Hospitalet de Llobregat, l' | Barcelonès | Carrer Progrés 78 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-056356 | ||||||
| 124785 | 124785 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Hospitalet de Llobregat, l' | Barcelonès | Carrer Progrés 78 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-056357 | ||||||
| 124786 | 124786 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Hospitalet de Llobregat, l' | Barcelonès | Carrer Progrés 78 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-056358 | ||||||
| 124787 | 124787 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Hospitalet de Llobregat, l' | Barcelonès | Carrer Progrés 78 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTB-056359 | ||||||
| 139692 | 139692 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Palafrugell | Baix Empordà | Carrer Brisa 9 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTG-010747 | ||||||
| 146004 | 146004 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Calonge i Sant Antoni | Baix Empordà | Disseminat Gil s/n | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTG-018105 | ||||||
| 167323 | 167323 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Torroella de Montgrí | Baix Empordà | Carrer Terme 3 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTG-057763 | ||||||
| 171947 | 171947 | Apartamento 602 | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | 4 | Blanes | Selva | Carrer d' Enric Morera 2 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTG-068340 | |||||
| 177299 | 177299 | Cal Claramunt | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | Torrefarrera | Segrià | Urbanització Salats 5 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTL-050623 | ||||||
| 207972 | 207972 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | 3 | Amposta | Montsià | Carrer de Voramar 41 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTTE-060055 | |||||
| 207992 | 207992 | Sense especificar | ES | stay | self_catering_villas | self_catering | normal | 3 | key | 3 claus | 4 | Amposta | Montsià | Carrer de l Eucaliptus 13 | ES-CAT | Habitatges d'ús turístic | 3 claus | HUTTE-060429 |
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, "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");