Export hotel & lodging data by city — without an API
Need a list of every hotel, hostel, guest house or motel in a city — with stars, room count, brand and contact details? This data comes straight from OpenStreetMap, so each row is the property's own published details rather than a listing scraped off an online travel agency. There are no prices, no reviews, and no OTA noise — just the facts about the property itself.
It's built for people assembling travel & tourism datasets, doing hospitality market and competitor mapping, running lead generation for hospitality suppliers, or building "hotels near X" features into an app or map.
What you get
Fields specific to lodging:
- name — the property name
- stars — star rating
- rooms — room count
- lodging_type — hotel, guest_house, hostel, motel, apartment or chalet
- brand and brand_wikidata — the chain, where applicable
- operator — who runs the property
- internet_access — Wi-Fi / internet availability
- phone — contact number
- website — the property's own site
Every row also includes full_address, map_url, state and branch, plus standard location fields (latitude, longitude, street, housenumber, city, postcode, country), source_url and all_tags. For chains you also get brand_wikidata and brand_logo. Fields are honest-null — if OpenStreetMap doesn't have a value, you get a null instead of a guess.
How to get it (no API key)
Run the dataquarry Hotels & Lodging Scraper on Apify. Give it an area (a city or region), a radius around a point, or a bounding box — optionally narrowed by name and by lodgingTypes. No API key, no quota.
{"area":"Edinburgh, UK","lodgingTypes":["hotel","hostel"]}
You'll get rows like this:
| name | lodging_type | stars | rooms | brand | city | full_address |
|---|---|---|---|---|---|---|
| Royal Mile Hotel | hotel | 4 | 120 | Premier Inn | Edinburgh | 1 High Street, Edinburgh, EH1 1AB, UK |
| Old Town Hostel | hostel | null | 48 | null | Edinburgh | 22 Grassmarket, Edinburgh, EH1 2HS, UK |
Run the Hotels & Lodging Scraper on Apify →
Why OpenStreetMap (and not a Booking/Expedia scraper)?
OpenStreetMap is open ODbL data — you can redistribute it with attribution, there's no API key to manage, and there are no anti-bot defenses or terms-of-service problems to work around. You get the property's own details rather than an OTA's listings, prices or reviews, and missing values stay honest-null instead of being filled with guesses. Pricing is pay-per-result: $3 per 1,000 rows, output as CSV, JSON or Excel.
Browse hotels by city
Ready-made hotel & lodging lists for major US metros: Houston · New York · San Antonio · Chicago · San Diego · Austin · San Francisco · Charlotte · Phoenix · Indianapolis · Portland · Nashville · Atlanta · Denver · Los Angeles · Dallas · Miami · Fort Worth · Columbus · Seattle · Boston · San Jose · Jacksonville · Philadelphia · Las Vegas
FAQ
Do I need an API key to get hotel data?
No. Give the tool a city (or a radius, or a name) and run it — no key and no quota.
Is this scraping Booking.com or Expedia?
No — it uses OpenStreetMap's open data, so you get each property's own details (stars, rooms, brand, contact, address) rather than OTA listings, prices or reviews. It's legal and needs no API key.
How much does it cost?
Pay-per-result: $3 per 1,000 rows — you only pay for the rows you actually get.