User Info Generator

Canadian Address Generator

May 4th, 2016

Generate a list of fake Canadian addresses with the street, city, region, country, postal codes and phone.

Canadian Address Attributes


Data Set

Data: Select all
  • 8297 Iron Bluff Cape, Dot, Louisiana, 70002-4971, US, (504) 844-0601
  • 4289 Heather Autumn Diversion, Ruff, New York, 14184-6543, US, (914) 719-2752
  • 6435 Lost Round, Manhattan, Texas, 78427-8438, US, (281) 135-7994
  • 3247 Rocky Route, Mayday, Arizona, 85286-5733, US, (602) 228-5469
  • 1901 Emerald Via, Stoner, Arizona, 86064-9431, US, (602) 840-9378

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('8297 Iron Bluff Cape', 'Dot', 'Louisiana', '70002-4971', 'US', '(504) 844-0601'),
  • ('4289 Heather Autumn Diversion', 'Ruff', 'New York', '14184-6543', 'US', '(914) 719-2752'),
  • ('6435 Lost Round', 'Manhattan', 'Texas', '78427-8438', 'US', '(281) 135-7994'),
  • ('3247 Rocky Route', 'Mayday', 'Arizona', '85286-5733', 'US', '(602) 228-5469'),
  • ('1901 Emerald Via', 'Stoner', 'Arizona', '86064-9431', 'US', '(602) 840-9378');

SQL Create Table

SQL Create: Select all
  • CREATE TABLE `addresses` (
  •   `id` int(11) NOT NULL AUTO_INCREMENT,
  •   `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