This yellow pages database is a great one to help people from all over the world developing your businiess with Canada. It has 1,488,581 company records with company, website, description, score, address extend, postal code, latitude, longitude, address and region in each.
All these companies are from 1,012 cities of 13 states in the Canada. They are all classified under 20,727 categories and further under 228,245 sub-categories. In the Canada companies data, there are 4 tables motsly related with these company, they are 1,144,170 company detail records; 2,833,062 company opening time records with day and time in each; 1,581,199 company phones and payment with 19 records.
The whole Canada yellow pages data set totaly has 13 tables.
| Name | n3_lyz_yellowpages.ca |
|---|---|
| Data | 1.55G (- 0.12G) |
| Tables | 13 (- 3) |
| Columns | 79 (+ 0) |
| Table Rows | 38,424,921 (+ 27,328,786) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 1,488,581 | latitude |
84.47%
|
| longitude |
84.47%
|
||
| postalcode |
83.44%
|
||
| region |
81.36%
|
||
| address |
83.81%
|
||
| address_extend |
81.44%
|
||
| score |
0%
|
||
| website |
28.15%
|
||
| description |
22.91%
|
||
| company |
100%
|
||
| company_opening_time | 2,833,062 | company_id |
100%
|
| time |
100%
|
||
| day |
99.8%
|
||
| company_detail_value | 4,776,419 | company_detail_id |
100%
|
| value |
100%
|
||
| company_detail | 1,144,170 | company_id |
100%
|
| title |
100%
|
||
| company_x_payment | 1,338,747 | company_id |
100%
|
| payment_id |
100%
|
||
| state | 13 | description |
0%
|
| state_feature |
0%
|
||
| state |
100%
|
||
| payment | 19 | payment_way |
100%
|
| company_phone | 1,581,199 | company_id |
100%
|
| phone |
100%
|
||
| category_2 | 228,245 | state |
100%
|
| city |
100%
|
||
| category_1 |
100%
|
||
| category_industry |
100%
|
||
| category_3 | 2,687,314 | city |
100%
|
| category_2id |
100%
|
||
| category_2 |
100%
|
||
| category_1 |
100%
|
||
| state |
100%
|
||
| category_3 |
100%
|
||
| city | 1,012 | state |
100%
|
| city |
100%
|
||
| category_1 | 20,727 | state |
100%
|
| city |
100%
|
||
| category_industry |
100%
|
||
| category_3_x_company | 22,325,413 | company_id |
100%
|
| category_3_id |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
