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
  • 3265 Sunny Wynd, Happy Valley, Florida, 34566-6232, US, (786) 750-7214
  • 4270 Dusty Prairie Byway, Card Place, Britsh Columbia, V9B-7O6, CA, (604) 324-5975
  • 4457 Stony Rabbit Gardens, Hazard, Saskatchewan, S0G-9N9, CA, (306) 364-2096
  • 5432 Colonial Timber Crest, Skamokawa, Saskatchewan, S5D-4L1, CA, (306) 400-2231
  • 2260 Grand Thicket, White Swan, Britsh Columbia, V0Q-7M4, CA, (778) 875-2028

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('3265 Sunny Wynd', 'Happy Valley', 'Florida', '34566-6232', 'US', '(786) 750-7214'),
  • ('4270 Dusty Prairie Byway', 'Card Place', 'Britsh Columbia', 'V9B-7O6', 'CA', '(604) 324-5975'),
  • ('4457 Stony Rabbit Gardens', 'Hazard', 'Saskatchewan', 'S0G-9N9', 'CA', '(306) 364-2096'),
  • ('5432 Colonial Timber Crest', 'Skamokawa', 'Saskatchewan', 'S5D-4L1', 'CA', '(306) 400-2231'),
  • ('2260 Grand Thicket', 'White Swan', 'Britsh Columbia', 'V0Q-7M4', 'CA', '(778) 875-2028');

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