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

43 rows where country = "CA"

✎ 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
19 19 ror:0131d6623 Algoma University 0131d6623 Q1261103           CA education,funder            
161 161 ror:056am2717 Brock University 056am2717 Q923624           CA education,funder            
214 214 ror:04r56ky81 Capital College 04r56ky81             CA education            
218 218 ror:02qtvee93 Carleton University 02qtvee93 Q1041737           CA education,funder            
358 358 ror:01t8qhk85 Conestoga College 01t8qhk85 Q5159523           CA education            
394 394 ror:04pmj7516 Dawson College 04pmj7516 Q2983587           CA education            
468 468 ror:03k788b92 Emily Carr University of Art and Design 03k788b92 Q1337587           CA education,funder            
552 552 ror:04s2jm085 Georgian College 04s2jm085 Q5548011           CA education            
821 821 ror:003s89n44 MacEwan University 003s89n44 Q6721877           CA education,funder            
859 859 ror:01pxwe438 McGill University 01pxwe438 Q201492           CA education,funder            
866 866 ror:04haebc03 Memorial University of Newfoundland 04haebc03 Q1895354           CA education,funder            
944 944 ror:04evsam41 Mount Royal University 04evsam41 Q13650869           CA education,funder            
956 956 ror:03sscxa41 NSCAD University 03sscxa41 Q1131966           CA education,funder            
1073 1073 ror:04k2ezm16 Okanagan College 04k2ezm16 Q7081780           CA education            
1085 1085 ror:059ncap70 Ontario College of Art and Design 059ncap70 Q1632007           CA education,funder            
1086 1086 ror:016zre027 Ontario Tech University 016zre027 Q2495899           CA education,funder            
1156 1156 ror:02y72wh86 Queen's University 02y72wh86 Q1420038           CA education,funder            
1172 1172 ror:04qx1zg28 Redeemer University 04qx1zg28 Q7305718           CA education,funder            
1209 1209 ror:04yr71909 Royal Military College of Canada 04yr71909 Q2565941           CA education,funder            
1302 1302 ror:0213rcc28 Simon Fraser University 0213rcc28 Q201603           CA education,funder            
1440 1440 ror:059qmz715 The Bridge Engagement Center 059qmz715             CA facility            
1471 1471 ror:02gdzyx04 The University of Winnipeg 02gdzyx04 Q472167           CA education,funder            
1475 1475 ror:01v9wj339 Thompson Rivers University 01v9wj339 Q3551501           CA education,funder            
1481 1481 ror:05g13zd79 Toronto Metropolitan University 05g13zd79 Q611723           CA education,funder            
1485 1485 ror:03ygmq230 Trent University 03ygmq230 Q3075124           CA education,funder            
1557 1557 ror:0160cpw27 University of Alberta 0160cpw27 Q640694           CA education,funder            
1569 1569 ror:03rmrcq20 University of British Columbia 03rmrcq20 Q391028           CA education,funder            
1570 1570 ror:03yjb2x39 University of Calgary 03yjb2x39 Q1067471           CA education,funder            
1609 1609 ror:01r7awg59 University of Guelph 01r7awg59 Q795988           CA education,funder            
1636 1636 ror:044j76961 University of Lethbridge 044j76961 Q1689439           CA education,funder            
1685 1685 ror:05nkf0n29 University of New Brunswick 05nkf0n29 Q1112515           CA education,funder            
1709 1709 ror:03c4mmv16 University of Ottawa 03c4mmv16 Q627969           CA education,funder            
1720 1720 ror:02xh9x144 University of Prince Edward Island 02xh9x144 Q1030305           CA education,funder            
1734 1734 ror:010x8gc63 University of Saskatchewan 010x8gc63 Q1514848           CA education,funder            
1762 1762 ror:03dbr7087 University of Toronto 03dbr7087 Q180865           CA education,funder            
1763 1763 ror:05k33q843 University of Toronto Scarborough 05k33q843 Q3137221           CA education,funder            
1772 1772 ror:04s5mat29 University of Victoria 04s5mat29 Q1458113           CA education,funder            
1779 1779 ror:01aff2v68 University of Waterloo 01aff2v68 Q1049470           CA education,funder            
1782 1782 ror:01gw3d370 University of Windsor 01gw3d370 Q2065769           CA education,funder            
1800 1800 ror:04h6w7946 University of the Fraser Valley 04h6w7946 Q2495961           CA education,funder            
1897 1897 ror:02grkyz14 Western University 02grkyz14 Q1144262           CA education,funder            
1914 1914 ror:00fn7gb05 Wilfrid Laurier University 00fn7gb05 Q2166701           CA education,funder            
1951 1951 ror:04t8wxc05 Yorkville University 04t8wxc05 Q8055824           CA 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);