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
  • 8459 Harvest Fox Link, Convict Lake, Arkansas, 72616-9952, US, (501) 327-0232
  • 3521 Lazy Island Island, Squabbletown, Mississippi, 38655-5197, US, (228) 261-7814
  • 8793 Lost Cloud Quay, Sweet Home, Arkansas, 71735-2291, US, (870) 582-2630
  • 535 Red Ridge, Dungeness, Northwest Territories, X6H-3W9, CA, (867) 821-0396
  • 3837 Emerald Elk Dale, Happy Jack, Arkansas, 72732-7840, US, (501) 486-4496

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('8459 Harvest Fox Link', 'Convict Lake', 'Arkansas', '72616-9952', 'US', '(501) 327-0232'),
  • ('3521 Lazy Island Island', 'Squabbletown', 'Mississippi', '38655-5197', 'US', '(228) 261-7814'),
  • ('8793 Lost Cloud Quay', 'Sweet Home', 'Arkansas', '71735-2291', 'US', '(870) 582-2630'),
  • ('535 Red Ridge', 'Dungeness', 'Northwest Territories', 'X6H-3W9', 'CA', '(867) 821-0396'),
  • ('3837 Emerald Elk Dale', 'Happy Jack', 'Arkansas', '72732-7840', 'US', '(501) 486-4496');

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