As we frequently enhance our databases, make sure you revisit from time to time to stay updated of the databases you have purchased. Simply by clicking through the URL we have sent, you can download the new versions anytime.
United States Business Yellow Pages Database
Database Description:
If you are ever in need of a huge database of US based companies, with over 3.4 million records, this one is it. For phone number database, look here.
Prospective Applications / Implementations:
- US yellow pages site
- US business directory
- Marketing needs
- Business information site enhancement
- Business search site
- Business reverse phone lookup
- ...Order a custom build
Database Meta:
- Size: 390.6 MB
- Last updated: Mar. 2nd, 2009
- Available Formats: MySQL 5 SQL text file, CSV for MS Excel
- Tables: 7
phpMyAdmin Screenshots:

Table Details:
-
category
Records:27Level 1 categorization.
Table fields
- id: smallint(6)
- title: varchar(255)
- url: varchar(255)
-
city
Records:26170US cities and towns.
Table fields
- id: smallint(6)
- title: varchar(255)
- url: varchar(255)
- state: smallint(6)
- letter: char(1)
-
listing
Records:3477656Table containing all the company listings.
Table fields
- id: int(11)
- title: varchar(255)
- phone: varchar(255)
- address: varchar(255)
- subcategory2city: mediumint(9)
-
state
Records:50All US states.
Table fields
- id: smallint(6)
- title: varchar(255)
- url: varchar(255)
- count: smallint(6)
-
subcategory
Records:284Level 2 categorization.
Table fields
- id: smallint(6)
- title: varchar(255)
- url: varchar(255)
- category: smallint(6)
-
subcategory2city
Records:585069Relational table of subcategory to city.
Table fields
- id: mediumint(9)
- subcategory: smallint(6)
- city: smallint(6)
-
subcategory2state
Records:13084Relational table of subcategory to state.
Table fields
- id: mediumint(9)
- subcategory: smallint(6)
- state: smallint(6)
Purchase: $589.95 (USD)
Instant automatic download upon payment success, just press return button on PayPal website after finishing payment.
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
- XML
- YAML
- WordPress Category / Post Database (Extra $400)