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 = "funder,government"

✎ View and edit SQL

This data as json, CSV (advanced)

country 2

  • US 2
  • RU 1

two_year 1

  • 0 1

kind 1

  • funder,government · 3 ✖
Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
567 567 ror:00p0fzx29 Government of New York City 00p0fzx29 Q3112559           US funder,government            
1457 1457 ror:04xnm9a92 The Russian Presidential Academy of National Economy and Public Administration 04xnm9a92 Q2822458           RU funder,government            
1514 1514 ror:0055d0g64 United States Air Force Academy 0055d0g64 Q1331280 128328 1 1 0 22 US funder,government 1 CO 39.010957 -104.891358 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 31.644ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits