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

658 rows where kind = "education" and two_year = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sector, carnegie_basic, control, hbcu, tribal

country 2

two_year 1

kind 1

  • education · 658 ✖
Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
2 2 ror:04089t965 Abraham Baldwin Agricultural College 04089t965 Q4668762 138558 1 1 0 23 US education 1 GA 31.481889 -83.528281 0 0
5 5 ror:02f131c52 Adrian College 02f131c52 Q4684938 168528 2 1 0 22 US education 2 MI 41.898591 -84.061481 0 0
6 6 ror:03w5gm511 Adventist University of Health Sciences 03w5gm511 Q4686466 133872 2 1 0 26 US education 2 FL 28.576142 -81.367687 0 0
9 9 ror:05hz8m414 Alabama Agricultural and Mechanical University 05hz8m414 Q1551044 100654 1 1 0 18 US education 1 AL 34.783368 -86.568502 1 0
14 14 ror:01vme4277 Albany State University 01vme4277 Q4709390 138716 1 1 0 19 US education 1 GA 31.56928 -84.141825 1 0
16 16 ror:00dr54257 Alcorn State University 00dr54257 Q1805243 175342 1 1 0 20 US education 1 MS 31.877216 -91.142854 1 0
23 23 ror:02h7s7a86 Allen University 02h7s7a86 Q49041 217624 2 1 0 21 US education 2 SC 34.010348 -81.020045 1 0
25 25 ror:028gf7832 Alvernia University 028gf7832 Q4737977 210775 2 1 0 17 US education 2 PA 40.310028 -75.936754 0 0
30 30 ror:05w0qtv14 American InterContinental University 05w0qtv14 Q4744166 445027 3 1 0 18 US education 3 AZ 33.278816 -111.804036 0 0
31 31 ror:02p014d02 American International College 02p014d02 Q3695722 164447 2 1 0 17 US education 2 MA 42.112346 -72.558338 0 0
33 33 ror:02890tv09 American Public University System 02890tv09 Q646842 449339 3 1 0 18 US education 3 WV 39.287826 -77.860121 0 0
35 35 ipeds:131159 American University     131159 2 1 0 16 US education 2 DC 38.936005 -77.088875 0 0
41 41 ipeds:150066 Anderson University     150066 2 1 0 20 US education 2 IN 40.112768 -85.664315 0 0
42 42 ipeds:217633 Anderson University     217633 2 1 0 18 US education 2 SC 34.5152 -82.640358 0 0
48 48 ror:058gcv483 Antioch University Seattle 058gcv483 Q4775043 245883 2 1 0 19 US education 2 WA 47.615916 -122.346318 0 0
51 51 ipeds:168786 Aquinas College     168786 2 1 0 21 US education 2 MI 42.96019 -85.628785 0 0
52 52 ror:00ff4bt20 Arcadia University 00ff4bt20 Q4785174 211088 2 1 0 18 US education 2 PA 40.092606 -75.163876 0 0
53 53 ror:01j8znm98 Arizona Christian University 01j8znm98 Q4791274 105899 2 1 0 22 US education 2 AZ 33.622952 -112.181776 0 0
60 60 ror:05c5js686 Ashland University 05c5js686 Q986122 201104 2 1 0 18 US education 2 OH 40.861755 -82.321061 0 0
65 65 ipeds:164562 Assumption University     164562 2 1 0 19 US education 2 MA 42.294226 -71.828991 0 0
66 66 ror:01zx16v02 Athens State University 01zx16v02 Q4813523 100812 1 1 0 22 US education 1 AL 34.806793 -86.964698 0 0
67 67 ror:0368f8s77 Atlanta Metropolitan State College 0368f8s77 Q4816111 138901 1 1 0 23 US education 1 GA 33.70893 -84.404659 0 0
72 72 ipeds:138983 Augusta State University     138983 1 1 0 19 US education 1 GA     0 0
74 74 ipeds:143084 Augustana College     143084 2 1 0 21 US education 2 IL 41.502365 -90.55057 0 0
75 75 ror:03a3qwm26 Augustana University 03a3qwm26 Q3298397 219000 2 1 0 19 US education 2 SD 43.525148 -96.736975 0 0
76 76 ror:027487t94 Aurora University 027487t94 Q11959672 143118 2 1 0 17 US education 2 IL 41.753631 -88.349023 0 0
77 77 ror:052k56z27 Austin College 052k56z27 Q4823037 222983 2 1 0 21 US education 2 TX 33.646345 -96.596331 0 0
81 81 ror:002f2sy95 Avila University 002f2sy95 Q4828842 176628 2 1 0 19 US education 2 MO 38.91339 -94.591758 0 0
87 87 ror:003rdc798 Baker College 003rdc798 Q4849134 168847 2 1 0 19 US education 2 MI 42.984804 -84.172404 0 0
89 89 ror:04v44vh53 Bank Street College of Education 04v44vh53 Q2882628 189015 2 1 0 32 US education 2 NY 40.805604 -73.966643 0 0
95 95 ror:00mesrk97 Barton College 00mesrk97 Q4865607 197911 2 1 0 22 US education 2 NC 35.734376 -77.913867 0 0
100 100 ror:05xca6483 Bay Path University 05xca6483 Q3695687 164632 2 1 0 18 US education 2 MA 42.055088 -72.583382 0 0
102 102 ror:04pqs5t46 Beacon College 04pqs5t46 Q812885 384254 2 1 0 22 US education 2 FL 28.811281 -81.87415 0 0
105 105 ror:04p81nz21 Bellarmine University 04p81nz21 Q2894666 156286 2 1 0 17 US education 2 KY 38.219279 -85.704997 0 0
106 106 ipeds:234669 Bellevue College     234669 1 1 0 23 US education 1 WA 47.584014 -122.150118 0 0
107 107 ror:00b7ckn36 Bellevue University 00b7ckn36 Q4883967 180814 2 1 0 18 US education 2 NE 41.150225 -95.91764 0 0
108 108 ror:00aj75s74 Belmont Abbey College 00aj75s74 Q4884322 197984 2 1 0 22 US education 2 NC 35.260651 -81.041315 0 0
110 110 ror:033vjpd42 Belmont University 033vjpd42 Q3298359 219709 2 1 0 17 US education 2 TN 36.135589 -86.794807 0 0
112 112 ror:01yjyvb35 Bemidji State University 01yjyvb35 Q816377 173124 1 1 0 20 US education 1 MN 47.482341 -94.874119 0 0
113 113 ror:045r9wn29 Benedict College 045r9wn29 Q4887262 217721 2 1 0 22 US education 2 SC 34.012941 -81.020403 1 0
114 114 ror:02fn4qf13 Benedictine College 02fn4qf13 Q4887341 154712 2 1 0 22 US education 2 KS 39.573079 -95.113858 0 0
115 115 ror:053fh2363 Benedictine University 053fh2363 Q4887352 145619 2 1 0 18 US education 2 IL 41.777569 -88.097307 0 0
117 117 ror:03cey6t89 Bennett College 03cey6t89 Q4889676 197993 2 1 0 21 US education 2 NC 36.067531 -79.77998 1 0
119 119 ror:05kmcre68 Berea College 05kmcre68 Q846859 156295 2 1 0 21 US education 2 KY 37.57202 -84.292893 0 0
121 121 ror:02xewxa75 Berkeley College 02xewxa75 Q2897191 183789 3 1 0 20 US education 3 NJ 40.898587 -74.189483 0 0
123 123 ipeds:237181 Bethany College     237181 2 1 0 21 US education 2 WV 40.205819 -80.560056 0 0
124 124 ror:03z2kds18 Bethany Lutheran College 03z2kds18 Q4897766 173142 2 1 0 21 US education 2 MN 44.166649 -93.990805 0 0
125 125 ipeds:154749 Bethel College-North Newton     154749 2 1 0 22 US education 2 KS 38.075169 -97.343256 0 0
126 126 ror:04e0j1059 Bethune-Cookman University 04e0j1059 Q3298457 132602 2 1 0 21 US education 2 FL 29.207195 -81.032946 1 0
129 129 ror:006g42111 Birmingham–Southern College 006g42111 Q4916871 100937 2 1 0 21 US education 2 AL 33.513774 -86.850552 0 0

Next page

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