LIMERICKS TAVERN

ALHAMBRA, CA 91801 · O1ea57eb75a7a · first seen 2026-10-08
4 sourceson premise · baralcohol: 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
LIMERICKS TAVERN 1 other
the most common name a source states
LIMERICK'S TAVERN ca-abc
Street
300 W MAIN ST 1 other
ca-abc
300 W MAIN ST STE 110 ab-inbevvtinfo ×2
City
ALHAMBRA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91801
ca-abcno other value
Pin
34.09318, -118.13039 map 1 other
overture
53 m away ca-abc
Phone
6268721504
vtinfono other value
Licences
ca-abc 00566669|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc22e45c7acfa; O9bb4ad0ac2c2; O9b792f7c4107

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-inbevLIMERICKS TAVERN
3984314
300 W MAIN ST STE 110, ALHAMBRA, CA, 9180134.09345, -118.130342026-11-112026-11-11
ca-abcLIMERICK'S TAVERN
00566669|47|LIC|0
300 W MAIN ST, ALHAMBRA, CA, 9180134.09358, -118.130082026-10-082026-11-06
overtureLimericks Tavern
a15389f6-053e-47ca-873a-9826c035e1bb
300 W Main St, Alhambra, CA, 91801626872150434.09318, -118.130392026-11-062026-11-06
vtinfoLIMERICKS TAVERN
c4bd427000baf148
300 W MAIN ST STE 110, ALHAMBRA, CA, 91801626872150434.09318, -118.130452026-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 LIMERICKS TAVERNca-abc LIMERICKS GROUP L.L.C.0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 740037c24ddf87b15ae2 · person: None · rule: names contained at one address · stratum: same-address
ca-abc LIMERICKS GROUP L.L.C.vtinfo LIMERICKS TAVERN0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: ee60f4ed80f1444a5a77 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev LIMERICKS TAVERNca-abc LIMERICK'S TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ab-inbev LIMERICKS TAVERNoverture Limericks Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
ab-inbev LIMERICKS TAVERNvtinfo LIMERICKS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 31 m apart · name similarity 1.00
ca-abc LIMERICK'S TAVERNoverture Limericks Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 53 m apart · name similarity 1.00
ca-abc LIMERICK'S TAVERNvtinfo LIMERICKS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 56 m apart · name similarity 1.00
overture Limericks Tavernvtinfo LIMERICKS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
168 within 1 mi · 1,101 within 3 mi
Off / on premise
31 / 105 within 1 mi · 186 / 697 within 3 mi
Selling alcohol
99 within 1 mi · 537 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
urban (9,061 people per sq mi)
People within 3 mi
256,184 (202,618 adults 21+, 89,741 households) from 64 tract(s), tracts within 3 mi
Income
per capita $47,758 · median household ~$101,078 (weighted mean of tract medians)
Age and education
median age ~43.1 · bachelor's or higher 42%
Ethnicity
Hispanic 32% · White 17% · Black 2% · Asian 50%
Adults per alcohol outlet
377
Alcohol spend within 3 mi
$68,428,734 a year ($30,531,819 at home, $37,868,997 away) · $127,191 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:56insertab-inbev 3984314 ↔ ca-abc 00674264|47|LIC|0one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00674264|47|LIC|0 ↔ vtinfo c4bd427000baf148one name contains the other, same addressheld: same-source-conflict15
2026-11-12 14:25insertca-abc 00566669|47|LIC|0 ↔ vtinfo c4bd427000baf148same address and namemerged12
2026-11-12 14:25insertoverture a15389f6-053e-47ca-873a-9826c035e1bb ↔ vtinfo c4bd427000baf148same address and namemerged12
2026-11-12 14:25insertab-inbev 3984314 ↔ vtinfo c4bd427000baf148same address and namemerged12
2026-11-11 12:56insertab-inbev 3984314 ↔ ca-abc 00566669|47|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3984314 ↔ overture a15389f6-053e-47ca-873a-9826c035e1bbsame address and namemerged12
2026-11-06 18:13insertca-abc 00566669|47|LIC|0 ↔ overture a15389f6-053e-47ca-873a-9826c035e1bbsame address and namemerged11