North American Address Generator

Generate a list of fake North American addresses with the street, city, region, country, zip/postal codes and phone:

Data Set

• 1327 Misty Robin Mount, Hazlet, Maryland, 21806-7045, US, (443) 026-6098
• 8296 Stony Stead, Nutterville, Vermont, 05151-0452, US, (802) 142-9682
• 3214 High Spring Carrefour, Fresh Kills, Connecticut, 06394-3705, US, (475) 356-1940
• 3701 Golden Rise, Treetops, Texas, 75554-7609, US, (832) 996-3635
• 5636 Rocky View Beach, Friendly Corner, Texas, 75179-0968, US, (432) 727-0235

Insert SQL Set

• INSERT INTO `addresses` (`street`, `city`, `region`, `country`, `code`, `phone`) VALUES
• ('1327 Misty Robin Mount', 'Hazlet', 'Maryland', '21806-7045', 'US', '(443) 026-6098'),
• ('8296 Stony Stead', 'Nutterville', 'Vermont', '05151-0452', 'US', '(802) 142-9682'),
• ('3214 High Spring Carrefour', 'Fresh Kills', 'Connecticut', '06394-3705', 'US', '(475) 356-1940'),
• ('3701 Golden Rise', 'Treetops', 'Texas', '75554-7609', 'US', '(832) 996-3635'),
• ('5636 Rocky View Beach', 'Friendly Corner', 'Texas', '75179-0968', 'US', '(432) 727-0235');

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