Skip to content

Guides

What the open data actually knows about working from cafés

We hold thousands of places to work across 58 cities and can confirm power outlets at barely a hundred of them. What that gap is made of, and why a "best cities for laptop work" ranking built on this data would rank mapping habits instead of cities.

· figures read live from the catalogue

A Berlin street corner café marked with map pins

We hold 25,767 cafés, libraries, hostels, coworking spaces, bookshops and study cafés across 100 cities, built from OpenStreetMap (6,970 places), Overture Maps (5,146) and Google Places (12,521). We can confirm Wi‑Fi at 5,152 of them, indoor seating at 2,913, and power outlets at 1178. That last number is not a typo. It is 4.6% of the catalogue, and it is the most useful single fact about the state of open data on working from cafés.

What is actually known about a café

Of the 25,767 places we list, here is how many carry each attribute a person with a laptop would want to know before walking there. None of this is guessed: every one is a stored fact with a source and a date attached.

AttributePlacesShare
Opening hours4,77619%
Wi‑Fi confirmed5,15220%
A working website8,56733%
Indoor seating confirmed2,91311%
Power outlets confirmed1,1784.6%

The shape of that table is the finding. Opening hours are recorded reasonably often because a shop's hours are on its door and somebody eventually types them in. Power outlets are recorded almost never, because nobody surveys a room for sockets, and a socket is the one thing that decides whether you can stay for three hours.

Why we are not publishing a "best cities for laptop work" ranking

The obvious piece to write from a catalogue like this is a league table: rank the cities by the share of their cafés with Wi‑Fi and outlets, publish it every year, watch it get cited. We built it, looked at it, and did not publish it, because the ranking it produces is not a ranking of cities.

Here is the same twenty cities grouped by country, with the three attributes that get filled in by whoever mapped the place. All of these cities were crawled the same way, to the same depth, in the same pass, so what varies is the mapping, not the looking.

CountryPlacesWi‑FiHoursWebsite
Hungary33634%59%59%
South Africa20233%28%47%
Georgia24732%53%39%
Indonesia39230%27%26%
Vietnam48027%20%17%
Argentina39527%31%37%
Portugal67524%39%46%
Colombia26822%24%25%
Thailand2,37816%9%12%
Mexico39915%17%28%
Czechia1,43113%17%20%
Germany2,28512%15%17%
Spain4,40411%12%19%
Taiwan2,29010%8%9%

The three columns move together, which is the tell. Taking them together, Hungary comes out best (34% Wi‑Fi, 59% hours, 59% website) and Taiwan worst (10%, 8%, 9%). Whether a café offers Wi‑Fi, what time it shuts, and whether its owner registered a domain are three unrelated facts about a business. They have no reason to rise and fall together from one country to the next, unless what they are all measuring is the same thing, which is whether somebody sat down and wrote the café into the map.

So a league table built on this data would rank the density and habits of local OpenStreetMap contributors, and it would do it while wearing the costume of a travel ranking. Plenty of sites publish exactly that. We would rather say what the data is.

A quarter of the websites are gone

We fetched every website the catalogue had a URL for, honouring robots.txt, to read hours and prices out of the pages. 6,550 sites were checked. 1543 of them did not serve a page at all (the host did not resolve, or answered 404), and a further 138 refused us with a 403, which usually means a site that works perfectly well for a person and blocks robots.

What happenedSites
host did not answer, twice1143
HTTP 404, twice327
HTTP 403, twice126
host did not answer41
The operation was aborted due to timeout, twice21
HTTP 406, twice21
fetch failed, twice19
HTTP 40312
HTTP 500, twice10
HTTP 409, twice8
HTTP 4047
HTTP 503, twice6
HTTP 410, twice4
HTTP 405, twice4
fetch failed3
HTTP 400, twice2
HTTP 401, twice1
HTTP 418, twice1
not html, twice1

24% of the small hospitality businesses that had a website in the public record have one that no longer answers. Most are cafés that closed, or that let a domain lapse and moved to Instagram. We take the link down after it fails twice a week apart, and keep a note of what it used to be.

Method

  • Every figure on this page is read from the database when the page is requested. Nothing is transcribed, so nothing can quietly go stale.
  • Places are counted live and visible only: removed and triaged-out listings are excluded throughout.
  • An attribute counts as confirmed only where a source asserted it: an OpenStreetMap tag, a machine-readable fact on the venue's own site, a Google Places field, or a rating from somebody signed in here. An unknown is stored as unknown and never as a no.
  • The country table covers the twenty core cities only, which were crawled identically. The catalogue-wide figures cover all 100 cities, where crawl depth does vary.
  • Website checks honour robots.txt, and a site has to fail twice at least a week apart before we treat it as gone.

If you want to check any of it, the pages are all public: every city we hold lists what is in it, and every listing shows the source and the date behind each fact.