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

1,200 rows where two_year = 0

✎ View and edit SQL

This data as json, CSV (advanced)

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

country 3

two_year 1

  • - · 1,200 ✖
Link rowid ▼ id name ror_id wikidata ipeds_unitid sector iclevel two_year carnegie_basic country kind control state lat lon hbcu tribal
1 1 ror:004srrf86 Abilene Christian University 004srrf86 Q1805145 222178 2 1 0 17 US education,funder 2 TX 32.468943 -99.709797 0 0
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
3 3 ror:05vccrs41 Adams State University 05vccrs41 Q351971 126182 1 1 0 18 US education,funder 1 CO 37.473636 -105.879642 0 0
4 4 ror:025n13r50 Adelphi University 025n13r50 Q4682076 188429 2 1 0 17 US education,funder 2 NY 40.721439 -73.653321 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
11 11 ror:01eedy375 Alabama State University 01eedy375 Q941524 100724 1 1 0 17 US education,funder 1 AL 32.364317 -86.295677 1 0
12 12 ror:014hfaw95 Albany College of Pharmacy and Health Sciences 014hfaw95 Q2830804 188526 2 1 0 26 US education,funder 2 NY 42.650371 -73.779063 0 0
13 13 ror:03g66yt05 Albany Medical College 03g66yt05 Q4709349 188580 2 1 0 25 US healthcare 2 NY 42.65382 -73.777289 0 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
15 15 ror:05nnk3913 Albion College 05nnk3913 Q2831920 168546 2 1 0 21 US education,funder 2 MI 42.245049 -84.745639 0 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
18 18 ror:01k81gt67 Alfred University 01k81gt67 Q3446091 188641 2 1 0 18 US education,funder 2 NY 42.254476 -77.788106 0 0
21 21 ror:02jgzjj54 Allegheny College 02jgzjj54 Q4062566 210669 2 1 0 21 US education,funder 2 PA 41.64869 -80.147168 0 0
23 23 ror:02h7s7a86 Allen University 02h7s7a86 Q49041 217624 2 1 0 21 US education 2 SC 34.010348 -81.020045 1 0
24 24 ror:02pdzen98 Alma College 02pdzen98 Q4733529 168591 2 1 0 22 US education,funder 2 MI 43.38004 -84.672053 0 0
25 25 ror:028gf7832 Alvernia University 028gf7832 Q4737977 210775 2 1 0 17 US education 2 PA 40.310028 -75.936754 0 0
26 26 ror:04h7gk919 Alverno College 04h7gk919 Q4737981 238193 2 1 0 18 US education,funder 2 WI 42.982842 -87.965174 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
44 44 ror:04n34rm95 Angelo State University 04n34rm95 Q536709 222831 1 1 0 18 US education,funder 1 TX 31.440914 -100.465051 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
49 49 ror:051m4vc48 Appalachian State University 051m4vc48 Q620640 197869 1 1 0 18 US education,funder 1 NC 36.215536 -81.680583 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
54 54 ror:03efmqc40 Arizona State University 03efmqc40 Q670897 104151 1 1 0 15 US education,funder 1 AZ 33.417721 -111.934383 0 0
57 57 ror:006pyvd89 Arkansas State University 006pyvd89 Q500131 106458 1 1 0 16 US education,funder 1 AR 35.842388 -90.679988 0 0
58 58 ror:03bahkk91 Arkansas Tech University 03bahkk91 Q673111 106467 1 1 0 18 US education,funder 1 AR 35.293237 -93.13562 0 0
59 59 ror:03rr7q548 Armstrong Atlantic State University 03rr7q548 Q4793919 138789 1 1 0 18 US education,funder 1 GA     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
69 69 ror:02v80fc35 Auburn University 02v80fc35 Q540672 100858 1 1 0 15 US education,funder 1 AL 32.599378 -85.488258 0 0
70 70 ror:05eynd241 Auburn University at Montgomery 05eynd241 Q758560 100830 1 1 0 18 US education,funder 1 AL 32.36736 -86.177544 0 0
71 71 ror:057ewhh68 Augsburg University 057ewhh68 Q760516 173045 2 1 0 18 US education,funder 2 MN 44.966307 -93.240436 0 0
72 72 ipeds:138983 Augusta State University     138983 1 1 0 19 US education 1 GA     0 0
73 73 ror:012mef835 Augusta University 012mef835 Q5547686 482149 1 1 0 16 US education,funder 1 GA 33.47037 -81.989071 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
79 79 ror:05tx3bv88 Austin Peay State University 05tx3bv88 Q781153 219602 1 1 0 18 US education,funder 1 TN 36.533319 -87.354081 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

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