Fetch Bar

Warwick, NY 10990 · O070640e7d30c · first seen 2026-10-08
7 sourceson premise · restaurantalcohol: 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
Fetch Bar 7 other
a licence name in capitals, cleaned (derived; record_title.py)
AJ Warwick, Inc. inspections (legal name)ny-sla (legal name) ×2
FETCH ny-sla
Fetch Bar & Grill overture
Fetch Bar and Grill inspections
fetch bar and grill warwick doordash
Fetch Bar Grill toast (legal name)
Fetch Bar Grill 48 Main Street toast
Street
48 MAIN ST 1 other
ny-sla
48 Main Street doordashinspectionstoast ×3
City
WARWICK
ny-slano other value
State
NY
ny-slano other value
ZIP
10990
ny-slano other value
Pin
41.25730, -74.35902 map
toastno other value
Phone
8459878200
vtinfono other value
Licences
ny-sla 0340-21-219197
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O923734d44b86; O734bff2da915; Ocf05f887fafa; Oe93f452fdbc7; Oe27665eeea9f; O518a703d50ca

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-inbevFETCH BAR
3307688
48 MAIN ST, WARWICK, NY, 1099041.25738, -74.359172026-11-162026-11-19
doordashfetch bar and grill warwick
22999812
48 Main Street, Warwick, NY, 1099041.25733, -74.359102026-10-082026-11-19
inspectionsFetch Bar and Grill
legal name: AJ Warwick, Inc.
inspections|nys|814703
48 MAIN STREET, Warwick, NY, 1099041.25740, -74.359142026-11-192026-11-19
ny-slaFETCH
legal name: AJ WARWICK INC
0340-21-219197
48 MAIN ST, WARWICK, NY, 1099041.25741, -74.359232026-11-022026-11-19
overtureFetch Bar & Grill
851faec5-5661-4401-83c6-6b4f8fb04737
48 Main St, Warwick, NY, 10990845987820041.25734, -74.359142026-11-092026-11-19
toastFetch Bar Grill 48 Main Street
legal name: Fetch Bar Grill
5432e9d5-7e07-4794-b1f6-acb3e062fc8c
48 Main Street, Warwick, NY, 10990845987820041.25730, -74.359022026-11-062026-11-19
vtinfoFETCH BAR
12890804f1a35c20
48 MAIN ST, WARWICK, NY, 10990845987820041.25709, -74.358792026-11-162026-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 FETCH BARvtinfo FETCH BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00
doordash fetch bar and grill warwickinspections Fetch Bar and Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash fetch bar and grill warwickoverture Fetch Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
doordash fetch bar and grill warwicktoast Fetch Bar Grill 48 Main Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · matched through the licence's legal name: Fetch Bar Grill · name similarity 1.00
inspections Fetch Bar and Grillny-sla FETCH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: AJ WARWICK INC · name similarity 1.00
inspections Fetch Bar and Grilloverture Fetch Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
inspections Fetch Bar and Grilltoast Fetch Bar Grill 48 Main Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · matched through the licence's legal name: Fetch Bar Grill · name similarity 1.00
overture Fetch Bar & Grilltoast Fetch Bar Grill 48 Main Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · matched through the licence's legal name: Fetch Bar Grill · name similarity 1.00 · phone: equal
ab-inbev FETCH BARdoordash fetch bar and grill warwick0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 8 m apart · name similarity 0.71
ab-inbev FETCH BARinspections Fetch Bar and Grill0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 3 m apart · name similarity 0.71
ab-inbev FETCH BARoverture Fetch Bar & Grill0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 5 m apart · name similarity 0.71
ab-inbev FETCH BARtoast Fetch Bar Grill 48 Main Street0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 15 m apart · matched through the licence's legal name: Fetch Bar Grill · name similarity 0.71
doordash fetch bar and grill warwickvtinfo FETCH BAR0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 37 m apart · name similarity 0.71
inspections Fetch Bar and Grillvtinfo FETCH BAR0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 45 m apart · name similarity 0.71
overture Fetch Bar & Grillvtinfo FETCH BAR0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 41 m apart · name similarity 0.71 · phone: equal
toast Fetch Bar Grill 48 Main Streetvtinfo FETCH BAR0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 30 m apart · matched through the licence's legal name: Fetch Bar Grill · name similarity 0.71 · phone: equal
ab-inbev FETCH BARny-sla FETCH0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.53 · same street + ZIP · pins 6 m apart · name similarity 0.61
ny-sla FETCHvtinfo FETCH BAR0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.53 · same street + city + state · pins 51 m apart · name similarity 0.61
doordash fetch bar and grill warwickny-sla FETCH0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.78 · same street + ZIP · pins 14 m apart · name similarity 0.42
ny-sla FETCHoverture Fetch Bar & Grill0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.78 · same street + ZIP · pins 11 m apart · name similarity 0.42

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
AJ WARWICK INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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:37insertab-inbev 3307688 ↔ inspections inspections|nys|814703same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|814703 ↔ vtinfo 12890804f1a35c20same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|814703 ↔ toast 5432e9d5-7e07-4794-b1f6-acb3e062fc8csame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|814703 ↔ ny-sla 0340-21-219197same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|814703 ↔ overture 851faec5-5661-4401-83c6-6b4f8fb04737same address and namemerged17
2026-11-19 20:37insertdoordash 22999812 ↔ inspections inspections|nys|814703same address and namemerged17
2026-11-16 14:56insertny-sla 0340-21-219197 ↔ vtinfo 12890804f1a35c20same address and namemerged15
2026-11-16 14:56insertab-inbev 3307688 ↔ ny-sla 0340-21-219197same address and namemerged15
2026-11-16 14:56inserttoast 5432e9d5-7e07-4794-b1f6-acb3e062fc8c ↔ vtinfo 12890804f1a35c20same address and namemerged15
2026-11-16 14:56insertoverture 851faec5-5661-4401-83c6-6b4f8fb04737 ↔ vtinfo 12890804f1a35c20same address and namemerged15
2026-11-16 14:56insertdoordash 22999812 ↔ vtinfo 12890804f1a35c20same address and namemerged15
2026-11-16 14:56insertab-inbev 3307688 ↔ toast 5432e9d5-7e07-4794-b1f6-acb3e062fc8csame address and namemerged15
2026-11-16 14:56insertab-inbev 3307688 ↔ overture 851faec5-5661-4401-83c6-6b4f8fb04737same address and namemerged15
2026-11-16 14:56insertab-inbev 3307688 ↔ doordash 22999812same address and namemerged15
2026-11-16 14:56insertab-inbev 3307688 ↔ vtinfo 12890804f1a35c20same address and namemerged15
2026-11-12 17:29insertny-sla 0340-21-219197 ↔ overture 851faec5-5661-4401-83c6-6b4f8fb04737same address and namemerged14
2026-11-12 17:29insertdoordash 22999812 ↔ ny-sla 0340-21-219197same address and namemerged14
2026-11-12 14:25insertoverture 851faec5-5661-4401-83c6-6b4f8fb04737 ↔ toast 5432e9d5-7e07-4794-b1f6-acb3e062fc8csame address and namemerged12
2026-11-12 14:25insertdoordash 22999812 ↔ toast 5432e9d5-7e07-4794-b1f6-acb3e062fc8csame address and namemerged12
2026-11-09 15:32insertdoordash 22999812 ↔ overture 851faec5-5661-4401-83c6-6b4f8fb04737same address and namemerged11