The Bottleshop Of Pittsburgh

Collier, PA 15017 · O2e0fe2807470 · first seen 2026-10-14
1 sourceunknownalcohol: unknown

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
The Bottleshop Of Pittsburgh
the most common name a source statesno other value
Street
1597 Washington Pike, Suite A20 1 other
ubereats
1597 Washington Pike ubereats
City
Collier
ubereatsno other value
State
PA
ubereatsno other value
ZIP
15017
ubereatsno other value
Pin
40.38166, -80.09561 map
ubereatsno other value
Phone
none
no other value
Licences
none on file
every licence and permit record in the outlet
Joined by singleton · absorbed ids: Od71e3e2e5fe5; O87bdb636ac49

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ubereatsThe Bottleshop Of Pittsburgh
7fdoLXXSRESvZvNDOEsnQg
1597 Washington Pike, Suite A20, Collier, PA, 15017
ZIP lookup: Bridgeville, PA
40.38166, -80.095612026-10-202026-10-20
ubereatsThe Bottleshop Of Pittsburgh
EZHqm9K-S--qxNyA8SsRDQ
1597 Washington Pike, Suite A20, Collier, PA, 15017
ZIP lookup: Bridgeville, PA
40.38166, -80.095612026-11-022026-11-03
ubereatsThe Bottleshop Of Pittsburgh
JUiyNw_KQuC0VRcflTDjIQ
1597 Washington Pike, Collier, PA, 15017
ZIP lookup: Bridgeville, PA
40.38166, -80.095612026-10-142026-10-20

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
overture Pittsburgh Bottleshopubereats The Bottleshop Of Pittsburgh1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00
overture Pittsburgh Bottleshopubereats The Bottleshop Of Pittsburgh1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00
overture Pittsburgh Bottleshopubereats The Bottleshop Of Pittsburgh1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00
doordash the bottleshop of pittsburgh bridgevilleubereats The Bottleshop Of Pittsburgh0.72Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The names match exactly (the DoorDash slug just has the city appended), and both records give 1597 Washington Pike in ZIP 15017 about 80 m apart. Although the building holds 3 businesses and only one
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records name The Bottleshop of Pittsburgh at 1597 Washington Pike in ZIP 15017 with coordinates about 80 m apart, and the doordash slug city Bridgeville matches the same Collier/Bridgeville area; the only mismatch is the suite on one side, so the name and address agreement points to one outlet despite three businesses at the address.
pair 92b3b0ab4e45591d04b1
doordash the bottleshop of pittsburgh bridgevilleubereats The Bottleshop Of Pittsburgh0.72Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The names agree exactly once DoorDash's appended city slug is set aside, and the street address, ZIP and coordinates (82 m apart) match; the suite on one side only and the shared building do not under
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records name The Bottleshop of Pittsburgh at 1597 Washington Pike in ZIP 15017 with coordinates about 80 m apart, and the DoorDash slug city Bridgeville matches the same Washington Pike location; the Uber Eats record adds Suite A20, which only one side names, so the building is shared but the name and address agree.
pair 83ddb306ac0e903de3c8
doordash the bottleshop of pittsburgh bridgevilleubereats The Bottleshop Of Pittsburgh0.72Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Same distinctive name (the DoorDash slug just appends the city), same street address and ZIP, and coordinates 82 m apart; Collier and Bridgeville are the same locality, and the matching names settle t
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records give the same street address and ZIP 15017 with about 82 m between coordinates, and the names match (The Bottleshop Of Pittsburgh); the city difference (Bridgeville vs Collier) is consistent with shared postal territory, though the building holds three businesses, so the matching name is what decides it.
pair 7b2945c08f5c373b8cc0
ubereats The Bottleshop Of Pittsburghubereats The Bottleshop Of Pittsburgh1.00one store listed twicemergedsame street + ZIP · name: identical
ubereats The Bottleshop Of Pittsburghubereats The Bottleshop Of Pittsburgh1.00one store listed twicemergedsame street + ZIP · name: identical

Attributes

Channel
unknown
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": []
}

Trade area

Other outlets
20 within 1 mi · 128 within 3 mi
Off / on premise
6 / 10 within 1 mi · 38 / 58 within 3 mi
Selling alcohol
7 within 1 mi · 38 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.38 mi
Setting
suburban (2,750 people per sq mi)
People within 3 mi
77,748 (60,260 adults 21+, 34,319 households) from 23 tract(s), tracts within 3 mi
Income
per capita $59,314 · median household ~$103,325 (weighted mean of tract medians)
Age and education
median age ~44.7 · bachelor's or higher 54%
Ethnicity
Hispanic 2% · White 83% · Black 3% · Asian 6%
Adults per alcohol outlet
1,586
Alcohol spend within 3 mi
$26,468,901 a year ($11,825,031 at home, $14,633,352 away) · $696,550 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-06 18:13insertoverture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats EZHqm9K-S--qxNyA8SsRDQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats JUiyNw_KQuC0VRcflTDjIQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats 7fdoLXXSRESvZvNDOEsnQgsame address and nameheld: same-source-conflict11
2026-11-03 13:33backfillubereats 7fdoLXXSRESvZvNDOEsnQg ↔ ubereats EZHqm9K-S--qxNyA8SsRDQone store listed twicemerged
2026-11-02 23:02backfilldoordash 30930489 ↔ ubereats 7fdoLXXSRESvZvNDOEsnQgClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfilldoordash 30930489 ↔ ubereats EZHqm9K-S--qxNyA8SsRDQClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfilldoordash 30930489 ↔ ubereats JUiyNw_KQuC0VRcflTDjIQClaude judge: sameheld: same-source-conflict
2026-10-20 21:04backfillubereats 7fdoLXXSRESvZvNDOEsnQg ↔ ubereats JUiyNw_KQuC0VRcflTDjIQone store listed twicemerged