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& #39;ve posted code for getting these from the Google & Bing Maps APIs: https://github.com/ksjiaxian/api-requester-locations">https://github.com/ksjiaxian...
2/ We& #39;d love to post the resulting data but don& #39;t think we can given the API terms of service. But you should be able to recreate the data using our code & instructions. You& #39;ll need to sign up for bing/gmaps API accounts, and of course there& #39;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,">https://more.stevemorse.org/latlonbat... which was developed by the inventor of the 8086 processor (!). You& #39;ll need a MapQuest key for that.
4/ This is what we& #39;ve been able to figure out, but pls let me know if you hear of other avenues. Note that we don& #39;t currently redistribute the MS location data at http://relianceonscience.org"> http://relianceonscience.org ; you& #39;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/ .">https://www.grid.ac/">... Probably easier than reverse-geocoding!