institutions
Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits
418 rows where two_year = 1
This data as json, CSV (advanced)
Suggested facets: sector, iclevel, carnegie_basic, control, hbcu, tribal
| Link | rowid ▼ | id | name | ror_id | wikidata | ipeds_unitid | sector | iclevel | two_year | carnegie_basic | country | kind | control | state | lat | lon | hbcu | tribal |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 7 | ror:01g325629 | Aims Community College | 01g325629 | Q4697183 | 126207 | 1 | 1 | 1 | 3 | US | education | 1 | CO | 40.409559 | -104.763415 | 0 | 0 |
| 10 | 10 | ror:015n0my11 | Alabama Southern Community College | 015n0my11 | Q4705321 | 101949 | 4 | 2 | 1 | 1 | US | education | 1 | AL | 0 | 0 | ||
| 20 | 20 | ror:053sdsy29 | Allan Hancock College | 053sdsy29 | Q4730667 | 108807 | 4 | 2 | 1 | 2 | US | education | 1 | CA | 34.943716 | -120.421144 | 0 | 0 |
| 22 | 22 | ror:03q8jhh94 | Allen Community College | 03q8jhh94 | Q4731591 | 154642 | 4 | 2 | 1 | 3 | US | education | 1 | KS | 37.938038 | -95.396377 | 0 | 0 |
| 27 | 27 | ror:04cwzs398 | Alvin Community College | 04cwzs398 | Q4738072 | 222567 | 4 | 2 | 1 | 9 | US | education | 1 | TX | 29.396244 | -95.240671 | 0 | 0 |
| 34 | 34 | ror:05t365n53 | American River College | 05t365n53 | Q2791079 | 109208 | 4 | 2 | 1 | 5 | US | education | 1 | CA | 38.65085 | -121.349672 | 0 | 0 |
| 43 | 43 | ror:02axqg987 | Angelina College | 02axqg987 | Q4762731 | 222822 | 4 | 2 | 1 | 5 | US | education | 1 | TX | 31.287444 | -94.731625 | 0 | 0 |
| 46 | 46 | ror:05eybs418 | Anoka-Ramsey Community College | 05eybs418 | Q4769881 | 172963 | 4 | 2 | 1 | 3 | US | education | 1 | MN | 45.172978 | -93.351697 | 0 | 0 |
| 47 | 47 | ror:01trzhx11 | Antelope Valley College | 01trzhx11 | Q4771201 | 109350 | 1 | 1 | 1 | 14 | US | education | 1 | CA | 34.676207 | -118.186166 | 0 | 0 |
| 55 | 55 | ror:04z557486 | Arizona Western College | 04z557486 | Q4791459 | 104160 | 4 | 2 | 1 | 2 | US | education | 1 | AZ | 32.689306 | -114.495968 | 0 | 0 |
| 62 | 62 | ror:05yptg266 | Asnuntuck Community College | 05yptg266 | Q4807464 | 128577 | 4 | 2 | 1 | 8 | US | education | 1 | CT | 41.998409 | -72.570177 | 0 | 0 |
| 68 | 68 | ror:01tphmj73 | Atlantic Cape Community College | 01tphmj73 | Q4816324 | 183655 | 4 | 2 | 1 | 1 | US | education | 1 | NJ | 39.462081 | -74.680019 | 0 | 0 |
| 78 | 78 | ror:044tz3m61 | Austin Community College | 044tz3m61 | Q3629946 | 222992 | 1 | 1 | 1 | 14 | US | education | 1 | TX | 30.326304 | -97.713778 | 0 | 0 |
| 86 | 86 | ipeds:139010 | Bainbridge College | 139010 | 4 | 2 | 1 | 2 | US | education | 1 | GA | 0 | 0 | ||||
| 99 | 99 | ror:057r54s29 | Baton Rouge Community College | 057r54s29 | Q4869472 | 437103 | 4 | 2 | 1 | 4 | US | education | 1 | LA | 30.448276 | -91.137935 | 0 | 0 |
| 109 | 109 | ror:051v7cd19 | Belmont College | 051v7cd19 | Q4884341 | 201283 | 4 | 2 | 1 | 8 | US | education | 1 | OH | 40.07695 | -80.964901 | 0 | 0 |
| 120 | 120 | ror:02hwvpm08 | Bergen Community College | 02hwvpm08 | Q4891499 | 183743 | 4 | 2 | 1 | 1 | US | education | 1 | NJ | 40.951782 | -74.088804 | 0 | 0 |
| 130 | 130 | ror:042fn4q48 | Bismarck State College | 042fn4q48 | Q4918312 | 200022 | 1 | 1 | 1 | 14 | US | education | 1 | ND | 46.821459 | -100.816534 | 0 | 0 |
| 132 | 132 | ror:02zvm4r30 | Black Hawk College | 02zvm4r30 | Q4920876 | 143279 | 4 | 2 | 1 | 6 | US | education | 1 | IL | 41.477283 | -90.447799 | 0 | 0 |
| 135 | 135 | ror:03g68pb09 | Blinn College | 03g68pb09 | Q4926785 | 223427 | 4 | 2 | 1 | 1 | US | education | 1 | TX | 30.160457 | -96.40852 | 0 | 0 |
| 138 | 138 | ror:027w3dq81 | Blue Mountain Community College | 027w3dq81 | Q4929509 | 208275 | 4 | 2 | 1 | 3 | US | education | 1 | OR | 45.677313 | -118.816944 | 0 | 0 |
| 139 | 139 | ror:02rw6sa19 | Blue Ridge Community College | 02rw6sa19 | Q4929703 | 231536 | 4 | 2 | 1 | 2 | US | education | 1 | VA | 38.279075 | -78.937471 | 0 | 0 |
| 140 | 140 | ror:034zes736 | Bluegrass Community and Technical College | 034zes736 | Q14690128 | 156392 | 4 | 2 | 1 | 4 | US | education | 1 | KY | 38.024808 | -84.503665 | 0 | 0 |
| 142 | 142 | ror:040hwr020 | Borough of Manhattan Community College | 040hwr020 | Q4946345 | 190521 | 4 | 2 | 1 | 1 | US | education | 1 | NY | 40.71879 | -74.011826 | 0 | 0 |
| 151 | 151 | ror:02srjxm46 | Brazosport College | 02srjxm46 | Q4959024 | 223506 | 1 | 1 | 1 | 14 | US | education | 1 | TX | 29.048604 | -95.40934 | 0 | 0 |
| 159 | 159 | ror:03ehdx160 | Brightpoint Community College | 03ehdx160 | Q6261498 | 232450 | 4 | 2 | 1 | 3 | US | education | 1 | VA | 37.346254 | -77.407919 | 0 | 0 |
| 160 | 160 | ror:05e168j76 | Bristol Community College | 05e168j76 | Q4968880 | 165033 | 4 | 2 | 1 | 1 | US | education | 1 | MA | 41.721994 | -71.119133 | 0 | 0 |
| 162 | 162 | ror:04w6mxh75 | Bronx Community College | 04w6mxh75 | Q4974180 | 190530 | 4 | 2 | 1 | 1 | US | education | 1 | NY | 40.858112 | -73.912043 | 0 | 0 |
| 163 | 163 | ror:05mrhv083 | Brookdale Community College | 05mrhv083 | Q4974383 | 183859 | 4 | 2 | 1 | 4 | US | education | 1 | NJ | 40.324906 | -74.132746 | 0 | 0 |
| 164 | 164 | ror:04z1g6718 | Brookhaven College | 04z1g6718 | Q4974630 | 223524 | 4 | 2 | 1 | 7 | US | education | 1 | TX | 0 | 0 | ||
| 166 | 166 | ror:02jj1w915 | Broward College | 02jj1w915 | Q556733 | 132709 | 1 | 1 | 1 | 14 | US | education | 1 | FL | 26.119422 | -80.14183 | 0 | 0 |
| 169 | 169 | ror:02em8e723 | Brunswick Community College | 02em8e723 | 198084 | 4 | 2 | 1 | 2 | US | education | 1 | NC | 34.038973 | -78.22979 | 0 | 0 | |
| 173 | 173 | ror:00f659030 | Bucks County Community College | 00f659030 | Q4983461 | 211307 | 4 | 2 | 1 | 2 | US | education | 1 | PA | 40.239102 | -74.965841 | 0 | 0 |
| 176 | 176 | ror:05r3ht428 | Bunker Hill Community College | 05r3ht428 | Q3695816 | 165112 | 4 | 2 | 1 | 1 | US | education | 1 | MA | 42.374806 | -71.069263 | 0 | 0 |
| 178 | 178 | ror:02zq8st27 | Butte College | 02zq8st27 | Q5002793 | 110246 | 4 | 2 | 1 | 7 | US | education | 1 | CA | 39.649782 | -121.644831 | 0 | 0 |
| 183 | 183 | ror:034948b51 | Calhoun Community College | 034948b51 | Q5019761 | 101514 | 4 | 2 | 1 | 5 | US | education | 1 | AL | 34.645844 | -86.949674 | 0 | 0 |
| 211 | 211 | ror:02w1skc55 | Cape Cod Community College | 02w1skc55 | Q5034681 | 165194 | 4 | 2 | 1 | 5 | US | education | 1 | MA | 41.691911 | -70.337334 | 0 | 0 |
| 212 | 212 | ror:05mc3r439 | Cape Fear Community College | 05mc3r439 | Q5034785 | 198154 | 4 | 2 | 1 | 1 | US | education | 1 | NC | 34.240624 | -77.948306 | 0 | 0 |
| 221 | 221 | ror:01wgg9r40 | Carroll Community College | 01wgg9r40 | Q5046528 | 405872 | 4 | 2 | 1 | 5 | US | education | 1 | MD | 39.531805 | -76.991113 | 0 | 0 |
| 224 | 224 | ror:02pys4392 | Cascadia College | 02pys4392 | Q5048210 | 439190 | 1 | 1 | 1 | 14 | US | education | 1 | WA | 47.760915 | -122.191572 | 0 | 0 |
| 229 | 229 | ror:01qqm4q52 | Cañada College | 01qqm4q52 | Q5055561 | 111434 | 4 | 2 | 1 | 3 | US | education | 1 | CA | 37.44877 | -122.265398 | 0 | 0 |
| 230 | 230 | ror:00pkwdr13 | Cecil College | 00pkwdr13 | Q5056011 | 162104 | 4 | 2 | 1 | 4 | US | education | 1 | MD | 39.642225 | -75.955949 | 0 | 0 |
| 233 | 233 | ror:003xs1762 | Central Arizona College | 003xs1762 | Q5060345 | 104346 | 4 | 2 | 1 | 2 | US | education | 1 | AZ | 32.957092 | -111.652501 | 0 | 0 |
| 235 | 235 | ror:01w4nn703 | Central Community College | 01w4nn703 | Q5060624 | 180902 | 4 | 2 | 1 | 9 | US | education | 1 | NE | 40.889582 | -98.372549 | 0 | 0 |
| 238 | 238 | ror:04e4qaj02 | Central Maine Community College | 04e4qaj02 | Q5061387 | 161077 | 4 | 2 | 1 | 4 | US | education | 1 | ME | 44.134346 | -70.235498 | 0 | 0 |
| 241 | 241 | ror:02yw59f42 | Central New Mexico Community College | 02yw59f42 | Q5061506 | 187532 | 4 | 2 | 1 | 2 | US | education | 1 | NM | 35.071878 | -106.628861 | 0 | 0 |
| 242 | 242 | ror:01by6g473 | Central Oregon Community College | 01by6g473 | Q5061559 | 208318 | 4 | 2 | 1 | 2 | US | education | 1 | OR | 44.071401 | -121.348585 | 0 | 0 |
| 244 | 244 | ror:00ehy3369 | Central Virginia Community College | 00ehy3369 | Q5061999 | 231697 | 4 | 2 | 1 | 3 | US | education | 1 | VA | 37.358809 | -79.184238 | 0 | 0 |
| 248 | 248 | ror:008hr1h38 | Century College | 008hr1h38 | Q5063141 | 175315 | 4 | 2 | 1 | 5 | US | education | 1 | MN | 45.041823 | -92.982105 | 0 | 0 |
| 249 | 249 | ror:03khjbj61 | Cerritos College | 03khjbj61 | Q5064834 | 111887 | 4 | 2 | 1 | 1 | US | education | 1 | CA | 33.886874 | -118.097337 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);