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
1,883 rows where country = "PT" and venue_type = "hotel"
This data as json, CSV (advanced)
Suggested facets: source_type, valid_until (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 503206 | 503206 | OPORTO FLY HOTEL | PT | stay | hotels | hotel | normal | none | 158 | Maia | 2026-06-17 | PT-RNT-RNET | Hotel | 13445 | |||||||||
| 503210 | 503210 | VILLA BRANDA - TAVIRA NATURE HOTEL | PT | stay | hotels | hotel | normal | none | 51 | Tavira | 2026-06-09 | PT-RNT-RNET | Hotel | 13435 | |||||||||
| 503222 | 503222 | HOTEL 77 LISBON | PT | stay | hotels | hotel | normal | none | 30 | Lisboa | 2026-05-21 | PT-RNT-RNET | Hotel | 13398 | |||||||||
| 503227 | 503227 | 705 O’PORTO HOTEL | PT | stay | hotels | hotel | normal | none | 154 | Porto | 2026-05-18 | PT-RNT-RNET | Hotel | 13387 | |||||||||
| 503231 | 503231 | TOREL PRIVATE COLLECTION | PT | stay | hotels | hotel | normal | none | 32 | Porto | 2026-05-15 | PT-RNT-RNET | Hotel | 13376 | |||||||||
| 503234 | 503234 | JUPITER PORTO HOTEL | PT | stay | hotels | hotel | normal | none | 262 | Porto | 2026-05-08 | PT-RNT-RNET | Hotel | 13367 | |||||||||
| 503239 | 503239 | MOINHO DO CANTO RESIDENCE HOTEL | PT | stay | hotels | hotel | normal | none | 27 | Rio Maior | 2026-05-04 | PT-RNT-RNET | Hotel | 13354 | |||||||||
| 503240 | 503240 | THE CLOUD ONE LISBON | PT | stay | hotels | hotel | normal | none | 168 | Lisboa | 2026-05-04 | PT-RNT-RNET | Hotel | 13352 | |||||||||
| 503242 | 503242 | PORTO RIVER SOUL HOTEL | PT | stay | hotels | hotel | normal | none | 120 | Vila Nova de Gaia | 2026-04-29 | PT-RNT-RNET | Hotel | 13347 | |||||||||
| 503244 | 503244 | CASA FALCÃO BY ASPASIOS | PT | stay | hotels | hotel | normal | none | 68 | Porto | 2026-04-23 | PT-RNT-RNET | Hotel | 13334 | |||||||||
| 503251 | 503251 | QUINTA DO ÉDEN | PT | stay | hotels | hotel | normal | none | 70 | Vagos | 2026-04-15 | PT-RNT-RNET | Hotel | 13318 | |||||||||
| 503254 | 503254 | MYSTAY PORTO RIBEIRA | PT | stay | hotels | hotel | normal | none | 28 | Porto | 2026-04-09 | PT-RNT-RNET | Hotel | 13308 | |||||||||
| 503256 | 503256 | SUBLIME LISBOA | PT | stay | hotels | hotel | normal | none | 25 | Lisboa | 2026-04-07 | PT-RNT-RNET | Hotel | 13299 | |||||||||
| 503271 | 503271 | THE MILA PORTO | PT | stay | hotels | hotel | normal | none | 52 | Porto | 2026-03-18 | PT-RNT-RNET | Hotel | 13251 | |||||||||
| 503276 | 503276 | MARVÃO HOTEL MUSEU**** | PT | stay | hotels | hotel | normal | none | 16 | Marvão | 2026-03-10 | PT-RNT-RNET | Hotel | 13233 | |||||||||
| 503280 | 503280 | OCA GRANDE HOTEL DO PEZO | PT | stay | hotels | hotel | normal | none | 88 | Melgaço | 2026-03-03 | PT-RNT-RNET | Hotel | 13217 | |||||||||
| 503282 | 503282 | OLIVIA LISBOA HOTEL | PT | stay | hotels | hotel | normal | none | 286 | Lisboa | 2026-02-25 | PT-RNT-RNET | Hotel | 13208 | |||||||||
| 503284 | 503284 | UNIQUE PRIVATE SUITES | PT | stay | hotels | hotel | normal | none | 72 | Matosinhos | 2026-02-23 | PT-RNT-RNET | Hotel | 13206 | |||||||||
| 503285 | 503285 | ALMALUSA BAIXA/CHIADO | PT | stay | hotels | hotel | normal | none | 64 | Lisboa | 2026-02-23 | PT-RNT-RNET | Hotel | 13205 | |||||||||
| 503286 | 503286 | HOTEL FLOR DO MINHO | PT | stay | hotels | hotel | normal | none | 45 | Valença | 2026-02-23 | PT-RNT-RNET | Hotel | 13201 | |||||||||
| 503316 | 503316 | CASTELO SUITES HOTEL | PT | stay | hotels | hotel | normal | none | 162 | Albufeira | 2026-01-12 | PT-RNT-RNET | Hotel | 13108 | |||||||||
| 503319 | 503319 | CASA D´ALMEIDA BY PORTO STORIES | PT | stay | hotels | hotel | normal | none | 21 | Porto | 2026-01-05 | PT-RNT-RNET | Hotel | 13100 | |||||||||
| 503327 | 503327 | 1904 BENFICA HOTEL - FLH HOTELS | PT | stay | hotels | hotel | normal | none | 103 | Lisboa | 2025-12-22 | PT-RNT-RNET | Hotel | 13089 | |||||||||
| 503350 | 503350 | ANDAZ LISBON | PT | stay | hotels | hotel | normal | none | 340 | Lisboa | 2025-11-13 | PT-RNT-RNET | Hotel | 13025 | |||||||||
| 503352 | 503352 | LOVELY CITYSCAPE | PT | stay | hotels | hotel | normal | none | 26 | Lagos | 2025-11-11 | PT-RNT-RNET | Hotel | 13017 | |||||||||
| 503360 | 503360 | CORREIO VELHO HOTEL | PT | stay | hotels | hotel | normal | none | 26 | Lisboa | 2025-10-28 | PT-RNT-RNET | Hotel | 12990 | |||||||||
| 503361 | 503361 | GLÓRIA SUITES HOTEL | PT | stay | hotels | hotel | normal | none | 46 | Lisboa | 2025-10-28 | PT-RNT-RNET | Hotel | 12989 | |||||||||
| 503366 | 503366 | SENHORA DA ROSA, TRADITION & NATURE HOTEL | PT | stay | hotels | hotel | normal | none | 68 | Ponta Delgada | 2025-10-22 | PT-RNT-RNET | Hotel | 12977 | |||||||||
| 503370 | 503370 | HOTEL BAINHARIA | PT | stay | hotels | hotel | normal | none | 26 | Porto | 2025-10-17 | PT-RNT-RNET | Hotel | 12965 | |||||||||
| 503371 | 503371 | ABC HOTEL PORTO - CAMPANHÃ | PT | stay | hotels | hotel | normal | none | 96 | Porto | 2025-10-16 | PT-RNT-RNET | Hotel | 12964 | |||||||||
| 503383 | 503383 | MERCURE PONTA DELGADA AZORES | PT | stay | hotels | hotel | normal | none | 150 | Ponta Delgada | 2025-09-19 | PT-RNT-RNET | Hotel | 12909 | |||||||||
| 503386 | 503386 | MOXY ALFRAGIDE LISBOA | PT | stay | hotels | hotel | normal | none | 436 | Amadora | 2025-09-12 | PT-RNT-RNET | Hotel | 12897 | |||||||||
| 503388 | 503388 | JARDIM DA BATALHA | PT | stay | hotels | hotel | normal | none | 40 | Porto | 2025-09-10 | PT-RNT-RNET | Hotel | 12891 | |||||||||
| 503391 | 503391 | HOTEL KODAWARI RESIDENCES FLORES | PT | stay | hotels | hotel | normal | none | 33 | Porto | 2025-09-06 | PT-RNT-RNET | Hotel | 12886 | |||||||||
| 503401 | 503401 | PALÁCIO DE TAVIRA | PT | stay | hotels | hotel | normal | none | 68 | Tavira | 2025-08-20 | PT-RNT-RNET | Hotel | 12857 | |||||||||
| 503406 | 503406 | B&B HOTEL SETÚBAL BONFIM | PT | stay | hotels | hotel | normal | none | 251 | Setúbal | 2025-08-13 | PT-RNT-RNET | Hotel | 12849 | |||||||||
| 503407 | 503407 | ORIGINE PORTO GAIA, A TRIBUTE PORTFOLIO HOTEL | PT | stay | hotels | hotel | normal | none | 123 | Vila Nova de Gaia | 2025-08-08 | PT-RNT-RNET | Hotel | 12836 | |||||||||
| 503409 | 503409 | MELIÁ SÃO JOÃO DA MADEIRA | PT | stay | hotels | hotel | normal | none | 186 | São João da Madeira | 2025-08-07 | PT-RNT-RNET | Hotel | 12834 | |||||||||
| 503413 | 503413 | HOTEL DALMA BAIXA | PT | stay | hotels | hotel | normal | none | 28 | Lisboa | 2025-08-05 | PT-RNT-RNET | Hotel | 12827 | |||||||||
| 503414 | 503414 | HOTEL VERDE MAR & SPA | PT | stay | hotels | hotel | normal | none | 328 | Ribeira Grande | 2025-08-04 | PT-RNT-RNET | Hotel | 12826 | |||||||||
| 503425 | 503425 | AÇORES AUTÊNTICO BOUTIQUE HOTEL | PT | stay | hotels | hotel | normal | none | 29 | Angra do Heroísmo | 2025-07-24 | PT-RNT-RNET | Hotel | 12802 | |||||||||
| 503427 | 503427 | VILA GALÉ CASAS D'ELVAS – HISTORIC HOTEL | PT | stay | hotels | hotel | normal | none | 88 | Elvas | 2025-07-21 | PT-RNT-RNET | Hotel | 12795 | |||||||||
| 503428 | 503428 | JARDIM DA LAPA | PT | stay | hotels | hotel | normal | none | 52 | Lisboa | 2025-07-21 | PT-RNT-RNET | Hotel | 12794 | |||||||||
| 503444 | 503444 | HOTEL DO ALBOI | PT | stay | hotels | hotel | normal | none | 31 | Aveiro | 2025-07-04 | PT-RNT-RNET | Hotel | 12753 | |||||||||
| 503447 | 503447 | ALIADOS PLAZA HOTEL | PT | stay | hotels | hotel | normal | none | 183 | Porto | 2025-07-01 | PT-RNT-RNET | Hotel | 12743 | |||||||||
| 503451 | 503451 | AMARELLO HOTEL PRAIA SANTO ANDRE, TAPESTRY COLLECTION BY HILTON | PT | stay | hotels | hotel | normal | none | 88 | Santiago do Cacém | 2025-06-27 | PT-RNT-RNET | Hotel | 12737 | |||||||||
| 503452 | 503452 | ARTCORE HOTEL | PT | stay | hotels | hotel | normal | none | 114 | Porto | 2025-06-26 | PT-RNT-RNET | Hotel | 12730 | |||||||||
| 503466 | 503466 | B&B HOTEL PORTO CENTRO MASSARELOS | PT | stay | hotels | hotel | normal | none | 352 | Porto | 2025-06-06 | PT-RNT-RNET | Hotel | 12690 | |||||||||
| 503467 | 503467 | MOAGEM INDUSTRIAL LODGE | PT | stay | hotels | hotel | normal | none | 34 | Viana do Alentejo | 2025-06-05 | PT-RNT-RNET | Hotel | 12688 | |||||||||
| 503470 | 503470 | ME LISBON | PT | stay | hotels | hotel | normal | none | 456 | Lisboa | 2025-06-04 | PT-RNT-RNET | Hotel | 12682 | |||||||||
| 503489 | 503489 | PENSÃO AMOR - MADAMS LODGE | PT | stay | hotels | hotel | normal | none | 44 | Lisboa | 2025-05-15 | PT-RNT-RNET | Hotel | 12632 | |||||||||
| 503492 | 503492 | HOTEL AKEAH PORTO CENTRO | PT | stay | hotels | hotel | normal | none | 76 | Porto | 2025-05-14 | PT-RNT-RNET | Hotel | 12628 | |||||||||
| 503493 | 503493 | LENSCAPE COTERIE | PT | stay | hotels | hotel | normal | none | 73 | Porto | 2025-05-14 | PT-RNT-RNET | Hotel | 12627 | |||||||||
| 503494 | 503494 | QUINTA DA MAQUIA HOTEL | PT | stay | hotels | hotel | normal | none | 90 | Sintra | 2025-05-13 | PT-RNT-RNET | Hotel | 12617 | |||||||||
| 503499 | 503499 | THE EDITORY BY THE SEA LAGOS | PT | stay | hotels | hotel | normal | none | 412 | Lagos | 2025-05-08 | PT-RNT-RNET | Hotel | 12609 | |||||||||
| 503500 | 503500 | PICO VINEYARDS HOTEL | PT | stay | hotels | hotel | normal | none | 30 | Madalena | 2025-05-07 | PT-RNT-RNET | Hotel | 12607 | |||||||||
| 503501 | 503501 | THE MN56 HOTEL | PT | stay | hotels | hotel | normal | none | 42 | Lagos | 2025-05-06 | PT-RNT-RNET | Hotel | 12604 | |||||||||
| 503502 | 503502 | CASA ZOGBI HOTEL | PT | stay | hotels | hotel | normal | none | 32 | Porto | 2025-05-06 | PT-RNT-RNET | Hotel | 12602 | |||||||||
| 503507 | 503507 | MACAM HOTEL | PT | stay | hotels | hotel | normal | none | 128 | Lisboa | 2025-04-17 | PT-RNT-RNET | Hotel | 12582 | |||||||||
| 503509 | 503509 | ÁGUA HOTELS TERRA FRIA | PT | stay | hotels | hotel | normal | none | 180 | Bragança | 2025-04-14 | PT-RNT-RNET | Hotel | 12579 | |||||||||
| 503510 | 503510 | ALBUFEIRA LOUNGE HOTEL | PT | stay | hotels | hotel | normal | none | 78 | Albufeira | 2025-04-11 | PT-RNT-RNET | Hotel | 12574 | |||||||||
| 503512 | 503512 | HOTEL FLORESCENTE | PT | stay | hotels | hotel | normal | none | 114 | Lisboa | 2025-04-10 | PT-RNT-RNET | Hotel | 12567 | |||||||||
| 503516 | 503516 | MS COLLECTION AROUCA | PT | stay | hotels | hotel | normal | none | 108 | Arouca | 2025-04-07 | PT-RNT-RNET | Hotel | 12561 | |||||||||
| 503517 | 503517 | CAIS URBAN LODGE | PT | stay | hotels | hotel | normal | none | 50 | Lisboa | 2025-04-04 | PT-RNT-RNET | Hotel | 12556 | |||||||||
| 503527 | 503527 | HOTEL M | PT | stay | hotels | hotel | normal | none | 86 | Espinho | 2025-03-28 | PT-RNT-RNET | Hotel | 12537 | |||||||||
| 503529 | 503529 | ÁGUA HOTELS LAGOS BAY | PT | stay | hotels | hotel | normal | none | 35 | Lagos | 2025-03-26 | PT-RNT-RNET | Hotel | 12532 | |||||||||
| 503536 | 503536 | LIBERATOR ROSSIO | PT | stay | hotels | hotel | normal | none | 46 | Lisboa | 2025-03-20 | PT-RNT-RNET | Hotel | 12517 | |||||||||
| 503556 | 503556 | HOTEL NELAS PARQ | PT | stay | hotels | hotel | normal | none | 147 | Nelas | 2025-02-24 | PT-RNT-RNET | Hotel | 12455 | |||||||||
| 503565 | 503565 | HAVEN NATURE HOTEL & VILLAS | PT | stay | hotels | hotel | normal | none | 62 | Batalha | 2025-02-19 | PT-RNT-RNET | Hotel | 12439 | |||||||||
| 503566 | 503566 | THE VINEA COLLECTION HOTEL | PT | stay | hotels | hotel | normal | none | 134 | Monção | 2025-02-19 | PT-RNT-RNET | Hotel | 12438 | |||||||||
| 503574 | 503574 | THE LOG PORTO HOTEL | PT | stay | hotels | hotel | normal | none | 324 | Porto | 2025-02-06 | PT-RNT-RNET | Hotel | 12411 | |||||||||
| 503584 | 503584 | TIVOLI KOPKE PORTO GAIA | PT | stay | hotels | hotel | normal | none | 300 | Vila Nova de Gaia | 2025-01-29 | PT-RNT-RNET | Hotel | 12392 | |||||||||
| 503585 | 503585 | LEIRIARTEM HOTEL | PT | stay | hotels | hotel | normal | none | 54 | Leiria | 2025-01-28 | PT-RNT-RNET | Hotel | 12389 | |||||||||
| 503586 | 503586 | JP VILLAGE | PT | stay | hotels | hotel | normal | none | 36 | Nelas | 2025-01-27 | PT-RNT-RNET | Hotel | 12385 | |||||||||
| 503591 | 503591 | LISBON CHIADO HOTEL & SPA | PT | stay | hotels | hotel | normal | none | 80 | Lisboa | 2025-01-14 | PT-RNT-RNET | Hotel | 12365 | |||||||||
| 503597 | 503597 | THE TWENTIES | PT | stay | hotels | hotel | normal | none | 42 | Lisboa | 2025-01-07 | PT-RNT-RNET | Hotel | 12357 | |||||||||
| 503603 | 503603 | HOTEL SÃO MIGUEL | PT | stay | hotels | hotel | normal | none | 34 | Ponta Delgada | 2024-12-18 | PT-RNT-RNET | Hotel | 12325 | |||||||||
| 503604 | 503604 | THE SOCIAL HUB | PT | stay | hotels | hotel | normal | none | 542 | Porto | 2024-12-18 | PT-RNT-RNET | Hotel | 12322 | |||||||||
| 503605 | 503605 | BACALHOEIROS 125 HOTEL | PT | stay | hotels | hotel | normal | none | 50 | Lisboa | 2024-12-17 | PT-RNT-RNET | Hotel | 12320 | |||||||||
| 503618 | 503618 | HOTEL AREOSA | PT | stay | hotels | hotel | normal | none | 24 | Maia | 2024-11-27 | PT-RNT-RNET | Hotel | 12285 | |||||||||
| 503620 | 503620 | TURIM SANTA MARIA HOTEL | PT | stay | hotels | hotel | normal | none | 165 | Funchal | 2024-11-20 | PT-RNT-RNET | Hotel | 12277 | |||||||||
| 503625 | 503625 | IBIS STYLES LISBOA AEROPORTO | PT | stay | hotels | hotel | normal | none | 159 | Loures | 2024-11-11 | PT-RNT-RNET | Hotel | 12258 | |||||||||
| 503626 | 503626 | NICOLA ROSSIO HOTEL | PT | stay | hotels | hotel | normal | none | 46 | Lisboa | 2024-11-11 | PT-RNT-RNET | Hotel | 12257 | |||||||||
| 503627 | 503627 | REDNYX HOTEL | PT | stay | hotels | hotel | normal | none | 19 | Ovar | 2024-11-11 | PT-RNT-RNET | Hotel | 12256 | |||||||||
| 503644 | 503644 | INSPIRA SANTOS BOUTIQUE HOTEL | PT | stay | hotels | hotel | normal | none | 129 | Lisboa | 2024-10-18 | PT-RNT-RNET | Hotel | 12209 | |||||||||
| 503649 | 503649 | BOUTIQUE HOTEL TEATRO | PT | stay | hotels | hotel | normal | none | 35 | Angra do Heroísmo | 2024-10-08 | PT-RNT-RNET | Hotel | 12184 | |||||||||
| 503652 | 503652 | SIENNA HOTEL | PT | stay | hotels | hotel | normal | none | 35 | Rio Maior | 2024-10-02 | PT-RNT-RNET | Hotel | 12174 | |||||||||
| 503655 | 503655 | VILA VICÊNCIA | PT | stay | hotels | hotel | normal | none | 59 | Funchal | 2024-09-30 | PT-RNT-RNET | Hotel | 12166 | |||||||||
| 503657 | 503657 | DARE RIVER HOTEL | PT | stay | hotels | hotel | normal | none | 40 | Lisboa | 2024-09-25 | PT-RNT-RNET | Hotel | 12160 | |||||||||
| 503660 | 503660 | HOLIDAY INN EXPRESS EVORA | PT | stay | hotels | hotel | normal | none | 152 | Évora | 2024-09-23 | PT-RNT-RNET | Hotel | 12154 | |||||||||
| 503661 | 503661 | FLAG LISBOA SINTRA | PT | stay | hotels | hotel | normal | none | 57 | Sintra | 2024-09-23 | PT-RNT-RNET | Hotel | 12153 | |||||||||
| 503662 | 503662 | ROSSIO PLAZA HOTEL | PT | stay | hotels | hotel | normal | none | 47 | Lisboa | 2024-09-23 | PT-RNT-RNET | Hotel | 12152 | |||||||||
| 503669 | 503669 | HOLIDAY INN EXPRESS PORTO-BOAVISTA | PT | stay | hotels | hotel | normal | none | 182 | Porto | 2024-09-16 | PT-RNT-RNET | Hotel | 12140 | |||||||||
| 503680 | 503680 | AZORES BOOK HOTEL | PT | stay | hotels | hotel | normal | none | 40 | Angra do Heroísmo | 2024-08-22 | PT-RNT-RNET | Hotel | 12106 | |||||||||
| 503681 | 503681 | HOLIDAY INN BRAGA | PT | stay | hotels | hotel | normal | none | 222 | Braga | 2024-08-21 | PT-RNT-RNET | Hotel | 12105 | |||||||||
| 503682 | 503682 | HOTEL TROIA | PT | stay | hotels | hotel | normal | none | 55 | Amares | 2024-08-21 | PT-RNT-RNET | Hotel | 12104 | |||||||||
| 503686 | 503686 | PESTANA RUA AUGUSTA LISBOA | PT | stay | hotels | hotel | normal | none | 171 | Lisboa | 2024-08-13 | PT-RNT-RNET | Hotel | 12082 | |||||||||
| 503687 | 503687 | TOREL QUINTA DA VACARIA DOURO VALLEY | PT | stay | hotels | hotel | normal | none | 66 | Peso da Régua | 2024-08-12 | PT-RNT-RNET | Hotel | 12081 | |||||||||
| 503694 | 503694 | ALIANÇA OPERÁRIA / LABOR ALLIANCE | PT | stay | hotels | hotel | normal | none | 32 | Lisboa | 2024-07-30 | PT-RNT-RNET | Hotel | 12066 | |||||||||
| 503696 | 503696 | B&B HOTEL VIANA DO CASTELO | PT | stay | hotels | hotel | normal | none | 241 | Viana do Castelo | 2024-07-26 | PT-RNT-RNET | Hotel | 12061 |
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");