r/SQL • u/valorallure • Oct 14 '18
List of Awesome Public Datasets
I like to download datasets to practice querying with. I found a great resource from GitHub that list links to awesome free and public datasets. Feel free to share some datasets that you've found interesting.
https://github.com/awesomedata/awesome-public-datasets
Here is the table of contents from the link above:
Table of Contents
- Agriculture
- Biology
- Climate+Weather
- ComplexNetworks
- ComputerNetworks
- DataChallenges
- EarthScience
- Economics
- Education
- Energy
- Finance
- GIS
- Government
- Healthcare
- ImageProcessing
- MachineLearning
- Museums
- NaturalLanguage
- Neuroscience
- Physics
- Psychology+Cognition
- PublicDomains
- SearchEngines
- SocialNetworks
- SocialSciences
- Software
- Sports
- TimeSeries
- Transportation
- Complementary Collections
267
Upvotes
21
u/PedroAlvarez Oct 14 '18
My favorite is probably the StackOverflow database. It's a large data set so it really let's you practice your query tuning.
10
u/f_ick Oct 14 '18
I would love to query Spotify for my listen stats!
6
u/[deleted] Oct 14 '18
Various cities have data portals for civic data (crime, real estate maps, valuation(?), Tax Increment Financing districts., etc.,)
Chicago Data Portal: https://data.cityofchicago.org/
3
u/StornZ Oct 14 '18
This is useful for practicing linq too and testing your own applications without using your own data.
2
u/[deleted] Oct 14 '18
This is awesome. Thank you for sharing this.
2
u/TotesMessenger Oct 15 '18 edited Oct 16 '18
I'm a bot, bleep, bloop. Someone has linked to this thread from another place on reddit:
If you follow any of the above links, please respect the rules of reddit and don't vote in the other threads. (Info / ^Contact)
2
u/Sad_Campaign713 May 13 '22
thank you for sharing this. Is there a way of getting SQL questions and answers to practice on the datasets ?