REDS ALEHOUSE & GRILL

ONEONTA, NY 13820 · O4addc2a41e4d · first seen 2026-11-02
2 sourceson premise · predictedalcohol: 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
REDS ALEHOUSE & GRILL 1 other
the most common name a source states
MC BREW COMPANY ONE, LLC ny-sla (legal name)
Street
84 MAIN ST
ny-slano other value
City
ONEONTA
ny-slano other value
State
NY
ny-slano other value
ZIP
13820
ny-slano other value
Pin
42.45108, -75.06389 map 1 other
ny-sla
430 m away ab-inbev
Phone
none
no other value
Licences
ny-sla 0340-22-214902
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob27ed592ad20

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-inbevREDS ALEHOUSE & GRILL
4008522
84 MAIN ST, ONEONTA, NY, 1382042.45340, -75.059702026-11-112026-11-11
ny-slaREDS ALEHOUSE & GRILL
legal name: MC BREW COMPANY ONE, LLC
0340-22-214902
84 MAIN ST, ONEONTA, NY, 1382042.45108, -75.063892026-11-022026-11-05

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 REDS ALEHOUSE & GRILLny-sla REDS ALEHOUSE & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 430 m apart · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MC BREW COMPANY ONE, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
117 within 1 mi · 161 within 3 mi
Off / on premise
22 / 64 within 1 mi · 35 / 81 within 3 mi
Selling alcohol
71 within 1 mi · 102 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
suburban (709 people per sq mi)
People within 3 mi
20,039 (13,668 adults 21+, 7,427 households) from 5 tract(s), tracts within 3 mi
Income
per capita $32,103 · median household ~$69,563 (weighted mean of tract medians)
Age and education
median age ~34.6 · bachelor's or higher 45%
Ethnicity
Hispanic 8% · White 83% · Black 6% · Asian 2%
Adults per alcohol outlet
133
Alcohol spend within 3 mi
$4,132,175 a year ($1,975,008 at home, $2,155,527 away) · $40,118 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-11 12:56insertab-inbev 4008522 ↔ ny-sla 0340-22-214902same address and namemerged12