Outlets /
Cliff's Local Market
Herkimer, NY 13350 · O299aa4a672b1 · first seen 2026-11-02
6 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Cliff's Local Market 6 other | a source's own spelling of the licence name (record_title.py) | CLIFFS LOCAL MARKET ab-inbevinspections ×2 CLIFF'S LOCAL MARKET #507 lottery Cliff's Local Market 507 snap CLIFFORD'S SUNRISE TO SUNSET MARKETS INC ny-sla (legal name) CLIFFORDS SUNRISE TO SUNSET MARKETS INC inspections (legal name) Cliff’s Local Market overture |
| Street | 412 E STATE ST 2 other | ny-sla | 412 E STATE STREET lottery 412 E STATE STREET### inspections |
| City | HERKIMER | ny-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 13350 | ny-sla | no other value |
| Pin | 43.02789, -74.97880 map 1 other | overture | 86 m away lottery |
| Phone | 3158667131 | overture | no other value |
| Licences | ny-sla 0081-23-222207 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O9b500306c88b; O9aad9ccc8e99; O41e3c6bc5085; Ofdedf287deae; O82969c243f62
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 | CLIFFS LOCAL MARKET 4025097 | 412 E STATE ST, HERKIMER, NY, 13350 | 43.02809, -74.97886 | 2026-11-12 | 2026-11-19 | |
| inspections | CLIFFS LOCAL MARKET legal name: CLIFFORDS SUNRISE TO SUNSET MARKETS INC inspections|nys-retail|704352 | 412 E STATE STREET###, Herkimer, NY, 13350 | 43.02803, -74.97876 | 2026-11-19 | 2026-11-19 | |
| lottery | CLIFF'S LOCAL MARKET #507 lottery|ny|075798 | 412 E STATE STREET, Herkimer, NY, 13350 | 43.02781, -74.97986 | 2026-11-20 | 2026-11-20 | |
| ny-sla | CLIFF'S LOCAL MARKET legal name: CLIFFORD'S SUNRISE TO SUNSET MARKETS INC 0081-23-222207 | 412 E STATE ST, HERKIMER, NY, 13350 | 43.02803, -74.97876 | 2026-11-02 | 2026-11-19 | |
| overture | Cliff’s Local Market 125fb5a2-63ad-414c-809e-da0cbdfc8c28 | 412 E State St, Herkimer, NY, 13350 | 3158667131 | 43.02789, -74.97880 | 2026-11-06 | 2026-11-19 |
| snap | Cliff's Local Market 507 snap|us|1076598 | 412 E State St, Herkimer, NY, 13350 | 43.02791, -74.97875 | 2026-11-19 | 2026-11-19 |
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 |
|---|---|---|---|---|---|
| ab-inbev CLIFFS LOCAL MARKET | inspections CLIFFS LOCAL MARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| ab-inbev CLIFFS LOCAL MARKET | lottery CLIFF'S LOCAL MARKET #507 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 87 m apart · name similarity 1.00 |
| ab-inbev CLIFFS LOCAL MARKET | ny-sla CLIFF'S LOCAL MARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| ab-inbev CLIFFS LOCAL MARKET | overture Cliff’s Local Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00 |
| inspections CLIFFS LOCAL MARKET | lottery CLIFF'S LOCAL MARKET #507 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00 |
| inspections CLIFFS LOCAL MARKET | ny-sla CLIFF'S LOCAL MARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 |
| inspections CLIFFS LOCAL MARKET | overture Cliff’s Local Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 |
| lottery CLIFF'S LOCAL MARKET #507 | ny-sla CLIFF'S LOCAL MARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00 |
| lottery CLIFF'S LOCAL MARKET #507 | overture Cliff’s Local Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00 |
| lottery CLIFF'S LOCAL MARKET #507 | snap Cliff's Local Market 507 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 91 m apart · name similarity 1.00 |
| ny-sla CLIFF'S LOCAL MARKET | overture Cliff’s Local Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 |
| ab-inbev CLIFFS LOCAL MARKET | snap Cliff's Local Market 507 | 0.83 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 22 m apart · name similarity 0.83 |
| inspections CLIFFS LOCAL MARKET | snap Cliff's Local Market 507 | 0.83 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 13 m apart · name similarity 0.83 |
| ny-sla CLIFF'S LOCAL MARKET | snap Cliff's Local Market 507 | 0.83 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 13 m apart · name similarity 0.83 |
| overture Cliff’s Local Market | snap Cliff's Local Market 507 | 0.83 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 5 m apart · name similarity 0.83 |
Attributes
- Channel
- off_premise · convenience — overture-category
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- CLIFFORD'S SUNRISE TO SUNSET MARKETS INC — 21 outlets in the master under this operator
- Licence privileges
- beer_off — NY 0081
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"off_premise",
"convenience"
]
]
}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|075798 ↔ snap snap|us|1076598 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | lottery lottery|ny|075798 ↔ ny-sla 0081-23-222207 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | lottery lottery|ny|075798 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|nys-retail|704352 ↔ lottery lottery|ny|075798 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ab-inbev 4025097 ↔ lottery lottery|ny|075798 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|704352 ↔ snap snap|us|1076598 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ab-inbev 4025097 ↔ snap snap|us|1076598 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ny-sla 0081-23-222207 ↔ snap snap|us|1076598 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 ↔ snap snap|us|1076598 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ab-inbev 4025097 ↔ inspections inspections|nys-retail|704352 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|704352 ↔ ny-sla 0081-23-222207 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|704352 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 | same address and name | merged | 17 |
| 2026-11-12 14:25 | insert | ab-inbev 4025097 ↔ ny-sla 0081-23-222207 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 4025097 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ny-sla 0081-23-222207 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 | same address and name | merged | 11 |