Miller & Brandes

Friendship, NY 14739 · O5667112f75d1 · first seen 2026-11-02
5 sourcesoff premise · conveniencealcohol: 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
Miller & Brandes 2 other
a source's own spelling of the licence name (record_title.py)
MILLER AND BRANDES snap
MILLER AND BRANDES INC ny-sla
Street
4681 CASTLE GARDEN RD 1 other
ny-sla
4681 CASTLE GARDEN ROAD inspections
City
FRIENDSHIP
ny-slano other value
State
NY
ny-slano other value
ZIP
14739
ny-slano other value
Pin
42.20257, -78.14861 map 1 other
overture
324 m away ab-inbev
Phone
5859732780
overtureno other value
Licences
ny-sla 0081-22-331643
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe9f9b5e518f8; Od8aae5667292; Oc544b1435329; Oc1aeb5a3d0ae

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-inbevMILLER & BRANDES
2600287
4681 CASTLE GARDEN RD, FRIENDSHIP, NY, 1473942.20546, -78.148102026-11-122026-11-12
inspectionsMILLER & BRANDES
inspections|nys-retail|020133
4681 CASTLE GARDEN ROAD, Friendship, NY, 1473942.20274, -78.148342026-11-192026-11-19
ny-slaMILLER AND BRANDES INC
0081-22-331643
4681 CASTLE GARDEN RD, FRIENDSHIP, NY, 1473942.20274, -78.148342026-11-022026-11-12
overtureMiller & Brandes
053f4157-34a3-4485-a7fa-3a9cbd8f8699
4681 Castle Garden Rd, Friendship, NY, 14739585973278042.20257, -78.148612026-11-062026-11-12
snapMILLER AND BRANDES
snap|us|464118
4681 Castle Garden Rd, Friendship, NY, 1473942.20274, -78.148372026-11-192026-11-19

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 MILLER & BRANDESinspections MILLER & BRANDES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 303 m apart · name similarity 1.00
ab-inbev MILLER & BRANDESny-sla MILLER AND BRANDES INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 303 m apart · name similarity 1.00
ab-inbev MILLER & BRANDESoverture Miller & Brandes1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 324 m apart · name similarity 1.00
ab-inbev MILLER & BRANDESsnap MILLER AND BRANDES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 303 m apart · name similarity 1.00
inspections MILLER & BRANDESny-sla MILLER AND BRANDES INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections MILLER & BRANDESoverture Miller & Brandes1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
inspections MILLER & BRANDESsnap MILLER AND BRANDES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
ny-sla MILLER AND BRANDES INCoverture Miller & Brandes1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
ny-sla MILLER AND BRANDES INCsnap MILLER AND BRANDES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
overture Miller & Brandessnap MILLER AND BRANDES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MILLER AND BRANDES INC — 1 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
7 within 1 mi · 8 within 3 mi
Off / on premise
3 / 2 within 1 mi · 3 / 2 within 3 mi
Selling alcohol
6 within 1 mi · 7 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.07 mi
Setting
rural (none people per sq mi)
People within 3 mi
3,843 (2,996 adults 21+, 1,695 households) from 1 tract(s), the nearest tract
Income
per capita $35,956 · median household ~$66,116 (weighted mean of tract medians)
Age and education
median age ~46.8 · bachelor's or higher 22%
Ethnicity
Hispanic 2% · White 95% · Black 1% · Asian 1%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$935,384 a year ($444,496 at home, $490,389 away) · none 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|nys-retail|020133 ↔ snap snap|us|464118same address and namemerged17
2026-11-19 20:37insertab-inbev 2600287 ↔ snap snap|us|464118same address and namemerged17
2026-11-19 20:37insertab-inbev 2600287 ↔ inspections inspections|nys-retail|020133same address and namemerged17
2026-11-19 20:37insertoverture 053f4157-34a3-4485-a7fa-3a9cbd8f8699 ↔ snap snap|us|464118same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|020133 ↔ overture 053f4157-34a3-4485-a7fa-3a9cbd8f8699same address and namemerged17
2026-11-19 20:37insertny-sla 0081-22-331643 ↔ snap snap|us|464118same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|020133 ↔ ny-sla 0081-22-331643same address and namemerged17
2026-11-12 14:25insertab-inbev 2600287 ↔ overture 053f4157-34a3-4485-a7fa-3a9cbd8f8699same address and namemerged12
2026-11-12 14:25insertab-inbev 2600287 ↔ ny-sla 0081-22-331643same address and namemerged12
2026-11-06 18:13insertny-sla 0081-22-331643 ↔ overture 053f4157-34a3-4485-a7fa-3a9cbd8f8699same address and namemerged11