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

9 rows where country = "BR"

✎ View and edit SQL

This data as json, CSV (advanced)

country 1

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
1535 1535 ror:00987cb86 Universidade Estadual Paulista (Unesp) 00987cb86 Q1817137           BR education,funder            
1536 1536 ror:01585b035 Universidade Estadual de Londrina 01585b035 Q7894364           BR education,funder            
1537 1537 ror:0176yjw32 Universidade Federal de Minas Gerais 0176yjw32 Q132140           BR education,funder            
1538 1538 ror:047908t24 Universidade Federal de Pernambuco 047908t24 Q2322256           BR education,funder            
1539 1539 ror:01b78mz79 Universidade Federal de Santa Maria 01b78mz79 Q3790133           BR education,funder            
1540 1540 ror:003qt4p19 Universidade Federal do Pampa 003qt4p19 Q7894382           BR education,funder            
1541 1541 ror:041yk2d64 Universidade Federal do Rio Grande do Sul 041yk2d64 Q766447           BR education,funder            
1542 1542 ror:036rp1748 Universidade de São Paulo 036rp1748 Q835960           BR education,funder            
1543 1543 ror:01ee0g236 Universidade do Estado do Rio Grande do Norte 01ee0g236 Q10387913           BR education            

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);