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

5 rows where kind = "other"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

  • other · 5 ✖

country 1

  • US 5

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
641 641 ror:05h9f2z18 I Believe 05h9f2z18             US other            
966 966 ror:05w75gv97 National Football League 05w75gv97 Q1215884           US other            
976 976 ror:0001sz110 National Writing Project 0001sz110             US other            
1505 1505 ror:020ck2w23 UNITE HERE 020ck2w23 Q3547263           US other            
1516 1516 ror:00zyc7969 United States Coast Guard 00zyc7969 Q11224           US other            

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 24.845ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits