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:
"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, ...
- "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"
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>
|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