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
  • 1802 Golden Pathway, Crooked Creek, Delaware, 19998-9614, US, (302) 935-7417
  • 1643 Quaking Elk Lane, Clatskanie, Saskatchewan, S5Z-0Z1, CA, (306) 163-1340
  • 2433 Thunder Barn Front, Onion Creek, Ohio, 44885-9034, US, (614) 894-1817
  • 2945 Emerald Hills Hollow, Niwot, Illinois, 60066-8784, US, (815) 335-8042
  • 108 Cinder Dell, Rifle, Saskatchewan, S0E-5X4, CA, (306) 649-9460

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('1802 Golden Pathway', 'Crooked Creek', 'Delaware', '19998-9614', 'US', '(302) 935-7417'),
  • ('1643 Quaking Elk Lane', 'Clatskanie', 'Saskatchewan', 'S5Z-0Z1', 'CA', '(306) 163-1340'),
  • ('2433 Thunder Barn Front', 'Onion Creek', 'Ohio', '44885-9034', 'US', '(614) 894-1817'),
  • ('2945 Emerald Hills Hollow', 'Niwot', 'Illinois', '60066-8784', 'US', '(815) 335-8042'),
  • ('108 Cinder Dell', 'Rifle', 'Saskatchewan', 'S0E-5X4', 'CA', '(306) 649-9460');

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