Data sets for realistic random/test data generation

Question

Where to get data sets for random or test data generation, such as names/surnames with distribution, address data, university/school names, company names etc.?

I've found the list of English names and surnames, with the count of them (unfortunately I haven't noted from where I got that). I got address database from Poland. However these data sets from other countries would also be very useful for me. So with university and school names.

What data do you need as source for such information? Could you provide links to such data? (of course, only those who are free publicly available)

I'm flagging this question because it is off-topic for Stack Overflow. Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it. — AStopher, Apr 25 '15 at 21:39

score 4 · Answer 1 · answered Feb 07 '11 at 22:30

4

There are many open source and commericial test data generators on internet. Below 2 are good ones

http://www.sqledit.com/dg/
http://www.generatedata.com/#about
for random numbers/strings: http://www.random.org/

answered Feb 07 '11 at 22:30

Aravind Yarram

78,777
46
231
327

The second link is quite good, it contains some data I need but I still would like to have broader data sets. First is commercial and second is full random only. – Danubian Sailor Feb 17 '11 at 07:50

score 4 · Accepted Answer · edited May 23 '17 at 12:00

4

I think you will find answer to your question in following topics:

Sample database for exercise

https://stackoverflow.com/questions/202092/where-can-i-find-free-and-open-data

edited May 23 '17 at 12:00

Community

1
1

answered Feb 25 '11 at 07:38

стривігор

126
4

score 2 · Answer 3 · answered Mar 28 '13 at 23:18

2

Try http://www.mockaroo.com

You can generate up to 100,000 rows of data in CSV, tab-delimited and SQL formats, save & reuse schemas, and automate test data generation using curl.

answered Mar 28 '13 at 23:18

mockaroodev

2,031
1
20
24

score 2 · Answer 4 · answered Feb 07 '11 at 22:30

2

Amazon has made several public data sets available for free download: http://aws.amazon.com/publicdatasets/

answered Feb 07 '11 at 22:30

Girish Rao

2,609
1
20
24

I was trying, but couldn't find the download link on that page – Danubian Sailor Feb 17 '11 at 07:43

score 1 · Answer 5 · answered Feb 20 '14 at 21:38

There is a free API at http://randomprofile.com/api-for-developers/ for generating test user profiles which include name, surname, address, bank info, CC number, blood type etc. Not sure about the schools, but useful if you're looking after data on Asian users.

Data sets for realistic random/test data generation

5 Answers5