United States Address Generator

December 25th, 2013

Generate a list of fake U.S. addresses with the street, city, region, country, zip codes and phone:

Address Attributes

Data Set

Data: Select all
  • 2769 Hazy Rise, Beaver, Delaware, 19994-9604, US, (302) 674-1613
  • 3714 Green Embers Plaza, Chignik, New Mexico, 88403-3655, US, (575) 500-5082
  • 2059 Clear Green, Chugiak, New Mexico, 87040-4122, US, (575) 619-6465
  • 580 Emerald Farm, Hershey, Arizona, 85169-8373, US, (602) 882-2095
  • 925 Noble Quail Bay, Umatilla, Arizona, 85357-1314, US, (480) 604-6625

Insert SQL Set

Query String: Select all
  • INSERT INTO `addresses` (`street`, `city`, `region`, `country`, `code`, `phone`) VALUES
  • ('2769 Hazy Rise', 'Beaver', 'Delaware', '19994-9604', 'US', '(302) 674-1613'),
  • ('3714 Green Embers Plaza', 'Chignik', 'New Mexico', '88403-3655', 'US', '(575) 500-5082'),
  • ('2059 Clear Green', 'Chugiak', 'New Mexico', '87040-4122', 'US', '(575) 619-6465'),
  • ('580 Emerald Farm', 'Hershey', 'Arizona', '85169-8373', 'US', '(602) 882-2095'),
  • ('925 Noble Quail Bay', 'Umatilla', 'Arizona', '85357-1314', 'US', '(480) 604-6625');

SQL Create Table

SQL Table: 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