US Business Yellow Pages Database (20.3 Million Company Phone Numbers, Addresses by Zip Code)

Database Description:

If you are ever in need of a complete database of United States based businesses / organizations / companies / corporations (category, types / keywords, state, city, name, address, zip code & extended zip, phone number), with over 20.3 million records, this one is it. Only 77 records have no phone numbers. The total number of unique phone numbers is 10,885,276.

In this US business database, there are businesses across 51 states and 33,639 cities that are classified under 18 business categories and further under 275 sub-categories. Zip codes and extended zip codes are available in a separate field to facilitate searching by postal code or locality.

Database Meta:

• Size: 5567.38 MB
• Last updated: June 26th, 2011
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 6

Buy Now & Download: $489.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• business

  Records:20,308,692

  The table containing all the businesses: name, address, zip code, phone, type, category, sub_category, state and city.

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(255)
  3. address: varchar(255)
  4. extended_zip_code: char(4)
  5. zip_code: char(5)
  6. phone: varchar(255)
  7. types: varchar(255)
  8. category_slug: varchar(255)
  9. sub_category_slug: varchar(255)
  10. state_abbreviation: char(2)
  11. city_slug: varchar(255)
  12. city_id: int(11)

• category

  Records:18

  Top business categories.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. count: varchar(255)

• city

  Records:33,639

  All US cities, each referencing a state.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. count: varchar(255)
  5. state_id: int(11)
  6. state_abbreviation: char(2)

• state

  Records:51

  All US states.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. abbreviation: char(2)

• sub_category

  Records:275

  All sub-categories, each referencing a category.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. count: varchar(255)
  5. category_id: int(11)

• sub_sub_category

  Records:3,167

  Independent sub-sub-category table, each referencing a sub-category.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. count: varchar(255)
  5. sub_category_id: int(11)

Buy Now & Download: $489.95 (USD)

Prospective Applications / Implementations:

• US yellow pages site by zip codes
• US business directory
• Marketing needs
• Business information site enhancement
• Business search site
• Business reverse phone lookup
• ...Order a custom build

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $175)
• Single Table Format (Extra $100)