Free data sources from

Sometimes its hard to find good data source when You make some side projects especially when You want to use survey data. I found an interesting site called There are more than thousand database freely available after registration.

It has a cool feature: you can export the data directly to R, so You do not need to download it to Your local drive.

However sometimes it is tricky to use this function because the file format is not always .csv as it assumes, but of course You can use the link of the data source in this case.

Here is a minimal example how You can use it:

# set working directory where You want to download the database
# setwd("C:/Users/yourName/Desktop")
download.file("", "database.xlsx", mode="wb")
# load the data with the openxlsx package
db = read.xlsx("database.xlsx", startRow = 1, colNames = TRUE)
# aggregate the data to a County level
db = aggregate(db[,"POP2010"], by=list(db[,"STNAME"]), FUN=sum, na.rm = TRUE)
# plot it with googleVis package
GeoStates <- gvisGeoChart(db, "Group.1", "x",
                                       width=600, height=400))

3 Replies to “Free data sources from”

  1. Ian Greenleigh

    Thanks for sharing with your readers! We’re so glad you’re enjoying the platform. Please don’t hesitate to reach out to us with any feedback or questions as your journey unfolds!

    -Ian and the team

  2. tarkomatas

    Thanks for Your reply. It would be useful if the system would recognise the file format and would offer the suitable most function.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.