institutions

ROR records (ror:) and IPEDS-only colleges (ipeds:). two_year = 1 when IPEDS ICLEVEL is 2 or the Carnegie Basic class is 1–14.

Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits

5 rows where country = "ZA"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

country 1

two_year 0

Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
1388 1388 ror:05bk57929 Stellenbosch University 05bk57929 Q1066492           ZA education,funder            
1631 1631 ror:04z6c2n17 University of Johannesburg 04z6c2n17 Q1972050           ZA education,funder            
1718 1718 ror:00g0p6g84 University of Pretoria 00g0p6g84 Q604444           ZA education,funder            
1737 1737 ror:048cwvf49 University of South Africa 048cwvf49 Q677993           ZA education,funder            
1807 1807 ror:03rp50x72 University of the Witwatersrand 03rp50x72 Q534643           ZA education,funder            

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE institutions (id TEXT, name TEXT, ror_id TEXT, wikidata TEXT, ipeds_unitid TEXT, sector INTEGER, iclevel INTEGER, two_year INTEGER, carnegie_basic INTEGER, country TEXT, kind TEXT, control INTEGER, state TEXT, lat REAL, lon REAL, hbcu INTEGER, tribal INTEGER);