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
  • 4067 Easy Anchor Pike, Goodnews Bay, Massachusetts, 02026-8667, US, (781) 800-2299
  • 6315 High Street, Gas Point, Arkansas, 72817-9046, US, (479) 043-3100
  • 7105 Noble Corners, Roach, Massachusetts, 02301-4355, US, (857) 727-1012
  • 8246 Golden Village, California Bar, California, 91297-5660, US, (619) 912-7825
  • 2009 Wishing Knoll, Chew, Arizona, 86207-6192, US, (520) 122-8989

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4067 Easy Anchor Pike', 'Goodnews Bay', 'Massachusetts', '02026-8667', 'US', '(781) 800-2299'),
  • ('6315 High Street', 'Gas Point', 'Arkansas', '72817-9046', 'US', '(479) 043-3100'),
  • ('7105 Noble Corners', 'Roach', 'Massachusetts', '02301-4355', 'US', '(857) 727-1012'),
  • ('8246 Golden Village', 'California Bar', 'California', '91297-5660', 'US', '(619) 912-7825'),
  • ('2009 Wishing Knoll', 'Chew', 'Arizona', '86207-6192', 'US', '(520) 122-8989');

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