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
128 rows where country = "ES", family = "guesthouses" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: rating_label, source, source_type, source_category
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216243 | 216243 | Finca Susanna | ES | stay | guesthouses | guesthouse | normal | 3 | star | Tres Estrellas | 7 | 3 | El Rosario | Tenerife | C/ Elías Bacallado Hernandez , 57 | 28.447459 | -16.375745 | ES-CAN | Pension | Tres Estrellas | |||
| 509256 | 509256 | ASTORIA II | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CRA de San Jerónimo 32, 28014 | ES-MAD | HOSTAL | 3-HOSTAL | HM-142 | |||||||
| 509257 | 509257 | ALHAMBRA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Espoz y Mina 6, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-143 | |||||||
| 509268 | 509268 | RINCON DE GRAN VIA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE Gran Vía 67, 28013 | ES-MAD | PENSION | 3-PENSION | HM-199 | |||||||
| 509278 | 509278 | LISBOA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Ventura de la Vega 17, 28014 | ES-MAD | HOSTAL | 3-HOSTAL | HM-230 | |||||||
| 509302 | 509302 | GALICIA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Valverde 1, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-41 | |||||||
| 509308 | 509308 | PEREDA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Valverde 1, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-56 | |||||||
| 509319 | 509319 | THE WALT MADRID | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Barco 3, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-92 | |||||||
| 509361 | 509361 | ALHAMBRA SUITES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Espoz y Mina 8, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-1217 | |||||||
| 509367 | 509367 | SAN LORENZO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de las Infantas 26, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-1310 | |||||||
| 509373 | 509373 | SANTO DOMINGO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Luna 6, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-1369 | |||||||
| 509377 | 509377 | GRAN VIA 63 ROOMS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 63, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-254 | |||||||
| 509382 | 509382 | MADRID | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Esparteros 6, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-270 | |||||||
| 509385 | 509385 | JOSEFINA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 44, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-299 | |||||||
| 509386 | 509386 | GALIANO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Alcalá Galiano 6, 28010 | ES-MAD | HOSTAL | 3-HOSTAL | HM-301 | |||||||
| 509391 | 509391 | TRIANA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Salud 13, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-318 | |||||||
| 509503 | 509503 | HISPANO ARGENTINO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 15, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-2373 | |||||||
| 509538 | 509538 | LAS MURALLAS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Fuencarral 23, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-1733 | |||||||
| 509570 | 509570 | JC ROOM SANTA ANA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Cruz 8, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3255 | |||||||
| 509589 | 509589 | ALHAMBRA DE LUXE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Espoz y Mina 8, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3365 | |||||||
| 509618 | 509618 | MIRAVALLE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Guadarrama | AVIA A-6 44, 28440 | ES-MAD | HOSTAL | 3-HOSTAL | HM-2668 | |||||||
| 509662 | 509662 | VELAZQUEZ 45 BY PILLOW | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Velázquez 45, 28001 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3035 | |||||||
| 509677 | 509677 | AVENIDA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Leganés | CALLE el Charco 4-6, 28911 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3446 | |||||||
| 509780 | 509780 | EL CHISCON | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Colmenar Viejo | CALLE de los Frailes 91, 28770 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4145 | |||||||
| 509787 | 509787 | CARLOS III | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Getafe | CALLE Velasco 7, 28901 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4155 | |||||||
| 509790 | 509790 | 4C CUATRO CAMINOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de los Artistas 7, 28020 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4159 | |||||||
| 509792 | 509792 | SALA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Guadarrama | CTRA Carretera de Los Molinos 1, 28440 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4162 | |||||||
| 509798 | 509798 | ORIENTE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Arenal 23, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4171 | |||||||
| 509808 | 509808 | ALCALA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | San Agustín del Guadalix | CALLE de las Cambroneras 4, 28750 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4186 | |||||||
| 509815 | 509815 | LA POSADA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Miraflores de la Sierra | PASEO de los Álamos 6, 28792 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4197 | |||||||
| 509827 | 509827 | ACAPULCO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Salud 13, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4219 | |||||||
| 509839 | 509839 | MADRID CHIPEN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Torrejón de Ardoz | CALLE Primavera 37, 28850 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4239 | |||||||
| 509845 | 509845 | COLORINES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Canencia | CALLE Real 110, 28743 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3985 | |||||||
| 509861 | 509861 | TRES CANTOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Tres Cantos | AVDA de Viñuelas 39, 28760 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4019 | |||||||
| 509868 | 509868 | SANTA BARBARA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Collado Villalba | CALLE Goya 1, 28400 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4035 | |||||||
| 509870 | 509870 | LOS ANGELES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Alcobendas | CALLE del Manzanares 4, 28100 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4042 | |||||||
| 509891 | 509891 | AZUL | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Molar, El | AVDA de España 57, 28710 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4076 | |||||||
| 509927 | 509927 | EL ROCIO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Paracuellos de Jarama | CALLE del Mesón 20, 28860 | ES-MAD | PENSION | 3-PENSION | HM-4137 | |||||||
| 509930 | 509930 | EL CENADOR DE SALVADOR | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Moralzarzal | CALLE de España 30, 28411 | ES-MAD | PENSION | 3-PENSION | HM-4240 | |||||||
| 509940 | 509940 | EL REY DE OROS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Cobeña | CTRA M-114 7, 28863 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4255 | |||||||
| 509957 | 509957 | ARTICO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Donoso Cortés 69, 28015 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4364 | |||||||
| 509962 | 509962 | MIAU | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Príncipe 26, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4369 | |||||||
| 509965 | 509965 | REAL SITIO DE ARANJUEZ | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Aranjuez | CALLE de las Infantas 15, 28300 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4372 | |||||||
| 509979 | 509979 | JULIAN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Brunete | PASEO de Ronda 2, 28690 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4394 | |||||||
| 509992 | 509992 | MARIA RONDA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Batalla de Torrijos 26, 28025 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4415 | |||||||
| 509999 | 509999 | TOLEDANO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Pinto | CALLE de Alvar Fáñez 8, 28320 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4427 | |||||||
| 510008 | 510008 | DON ANGEL II | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Villanueva de la Cañada | CALLE Benjamín Palencia 8, 28691 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4277 | |||||||
| 510021 | 510021 | LOS 5 PINOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Fuentelahiguera 4, 28022 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4299 | |||||||
| 510023 | 510023 | MORALEJA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Moraleja de Enmedio | AVDA de Arroyomolinos 1, 28950 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4303 | |||||||
| 510027 | 510027 | LA PARADA DEL REY | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Miraflores de la Sierra | AVDA de Madrid 16, 28792 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4311 | |||||||
| 510034 | 510034 | SAN LORENZO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Clavel 8, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4322 | |||||||
| 510042 | 510042 | EL VAL | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Alcalá de Henares | CALLE Zaragoza 2, 28804 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4332 | |||||||
| 510070 | 510070 | VILLA DE AJALVIR | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Ajalvir | CALLE Paloma 33, 28864 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4577 | |||||||
| 510073 | 510073 | VILLA PARACUELLOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Paracuellos de Jarama | CALLE Real 17, 28860 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4581 | |||||||
| 510082 | 510082 | EL PASAJE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Pozo 4, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4590 | |||||||
| 510087 | 510087 | SAN MARCOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | San Martín de la Vega | CALLE de José Azorín 1, 28330 | ES-MAD | HOSTAL | 3-HOSTAL | HM-5101 | |||||||
| 510097 | 510097 | ADRIA SANTA ANA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE de Núñez de Arce 15, 28012 | ES-MAD | PENSION | 3-PENSION | HM-4607 | |||||||
| 510098 | 510098 | LOS CORONALES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Briones 38, 28042 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4608 | |||||||
| 510104 | 510104 | AVENIDAS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | San Martín de la Vega | CALLE Alcalde Enrique Gálvez 10, 28330 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4614 | |||||||
| 510106 | 510106 | IPANEMA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Collado Villalba | AVDA Juan Carlos I 17, 28400 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4618 | |||||||
| 510110 | 510110 | TERMINAL 4 | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Paracuellos de Jarama | CALLE de las Escombreras 2, 28860 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4622 | |||||||
| 510114 | 510114 | LA CASONA DE MORATA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Morata de Tajuña | CTRA M-313 Arganda del Rey 10, 28530 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4627 | |||||||
| 510117 | 510117 | CAMPO REAL | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Campo Real | CALLE Flor 4-5, 28510 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4631 | |||||||
| 510120 | 510120 | SOTOHOSTEL ALGETE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Algete | CALLE del Nogal 2, 28119 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4636 | |||||||
| 510176 | 510176 | MIRALRIO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Fuentidueña de Tajo | CTRA de Madrid-Valencia 62,500, 28597 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4511 | |||||||
| 510189 | 510189 | EL CAÑO DE ALPEDRETE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Alpedrete | CALLE del Caño 29, 28430 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4529 | |||||||
| 510202 | 510202 | FAR HOME | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE de la Chinchilla 1, 28013 | ES-MAD | PENSION | 3-PENSION | HM-4550 | |||||||
| 510211 | 510211 | SAN MARTIN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | San Martín de la Vega | CALLE de Antonio Machado 14, 28330 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4562 | |||||||
| 510230 | 510230 | MADRISOL | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Núñez de Arce 1, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4668 | |||||||
| 510232 | 510232 | JC ROOMS SANTO DOMINGO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CUSTA de Santo Domingo 16, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4766 | |||||||
| 510233 | 510233 | VITIUM URBAM SUITES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 61, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4768 | |||||||
| 510234 | 510234 | ALESIS MADRID | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Príncipe 18, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4772 | |||||||
| 510241 | 510241 | MEDITERRANEA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | AVIA M-50 64, 28051 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4780 | |||||||
| 510242 | 510242 | NEO MAGNA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Don Ramón de la Cruz 94, 28006 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4781 | |||||||
| 510248 | 510248 | ATELIER | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Príncipe 18, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4788 | |||||||
| 510262 | 510262 | LANDHAUS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Molar, El | AVDA de Madrid 68, 28710 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4804 | |||||||
| 510274 | 510274 | CC MALASAÑA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE del Espíritu Santo 18, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4824 | |||||||
| 510295 | 510295 | ABADIA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Luis Vélez de Guevara 2, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4687 | |||||||
| 510298 | 510298 | LA PARADA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Getafe | CALLE Eratóstenes 15, 28906 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4692 | |||||||
| 510315 | 510315 | ARAVACA GARDEN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Burgohondo 8, 28023 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4715 | |||||||
| 510319 | 510319 | EL RINCON DE GRAN VIA II | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE Gran Vía 67, 28013 | ES-MAD | PENSION | 3-PENSION | HM-4720 | |||||||
| 510324 | 510324 | VERTICE ROOM SPACE MADRID | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de la Laguna Dalga 4, 28021 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4728 | |||||||
| 510333 | 510333 | RINCON DE GRAN VIA III | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 67, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4743 | |||||||
| 510419 | 510419 | ROISA HOSTAL BOUTIQUE | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Serrano 236, 28016 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4849 | |||||||
| 510421 | 510421 | JC ROOMS CHUECA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de las Infantas 5, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4854 | |||||||
| 510428 | 510428 | RINCÓN DE GRAN VÍA IV | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE Gran Vía 67, 28013 | ES-MAD | PENSION | 3-PENSION | HM-4866 | |||||||
| 510440 | 510440 | GOLDEN ALCALA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Alcalá 288, 28027 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4882 | |||||||
| 510443 | 510443 | JC JARDINES | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de los Jardines 3, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4885 | |||||||
| 510453 | 510453 | RINCON DE GRAN VIA V | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE Gran Vía 67, 28013 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4902 | |||||||
| 510458 | 510458 | MI CASA INN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Blasco de Garay 61, 28015 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4908 | |||||||
| 514821 | 514821 | CASA DU SOLEIL | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de San Pedro Mártir 9, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4952 | |||||||
| 514826 | 514826 | PLAZA MAYOR | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Torrejón de Ardoz | CALLE Cristo 21-23, 28850 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4951 | |||||||
| 514860 | 514860 | AVENIDA RCA Y JMC | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | AVDA Logroño 333, 28042 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4681 | |||||||
| 514875 | 514875 | HOSTAL GRAN VIA PINTO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Pinto | CALLE EGIDO DE LA FUENTE 22, 28320 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4721 | |||||||
| 514927 | 514927 | PRADO 46 | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | PASEO del Prado 46, 28014 | ES-MAD | PENSION | 3-PENSION | HM-4941 | |||||||
| 515205 | 515205 | SAN MARCOS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | San Martín de la Vega | CALLE de José Azorín 1, 28330 | ES-MAD | HOSTAL | 3-HOSTAL | HM-4597 | |||||||
| 515626 | 515626 | HOSTAL ANTON MARTIN | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE MAGDALENA 29, 28012 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3636 | |||||||
| 515743 | 515743 | PALACIO DE LUNA | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE Luna 6, 28004 | ES-MAD | PENSION | 3-PENSION | HM-1904 | |||||||
| 515874 | 515874 | GALLARDO | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-HOSTAL | Madrid | CALLE de Fuencarral 95, 28004 | ES-MAD | HOSTAL | 3-HOSTAL | HM-3788 | |||||||
| 515903 | 515903 | OPERA ROOMS | ES | stay | guesthouses | guesthouse | normal | 3 | star | 3-PENSION | Madrid | CALLE de la Flora 4, 28013 | ES-MAD | PENSION | 3-PENSION | HM-4981 |
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");