Puerto Vallarta

Steubenville, OH 43952 · O3f1d7f2fcf26 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: 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
Puerto Vallarta 1 other
the most common name a source states
puerto vallarta mexixan restaurant steubenville doordash
Street
4101 Sunset Boulevard 1 other
ubereats
4101 Sunset Blvd doordashoverture ×2
City
Steubenville
ubereatsno other value
State
OH
ubereatsno other value
ZIP
43952
ubereatsno other value
Pin
40.37669, -80.67532 map
ubereatsno other value
Phone
7402646001
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O96a3417b8de0; O9c9a8f0713e6

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
doordashpuerto vallarta mexixan restaurant steubenville
40514323
4101 Sunset Blvd, Steubenville, OH, 4395240.37683, -80.675412026-10-082026-11-02
overturePuerto Vallarta
43120ff8-1910-4daf-88e3-eca38382d38e
4101 Sunset Blvd, Steubenville, OH, 43952740264600140.37671, -80.675322026-11-062026-11-06
ubereatsPuerto Vallarta
HAXQPQk3SzqNThfuZWRMVA
4101 Sunset Boulevard, Steubenville, OH, 4395240.37669, -80.675322026-10-112026-10-11

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 Puerto Vallartaubereats Puerto Vallarta1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
doordash puerto vallarta mexixan restaurant steubenvilleubereats Puerto Vallarta0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Same name (Puerto Vallarta, with a typo'd slug suffix) at the same street address, 4101 Sunset Blvd, Steubenville, only 18 m apart, and the only business our data holds at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records place Puerto Vallarta at 4101 Sunset Boulevard in Steubenville, OH, ZIP 43952, with coordinates about 18 m apart, and no other business is held at that address, so the names agree despite the slug's 'mexixan restaurant' suffix.
  • Claude Haiku 5.5, prompt v4: same, 95% confident — Both records name Puerto Vallarta at 4101 Sunset Boulevard in Steubenville, OH, with coordinates about 18 m apart, and no other businesses are held at that address, so the DoorDash slug and the Uber Eats name refer to the same restaurant.
pair 4d0d6bafbdb788906b4e

Attributes

Channel
on_premise · restaurant — ubereats-type
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": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
38 within 1 mi · 100 within 3 mi
Off / on premise
9 / 20 within 1 mi · 31 / 47 within 3 mi
Selling alcohol
19 within 1 mi · 53 within 3 mi
Nearest
same channel 0.11 mi · licensed 2.82 mi
Setting
suburban (622 people per sq mi)
People within 3 mi
17,587 (13,412 adults 21+, 7,606 households) from 6 tract(s), tracts within 3 mi
Income
per capita $34,684 · median household ~$65,366 (weighted mean of tract medians)
Age and education
median age ~43.1 · bachelor's or higher 31%
Ethnicity
Hispanic 4% · White 85% · Black 8% · Asian 1%
Adults per alcohol outlet
253
Alcohol spend within 3 mi
$4,019,351 a year ($1,941,205 at home, $2,076,093 away) · $75,837 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

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 43120ff8-1910-4daf-88e3-eca38382d38e ↔ ubereats HAXQPQk3SzqNThfuZWRMVAsame address and namemerged11
2026-11-02 23:02backfilldoordash 40514323 ↔ ubereats HAXQPQk3SzqNThfuZWRMVAClaude judge: samemerged