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 = "FR"

✎ 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
667 667 ror:037x4qk98 International Union Against Tuberculosis and Lung Disease 037x4qk98 Q2096638           FR funder,nonprofit            
1808 1808 ror:02rx3b187 Université Grenoble Alpes 02rx3b187 Q945876           FR education,funder            
1809 1809 ror:03z6jp965 Université Sorbonne Nouvelle 03z6jp965 Q571293           FR education            
1810 1810 ror:04ezk3x31 Université Toulouse - Jean Jaurès 04ezk3x31 Q1933558           FR education            
1811 1811 ror:02kzqn938 Université de Lille 02kzqn938 Q3551621           FR education,funder            
1812 1812 ror:04xhy8q59 Université de Poitiers 04xhy8q59 Q661056           FR 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);