Database
2.9M 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, XML, 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
- Tofield
- Turner Valley
- Valleyview
- Vegreville
- Vermilion
- Viking
- Vulcan
- Wabasca
- Wainwright
- Westlock
- Wetaskiwin
- Whitecourt
- 100 Mile House
- Abbotsford
- Agassiz
- Aldergrove
- Armstrong
- Barriere
- Bowen Island
- Brentwood Bay
- Burnaby
- Burns Lake
- Campbell River
- Castlegar
- Chase
- Chemainus
- Chetwynd
- Chilliwack
- Clearwater
- Cloverdale
- Cobble Hill
- Comox
- Coquitlam
- Courtenay
- Cranbrook
- Creston
- Cumberland
- Dawson Creek
- Delta
- Duncan
- Enderby
- Fernie
- Fort Langley
- Fort Nelson
- Fort St. James
- Fort St. John
- Fruitvale
- Gabriola
- Gibsons
- Golden
- Grand Forks
- Haney
- Hope
- Houston
- Invermere
- Kamloops
- Kelowna
- Keremeos
- Kimberley
- Kitimat
- Ladner
- Ladysmith
- Lake Cowichan
- Langley
- Lantzville
- Lillooet
- Lumby
- Mackenzie
- Maple Ridge
- Merritt
- Mill Bay
- Mission
- Nakusp
- Nanaimo
- Nanoose Bay
- Nelson
- New Westminster
- Newton
- North Saanich
- North Vancouver
- Okanagan Falls
- Oliver
- Osoyoos
- Parksville
- Peachland
- Pemberton
- Penticton
- Pitt Meadows
- Port Alberni
- Port Coquitlam
- Port Hardy
- Port McNeill
- Port Moody
- Powell River
- Prince George
- Prince Rupert
- Princeton
- Qualicum Beach
- Quesnel
- Revelstoke
- Richmond
- Rossland
- Rutland
- Saanich
- Saanichton
- Salmon Arm
- Salt Spring Island
- Sechelt
- Sicamous
- Sidney
- Smithers
- Sooke
- Sorrento
- Sparwood
- Squamish
- Summerland
- Surrey
- Terrace
- Tofino
- Trail
- Ucluelet
- Valemount
- Vancouver
- Vanderhoof
- Vernon
- Victoria
- West Kelowna
- West Vancouver
- Westbank
- Whalley
- Whistler
- White Rock
- Williams Lake
- Winfield
- Altona
- Arborg
- Beausejour
- Boissevain
- Brandon
- Carberry
- Carman
- Dauphin
- East St Paul
- Flin Flon
- Gimli
- Headingley
- Killarney
- Lac du Bonnet
- Lockport
- Lorette
- Minnedosa
- Morden
- Morris
- Neepawa
- Niverville
- Oakbank
- Portage la Prairie
- Roblin
- Selkirk
- Souris
- Ste Anne
- Ste Rose du Lac
- Steinbach
- Stonewall
- Swan River
- Teulon
- The Pas
- Thompson
- Virden
- West St Paul
- Winkler
- Winnipeg
- Bathurst
- Beresford
- Bouctouche
- Campbellton
- Cap-Pele
- Caraquet
- Cocagne
- Dalhousie
- Dieppe
- Edmundston
- Florenceville-Bristol
- Fredericton
- Grand Bay-Westfield
- Grand Falls
- Grand-Sault/Grand Falls
- Hampton
- Hartland
- Minto
- Miramichi
- Moncton
- Neguac
- Oromocto
- Perth-Andover
- Petit-Rocher
- Petitcodiac
- Quispamsis
- Richibucto
- Riverview
- Rothesay
- Sackville
- Saint John
- Saint-Quentin
- Salisbury
- Shediac
- Shippagan
- St Andrews
- St George
- St Stephen
- Sussex
- Tracadie-Sheila
- Woodstock
- Bay Roberts
- Carbonear
- Channel-Port-aux-Basques
- Conception Bay South
- Corner Brook
- Deer Lake
- Gander
- Grand Bank
- Grand Falls-Windsor
- Happy Valley-Goose Bay
- Labrador City
- Lewisporte
- Long Pond
- Marystown
- Mount Pearl
- Paradise
- Portugal Cove-St Philips
- Rocky Harbour
- Springdale
- St. Anthony
- St John's
- Stephenville
- Torbay
- Fort Smith
- Hay River
- Inuvik
- Yellowknife
- Amherst
- Annapolis Royal
- Antigonish
- Baddeck
- Barrington
- Bedford
- Berwick
- Bridgewater
- Chester
- Dartmouth
- Digby
- Elmsdale
- Glace Bay
- Halifax
- Head of St Margarets Bay
- Kentville
- Kingston
- Liverpool
- Lower Sackville
- Lunenburg
- Mahone Bay
- Middleton
- Musquodoboit Harbour
- New Glasgow
- New Minas
- North Sydney
- Pictou
- Port Hawkesbury
- Shelburne
- Shubenacadie
- Springhill
- Sydney
- Truro
- Waverley
- Windsor
- Wolfville
- Yarmouth
- Iqaluit
- Acton
- Ajax
- Alexandria
- Alliston
- Almonte
- Amherstburg
- Ancaster
- Angus
- Arnprior
- Atikokan
- Aurora
- Aylmer
- Ayr
- Azilda
- Baden
- Bala
- Bancroft
- Barrie
- Barrys Bay
- Bayfield
- Beamsville
- Beaverton
- Beeton
- Belle River
- Belleville
- Binbrook
- Blind River
- Bobcaygeon
- Bolton
- Bowmanville
- Bracebridge
- Bradford
- Brampton
- Brantford
- Breslau
- Bridgenorth
- Brighton
- Brockville
- Brooklin
- Buckhorn
- Burford
- Burks Falls
- Burlington
- Caledon East
- Caledonia
- Callander
- Cambridge
- Campbellford
- Campbellville
- Carleton Place
- Carp
- Casselman
- Cayuga
- Chapleau
- Chatham
- Chatsworth
- Chelmsford
- Clarkson
- Cobden
- Coboconk
- Cobourg
- Cochrane
- Coldwater
- Collingwood
- Concord
- Cookstown
- Cooksville
- Cornwall
- Corunna
- Courtice
- Creemore
- Deep River
- Delhi
- Deseronto
- Dorchester
- Dryden
- Dundas
- Dunnville
- East York
- Eganville
- Elliot Lake
- Elmira
- Elmvale
- Elora
- Embrun
- Englehart
- Erin
- Espanola
- Essex
- Etobicoke
- Exeter
- Fenelon Falls
- Fergus
- Fort Erie
- Fort Frances
- Freelton
- Galt
- Gananoque
- Garson
- Georgetown
- Gloucester
- Goderich
- Gormley
- Grand Bend
- Gravenhurst
- Grimsby
- Guelph
- Hagersville
- Haileybury
- Haliburton
- Hamilton
- Hanmer
- Hanover
- Harriston
- Havelock
- Hawkesbury
- Hearst
- Holland Landing
- Huntsville
- Ingersoll
- Innisfil
- Iroquois Falls
- Jarvis
- Kanata
- Kapuskasing
- Kemptville
- Kenora
- Keswick
- Kincardine
- King City
- Kingston
- Kingsville
- Kirkland Lake
- Kitchener
- Kleinburg
- Lakefield
- Lambeth
- Leamington
- Lindsay
- Listowel
- Little Current
- Lively
- London
- Lucan
- Madoc
- Maidstone
- Malton
- Manotick
- Maple
- Marathon
- Markdale
- Markham
- Marmora
- Mattawa
- Meaford
- Merrickville
- Metcalfe
- Midland
- Milton
- Mindemoya
- Minden
- Mississauga
- Mitchell
- Moosonee
- Morrisburg
- Mount Albert
- Mount Brydges
- Mount Forest
- Mount Hope
- Napanee
- Navan
- Nepean
- New Hamburg
- New Liskeard
- Newcastle
- Newmarket
- Niagara Falls
- Niagara-on-the-Lake
- Nipigon
- Nobleton
- North Bay
- North Gower
- North York
- Norwich
- Norwood
- Oak Ridges
- Oakville
- Ohsweken
- Omemee
- Orangeville
- Orillia
- Orleans
- Orono
- Oshawa
- Ottawa
- Owen Sound
- Paris
- Parkhill
- Parry Sound
- Pefferlaw
- Pelham
- Pembroke
- Penetanguishene
- Perth
- Petawawa
- Peterborough
- Petrolia
- Pickering
- Picton
- Point Edward
- Port Carling
- Port Colborne
- Port Credit
- Port Dover
- Port Elgin
- Port Hope
- Port Perry
- Port Rowan
- Port Stanley
- Powassan
- Prescott
- Queensville
- Red Lake
- Renfrew
- Richmond Hill
- Ridgetown
- Ridgeway
- Rockland
- Rockwood
- Russell
- Sarnia
- Sauble Beach
- Sault Ste. Marie
- Scarborough
- Schomberg
- Seaforth
- Severn Bridge
- Shelburne
- Simcoe
- Sioux Lookout
- Smiths Falls
- Smithville
- South Porcupine
- South River
- St Catharines
- St Clements
- St George Brant
- St Jacobs
- St Marys
- St Thomas
- Stayner
- Stirling
- Stittsville
- Stoney Creek
- Stouffville
- Stratford
- Strathroy
- Streetsville
- Sturgeon Falls
- Sudbury
- Sundridge
- Sutton West
- Tavistock
- Tecumseh
- Thornbury
- Thorndale
- Thornhill
- Thorold
- Thunder Bay
- Tilbury
- Tillsonburg
- Timmins
- Toronto
- Tottenham
- Trenton
- Tweed
- Unionville
- Uxbridge
- Val Caron
- Vanier
- Vankleek Hill
- Vineland
- Walkerton
- Wallaceburg
- Wasaga Beach
- Waterdown
- Waterford
- Waterloo
- Watford
- Wawa
- Welland
- Wheatley
- Whitby
- Wiarton
- Winchester
- Windsor
- Wingham
- Winona
- Woodbridge
- Woodstock
- Alberton
- Charlottetown
- Kensington
- Montague
- Souris
- Stratford
- Summerside
- Acton Vale
- Alma
- Amos
- Amqui
- Anjou
- Asbestos
- Aylmer
- Baie-Comeau
- Baie-d'Urfé
- Baie-Saint-Paul
- Beaconsfield
- Beauceville
- Beauharnois
- Bécancour
- Bedford
- Beloeil
- Berthierville
- Blainville
- Bois-des-Filion
- Boisbriand
- Boischatel
- Bonaventure
- Boucherville
- Bromont
- Brossard
- Brownsburg-Chatham
- Buckingham
- Cabano
- Candiac
- Carignan
- Carleton
- Chambly
- Chandler
- Charlesbourg
- Charny
- Château-Richer
- Châteauguay
- Chelsea
- Chibougamau
- Chicoutimi
- Chomedey
- Coaticook
- Contrecoeur
- Côte-Saint-Luc
- Coteau-du-Lac
- Cowansville
- Danville
- Dégelis
- Delson
- Deux-Montagnes
- Disraeli
- Dolbeau-Mistassini
- Dollard-des-Ormeaux
- Donnacona
- Dorval
- Drummondville
- Dunham
- East Angus
- Farnham
- Forestville
- Fort-Coulonge
- Gaspe
- Gatineau
- Gracefield
- Granby
- Grand-Mère
- Grande-Rivière
- Greenfield Park
- Grenville
- Havre-Saint-Pierre
- Hemmingford
- Hudson
- Hull
- Huntingdon
- Joliette
- Jonquière
- Kirkland
- Knowlton
- L'Ancienne-Lorette
- L'Assomption
- L'Épiphanie
- L'Ile-Perrot
- L'Islet
- La Baie
- La Guadeloupe
- La Malbaie
- La Pocatière
- La Prairie
- La Sarre
- La Tuque
- Labelle
- Lac-Beauport
- Lac-Etchemin
- Lac-Mégantic
- Lachine
- Lachute
- Lacolle
- Lambton
- LaSalle
- Laterrière
- Laval
- Laval-Ouest
- Lavaltrie
- Le Gardeur
- Lebel-sur-Quévillon
- Lemoyne
- Les Cèdres
- Les Coteaux
- Les Escoumins
- Lévis
- Longueuil
- Loretteville
- Lorraine
- Louiseville
- Magog
- Malartic
- Maniwaki
- Maria
- Marieville
- Mascouche
- Matane
- Mercier
- Métabetchouan-Lac-à-la-Croix
- Mirabel
- Mont-Joli
- Mont-Laurier
- Mont-Royal
- Mont-Saint-Hilaire
- Mont-Tremblant
- Montmagny
- Montréal
- Montréal-Est
- Montréal-Nord
- Montréal-Ouest
- Morin-Heights
- Napierville
- New Richmond
- Nicolet
- Normandin
- Notre-Dame-des-Prairies
- Oka
- Ormstown
- Otterburn Park
- Outremont
- Papineauville
- Percé
- Piedmont
- Pierrefonds
- Pierreville
- Pincourt
- Pintendre
- Plessisville
- Pointe-aux-Trembles
- Pointe-Claire
- Pont-Rouge
- Pont-Viau
- Port-Cartier
- Prévost
- Princeville
- Québec
- Rawdon
- Repentigny
- Richmond
- Rigaud
- Rimouski
- Rivière-du-Loup
- Rivière-Rouge
- Roberval
- Rosemère
- Rouyn-Noranda
- Roxboro
- Saint-Agapit
- Saint-Alphonse-de-Granby
- Saint-Amable
- Saint-Ambroise
- Saint-Ambroise-de-Kildare
- Saint-Andre-Avellin
- Saint-Anselme
- Saint-Antonin
- Saint-Apollinaire
- Saint-Augustin-de-Desmaures
- Saint-Basile-le-Grand
- Saint-Boniface-de-Shawinigan
- Saint-Bruno
- Saint-Bruno-Lac-Saint-Jean
- Saint-Césaire
- Saint-Charles-Borromée
- Saint-Charles-de-Drummond
- Saint-Colomban
- Saint-Constant
- Saint-Cyrille-de-Wendover
- Saint-Donat-de-Montcalm
- Saint-Éphrem-de-Beauce
- Saint-Étienne-de-Lauzon
- Saint-Eustache
- Saint-Faustin-Lac-Carré
- Saint-Felicien
- Saint-Felix-de-Valois
- Saint-Flavien
- Saint-Gabriel-de-Brandon
- Saint-Georges
- Saint-Germain-de-Grantham
- Saint-Henri-de-Lévis
- Saint-Hippolyte
- Saint-Honore-de-Chicoutimi
- Saint-Hubert
- Saint-Hyacinthe
- Saint-Jacques
- Saint-Janvier
- Saint-Jean-Chrysostome
- Saint-Jean-de-Matha
- Saint-Jean-Port-Joli
- Saint-Jean-sur-Richelieu
- Saint-Jérome
- Saint-Joseph-de-Beauce
- Saint-Joseph-du-Lac
- Saint-Lambert
- Saint-Lambert-de-Lauzon
- Saint-Laurent
- Saint-Lazare
- Saint-Léonard
- Saint-Liboire
- Saint-Lin-Laurentides
- Saint-Marc-des-Carrières
- Saint-Michel-des-Saints
- Saint-Nicéphore
- Saint-Nicolas
- Saint-Pamphile
- Saint-Pascal
- Saint-Paul-d'Abbotsford
- Saint-Pie
- Saint-Prosper-de-Dorchester
- Saint-Raymond
- Saint-Rémi
- Saint-Romuald
- Saint-Sauveur
- Saint-Tite
- Saint-Victor
- Saint-Vincent-de-Paul
- Sainte-Adèle
- Sainte-Agathe-des-Monts
- Sainte-Anne-de-Beaupré
- Sainte-Anne-de-Bellevue
- Sainte-Anne-des-Monts
- Sainte-Anne-des-Plaines
- Sainte-Catherine
- Sainte-Claire
- Sainte-Geneviève
- Sainte-Julie
- Sainte-Julienne
- Sainte-Madeleine
- Sainte-Marie
- Sainte-Marthe-sur-le-Lac
- Sainte-Martine
- Sainte-Rose
- Sainte-Sophie
- Sainte-Thérèse
- Salaberry-de-Valleyfield
- Senneterre
- Sept-Îles
- Shawinigan
- Shawinigan-Sud
- Shawville
- Shefford
- Sherbrooke
- Sorel-Tracy
- Stanstead
- Sainte-Catherine-de-la-J-Cartier
- Stoneham-et-Tewkesbury
- Sutton
- Témiscaming
- Terrebonne
- Thetford Mines
- Thurso
- Trois-Pistoles
- Trois-Rivières
- Val-d'Or
- Val-David
- Val-des-Monts
- Valcourt
- Varennes
- Vaudreuil-Dorion
- Verchères
- Verdun
- Victoriaville
- Ville-Marie
- Vimont
- Wakefield
- Warwick
- Waterloo
- Westmount
- Wickham
- Windsor
- Assiniboia
- Biggar
- Canora
- Carlyle
- Carnduff
- Esterhazy
- Estevan
- Foam Lake
- Fort Qu'Appelle
- Gravelbourg
- Hudson Bay
- Humboldt
- Kamsack
- Kindersley
- La Ronge
- Langenburg
- Lloydminster
- Lumsden
- Macklin
- Maidstone
- Maple Creek
- Martensville
- Meadow Lake
- Melfort
- Melville
- Moose Jaw
- Moosomin
- Nipawin
- North Battleford
- Outlook
- Oxbow
- Preeceville
- Prince Albert
- Redvers
- Regina
- Rosetown
- Rosthern
- Saskatoon
- Shaunavon
- Shellbrook
- Swift Current
- Tisdale
- Unity
- Wadena
- Warman
- Watrous
- Weyburn
- Wynyard
- Yorkton
- Dawson
- Whitehorse
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.