有用的库存SQL数据集?[英] Useful stock SQL datasets?

本文是小编为大家收集整理的关于有用的库存SQL数据集?的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

有人知道有任何提供良好,有用的库存数据集的资源吗?例如,我下载了一个SQL脚本,其中包括美国所有州,城市和邮政编码.在最近的一个应用程序中,这为我节省了很多时间,我希望能够通过地理位置进行查找.你们中有人知道其他有用的数据集可以免费下载吗?

例如:

  • 黑名单的IP地址
  • 学院/大学的名字
  • 公司/股票符号的名称

有人有任何建议吗?

编辑:

举例来说,这是我找到一个包含美国所有邮政编码及其相应纬度/经度的MySQL脚本的位置.是否有人在SQL中发现类似有用的数据集可以轻松导入和使用?

/UPLOADS/2009/06/zipcodes.7z

编辑2:

澄清我在说什么类型的数据集...我指的是可以立即对应用程序有用的数据集,可以在各种方案中应用,并且通常表示易于找到的信息小案例,但很难为较大的数据集编译.邮政编码数据库对我来说是一个很好的例子.单个给定的邮政编码不难获得lat/long.但是,在美国获得所有有效的邮政编码的值要花费更多的时间,该数据对单个行业或业务部门也不有用,但是可以在一系列应用程序中应用.

推荐答案

在这里开放数据集的许多链接:

a>

尽管我怀疑他们中的任何一个都会为您生成SQL语句.

其他推荐答案

Shadowman ,如果您说想要的详细信息列表,最好.

  • 黑名单的IP地址 - 广告? xxx?欺诈?
  • 大学/大学的名字 - 世界上?不会太多吗?

这是一个想法如何删除某物列表的想法 - 这就是我这样做的方式:

例如,我需要加利福尼亚的大学/大学清单.

  1. i Google for:colleges california wikipedia.然后打开首先找到项目在那里
  2. 通过使用鼠标,我从那里选择所有的大学和剪贴板;
  3. 打开Excel并将粘贴复制到第一行+列;
  4. 在第一行的第二个单元格中编写模板脚本,例如:

    ="INSERT INTO Colleges (state, name) VALUES ('CA', '" & RC[-1] & "');"
    

    这应该产生

    之类的东西
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Academy of Art University, San Francisco');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Allied American University, Laguna Hills (Online)');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'American Jewish University, Los Angeles');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'American Sports University, San Bernardino');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Anaheim University, Anaheim (Online)');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Antioch University, Culver City');
    -- etc...
    
  5. 然后仅复制生成脚本并将其用于数据库

其他推荐答案

http://www.data.gov/有很多不同的数据集,但大多数数据集不是"库存".

本文地址:https://www.itbaoku.cn/post/597492.html

问题描述

Does anyone know of any resources that provide good, useful stock datasets? For example, I've downloaded a SQL script that includes all of the U.S. states, cities, and zipcodes. This saved me a lot of time in a recent application where I wanted to be able to do lookups by geography. Are any of you aware of other useful datasets that are freely available for download?

For example:

  • Blacklisted IP addresses
  • Names of colleges/universities
  • Names of corporations/stock symbols

Anyone have any recommendations?

EDIT:

As an example, here is the location where I found a MySQL script containing all of the U.S. zip codes and their corresponding latitude/longitude. Has anyone else found similarly useful datasets in SQL that can be easily imported and used?

http://www.chrissibert.com/blog/wp-content/uploads/2009/06/zipcodes.7z

EDIT 2:

To clarify what type of datasets I'm talking about... I'm referring to datasets that can be immediately useful for applications, can be applied across a variety of scenarios, and typically represent information that is easy to find for small cases but harder to compile for larger data sets. The zip code database is a great example to me. It's not hard to get the lat/long for a single given zip code. But, it's a bit more time consuming to get the values for all valid zip codes in the U.S. This data is also not useful to a single industry or business sector, but can be applied across a range of applications.

推荐答案

Lots of links to open data sets here:

http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/

although I doubt any of them will generate SQL statements for you.

其他推荐答案

Shadowman, better if you say detail list of what you want.

  • Blacklisted IP addresses - Ad? Xxx? Fraud?
  • Names of colleges/universities - All in the world? Wouldn't it be too much?

Here is an idea how to drop down a list of something - this is how I do that:

For example, I need a list of colleges/universities in California.

  1. I google for: colleges california wikipedia. Then open the first found item there;
  2. By using mouse I select all the colleges and universities from there to clipboard;
  3. Open Excel and paste copied names into the first row+column;
  4. In the second cell of the first row write templated script, like:

    ="INSERT INTO Colleges (state, name) VALUES ('CA', '" & RC[-1] & "');"
    

    This should produce something like

    INSERT INTO Colleges (state, name) VALUES ('CA', 'Academy of Art University, San Francisco');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Allied American University, Laguna Hills (Online)');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'American Jewish University, Los Angeles');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'American Sports University, San Bernardino');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Anaheim University, Anaheim (Online)');
    INSERT INTO Colleges (state, name) VALUES ('CA', 'Antioch University, Culver City');
    -- etc...
    
  5. Then just copy generated script and use it for your database

其他推荐答案

http://www.data.gov/ has a lot of different datasets but most are not "stock".