University dataset

Description:

This dataset includes the scorecard information of most universities in United States of America, and the location information of most famous building and places around the world. The scorecards are represented as a relational table, which is fetched from U.S. Government's open data. The locations are represented as RDF triples, which is extracted from DBpedia 2014, containing their latitude and longitude. The universities in two data source are redirected to a unified name using the search API of DBpedia.

Complete Data Statistics:

Relational Table
  university
Rows 7,803
Attributes 1729
RDF graph
  university
Source Nodes 526,256
Labeled edges 2
Target nodes 1,052,512
Triples 1,052,512

Sample Data:

university_scorecard.table

"UNITID","OPEID","opeid6","INSTNM","CITY","STABBR","ZIP","AccredAgency", ...

100654,00100200,001002,Alabama A&M University,Normal,AL,35762,Southern Association of Colleges and Schools Commission on Colleges, ...

100663,00105200,001052,University of Alabama at Birmingham,Birmingham,AL,35294-0110,Southern Association of Colleges and Schools Commission on Colleges, ...

where

  • "UNITID" is "Unit ID for institution"
  • "OPEID" is "8-digit OPE ID for institution"
  • "opeid6" is "6-digit OPE ID for institution"
  • "INSTNM" is "Institution name"
  • "CITY" is ""City
  • "STABBR" is "State postcode"
  • "ZIP" is "ZIP code"
  • "AccredAgency" is "Accreditor for institution"

location.graph

New_York latitude "43.0"^^<http://www.w3.org/2001/XMLSchema#float>

New_York longitude "-75.0"^^<http://www.w3.org/2001/XMLSchema#float>

Los_Angeles latitude "34.05"^^<http://www.w3.org/2001/XMLSchema#float>

Los_Angeles longitude "-118.25"^^<http://www.w3.org/2001/XMLSchema#float>

Example Queries:

Query Description
q1 Find top-k nearest universities with New York.
q2 Find top-k nearest universities in California with Los Angeles, which can provide Bachelor's degree.
q3 Find top-k nearest universities with New York, whose percentage of degrees awarded in architecture is at least 0.1.
q4 Find all universities within the range between New York and Washington, which are men-only.
q5 Rank universities by admission rate within the range between Chicago and Los Angeles.

Download Files: University.zip