Canadian Address Generator

Generate a list of fake Canadian addresses with the street, city, region, country, postal codes and phone:

Data Set

• 1150 Bright Parade, Eighty Four, Britsh Columbia, V9Q-6H8, CA, (604) 499-5377
• 1115 Cotton Turnabout, Mattawoman, Yukon, Y5U-2Q5, CA, (867) 337-7740
• 7757 Hidden Shadow Lane, Barnstable, Northwest Territories, X5D-2D7, CA, (867) 440-8239
• 6629 Iron Green, Jump, Nunavut, X0V-3F3, CA, (867) 581-1680
• 5977 Stony Circle, Osawatomie, Britsh Columbia, V4A-7G9, CA, (778) 197-8642

Insert SQL Set

• INSERT INTO `addresses` (`street`, `city`, `region`, `country`, `postal_code`, `phone`) VALUES
• ('1150 Bright Parade', 'Eighty Four', 'Britsh Columbia', 'V9Q-6H8', 'CA', '(604) 499-5377'),
• ('1115 Cotton Turnabout', 'Mattawoman', 'Yukon', 'Y5U-2Q5', 'CA', '(867) 337-7740'),
• ('7757 Hidden Shadow Lane', 'Barnstable', 'Northwest Territories', 'X5D-2D7', 'CA', '(867) 440-8239'),
• ('6629 Iron Green', 'Jump', 'Nunavut', 'X0V-3F3', 'CA', '(867) 581-1680'),
• ('5977 Stony Circle', 'Osawatomie', 'Britsh Columbia', 'V4A-7G9', 'CA', '(778) 197-8642');

SQL Create Table

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,
  `postal_code` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;