PUERTO VALLARTA

SOUTHINGTON, CT 06489 · O204278e2f228 · first seen 2026-10-08
6 sourceson premise · restaurantchain: Puerto Vallartaalcohol: 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
JUAN RODRIGUEZ LLC ct-dcp (legal name)
puerto vallarta restaurant southington doordash
Puerto Vallarta Southington | Mexican overture
Street
826 QUEEN ST
ct-dcpno other value
City
SOUTHINGTON
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06489
ct-dcpno other value
Pin
41.63908, -72.87456 map
ubereatsno other value
Phone
8607360060 1 other
vtinfo
8606099326 overture
Licences
ct-dcp CT|LIR.0016680
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6454d5d58d49; Ob1334a65fadf; O3cc8f0f1032b; O7aef057d1242; O89c749135480

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
180482
826 QUEEN ST, SOUTHINGTON, CT, 0648941.63897, -72.874872026-11-132026-11-13
ct-dcpPUERTO VALLARTA
legal name: JUAN RODRIGUEZ LLC
CT|LIR.0016680
826 QUEEN ST, SOUTHINGTON, CT, 0648941.63907, -72.873982026-11-032026-11-05
doordashpuerto vallarta restaurant southington
36273075
826 Queen St, Southington, CT, 0648941.63917, -72.874892026-10-082026-11-02
overturePuerto Vallarta Southington | Mexican
20662787-1031-4c6c-93ab-2c4900abe98a
826 Queen St, Southington, CT, 06489860609932641.63904, -72.874742026-11-132026-11-13
ubereatsPuerto Vallarta
_CIywMdGUmGqeajNG3eVrQ
826 Queen St, Southington, CT, 0648941.63908, -72.874562026-10-262026-10-26
vtinfoPUERTO VALLARTA
9a8793175efb59f5
826 QUEEN ST, SOUTHINGTON, CT, 06489860736006041.63930, -72.874772026-11-122026-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 75 m apart · name similarity 1.00
ab-inbev PUERTO VALLARTAubereats Puerto Vallarta1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 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 38 m apart · name similarity 1.00
ct-dcp PUERTO VALLARTAubereats Puerto Vallarta1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · 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 70 m apart · name similarity 1.00
ubereats Puerto Vallartavtinfo PUERTO VALLARTA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
ab-inbev PUERTO VALLARTAdoordash puerto vallarta restaurant southington0.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 22 m apart · name similarity 0.70
ct-dcp PUERTO VALLARTAdoordash puerto vallarta restaurant southington0.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 76 m apart · name similarity 0.70
doordash puerto vallarta restaurant southingtonubereats Puerto Vallarta0.70Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Same name (DoorDash slug 'puerto vallarta restaurant southington' with the city appended) at the identical street address and ZIP, 29 m apart, with only one business recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 826 Queen St, Southington CT 06489 with coordinates about 30 m apart, the only business at that address in the data, and the DoorDash slug 'puerto vallarta restaurant southington' matches the Uber Eats name 'Puerto Vallarta'.
pair a968f1093615053d8649
doordash puerto vallarta restaurant southingtonvtinfo 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 18 m apart · name similarity 0.70
doordash puerto vallarta restaurant southingtonoverture Puerto Vallarta Southington | Mexican0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.74 · same street + ZIP · pins 19 m apart · name similarity 0.67

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Puerto Vallarta — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
JUAN RODRIGUEZ 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)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
65 within 1 mi · 223 within 3 mi
Off / on premise
21 / 28 within 1 mi · 70 / 80 within 3 mi
Selling alcohol
27 within 1 mi · 147 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.05 mi
Setting
suburban (1,232 people per sq mi)
People within 3 mi
34,828 (27,771 adults 21+, 14,971 households) from 10 tract(s), tracts within 3 mi
Income
per capita $52,424 · median household ~$100,704 (weighted mean of tract medians)
Age and education
median age ~43.7 · bachelor's or higher 35%
Ethnicity
Hispanic 11% · White 81% · Black 3% · Asian 3%
Adults per alcohol outlet
188
Alcohol spend within 3 mi
$11,221,891 a year ($5,043,319 at home, $6,173,963 away) · $75,824 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-13 17:47insertab-inbev 180482 ↔ doordash 36273075same address and namemerged15
2026-11-13 17:47insertab-inbev 180482 ↔ vtinfo 9a8793175efb59f5same address and namemerged15
2026-11-13 17:47insertab-inbev 180482 ↔ ubereats _CIywMdGUmGqeajNG3eVrQsame address and namemerged15
2026-11-13 17:47insertab-inbev 180482 ↔ ct-dcp CT|LIR.0016680same address and namemerged15
2026-11-13 14:10insertdoordash 36273075 ↔ overture 20662787-1031-4c6c-93ab-2c4900abe98asame address and namemerged15
2026-11-12 17:29insertdoordash 36273075 ↔ vtinfo 9a8793175efb59f5same address and namemerged14
2026-11-12 17:29insertct-dcp CT|LIR.0016680 ↔ doordash 36273075same address and namemerged14
2026-11-12 14:25insertubereats _CIywMdGUmGqeajNG3eVrQ ↔ vtinfo 9a8793175efb59f5same address and namemerged12
2026-11-12 14:25insertct-dcp CT|LIR.0016680 ↔ vtinfo 9a8793175efb59f5same address and namemerged12
2026-11-03 13:33backfillct-dcp CT|LIR.0016680 ↔ ubereats _CIywMdGUmGqeajNG3eVrQsame address and namemerged
2026-11-02 23:02backfilldoordash 36273075 ↔ ubereats _CIywMdGUmGqeajNG3eVrQClaude judge: samemerged