home / cccc

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

3 rows where kind = "nonprofit" and two_year = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: carnegie_basic

two_year 1

  • - · 3 ✖

kind 1

  • nonprofit · 3 ✖

country 1

  • US 3
Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
391 391 ror:055e80y87 Davenport University 055e80y87 Q5230267 169479 2 1 0 18 US nonprofit 2 MI 42.850013 -85.533519 0 0
653 653 ror:03r1ch818 Indiana Institute of Technology 03r1ch818 Q14688450 151290 2 1 0 18 US nonprofit 2 IN 41.078365 -85.116479 0 0
1142 1142 ror:007m3p006 Pratt Institute 007m3p006 Q1204714 194578 2 1 0 30 US nonprofit 2 NY 40.691297 -73.96431 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);
Powered by Datasette · Queries took 26.526ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits