Lifetime updates. Come back once in a while to stay updated of new versions of this database.
US/CA Business Yellow Pages Database (13.8 Million Companies Phone, Zip Code, Website, Latitude & Longitude, etc.)
Database Description:
This database (9.9GB) contains all the 13.8 million companies & businesses across United States and Canada, with important information such as phone number (100%), website URL (35.1%), latitude (99.2%), longitude (99.2%), fax (1%), contact person (34.6%), street address (100%), zip code (99.3%), city (100%), state / province (100%), extended zip code (75.0%), estimated number of employees (30.4%), both NAICS & SIC classifications (100%). If you are ever in need of a complete database of North America based businesses / organizations / companies / corporations, this one is it. The total number of unique phone numbers is 11,375,789, website 2,214,232.
This is the 3rd edition / major update of this database. For the 4th edition, see US Yellow Pages (22.5 Million).
In this business directory database of United States and Canada, we have businesses classified under 18 business categories and further under 273 sub-categories, across 51 states of US, 13 provinces of Canada and 43,868 cities in both of them.
Database Meta:
Buy Now & Download: $599.00 (USD)
phpMyAdmin Screenshots:
Table Details (Data Structure / Schema):
-
business
Records:13,824,004All the business records containing information for each of the businesses in United States and Canada.
Data fields
- id: int(11)
- title: varchar(255)
- address_html: varchar(255)
- street: varchar(255)
- city: varchar(255)
- zipcode: varchar(255)
- zipcode_extended: varchar(255)
- phone: varchar(255)
- contact_person: varchar(255)
- categories: text
- fax: varchar(255)
- website: varchar(255)
- estimated_number_of_employees: varchar(255)
- latitude: varchar(255)
- longitude: varchar(255)
- NAICS_categories: text
- SIC_categories: text
-
business2city2category_sub
Records:19,751,639A business is related to cities and sub categories.
Data fields
- id: int(11)
- business_id: int(11)
- city_id: int(11)
- category_sub_id: int(11)
- city2category_sub_id: int(11)
-
category
Records:18Top categories table of major business types or industries.
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
- count: int(11)
-
category_sub
Records:273Sub categories of businesses, children of the top categories.
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
- category_id: int(11)
- count: int(11)
-
city
Records:43,868Cities in US and Canada.
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
- state_province: char(2)
- country: char(2)
- count: int(11)
-
city2category_sub
Records:1,997,681Combinations of cities and sub categories.
Data fields
- id: int(11)
- city_id: int(11)
- category_sub_id: int(11)
- count: int(11)
-
state_province
Records:6451 states of US and 13 provinces of Canada.
Data fields
- id: int(11)
- title: varchar(255)
- slug: char(2)
- country: char(2)
- count: int(11)
Buy Now & Download: $599.00 (USD)
Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.
Instant download upon payment success, just press return button on PayPal website after finishing payment.
Potential Applications / Usage:
- US yellow pages site by zip codes
- US business directory
- Marketing intelligence
- Business information site or application
- Business maps, search and comparison site or app
- Business reverse phone lookup
Other Available Formats:
Some of these formats are available on extra charge, depending on the database.
- 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
- Single Table Format
As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.