Bob Williams Sunoco

Alexandria Bay, NY 13607 · O1726cc9dbd8a · first seen 2026-11-02
4 sourcesunknownalcohol: 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
Bob Williams Sunoco 4 other
a licence name in capitals, cleaned (derived; record_title.py)
ROBERT J WILLIAMS ny-sla (legal name)
SUNOCO ab-inbev
VALERO inspections
WILLIAMS ROBERT J inspections (legal name)
Street
45721 STATE RTE 12 3 other
ny-sla
45721 NYS ROUTE 12 lottery
45721 NYS RT 12 ##### inspections
45721 SR 12 ab-inbev
City
ALEXANDRIA BAY
ny-slano other value
State
NY
ny-slano other value
ZIP
13607
ny-slano other value
Pin
44.32876, -75.91828 map 3 other
inspections
202 m away ab-inbev
215 m away lottery
73 m away ny-sla
Phone
none
no other value
Licences
ny-sla 0081-21-209262
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8bf9d154850d; O742e487b965b; O1e4bf3bfece9

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-inbevSUNOCO
2599447
45721 SR 12, ALEXANDRIA BAY, NY, 1360744.33017, -75.916672026-11-132026-11-20
inspectionsVALERO
legal name: WILLIAMS ROBERT J
inspections|nys-retail|220061
45721 NYS RT 12 #####, Alexandria Bay, NY, 1360744.32876, -75.918282026-11-192026-11-20
lotteryBOB WILLIAMS SUNOCO
lottery|ny|046579
45721 NYS ROUTE 12, Alexandria Bay, NY, 1360744.33022, -75.916502026-11-202026-11-20
ny-slaBOB WILLIAMS SUNOCO
legal name: ROBERT J WILLIAMS
0081-21-209262
45721 STATE RTE 12, ALEXANDRIA BAY, NY, 1360744.32925, -75.917662026-11-022026-11-20

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
inspections VALEROny-sla BOB WILLIAMS SUNOCO1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.75
lottery BOB WILLIAMS SUNOCOny-sla BOB WILLIAMS SUNOCO1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 142 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev SUNOCOny-sla BOB WILLIAMS SUNOCO0.41one name contains the other, same addressmergedjudge: None · pair_id: adecc5430e8776fbb6fd · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off — NY 0081
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": []
}

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-20 22:08insertlottery lottery|ny|046579 ↔ ny-sla 0081-21-209262street written two waysmerged17
2026-11-19 20:37insertinspections inspections|nys-retail|220061 ↔ ny-sla 0081-21-209262street written two waysmerged17
2026-11-16 14:56insertab-inbev 2599447 ↔ ny-sla 0081-21-209262one name contains the other, same addressmerged15