Home Data Business & Industry Yellow Pages Canada Yellow Pages

Canada 3,167,986 Businesses Yellow Pages Data: Address, Lat, Lon, Tel.

Name	n3_lyz_canpages.ca
Data	3.95G (+ 0B)
Tables	9 (+ 0)
Columns	55 (+ 0)
Table Rows	17,047,801 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:12:05 (+ 169 d)

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 9 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_lyz/yellow_page_information_for_business_of_Canada_1/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category_industry	2,809	category_industry	100%
city	1,029	city	100%
city	1,029	state_id	100%
city_x_category_industry	102,842	city_id	100%
city_x_category_industry	102,842	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_auto	18,306	company	100%
		description	17.13%
		city_x_category_industry_id	38.85%
		address	98.72%
		telephone	98.56%
		rating_index	11.71%
		latitude	27.83%
		longitude	27.83%
company_detail	2,305,854	title	100%
company_detail	2,305,854	company_id	100%
company_detail_value	8,913,997	value	100%
company_detail_value	8,913,997	company_detail_id	100%
company_opne_time	2,534,965	open_time	100%
company_opne_time	2,534,965	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.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	3.95G (+ 0B)	9 (+ 0)	55 (+ 0)	17,047,801 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	3.95G (+ 0B)	9 (+ 0)	55 (+ 0)	17,047,801 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	3.95G (+ 0B)	9 (+ 0)	55 (+ 0)	17,047,801 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	3.95G (+ 0B)	9 (+ 0)	55 (+ 0)	17,047,801 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	3.95G (+ 15.97M)	9 (+ 1)	55 (+ 11)	17,047,801 (+ 18,306)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	3.93G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	3.93G (+ 2.96G)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	0.98G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	0.98G (+ 0B)	8 (+ 0)	44 (+ 0)	17,029,495 (+ 4,605,377)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	0.98G (+ 0B)	8 (+ 0)	44 (+ 0)	12,424,118 (+ 3,492,693)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	0.98G (+ 0B)	8 (+ 0)	44 (+ 0)	8,931,425 (+ 3,866,322)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	0.98G (+ 217.52M)	8 (+ 0)	44 (+ 0)	5,065,103 (+ 1,908,017)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	780.94M (+ 588.50M)	8 (+ 0)	44 (+ 2)	3,157,086 (+ 2,702,980)	0B (+ 0B)	0 (+ 0)
2018-04-11	192.44M	8	42	454,106	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.