Outlets /
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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | The Bottleshop Of Pittsburgh | the most common name a source states | no other value |
| Street | 1597 Washington Pike, Suite A20 1 other | ubereats | 1597 Washington Pike ubereats |
| City | Collier | ubereats | no other value |
| State | PA | ubereats | no other value |
| ZIP | 15017 | ubereats | no other value |
| Pin | 40.38166, -80.09561 map | ubereats | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ubereats | The Bottleshop Of Pittsburgh 7fdoLXXSRESvZvNDOEsnQg | 1597 Washington Pike, Suite A20, Collier, PA, 15017 ZIP lookup: Bridgeville, PA | 40.38166, -80.09561 | 2026-10-20 | 2026-10-20 | |
| ubereats | The Bottleshop Of Pittsburgh EZHqm9K-S--qxNyA8SsRDQ | 1597 Washington Pike, Suite A20, Collier, PA, 15017 ZIP lookup: Bridgeville, PA | 40.38166, -80.09561 | 2026-11-02 | 2026-11-03 | |
| ubereats | The Bottleshop Of Pittsburgh JUiyNw_KQuC0VRcflTDjIQ | 1597 Washington Pike, Collier, PA, 15017 ZIP lookup: Bridgeville, PA | 40.38166, -80.09561 | 2026-10-14 | 2026-10-20 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| overture Pittsburgh Bottleshop | ubereats The Bottleshop Of Pittsburgh | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00 |
| overture Pittsburgh Bottleshop | ubereats The Bottleshop Of Pittsburgh | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00 |
| overture Pittsburgh Bottleshop | ubereats The Bottleshop Of Pittsburgh | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00 |
| doordash the bottleshop of pittsburgh bridgeville | ubereats The Bottleshop Of Pittsburgh | 0.72 | Claude judge: same | held 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:
pair 92b3b0ab4e45591d04b1 |
| doordash the bottleshop of pittsburgh bridgeville | ubereats The Bottleshop Of Pittsburgh | 0.72 | Claude judge: same | held 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:
pair 83ddb306ac0e903de3c8 |
| doordash the bottleshop of pittsburgh bridgeville | ubereats The Bottleshop Of Pittsburgh | 0.72 | Claude judge: same | held 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:
pair 7b2945c08f5c373b8cc0 |
| ubereats The Bottleshop Of Pittsburgh | ubereats The Bottleshop Of Pittsburgh | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| ubereats The Bottleshop Of Pittsburgh | ubereats The Bottleshop Of Pittsburgh | 1.00 | one store listed twice | merged | same 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-06 18:13 | insert | overture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats EZHqm9K-S--qxNyA8SsRDQ | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats JUiyNw_KQuC0VRcflTDjIQ | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture ce90971f-706f-4512-b015-eceb11d0c12e ↔ ubereats 7fdoLXXSRESvZvNDOEsnQg | same address and name | held: same-source-conflict | 11 |
| 2026-11-03 13:33 | backfill | ubereats 7fdoLXXSRESvZvNDOEsnQg ↔ ubereats EZHqm9K-S--qxNyA8SsRDQ | one store listed twice | merged | |
| 2026-11-02 23:02 | backfill | doordash 30930489 ↔ ubereats 7fdoLXXSRESvZvNDOEsnQg | Claude judge: same | held: same-source-conflict | |
| 2026-11-02 23:02 | backfill | doordash 30930489 ↔ ubereats EZHqm9K-S--qxNyA8SsRDQ | Claude judge: same | held: same-source-conflict | |
| 2026-11-02 23:02 | backfill | doordash 30930489 ↔ ubereats JUiyNw_KQuC0VRcflTDjIQ | Claude judge: same | held: same-source-conflict | |
| 2026-10-20 21:04 | backfill | ubereats 7fdoLXXSRESvZvNDOEsnQg ↔ ubereats JUiyNw_KQuC0VRcflTDjIQ | one store listed twice | merged |