Welsh Farms Food & Liquor

Bogota, NJ 07603 · O134dd7260367 · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: Quicklly Liquor Storesalcohol: alcohol

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
Welsh Farms Food & Liquor 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Welsh Farms overtureubereats ×2
welsh farms bogota doordash
Street
55 Queen Anne Road 1 other
ubereats
55 QUEEN ANNE RD ab-inbevdoordashoverturevtinfo ×4
City
Bogota
ubereatsno other value
State
NJ
ubereatsno other value
ZIP
7603 1 other
ubereats
07603 ab-inbevdoordashoverturevtinfo ×4
Pin
40.86726, -74.02225 map 1 other
ubereats
70 m away ab-inbev
Phone
2013429654
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob93a12aee046; Ofe634926ddd5; O630846bf5a98; Oa8421e1e07fd

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-inbevWELSH FARMS FOOD & LIQUOR
2559111
55 QUEEN ANNE RD, BOGOTA, NJ, 0760340.86788, -74.022412026-11-122026-11-19
doordashwelsh farms bogota
31664471
55 Queen Anne Rd, Bogota, NJ, 0760340.86726, -74.022232026-10-082026-11-06
overtureWelsh Farms
2238705a-813b-4936-9fd4-31b6679e796b
55 Queen Anne Rd, Bogota, NJ, 07603201342965440.86719, -74.022212026-11-062026-11-06
ubereatsWelsh Farms
LDS8ss9CWouRV_lF724E1w
55 Queen Anne Road, Bogota, NJ, 760340.86726, -74.022252026-11-132026-11-13
vtinfoWELSH FARMS FOOD & LIQUOR
a4a0f4f585fce0d9
55 QUEEN ANNE RD, BOGOTA, NJ, 07603201342965440.86721, -74.022442026-11-122026-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 WELSH FARMS FOOD & LIQUORvtinfo WELSH FARMS FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 75 m apart · name similarity 1.00
doordash welsh farms bogotaoverture Welsh Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash welsh farms bogotaubereats Welsh Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
overture Welsh Farmsubereats Welsh Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
doordash welsh farms bogotavtinfo WELSH FARMS FOOD & LIQUOR0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Same name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 55 Queen Anne Rd, Bogota NJ 07603 with coordinates about 18 m apart, and the DoorDash listing 'welsh farms bogota' matches the VTInfo account 'WELSH FARMS FOOD & LIQUOR' as the same Welsh Farms store at the only business recorded at that address.
pair 106b29a227f0d5432d88
ubereats Welsh Farmsvtinfo WELSH FARMS FOOD & LIQUOR0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Welsh Farms Food & Liquor at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records place Welsh Farms at 55 Queen Anne Road, Bogota NJ 07603, about 17 m apart, with no other business at that address, and the names match (Welsh Farms vs. Welsh Farms Food & Liquor).
pair 1a5acd187e5d2733b709

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
Quicklly Liquor Stores — ubereats-parent
Alcohol
alcohol — channel liquor_store
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
120 within 1 mi · 1,131 within 3 mi
Off / on premise
28 / 76 within 1 mi · 198 / 718 within 3 mi
Selling alcohol
41 within 1 mi · 335 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.28 mi
Setting
urban (7,985 people per sq mi)
People within 3 mi
225,776 (176,302 adults 21+, 87,212 households) from 50 tract(s), tracts within 3 mi
Income
per capita $53,286 · median household ~$105,231 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 47%
Ethnicity
Hispanic 32% · White 37% · Black 12% · Asian 21%
Adults per alcohol outlet
525
Alcohol spend within 3 mi
$69,682,519 a year ($30,925,334 at home, $38,728,579 away) · $207,388 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:37insertubereats LDS8ss9CWouRV_lF724E1w ↔ vtinfo a4a0f4f585fce0d9Claude judge: samemerged17
2026-11-19 20:37insertdoordash 31664471 ↔ vtinfo a4a0f4f585fce0d9Claude judge: samemerged17
2026-11-13 14:10insertdoordash 31664471 ↔ ubereats LDS8ss9CWouRV_lF724E1wsame address and namemerged15
2026-11-13 14:10insertoverture 2238705a-813b-4936-9fd4-31b6679e796b ↔ ubereats LDS8ss9CWouRV_lF724E1wsame address and namemerged15
2026-11-12 14:25insertab-inbev 2559111 ↔ vtinfo a4a0f4f585fce0d9same address and namemerged12
2026-11-06 18:13insertdoordash 31664471 ↔ overture 2238705a-813b-4936-9fd4-31b6679e796bsame address and namemerged11