This yellow pages database is a great one to help people from all over the world checking the telephone numbers of Canada and developing your business. It has 3,167,986 company records with description, address, telephone, rating index, latitude, longitude, etc. in each. All these companies are categorized into 2,809 industries and from 1,029 cities of 13 states in the Canada. It also contains 2,305,854 details and 2,534,965 the open time of these companies. The whole Canada yellow pages has a total of 8 tables.
| Name | n3_lyz_canpages.ca |
|---|---|
| Data | 3.93G (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 44 (+ 0) |
| Table Rows | 17,029,495 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_industry | 2,809 | category_industry |
100%
|
| city | 1,029 | city |
100%
|
| state_id |
100%
|
||
| city_x_category_industry | 102,842 | city_id |
100%
|
| category_industry_id |
100%
|
||
| company | 3,167,986 | company |
100%
|
| description |
20.92%
|
||
| city_x_category_industry_id |
40.08%
|
||
| address |
99.58%
|
||
| telephone |
99.09%
|
||
| rating_index |
5.97%
|
||
| latitude |
29.68%
|
||
| longitude |
29.68%
|
||
| company_detail | 2,305,854 | title |
100%
|
| company_id |
100%
|
||
| company_detail_value | 8,913,997 | value |
100%
|
| company_detail_id |
100%
|
||
| company_opne_time | 2,534,965 | open_time |
100%
|
| company_id |
100%
|
||
| state | 13 | state |
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.
