Know: Excel data to download 数据下载

https://docs.microsoft.com/en-us/power-bi/sample-financial-download

https://www.kaggle.com/

http://www.principlesofeconometrics.com/excel.htm

Every great data visualization starts with good and clean data. Most people believe that collecting big data would be a rough thing, but it’s simply not true. There are thousands of free data sets available online, ready to be analyzed and visualized by anyone. Here we’ve rounded up 70 free data sources for 2017 on government, crime, health, financial and economic data, marketing and social media, journalism, and media, real estate, company directory and review, and more.

Government

1. Data.gov: It is the first stage and acts as a portal to all sorts of amazing information on everything from climate to crime freely by the US Government.
2. Data.gov.uk: There are datasets from all UK central departments and a number of other public sector and local authorities. It acts as a portal to all sorts of information on everything, including business and economy, crime and justice, defense, education, environment, government, health, society, and transportation.
3. U.S. Census Bureau: The website is about the government-informed statistics on the lives of US citizens including population, economy, education, geography, and more.
4. The CIA World Factbook: Facts on every country in the world; focuses on history, government, population, economy, energy, geography, communications, transportation, military, and transnational issues of 267 countries.
5. Socrata: Socrata is a mission-driven software company that is another interesting place to explore government-related data with some visualization tools built-in. Its data as a service has been adopted by more than 1200 government agencies for open data, performance management, and data-driven government.
6. European Union Open Data Portal: It is the single point of access to a growing range of data from the institutions and other bodies of the European Union. The data boosts includes economic development within the EU and transparency within the EU institutions, including geographic, geopolitical and financial data, statistics, election results, legal acts, and data on crime, health, the environment, transport and scientific research. They could be reused in different databases and reports. And more, a variety of digital formats are available from the EU institutions and other EU bodies. The portal provides a standardized catalog, a list of apps and web tools reusing these data, a SPARQL endpoint query editor and rest API access, and tips on how to make the best use of the site.
7. Canada Open Data is a pilot project with many government and geospatial datasets. It could help you explore how the Government of Canada creates greater transparency, accountability, increases citizen engagement, and drives innovation and economic opportunities through open data, open information, and open dialogue.
8. Datacatalogs.org: It offers open government data from US, EU, Canada, CKAN, and more.
9. U.S. National Center for Education Statistics: The National Center for Education Statistics (NCES) is the primary federal entity for collecting and analyzing data related to education in the U.S. and other nations.
10. UK Data Service: The UK Data Service collection includes major UK government-sponsored surveys, cross-national surveys, longitudinal studies, UK census data, international aggregate, business data, and qualitative data.

Crime

11. Uniform Crime Reporting: The UCR Program has been the starting place for law enforcement executives, students, researchers, members of the media, and the public seeking information on crime in the US.
12. FBI Crime Statistics: Statistical crime reports and publications detailing specific offenses and outlining trends to understand crime threats at both local and national levels.
13. Bureau of Justice Statistics: Information on anything related to U.S. justice system, including arrest-related deaths, census of jail inmates, a national survey of DNA crime labs, surveys of law enforcement gang units, etc.
14. National Sex Offender Search: It is an unprecedented public safety resource that provides the public with access to sex offender data nationwide. It presents the most up-to-date information as provided by each Jurisdiction.

Health

15. U.S. Food & Drug Administration: Here you will find a compressed data file of the Drugs@FDA database. Drugs@FDA is updated daily, this data file is updated once per week, on Tuesday.
16. UNICEF: UNICEF gathers evidence on the situation of children and women around the world. The data sets include accurate, nationally representative data from household surveys and other sources.
17. World Health Organisation: statistics concerning nutrition, disease, and health in more than 150 countries.
18. Healthdata.gov: 125 years of US healthcare data including claim-level Medicare data, epidemiology and population statistics.
19. NHS Health and Social Care Information Centre: Health data sets from the UK National Health Service. The organization produces more than 260 official and national statistical publications. This includes national comparative data for secondary uses, developed from the long-running Hospital Episode Statistics which can help local decision-makers to improve the quality and efficiency of frontline care.

Financial and Economic Data

20. World Bank Open Data: Education statistics about everything from finances to service delivery indicators around the world.
21. IMF Economic Data: An incredibly useful source of information that includes global financial stability reports, regional economic reports, international financial statistics, exchange rates, directions of trade, and more.
22. UN Comtrade Database: Free access to detailed global trade data with visualizations. UN Comtrade is a repository of official international trade statistics and relevant analytical tables. All data is accessible through API.
23. Global Financial Data: With data on over 60,000 companies covering 300 years, Global Financial Data offers a unique source to analyze the twists and turns of the global economy.
24. Google Finance: Real-time stock quotes and charts, financial news, currency conversions, or tracked portfolios.
25. Google Public Data Explorer: Google’s Public Data Explorer provides public data and forecasts from a range of international organizations and academic institutions including the World Bank, OECD, Eurostat and the University of Denver. These can be displayed as line graphs, bar graphs, cross-sectional plots or on maps.
26. U.S. Bureau of Economic Analysis: U.S. official macroeconomic and industry statistics, most notably reports about the gross domestic product (GDP) of the United States and its various units. They also provide information about personal income, corporate profits, and government spending in their National Income and Product Accounts (NIPAs).
27. Financial Data Finder at OSU: Plentiful links to anything related to finance, no matter how obscure, including World Development Indicators Online, World Bank Open Data, Global Financial Data, International Monetary Fund Statistical Databases, and EMIS Intelligence.
28. National Bureau of Economic Research: Macro data, industry data, productivity data, trade data, international finance, data, and more.
29. U.S. Securities and Exchange Commission: Quarterly datasets of extracted information from exhibits to corporate financial reports filed with the Commission.
30. Visualizing Economics: Data visualizations of the economy.
31. Financial Times: The Financial Times provides a broad range of information, news, and services for the global business community.

Marketing and Social Media

32. Amazon API: Browse Amazon Web Services’ Public Data Sets by category for a huge wealth of information. Amazon API Gateway allows developers to securely connect mobile and web applications to APIs that run on Amazon Web(AWS) Lambda, Amazon EC2, or other publicly addressable web services that are hosted outside of AWS.
33. American Society of Travel Agents: ASTA is the world’s largest association of travel professionals. It provides members information including travel agents and the companies whose products they sell such as tours, cruises, hotels, car rentals, etc.
34. Social Mention: Social Mention is a social media search and analysis platform that aggregates user-generated content from across the universe into a single stream of information.
35. Google Trends: Google Trends shows how often a particular search-term is entered relative to the total search-volume across various regions of the world in various languages.
36. Facebook API: Learn how to publish to and retrieve data from Facebook using the Graph API.
37. Twitter API: The Twitter Platform connects your website or application with the worldwide conversation happening on Twitter.
38. Instagram API: The Instagram API Platform can be used to build non-automated, authentic, high-quality apps and services.
39. Foursquare API: The Foursquare API gives you access to our world-class places database and the ability to interact with Foursquare users and merchants.
40. HubSpot: A large repository of marketing data. You could find the latest marketing stats and trends here. It also provides tools for social media marketing, content management, web analytics, landing pages and search engine optimization.
41. Moz: Insights on SEO that includes keyword research, link building, site audits, and page optimization insights in order to help companies to have a better view of the position they have on search engines and how to improve their ranking.
42. Content Marketing Institute: The latest news, studies, and research on content marketing.

Journalism and Media

43. The New York Times Developer Network – Search Times articles from 1851 to today, retrieving headlines, abstracts and links to associated multimedia. You can also search book reviews, NYC event listings, movie reviews, top stories with images and more.
44. Associated Press API: The AP Content API allows you to search and download content using your own editorial tools, without having to visit AP portals. It provides access to images from AP-owned, member-owned and third-party, and videos produced by AP and selected third-party.
45. Google Books Ngram Viewer: It is an online search engine that charts frequencies of any set of comma-delimited search strings using a yearly count of n-grams found in sources printed between 1500 and 2008 in Google’s text corpora.
46. Wikipedia Database: Wikipedia offers free copies of all available content to interested users.
47. FiveThirtyEight: It is a website that focuses on opinion poll analysis, politics, economics, and sports blogging. The data and code on Github are behind the stories and interactives at FiveThirtyEight.
48. Google Scholar: Google Scholar is a freely accessible web search engine that indexes the full text or metadata of scholarly literature across an array of publishing formats and disciplines. It includes most peer-reviewed online academic journals and books, conference papers, theses and dissertations, preprints, abstracts, technical reports, and other scholarly literature, including court opinions and patents.

Real Estate

49. Castles: Castles are a successful, privately owned independent agency. Established in 1981, they offer a comprehensive service incorporating residential sales, letting and management, and surveys and valuations.
50. Realestate.com: RealEstate.com serves as the ultimate resource for first-time home buyers, offering easy-to-understand tools and expert advice at every stage in the process.
51. Gumtree: Gumtree is the first site for free classifieds ads in the UK. Buy and sell items, cars, properties, and find or offer jobs in your area is all available on the website.
52. James Hayward: It provides an innovative database approach to residential sales, lettings & management.
53. Lifull Home’s: Japan’s property website.
54. Immobiliare.it: Italy’s property website.
55. Subito: Italy’s property website.
56. Immoweb: Belgium’s leading property website.

Business Directory and Review

57. LinkedIn: LinkedIn is a business- and employment-oriented social networking service that operates via websites and mobile apps. It has 500 million members in 200 countries and you could find the business directory here.
58. OpenCorporates: OpenCorporates is the largest open database of companies and company data in the world, with in excess of 100 million companies in a similarly large number of jurisdictions. Our primary goal is to make information on companies more usable and more widely available for the public benefit, particularly to tackle the use of companies for criminal or anti-social purposes, for example, corruption, money laundering and organized crime.
59. Yellowpages: The original source to find and connect with local plumbers, handymen, mechanics, attorneys, dentists, and more.
60. Craigslist: Craigslist is an American classified advertisements website with sections devoted to jobs, housing, personals, for sale, items wanted, services, community, gigs, résumés, and discussion forums.
61. GAF Master Elite Contractor : Founded in 1886, GAF has become North America’s largest manufacturer of commercial and residential roofing (Source: Fredonia Group study). Our success in growing the company to nearly $3 billion in sales has been a result of our relentless pursuit of quality, combined with industry-leading expertise and comprehensive roofing solutions. Jim Schnepper is the President of GAF, an operating subsidiary of Standard Industries. When you are looking to protect the things you treasure most, here are just some of the reasons why we believe you should choose GAF.
62. CertainTeed: You could find contractors, remodelers, installers or builders in the US or Canada on your residential or commercial project here.
63. Companies in California: All information about companies in California.
64. Manta: Manta is one of the largest online resources that deliver products, services, and educational opportunities. The Manta directory boasts millions of unique visitors every month who search the comprehensive database for individual businesses, industry segments, and geographic-specific listings.
65. EU-Startups: Directory about startups in EU.
66. Kansas Bar Association: Directory for lawyers. The Kansas Bar Association (KBA) was founded in 1882 as a voluntary association of dedicated legal professionals and has more than 7,000 members, including lawyers, judges, law students, and paralegals.

Other websites

67. Capterra: Directory of business software and reviews.
68. Monster: Data source for jobs and career opportunities.
69. Glassdoor: Directory of jobs and information about inside scoop on companies with employee reviews, personalized salary tools, and more.
70. The Good Garage Scheme: Directory about car service, MOT or car repair.
71. OSMOZ: Information about fragrance.
72. Octoparse: A free data extraction tool to collect all the web data mentioned above online.