Read on Twitter
1/ A number of people have asked about location data in @MSFTAcademic. Last year it added longitude/latitude for a subset of affiliations, but many researchers want city/state/country. We've posted code for getting these from the Google & Bing Maps APIs: https://github.com/ksjiaxian/api-requester-locations
2/ We'd love to post the resulting data but don't think we can given the API terms of service. But you should be able to recreate the data using our code & instructions. You'll need to sign up for bing/gmaps API accounts, and of course there's a monthly usage limit.
3/ Another path is to use the lat/long from the Microsoft data and reverse-geocode to get city/state/country. My favorite tool for this is http://more.stevemorse.org/latlonbatch2.html?direction=reverse, which was developed by the inventor of the 8086 processor (!). You'll need a MapQuest key for that.
4/ This is what we've been able to figure out, but pls let me know if you hear of other avenues. Note that we don't currently redistribute the MS location data at http://relianceonscience.org ; you'll need to get that from them directly.
thanks @Watzinger for pointing out that the raw MAG data has a Grid ID for a subset of affiliations, which is a unique identifier for an institution with fields at https://www.grid.ac/ . Probably easier than reverse-geocoding!
