EJ'S Bar & Grill

Hamburg, NY 14075 · O12d80f964d17 · first seen 2026-10-08
5 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
EJ'S Bar & Grill 2 other
a source's own spelling of the licence name (record_title.py)
EJS BAR & GRILL ab-inbevvtinfo ×2
ejs bar grill 5822 camp rd hamburg doordash
Street
5822 Camp Rd
ny-slano other value
City
Hamburg
ny-slano other value
State
NY
ny-slano other value
ZIP
14075
ny-slano other value
Pin
42.72896, -78.83664 map
doordashno other value
Phone
7162021373
vtinfono other value
Licences
ny-sla 0340-24-327112
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O2063cdfc1dd7; Oae82cf41b4c1; O4c0728384424; Oc0c633f37e01

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-inbevEJS BAR & GRILL
4731272
5822 CAMP RD, HAMBURG, NY, 1407542.72919, -78.836202026-11-112026-11-11
doordashejs bar grill 5822 camp rd hamburg
33672281
5822 Camp Rd, Hamburg, NY, 1407542.72896, -78.836642026-10-082026-11-12
ny-slaEJ'S Bar & Grill
0340-24-327112
5822 Camp Rd, Hamburg, NY, 1407542.72878, -78.836762026-11-022026-11-03
overtureEJ's Bar & Grill
d4823d69-8b7a-44c7-82b5-762ec8ca8ae2
5822 Camp Rd, Hamburg, NY, 14075716202137342.72897, -78.836702026-11-062026-11-06
vtinfoEJS BAR & GRILL
d712c8c5f4251d6f
5822 CAMP RD, HAMBURG, NY, 14075716202137342.72917, -78.836622026-11-152026-11-15

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 EJS BAR & GRILLny-sla EJ'S Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ab-inbev EJS BAR & GRILLoverture EJ's Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00
ab-inbev EJS BAR & GRILLvtinfo EJS BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ny-sla EJ'S Bar & Grilloverture EJ's Bar & Grill1.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 EJ'S Bar & Grillvtinfo EJS BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
overture EJ's Bar & Grillvtinfo EJS BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00 · phone: equal
ab-inbev EJS BAR & GRILLdoordash ejs bar grill 5822 camp rd hamburg0.58Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (97% confident; asked as a “near” pair)
Same name (EJ's Bar & Grill) at the same street address, 5822 Camp Rd, Hamburg NY 14075, with only one business recorded at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 96% confident — EJS Bar & Grill same address.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same name (EJS Bar & Grill / ejs bar grill) at the identical street address 5822 Camp Rd, Hamburg NY 14075, with coordinates about 44 m apart and no other business at that address.
pair 053bd9d5ba94ca66e2a3

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
92 within 1 mi · 175 within 3 mi
Off / on premise
22 / 39 within 1 mi · 36 / 74 within 3 mi
Selling alcohol
63 within 1 mi · 124 within 3 mi
Nearest
same channel 0.35 mi · licensed 0.07 mi
Setting
suburban (1,385 people per sq mi)
People within 3 mi
39,152 (30,535 adults 21+, 17,226 households) from 7 tract(s), tracts within 3 mi
Income
per capita $48,835 · median household ~$91,210 (weighted mean of tract medians)
Age and education
median age ~46.8 · bachelor's or higher 41%
Ethnicity
Hispanic 3% · White 92% · Black 2% · Asian 1%
Adults per alcohol outlet
244
Alcohol spend within 3 mi
$12,412,617 a year ($5,659,479 at home, $6,748,081 away) · $99,301 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-15 16:24insertny-sla 0340-24-327112 ↔ vtinfo d712c8c5f4251d6fsame address and namemerged15
2026-11-15 16:24insertoverture d4823d69-8b7a-44c7-82b5-762ec8ca8ae2 ↔ vtinfo d712c8c5f4251d6fsame address and namemerged15
2026-11-15 16:24insertab-inbev 4731272 ↔ vtinfo d712c8c5f4251d6fsame address and namemerged15
2026-11-12 14:25insertab-inbev 4731272 ↔ doordash 33672281Claude judge: samemerged12
2026-11-11 12:56insertab-inbev 4731272 ↔ ny-sla 0340-24-327112same address and namemerged12
2026-11-11 12:56insertab-inbev 4731272 ↔ overture d4823d69-8b7a-44c7-82b5-762ec8ca8ae2same address and namemerged12
2026-11-06 18:13insertny-sla 0340-24-327112 ↔ overture d4823d69-8b7a-44c7-82b5-762ec8ca8ae2same address and namemerged11