Hoffner Pub LLC

CINCINNATI, OH 45223 · O0a0dd0927caf · first seen 2026-11-13
3 sourceson premise · predictedalcohol: 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
Hoffner Pub LLC 1 other
a source's own spelling of the licence name (record_title.py)
HOFFNER PUB ab-inbevvtinfo ×2
Street
4124 HAMILTION AVE 1 other
ab-inbev
4124 HAMILTON AV inspections
City
CINCINNATI
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
45223
ab-inbevno other value
Pin
39.16099, -84.53919 map
inspectionsno other value
Phone
9999999999
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8beaa59ea084; O578e956ba454

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-inbevHOFFNER PUB
4835467
4124 HAMILTION AVE, CINCINNATI, OH, 4522339.16068, -84.539292026-11-132026-11-13
inspectionsHoffner Pub LLC
inspections|cin|CIN-HEFD-002793
4124 HAMILTON AV, Cincinnati, OH, 4522339.16099, -84.539192026-11-192026-11-19
vtinfoHOFFNER PUB
a136bf86ceb7e184
4124 HAMILTION AVE, CINCINNATI, OH, 45223999999999939.16092, -84.539072026-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 HOFFNER PUBinspections Hoffner Pub LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 35 m apart · name similarity 1.00 · street similarity 0.96
ab-inbev HOFFNER PUBvtinfo HOFFNER PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
inspections Hoffner Pub LLCvtinfo HOFFNER PUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 12 m apart · name similarity 1.00 · street similarity 0.96

Attributes

Channel
unknown
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +8 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
58 within 1 mi · 387 within 3 mi
Off / on premise
9 / 31 within 1 mi · 70 / 204 within 3 mi
Selling alcohol
42 within 1 mi · 222 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.14 mi
Setting
urban (3,711 people per sq mi)
People within 3 mi
104,926 (71,486 adults 21+, 46,575 households) from 34 tract(s), tracts within 3 mi
Income
per capita $27,563 · median household ~$41,688 (weighted mean of tract medians)
Age and education
median age ~32.2 · bachelor's or higher 34%
Ethnicity
Hispanic 5% · White 43% · Black 42% · Asian 3%
Adults per alcohol outlet
321
Alcohol spend within 3 mi
$20,811,265 a year ($10,201,034 at home, $10,597,131 away) · $93,324 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:37insertinspections inspections|cin|CIN-HEFD-002793 ↔ vtinfo a136bf86ceb7e184street written two waysmerged17
2026-11-19 20:37insertab-inbev 4835467 ↔ inspections inspections|cin|CIN-HEFD-002793street written two waysmerged17
2026-11-13 14:10insertab-inbev 4835467 ↔ vtinfo a136bf86ceb7e184same address and namemerged15