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
  • 4004 Honey Dell, New Knockhock, Oklahoma, 74080-0714, US, (405) 746-8108
  • 5556 Lazy Private, Yellowjacket, Oklahoma, 73895-8083, US, (918) 832-3800
  • 9868 Blue Anchor Villas, Vopolo Havoka, Northwest Territories, X6H-0G4, CA, (867) 237-2480
  • 9434 Old Wharf, Moose Town, Oklahoma, 74902-7224, US, (539) 506-2451
  • 8754 Round Oak Grove, Plentywood, Nebraska, 68738-7392, US, (308) 578-9160

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4004 Honey Dell', 'New Knockhock', 'Oklahoma', '74080-0714', 'US', '(405) 746-8108'),
  • ('5556 Lazy Private', 'Yellowjacket', 'Oklahoma', '73895-8083', 'US', '(918) 832-3800'),
  • ('9868 Blue Anchor Villas', 'Vopolo Havoka', 'Northwest Territories', 'X6H-0G4', 'CA', '(867) 237-2480'),
  • ('9434 Old Wharf', 'Moose Town', 'Oklahoma', '74902-7224', 'US', '(539) 506-2451'),
  • ('8754 Round Oak Grove', 'Plentywood', 'Nebraska', '68738-7392', 'US', '(308) 578-9160');

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