Pig Beach

ASTORIA, NY 11106 · O1079e1fec6fb · 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
Pig Beach 2 other
a licence name in capitals, cleaned (derived; record_title.py)
PB LIC LLC AND PIG BEACH LIC BBQ LLC ny-sla (legal name)
pig beach bbq queens astoria doordash
Street
35-33 36TH ST 3 other
ny-sla
35 37 36TH ST ab-inbevvtinfo ×2
35-33 36 STREET inspections
35-37 36th Street doordash
City
ASTORIA 1 other
ny-sla
Queens inspections
State
NY
ny-slano other value
ZIP
11106
ny-slano other value
Pin
40.75523, -73.92521 map 1 other
doordash
52 m away inspections
Phone
7183626111
vtinfono other value
Licences
ny-sla 0417-23-141549
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O96fa63ad382a; O7d826c3142c8; O301c8805bca1; O485257e0202b

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-inbevPIG BEACH
4479106
35 37 36TH ST, ASTORIA, NY, 1110640.75517, -73.925312026-11-132026-11-18
doordashpig beach bbq queens astoria
23561926
35-37 36th Street, Astoria, NY, 1110640.75523, -73.925212026-10-082026-11-18
inspectionsPIG BEACH
inspections|nyc|50113199
35-33 36 STREET, Queens, NY, 11106718362611140.75566, -73.924972026-11-192026-11-19
ny-slaPIG BEACH
legal name: PB LIC LLC AND PIG BEACH LIC BBQ LLC
0417-23-141549
35-33 36TH ST, ASTORIA, NY, 1110640.75542, -73.925182026-11-022026-11-05
vtinfoPIG BEACH
aff64b5de4a99729
35 37 36TH ST, ASTORIA, NY, 11106718362611140.75497, -73.924932026-11-112026-11-18

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 PIG BEACHny-sla PIG BEACH1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same distinctive name, adjacent address numbers
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are named PIG BEACH on the same block of 36th St in Astoria, ZIP 11106, about 30 m apart; the house numbers differ slightly (35 37 vs 35-33), and the names agree exactly, which carries the match in a building shared with another business.
pair c498609f1edd4e411410
ab-inbev PIG BEACHvtinfo PIG BEACH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
inspections PIG BEACHny-sla PIG BEACH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ny-sla PIG BEACHvtinfo PIG BEACH1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Same name, adjoining address range 35-33/35-37
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are named PIG BEACH in the same ZIP 11106, with coordinates about 54 m apart and a legal name (PIG BEACH LIC BBQ LLC) that fits the trade name; the street numbers differ slightly (35-33 vs 35 37) but the names agree in a building shared with another business.
pair 39fce970ccb4d7ef8acc
doordash pig beach bbq queens astoriany-sla PIG BEACH0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Pig Beach names match, adjacent street numbers
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — The DoorDash listing 'pig beach bbq queens astoria' matches the NY SLA licence 'PIG BEACH' whose legal name includes 'PIG BEACH LIC BBQ LLC', the two coordinates are about 21 m apart, and the house numbers (35-37 vs 35-33) plausibly refer to the same building, so the names agree despite the shared-building count.
pair 5e4fe2e7bd8fe6a2a521
ab-inbev PIG BEACHdoordash pig beach bbq queens astoria0.56Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Same name and address, Pig Beach Astoria.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 35-37 36th Street, Astoria NY 11106 with coordinates about 11 m apart, no other business is held at that address, and the DoorDash slug 'pig beach bbq queens astoria' matches the AB InBev account name 'PIG BEACH'.
pair f017b14b0a4aac225c42
doordash pig beach bbq queens astoriavtinfo PIG BEACH0.56Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Pig Beach at same address, same name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records are Pig Beach at 35-37 36th Street (35 37 36TH ST), Astoria NY 11106, with coordinates about 37 m apart and no other business at that address, so the DoorDash listing and the VIP brand-finder account are one outlet.
pair 7a9923700a3aac65006d

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PB LIC LLC AND PIG BEACH LIC BBQ LLC — 2 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0417
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,531 within 1 mi · 8,359 within 3 mi
Off / on premise
160 / 803 within 1 mi · 1,007 / 4,340 within 3 mi
Selling alcohol
782 within 1 mi · 5,006 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
urban (35,068 people per sq mi)
People within 3 mi
991,535 (811,765 adults 21+, 448,972 households) from 279 tract(s), tracts within 3 mi
Income
per capita $78,497 · median household ~$115,469 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 56%
Ethnicity
Hispanic 28% · White 46% · Black 6% · Asian 20%
Adults per alcohol outlet
162
Alcohol spend within 3 mi
$370,524,675 a year ($162,291,967 at home, $208,097,335 away) · $74,001 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-19 20:37insertinspections inspections|nyc|50113199 ↔ ny-sla 0417-23-141549same address and namemerged17
2026-11-18 18:58insertab-inbev 4479106 ↔ doordash 23561926Claude judge: samemerged15
2026-11-18 18:58insertdoordash 23561926 ↔ vtinfo aff64b5de4a99729Claude judge: samemerged15
2026-11-18 18:58insertdoordash 23561926 ↔ ny-sla 0417-23-141549Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4479106 ↔ ny-sla 0417-23-141549Claude judge: samemerged15
2026-11-18 18:58insertny-sla 0417-23-141549 ↔ vtinfo aff64b5de4a99729Claude judge: samemerged15
2026-11-13 17:47insertab-inbev 4479106 ↔ vtinfo aff64b5de4a99729same address and namemerged15