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
  • 3412 Rocky Treasure Highway, Fink Creek, Alberta, T8P-7Z7, CA, (403) 411-7090
  • 8498 Cozy Terrace, Top of the World, Nova Scotia, B0H-6F2, CA, (902) 927-9702
  • 685 Lazy Isle, Twain Harte, Tennessee, 37351-0353, US, (615) 362-1651
  • 1295 Misty Branch Ledge, Big Sandy, Alberta, T5Z-6O4, CA, (780) 125-1285
  • 3815 Silent Rise, Ottumwa, Nova Scotia, B4G-5C5, CA, (902) 020-3954

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('3412 Rocky Treasure Highway', 'Fink Creek', 'Alberta', 'T8P-7Z7', 'CA', '(403) 411-7090'),
  • ('8498 Cozy Terrace', 'Top of the World', 'Nova Scotia', 'B0H-6F2', 'CA', '(902) 927-9702'),
  • ('685 Lazy Isle', 'Twain Harte', 'Tennessee', '37351-0353', 'US', '(615) 362-1651'),
  • ('1295 Misty Branch Ledge', 'Big Sandy', 'Alberta', 'T5Z-6O4', 'CA', '(780) 125-1285'),
  • ('3815 Silent Rise', 'Ottumwa', 'Nova Scotia', 'B4G-5C5', 'CA', '(902) 020-3954');

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