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.
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: Dec. 1st, 2008
- Format: MySQL 5, compressed SQL text file
- 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: $789.95 (USD)
Instant automatic download upon payment success, just press return button on PayPal website after finishing payment.