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 = "CA" and kind = "education"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

  • education · 6 ✖

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
214 214 ror:04r56ky81 Capital College 04r56ky81             CA education            
358 358 ror:01t8qhk85 Conestoga College 01t8qhk85 Q5159523           CA education            
394 394 ror:04pmj7516 Dawson College 04pmj7516 Q2983587           CA education            
552 552 ror:04s2jm085 Georgian College 04s2jm085 Q5548011           CA education            
1073 1073 ror:04k2ezm16 Okanagan College 04k2ezm16 Q7081780           CA education            
1951 1951 ror:04t8wxc05 Yorkville University 04t8wxc05 Q8055824           CA education            

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);