US/CA Yellow Pages
US/CA Business Yellow Pages (Phone, Zip, URL, Latitude & Longitude)
↑Data Structure
business
[13,824,004]
int(11)
+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]
int(11)
+id
(100%)
timestamp
+ts
(100%)
int(11)
+business_id
(100%)
int(11)
+city_id
(100%)
int(11)
+category_sub_id
(100%)
int(11)
+city2category_sub_id
(100%)
category
[18]
int(11)
+id
(100%)
timestamp
+ts
(100%)
varchar(255)
+title
(100%)
varchar(255)
+slug
(100%)
int(11)
+count
(100%)
category_sub
[273]
int(11)
+id
(100%)
timestamp
+ts
(100%)
varchar(255)
+title
(100%)
varchar(255)
+slug
(100%)
int(11)
+category_id
(100%)
int(11)
+count
(100%)
city
[43,868]
int(11)
+id
(100%)
timestamp
+ts
(100%)
varchar(255)
+title
(100%)
varchar(255)
+slug
(100%)
char(2)
+state_province
(100%)
char(2)
+country
(100%)
int(11)
+count
(99%)
int(11)
+state_province_id
(100%)
city2category_sub
[1,997,681]
int(11)
+id
(100%)
timestamp
+ts
(100%)
int(11)
+city_id
(100%)
int(11)
+category_sub_id
(100%)
int(11)
+count
(100%)
state_province
[64]
int(11)
+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.
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.71G |
| Tables | 7 |
| Last Commit | 2021-02-01 01:50:03 |
↑Updates / Commits
| Time | Size | Tables | Columns | Rows |
|---|---|---|---|---|
| 2021-02-01 01:50:03 | 11.71G | 7 | 54 | 35617547 |
| 2017-04-04 01:40:01 | 11.98G | 7 | 54 | 35617547 |
| 2016-08-31 04:13:53 | 11.98G | 7 | 54 | 35617547 |
↑Pricing
All prices are in Datactory Credits.
| Table | Rows | Price 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.