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.

Address Attributes

Data Set

Data: Select all
  • 9878 Wishing Blossom Field, Iron Horse, Northwest Territories, X4B-0R4, CA, (867) 331-7079
  • 155 Fallen Forest Gardens, Pronto, Alberta, T1X-4Y7, CA, (780) 017-0644
  • 4448 Heather Pines, Totopitk, Saskatchewan, S4E-4H1, CA, (306) 114-8132
  • 8449 Broad Branch Round, Ticaboo, Newfoundland, A2C-7W8, CA, (709) 150-3419
  • 5857 Iron Pine Acres, Assumption, Saskatchewan, S0S-6F8, CA, (306) 927-1781

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('9878 Wishing Blossom Field', 'Iron Horse', 'Northwest Territories', 'X4B-0R4', 'CA', '(867) 331-7079'),
  • ('155 Fallen Forest Gardens', 'Pronto', 'Alberta', 'T1X-4Y7', 'CA', '(780) 017-0644'),
  • ('4448 Heather Pines', 'Totopitk', 'Saskatchewan', 'S4E-4H1', 'CA', '(306) 114-8132'),
  • ('8449 Broad Branch Round', 'Ticaboo', 'Newfoundland', 'A2C-7W8', 'CA', '(709) 150-3419'),
  • ('5857 Iron Pine Acres', 'Assumption', 'Saskatchewan', 'S0S-6F8', 'CA', '(306) 927-1781');

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