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
  • 4036 Broad River Vista, Atlas, New Hampshire, 03313-2215, US, (603) 337-9774
  • 2685 Hazy Pony Isle, Skidoo, Arkansas, 72846-6892, US, (870) 080-0882
  • 31 Crystal Anchor Diversion, Red Top, Prince Edward Island, C1E-1Q0, CA, (902) 809-5366
  • 7152 Old Stead, Freeland, Kentucky, 41148-1981, US, (270) 088-1560
  • 112 Little Deer Park, Skull Creek, Kentucky, 40148-3985, US, (606) 620-8772

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4036 Broad River Vista', 'Atlas', 'New Hampshire', '03313-2215', 'US', '(603) 337-9774'),
  • ('2685 Hazy Pony Isle', 'Skidoo', 'Arkansas', '72846-6892', 'US', '(870) 080-0882'),
  • ('31 Crystal Anchor Diversion', 'Red Top', 'Prince Edward Island', 'C1E-1Q0', 'CA', '(902) 809-5366'),
  • ('7152 Old Stead', 'Freeland', 'Kentucky', '41148-1981', 'US', '(270) 088-1560'),
  • ('112 Little Deer Park', 'Skull Creek', 'Kentucky', '40148-3985', 'US', '(606) 620-8772');

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