I am looking for any open data set that maintains restaurants (or places in general) with their address. If a place closes I am hoping this database will reflect that quickly.

  • Are you only interested in restaurants or in places in general? If it's the latter, you might want to change the title of your question accordingly. Also, are you only interested in places in the US or elsewhere too? May 31, 2013 at 7:26
  • 3
    I think your best bet would be to connect to the restaurant/pub elements in OpenStreetMap data - and possibly report back mistakes and changes to OSM.
    – relet
    May 31, 2013 at 7:58
  • Point of Interest data from OSM is certainly one of your best starting points. But it's created by volunteers - don't expect to have all POI updated constantly or just after a restaurant closed. If you want to be up-to-date immediately you will most likely need to create yourself an app that derives information on change from various source like business registers, restaurant recommendations (e.g. when a new restaurant is at an existing address), local news, social networks etc - depending for which country / region / city you want to track that there might be specific sources
    – fpp
    May 31, 2013 at 12:26
  • 2
    What's your geography? Restaurant inspection data can do this, but you there's not single national source?
    – fgregg
    May 31, 2013 at 16:31
  • As close to national as possible, global would be best but take what I can get. Jun 4, 2013 at 7:12

6 Answers 6


OpenStreetMap has quite an easily accessible database of restaurants (and other places), which you can easily query using their Overpass API. An example query for Overpass's Query Form which gets all restaurants in greater London:

<query type="node">
  <has-kv k="amenity" v="restaurant"/>
  <bbox-query s="51.28" n="51.686" w="-0.489" e="0.236"/>

An easier way of creating a query is to use Overpass Turbo, which allows you to navigate a map to reflect your area of interest, again an example of all restaurants in greater London (click on Run and move to the Data tab on the upper right to see the 'raw' data).

Another source is OpenCorporates, which often holds official registrations of companies and whether they are active or not. Many restaurant registrations don't have their address listed, but you might want to use their data to find out whether restaurants are still active or not (see their video on how to use Google/OpenRefine to reconcile names from a certain dataset (in this case OpenStreetMaps) with the OpenCorporates dataset).

  • Wah! Just what I need (-ish). Do you know how to query that with Leaflet? Or even just plain JS (that looks like HTML, but it doesn't, if you know what I mean, so I imagine you are using a framework, but don't know which one) Nov 29, 2019 at 7:23

The SimpleGeo point of interest dump of 21m places is the best open data set I know of, though it's getting pretty long in the tooth these days and so won't have the up-to-date-ness you're looking for:



Wikivoyage has open data about restaurants and bars, worldwide, pretty up-to-date.

The data is licensed under Creative Commons Attribution/Share-Alike.

The format is like this:

| name=Atelier de Joel Robuchon | url=http://www.robuchon.jp/latelier | email=
| address=Roppongi Hills Hillside 2F, 6-10-1 Roppongi
| lat=35.660197 | long=139.728804 | directions=
| phone=+81 3 5772-7500 | tollfree= | fax=
| hours=11:00–22:00 daily | price=
| content=The first overseas venture of the eponymous [[Paris]]-based Michelin-starred chef.  Each dish is a work of art almost as breathtaking as the price tag, as courses cost ¥2900–¥12,800 &mdash; still a steal by Tokyo gourmet standards.  No reservations are accepted, so prepare to queue.

You are probably interested in the name and address field. Concatenate the the name of the article (country and city) to the address, and tha makes the full address.


  • It does not contain ALL restaurants, but rather a selection of about 10 restaurants for each small city (or each part of a big city).
  • As far as I know, DBpedia does not parse Wikivoyage yet. This means you will have to download the XML dump (enwikivoyage-xxx-pages-articles.xml.bz2) and write a small script to extract the name-address couples.
  • I like it because I think it has a lot of future potential, but how do you access the data? Any API or dump? Jun 5, 2013 at 5:19
  • 1
    @djc391: Thanks for the feedback! I added the information about how to access the data.
    – Nicolas Raoul
    Jun 5, 2013 at 5:26

Local health departments are often the agencies that keep license and inspection information. Yelp and a few cities have been working to develop a national standard for inspection data (LIVES), but not too many places have adopted this yet.


open tables sounds like the ticket:

edit: although i just clicked through state and onto a city...doesn't look like a straightforward list. @ least not offhand.


Yelp has a search and business API and you can find more details on their developers page.

  • 2
    Thanks for your answer! However, since this is the Open Data SE, we are looking for open datasets. The data from Yelp is copyrighted, so it's not really helpful here. May 31, 2013 at 7:25
  • That's very helpful. Is it ok to delete a bad answer?
    – LAB
    May 31, 2013 at 21:08
  • 1
    If you think you can improve your answer, you can edit it. Of course it's also fine to delete your answer. These tips on how to answer might also be helpful :) Jun 1, 2013 at 0:17
  • Yelp is not open data. Yelp is owned by google and can't be used but thank you. Jun 1, 2013 at 8:52
  • 1
    On some other stack exchange sites, I've edited the answer to strike it out -- to mark that my answer was flawed, if there was a good chance that someone else might give the same response.
    – Joe
    Jun 1, 2013 at 11:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.