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
  • 7878 Merry Plaza, Captain Cook, Rhode Island, 02902-0748, US, (401) 005-2622
  • 7797 Harvest Robin Beach, Shaktoolik, Ontario, M9A-9M2, CA, (248) 871-3548
  • 3272 Burning Autoroute, Bombay, New Jersey, 08739-2958, US, (848) 139-5752
  • 2652 Little Pathway, Old Corral, Rhode Island, 02857-6176, US, (401) 581-3859
  • 802 Cozy Abbey, Minnehaha, Rhode Island, 02966-0995, US, (401) 006-6653

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('7878 Merry Plaza', 'Captain Cook', 'Rhode Island', '02902-0748', 'US', '(401) 005-2622'),
  • ('7797 Harvest Robin Beach', 'Shaktoolik', 'Ontario', 'M9A-9M2', 'CA', '(248) 871-3548'),
  • ('3272 Burning Autoroute', 'Bombay', 'New Jersey', '08739-2958', 'US', '(848) 139-5752'),
  • ('2652 Little Pathway', 'Old Corral', 'Rhode Island', '02857-6176', 'US', '(401) 581-3859'),
  • ('802 Cozy Abbey', 'Minnehaha', 'Rhode Island', '02966-0995', 'US', '(401) 006-6653');

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