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

15 rows where country = "GB" and kind = "education,funder"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

  • education,funder · 15 ✖

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
98 98 ror:0038jbq24 Bath Spa University 0038jbq24 Q3091754           GB education,funder            
168 168 ror:00dn4t376 Brunel University of London 00dn4t376 Q932411           GB education,funder            
373 373 ror:01tgmhj36 Coventry University 01tgmhj36 Q1138080           GB education,funder            
731 731 ror:0220mzb33 King's College London 0220mzb33 Q245247           GB education,funder            
754 754 ror:04f2nsd36 Lancaster University 04f2nsd36 Q262854           GB education,funder            
794 794 ror:0090zs177 London School of Economics and Political Science 0090zs177 Q174570           GB education,funder            
1096 1096 ror:04v2twj65 Oxford Brookes University 04v2twj65 Q132478           GB education,funder            
1294 1294 ror:019wt1929 Sheffield Hallam University 019wt1929 Q1752117           GB education,funder            
1600 1600 ror:03yghzc09 University of Exeter 03yghzc09 Q1414861           GB education,funder            
1605 1605 ror:00vtgdb53 University of Glasgow 00vtgdb53 Q192775           GB education,funder            
1635 1635 ror:024mrxd33 University of Leeds 024mrxd33 Q503424           GB education,funder            
1638 1638 ror:04cw6st05 University of London 04cw6st05 Q170027           GB education,funder            
1717 1717 ror:03ykbk197 University of Portsmouth 03ykbk197 Q2744209           GB education,funder            
1724 1724 ror:05v62cm79 University of Reading 05v62cm79 Q1432632           GB education,funder            
1798 1798 ror:04m01e293 University of York 04m01e293 Q967165           GB 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);