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

6 rows where country = "US" and kind = "funder,nonprofit"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

  • funder,nonprofit · 6 ✖

country 1

  • US · 6 ✖

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
29 29 ror:0158f8t80 American Bar Association 0158f8t80 Q463465           US funder,nonprofit            
360 360 ror:024weye46 Conservation International 024weye46 Q1127365           US funder,nonprofit            
454 454 ror:03b5q4637 Educational Testing Service 03b5q4637 Q959089           US funder,nonprofit            
678 678 ror:021sy4w91 Jackson Laboratory 021sy4w91 Q1677355           US funder,nonprofit            
885 885 ror:009445d52 Michigan Humanities Council 009445d52             US funder,nonprofit            
1341 1341 ror:02wj29p03 Southern Regional Education Board 02wj29p03 Q7570391           US funder,nonprofit            

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