List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 29 2010 3:12pm
Subject:RE: Good source for sample data?
View as plain text  
If you need "verifiable" mailing addresses (actual street/city/state/zip 
combinations), you should look at some of the databases the USPS (usps.com) 
has available. They are mostly for tracking delivery statistics, and the like, 
but as a side effect they list streets all over the USA. The only thing you 
won't have are street numbers and names, but you can easily generate random 
combinations there.

By the way, if you need real-sounding names you can get a pile of first names 
from http://www.socialsecurity.gov/OACT/babynames/decades/names2000s.html; I 
used that information as part of security screening for a registration system.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com

>-----Original Message-----
>From: Shawn McKenzie [mailto:nospam@stripped]
>Sent: Thursday, January 28, 2010 7:20 PM
>To: Brian Dunning
>Cc: php-general@stripped; mysql@stripped
>Subject: Re: Good source for sample data?
>
>Brian Dunning wrote:
>> Hey all -
>>
>> I need a few million sample contact records - name, company, address, 
>> email,
>web, phone, fax. ZIP codes and area codes and street addresses should be
>correct and properly formatted, but preferably not real people or companies 
>or
>email addresses. But they'd work if you did address validation or mapping.
>Anyone have a suggestion?
>>
>> - Brian
>
>It should be easy to code a routine to generate random data.  Maybe 20 -
>30 lines of code.  Obviously you may have a name like Dgidfgq Xcvbop and
>company Wsdkn, but it shouldn't matter if testing is your purpose.
>
>--
>Thanks!
>-Shawn
>http://www.spidean.com
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>infoshop.com




Thread
Good source for sample data?Brian Dunning29 Jan
  • Re: Good source for sample data?Shawn McKenzie29 Jan
    • RE: Good source for sample data?Jerry Schwartz29 Jan
  • Re: Good source for sample data?John Meyer29 Jan
  • Re: Good source for sample data?Nathan Rixham29 Jan
  • Re: Good source for sample data?Carlos Proal29 Jan
    • Re: Good source for sample data?John Meyer29 Jan
      • Re: Good source for sample data?Mark Goodge29 Jan
        • RE: Good source for sample data?Jerry Schwartz29 Jan
          • Re: Good source for sample data?Mark Goodge29 Jan
            • RE: Good source for sample data?Jerry Schwartz29 Jan
  • Re: Good source for sample data?Martijn Tonies29 Jan
  • Re: Good source for sample data?Martijn Tonies29 Jan
  • Re: [PHP] Good source for sample data?Brian Dunning30 Jan
    • Re: [PHP] Good source for sample data?tedd30 Jan