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
  • 3734 Thunder Prairie Line, Tie Siding, Mississippi, 38794-2327, US, (601) 406-7722
  • 5265 Burning Hill, Blackankle, Kentucky, 42506-5846, US, (606) 491-7156
  • 8586 Fallen Pond Diversion, Lone Sasafras, Arkansas, 72996-3583, US, (501) 230-5976
  • 723 Dewy Spring Glade, Umpire, Mississippi, 38766-7186, US, (228) 433-0933
  • 5716 Cotton Wynd, Flat Lick, Mississippi, 39259-2489, US, (601) 970-1913

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('3734 Thunder Prairie Line', 'Tie Siding', 'Mississippi', '38794-2327', 'US', '(601) 406-7722'),
  • ('5265 Burning Hill', 'Blackankle', 'Kentucky', '42506-5846', 'US', '(606) 491-7156'),
  • ('8586 Fallen Pond Diversion', 'Lone Sasafras', 'Arkansas', '72996-3583', 'US', '(501) 230-5976'),
  • ('723 Dewy Spring Glade', 'Umpire', 'Mississippi', '38766-7186', 'US', '(228) 433-0933'),
  • ('5716 Cotton Wynd', 'Flat Lick', 'Mississippi', '39259-2489', 'US', '(601) 970-1913');

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