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
  • 4753 Wishing Bear Mall , Fair Play, Kentucky, 40119-3435, US, (859) 051-3566
  • 7563 Dusty Place, Skidoo, Rhode Island, 02987-8063, US, (401) 023-1010
  • 8490 Crystal Anchor Plaza, Jackpot, Nebraska, 69119-5260, US, (402) 940-2750
  • 4677 Golden Gate Falls, Constellation, New Mexico, 87891-4819, US, (575) 654-7791
  • 5890 Tawny Willow Alley, Tat Momoli, Rhode Island, 02922-7599, US, (401) 377-8881

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('4753 Wishing Bear Mall ', 'Fair Play', 'Kentucky', '40119-3435', 'US', '(859) 051-3566'),
  • ('7563 Dusty Place', 'Skidoo', 'Rhode Island', '02987-8063', 'US', '(401) 023-1010'),
  • ('8490 Crystal Anchor Plaza', 'Jackpot', 'Nebraska', '69119-5260', 'US', '(402) 940-2750'),
  • ('4677 Golden Gate Falls', 'Constellation', 'New Mexico', '87891-4819', 'US', '(575) 654-7791'),
  • ('5890 Tawny Willow Alley', 'Tat Momoli', 'Rhode Island', '02922-7599', 'US', '(401) 377-8881');

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