Download
doalu-places.csv(2.6 MB)datapackage.json(2.2 KB)README.md(2.5 KB)SOURCES.md(0.9 KB)CITATION.cff(0.6 KB)CHANGELOG.md(0.1 KB)
The places covered by doalu.com, a where-to-stay guide organised by area: 16,668 rows (187 countries, 1,888 regions, 7,087 cities, 7,506 districts), each with its page on doalu.com and its identifiers in Wikidata and GeoNames. Use it as a crosswalk between Wikidata QIDs, GeoNames IDs and a city → district hierarchy, or to link travellers to the right area guide.
- File:
doalu-places.csv(UTF-8, comma-separated) withdatapackage.json(Frictionless). - Browse by country: countries/ lists every region, city and district with a link to its guide.
- Release: 121 (2026-10-23). Licence: CC BY 4.0. Sources: SOURCES.md.
Columns
| column | meaning |
|---|---|
doalu_id | doalu place id, kept across releases |
kind | country, region, city or district |
name, ascii_name | the place name, and an ASCII fold of it |
country_iso2 | ISO 3166-1 alpha-2 |
parent_doalu_id | the place it sits under on doalu.com (the site's hierarchy, not legal containment) |
url | its guide on doalu.com |
wikidata_qid, geonames_id | identifiers to join on |
population | the GeoNames figure for the row's own geonames_id, published only where it matches our record; otherwise blank |
timezone | the GeoNames time zone (only with a geonames_id) |
wikipedia_url | the English Wikipedia article |
Caveats
wikidata_qidis not unique: where Wikidata has one item for a city and its region or country (Berlin, Tokyo, Singapore, Oslo…), both rows carry it (104 items appear twice). Join ondoalu_idfor one row per place.- Population figures come from different years and definitions, so a child can exceed its parent (some districts exceed their city, some cities their region or country).
- No coordinates or geometry: join
wikidata_qid(Wikidata P625) orgeonames_idfor those, under their licences. - Some Romanian names use the cedilla letters ş/ţ instead of ș/ț, as in GeoNames.
Cite this
doalu places dataset (https://doalu.com), CC BY 4.0; contains modified GeoNames data (CC BY 4.0, https://www.geonames.org) and Wikidata identifiers (CC0)
Please keep the link to https://doalu.com when you reuse the data (CC BY 4.0 attribution). CITATION.cff has the details.
Corrections
Open an issue on GitHub, or write to [email protected].