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

4 rows where kind = "education,funder" and two_year = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sector, iclevel, carnegie_basic, state

two_year 1

kind 1

  • education,funder · 4 ✖

country 1

Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
525 525 ror:057bq1s94 Fullerton College 057bq1s94 Q5508288 114859 4 2 1 1 US education,funder 1 CA 33.875514 -117.918255 0 0
677 677 ror:00x9kww32 Jackson College 00x9kww32 Q6116999 170444 1 1 1 14 US education,funder 1 MI 42.16483 -84.403942 0 0
1212 1212 ror:01fw8ag12 SUNY Adirondack 01fw8ag12 Q7395009 188438 4 2 1 1 US education,funder 1 NY 43.351839 -73.654813 0 0
1268 1268 ror:01cntdd82 Santa Monica College 01cntdd82 Q1033692 122977 1 1 1 14 US education,funder 1 CA 34.017022 -118.469765 0 0

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