User Info Generator

Full Contact Info Generator

December 16th, 2015

Generate a list of fake users with fake addresses, and the choice of real or fake cities, province or state, country, zip code or postal code and phone number. Every user that is created has realistic zip codes/postal codes and phone numbers based on the state or province the user was created under.

The new attributes also let you include location data and calculations. The calculations can be used to determine how close one city is to another.

Full Contact Attributes



Data Set

Data: Select all
  • Mr, Lorimer, Savard, 116 Sleepy Cloud Farm, Yamhill, Prince Edward Island, C7D-4E7, CA, (902) 567-9361
  • Mr, Pierson, Deford, 3846 Umber Hickory Thicket, Coeur d\' Alene, Alabama, 36821-4993, US, (256) 400-4587
  • Ms, Christie, Harden, 1368 High Leaf Isle, Eightmile, California, 91671-5083, US, (805) 869-1461
  • Mr, Solt, Lomax, 3122 Dewy Dale Grove, Umpire, Prince Edward Island, C9J-7Y9, CA, (902) 311-9992
  • Mr, Traherne, Rao, 4184 Silent Anchor Place, Black Gold, Alabama, 36973-0657, US, (251) 229-3165

Insert SQL Set

Query String: Select all
  • INSERT INTO `user_data` (`gender`, `firstname`, `lastname`, `street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('M', 'Lorimer', 'Savard', '116 Sleepy Cloud Farm', 'Yamhill', 'Prince Edward Island', 'C7D-4E7', 'CA', '(902) 567-9361'),
  • ('M', 'Pierson', 'Deford', '3846 Umber Hickory Thicket', 'Coeur d\' Alene', 'Alabama', '36821-4993', 'US', '(256) 400-4587'),
  • ('F', 'Christie', 'Harden', '1368 High Leaf Isle', 'Eightmile', 'California', '91671-5083', 'US', '(805) 869-1461'),
  • ('M', 'Solt', 'Lomax', '3122 Dewy Dale Grove', 'Umpire', 'Prince Edward Island', 'C9J-7Y9', 'CA', '(902) 311-9992'),
  • ('M', 'Traherne', 'Rao', '4184 Silent Anchor Place', 'Black Gold', 'Alabama', '36973-0657', 'US', '(251) 229-3165');

SQL Create Table

SQL Create: Select all
  • CREATE TABLE `user_data` (
  •   `id` int(11) NOT NULL AUTO_INCREMENT,
  •   `gender` varchar(255) NOT NULL,
  •   `firstname` varchar(255) NOT NULL,
  •   `lastname` varchar(255) NOT NULL,
  •   `street` varchar(255) NOT NULL,
  •   `city` varchar(255) NOT NULL,
  •   `region` varchar(255) NOT NULL,
  •   `country` varchar(255) NOT NULL,
  •   `code` varchar(255) NOT NULL,
  •   `phone` varchar(255) NOT NULL,
  •   PRIMARY KEY (`id`)
  • ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Testimonials

"Incredible, usually for testing we have to obfuscate live user data, but with your data I was able to create a 1,000 users in only a few minutes."

Russ McEwan, Denver, CO

"Thanks this is exactly what I was looking for when I needed a lot of users created as test data."

Timothy Hardy, Chicago, IL

"So glad I stumbled on this site. Now I would not be able to do my job without these helpful generators. Thanks."

S. Rosario, Maryland