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
  • 3168 Cotton Run, Doghouse Junction, South Dakota, 57509-6396, US, (605) 595-2716
  • 1306 Heather Expressway, Otay, Delaware, 19897-2583, US, (302) 836-0989
  • 9033 Hidden Lake Concession, Thirtynine, South Dakota, 57298-4720, US, (605) 601-8156
  • 4335 Hazy Goose Cape, Credit, Mississippi, 39127-5764, US, (601) 654-9760
  • 6077 Indian Promenade, Bruly McCall, Prince Edward Island, C1V-8E5, CA, (902) 045-7538

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('3168 Cotton Run', 'Doghouse Junction', 'South Dakota', '57509-6396', 'US', '(605) 595-2716'),
  • ('1306 Heather Expressway', 'Otay', 'Delaware', '19897-2583', 'US', '(302) 836-0989'),
  • ('9033 Hidden Lake Concession', 'Thirtynine', 'South Dakota', '57298-4720', 'US', '(605) 601-8156'),
  • ('4335 Hazy Goose Cape', 'Credit', 'Mississippi', '39127-5764', 'US', '(601) 654-9760'),
  • ('6077 Indian Promenade', 'Bruly McCall', 'Prince Edward Island', 'C1V-8E5', 'CA', '(902) 045-7538');

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