Best Farms

HICKSVILLE, NY 11801 · O2093a129889d · first seen 2026-11-02
5 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
Best Farms 1 other
a licence name in capitals, cleaned (derived; record_title.py)
Frasch Foods Inc overtureinspections (legal name)ny-sla (legal name) ×3
Street
434 JERUSALEM AVE
ny-slano other value
City
HICKSVILLE
ny-slano other value
State
NY
ny-slano other value
ZIP
11801
ny-slano other value
Pin
40.74935, -73.51911 map
overtureno other value
Phone
5168223232
vtinfono other value
Licences
ny-sla 0081-23-112622
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9981c78654eb; Oa1061eed990d; O78f9e74604a4; O917ad272578d

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-inbevBEST FARMS
4321439
434 JERUSALEM AVE, HICKSVILLE, NY, 1180140.74955, -73.519012026-11-112026-11-11
inspectionsBEST FARMS
legal name: FRASCH FOODS INC
inspections|nys-retail|740722
434 JERUSALEM AVE, Hicksville, NY, 1180140.74941, -73.518862026-11-192026-11-19
ny-slaBEST FARMS
legal name: FRASCH FOODS INC
0081-23-112622
434 JERUSALEM AVE, HICKSVILLE, NY, 1180140.74941, -73.518862026-11-022026-11-11
overtureFrasch Foods Inc
8899e8f8-c988-4c03-b535-dabe450fa903
434 Jerusalem Ave, Hicksville, NY, 1180140.74935, -73.519112026-11-062026-11-11
vtinfoBEST FARMS
ddb5a98b73b2fb4f
434 JERUSALEM AVE, HICKSVILLE, NY, 11801516822323240.74936, -73.519112026-11-112026-11-18

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 BEST FARMSinspections BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev BEST FARMSny-sla BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev BEST FARMSvtinfo BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
inspections BEST FARMSny-sla BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections BEST FARMSoverture Frasch Foods Inc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · matched through the licence's legal name: FRASCH FOODS INC · name similarity 1.00
inspections BEST FARMSvtinfo BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ny-sla BEST FARMSoverture Frasch Foods Inc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · matched through the licence's legal name: FRASCH FOODS INC · name similarity 1.00
ny-sla BEST FARMSvtinfo BEST FARMS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00

Attributes

Channel
off_premise — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FRASCH FOODS INC — 1 outlets in the master under this operator
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
  ]
 ]
}

Trade area

Other outlets
113 within 1 mi · 908 within 3 mi
Off / on premise
19 / 68 within 1 mi · 202 / 505 within 3 mi
Selling alcohol
39 within 1 mi · 462 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (6,343 people per sq mi)
People within 3 mi
179,358 (136,248 adults 21+, 56,607 households) from 35 tract(s), tracts within 3 mi
Income
per capita $55,337 · median household ~$148,397 (weighted mean of tract medians)
Age and education
median age ~42.2 · bachelor's or higher 43%
Ethnicity
Hispanic 22% · White 54% · Black 4% · Asian 20%
Adults per alcohol outlet
294
Alcohol spend within 3 mi
$56,339,615 a year ($24,084,373 at home, $32,236,106 away) · $121,684 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

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-19 20:37insertinspections inspections|nys-retail|740722 ↔ ny-sla 0081-23-112622same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|740722 ↔ overture 8899e8f8-c988-4c03-b535-dabe450fa903same address and namemerged17
2026-11-19 20:37insertab-inbev 4321439 ↔ inspections inspections|nys-retail|740722same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|740722 ↔ vtinfo ddb5a98b73b2fb4fsame address and namemerged17
2026-11-11 12:56insertab-inbev 4321439 ↔ vtinfo ddb5a98b73b2fb4fsame address and namemerged12
2026-11-11 12:56insertny-sla 0081-23-112622 ↔ vtinfo ddb5a98b73b2fb4fsame address and namemerged12
2026-11-11 12:56insertab-inbev 4321439 ↔ ny-sla 0081-23-112622same address and namemerged12
2026-11-06 18:13insertny-sla 0081-23-112622 ↔ overture 8899e8f8-c988-4c03-b535-dabe450fa903same address and namemerged11