Usage & Publication License: database price dollar sign199.00

3M Canada Yellow Pages: Desc, Address, Lat, Lon, Tel. Database

3,167,986 yellow pages: address, lat, lon, tel. database from 1,029 cities of 13 states in Canada

database structure screenshot of 3M Canada Yellow Pages: Desc, Address, Lat, Lon, Tel. Database

Description: 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.

Data Samples (JSON, CSV, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/yellow_page_information_for_business_of_Canada_1/main/list/

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. Which cannot float 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.