Alexei@Nitobi

UPDATE (June 28, 2007): New release of this dataset is available below with corrections and new datasets.

Over the years I’ve needed data for various purposes when developing web applications. Examples: Regional data for sign-up forms (”Choose your location:”), Dictionaries for spell checkers, relational enterprise data for mockups and samples, etc. So I’ve compiled a fairly large resource that I imagine would be useful – given how hard some of it was to come by.

I know there are data generators out there and other sources for some of this – but when I was looking it was a chore (especially for the regional data) to get it all together the way I needed it. So here it is (download link is at the bottom of the page). Warning: its around 100MB compressed and 550 MB uncompressed so watch out!

Included is full schema information for each database.

For each database there are 4 formats available:

1. CSV
2. MS Access 2000
3. SQL Syntax file
4. XML

The following databases are included:

1. ComputerLanguages – A random list of computer languages in a table. Don’t know why I needed this
2. ContactsFlatfile1k – A table of 1000 realistic but fake people with full contact information, email, phone, address, etc.
3. ContactsFlatfile10k – Same but with 10,000 entries.
4. ContactsFlatfile100k – Same but with 100,000 entries for testing big lookups.
5. CountryRegion – A fairly extensive list of Country and region (be it state/province, etc) flatfile information. Great for signup forms. UPDATED
6. EnglishDictionary – 110,554 words and definitions from the English language. Don’t know where this came from, but you might want to check copyright before using it in anything serious.
7. EnglishWordsLarge – A slightly larger (127,238) database of English words without definitions.
8. EnglishWordsMostPopular – The most popular 1,000 words in the English Language. Great for live spell checkers.
9. GeneralProducts – A table of product information.
10. NorthWindUltra – A much larger and more detailed version of the famous NorthWind database from Microsoft. Note: it contains none of it’s data. This is all new stuff and would be great for app mockups.
11. USCityStates – A detailed list of all major US cities and their states. This version is in a heirarchical parent-child relationship database structure. Over 13,000 entries.
12. USCityStatesFlatfile – A detailed list of all major US cities and their states. This version is in a flat-file single table structure for easy reference. The same 13,000 entries.
    Â
    And Now Including:
    
13. Industries – A list of common industries. Useful for signup forms.
14. CompanyTypesSizes – A list of common company types and sizes. Also useful for signup forms.
15. UKPostalCodes – A list of UK Postal Codes with full longitude, latitude, and district name. Thanks to Tony Hine for this!

Download it here (100 MB): http://blogs.nitobi.com/alexei/dbtestdata_entset2007.zip

| Del.icio.us

This entry was posted on Monday, June 18th, 2007 at 10:07 pm and is filed under web development, resources. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.