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
  • 4582 Merry Bear Harbour, Crooked Creek, New Brunswick, E9J-8S0, CA, (506) 646-7310
  • 3725 Grand Freeway, Battle Ground, New Brunswick, E4L-6T9, CA, (506) 981-4832
  • 2527 Round Ledge, Humble City, Yukon, Y1J-0F3, CA, (867) 229-5149
  • 832 Misty Lagoon Hill, Big Sandy, Yukon, Y2K-8X9, CA, (867) 923-9533
  • 7080 Shady Pond Farms, Fender, New Brunswick, E1B-7Z9, CA, (506) 145-1413

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4582 Merry Bear Harbour', 'Crooked Creek', 'New Brunswick', 'E9J-8S0', 'CA', '(506) 646-7310'),
  • ('3725 Grand Freeway', 'Battle Ground', 'New Brunswick', 'E4L-6T9', 'CA', '(506) 981-4832'),
  • ('2527 Round Ledge', 'Humble City', 'Yukon', 'Y1J-0F3', 'CA', '(867) 229-5149'),
  • ('832 Misty Lagoon Hill', 'Big Sandy', 'Yukon', 'Y2K-8X9', 'CA', '(867) 923-9533'),
  • ('7080 Shady Pond Farms', 'Fender', 'New Brunswick', 'E1B-7Z9', 'CA', '(506) 145-1413');

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