Database
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
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
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 |
|
| state | 13 |
|
| city | 1,029 |
|
| city_x_category_industry | 102,842 |
|
| company | 2,918,163 |
|
| company_detail | 2,305,854 |
|
| company_detail_value | 8,913,997 |
|
| 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
Let us know and we'll see what we can do. Additional fees may apply.