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 world. The scorecards are represented as a relational table, which is fetched from U.S. Government's open data (https://catalog.data.gov/dataset/college-scorecard). The locations are represented as RDF triples, which is extracted from DBpedia 2014 (http://wiki.dbpedia.org/services-resources/datasets/dbpedia-data-set-2014), containing their latitude and longitude. The universities in two data source are redirected to an unified name using the search API of DBpedia (https://en.wikipedia.org/w/api.php?action=opensearch).

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:

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

Download Files: University.zip