United States Company Profiles Database

Database Description:

Over 300,000 distinct records of United States companies and businesses, mostly with online presence and success, categorized under states / cities as well as 3 levels of classifications (180,00 of them), including business address, website URL, phone number, fax number, annual revenue, total employee and leading board (full names and positions).

Prospective Applications / Implementations:

• US yellow pages site
• US business directory
• Marketing needs
• Competitive analysis
• ...Order a custom build

Database Meta:

• Size: 161.6 MB
• Last updated: Dec. 3rd, 2008
• Format: MySQL 5, compressed SQL text file
• Tables: 6

phpMyAdmin Screenshots:

Table Details:

• category

  Records:153

  Level 2 categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. topcategory: smallint(6)
  4. url: varchar(255)
  5. count: varchar(255)

• city

  Records:25965

  US cities and towns.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. state: smallint(6)
  4. url: varchar(255)
  5. letter: char(1)

• listing

  Records:302368

  Company and business listings and their detailed information.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. state: smallint(6)
  4. city: smallint(6)
  5. subcategory: smallint(6)
  6. intro: text
  7. location: varchar(255)
  8. address: text
  9. website: varchar(255)
  10. phone: varchar(255)
  11. fax: varchar(255)
  12. revenue: varchar(255)
  13. employee: varchar(255)
  14. desc: text
  15. people: text

• state

  Records:50

  US states.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)

• subcategory

  Records:16992

  Level 3 categorization.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. url: varchar(255)
  4. category: smallint(6)
  5. count: smallint(6)

• topcategory

  Records:24

  Level 1 categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)
  4. count: mediumint(9)

Purchase: $589.95 (USD)