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.
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!
You can follow @marxmatt.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled: