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

12 rows where country = "CN"

✎ 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
103 103 ror:03te2zs36 Beijing Language and Culture University 03te2zs36 Q549697           CN education,funder            
423 423 ror:04sr5ys16 Duke Kunshan University 04sr5ys16 Q1391751           CN education,funder            
523 523 ror:013q1eq08 Fudan University 013q1eq08 Q495015           CN education,funder            
581 581 ror:02frt9q65 Guangxi Normal University 02frt9q65 Q137006           CN education,funder            
587 587 ror:03q648j11 Hainan University 03q648j11 Q5639382           CN education,funder            
817 817 ror:029man787 Luoyang Normal University 029man787 Q22101003           CN education,funder            
1287 1287 ror:006teas31 Shanghai University 006teas31 Q1343386           CN education,funder            
1288 1288 ror:032gae017 Shanghai University of Political Science and Law 032gae017 Q7488529           CN education            
1289 1289 ror:0286g6711 Shaoguan University 0286g6711 Q15903840           CN education,funder            
1628 1628 ror:05khqpb71 University of International Business and Economics 05khqpb71 Q835779           CN education,funder            
1874 1874 ror:05609xa16 Wenzhou-Kean University 05609xa16 Q6382152           CN education            
1953 1953 ror:0040axw97 Yunnan University 0040axw97 Q649882           CN 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);