PUERTO VALLARTA

NEWINGTON, CT 06111 · O1dad9508862f · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed1 licence

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 3 other
the most common name a source states
ESAUL LLC ct-dcp (legal name)
Puerto Vallarta Newington overture
puerto vallarta restaurant newington doordash
Street
2385 BERLIN TPKE
ct-dcpno other value
City
NEWINGTON
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06111
ct-dcpno other value
Pin
41.68685, -72.70872 map 2 other
doordash
107 m away ab-inbev
210 m away ct-dcp
Phone
8606678080
vtinfono other value
Licences
ct-dcp CT|LIR.0015959
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob65dd5c24d40; Oad341cd0ebf1; O87490abfad02; Oa754a564e6e3

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
ab-inbevPUERTO VALLARTA
180481
2385 BERLIN TPKE, NEWINGTON, CT, 0611141.68768, -72.708072026-11-112026-11-11
ct-dcpPUERTO VALLARTA
legal name: ESAUL LLC
CT|LIR.0015959
2385 BERLIN TPKE, NEWINGTON, CT, 0611141.68840, -72.707272026-11-032026-11-11
doordashpuerto vallarta restaurant newington
36357047
2385 Berlin Tpke, Newington, CT, 0611141.68685, -72.708722026-10-082026-11-12
overturePuerto Vallarta Newington
51757fc9-81d1-4312-bbfb-1e854aaaf407
2385 Berlin Tpke, Newington, CT, 06111860667808041.68694, -72.708772026-11-132026-11-13
vtinfoPUERTO VALLARTA
ca396b6f832bd5d0
2385 BERLIN TPKE, NEWINGTON, CT, 06111860667808041.68682, -72.708592026-11-112026-11-14

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
ab-inbev PUERTO VALLARTAct-dcp PUERTO VALLARTA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00
ab-inbev PUERTO VALLARTAvtinfo PUERTO VALLARTA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 104 m apart · name similarity 1.00
ct-dcp PUERTO VALLARTAvtinfo PUERTO VALLARTA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 207 m apart · name similarity 1.00
doordash puerto vallarta restaurant newingtonoverture Puerto Vallarta Newington0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.91 · same street + ZIP · pins 11 m apart · name similarity 0.79
ab-inbev PUERTO VALLARTAdoordash puerto vallarta restaurant newington0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.86 · same street + ZIP · pins 107 m apart · name similarity 0.70
ct-dcp PUERTO VALLARTAdoordash puerto vallarta restaurant newington0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.86 · same street + ZIP · pins 210 m apart · name similarity 0.70
doordash puerto vallarta restaurant newingtonvtinfo PUERTO VALLARTA0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.86 · same street + city + state · pins 11 m apart · name similarity 0.70

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ESAUL LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LIR
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-13 14:10insertdoordash 36357047 ↔ overture 51757fc9-81d1-4312-bbfb-1e854aaaf407same address and namemerged15
2026-11-12 17:29insertdoordash 36357047 ↔ vtinfo ca396b6f832bd5d0same address and namemerged14
2026-11-12 17:29insertab-inbev 180481 ↔ doordash 36357047same address and namemerged14
2026-11-12 17:29insertct-dcp CT|LIR.0015959 ↔ doordash 36357047same address and namemerged14
2026-11-11 12:56insertab-inbev 180481 ↔ vtinfo ca396b6f832bd5d0same address and namemerged12
2026-11-11 12:56insertct-dcp CT|LIR.0015959 ↔ vtinfo ca396b6f832bd5d0same address and namemerged12
2026-11-11 12:56insertab-inbev 180481 ↔ ct-dcp CT|LIR.0015959same address and namemerged12