RE: Good source for sample data?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx]
>Sent: Thursday, January 28, 2010 7:20 PM
>To: Brian Dunning
>Cc: php-general@xxxxxxxxxxxxx; mysql@xxxxxxxxxxxxxxx
>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=jschwartz@the-
>infoshop.com





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux