Beer Castle

BROOKLYN, NY 11236 · O077c88c13900 · first seen 2026-11-02
4 sourcesoff premise · liquor_storealcohol: 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
Beer Castle 2 other
a source's own spelling of the licence name (record_title.py)
ROJAN LLC ny-sla (legal name)
The Beer Castle ny-sla
Street
854 860 RALPH AVE 1 other
ny-sla
860 RALPH AVE ab-inbevoverturevtinfo ×3
City
BROOKLYN
ny-slano other value
State
NY
ny-slano other value
ZIP
11236
ny-slano other value
Pin
40.65324, -73.92105 map
overtureno other value
Phone
7183851453
vtinfono other value
Licences
ny-sla 0001-24-110009
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od065b5e4e343; O2e023d7cd6ef; O1384b8ad7466

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-inbevBEER CASTLE
2619579
860 RALPH AVE, BROOKLYN, NY, 1123640.65283, -73.920882026-11-112026-11-12
ny-slaThe Beer Castle
legal name: ROJAN LLC
0001-24-110009
854 860 RALPH AVE, BROOKLYN, NY, 1123640.65324, -73.920852026-11-022026-11-12
overtureBeer Castle
8e6c2171-3eb0-42b6-9c4c-3efe173b13a8
860 Ralph Ave, Brooklyn, NY, 11236718385145340.65324, -73.921052026-11-132026-11-13
vtinfoBEER CASTLE
b644bd91ae812f1c
860 RALPH AVE, BROOKLYN, NY, 11236718385145340.65323, -73.921062026-11-122026-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 BEER CASTLEny-sla The Beer Castle1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Beer Castle name and address match.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name The Beer Castle at 860 Ralph Ave in Brooklyn, ZIP 11236, with coordinates about 46 m apart, and the NY-SLA record's legal entity ROJAN LLC is the licensee behind the trade name; the address shown as '854 860' is a shared-building listing variant and only one business is at that address in the data.
pair 3ea4bfffeb45b86719d2
ab-inbev BEER CASTLEoverture Beer Castle1.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 BEER CASTLEvtinfo BEER CASTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00
overture Beer Castlevtinfo BEER CASTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROJAN LLC — 2 outlets in the master under this operator
Licence privileges
beer_off — NY 0001
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
378 within 1 mi · 3,661 within 3 mi
Off / on premise
76 / 172 within 1 mi · 698 / 1,865 within 3 mi
Selling alcohol
213 within 1 mi · 2,075 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.04 mi
Setting
urban (38,664 people per sq mi)
People within 3 mi
1,093,185 (843,313 adults 21+, 429,538 households) from 340 tract(s), tracts within 3 mi
Income
per capita $41,933 · median household ~$79,677 (weighted mean of tract medians)
Age and education
median age ~38.3 · bachelor's or higher 36%
Ethnicity
Hispanic 17% · White 19% · Black 54% · Asian 5%
Adults per alcohol outlet
406
Alcohol spend within 3 mi
$282,424,109 a year ($128,897,098 at home, $153,388,178 away) · $136,042 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-13 14:10insertoverture 8e6c2171-3eb0-42b6-9c4c-3efe173b13a8 ↔ vtinfo b644bd91ae812f1csame address and namemerged15
2026-11-13 14:10insertab-inbev 2619579 ↔ overture 8e6c2171-3eb0-42b6-9c4c-3efe173b13a8same address and namemerged15
2026-11-12 17:29insertab-inbev 2619579 ↔ ny-sla 0001-24-110009Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2619579 ↔ vtinfo b644bd91ae812f1csame address and namemerged12