Outlets /
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.
| Field | Master value | Taken from | What 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-sla | no other value |
| ZIP | 11106 | ny-sla | no other value |
| Pin | 40.75523, -73.92521 map 1 other | doordash | 52 m away inspections |
| Phone | 7183626111 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | PIG BEACH 4479106 | 35 37 36TH ST, ASTORIA, NY, 11106 | 40.75517, -73.92531 | 2026-11-13 | 2026-11-18 | |
| doordash | pig beach bbq queens astoria 23561926 | 35-37 36th Street, Astoria, NY, 11106 | 40.75523, -73.92521 | 2026-10-08 | 2026-11-18 | |
| inspections | PIG BEACH inspections|nyc|50113199 | 35-33 36 STREET, Queens, NY, 11106 | 7183626111 | 40.75566, -73.92497 | 2026-11-19 | 2026-11-19 |
| ny-sla | PIG BEACH legal name: PB LIC LLC AND PIG BEACH LIC BBQ LLC 0417-23-141549 | 35-33 36TH ST, ASTORIA, NY, 11106 | 40.75542, -73.92518 | 2026-11-02 | 2026-11-05 | |
| vtinfo | PIG BEACH aff64b5de4a99729 | 35 37 36TH ST, ASTORIA, NY, 11106 | 7183626111 | 40.75497, -73.92493 | 2026-11-11 | 2026-11-18 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev PIG BEACH | ny-sla PIG BEACH | 1.00 | Claude judge: same | merged | 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:
pair c498609f1edd4e411410 |
| ab-inbev PIG BEACH | vtinfo PIG BEACH | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00 |
| inspections PIG BEACH | ny-sla PIG BEACH | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00 |
| ny-sla PIG BEACH | vtinfo PIG BEACH | 1.00 | Claude judge: same | merged | 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:
pair 39fce970ccb4d7ef8acc |
| doordash pig beach bbq queens astoria | ny-sla PIG BEACH | 0.57 | Claude judge: same | merged | 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:
pair 5e4fe2e7bd8fe6a2a521 |
| ab-inbev PIG BEACH | doordash pig beach bbq queens astoria | 0.56 | Claude judge: same | merged | 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:
pair f017b14b0a4aac225c42 |
| doordash pig beach bbq queens astoria | vtinfo PIG BEACH | 0.56 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | inspections inspections|nyc|50113199 ↔ ny-sla 0417-23-141549 | same address and name | merged | 17 |
| 2026-11-18 18:58 | insert | ab-inbev 4479106 ↔ doordash 23561926 | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | doordash 23561926 ↔ vtinfo aff64b5de4a99729 | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | doordash 23561926 ↔ ny-sla 0417-23-141549 | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 4479106 ↔ ny-sla 0417-23-141549 | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | ny-sla 0417-23-141549 ↔ vtinfo aff64b5de4a99729 | Claude judge: same | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 4479106 ↔ vtinfo aff64b5de4a99729 | same address and name | merged | 15 |