The Red Jug Pub

BINGHAMTON, NY 13905 · O71547d3f4608 · first seen 2026-11-02
3 sourceson premise · predictedalcohol: 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
The Red Jug Pub 1 other
a licence name in capitals, cleaned (derived; record_title.py)
RED JUG BINGO INC ny-sla (legal name)
Street
17 MAIN ST
ny-slano other value
City
BINGHAMTON
ny-slano other value
State
NY
ny-slano other value
ZIP
13905
ny-slano other value
Pin
42.09887, -75.91797 map
ny-slano other value
Phone
6072387193
vtinfono other value
Licences
ny-sla 0370-23-231041
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocbf6826c833d; O88e285ba775f

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-inbevTHE RED JUG PUB
4457710
17 MAIN ST, BINGHAMTON, NY, 1390542.09878, -75.917882026-11-112026-11-11
ny-slaTHE RED JUG PUB
legal name: RED JUG BINGO INC
0370-23-231041
17 MAIN ST, BINGHAMTON, NY, 1390542.09887, -75.917972026-11-022026-11-11
vtinfoTHE RED JUG PUB
355174be8878c731
17 MAIN ST, BINGHAMTON, NY, 13905607238719342.09860, -75.917952026-11-142026-11-14

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 THE RED JUG PUBny-sla THE RED JUG PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev THE RED JUG PUBvtinfo THE RED JUG PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ny-sla THE RED JUG PUBvtinfo THE RED JUG PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RED JUG BINGO INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
207 within 1 mi · 372 within 3 mi
Off / on premise
31 / 87 within 1 mi · 67 / 166 within 3 mi
Selling alcohol
150 within 1 mi · 264 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
suburban (2,625 people per sq mi)
People within 3 mi
74,228 (52,723 adults 21+, 29,577 households) from 23 tract(s), tracts within 3 mi
Income
per capita $27,647 · median household ~$51,654 (weighted mean of tract medians)
Age and education
median age ~36.0 · bachelor's or higher 31%
Ethnicity
Hispanic 7% · White 70% · Black 11% · Asian 9%
Adults per alcohol outlet
199
Alcohol spend within 3 mi
$14,582,352 a year ($7,058,372 at home, $7,516,277 away) · $55,028 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-14 20:23insertab-inbev 4457710 ↔ vtinfo 355174be8878c731same address and namemerged15
2026-11-14 20:23insertny-sla 0370-23-231041 ↔ vtinfo 355174be8878c731same address and namemerged15
2026-11-11 12:56insertab-inbev 4457710 ↔ ny-sla 0370-23-231041same address and namemerged12