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:
university | |
---|---|
Rows | 7,803 |
Attributes | 1729 |
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
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