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
  • 2842 Quaking Zephyr Avenue, Happy Valley, Louisiana, 70638-8797, US, (225) 075-4876
  • 1587 Hidden Terrace, Atlas, Idaho, 83914-5954, US, (208) 961-8181
  • 3812 Indian Rabbit Loop, Cuba, Yukon, Y8E-0M4, CA, (867) 061-7794
  • 3011 Cozy Freeway, Joshua Tree, Idaho, 83715-8302, US, (208) 436-7086
  • 789 Silver Timber Highway, Walla Walla, Idaho, 83743-0685, US, (208) 065-6113

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('2842 Quaking Zephyr Avenue', 'Happy Valley', 'Louisiana', '70638-8797', 'US', '(225) 075-4876'),
  • ('1587 Hidden Terrace', 'Atlas', 'Idaho', '83914-5954', 'US', '(208) 961-8181'),
  • ('3812 Indian Rabbit Loop', 'Cuba', 'Yukon', 'Y8E-0M4', 'CA', '(867) 061-7794'),
  • ('3011 Cozy Freeway', 'Joshua Tree', 'Idaho', '83715-8302', 'US', '(208) 436-7086'),
  • ('789 Silver Timber Highway', 'Walla Walla', 'Idaho', '83743-0685', 'US', '(208) 065-6113');

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