Casa Lupe 2

SUNNYVALE, CA 94087 · O1a20d8066f50 · first seen 2026-10-08
3 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
Casa Lupe 2 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Casa Lupe overture
CASA LUPE RESTAURANT vtinfo
VELASCOROMERO J ROQUE ca-abc (legal name)
Street
671 S BERNARDO AVE
ca-abcno other value
City
SUNNYVALE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94087
ca-abcno other value
Pin
37.37202, -122.05762 map 1 other
overture
65 m away ca-abc
Phone
4087392900
vtinfono other value
Licences
ca-abc 00394596|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O476fc46d5239; Oc4f737005abf

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
ca-abcCASA LUPE 2
legal name: VELASCOROMERO J ROQUE
00394596|47|LIC|0
671 S BERNARDO AVE, SUNNYVALE, CA, 9408737.37217, -122.056912026-10-082026-11-16
overtureCasa Lupe
50a94826-7a2a-43b7-84fe-5651d1e3982d
671 S Bernardo Ave, Sunnyvale, CA, 94087408739290037.37202, -122.057622026-11-132026-11-13
vtinfoCASA LUPE RESTAURANT
5c330b7fea3c1d1e
671 S BERNARDO AVE, SUNNYVALE, CA, 94087408739290037.37194, -122.057482026-11-132026-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
overture Casa Lupevtinfo CASA LUPE RESTAURANT0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + city + state · pins 16 m apart · name similarity 0.64 · phone: equal
ca-abc CASA LUPE 2vtinfo CASA LUPE RESTAURANT0.54one name contains the other, same addressmergedjudge: None · pair_id: 17c2f8e7bc69c0c7d84a · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
124 within 1 mi · 926 within 3 mi
Off / on premise
17 / 87 within 1 mi · 159 / 589 within 3 mi
Selling alcohol
44 within 1 mi · 438 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.04 mi
Setting
urban (7,201 people per sq mi)
People within 3 mi
203,607 (155,598 adults 21+, 79,755 households) from 46 tract(s), tracts within 3 mi
Income
per capita $110,654 · median household ~$200,047 (weighted mean of tract medians)
Age and education
median age ~37.7 · bachelor's or higher 75%
Ethnicity
Hispanic 16% · White 35% · Black 2% · Asian 44%
Adults per alcohol outlet
354
Alcohol spend within 3 mi
$90,709,819 a year ($37,729,437 at home, $52,959,261 away) · $206,628 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-16 14:56insertca-abc 00394596|47|LIC|0 ↔ vtinfo 5c330b7fea3c1d1eone name contains the other, same addressmerged15
2026-11-13 14:10insertoverture 50a94826-7a2a-43b7-84fe-5651d1e3982d ↔ vtinfo 5c330b7fea3c1d1esame address and namemerged15