Leila By The Bay

HERCULES, CA 94547 · O09c2c31416ff · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed4 licences

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
Leila By The Bay 3 other
a source's own spelling of the licence name (record_title.py)
LOTUS ORGANIC LLC ca-abc (legal name) ×3
FMSH INC ca-abc (legal name)
leila by the bay hercules doordash
Street
1991 RAILROAD AVE 1 other
ca-abc
1991 Railroad Avenue doordash
City
HERCULES
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94547
ca-abcno other value
Pin
38.01607, -122.29058 map 2 other
ubereats
57 m away ca-abc ×4
60 m away vtinfo
Phone
5107415580
vtinfono other value
Licences
ca-abc 00556663|47|APP|0 · ca-abc 00556663|47|LIC|0 · ca-abc 00556663|58|LIC|0 · ca-abc 00622675|47|APP|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oea540338ec7e; Of7b30009a75f; Oa941dc0aa15b; O58d20c7079fb; Obfd94f19dd28; O3050ba626691; Ode45fb6b80c1

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-abcLEILA BY THE BAY
legal name: LOTUS ORGANIC LLC
00556663|47|APP|0
1991 RAILROAD AVE, HERCULES, CA, 9454738.01633, -122.290012026-10-082026-11-05
ca-abcLEILA BY THE BAY
legal name: LOTUS ORGANIC LLC
00556663|47|LIC|0
1991 RAILROAD AVE, HERCULES, CA, 9454738.01633, -122.290012026-10-082026-11-05
ca-abcLEILA BY THE BAY
legal name: LOTUS ORGANIC LLC
00556663|58|LIC|0
1991 RAILROAD AVE, HERCULES, CA, 9454738.01633, -122.290012026-10-082026-11-05
ca-abcLEILA BY THE BAY
legal name: FMSH INC
00622675|47|APP|0
1991 RAILROAD AVE, HERCULES, CA, 9454738.01633, -122.290012026-10-082026-11-05
doordashleila by the bay hercules
90172
1991 Railroad Avenue, Hercules, CA, 9454738.01613, -122.290532026-10-082026-11-13
overtureLeila by the Bay
e23e1d38-3cba-444d-95b9-01ed3338da83
1991 Railroad Ave, Hercules, CA, 94547510741558038.01617, -122.290532026-11-062026-11-06
ubereatsLeila By The Bay
cXl5YyjMTumpGAZXnHmVBw
1991 Railroad Ave, Hercules, CA, 9454738.01607, -122.290582026-10-272026-11-05
vtinfoLEILA BY THE BAY
e1d0d4d63a530eb1
1991 RAILROAD AVE, HERCULES, CA, 94547510741558038.01571, -122.291092026-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
ca-abc LEILA BY THE BAYca-abc LEILA BY THE BAY1.00one licence filemergedfile: 00556663 · same_address
ca-abc LEILA BY THE BAYca-abc LEILA BY THE BAY1.00one licence filemergedfile: 00556663 · same_address
ca-abc LEILA BY THE BAYca-abc LEILA BY THE BAY1.00one store listed twicemergedsame street + ZIP · name: identical
ca-abc LEILA BY THE BAYdoordash leila by the bay hercules1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYoverture Leila by the Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc LEILA BY THE BAYvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 117 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYdoordash leila by the bay hercules1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYoverture Leila by the Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc LEILA BY THE BAYvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 117 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYdoordash leila by the bay hercules1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYoverture Leila by the Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc LEILA BY THE BAYvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 117 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYdoordash leila by the bay hercules1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYoverture Leila by the Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
ca-abc LEILA BY THE BAYvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 117 m apart · name similarity 1.00
doordash leila by the bay herculesoverture Leila by the Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash leila by the bay herculesubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
doordash leila by the bay herculesvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 68 m apart · name similarity 1.00
overture Leila by the Bayubereats Leila By The Bay1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
overture Leila by the Bayvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 71 m apart · name similarity 1.00 · phone: equal
ubereats Leila By The Bayvtinfo LEILA BY THE BAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
LOTUS ORGANIC LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
31 within 1 mi · 244 within 3 mi
Off / on premise
6 / 24 within 1 mi · 69 / 155 within 3 mi
Selling alcohol
23 within 1 mi · 118 within 3 mi
Nearest
same channel 0.22 mi · licensed 0.22 mi
Setting
suburban (2,178 people per sq mi)
People within 3 mi
61,569 (48,688 adults 21+, 21,704 households) from 13 tract(s), tracts within 3 mi
Income
per capita $51,282 · median household ~$119,700 (weighted mean of tract medians)
Age and education
median age ~43.3 · bachelor's or higher 40%
Ethnicity
Hispanic 26% · White 23% · Black 15% · Asian 32%
Adults per alcohol outlet
409
Alcohol spend within 3 mi
$18,831,825 a year ($8,257,787 at home, $10,566,149 away) · $158,251 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-13 14:10insertca-abc 00556663|58|LIC|0 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertca-abc 00556663|47|LIC|0 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertca-abc 00622675|47|APP|0 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertoverture e23e1d38-3cba-444d-95b9-01ed3338da83 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertubereats cXl5YyjMTumpGAZXnHmVBw ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertca-abc 00556663|47|APP|0 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-13 14:10insertdoordash 90172 ↔ vtinfo e1d0d4d63a530eb1same address and namemerged15
2026-11-12 14:25insertca-abc 00556663|58|LIC|0 ↔ doordash 90172same address and namemerged12
2026-11-12 14:25insertca-abc 00556663|47|LIC|0 ↔ doordash 90172same address and namemerged12
2026-11-12 14:25insertca-abc 00622675|47|APP|0 ↔ doordash 90172same address and namemerged12
2026-11-12 14:25insertdoordash 90172 ↔ overture e23e1d38-3cba-444d-95b9-01ed3338da83same address and namemerged12
2026-11-12 14:25insertdoordash 90172 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged12
2026-11-12 14:25insertca-abc 00556663|47|APP|0 ↔ doordash 90172same address and namemerged12
2026-11-06 18:13insertca-abc 00556663|58|LIC|0 ↔ overture e23e1d38-3cba-444d-95b9-01ed3338da83same address and namemerged11
2026-11-06 18:13insertca-abc 00556663|47|LIC|0 ↔ overture e23e1d38-3cba-444d-95b9-01ed3338da83same address and namemerged11
2026-11-06 18:13insertoverture e23e1d38-3cba-444d-95b9-01ed3338da83 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged11
2026-11-06 18:13insertca-abc 00556663|47|APP|0 ↔ overture e23e1d38-3cba-444d-95b9-01ed3338da83same address and namemerged11
2026-11-06 18:13insertca-abc 00622675|47|APP|0 ↔ overture e23e1d38-3cba-444d-95b9-01ed3338da83same address and namemerged11
2026-11-05 17:26backfillca-abc 00556663|47|APP|0 ↔ ca-abc 00622675|47|APP|0one store listed twicemerged
2026-10-27 01:03backfillca-abc 00622675|47|APP|0 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged
2026-10-27 01:03backfillca-abc 00556663|47|APP|0 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged
2026-10-27 01:03backfillca-abc 00556663|47|LIC|0 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged
2026-10-27 01:03backfillca-abc 00556663|58|LIC|0 ↔ ubereats cXl5YyjMTumpGAZXnHmVBwsame address and namemerged
2026-10-09 13:59backfillca-abc 00556663|47|APP|0 ↔ ca-abc 00556663|58|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00556663|47|APP|0 ↔ ca-abc 00556663|47|LIC|0one licence filemerged