PUERTO VALLARTA RESTAURANT

REDDING, CA 96002 · O1e8e9ca1bcea · 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 RESTAURANT 4 other
the most common name a source states
Puerto Vallarta Family Mexican Restaurant overture
PUERTO VALLARTA MEXICAN RESTAURANT ca-abc
puerto vallarta redding doordash
SANTIAGO AND LULA'S INC ca-abc (legal name)
Street
1109 HARTNELL AVE 3 other
ca-abc
1109 HARTNELL AVE STE 16 ab-inbevvtinfo ×2
1109 Hartnell Ave Ste 2 overture
1109 Hartnell Ave Ste 2 # Ste doordash
City
REDDING
ca-abcno other value
State
CA
ca-abcno other value
ZIP
96002
ca-abcno other value
Pin
40.56345, -122.35146 map
doordashno other value
Phone
5302232441
vtinfono other value
Licences
ca-abc 00618461|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O5635861ed8e3; O481fc4b37fbb; O1fcdb9cb99cc; Ob3dbed1936cd

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 RESTAURANT
2936390
1109 HARTNELL AVE STE 16, REDDING, CA, 9600240.56314, -122.351262026-11-112026-11-11
ca-abcPUERTO VALLARTA MEXICAN RESTAURANT
legal name: SANTIAGO AND LULA'S INC
00618461|47|LIC|0
1109 HARTNELL AVE, REDDING, CA, 9600240.56367, -122.351502026-10-082026-11-05
doordashpuerto vallarta redding
34807541
1109 Hartnell Ave Ste 2 # Ste, Redding, CA, 9600240.56345, -122.351462026-10-082026-11-11
overturePuerto Vallarta Family Mexican Restaurant
20d1a14a-2fce-4644-8412-329707ae1b1e
1109 Hartnell Ave Ste 2, Redding, CA, 96002530223244140.56360, -122.351722026-11-062026-11-06
vtinfoPUERTO VALLARTA RESTAURANT
cd1c390dbbbb3dd1
1109 HARTNELL AVE STE 16, REDDING, CA, 96002530223244140.56322, -122.351442026-11-142026-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 VALLARTA RESTAURANTvtinfo PUERTO VALLARTA RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ca-abc PUERTO VALLARTA MEXICAN RESTAURANToverture Puerto Vallarta Family Mexican Restaurant0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.78 · same street + ZIP · pins 20 m apart · name similarity 0.85
ab-inbev PUERTO VALLARTA RESTAURANTca-abc PUERTO VALLARTA MEXICAN RESTAURANT0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.77 · same street + ZIP · pins 62 m apart · name similarity 0.81
ca-abc PUERTO VALLARTA MEXICAN RESTAURANTvtinfo PUERTO VALLARTA RESTAURANT0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.77 · same street + ZIP · pins 51 m apart · name similarity 0.81
ab-inbev PUERTO VALLARTA RESTAURANTdoordash puerto vallarta redding0.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 39 m apart · name similarity 0.70
doordash puerto vallarta reddingvtinfo PUERTO VALLARTA RESTAURANT0.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 26 m apart · name similarity 0.70
ca-abc PUERTO VALLARTA MEXICAN RESTAURANTdoordash puerto vallarta redding0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The names agree: 'Puerto Vallarta Mexican Restaurant' and DoorDash's 'puerto vallarta redding' both name Puerto Vallarta at 1109 Hartnell Ave, Redding, 24 m apart, so matching names outweigh the share
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The distinctive name 'Puerto Vallarta' matches the CA restaurant licence at 1109 Hartnell Ave, and the coordinates are about 24 m apart; the DoorDash suite (Ste 2) is unmatched on the ABC side and the building is shared by three businesses, so the name agreement is what carries the verdict.
  • Claude Haiku 5.5, prompt v4: unsure, 60% confident — Record B is a DoorDash slug with city Redding but no street address, and the name matches the restaurant in A, but the address is shared by three businesses in the data and the chain-status of Puerto Vallarta cannot be verified, so the records do not establish the same outlet.
pair 5b889346cc221f95e5a2

Attributes

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

Trade area

Other outlets
103 within 1 mi · 391 within 3 mi
Off / on premise
39 / 47 within 1 mi · 129 / 196 within 3 mi
Selling alcohol
74 within 1 mi · 275 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
suburban (2,154 people per sq mi)
People within 3 mi
60,894 (44,650 adults 21+, 23,895 households) from 15 tract(s), tracts within 3 mi
Income
per capita $37,241 · median household ~$72,989 (weighted mean of tract medians)
Age and education
median age ~37.4 · bachelor's or higher 27%
Ethnicity
Hispanic 15% · White 73% · Black 1% · Asian 5%
Adults per alcohol outlet
162
Alcohol spend within 3 mi
$14,362,554 a year ($6,728,371 at home, $7,628,374 away) · $52,038 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-14 20:23insertdoordash 34807541 ↔ vtinfo cd1c390dbbbb3dd1same address and namemerged15
2026-11-14 20:23insertca-abc 00618461|47|LIC|0 ↔ vtinfo cd1c390dbbbb3dd1same address and namemerged15
2026-11-14 20:23insertab-inbev 2936390 ↔ vtinfo cd1c390dbbbb3dd1same address and namemerged15
2026-11-12 17:29insertab-inbev 2936390 ↔ doordash 34807541same address and namemerged14
2026-11-11 12:56insertca-abc 00618461|47|LIC|0 ↔ doordash 34807541Claude judge: samemerged12
2026-11-11 12:56insertab-inbev 2936390 ↔ ca-abc 00618461|47|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00618461|47|LIC|0 ↔ overture 20d1a14a-2fce-4644-8412-329707ae1b1esame address and namemerged11