query-7446a921746ca29b0b468e2b9fbf22ae
Our question: Which universities of the country are recognised as higher education institutions (accredited, attested)? was not possible to create because there is not property in WIKIDATA for the accreditation of universities.The queries Which city offers a specific degree in a specific major in which city?does work even if there are some unclear things. . It seems to be the same but there are different results for each query. By playing around with the queries we noticed that very few universities have the property “grant”. For germany we get 658 universities but just less than ten have it. ( ?university wdt:P31 wd:Q3918 ) and if a “university is a university” ( ?university wdt:P31/wdt:P279* wd:Q38723 )We are not sure what the difference is between if a “university is an instance of a subclass of a higher education institution” Finally we decided to use the first version with higher education institution.
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?university ?universityLabel ?degreeLabel ?majorLabel ?cityLabel WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language
"[AUTO_LANGUAGE],en". }
?university wdt:P31/wdt:P279* wd:Q38723;
wdt:P17 wd:Q1027;# in country mauritius
wdt:P131 ?city;
p:P5460 ?statement .
?statement ps:P5460 ?degree .
?statement pq:P812 ?major .
FILTER(?degree = wd:Q1765120) #bachelor of arts degree
FILTER(?major = wd:Q16653334) #Law and management
FILTER(?city = wd:Q282908 ) #Moka
}
ORDER BY ?universityLabel ?degreeLabel ?majorLabel