EFFIES COFFEE SHOP & FINE DINNING

CAMPBELL, CA 95008 · O1f17907e8c35 · 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
EFFIES COFFEE SHOP & FINE DINNING 4 other
the most common name a source states
Effie's Restaurant & Bar overture
effie's restaurant campbell doordash
EFFIES ca-abc
SHIRVANIS HOLDING LLC ca-abc (legal name)
Street
331 W HACIENDA AVE 1 other
ca-abc
331 West Hacienda Avenue doordash
City
CAMPBELL
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95008
ca-abcno other value
Pin
37.26953, -121.95689 map
doordashno other value
Phone
4083743400
vtinfono other value
Licences
ca-abc 00660235|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O928ac3648667; Ob5e5afc4168c; O8146f94edd99; O7015b12bd2dd

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-inbevEFFIES COFFEE SHOP & FINE DINNING
1948233
331 W HACIENDA AVE, CAMPBELL, CA, 9500837.26925, -121.956902026-11-112026-11-11
ca-abcEFFIES
legal name: SHIRVANIS HOLDING LLC
00660235|47|LIC|0
331 W HACIENDA AVE, CAMPBELL, CA, 9500837.26922, -121.956802026-10-082026-11-16
doordasheffie's restaurant campbell
32144
331 West Hacienda Avenue, Campbell, CA, 9500837.26953, -121.956892026-10-082026-11-16
overtureEffie's Restaurant & Bar
f42283dd-69e1-4888-812c-04291d0576d1
331 W Hacienda Ave, Campbell, CA, 95008408374340037.26953, -121.956862026-11-132026-11-16
vtinfoEFFIES COFFEE SHOP & FINE DINNING
a53e5cc8571b0803
331 W HACIENDA AVE, CAMPBELL, CA, 95008408374340037.26954, -121.957032026-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 EFFIES COFFEE SHOP & FINE DINNINGvtinfo EFFIES COFFEE SHOP & FINE DINNING1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
doordash effie's restaurant campbelloverture Effie's Restaurant & Bar0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.82 · same street + ZIP · pins 3 m apart · name similarity 0.78
ca-abc EFFIESdoordash effie's restaurant campbell0.51Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The names match ('EFFIES' and 'effie's restaurant campbell', with the city appended to the DoorDash slug), the street address is the same, only one business is recorded there, and the restaurant licen
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 331 W Hacienda Ave, Campbell, ZIP 95008, with no other businesses at that address, and the name 'EFFIES' matches 'effie's restaurant campbell'; the CA licence is an on-sale eating-place licence, consistent with the restaurant listing.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Same street address, ZIP and city, with the CA ABC restaurant licence (on-sale eating place) matching the DoorDash listing 'effie's restaurant campbell' as the only business at the address, and coordinates within 36 m.
pair 3840393a5c1550f62ee6
ca-abc EFFIESoverture Effie's Restaurant & Bar0.39same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.76 · same street + ZIP · pins 35 m apart · name similarity 0.39
ab-inbev EFFIES COFFEE SHOP & FINE DINNINGca-abc EFFIES0.31one name contains the other, same addressmergedjudge: None · pair_id: 915a0a995ccb6c3231b2 · person: None · rule: names contained at one address · stratum: same-address
ca-abc EFFIESvtinfo EFFIES COFFEE SHOP & FINE DINNING0.31one name contains the other, same addressmergedjudge: None · pair_id: b39e7a48fdac32079967 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev EFFIES COFFEE SHOP & FINE DINNINGdoordash effie's restaurant campbell0.29one name contains the other, same addressmergedjudge: None · pair_id: e541a8ecb2eb634631b8 · person: None · rule: names contained at one address · stratum: same-address
doordash effie's restaurant campbellvtinfo EFFIES COFFEE SHOP & FINE DINNING0.29one name contains the other, same addressmergedjudge: None · pair_id: f36bd15983b8330781a4 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SHIRVANIS HOLDING LLC — 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
63 within 1 mi · 766 within 3 mi
Off / on premise
15 / 35 within 1 mi · 174 / 465 within 3 mi
Selling alcohol
40 within 1 mi · 419 within 3 mi
Nearest
same channel 0.21 mi · licensed 0.20 mi
Setting
urban (7,025 people per sq mi)
People within 3 mi
198,622 (148,252 adults 21+, 74,126 households) from 41 tract(s), tracts within 3 mi
Income
per capita $89,568 · median household ~$171,316 (weighted mean of tract medians)
Age and education
median age ~41.0 · bachelor's or higher 62%
Ethnicity
Hispanic 18% · White 46% · Black 2% · Asian 30%
Adults per alcohol outlet
353
Alcohol spend within 3 mi
$77,477,971 a year ($32,621,526 at home, $44,836,144 away) · $184,471 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:56insertdoordash 32144 ↔ vtinfo a53e5cc8571b0803one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 1948233 ↔ doordash 32144one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00660235|47|LIC|0 ↔ vtinfo a53e5cc8571b0803one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 1948233 ↔ ca-abc 00660235|47|LIC|0one name contains the other, same addressmerged15
2026-11-13 14:10insertca-abc 00660235|47|LIC|0 ↔ overture f42283dd-69e1-4888-812c-04291d0576d1same address and namemerged15
2026-11-13 14:10insertdoordash 32144 ↔ overture f42283dd-69e1-4888-812c-04291d0576d1same address and namemerged15
2026-11-11 12:56insertca-abc 00660235|47|LIC|0 ↔ doordash 32144Claude judge: samemerged12
2026-11-11 12:56insertab-inbev 1948233 ↔ vtinfo a53e5cc8571b0803same address and namemerged12