Mermaid Liquor House

Brooklyn, NY 11224 · O0a082109c553 · 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
Mermaid Liquor House 1 other
a source's own spelling of the licence name (record_title.py)
MERMAID LIQUOR HOUSE INC ny-sla
Street
3030 MERMAID AVE 1 other
ny-sla
3030 MERMAID AVENUE lottery
City
BROOKLYN
ny-slano other value
State
NY
ny-slano other value
ZIP
11224
ny-slano other value
Pin
40.57510, -73.99697 map
overtureno other value
Phone
3474923347
vtinfono other value
Licences
ny-sla 0100-21-115005
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O84019ec23f9b; Oea9f094d330d; O7b7df04c3533

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
lotteryMERMAID LIQUOR HOUSE
lottery|ny|107952
3030 MERMAID AVENUE, Brooklyn, NY, 1122440.57511, -73.997292026-11-202026-11-20
ny-slaMERMAID LIQUOR HOUSE INC
0100-21-115005
3030 MERMAID AVE, BROOKLYN, NY, 1122440.57526, -73.997322026-11-022026-11-20
overtureMermaid Liquor House
ff3e13bf-5b7a-446c-983e-5fbb834bba7d
3030 Mermaid Ave, Brooklyn, NY, 11224347492334740.57510, -73.996972026-11-062026-11-20
vtinfoMERMAID LIQUOR HOUSE
fba679a451846e07
3030 MERMAID AVE, BROOKLYN, NY, 11224347492334740.57510, -73.996972026-11-122026-11-20

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
lottery MERMAID LIQUOR HOUSEny-sla MERMAID LIQUOR HOUSE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
lottery MERMAID LIQUOR HOUSEoverture Mermaid Liquor House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
lottery MERMAID LIQUOR HOUSEvtinfo MERMAID LIQUOR HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ny-sla MERMAID LIQUOR HOUSE INCoverture Mermaid Liquor House1.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 MERMAID LIQUOR HOUSE INCvtinfo MERMAID LIQUOR HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00
overture Mermaid Liquor Housevtinfo MERMAID LIQUOR HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MERMAID LIQUOR HOUSE INC — 1 outlets in the master under this operator
Licence privileges
wine_off, spirits_off — NY 0100
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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-20 22:08insertlottery lottery|ny|107952 ↔ overture ff3e13bf-5b7a-446c-983e-5fbb834bba7dsame address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|107952 ↔ ny-sla 0100-21-115005same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|107952 ↔ vtinfo fba679a451846e07same address and namemerged17
2026-11-12 14:25insertoverture ff3e13bf-5b7a-446c-983e-5fbb834bba7d ↔ vtinfo fba679a451846e07same address and namemerged12
2026-11-12 14:25insertny-sla 0100-21-115005 ↔ vtinfo fba679a451846e07same address and namemerged12
2026-11-06 18:13insertny-sla 0100-21-115005 ↔ overture ff3e13bf-5b7a-446c-983e-5fbb834bba7dsame address and namemerged11