database 美国大学和学院数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1937988/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Database for US Universities and Colleges
提问by Omar
Not sure if this is the proper place to post this question, but I've seen questions regarding ISBN databases, so I thought it would be appropriate.
不确定这是否是发布此问题的合适位置，但我已经看到有关 ISBN 数据库的问题，所以我认为这是合适的。
In my website, I intend allow my users to choose between all the US college/universities (community or 4 year institutes). I would then store their selection in a database.
在我的网站上，我打算让我的用户在所有美国大学/大学（社区或 4 年制学院）之间进行选择。然后我会将他们的选择存储在数据库中。
At first I thought about allowing them to input the name themselves, but saw some issues with that. I tried to look for a database of some sort, but all I found were search engines to find a specific university.
起初我想让他们自己输入名字，但看到了一些问题。我试图寻找某种数据库，但我找到的只是搜索引擎来查找特定大学。
I was hoping to find a database can I export to my own database (SQL Server) and have users search my own database.
我希望找到一个可以导出到我自己的数据库（SQL Server）并让用户搜索我自己的数据库的数据库。
Has anyone come across this issue and found a reasonable solution?
有没有人遇到过这个问题并找到了合理的解决方案？
回答by JeremyPlease
This is an old question, but I wanted to post the answer for those who find this page.
这是一个老问题，但我想为找到此页面的人发布答案。
This should do the trick: http://ope.ed.gov/accreditation/GetDownloadFile.aspx
这应该可以解决问题：http: //ope.ed.gov/accreditation/GetDownloadFile.aspx
It's a csv and xls file of all the accredited universities in the US. It's about 22,800 rows and narrowing it uniquely by name brings it down to about 9,000.
它是美国所有认可大学的 csv 和 xls 文件。它大约有 22,800 行，按名称唯一地缩小它会使其减少到大约 9,000。
Enjoy!
享受！
回答by Andrew Cafourek
This question was posted in 2011, but luckily data is getting easier to come by!
这个问题是在 2011 年发布的，但幸运的是数据越来越容易获得！
Department of Education now has an API(also CSV) available to get a variety of data about universities as well as public elementary and high schools.
教育部现在有一个 API（也是 CSV），可用于获取有关大学以及公立小学和高中的各种数据。
Their Directory Listing CSV under 'Colleges and Universities' contains about 7,700 rows which matches up pretty well with NCES data(from 2012) putting the number of post-secondary institutions in the US around 7,000.
他们在“学院和大学”下的目录列表 CSV 包含大约 7,700 行，与NCES 数据（从 2012 年开始）非常匹配，使美国的大专院校数量约为 7,000。
Disclaimer before you go write academic research with that database: Considering that NCES number is a couple years out of date, it seems reasonable to assume this Dept of Ed listing is reasonably accurate though I havent tested it rigorously
使用该数据库撰写学术研究之前的免责声明：考虑到 NCES 编号已过时几年，尽管我尚未对其进行严格测试，但假设该教育部列表相当准确似乎是合理的
回答by Jay Zeng
You can combine these two by having a search box with auto complete, if the input query does not match, indicate if they want to add this into database. You can create a table in database to hold all these contributions and they won't get added to the list before you or someone approve it.
您可以通过具有自动完成功能的搜索框将这两者结合起来，如果输入查询不匹配，请指示他们是否要将其添加到数据库中。您可以在数据库中创建一个表来保存所有这些贡献，并且在您或其他人批准之前它们不会被添加到列表中。
回答by Reza
The most complete resource is the IPEDS, you need to click on download survey, and download the year data you like. I have called them to see if they have an API, but no luck there, so it's all in excel format. bummer....
最全的资源是IPEDS，你需要点击下载调查，下载你喜欢的年份数据。我打电话给他们看他们是否有 API，但没有运气，所以都是 excel 格式。无赖....
回答by Tural Ali
Here is the free database of the major worldwide universities:
以下是全球主要大学的免费数据库：
https://github.com/turalus/openDB
https://github.com/turalus/openDB
It's 9498 Universities from all over the world.
这是来自世界各地的9498所大学。
- Their names are translated into 3 languages: English, Russian, Azerbaijani.
- 3072 of them have logos.
- organized by countries
- 他们的名字被翻译成 3 种语言：英语、俄语、阿塞拜疆语。
- 其中 3072 个有徽标。
- 由国家组织
回答by Aditya Mukherji
googling for 'list of us universities' gives me a lot of hits.
you could have a textbox which allows them to enter the name themselves but offers autocomplete functionality which aids them in inputing a string which is an exact match to one in your database (sort of like how facebook autocompletes the friend search on the top right)
if the user ignores this and specifies an unknown string, you could either add this new string to your database or refuse, saying that they should ask the admin to add it for them and then try again
谷歌搜索“美国大学名单”给了我很多点击率。
你可以有一个文本框，允许他们自己输入名字，但提供自动完成功能，帮助他们输入一个与你数据库中的字符串完全匹配的字符串（有点像 facebook 如何自动完成右上角的朋友搜索），
如果用户忽略此并指定一个未知字符串，您可以将此新字符串添加到您的数据库或拒绝，说他们应该要求管理员为他们添加它，然后再试一次
回答by Kevin_cl
you get complete list from
你从
complete world univerity names and ranks. now just scrap them .
完整的世界大学名称和排名。现在只是报废他们。
