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

7 rows where kind = "funder,other"

✎ View and edit SQL

This data as json, CSV (advanced)

kind 1

  • funder,other · 7 ✖

country 1

  • US 7

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
63 63 ror:015t7hs32 Association of American Colleges and Universities 015t7hs32 Q4809602           US funder,other            
64 64 ror:05nry7t92 Association of Public and Land-grant Universities 05nry7t92 Q4810015           US funder,other            
676 676 ror:003thv661 Jack Kent Cooke Foundation 003thv661             US funder,other            
918 918 ror:00ag8ns14 Modern Language Association 00ag8ns14 Q1506059           US funder,other            
965 965 ror:04ebkyp66 National Council of Teachers of English 04ebkyp66             US funder,other            
1066 1066 ror:032h87485 Office of Education 032h87485             US funder,other            
1929 1929 ror:03kyxhh57 Wisconsin Historical Society 03kyxhh57 Q321717           US funder,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 23.249ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits