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
  • 6150 Shady Deer Common, Eek, Kansas, 67557-0478, US, (913) 322-8699
  • 7015 Fallen Leaf Ridge, Fallen Leaf, South Carolina, 29979-4926, US, (864) 729-5436
  • 3602 Old Valley, Valley of Enchantment, Kansas, 66664-1232, US, (785) 015-1280
  • 3446 Silent Village, Two Guns, Kansas, 67286-3961, US, (620) 313-5972
  • 3916 Velvet Private, New York, Northwest Territories, X4C-5K6, CA, (867) 776-0313

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('6150 Shady Deer Common', 'Eek', 'Kansas', '67557-0478', 'US', '(913) 322-8699'),
  • ('7015 Fallen Leaf Ridge', 'Fallen Leaf', 'South Carolina', '29979-4926', 'US', '(864) 729-5436'),
  • ('3602 Old Valley', 'Valley of Enchantment', 'Kansas', '66664-1232', 'US', '(785) 015-1280'),
  • ('3446 Silent Village', 'Two Guns', 'Kansas', '67286-3961', 'US', '(620) 313-5972'),
  • ('3916 Velvet Private', 'New York', 'Northwest Territories', 'X4C-5K6', 'CA', '(867) 776-0313');

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