4 Star Deli

Troy, NY 12180 · O1e78251520cd · first seen 2026-11-02
6 sourcesoff premisealcohol: 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
4 Star Deli 3 other
a licence name in capitals, cleaned (derived; record_title.py)
4 STAR GROCERY ab-inbevoverturevtinfo ×3
RAVINDER SINGH ny-sla (legal name)
SINGH RAVINDER inspections (legal name)
Street
273 4TH ST
ny-slano other value
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.72303, -73.69098 map 1 other
overture
67 m away ab-inbev
Phone
5182740520 1 other
vtinfo
5182383536 overture
Licences
ny-sla 0081-22-226456
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O77d163f9ab9e; O8c543ae5b76f; O834600ea24bc; Oa029bd5ed844; O5490678bdece

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-inbev4 STAR GROCERY
3245052
273 4TH ST, TROY, NY, 1218042.72361, -73.690762026-11-112026-11-20
inspections4 STAR DELI
legal name: SINGH RAVINDER
inspections|nys-retail|706047
273 4TH ST, Troy, NY, 1218042.72299, -73.690832026-11-192026-11-20
lottery4 STAR DELI
lottery|ny|075930
273 4TH ST, Troy, NY, 1218042.72306, -73.691002026-11-202026-11-20
ny-sla4 STAR DELI
legal name: RAVINDER SINGH
0081-22-226456
273 4TH ST, TROY, NY, 1218042.72299, -73.690832026-11-022026-11-20
overture4 Star Grocery
e8859da0-4ca2-4598-97b8-608d2265ed04
273 4th St, Troy, NY, 12180518238353642.72303, -73.690982026-11-132026-11-20
vtinfo4 STAR GROCERY
d98d489f7a51c166
273 4TH ST, TROY, NY, 12180518274052042.72303, -73.690982026-11-122026-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 4 STAR GROCERYoverture 4 Star Grocery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
ab-inbev 4 STAR GROCERYvtinfo 4 STAR GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 67 m apart · name similarity 1.00
inspections 4 STAR DELIlottery 4 STAR DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections 4 STAR DELIny-sla 4 STAR DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
lottery 4 STAR DELIny-sla 4 STAR DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture 4 Star Groceryvtinfo 4 STAR GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00 · phone: differs
ab-inbev 4 STAR GROCERYinspections 4 STAR DELI0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 69 m apart · name similarity 0.57
ab-inbev 4 STAR GROCERYlottery 4 STAR DELI0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 64 m apart · name similarity 0.57
ab-inbev 4 STAR GROCERYny-sla 4 STAR DELI0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 69 m apart · name similarity 0.57
inspections 4 STAR DELIoverture 4 Star Grocery0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 13 m apart · name similarity 0.57
inspections 4 STAR DELIvtinfo 4 STAR GROCERY0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 13 m apart · name similarity 0.57
lottery 4 STAR DELIoverture 4 Star Grocery0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 4 m apart · name similarity 0.57
lottery 4 STAR DELIvtinfo 4 STAR GROCERY0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 4 m apart · name similarity 0.57
ny-sla 4 STAR DELIoverture 4 Star Grocery0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + ZIP · pins 13 m apart · name similarity 0.57
ny-sla 4 STAR DELIvtinfo 4 STAR GROCERY0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, grocery · name Jaro-Winkler 0.73 · same street + city + state · pins 13 m apart · name similarity 0.57

Attributes

Channel
off_premise — overture-category
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": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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:08insertab-inbev 3245052 ↔ lottery lottery|ny|075930same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|075930 ↔ vtinfo d98d489f7a51c166same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|075930 ↔ overture e8859da0-4ca2-4598-97b8-608d2265ed04same address and namemerged17
2026-11-20 22:08insertinspections inspections|nys-retail|706047 ↔ lottery lottery|ny|075930same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|075930 ↔ ny-sla 0081-22-226456same address and namemerged17
2026-11-19 20:37insertab-inbev 3245052 ↔ inspections inspections|nys-retail|706047same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|706047 ↔ vtinfo d98d489f7a51c166same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|706047 ↔ overture e8859da0-4ca2-4598-97b8-608d2265ed04same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|706047 ↔ ny-sla 0081-22-226456same address and namemerged17
2026-11-13 14:10insertny-sla 0081-22-226456 ↔ overture e8859da0-4ca2-4598-97b8-608d2265ed04same address and namemerged15
2026-11-13 14:10insertoverture e8859da0-4ca2-4598-97b8-608d2265ed04 ↔ vtinfo d98d489f7a51c166same address and namemerged15
2026-11-13 14:10insertab-inbev 3245052 ↔ overture e8859da0-4ca2-4598-97b8-608d2265ed04same address and namemerged15
2026-11-12 17:29insertny-sla 0081-22-226456 ↔ vtinfo d98d489f7a51c166same address and namemerged14
2026-11-12 17:29insertab-inbev 3245052 ↔ ny-sla 0081-22-226456same address and namemerged14
2026-11-12 14:25insertab-inbev 3245052 ↔ vtinfo d98d489f7a51c166same address and namemerged12