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

8 rows where country = "MX"

✎ 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
80 80 ror:04mrrw205 Autonomous University of Chihuahua 04mrrw205 Q4826829           MX education,funder            
116 116 ror:03p2z7827 Benemérita Universidad Autónoma de Puebla 03p2z7827 Q495032           MX education,funder            
247 247 ror:009eqmr18 Centro de Investigación y de Estudios Avanzados del Instituto Politécnico Nacional 009eqmr18 Q5011793           MX facility            
1521 1521 ror:05xwcq167 Universidad Autónoma de Baja California 05xwcq167 Q4826824           MX education,funder            
1524 1524 ror:01tmp8f25 Universidad Nacional Autónoma de México 01tmp8f25 Q222738           MX education,funder            
1528 1528 ror:00njxm476 Universidad Popular Autónoma del Estado de Puebla 00njxm476 Q7894306           MX education            
1531 1531 ror:03efxn362 Universidad Veracruzana 03efxn362 Q1808814           MX education,funder            
1534 1534 ror:058cjye32 Universidad de Guanajuato 058cjye32 Q641889           MX education,funder            

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