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
  • 4130 Golden Leaf Edge, Bummerville, Arkansas, 72718-2087, US, (479) 054-6712
  • 3405 Jagged Mountain Via, Virgin, Nova Scotia, B3F-8A8, CA, (902) 427-1024
  • 6307 Sleepy Robin Village, Institute, Indiana, 47830-0472, US, (219) 306-5424
  • 3716 Thunder Pointe, Ficklin, Nova Scotia, B5D-2I8, CA, (902) 043-3134
  • 1790 Green Pioneer Gardens, New Rome, Oklahoma, 74168-2369, US, (580) 671-4409

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4130 Golden Leaf Edge', 'Bummerville', 'Arkansas', '72718-2087', 'US', '(479) 054-6712'),
  • ('3405 Jagged Mountain Via', 'Virgin', 'Nova Scotia', 'B3F-8A8', 'CA', '(902) 427-1024'),
  • ('6307 Sleepy Robin Village', 'Institute', 'Indiana', '47830-0472', 'US', '(219) 306-5424'),
  • ('3716 Thunder Pointe', 'Ficklin', 'Nova Scotia', 'B5D-2I8', 'CA', '(902) 043-3134'),
  • ('1790 Green Pioneer Gardens', 'New Rome', 'Oklahoma', '74168-2369', 'US', '(580) 671-4409');

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