Outlets /
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.
| Field | Master value | Taken from | What 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 | ubereats | no other value |
| State | NJ | ubereats | no 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 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | WELSH FARMS FOOD & LIQUOR 2559111 | 55 QUEEN ANNE RD, BOGOTA, NJ, 07603 | 40.86788, -74.02241 | 2026-11-12 | 2026-11-19 | |
| doordash | welsh farms bogota 31664471 | 55 Queen Anne Rd, Bogota, NJ, 07603 | 40.86726, -74.02223 | 2026-10-08 | 2026-11-06 | |
| overture | Welsh Farms 2238705a-813b-4936-9fd4-31b6679e796b | 55 Queen Anne Rd, Bogota, NJ, 07603 | 2013429654 | 40.86719, -74.02221 | 2026-11-06 | 2026-11-06 |
| ubereats | Welsh Farms LDS8ss9CWouRV_lF724E1w | 55 Queen Anne Road, Bogota, NJ, 7603 | 40.86726, -74.02225 | 2026-11-13 | 2026-11-13 | |
| vtinfo | WELSH FARMS FOOD & LIQUOR a4a0f4f585fce0d9 | 55 QUEEN ANNE RD, BOGOTA, NJ, 07603 | 2013429654 | 40.86721, -74.02244 | 2026-11-12 | 2026-11-19 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev WELSH FARMS FOOD & LIQUOR | vtinfo WELSH FARMS FOOD & LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 75 m apart · name similarity 1.00 |
| doordash welsh farms bogota | overture Welsh Farms | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00 |
| doordash welsh farms bogota | ubereats Welsh Farms | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00 |
| overture Welsh Farms | ubereats Welsh Farms | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 |
| doordash welsh farms bogota | vtinfo WELSH FARMS FOOD & LIQUOR | 0.57 | Claude judge: same | merged | 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:
pair 106b29a227f0d5432d88 |
| ubereats Welsh Farms | vtinfo WELSH FARMS FOOD & LIQUOR | 0.57 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | ubereats LDS8ss9CWouRV_lF724E1w ↔ vtinfo a4a0f4f585fce0d9 | Claude judge: same | merged | 17 |
| 2026-11-19 20:37 | insert | doordash 31664471 ↔ vtinfo a4a0f4f585fce0d9 | Claude judge: same | merged | 17 |
| 2026-11-13 14:10 | insert | doordash 31664471 ↔ ubereats LDS8ss9CWouRV_lF724E1w | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture 2238705a-813b-4936-9fd4-31b6679e796b ↔ ubereats LDS8ss9CWouRV_lF724E1w | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2559111 ↔ vtinfo a4a0f4f585fce0d9 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 31664471 ↔ overture 2238705a-813b-4936-9fd4-31b6679e796b | same address and name | merged | 11 |