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
  • 9383 Quaking Townline, Mililani, California, 94959-5746, US, (661) 243-0145
  • 9976 Old Lake Grounds, Ono, Louisiana, 70351-3229, US, (504) 120-2561
  • 2885 Red Hickory Lane, Pronto, Louisiana, 71366-7382, US, (504) 521-0372
  • 8231 Broad Jetty, Kinikinik, California, 95777-0448, US, (831) 593-0771
  • 3390 Rocky By-pass, Manhattan, Georgia, 39884-6119, US, (706) 390-0895

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `code`, `country`, `phone` ) VALUES
  • ('9383 Quaking Townline', 'Mililani', 'California', '94959-5746', 'US', '(661) 243-0145'),
  • ('9976 Old Lake Grounds', 'Ono', 'Louisiana', '70351-3229', 'US', '(504) 120-2561'),
  • ('2885 Red Hickory Lane', 'Pronto', 'Louisiana', '71366-7382', 'US', '(504) 521-0372'),
  • ('8231 Broad Jetty', 'Kinikinik', 'California', '95777-0448', 'US', '(831) 593-0771'),
  • ('3390 Rocky By-pass', 'Manhattan', 'Georgia', '39884-6119', 'US', '(706) 390-0895');

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