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
  • 4490 Lost Nook, Kailua Kona, Yukon, Y6V-4K1, CA, (867) 927-6034
  • 8872 Dusty Lookout, Tin Shack, Yukon, Y6O-8E2, CA, (867) 751-2617
  • 4313 Crystal Lagoon Valley, Chugwater, Oregon, 97799-9549, US, (503) 066-0385
  • 8406 Amber Harbour, Loveless, Maryland, 21966-8414, US, (443) 079-2039
  • 2558 High Thicket, Oblong, Kentucky, 42587-6099, US, (859) 284-5456

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4490 Lost Nook', 'Kailua Kona', 'Yukon', 'Y6V-4K1', 'CA', '(867) 927-6034'),
  • ('8872 Dusty Lookout', 'Tin Shack', 'Yukon', 'Y6O-8E2', 'CA', '(867) 751-2617'),
  • ('4313 Crystal Lagoon Valley', 'Chugwater', 'Oregon', '97799-9549', 'US', '(503) 066-0385'),
  • ('8406 Amber Harbour', 'Loveless', 'Maryland', '21966-8414', 'US', '(443) 079-2039'),
  • ('2558 High Thicket', 'Oblong', 'Kentucky', '42587-6099', 'US', '(859) 284-5456');

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