Outlets /
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.
| Field | Master value | Taken from | What 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-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 13607 | ny-sla | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SUNOCO 2599447 | 45721 SR 12, ALEXANDRIA BAY, NY, 13607 | 44.33017, -75.91667 | 2026-11-13 | 2026-11-20 | |
| inspections | VALERO legal name: WILLIAMS ROBERT J inspections|nys-retail|220061 | 45721 NYS RT 12 #####, Alexandria Bay, NY, 13607 | 44.32876, -75.91828 | 2026-11-19 | 2026-11-20 | |
| lottery | BOB WILLIAMS SUNOCO lottery|ny|046579 | 45721 NYS ROUTE 12, Alexandria Bay, NY, 13607 | 44.33022, -75.91650 | 2026-11-20 | 2026-11-20 | |
| ny-sla | BOB WILLIAMS SUNOCO legal name: ROBERT J WILLIAMS 0081-21-209262 | 45721 STATE RTE 12, ALEXANDRIA BAY, NY, 13607 | 44.32925, -75.91766 | 2026-11-02 | 2026-11-20 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| inspections VALERO | ny-sla BOB WILLIAMS SUNOCO | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.75 |
| lottery BOB WILLIAMS SUNOCO | ny-sla BOB WILLIAMS SUNOCO | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 142 m apart · name similarity 1.00 · street similarity 0.75 |
| ab-inbev SUNOCO | ny-sla BOB WILLIAMS SUNOCO | 0.41 | one name contains the other, same address | merged | judge: 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | lottery lottery|ny|046579 ↔ ny-sla 0081-21-209262 | street written two ways | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|220061 ↔ ny-sla 0081-21-209262 | street written two ways | merged | 17 |
| 2026-11-16 14:56 | insert | ab-inbev 2599447 ↔ ny-sla 0081-21-209262 | one name contains the other, same address | merged | 15 |