Kwik Fill

MAYVILLE, NY 14757 · O0b66726ed85e · first seen 2026-11-02
3 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
Kwik Fill 3 other
the most common name a source states
KWIK FILL #M0024 ny-sla
RED APPLE KWIK FILL ab-inbev
UNITED REFINING CO OF PA ny-sla (legal name)
Street
14 WATER STREET 1 other
ny-sla
14 WATER ST ab-inbevoverture ×2
City
MAYVILLE
ny-slano other value
State
NY
ny-slano other value
ZIP
14757
ny-slano other value
Pin
42.24513, -79.49580 map 1 other
overture
78 m away ab-inbev
Phone
7167533653
overtureno other value
Licences
ny-sla 0081-21-308844
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O15a1c499ab54; O9ccec16456f8

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 APPLE KWIK FILL
2636384
14 WATER ST, MAYVILLE, NY, 1475742.24446, -79.496102026-11-112026-11-12
ny-slaKWIK FILL #M0024
legal name: UNITED REFINING CO OF PA
0081-21-308844
14 WATER STREET, MAYVILLE, NY, 1475742.24501, -79.495672026-11-022026-11-06
overtureKwik Fill
d6a8afe6-286c-48fc-bfbf-8fddeb02d6e1
14 Water St, Mayville, NY, 14757716753365342.24513, -79.495802026-11-062026-11-06

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
ny-sla KWIK FILL #M0024overture Kwik Fill0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 17 m apart · name similarity 0.71
ab-inbev RED APPLE KWIK FILLny-sla KWIK FILL #M00240.49Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Red Apple Kwik Fill same address, same brand
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 14 Water Street, Mayville NY 14757, about 71 m apart, and both carry the Kwik Fill name (the AB InBev 'Red Apple Kwik Fill' and the NY SLA 'KWIK FILL #M0024' licence held by United Refining, the Kwik Fill operator), so they read as one station.
pair 0f034cdc7c02c07811a6

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
UNITED REFINING CO OF PA — 111 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
18 within 1 mi · 26 within 3 mi
Off / on premise
4 / 6 within 1 mi · 8 / 8 within 3 mi
Selling alcohol
17 within 1 mi · 25 within 3 mi
Nearest
same channel 0.66 mi · licensed 0.04 mi
Setting
rural (89 people per sq mi)
People within 3 mi
2,524 (2,063 adults 21+, 1,124 households) from 1 tract(s), tracts within 3 mi
Income
per capita $39,139 · median household ~$73,333 (weighted mean of tract medians)
Age and education
median age ~53.1 · bachelor's or higher 42%
Ethnicity
Hispanic 4% · White 90% · Black 3% · Asian 0%
Adults per alcohol outlet
79
Alcohol spend within 3 mi
$671,522 a year ($310,138 at home, $360,900 away) · $25,828 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-12 17:29insertab-inbev 2636384 ↔ ny-sla 0081-21-308844Claude judge: samemerged14
2026-11-06 18:13insertny-sla 0081-21-308844 ↔ overture d6a8afe6-286c-48fc-bfbf-8fddeb02d6e1same address and namemerged11