11

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.

3
  • also take a look at utexas.edu/world/univ/alpha as a checklist to make sure Wikipedia didn't miss any US ones. Also see data.ny.gov/Education/…? which has information you are looking for but only for U.S. Institutions Commented Jul 26, 2014 at 0:32
  • ~15 years ago, I was working on a system for tracking of licensed engineers ... I used the ABET acredidation list. You might be able to use other acredidation lists, and then de-duplicate them. (some are by field, some are by geographical region, so many are acredited by more than one group)
    – Joe
    Commented Jul 27, 2014 at 1:07
  • opendata.stackexchange.com/a/4892/25665 Hi, also interested in this topic. Just a question, as a no coder, how could I use this query in Google Sheet ? Thanks in advance.
    – AyS 0908
    Commented Aug 25, 2020 at 20:04

2 Answers 2

10

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.

8

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.

3
  • This is a smart community. I can create a dataset from Wikipedia but it wont be easy even with kimonolabs.com. Thanks a bunch. Commented Jul 25, 2014 at 11:53
  • 1
    @user3237694 - correct that it's not easy but it seems like this will be your best bet. My suggestion is to collect a list of universities by traversing the Wikipedia index pages and then go about parsing all the Wikipedia entries. Some will have structured data in the right sidebar, some will not. For those without, there are probably a few patterns like "founded in XXXX" and "established in YYYY" to get some of the data out of the free-text. Commented Jul 26, 2014 at 0:22
  • @user3237694 : consider searching dbpedia for rdf:type <http://schema.org/CollegeOrUniversity>; see stackoverflow.com/q/17056476/143791
    – Joe
    Commented Jul 27, 2014 at 1:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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