Usage & Publication License: database price dollar sign199.00

2,918,163 Canada Yellow Pages Database

Phone, rating index, latitude, longitude, address, business content of 13,167,986 companies by 2809 categories & 1,029 cities

database structure screenshot of 2,918,163 Canada Yellow Pages Database

Description: This Canada yellow pages database is a great one to help people from all over the world check the telephone numbers of Canada and develop your business. There are 2,918,163 business records from 1,029 cities of 13 states. This data set consists title,address,telephone,rating index,description,latitude,longitude,detail business scope and detail business hours etc.

Data Samples (JSON, CSV, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/yellow_page_information_for_business_of_Canada_1/main/list/?app=html-bunker

Related DBs:

Database Statistics

  • Size: 3.90 GB
  • Tables: 8
  • Records: 2,918,163
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
category_industry 2,809
  1. id
  2. ts
  3. category_industry
state 13
  1. id
  2. ts
  3. state
city 1,029
  1. id
  2. ts
  3. city
city_x_category_industry 102,842
  1. id
  2. ts
company 2,918,163
  1. id
  2. ts
  3. company
  4. description
  5. address
  6. telephone
  7. rating_index
  8. latitude
  9. longitude
company_detail 2,305,854
  1. id
  2. ts
  3. title
company_detail_value 8,913,997
  1. id
  2. ts
  3. value
company_open_time 2,534,965

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

state

  • Alberta
  • British Columbia
  • Manitoba
  • New Brunswick
  • Newfoundland and Labrador
  • Northwest Territories
  • Nova Scotia
  • Nunavut
  • Ontario
  • Prince Edward Island
  • Québec
  • Saskatchewan
  • Yukon

city

  • Acheson
  • Airdrie
  • Ardrossan
  • Athabasca
  • Banff
  • Barrhead
  • Beaumont
  • Beaverlodge
  • Bentley
  • Blackfalds
  • Bonnyville
  • Bow Island
  • Boyle
  • Bragg Creek
  • Brooks
  • Calgary
  • Camrose
  • Canmore
  • Cardston
  • Carstairs
  • Chestermere
  • Clairmont
  • Claresholm
  • Coaldale
  • Cochrane
  • Cold Lake
  • Coronation
  • Crossfield
  • Crowsnest Pass
  • Devon
  • Didsbury
  • Drayton Valley
  • Drumheller
  • Eckville
  • Edmonton
  • Edson
  • Elk Point
  • Evansburg
  • Fairview
  • Falher
  • Fort Macleod
  • Fort McMurray
  • Fort Saskatchewan
  • Fox Creek
  • Grande Cache
  • Grande Prairie
  • Grimshaw
  • Hanna
  • High Level
  • High Prairie
  • High River
  • Hinton
  • Innisfail
  • Jasper
  • La Crete
  • Lac la Biche
  • Lacombe
  • Lamont
  • Langdon
  • Leduc
  • Lethbridge
  • Lloydminster
  • Manning
  • Mayerthorpe
  • Medicine Hat
  • Millet
  • Morinville
  • Nanton
  • Nisku
  • Okotoks
  • Olds
  • Onoway
  • Peace River
  • Penhold
  • Picture Butte
  • Pincher Creek
  • Ponoka
  • Provost
  • Red Deer
  • Red Deer County
  • Redcliff
  • Redwater
  • Rimbey
  • Rocky Mountain House
  • Sexsmith
  • Sherwood Park
  • Slave Lake
  • Smoky Lake
  • Spirit River
  • Spruce Grove
  • St Paul
  • St Albert
  • Stettler
  • Stony Plain
  • Strathmore
  • Sundre
  • Swan Hills
  • Sylvan Lake
  • Taber
  • Three Hills

category_industry

  • All-Terrain Vehicles
  • Automobile Repairing & Service
  • Automobile Wheel Alignment, Balancing, Frame & Axle Service
  • Banquet Rooms
  • Beverages - Non-Alcoholic - Retail
  • Buses - Wholesalers &/or Manufacturers
  • Concrete Breaking, Cutting, Sawing, Etc
  • Concrete Contractors
  • Contractors
  • Contractors - General
  • Cranes - Rental
  • Cruises
  • Demolition Contractors
  • Drilling & Boring Contractors
  • Excavating Contractors
  • Fuel - Bulk - Dealers
  • Home Builders
  • Insulation Contractors - Cold & Heat
  • Insulation Materials - Cold & Heat
  • Landscape Contractors
  • Modular Homes - Dealers
  • Oil Companies
  • Oil Field Equipment - Repair
  • Oil Field Services
  • Oil Tanks - Installation & Removal
  • Outboard Motors - Parts
  • Outboard Motors - Retail
  • Packaging Machinery
  • Party Supplies - Retail
  • Pavement Marking
  • Pipe - Wholesalers &/or Manufacturers
  • Pipe Bending & Fabricating
  • Plastic Moulders - Wholesalers &/or Manufacturers
  • Plastics & Plastic Products
  • Plastics - Products - Finished - Wholesalers &/or Manufacturers
  • Plating
  • Poles
  • Pollution Control
  • Produce - Wholesale
  • Recreational Vehicle Parks
  • Recreational Vehicles & Campers - Wholesalers &/or Manufacturers
  • Recreational Vehicles - Equipment, Parts & Service
  • Recreational Vehicles - Rental & Leasing
  • Recreational Vehicles - Repair & Service
  • Recreational Vehicles - Retail
  • Recreational Vehicles - Storage
  • Renovations & Home Improvements
  • Rental Service Stores & Yards
  • Restaurants
  • Road Construction
  • Roof Structures
  • Roof Trusses
  • Roofing Contractors
  • Roofing Materials - Wholesalers &/or Manufacturers
  • Safety Consultants & Training
  • Septic Tanks & Systems - Wholesalers &/or Manufacturers
  • Service Stations - Gasoline & Oil
  • Sewer Contractors
  • Sheet Metal - Retail
  • Siding Contractors
  • Signs
  • Snack Products
  • Snow Removal Services
  • Snowmobiles - Parts & Accessories
  • Snowmobiles - Retail
  • Steel
  • Steel - Structural
  • Steel Erectors
  • Steel Fabricators
  • Tanks - Fibreglass, Plastic, Etc
  • Tanks - Metal
  • Telecommunications Consultants
  • Tire Dealers' Equipment & Supplies
  • Tire Retreading & Repair
  • Tire Services
  • Tires - Retail
  • Tourist Information
  • Trailer Parks
  • Trailers - Camping & Travel
  • Trailers - Commercial - Dealers & Manufacturers
  • Trailers - Equipment & Parts
  • Trailers - Industrial Camps
  • Trailers - Rental & Leasing
  • Trailers - Repair & Service
  • Trailers - Truck
  • Travel Services
  • Truck Accessories
  • Truck Bodies
  • Truck Bodies - Wholesalers &/or Manufacturers
  • Truck Equipment & Parts
  • Truck Lines
  • Trucks - Repair & Service
  • Trucks - Retail
  • Trucks - Used
  • Tubing
  • Water Heaters - Retail
  • Waterproofing Materials
  • Weed Control Services
  • Welding Shops
  • Wood Preserving

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What floats on water, boat or stone?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.