List of all universities by country

Question

Is there a list of all universities by country including their websites, location, latitude and longitude, facebook, twitter, youtube, founding year etc. I can't believe such a data set is not publicly available.

Answer 1

Wikipedia's sister project Wikidata provides data about more than 18,000 universities with a varying amount of detail.

You can use the Wikidata Query Builder to generate the following SPARQL query:

SELECT DISTINCT ?item ?itemLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P31 ?statement0.
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q3918.
    }
  }
}

This returns a list of all instances (P31) of university (Q3918) and any of its subclasses (P279) (such as institute of technology or law school).

By slightly tweaking the above query, you can even generate an interactive tree view of all countries and universities backed by live data from Wikidata.

Answer 2

You can use Wikipedia to create your own dataset. It will not be hard. Here are a few details:

List of all universities by country

Divided by continent and country, you have a list of all the universities

Then in every wikipedia page of a university, you can find as many details you want:

For example, in Aristotle University of Thessaloniki you can find coordinates, founding year, website etc.