Pennsylvania Business Listings Database v.2.0.0
399,562 Business locations
AccountWelcome, guestSign in / Register
Pennsylvania business locations, organized for practical use Explore 399,562 Pennsylvania business-location records with names, published street addresses, locality labels, ZIP codes, coordi...
Ready for your workflow
![]() |
PENNSYLVANIA BUSINESS DIRECTORY USAGE LICENSE $200.00 |
PENNSYLVANIA CONTACTS AND CLASSIFICATIONS PUBLICATION LICENSE $400.00 |
COMPLETE PENNSYLVANIA BUSINESS DATA MASTER LICENSE $800.00 |
| Data Modification | ![]() |
![]() |
![]() |
| Importing | ![]() |
![]() |
![]() |
| Exporting | ![]() |
![]() |
![]() |
| Merge | ![]() |
![]() |
![]() |
| Web Usage | ![]() |
![]() |
![]() |
| Multiple PC's or Websites | ![]() |
![]() |
![]() |
| Mobile Development | ![]() |
![]() |
![]() |
| Updates Available | ![]() |
![]() |
![]() |
| Included file formats | CSV, JSON, SQLite | CSV, JSON, SQLite | CSV, JSON, SQLite |
| Custom File Formats | ![]() |
![]() |
![]() |
| Distribution | ![]() |
![]() |
![]() |
| Copyright Endorsement | ![]() |
![]() |
![]() |
| BUY NOW | BUY NOW | BUY NOW |
Explore 399,562 Pennsylvania business-location records with names, published street addresses, locality labels, ZIP codes, coordinates and county geography. Build searchable directories, compare regional coverage, research business markets and connect location records to your own systems.
Pennsylvania Business Directory includes the location table and point-derived county names and FIPS codes. Pennsylvania Contacts and Classifications adds published phone, website, email and social channels plus category relationships. Complete Pennsylvania Business Data adds brand summaries, brand-to-location relationships and 2,415 dated historical contact facts for 2,232 current locations.
The August 2026 directory snapshot covers commercial and service destinations across 67 Pennsylvania counties. Every retained coordinate falls within a Pennsylvania county polygon in the 2025 Census boundary source. Locations are not unique legal companies, and a business with multiple locations can appear more than once.
Operating status distinguishes reported open from unreported. Contacts are published but not independently tested or opted-in leads. Address and coordinate precision varies. Historical contact supplements are dated 2015 and require verification. No employee counts, revenue, hours or live availability are promised.
Every tier includes matching UTF-8 CSV, JSON and SQLite, a field dictionary, schemas, representative samples, table statistics and source documentation. ZIP and FIPS codes remain text. Missing values are documented consistently across formats.
Release structure
Review the published tables, record coverage, and field names included with release 2.0.0.
Data dictionary
| Table | Records | Fields |
|---|---|---|
| locations | 399562 | location_id, location_name, brand_name, address_line_1, city, region_code, postal_code, country_code, county_fips, county_name, latitude, longitude, business_category, operating_status, geographic_status |
| contacts | 1127461 | contact_id, location_id, contact_type, contact_value, verification_status |
| classifications | 688026 | category_id, location_id, category_name, category_role |
| brands | 7138 | brand_id, brand_name, listed_location_count, city_count, relationship_status |
| brand_locations | 46398 | brand_location_id, brand_id, location_id |
| historical_contacts | 2415 | historical_fact_id, location_id, field_name, fact_value, as_of_date, verification_status |
Release at a glance
399,562 Pennsylvania business-location directory records with point-derived county geography, published contacts and classifications.
Showing the 12 largest groups from 67 represented values.
Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.
Inspect the data
Switch tables to review representative fields and rows from every table advertised for this release.
| location_id | location_name | brand_name | address_line_1 | city | region_code | postal_code | country_code | county_fips | county_name | latitude | longitude | business_category | operating_status | geographic_status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 000046d7ee433f9060607c83 | Young Brothers Flooring | 8232 Perry Hwy | Pittsburgh | PA | 15237-5216 | US | 42003 | Allegheny County | 40.5573993 | -80.0391437 | hardware home and garden store | reported_open | point_within_2025_census_county | |
| 0d8806dd718a513df25bd405 | Fabled Table | 1400 Buena Vista St | Pittsburgh | PA | 15212 | US | 42003 | Allegheny County | 40.4566205 | -80.0142959 | event or party service | reported_open | point_within_2025_census_county | |
| 1b19b998b37a8dc1f59ce755 | Workzone | 16 Township Line Rd | Blue Bell | PA | 19401 | US | 42091 | Montgomery County | 40.1496168 | -75.309494 | technical service | reported_open | point_within_2025_census_county | |
| 2885f6d4f9e6083a1396520a | My Home Property Management, LLC | 55 W High St | Elizabethtown | PA | 17022 | US | 42071 | Lancaster County | 40.151052 | -76.6074132 | real estate service | reported_open | point_within_2025_census_county | |
| 361d42870915b53249d12a53 | UPMC Eye Center Eye Care & Optical | 3616 Forbes Ave | Pittsburgh | PA | 15213-3407 | US | 42003 | Allegheny County | 40.440898 | -79.957666 | vision or eye care clinic | reported_open | point_within_2025_census_county | |
| 438d8270034711372d780b76 | NAPA Auto Parts | NAPA Auto Parts | 1301 Jackson Ave | Windber | PA | 15963-1795 | US | 42111 | Somerset County | 40.2296762 | -78.7702895 | vehicle parts store | not_reported | point_within_2025_census_county |
| 50ffead155f9857e7754e2a8 | Relax With Remy Pet Spa | 1111 Richmond Rd | Chanceford Twp | PA | 17356 | US | 42133 | York County | 39.9231446 | -76.5039025 | animal or pet service | reported_open | point_within_2025_census_county | |
| 5e95e3ae53f85f3d27eafabb | Carol Whitehead Custom Framing | 335 1st St #3101 | Aspinwall | PA | 15215 | US | 42003 | Allegheny County | 40.4899415 | -79.9013534 | arts crafts and hobby store | reported_open | point_within_2025_census_county | |
| 6c33bc6e90dab9c4b358476f | Keller Williams Real Estate | 2400 Bristol Rd | Bensalem | PA | 19020 | US | 42017 | Bucks County | 40.1316834 | -74.9248447 | real estate service | not_reported | point_within_2025_census_county | |
| 798f19ed228f314f9ac81503 | Gilbert's Ballroom | 705 E 11th St | Chester | PA | 19013-6120 | US | 42045 | Delaware County | 39.8581017 | -75.3527232 | event venue | reported_open | point_within_2025_census_county | |
| 870e97882244f7a318130908 | Natalia Hanson, MD | 10 Gateway Dr | Reedsville | PA | 17084 | US | 42087 | Mifflin County | 40.666321 | -77.607265 | outpatient care facility | reported_open | point_within_2025_census_county | |
| 9462f13d6804ccd9041d0638 | Supreme Heating & Cooling LLC | 1475 Frey Rd | Pittsburgh | PA | 15235 | US | 42003 | Allegheny County | 40.4741154 | -79.8245568 | home service | not_reported | point_within_2025_census_county | |
| a1c2244605ffc05787bdf444 | Mountainville Car Wash | 1929 S 5th St | Allentown | PA | 18103 | US | 42077 | Lehigh County | 40.5791368 | -75.456225 | automotive service | reported_open | point_within_2025_census_county | |
| af2021742c655aecfe1ec6d0 | David C Neuschwander, MD | 4262 Old William Penn Hwy Ste 110 | Murrysville | PA | 15668 | US | 42129 | Westmoreland County | 40.4283252 | -79.6834531 | specialized health care | reported_open | point_within_2025_census_county | |
| bc88e0f80611f9584f342d89 | Girl Code Hair Studio | 5132 Market St | Philadelphia | PA | 19139 | US | 42101 | Philadelphia County | 39.9597081 | -75.224163 | personal or beauty service | reported_open | point_within_2025_census_county | |
| c9feb9e0f22e12b67235b5d4 | Wet Noses and Whiskers | 1303 Chicora Rd | Donegal Twp | PA | 16025 | US | 42019 | Butler County | 40.9454643 | -79.764111 | animal or pet service | reported_open | point_within_2025_census_county | |
| d7788c92e782df4f7e6f40ed | Pittsburgh Orthodontic Group | 850 Clairton Blvd Ste 3200 | Pittsburgh | PA | 15236 | US | 42003 | Allegheny County | 40.322344 | -79.944118 | dental clinic | reported_open | point_within_2025_census_county | |
| e4ece102c537147ba8b7d4b0 | Dennis P. Mchugh, Do | 716 W Germantown Pike | East Norriton | PA | 19403-4255 | US | 42091 | Montgomery County | 40.152232 | -75.352039 | surgery | reported_open | point_within_2025_census_county | |
| f27320e6eadd8269d6666dae | Weaver Memorials | Weaver Memorials | 126 Main St | Strausstown | PA | 19559 | US | 42011 | Berks County | 40.4933839 | -76.1829663 | family service | reported_open | point_within_2025_census_county |
| fffff3eeaa31e3f2b97a2397 | Sails Inn | 277 N Gallatin Ave | Uniontown | PA | 15401-2957 | US | 42051 | Fayette County | 39.910903 | -79.7200311 | restaurant | reported_open | point_within_2025_census_county |
| contact_id | location_id | contact_type | contact_value | verification_status |
|---|---|---|---|---|
| 00000f8b36a676eaf152e58c | 27807292f08ff2ff6105d625 | phone | +16106164509 | published_unverified |
| 0d76e41b1501bf9508c6dedc | bc3a92291f9d99e9a9fda6d0 | [email protected] | published_unverified | |
| 1acd7d2b989c583e7985d48a | 6d8a1bf05c8f934f4f7654c7 | website | http://www.walborninsurance.com/ | published_unverified |
| 28407d96b717fc13828f1df9 | 5aaf87d4754e3efc404889f4 | phone | +14126831290 | published_unverified |
| 35b89e3a03b1c41f9dfee57f | 04531c83887454f80d33af49 | website | https://northern-beer-traders.hub.biz | published_unverified |
| 431353ecd909bdd544ae157f | 9e5a77b00a26410139bc8f69 | [email protected] | published_unverified | |
| 5099c320c8d83c88575d5ae3 | f14f552d3ec150cd3f3fbcb0 | social | https://www.youtube.com/user/SpeedwayCStores | published_unverified |
| 5e1c151d3a673b896e537325 | ca031f01e9887f4ace1a7152 | phone | +17246585750 | published_unverified |
| 6ba8e64af978db7b3ae5d98c | dfe8e36a9fcf77a0ffaa65c3 | phone | +14126825531 | published_unverified |
| 792d674122e157eefd491b5d | 55e6fe2d6d1bb2972ca21f69 | phone | +17177555878 | published_unverified |
| 869a568c774cc125e5bb2512 | 73268b15f455eeecb832d056 | [email protected] | published_unverified | |
| 94203c9de19aabd4b795636f | c4407109498a7cc24cfb0b87 | [email protected] | published_unverified | |
| a181467f12bc026f3f4a92b5 | fef9a5d4cc1d88bef871baed | website | https://www.vrbo.com/4248624ha | published_unverified |
| aefac650aaf5a6cd1f164952 | b19e8eba75337ff6559c5852 | phone | +14454445374 | published_unverified |
| bc5d495edd4dcc6fe446c49f | 37947a76e906b36a35f59af4 | [email protected] | published_unverified | |
| c9dc090cea2d1b1e68b7256f | 2d04ec4174ffd09af354e6f3 | website | http://www.citgo.com/ | published_unverified |
| d7640ab923e4345d833b3848 | fcf9d077154352f97ec66994 | website | http://www.vfrepettocoinc.com | published_unverified |
| e4d73a189ff863514b8516e1 | 9ac280451df7bf93fc295d53 | social | https://www.facebook.com/1029547053809975 | published_unverified |
| f256c3f09b137580dee20ef5 | 8566c7cb584ac83a51866c21 | phone | +12153574650 | published_unverified |
| fffff6103ab4b0c4d6ed39fb | 4360b952c2b8c4e2a65621e7 | phone | +15702439688 | published_unverified |
| category_id | location_id | category_name | category_role |
|---|---|---|---|
| 00000bb06c0f8d6c57c7c105 | 26c3ac9e28bc05926470b785 | financial service | basic |
| 0d86d5c846e720b23a023d91 | c27f59e16c69a35021a235a1 | home service | basic |
| 1aefff4f3ca24d7a11a151e6 | 079e16dfddfa6dc27a1d7429 | private association | primary |
| 285aaa1cd39cea16d2a3e3d8 | 4de15bb9ef96c03769cdea16 | countertop installation | primary |
| 35bdccf759e9b075d2f0ad95 | 71ffba57eaa35fd9257b5acd | professional service | basic |
| 4320aa1eb3605dad57cbe954 | 1415a3da7d64f362a0aebda4 | surgery | basic |
| 50ad8dedf2ce7fb082032685 | d291fc5602de132990cb5ccb | pet breeder | primary |
| 5e3bd15e9c12649a54b86c7f | c3abcdea5a141c125ef98f23 | life insurance | primary |
| 6bb4082e7d31b46988c10f67 | 60068d0ddf07237119f853c9 | diner | primary |
| 79279813edee37a800c53d0c | 4c2042c47e068a72ee3d23e4 | warehouse club store | primary |
| 86959bfa336b43fe0e6a5621 | 479a321cc30603a2ef9a828b | physical medicine and rehabilitation | basic |
| 93f052751e867682d0c5cad7 | 7ca09975fea7b754722d45ea | auto dealer | primary |
| a16b02d434a873826b2d7835 | dec8298099ddad124718633e | farm | primary |
| aeccb5a5d7c018e53b32b2f1 | 6e3c2e296ee3270c9a483329 | information technology company | primary |
| bc60400c6e6b3590d0722da6 | b4827b7125801ef9377e0af4 | credit and debt counseling | primary |
| c9dc97e3aeaf86e1764d9862 | 6a5939c79b39e1d3b34c7589 | discount store | primary |
| d763a83c0da50fff6b10553f | 7dbeafbbddcce8c337d569cb | bank or credit union | primary |
| e4ff927c5513da984fee6cd1 | cd9c63bc2a2be41c89a577d8 | food and beverage store | basic |
| f284af297fc41097722b9529 | 3d8ee76862ce7bb386ab866c | hardware home and garden store | basic |
| ffffe37306a9580828100a88 | 7a08c2a2770127cc0da85cc7 | second hand store | basic |
| brand_id | brand_name | listed_location_count | city_count | relationship_status |
|---|---|---|---|---|
| 000815c2c306c1231f01eeed | Yocco's Hot Dogs | 2 | 2 | reported_brand_not_verified_ownership |
| 0d73d059b24eb94be59c75f0 | Groomingdales | 2 | 2 | reported_brand_not_verified_ownership |
| 19e4f684f087a9e793625ff7 | Bella’s Blooms Flower Co. | 1 | 1 | reported_brand_not_verified_ownership |
| 27ebe50ee0cd93c0c8d66393 | Northern Nurseries | 1 | 1 | reported_brand_not_verified_ownership |
| 3521947982b09a05ff115478 | EverTrue Buffalo Valley Lutheran Village | 4 | 4 | reported_brand_not_verified_ownership |
| 426aaf3202f72f7c7fc151aa | Joe's Pizza | 1 | 1 | reported_brand_not_verified_ownership |
| 4fcbb41a9d319a20f16a83d1 | June Hines Pilates | 3 | 2 | reported_brand_not_verified_ownership |
| 5e322a75dfc7f2ff819bd878 | Shoppers World: Always New, Always For Less - Everyday Savings | 1 | 1 | reported_brand_not_verified_ownership |
| 6ba953677269473119ef4897 | Braskem | 3 | 2 | reported_brand_not_verified_ownership |
| 7867b248d406bd0a77cafa0a | Au vieuxfournil | 1 | 1 | reported_brand_not_verified_ownership |
| 868a8f5f2cc0e77f7d2f5f13 | Reebok | 2 | 2 | reported_brand_not_verified_ownership |
| 938979ce5571da618a275992 | Trillium Energy Solutions | 5 | 5 | reported_brand_not_verified_ownership |
| a1eb59bfa85aa2699acdde74 | Leonard's Auto Tag Service | 4 | 4 | reported_brand_not_verified_ownership |
| afa95453e0670cfc424a499d | SecureSpace Self Storage | 5 | 4 | reported_brand_not_verified_ownership |
| bc37017947798c1271a33b23 | Motherhood Maternity | 1 | 1 | reported_brand_not_verified_ownership |
| ca20fb4d72c1886afb486f3f | Hyatt Centric | 1 | 1 | reported_brand_not_verified_ownership |
| d7ea76aab76b09ecb37f1d77 | Haun Welding Supply & Haun Specialty Gases | 1 | 1 | reported_brand_not_verified_ownership |
| e5308fafa79800c27b8de3c3 | Sarah Reed Children's Center | 3 | 2 | reported_brand_not_verified_ownership |
| f260f232dd89f6af1f316a2b | OneMain Financial | 37 | 35 | reported_brand_not_verified_ownership |
| fffcc3fab158557934b59b17 | Preferred Home Health Care & Nursing Services Pennsylvania | 3 | 3 | reported_brand_not_verified_ownership |
| brand_location_id | brand_id | location_id |
|---|---|---|
| 000044adaf08756f64613510 | b3f99d91ca44d3c10e72e8aa | 642b001bd1cf30add1e4c25d |
| 0dbb124f4561af8191f63690 | 6684afe681c780db8d67fd9b | f010425ec2fc3469d03f91b9 |
| 1aec3e2dea2ddd37e04fa872 | c820e8d9de1e005fcce753da | 0cce73789b9eab789ec31002 |
| 28cadda129e07e374f8c0f48 | c820e8d9de1e005fcce753da | 62877489703ed9e36f25193a |
| 366db6a30d611bd096c5852c | 01df915fc97efacf5903a58f | 92e35b6f6d70185748502306 |
| 43f36a8fd783e6632df6b82e | f82ad4ecdc80d07f6ab9c60b | c08548d7bc512017727a6917 |
| 515690cdd9aebb3f68e57721 | e8ccd2ec23a8991364d0cac6 | de8e8edaa5e1474a3c4916ac |
| 5eb549b6249e83a2114dd505 | f7851c6250de10d71895c0d5 | 5e65d6cb35d0644445e13611 |
| 6be35c3cf29c9bddc53a2746 | 789b4f5426f445baab12f5f1 | 74961a341a244d5a4efada90 |
| 795a07e2605206a33ff7411e | 052202d700b5eed31ebd1b78 | 80560c5ad70e37df4457c727 |
| 86a008084f695a52a7908ad2 | fa540a923adccb0735ac7f5b | c17fc2adfd17a15298119c2b |
| 949a35462a80e32943d7dbfc | f764e13dfa0784119408ca7a | dfdefee1cc0c2e0b8a27c409 |
| a200bfdfe37fc360ab9e35e2 | c474f57ab72d99d1595b6d28 | e3bffb73a0080aa7da346c37 |
| af865548f01506707a9f70c1 | 6d6548092b3c91c1d7c802a8 | d9ae9d2e2f3b53d8294a755e |
| bce527a11224d1b1681d132d | f7098af9b595dac4811ed4a4 | 594e310de8b333e747bb4427 |
| ca25d8ccf5ed983340b8fda0 | c8980017461710494f7b2d2e | dba130e84d215a52adb9f454 |
| d826200d1d98a70330809d68 | 4868d07e144856103da945a6 | 47808db8cb9168e6d43e4649 |
| e57400cef1076148383eaa29 | c15b4d3649854707be93a923 | e3bf27e6d68ff7e3dd44c032 |
| f2a0a1091d3baf0f36db2522 | e8ebe9dfeb644227fe5d1ae9 | 66f7eb13f9519d043e43e0be |
| fffedf6025aa69120e351ecc | 3316222bcb0d24b2edc97070 | 666bd137160c26bc4a89d30c |
| historical_fact_id | location_id | field_name | fact_value | as_of_date | verification_status |
|---|---|---|---|---|---|
| 0002aad19b0b7571d8a59c99 | ca2b0f4970273c30bc18279f | website | http://www.allentown.citysearch.com/profile/external/46331041/allentown_pa/rite_aid.html | 2015-08-26 | historical_unverified |
| 0ff25d51e3578dd9068fedb8 | 22586daf3e31ff1eab617761 | website | http://www.butlerorthopedics.com/ | 2015-08-26 | historical_unverified |
| 1f84acfa23efddcde33dffae | 3d523a58b9933202b707fc8c | phone | (724) 776-2280 | 2015-08-26 | historical_unverified |
| 2dad14134c583a452b48c056 | 2f2ffef8c7a52306ebbf3268 | phone | (610) 631-6999 | 2015-08-26 | historical_unverified |
| 3b0f265ef7182563ba5db68c | 92eb0170bfe9c3507ec2671c | [email protected] | 2015-08-26 | historical_unverified | |
| 47eff1065ad37b7524ecbf41 | bcd45dabbe2bb23e3df8c09a | phone | (717) 362-7223 | 2015-08-26 | historical_unverified |
| 524e979097f4f08649a9bed5 | 0860e68a508e0aebf3ec9f5e | [email protected] | 2015-08-26 | historical_unverified | |
| 60091f3202d349f7ef8f26e5 | 326aabb378bcf6c8c3c4fcb2 | [email protected] | 2015-08-26 | historical_unverified | |
| 6c4940244a98b3b6a6306dd8 | 1fccceda545a31e361fc1bbb | website | http://www.upacreekinn.com | 2015-08-26 | historical_unverified |
| 796cac59c1915990acf06e1a | 409bcdfb50c681b62d1468cc | fax | (610) 358-1758 | 2015-08-26 | historical_unverified |
| 85e52f208ea37c684e76c2e6 | 2c6360a122440615ef985032 | [email protected] | 2015-08-26 | historical_unverified | |
| 926173cd25ea914745b2b0bd | 785de0e7938d67665088dfd4 | fax | (215) 234-8038 | 2015-08-26 | historical_unverified |
| 9ebb57662ebec3dd85f49a70 | c6f2325d2655cc62472b7c3f | phone | (215) 757-8877 | 2015-08-26 | historical_unverified |
| ab1e02dff9e20c4cde053fc3 | 962391d3e06878a27042a1d3 | website | http://www.allentown.citysearch.com/profile/external/8833248/hellertown_pa/h_r_block.html | 2015-08-26 | historical_unverified |
| b892153e7bb420e21cc3573d | 6e7a42c4911b114fb95fca55 | fax | (717) 627-4577 | 2015-08-26 | historical_unverified |
| c4c9ac86fdcc1e3c5afc4acc | bf309ae915ae775438428f22 | website | http://www.eriegymnastics.com | 2015-08-26 | historical_unverified |
| d326f5443b713b2b27042c8b | 7bd55f1d14829eb25c95a7bd | website | http://www.piperclassics.com | 2015-08-26 | historical_unverified |
| e20e88610784343276c98954 | fd9d0a642fa3252ed26f1aeb | phone | (814) 629-6561 | 2015-08-26 | historical_unverified |
| ef9372143d6ed25cb3e920fa | 26301e320f2cbca35a838c72 | website | http://www.contractors.com/NewHopeTreeLandscape | 2015-08-26 | historical_unverified |
| fff9517f80d91b72db3047e5 | c991e18435141e050e817a77 | [email protected] | 2015-08-26 | historical_unverified |
399,562 locations; 1,127,461 contacts; 688,026 classifications; 7,138 brands; 46,398 brand locations; 2,415 historical contacts. Locations are the primary count; linked contacts, classifications and brand relationships are not additional locations.