A publicly available large data set that I can use for a lecture

DublinWriter · 04-10-2015 3:12pm #1

I'm currently lecturing part-time in database design.

Does anyone have any good pointers to a downloadable publicly available large data set that I can use for class demo purposes?

It has to be interesting enough to hold the students imagination, especially when demonstrating the delights of SQL.

...and no, don't suggest the Ashley-Madison data.

L.Jenkins · 04-10-2015 3:19pm

http://data.fingal.ie/ViewDataSets/ might be of some use. You could also google open source data in Ireland.

DublinWriter · 04-10-2015 4:11pm

Nice one Itzy.

L.Jenkins · 04-10-2015 9:10pm

Not a bother. What technology do you use to teach the students? Maybe you could give them a crash course in loading the data into a db, then letting them run a few queries against the data.

daymobrew · 05-10-2015 8:53am

I created a small database with the stats from 2014/5 Match Attax cards. I didn't complete the data entry.

then letting them run a few queries against the data.

Although a small database it would be fun to run some queries against it e.g. return all 'midfielders' in 'X' team sorted by 'speed'.

DublinWriter · 05-10-2015 2:29pm

Thanks all - answering my own question here - many US police departments put up their call data online and available to download in CSV format.

beauf · 05-10-2015 3:04pm

It would useful to know good techniques to create large data sets of varied data. For testing in a development environment. Something that never seems to happen any place I've worked. We just use the often imperfect data from somewhere else.

Evil Phil · 09-10-2015 3:30pm

Itzy wrote: »

http://data.fingal.ie/ViewDataSets/ might be of some use. You could also google open source data in Ireland.

You could also try:

<edit>
Oh yeah, and http://www.dublinked.ie (how could I forget!)

kyote00 · 09-10-2015 11:24pm

Also linked data .... (SQL and rDB are so 1980s ;-))

http://lod-cloud.net/

L.Jenkins · 10-10-2015 11:41am

Maybe you could have your students do something similar as an exercise. https://support.discountasp.net/kb/a1179/importing-a-csv-file-into-your-database-with-sql-server-management-studio.aspx

devildriver · 14-10-2015 9:53pm

You could also grab your own data set using:

https://import.io

jmcc · 16-10-2015 1:28pm

beauf wrote: »

It would useful to know good techniques to create large data sets of varied data. For testing in a development environment. Something that never seems to happen any place I've worked. We just use the often imperfect data from somewhere else.

There are climate sets available but they tend to be on the large side.
https://www.ncdc.noaa.gov/cdo-web/datasets

Alternatively use some MD5 or SHA1 hashing with random input data.

Regards...jmcc

A publicly available large data set that I can use for a lecture

Comments