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.

FieldMaster valueTaken fromWhat 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-slano other value
State
NY
ny-slano other value
ZIP
13350
ny-slano other value
Pin
43.02789, -74.97880 map 1 other
overture
86 m away lottery
Phone
3158667131
overtureno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevCLIFFS LOCAL MARKET
4025097
412 E STATE ST, HERKIMER, NY, 1335043.02809, -74.978862026-11-122026-11-19
inspectionsCLIFFS LOCAL MARKET
legal name: CLIFFORDS SUNRISE TO SUNSET MARKETS INC
inspections|nys-retail|704352
412 E STATE STREET###, Herkimer, NY, 1335043.02803, -74.978762026-11-192026-11-19
lotteryCLIFF'S LOCAL MARKET #507
lottery|ny|075798
412 E STATE STREET, Herkimer, NY, 1335043.02781, -74.979862026-11-202026-11-20
ny-slaCLIFF'S LOCAL MARKET
legal name: CLIFFORD'S SUNRISE TO SUNSET MARKETS INC
0081-23-222207
412 E STATE ST, HERKIMER, NY, 1335043.02803, -74.978762026-11-022026-11-19
overtureCliff’s Local Market
125fb5a2-63ad-414c-809e-da0cbdfc8c28
412 E State St, Herkimer, NY, 13350315866713143.02789, -74.978802026-11-062026-11-19
snapCliff's Local Market 507
snap|us|1076598
412 E State St, Herkimer, NY, 1335043.02791, -74.978752026-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 CLIFFS LOCAL MARKETinspections CLIFFS LOCAL MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev CLIFFS LOCAL MARKETlottery CLIFF'S LOCAL MARKET #5071.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 87 m apart · name similarity 1.00
ab-inbev CLIFFS LOCAL MARKETny-sla CLIFF'S LOCAL MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev CLIFFS LOCAL MARKEToverture Cliff’s Local Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
inspections CLIFFS LOCAL MARKETlottery CLIFF'S LOCAL MARKET #5071.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00
inspections CLIFFS LOCAL MARKETny-sla CLIFF'S LOCAL MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections CLIFFS LOCAL MARKEToverture Cliff’s Local Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
lottery CLIFF'S LOCAL MARKET #507ny-sla CLIFF'S LOCAL MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00
lottery CLIFF'S LOCAL MARKET #507overture Cliff’s Local Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00
lottery CLIFF'S LOCAL MARKET #507snap Cliff's Local Market 5071.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 91 m apart · name similarity 1.00
ny-sla CLIFF'S LOCAL MARKEToverture Cliff’s Local Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev CLIFFS LOCAL MARKETsnap Cliff's Local Market 5070.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 22 m apart · name similarity 0.83
inspections CLIFFS LOCAL MARKETsnap Cliff's Local Market 5070.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 13 m apart · name similarity 0.83
ny-sla CLIFF'S LOCAL MARKETsnap Cliff's Local Market 5070.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.84 · same street + ZIP · pins 13 m apart · name similarity 0.83
overture Cliff’s Local Marketsnap Cliff's Local Market 5070.83same address and namemergedaddress 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”).
WhenEventPairRuleDecisionRule version
2026-11-20 22:08insertlottery lottery|ny|075798 ↔ snap snap|us|1076598same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|075798 ↔ ny-sla 0081-23-222207same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|075798 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28same address and namemerged17
2026-11-20 22:08insertinspections inspections|nys-retail|704352 ↔ lottery lottery|ny|075798same address and namemerged17
2026-11-20 22:08insertab-inbev 4025097 ↔ lottery lottery|ny|075798same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|704352 ↔ snap snap|us|1076598same address and namemerged17
2026-11-19 20:37insertab-inbev 4025097 ↔ snap snap|us|1076598same address and namemerged17
2026-11-19 20:37insertny-sla 0081-23-222207 ↔ snap snap|us|1076598same address and namemerged17
2026-11-19 20:37insertoverture 125fb5a2-63ad-414c-809e-da0cbdfc8c28 ↔ snap snap|us|1076598same address and namemerged17
2026-11-19 20:37insertab-inbev 4025097 ↔ inspections inspections|nys-retail|704352same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|704352 ↔ ny-sla 0081-23-222207same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|704352 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28same address and namemerged17
2026-11-12 14:25insertab-inbev 4025097 ↔ ny-sla 0081-23-222207same address and namemerged12
2026-11-12 14:25insertab-inbev 4025097 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28same address and namemerged12
2026-11-06 18:13insertny-sla 0081-23-222207 ↔ overture 125fb5a2-63ad-414c-809e-da0cbdfc8c28same address and namemerged11