I am an editor at Wikivoyage (world travel guide), and for each city we list all embassies and consulates available in that city. Our problem is that this information quickly becomes out-of-date.

Where to find up-to-date information about embassies and consulates of all countries, in all cities?

For each item, we would need (in order of importance):

  • Country that runs the embassy/consulate
  • Address in which the embassy/consulate is (at least city/country)
  • Name (for instance "Consulate General of Germany" or "Taipei Economic and Cultural Office"). Bonus if the name is available in various languages (local language, country's language, others)
  • Website
  • Latitude/longitude
  • Phone
  • Office hours

Data must be reusable under the Creative Commons Attribution-ShareAlike License.

  • As @ user2361174 said in a comment, most of the data is broken regarding the target country and the addresses. Is there a way to get the nearest address based on the polygon coordinates? – trexgris Oct 8 at 14:04
  • Please give me 5 examples which have broken target country, because I believe all the data is correct regarding target country. Thanks! – Nicolas Raoul Oct 9 at 6:41
  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review – Jan Doggen Oct 9 at 8:16
  • @NicolasRaoul I was refering to OpenMaps and the overpass API, not your database (Not sure if you meant that?). Anyway, if you check this request overpass-turbo.eu/s/CEZ You will see that some embassies' data dont have the same format as the one mentioned in @philshem♦ post. – trexgris Oct 10 at 17:30

For a wider listing of diplomatic entities, consider using Open Street Maps.

For example, you can use the Tag: amenity=embassy. This data source includes the following dimensions:

 "lat"
 "lon"
  "tags": {
    "addr:city"
    "addr:country"
    "addr:housenumber"
    "addr:postcode"
    "addr:street"
    "amenity"
    "contact:email"
    "contact:fax"
    "contact:phone"
    "country"
    "name"
    "name:de"
    "name:en"
    "name:fr"
    "opening_hours"
    "website"}

With 5,600 objects including consulates, missions, embassies (as of Dec 2014).

enter image description here

To test it out, you can use the overpass-turbo API.

enter image description here

And the corresponding JSON data:

enter image description here

  • Wonderful! So, if I understand correctly, the Argentinian embassy in Switzerland is the consulate-tagged item that has country=AR and addr:country=CH. Unfortunately consulates don't seem to enjoy the same success, with only 57 occurrences: taginfo.openstreetmap.org/tags/amenity=consulate#overview – Nicolas Raoul Dec 8 '14 at 11:34
  • 1
    Yes, that's the Argentinian Embassy in Bern, Switzerland. I think many consulates are tagged with amenity=embassy (i.e. openstreetmap.org/way/24525106 ). Data quality can only improve for this type of project! – philshem Dec 8 '14 at 12:12
  • I've tried to used OSM, but it appears that a lot of the data is broken. Out of those 5,600 objects, only ~1,100 appear to have a country and target to them. Also TagInfo doesn't actually have any data for the tags that Embassies use... – user2361174 Feb 8 '17 at 5:02

Official lists maintained by government bodies:

United States

The dc.gov (Washington, DC) has a dataset for all embassies in Washington, DC:
http://data.octo.dc.gov/metadata.aspx?id=77

This data.gov dataset lists all US embassies/consulates in the World:
https://catalog.data.gov/dataset/country-specific-information

Canada

This open.canada dataset lists all Canadian embassies/consulates in the world:
http://open.canada.ca/data/en/dataset?keywords=Embassies

This dataset gives details on Canada embassies/consulates in the US:
http://can-am.gc.ca/offices-bureaux/index.aspx?lang=eng

You can get a quarterly publication from the Canadian government on all embassies/consular in Canada via email by subscribing here:
http://w03.international.gc.ca/Protocol-Protocole/archives.aspx?lang=eng

Australia

This data.gov.au dataset lists all Embassies/Consulars in Australia:
https://data.gov.au/dataset/national-consular-missions-database

This government site lists the location of all Australian embassies/consulates in the world:
http://www.dfat.gov.au/missions/

United Kingdom

This data.gov.uk dataset lists all the locations of UK Embassies/Consulates in the World:
http://data.gov.uk/dataset/uk-foreign-post-locations

China

Chinese Embassies:
http://www.fmprc.gov.cn/mfa_eng/wjb_663304/zwjg_665342/2490_665344/

Chinese Consulates General:
http://www.fmprc.gov.cn/mfa_eng/wjb_663304/zwjg_665342/2498_665360/

United Nations?

My opinion, if the UN does not provide/maintain such a dataset (I have not seen one), then you will be dependent on getting up-to-date information on a per country basis.

Wikidata has a lot of data about embassies and consulates.

To download the data:

  • Go to https://github.com/nicolas-raoul/database-of-embassies
  • Press the link called "Click here to see the data or download it" (the SPARQL request is so big I can not paste it here).
  • Scroll down.
  • Press the "Play" button at the left.
  • Waiting for about a minute until the data shows up.
  • Press the "Download" dropdown at the right (between the query and the resulting data).
  • Select JSON, TSV, CSV or HTML.

Data sample:

country: Austria
city: Vienna
address: Ölzeltgasse 3, Vienna
coordinates: Point(16.378275 48.198)
operator: Serbia
type: embassy
phone: +43-1-7132595
website: <http://www.vienna.mfa.gov.rs/>
image: commons:Oelzeltgasse3.JPG
wikidata: wd:Q5369858

The GitHub page also lists things that you can easily do to help improve the data.

License: Public domain

  • 1
    awesome dude good job! – ziggy Sep 13 '16 at 1:45
  • I've tried to run your query but I get this error: Query is malformed: Encountered " <INTEGER> "5960338859003578441 "" at line 1, column 1. – user2361174 Feb 8 '17 at 4:57
  • 1
    @user2361174: It is fixed now. – Nicolas Raoul Jun 27 at 2:56

Just to detail my findings about Andrew's first link (embassies in Washington, DC):

The data file can be found at http://geospatial.dcgis.dc.gov/dc_kmz/Culture_and_Society/DCG9_Miscellaneous_EmbassyPt/DCG9_Miscellaneous_EmbassyPt/DCG9_Miscellaneous_EmbassyPt.kmz

Once unzipped, open the doc.kml file, it contains such an item for each embassy:

<Placemark id="497" >
 <description>
  <![CDATA[
   <style type="text/css">HTML{font-family: Arial;font-size: 14px;}.popupBackground{width: Auto;height: Auto;margin: 10px 10px 10px;background-repeat: no-repeat;}.TOCName{text-align: center;font-weight: bold;margin-bottom: 10px;}.contentDiv{height: Auto;width:350px;}.leftSpan{width: 200px;float:left;}.rightSpan{}.dataGrid{border-collapse: collapse;padding: 1px;margin-bottom: 8px;}.dataGrid, .dataGrid th, .dataGrid td{border: solid 1px #bfbfbf;padding: 1px 1px 1px 1px;}.dataGridLeftTD{width: 150px;}.dataGridRightTD{}.bottomLinks{color: #365f91;text-decoration: underline;cursor: pointer;white-space:nowrap;}.ProvidedBy{white-space:nowrap;}</style>
   <div class="popupBackground"><div class="contentDiv"><div class="TOCName">Embassies </div><div><span class="leftSpan">Feature Class Name:</span> <span class="rightSpan">EmbassyPt </span></div><div style="margin-bottom: 8px;"><span class="leftSpan">Last Data Update:</span> <span class="rightSpan">20130704</span></div>
   <table class="dataGrid" width="100%">
   <tr><td class="dataGridLeftTD">COUNTRY</td><td class="dataGridRightTD">Yemen</td></tr>
   <tr><td class="dataGridLeftTD">ADDRESS</td><td class="dataGridRightTD">2319 WYOMING AVENUE NW</td></tr>
   <tr><td class="dataGridLeftTD">CITY</td><td class="dataGridRightTD">Washington</td></tr>
   <tr><td class="dataGridLeftTD">STATE</td><td class="dataGridRightTD">DC</td></tr>
   <tr><td class="dataGridLeftTD">TELEPHONE</td><td class="dataGridRightTD">(202) 965-4760</td></tr>
   <tr><td class="dataGridLeftTD">EMBASSY TITLE</td><td class="dataGridRightTD">Embassy of the Republic of Yemen</td></tr>
   </table>
   <table border="0" width="100%">
   <tr><td><img src="http://geospatial.dcgis.dc.gov/DC_KMZ/dclogo.gif"  alt="DCGIS" border="none" /></td><td class="ProvidedBy" style="text-align: right">Provided By:</td><td class="bottomLinks"><a href='http://dcgis.dc.gov' target='_blank' >DC GIS</a></td><td class="bottomLinks"><a href="#497;flyto">Fly To Me</a></td></tr>
   </table></div>
  ]]>
 </description>
 <Snippet maxLines="0"></Snippet>
 <styleUrl>#Style_0</styleUrl>
 <Point  id="g177">
  <altitudeMode>clampToGround</altitudeMode>
  <coordinates>-77.0513058292769,38.9172415955323,0</coordinates>
 </Point>
</Placemark>

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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