Beer Castle

BROOKLYN, NY 11236 · O04c0fe68d810 · first seen 2026-11-02
5 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 3 other
a source's own spelling of the licence name (record_title.py)
LEMBERG ENTERPRISES INC inspections (legal name)
ROJAN LLC ny-sla (legal name)
The Beer Castle ny-sla
Street
854 860 RALPH AVE 2 other
ny-sla
860 RALPH AVE ab-inbevoverturevtinfo ×3
854 RALPH AVE inspections
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; O077c88c13900

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-19
inspectionsBEER CASTLE
legal name: LEMBERG ENTERPRISES INC
inspections|nys-retail|612750
854 RALPH AVE, Brooklyn, NY, 1123640.65329, -73.920862026-11-192026-11-19
ny-slaThe Beer Castle
legal name: ROJAN LLC
0001-24-110009
854 860 RALPH AVE, BROOKLYN, NY, 1123640.65324, -73.920852026-11-022026-11-19
overtureBeer Castle
8e6c2171-3eb0-42b6-9c4c-3efe173b13a8
860 Ralph Ave, Brooklyn, NY, 11236718385145340.65324, -73.921052026-11-132026-11-19
vtinfoBEER CASTLE
b644bd91ae812f1c
860 RALPH AVE, BROOKLYN, NY, 11236718385145340.65323, -73.921062026-11-122026-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 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
inspections BEER CASTLEny-sla The Beer Castle1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 6 m apart · name similarity 1.00 · street similarity 0.82
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 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": []
}

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:37insertinspections inspections|nys-retail|612750 ↔ ny-sla 0001-24-110009street written two waysmerged17
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