The Ideal Store

REDWOOD CITY, CA 94063 · O062821dd3fe0 · first seen 2026-10-08
5 sourcesoff premisealcohol: 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
The Ideal Store 2 other
the most common name a source states
IDEAL STORE LP THE ca-abc (legal name)
IDEAL STORE THE ca-abc
Street
3375 E BAYSHORE RD
ca-abcno other value
City
REDWOOD CITY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94063
ca-abcno other value
Pin
37.48629, -122.19260 map
overtureno other value
Phone
6503651574
vtinfono other value
Licences
ca-abc 00607980|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O0f728273b360; Ocd812402568a; O774278c12436; Oab259beffdcb

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-inbevTHE IDEAL STORE
4149681
3375 E BAYSHORE RD, REDWOOD CITY, CA, 9406337.48617, -122.192092026-11-112026-11-11
ca-abcIDEAL STORE THE
legal name: IDEAL STORE LP THE
00607980|21|LIC|0
3375 E BAYSHORE RD, REDWOOD CITY, CA, 9406337.48625, -122.192842026-10-082026-11-05
overtureThe Ideal Store
9c5873b7-d4e5-4e3c-b180-d9ac577a5d2f
3375 E Bayshore Rd, Redwood City, CA, 94063650365157437.48629, -122.192602026-11-062026-11-06
snapThe Ideal Store
snap|us|1407053
3375 E Bayshore Rd, Redwood City, CA, 9406337.48622, -122.192902026-11-192026-11-19
vtinfoTHE IDEAL STORE
4b712ac7d7e5b84d
3375 E BAYSHORE RD, REDWOOD CITY, CA, 94063650365157437.48630, -122.192612026-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 THE IDEAL STOREca-abc IDEAL STORE THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
ab-inbev THE IDEAL STOREoverture The Ideal Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00
ab-inbev THE IDEAL STOREsnap The Ideal Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev THE IDEAL STOREvtinfo THE IDEAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 48 m apart · name similarity 1.00
ca-abc IDEAL STORE THEoverture The Ideal Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc IDEAL STORE THEsnap The Ideal Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ca-abc IDEAL STORE THEvtinfo THE IDEAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
overture The Ideal Storesnap The Ideal Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
overture The Ideal Storevtinfo THE IDEAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal
snap The Ideal Storevtinfo THE IDEAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
IDEAL STORE LP THE — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 630 within 3 mi
Off / on premise
9 / 16 within 1 mi · 128 / 386 within 3 mi
Selling alcohol
24 within 1 mi · 386 within 3 mi
Nearest
same channel 0.47 mi · licensed 0.49 mi
Setting
urban (3,489 people per sq mi)
People within 3 mi
98,651 (75,326 adults 21+, 34,139 households) from 23 tract(s), tracts within 3 mi
Income
per capita $84,133 · median household ~$156,176 (weighted mean of tract medians)
Age and education
median age ~36.7 · bachelor's or higher 49%
Ethnicity
Hispanic 45% · White 38% · Black 3% · Asian 14%
Adults per alcohol outlet
195
Alcohol spend within 3 mi
$34,077,431 a year ($14,474,864 at home, $19,593,818 away) · $88,055 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-19 20:37insertoverture 9c5873b7-d4e5-4e3c-b180-d9ac577a5d2f ↔ snap snap|us|1407053same address and namemerged17
2026-11-19 20:37insertab-inbev 4149681 ↔ snap snap|us|1407053same address and namemerged17
2026-11-19 20:37insertca-abc 00607980|21|LIC|0 ↔ snap snap|us|1407053same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1407053 ↔ vtinfo 4b712ac7d7e5b84dsame address and namemerged17
2026-11-12 14:25insertoverture 9c5873b7-d4e5-4e3c-b180-d9ac577a5d2f ↔ vtinfo 4b712ac7d7e5b84dsame address and namemerged12
2026-11-12 14:25insertab-inbev 4149681 ↔ vtinfo 4b712ac7d7e5b84dsame address and namemerged12
2026-11-12 14:25insertca-abc 00607980|21|LIC|0 ↔ vtinfo 4b712ac7d7e5b84dsame address and namemerged12
2026-11-11 12:56insertab-inbev 4149681 ↔ overture 9c5873b7-d4e5-4e3c-b180-d9ac577a5d2fsame address and namemerged12
2026-11-11 12:56insertab-inbev 4149681 ↔ ca-abc 00607980|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00607980|21|LIC|0 ↔ overture 9c5873b7-d4e5-4e3c-b180-d9ac577a5d2fsame address and namemerged11