US/CA Yellow Pages

US/CA Business Yellow Pages (Phone, Zip, URL, Latitude & Longitude)

Data Structure

business [13,824,004]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address_html (100%)
varchar(255)
+ street (100%)
varchar(255)
+ city (100%)
varchar(255)
+ zipcode (99.3%)
varchar(255)
+ zipcode_extended (75%)
varchar(255)
+ phone (100%)
varchar(255)
+ contact_person (34.6%)
text
+ categories (100%)
varchar(255)
+ fax (0.9%)
varchar(255)
+ website (35.1%)
varchar(255)
+ estimated_number_of_employees (30.3%)
varchar(255)
+ latitude (99.2%)
varchar(255)
+ longitude (99.2%)
text
+ NAICS_categories (100%)
text
+ SIC_categories (100%)
business2city2category_sub [19,751,639]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ business_id (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ category_sub_id (100%)
bigint(20) unsigned
+ city2category_sub_id (100%)
category [18]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
int(11)
+ count (100%)
category_sub [273]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ category_id (100%)
int(11)
+ count (100%)
city [43,868]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
char(2)
+ state_province (100%)
bigint(20) unsigned
+ state_province_id (100%)
char(2)
+ country (100%)
int(11)
+ count (99%)
city2category_sub [1,997,681]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ category_sub_id (100%)
int(11)
+ count (100%)
state_province [64]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
char(2)
+ slug (100%)
char(2)
+ country (100%)
int(11)
+ count (100%)

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. While it may seem to have less records than the previous version, it actually contains more unique businesses because we were counting businesses in multiple categories.

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.

Data Profile

Size 11.98G
Tables 7
Last Commit 2017-04-04 00:40:01

Updates / Commits

Time Size Tables Columns Rows
2017-04-04 00:40:01 11.98G 7 54 35617547
2016-08-31 03:13:53 11.98G 7 54 35617547

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
business 13,824,004 .001 13824.004
business2city2category_sub 19,751,639 .001 19751.639
category 18 .001 0.018
category_sub 273 .001 0.273
city 43,868 .001 43.868
city2category_sub 1,997,681 .001 1997.681
state_province 64 .001 0.064
Total Credits 35617.547 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.