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

6 rows where country = "AU"

✎ View and edit SQL

This data as json, CSV (advanced)

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
494 494 ror:01kpzv902 Flinders University 01kpzv902 Q15575           AU education,funder            
865 865 ror:0132xxe06 Melbourne Institute of Technology 0132xxe06 Q6811806           AU education            
1458 1458 ror:01ej9dk98 The University of Melbourne 01ej9dk98 Q319078           AU education,funder            
1459 1459 ror:00rqy9422 The University of Queensland 00rqy9422 Q866012           AU education,funder            
1460 1460 ror:0384j8v12 The University of Sydney 0384j8v12 Q487556           AU education,funder            
1796 1796 ror:00jtmb277 University of Wollongong 00jtmb277 Q1350021           AU 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);