RED SHAMROCK PUB

Birmingham, AL 35242 · O22706ebd8704 · first seen 2026-11-13
2 sourceson premise · baralcohol: alcohol

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
RED SHAMROCK PUB 1 other
the most common name a source states
The Red Shamrock Pub overture
Street
42 MANNING PL
ab-inbevno other value
City
BIRMINGHAM
ab-inbevno other value
State
AL
ab-inbevno other value
ZIP
35242
ab-inbevno other value
Pin
33.40750, -86.63028 map
overtureno other value
Phone
2056596032
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O893f710ac6d8

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-inbevRED SHAMROCK PUB
3337091
42 MANNING PL, BIRMINGHAM, AL, 3524233.40770, -86.630322026-11-132026-11-13
overtureThe Red Shamrock Pub
458af0ed-6a52-43e0-ba03-260758d1c40e
42 Manning Pl, Birmingham, AL, 35242205659603233.40750, -86.630282026-11-132026-11-13

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 RED SHAMROCK PUBoverture The Red Shamrock Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
alcohol — channel bar
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
6 within 1 mi · 102 within 3 mi
Off / on premise
3 / 2 within 1 mi · 24 / 54 within 3 mi
Selling alcohol
5 within 1 mi · 52 within 3 mi
Nearest
same channel 0.01 mi · licensed 1.82 mi
Setting
suburban (791 people per sq mi)
People within 3 mi
22,362 (17,051 adults 21+, 8,632 households) from 4 tract(s), tracts within 3 mi
Income
per capita $77,791 · median household ~$141,272 (weighted mean of tract medians)
Age and education
median age ~48.5 · bachelor's or higher 63%
Ethnicity
Hispanic 2% · White 86% · Black 6% · Asian 4%
Adults per alcohol outlet
322
Alcohol spend within 3 mi
$8,493,442 a year ($3,633,292 at home, $4,857,807 away) · $160,254 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:10insertab-inbev 3337091 ↔ overture 458af0ed-6a52-43e0-ba03-260758d1c40esame address and namemerged15