Free, Open License Datasets at

photo-1443745029291-d5c27bc0b562Want a new kind of sample data? Maybe you want to use it to learn, or to do a project with it. Either way, you can blog about to build up your experience, resume, and share it with the community.

Or maybe you’d like to write demos with the sample data for presentations. If you do that, you need a really open license so that you can redistribute the data for people to run the demos themselves later.

One great source is The US Government runs this site and they want to provide “open” data– data with few to no restrictions for use.

Each dataset they host or link to has information about the license (or notes if it’s unclear), so they make it pretty easy to figure out what you can and can’t do. Many of the datasets use the CC Zero license!

The data is interesting stuff, too. Topics include:

  • Customer complaints
  • Airline delays (and why they’re late)
  • Crime statistics
  • Census data and population estimates
  • College ratings and comparisons
  • Weather and environmental data

Just want data with geospatial info? There’s a filter for that. Just want data in certain file types? You can set a filter for that, too. Happy querying!

, ,

4 Responses to Free, Open License Datasets at

  1. Nic Neufeld December 15, 2015 at 12:55 pm #

    Two fun ones that I’ve played around with before:

    Records of all White House visitor requests:

    And FEC records of political donations (over $200):


  1. Importing Open Data Sets in SQL Server - The Database Avenger - March 10, 2016

    […] a decent data set on which to test some of the new visualisations in SSRS 2016. I remembered this post on open data sets by Kendra Little that mentioned There are a lot of different data […]

  2. Teach Yourself SQL Server Performance Tuning (Dear SQL DBA Episode 12) - by Kendra Little - February 21, 2017

    […] are also many free data downloads at, if you want to build your […]

  3. Fits and Starts » Henderson Consulting - June 4, 2017

    […] Kendra Little’s blog post Free, Open License Dataset at for more […]

Leave a Reply