Usage & Publication License: database price dollar sign500.00

US & Canada Yellow Pages Database of 13.8 Million Businesses

Phone, fax, website, latitude, longitude, address of 13,824,004 companies by 273 categories & 43,868 cities

database structure screenshot of US & Canada Yellow Pages Database of 13.8 Million Businesses

Description: In this US business directory database, there are 13,824,004 companies across 43,868 cities from 51 states of US and 13 provinces of Canada, that are classified under 18 categories and further under 273 sub-categories. If you are ever in need of a complete yellow pages database of all North America businesses, this is the one. In table business, each record is comprised of company name, address (street, city, state / province), zip code (optionally an extended zip code), phone number, contact person, categories (also indexed as separate tables), fax number, website address, estimated number of employees, NAICS categories and SIC categories. The total number of unique phone numbers is 11,375,789, website 2,214,232.

99.2% of the businesses have latitude and longitude.

Related DBs:

Database Statistics

  • Size: 9.98 GB
  • Tables: 7
  • Records: 13,824,004
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
business 13,824,004
  1. id
  2. title
  3. address_html
  4. street
  5. city
  6. zipcode
  7. zipcode_extended
  8. phone
  9. contact_person
  10. categories
  11. fax
  12. website
  13. estimated_number_of_employees
  14. latitude
  15. longitude
  16. NAICS_categories
  17. SIC_categories
business2city2category_sub 19,751,639
  1. id
  2. business_id
  3. city_id
  4. category_sub_id
  5. city2category_sub_id
category 18
  1. id
  2. title
  3. slug
  4. count
category_sub 273
  1. id
  2. title
  3. slug
  4. category_id
  5. count
city 43,868
  1. id
  2. title
  3. slug
  4. state_province
  5. country
  6. count
city2category_sub 1,997,681
  1. id
  2. city_id
  3. category_sub_id
  4. count
state_province 64
  1. id
  2. title
  3. slug
  4. country
  5. count

Content Scope

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

state_province

  • Alabama - 295,202
  • Alaska - 77,683
  • Arizona - 263,145
  • Arkansas - 198,428
  • California - 1,951,237
  • Colorado - 360,648
  • Connecticut - 267,008
  • Delaware - 56,382
  • Florida - 1,044,831
  • Georgia - 506,797
  • Hawaii - 89,726
  • Idaho - 132,150
  • Illinois - 663,792
  • Indiana - 366,863
  • Iowa - 244,348
  • Kansas - 222,393
  • Kentucky - 245,686
  • Louisiana - 291,204
  • Maine - 99,890
  • Maryland - 352,154
  • Massachusetts - 412,578
  • Michigan - 577,554
  • Minnesota - 352,260
  • Mississippi - 194,874
  • Missouri - 368,483
  • Montana - 109,925
  • Nebraska - 147,069
  • Nevada - 110,918
  • New Hampshire - 90,274
  • New Jersey - 658,276
  • New Mexico - 125,637
  • New York - 940,500
  • North Carolina - 526,784
  • North Dakota - 78,403
  • Ohio - 652,707
  • Oklahoma - 246,521
  • Oregon - 238,417
  • Pennsylvania - 822,425
  • Rhode Island - 57,643
  • South Carolina - 252,999
  • South Dakota - 79,056
  • Tennessee - 344,829
  • Texas - 1,099,900
  • Utah - 156,320
  • Vermont - 55,606
  • Virginia - 462,751
  • Washington - 373,101
  • Washington, DC - 28,266
  • West Virginia - 124,958
  • Wisconsin - 405,793
  • Wyoming - 65,002
  • Alberta - 222,168
  • British Columbia - 303,219
  • Manitoba - 66,032
  • New Brunswick - 52,787
  • Newfoundland and Labrador - 35,063
  • Nova Scotia - 63,557
  • Northwest Territories - 7,312
  • Nunavut - 1,637
  • Ontario - 611,967
  • Prince Edward Island - 13,232
  • Quebec - 386,765
  • Saskatchewan - 93,438
  • Yukon - 5,066
  • - 0

category

  • Agriculture - 351,512
  • Business Services - 2,369,459
  • Community Services - 1,265,637
  • Construction - 1,391,471
  • Education - 1,033,524
  • Finance - 1,314,510
  • Government - 1,219,636
  • Health & Medical - 1,655,277
  • Industry - 854,470
  • Manufacturing - 307,842
  • Motorized Vehicle - 1,099,297
  • Personal Services - 1,225,780
  • Professional - 639,712
  • Real Estate - 431,584
  • Restaurants/Food & Dining - 823,004
  • Shopping & Shopping Services - 3,145,989
  • Transportation - 372,606
  • Travel & Tourism - 250,329
  • - 0

category_sub

  • Farm Equipment - 45,218
  • Forestry & Logging - 846
  • Livestock - 23,348
  • Advertising, Marketing & PR Services - 92,740
  • Business & Professional Associations - 62,841
  • Business Legal Services - 394,793
  • Communications Services - 189,987
  • Computer & Audio Visual Services - 45,389
  • Computer Services - 11,209
  • Computer System Design - 17,050
  • Consultants & Services - 299,038
  • General Business Services - 286,587
  • Management Consultants & Services - 133,786
  • Miscellaneous Business Services - 20,166
  • Printing & Publishing Services - 52,247
  • Repair Services - 249,978
  • Security Services - 72,133
  • Staffing & Support Services - 65,690
  • Arts & Culture - 96,179
  • Community & Recreational Facilities - 60,713
  • Foundations, Clubs, Associations, Etcetera - 170,116
  • Religious Organizations - 426,287
  • Social Services & Welfare - 401,775
  • Utilities - 109,763
  • Builders & Contractors 1 Of 2 - 765,314
  • Builders & Contractors 2 Of 2 - 209,549
  • Building Supplies & Materials - 340,703
  • Construction Services - 75,905
  • Elementary Schools - 315,073
  • Secondary Schools - 289,853
  • Accounting, Auditing & Bookkeeping Services - 302,903
  • Financial Institutions - 258,863
  • Financial Services - 244,372
  • Insurance Carriers - 319,924
  • City & County Government - 612,853
  • Federal Government - 217,650
  • Miscellaneous Government - 78,965
  • National Government - 131,826
  • State Government - 161,688
  • Health And Medical Centers - 519,980
  • Health Care Information & Services - 70,847
  • Healthcare Professionals - 972,355
  • Environmental Products - 24,871
  • Fuel - 65,927
  • Industrial Contractors - 95,349
  • Industrial Goods & Products - Hard Goods - Large - 60,196
  • Machinery, Equipment & Supplies - Business Production Related - 44,938
  • Machinery, Equipment & Supplies - Construction/Contractor Related - 70,181
  • Marine Products And Services - 4,669
  • Building Hardware & Materials - 35,678
  • Manufacturing Products - 44,595
  • Oil And Petroleum Products - 779
  • Publishing & Printing Manufacturers - 52,580
  • Wood Products Manufacturers - 1,761
  • Auto Maintenance & Repair Services - 359,789
  • Auto Services - 204,414
  • Automotive Parts, Equipment & Supplies - 248,492
  • Heavy & Industrial Vehicle Dealers - 8,519
  • Motorized Vehicle Rental & Leasing - 58,346
  • Passenger Vehicle Dealers - 154,811
  • Family Services & Care - 100,326
  • Fitness - 93,872
  • Garment & Linen Services - 106,929
  • Personal Care - 376,047
  • Personal Legal Services - 360,876
  • Legal Professionals - 368,113
  • Miscellaneous Professional - 106,267
  • Commercial & Industrial - 54,623
  • Real Estate Services - 244,583
  • Residential - 132,378
  • Casual Dining Restaurants - 346,974
  • Central American Restaurants - 53,507
  • Fish & Seafood Restaurants - 21,696
  • Air Conditioning & Heating Equipment & Supplies - 8,153
  • Electronics - 163,548
  • Flowers & Plants - 135,821
  • Food & Beverage Stores & Services - 320,602
  • Food & Beverages Wholesale & Retail - 116,395
  • Fuel Dealers - 23,353
  • General Merchandise Stores - 207,003
  • Hardware Stores - 84,067
  • Appliances Household & Commercial - 73,116
  • Lacquers Stains & Wood Finishes - 52
  • Masonry Materials & Supplies - 41,516
  • Nurseries & Garden Centers - 74,671
  • Other Building Materials - 56,394
  • Product Repair Services - 308,958
  • Specialty Stores - 702,318
  • Telecommunications - 58,253
  • Ground Transportation, Except Passenger - 182,627
  • Transportation Facilities & Services - 38,563
  • Transportation Rental & Leasing - 49,657
  • Water Transportation, Except Passenger - 12,562
  • Lodging - 167,131
  • Lawn & Garden Services - 43,956
  • Additional Educational Opportunities - 128,054
  • Administrative Organizations - 14,648
  • Insurance Services - 56,485
  • All-Terrain & Recreational Vehicle Dealers - 34,598
  • Work, Utility & Commercial Vehicle Dealers - 6,166
  • Cleaning & Maintenance Services - 76,124
  • Chemicals & Related Products - 10,268
  • Entertainment & Recreation - 83,324
  • Cards Stationery & Giftwrap - 82,104
  • Glass & Glass Products - 41,889
  • Ornamental Nursery - 44,179
  • Engineer & Architect Services - 107,452
  • Investment Services & Advisors - 131,963
  • Industrial Goods & Products - Hard Goods - Small - 105,994
  • Building & Homes Manufactures - 407
  • Miscellaneous Manufacturing - 22,729
  • Direct Selling Businesses - 1,464
  • Roofing Materials - 8,063
  • Tourist Attractions - 22,386
  • Industrial Goods & Products - Soft - Large & Small - 45,214
  • Mining - 17,554
  • Drinking Establishments - 69,673
  • Colleges & Universities - 181,024
  • Photography - 54,775
  • Animals - 35,337
  • Landscaping - 74,625
  • Miscellaneous Agriculture - 9,473
  • Charitable & Non-Profit Organizations - 30,887
  • Computer Networks - 17,770
  • Decorating & Designing Services - 38,625
  • Graphic Designer & Artist Services - 25,443
  • Internet Services - 49,620
  • Packaging, Shipping & Labeling Services - 27,164
  • Research Services - 42,463
  • Educational Facilities - 5,506
  • Preschools - 51,260
  • Religious Education - 11,030
  • Healthcare Consultants - 10,841
  • Medical Equipment & Supplies - 81,254
  • Industrial Machinery & Equipment - 53,885
  • Industrial Machinery Equipment & Supplies Rental & Leasing - 28,570
  • Machinery, Equipment & Supplies - Business Supplies Related - 71,879
  • Refuse Systems - 5,021
  • Scientific Equipment & Services - 1,429
  • Storage And Warehousing - 97,443
  • Apparel Manufacturers - 14,649
  • Chemical Product Manufacturers - 6,813
  • Electronics Manufacturers - 8,284
  • Finished Textiles Manufacturers - 8,827
  • Fitness & Beauty - 1,149
  • Food Product Manufacturers - 26,872
  • Paper & Cardboard Manufacturers - 27,468
  • Transportation Equipment Manufacturers - 15,620
  • Employment Assistance - 13,517
  • Entertainment Services - 14,765
  • Miscellaneous Personal Services - 43,067
  • Party & Event Planning - 20,712
  • Personal Financial Services - 7,444
  • Professionals Equipment & Supplies - 66,476
  • Asian Restaurants - 61,917
  • Bakeries - 65,251
  • Breakfast Restaurants - 5,189
  • European Cuisine - 45,205
  • Food Services - 108,066
  • North American Restaurants - 6,457
  • Snacks & Desserts - 27,245
  • Arts & Crafts - 36,639
  • Commercial Equipment - 78,311
  • Computers Electronics - 80,980
  • Drains, Pipes & Sewage Materials - 2,239
  • Games & Hobbies - 34,927
  • Garage, Door & Window Products - 43,328
  • Home Improvement Centers - 4,130
  • Kitchen & Bath Products & Supplies - 27,131
  • Lumber & Lumber Products - 18,346
  • Music - 37,370
  • Outdoor Equipment & Accessories - 29,508
  • Pets - 34,589
  • Prefabricated Buildings - 2,167
  • Product Rental & Leasing - 46,657
  • Passenger Air Transportation - 9,402
  • Passenger Ground Transportation - 54,575
  • Travel Arrangement & Services - 41,320
  • Agricultural Crops - 5,214
  • Farms - 42,949
  • Copying & Duplicating Services - 23,916
  • Rental & Leasing Business Equipment - 6,367
  • Administrative Professionals - 32,776
  • Aerospace Industry - 2,996
  • Exporters - 8,403
  • Hauling And Shipping - 7,426
  • Importers - 12,214
  • Scrap & Waste Materials - 13,177
  • Tobacco Products - 1,220
  • Aviation & Avionics Sales - 3,066
  • Personal Watercraft Dealers - 20,791
  • Catalog, Mail-Order, & Electronic Shopping - 3,012
  • Durable & Non Durable Goods & Products - 9,259
  • Flooring Materials - 6,672
  • Paint & Painting Supplies - 18,541
  • Siding Materials - 2,773
  • Passenger Water Transportation - 12,215
  • Hunting Trapping & Game Propagation - 4,015
  • Computer Graphics - 2,796
  • Business Wholesale - 3,811
  • Electrical Goods - 480
  • Religious Practitioners - 17,334
  • Merchandise Sales Events - 10,653
  • Forestry & Lumbering - 8,334
  • Miscellaneous Industry - 9,350
  • Agricultural Services - 11,093
  • Forestry Services - 2,521
  • Insulation & Energy Conservation Materials - 3,053
  • Wallpaper & Wallcoverings - 3,458
  • Writing Services - 2,259
  • Education Services - 3,804
  • Political Organizations - 5,392
  • Medical Equipment Manufacturers - 1,634
  • Recreational Good Manufacturers - 1,964
  • Public Administration - 1,420
  • Video, Television And Movies - 24,329
  • Building Restoration Equipment - 4
  • Air Transportation, Except Passenger - 5,605
  • Plastic Products Manufacturers - 7,000
  • Stone And Glass Products - 1,695
  • Art - 7,148
  • Recreational Services - 17,606
  • Furniture Manufacturers - 6,158
  • Household Services - 4,447
  • Bottling Manufacturing - 4,501
  • Machinery And Equipment Manufacturers - 8,815
  • Tribal Government - 8,975
  • Fine Dining Restaurants - 4,360
  • Computer Data Base Service - 806
  • Science & Research - 889
  • Ethnic Restaurants - 2,034
  • Middle Eastern Restaurants - 3,398
  • Steel Products - 588
  • Paneling Materials - 142
  • Transportation Repair & Maintenance - 2,294
  • Theme & Entertainment Restaurants - 857
  • Historical Places & Services - 1,886
  • Computer Manufacturers - 2,015
  • Air Purification Systems - 626
  • Fencing & Gate Materials - 5,811
  • Health & Safety Industrial - 1,371
  • Metal Products - 834
  • Instrument Manufacturers - 308
  • Leather Goods - 1,209
  • South American Restaurants - 773
  • Moldings Materials - 1,631
  • Transportation Equipment And Supplies (Except Motor Vehicle) - 4,427
  • Transportation Equipment - 288
  • Aviation & Aerospace Equipment & Supplies - 332
  • Small Business Services - 163
  • Plastering Stucco Caulking & Grouting Materials - 401
  • Law Enforcement Professional - 109
  • Transportation Inspection Services - 679
  • Rubber Products - Manufacturers - 294
  • Personal Document & Information Services - 506
  • Farm Products Raw Materials - 668
  • Political & Ideological Organizations - 766
  • Marketing - 81
  • Foreign Government - 2,287
  • Audio & Visual Equipment Manufacturers - 771
  • Sporting Goods Manufacturers - 1,135
  • Solar Products & Services - 1,711
  • Heavy & Industrial Vehicle Parts & Accessories - 305
  • Lawn & Yard - 153
  • Business Networking - 54
  • Educational Aids & Electronic Training Materials - 496
  • Musical Instrument Manufacturers - 713
  • Biotechnology - 323
  • African Restaurants - 279
  • Investigative Services - 40
  • Mentoring - 38
  • Restaurant Information & Referral Service - 123
  • Waste Treatment Plants Manufacturers - 46
  • - 0

Miscellaneous

Notes:

  • 100% of the records have a phone number.
  • 35.1% of the records have a website address.
  • 99.2% of the records have a latitude.
  • 99.2% of the records have a longitude.
  • 1% of the records have a fax number.
  • 34.6% of the records have a contact person.
  • 100% of the records have a street address.
  • 99.3% of the records have a zip code.
  • 75.0% of the records have an extended zip code.
  • 30.4% of the records have an estimated number of employees.

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and 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. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

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. How many days are there in a week? Use 1, 2, 3, ... to answer.

    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.