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
  • 7821 Sunny Pathway, Lawyers Bar, Florida, 34771-3873, US, (239) 304-4583
  • 184 Sleepy Beacon Terrace, Riddle, Kentucky, 40175-0459, US, (606) 967-8664
  • 6556 Shady Acres, Santa, Idaho, 83212-0870, US, (208) 409-7346
  • 59 Umber Quay, Hungry Horse, Northwest Territories, X3E-8Q2, CA, (867) 894-5256
  • 7697 Burning Jetty, Philadelphia, Northwest Territories, X8U-7F4, CA, (867) 698-2641

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('7821 Sunny Pathway', 'Lawyers Bar', 'Florida', '34771-3873', 'US', '(239) 304-4583'),
  • ('184 Sleepy Beacon Terrace', 'Riddle', 'Kentucky', '40175-0459', 'US', '(606) 967-8664'),
  • ('6556 Shady Acres', 'Santa', 'Idaho', '83212-0870', 'US', '(208) 409-7346'),
  • ('59 Umber Quay', 'Hungry Horse', 'Northwest Territories', 'X3E-8Q2', 'CA', '(867) 894-5256'),
  • ('7697 Burning Jetty', 'Philadelphia', 'Northwest Territories', 'X8U-7F4', 'CA', '(867) 698-2641');

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