Database
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
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/
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.