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

22 rows where country = "GB"

✎ 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
50 50 ror:02qp5ew04 Aquinas College 02qp5ew04 Q4782977           GB education            
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            
563 563 ror:01khx4a30 Goldsmiths University of London 01khx4a30 Q528231           GB education            
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            
893 893 ror:01rv4p989 Middlesex University London 01rv4p989 Q1760791           GB education            
1096 1096 ror:04v2twj65 Oxford Brookes University 04v2twj65 Q132478           GB education,funder            
1097 1097 ror:0336mm561 Oxford University Press (United Kingdom) 0336mm561 Q217595           GB company,funder            
1294 1294 ror:019wt1929 Sheffield Hallam University 019wt1929 Q1752117           GB education,funder            
1446 1446 ror:04h0zjx60 The George Institute for Global Health 04h0zjx60 Q30269341           GB facility            
1450 1450 ror:0546ajs61 The London College 0546ajs61 Q59535953           GB education            
1456 1456 ror:05ekxjh51 The Research Network 05ekxjh51             GB facility            
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);