This yellow pages database is a great one to help people from all over the world developing your businiess with Canada. It has 677,276 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 21 categories and further under 232 sub-categories. In the Canada companies data, there are 4 tables motsly related with these company, they are 198,468 company detail records; 481,710 company opening time records with day and time in each; 739,623 company phones and payment with 17 records.
The whole Canada yellow pages data set totaly has 16 tables.
| Name | n3_lyz_yellowpages.ca |
|---|---|
| Data | 1.68G (+ 820.44M) |
| Tables | 16 (+ 0) |
| Columns | 79 (+ 0) |
| Table Rows | 11,096,135 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 21 | category_industry |
100%
|
| category_2 | 232 | category_industry |
100%
|
| category_1_id |
100%
|
||
| category_3 | 6,024 | category_industry |
100%
|
| category_2_id |
100%
|
||
| city | 1,012 | city |
100%
|
| state_id |
100%
|
||
| city_x_category_1 | 21,242 | city_id |
100%
|
| category_1_id |
100%
|
||
| city_x_category_1_x_category_2 | 132,447 | city_x_category_1_id |
100%
|
| category_2_id |
100%
|
||
| city_x_category_1_x_category_2_x_category_3 | 1,024,083 | city_x_category_1_x_category_2_id |
100%
|
| category_3_id |
100%
|
||
| city_x_category_1_x_category_2_x_category_3_x_company | 6,719,669 | city_x_category_1_x_category_2_x_category_3_id |
100%
|
| company_id |
100%
|
||
| company | 677,276 | company |
100%
|
| website |
18.09%
|
||
| description |
7.85%
|
||
| score |
1.53%
|
||
| address_extend |
30.27%
|
||
| postalcode |
31.09%
|
||
| latitude |
33.26%
|
||
| longitude |
33.26%
|
||
| address |
31.2%
|
||
| region |
30.19%
|
||
| company_detail | 198,468 | title |
100%
|
| company_id |
100%
|
||
| company_detail_value | 836,168 | value |
100%
|
| company_detail_id |
100%
|
||
| company_opening_time | 481,710 | day |
99.77%
|
| time |
100%
|
||
| company_id |
100%
|
||
| company_phone | 739,623 | phone |
100%
|
| company_id |
100%
|
||
| company_x_payment | 258,130 | company_id |
100%
|
| payment_id |
100%
|
||
| payment | 17 | payment_way |
100%
|
| state | 13 | state |
100%
|
| state_feature |
84.62%
|
||
| description |
84.62%
|
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.
