Hotel Solsville

Madison, NY 13402 · O433a94efd0af · first seen 2026-11-02
5 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
Hotel Solsville 1 other
a source's own spelling of the licence name (record_title.py)
HOTEL SOLSVILLE INC ny-sla
Street
7243 VALLEY ROAD 1 other
ny-sla
7243 VALLEY RD ab-inbevlotteryoverture ×3
City
MADISON
ny-slano other value
State
NY
ny-slano other value
ZIP
13402
ny-slano other value
Pin
42.91064, -75.51815 map 1 other
overture
77 m away lottery
Phone
3158937698
overtureno other value
Licences
ny-sla 0343-23-215788
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of00ab3a5a7e0; Od4f67fea68d3; Ob6ccde650eb9; O636c612e31a2

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-inbevHOTEL SOLSVILLE
2913271
7243 VALLEY RD, MADISON, NY, 1340242.91071, -75.517752026-11-122026-11-20
inspectionsHOTEL SOLSVILLE
inspections|nys|281406
7243 VALLEY ROAD, Madison, NY, 1340242.91059, -75.518042026-11-192026-11-20
lotteryHOTEL SOLSVILLE
lottery|ny|042162
7243 VALLEY RD, Madison, NY, 1340242.91080, -75.517232026-11-202026-11-20
ny-slaHOTEL SOLSVILLE INC
0343-23-215788
7243 VALLEY ROAD, MADISON, NY, 1340242.91054, -75.518052026-11-022026-11-20
overtureHotel Solsville
ab1fe6ed-0004-4c93-82d8-a54e084ed00a
7243 Valley Rd, Madison, NY, 13402315893769842.91064, -75.518152026-11-062026-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
ab-inbev HOTEL SOLSVILLEinspections HOTEL SOLSVILLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ab-inbev HOTEL SOLSVILLElottery HOTEL SOLSVILLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev HOTEL SOLSVILLEny-sla HOTEL SOLSVILLE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev HOTEL SOLSVILLEoverture Hotel Solsville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
inspections HOTEL SOLSVILLElottery HOTEL SOLSVILLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 70 m apart · name similarity 1.00
inspections HOTEL SOLSVILLEny-sla HOTEL SOLSVILLE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
inspections HOTEL SOLSVILLEoverture Hotel Solsville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
lottery HOTEL SOLSVILLEny-sla HOTEL SOLSVILLE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 73 m apart · name similarity 1.00
lottery HOTEL SOLSVILLEoverture Hotel Solsville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
ny-sla HOTEL SOLSVILLE INCoverture Hotel Solsville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HOTEL SOLSVILLE INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0343
Rule version 11, computed 2026-11-20 23:33.
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|042162 ↔ ny-sla 0343-23-215788same address and namemerged17
2026-11-20 22:08insertab-inbev 2913271 ↔ lottery lottery|ny|042162same address and namemerged17
2026-11-20 22:08insertinspections inspections|nys|281406 ↔ lottery lottery|ny|042162same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|042162 ↔ overture ab1fe6ed-0004-4c93-82d8-a54e084ed00asame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|281406 ↔ ny-sla 0343-23-215788same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|281406 ↔ overture ab1fe6ed-0004-4c93-82d8-a54e084ed00asame address and namemerged17
2026-11-19 20:37insertab-inbev 2913271 ↔ inspections inspections|nys|281406same address and namemerged17
2026-11-12 14:25insertab-inbev 2913271 ↔ ny-sla 0343-23-215788same address and namemerged12
2026-11-12 14:25insertab-inbev 2913271 ↔ overture ab1fe6ed-0004-4c93-82d8-a54e084ed00asame address and namemerged12
2026-11-06 18:13insertny-sla 0343-23-215788 ↔ overture ab1fe6ed-0004-4c93-82d8-a54e084ed00asame address and namemerged11