views:

757

answers:

6

How can I find or generate thousands of company names for testing and demo purposes? (Address, phone number, and related information would be nice too.)

I've got a system I'm building which includes business contact information. Pretty common no doubt.

My test/demo database currently has randomly generated individual's names loaded (thanks to a handy IRS spreadsheet I found). This has worked great for internal testing and review purposes, but it looks really odd when shown to prospective customers.

I've tried various online public information sources (e.g. EDGAR, and county based property records searches), but these all require me to manually stitch together the results in blocks of 50 names or so at a time. I could do this, but was really hoping for a search service or data store out there that had this type of information readily searchable and retrievable in very large batches.

+12  A: 

I use Fake Name generator (http://www.fakenamegenerator.com/).

warren
Wow, that's an incredibly awesome service. Thanks for the link. Only problem for this particular purpose is that it's individual names.
schefdev
Can this be used to make a big ol' list, or just one at a time? I reckon some enterprising automater would figure out a way to use WatiN or some such thing to extract a bunch of names robotically. Let me know how that works for you.
MrBoJangles
true - but i think they'll do custom work for free/cheap
warren
They [offer](http://www.fakenamegenerator.com/order.php) on that site to generate 1 million records in the format of your choice for $25. That's cheap for a ton of data.
schefdev
Very cool. By the way, you can get all the free names you want for free, but only 120,000 at a time (40,000 per free request max * 3 requests in the queue max).
raven
Love that page, really cool, thanks for sharing!!!
Mecki
Snap, that's way cheaper than trying to 'robot' the info. I'm going to send that URL to my dev peeps.
MrBoJangles
+4  A: 

You could scrape a public source like Wikipedia for names, or you could just grab random (non-offensive, of course) nouns from your dictionary of choice (/usr/share/dict/words, etc.) and append "Company", "Corporation", "LTD" at random.

Rob Hruska
that's a rather clever idea (the `/usr/share/dict/words` thing) ... I've used that for crossword puzzle solving, but hadn't thought of it for company names
warren
+2  A: 

I personally STRONGLY recommend against using ACTUAL data of any form for testing/demoing an application.

I have had to go in too many times and pick up the pieces when real e-mail addresses were used and emails accidentally went out to all kinds of customers.

I would use something like the tools from RedGate to add data, make it dummy data, real data is too risky, at least in my opinion.

Mitchel Sellers
Agreed. I'm not going to be using the email addresses for these purposes and can see where that could bite you. I was interested to see that the FakeNameGenerator.com guys also include an email address that points back to them for testing purposes.
schefdev
+1  A: 

If you are simply looking to generate names, I would use one of the two above options. If you are looking for more complex data, Redgate makes a SQL data generator. I have never used this program, I simply know of its existence.

NYSystemsAnalyst
+2  A: 

I would suggest having a "random character" generator that strings together "company name" "companytype" and so forth. This will minimize the chance of actually displaying a real company's name.

Also, check out the Ipsum Lorum generators; they might have some tips.

Paul Nathan
+2  A: 

A pretty good generator is: generatedata.

It's very customizable: you can generate names, streets, telephone numbers, a random entry from a specified list.

You can export the generated data in different formats like: SQL, HTML, Excel, XML and CSV.

Igor Popov