GG Campbell

NEW YORK, NY 10017 · O0b9766f319c1 · first seen 2026-11-02
4 sourceson premise · baralcohol: licensed3 licences

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
GG Campbell 4 other
a licence name in capitals, cleaned (derived; record_title.py)
GG CAMPBELL LLC ny-slany-sla (legal name) ×3
THE CAMPBELL inspectionsny-slaoverture ×3
Campbell Apartment overture
THE CAMPBELL APARTMENT vtinfo
Street
15 VANDERBILT AVE 1 other
ny-sla
15 VANDERBILT AVENUE inspections
City
NEW YORK
ny-slano other value
State
NY
ny-slano other value
ZIP
10017
ny-slano other value
Pin
40.75260, -73.97781 map 2 other
overture
87 m away overture
87 m away vtinfo
Phone
9172093440 1 other
vtinfo
2122971781 inspections
Licences
ny-sla 0370-23-136485 · ny-sla 0423-23-136135 · ny-sla 0423-23-137252
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocef015d8ca51; Obf71f3ee0c5b; Oe87badf93d59; Ob0b81160f02f; Oa27622f386a8; O200aa26f9dd4

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
inspectionsTHE CAMPBELL
inspections|nyc|50063550
15 VANDERBILT AVENUE, New York, NY, 10017212297178140.75279, -73.978072026-11-192026-11-19
ny-slaTHE CAMPBELL
legal name: GG CAMPBELL LLC
0370-23-136485
15 VANDERBILT AVE, NEW YORK, NY, 1001740.75292, -73.978002026-11-022026-11-19
ny-slaGG CAMPBELL LLC
0423-23-136135
15 VANDERBILT AVE, NEW YORK, NY, 1001740.75292, -73.978002026-11-022026-11-02
ny-slaGG CAMPBELL LLC
0423-23-137252
15 VANDERBILT AVE, NEW YORK, NY, 1001740.75292, -73.978002026-11-022026-11-03
overtureThe Campbell
2720c876-30c3-49a8-8439-2ad3b322fdf2
15 Vanderbilt Ave, New York, NY, 10017917209344040.75260, -73.977812026-11-062026-11-19
overtureCampbell Apartment
d0b092a2-46d2-4087-adfd-dc3047102726
15 Vanderbilt Ave, New York, NY, 1001740.75215, -73.978662026-11-132026-11-19
vtinfoTHE CAMPBELL APARTMENT
99c52d8283d401dd
15 VANDERBILT AVE, NEW YORK, NY, 10017917209344040.75215, -73.978662026-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
inspections THE CAMPBELLny-sla THE CAMPBELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections THE CAMPBELLoverture The Campbell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00 · phone: differs
ny-sla THE CAMPBELLoverture The Campbell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
ny-sla GG CAMPBELL LLCny-sla GG CAMPBELL LLC1.00one store listed twicemergedsame street + ZIP · name: identical
overture Campbell Apartmentvtinfo THE CAMPBELL APARTMENT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00
inspections THE CAMPBELLny-sla GG CAMPBELL LLC0.67same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 16 m apart · name similarity 0.67
inspections THE CAMPBELLny-sla GG CAMPBELL LLC0.67same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 16 m apart · name similarity 0.67
ny-sla GG CAMPBELL LLCoverture The Campbell0.67same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 39 m apart · name similarity 0.67
ny-sla GG CAMPBELL LLCoverture The Campbell0.67same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 39 m apart · name similarity 0.67
ny-sla THE CAMPBELLvtinfo THE CAMPBELL APARTMENT0.56one name contains the other, same addressmerged department listings of one storejudge: None · pair_id: 31ea500d6bd36ded1b1e · person: None · rule: names contained at one address · stratum: near
ny-sla GG CAMPBELL LLCvtinfo THE CAMPBELL APARTMENT0.44Claude judge: samemerged both outlets held a record of one source, each naming the same business
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
GG Campbell LLC is legal entity for Campbell Apartment.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — GG CAMPBELL LLC is the legal entity behind The Campbell Apartment, and both records sit at 15 Vanderbilt Ave, 0.1 km apart, so they most likely describe one bar, though the shared building (2 businesses at the address) keeps this from being certain.
pair 53ef261b983b34d36920

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GG CAMPBELL LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370; NY 0423 (add-on: follows the base licence)
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
5,239 within 1 mi · 16,117 within 3 mi
Off / on premise
559 / 2,671 within 1 mi · 1,737 / 8,870 within 3 mi
Selling alcohol
3,386 within 1 mi · 9,872 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.02 mi
Setting
urban (45,039 people per sq mi)
People within 3 mi
1,273,447 (1,073,394 adults 21+, 651,047 households) from 292 tract(s), tracts within 3 mi
Income
per capita $113,441 · median household ~$140,708 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 73%
Ethnicity
Hispanic 18% · White 59% · Black 6% · Asian 15%
Adults per alcohol outlet
109
Alcohol spend within 3 mi
$606,091,271 a year ($259,193,378 at home, $346,701,927 away) · $61,389 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-20 22:08updateinspections inspections|nyc|50063550 ↔ ny-sla 0423-23-136135same address and namemerged17
2026-11-20 22:08updateny-sla 0423-23-136135 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and namemerged17
2026-11-20 22:08updateinspections inspections|nyc|50063550 ↔ ny-sla 0423-23-137252same address and namemerged17
2026-11-20 22:08updateny-sla 0423-23-137252 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and namemerged17
2026-11-19 20:37updateny-sla 0423-23-136135 ↔ vtinfo 99c52d8283d401ddClaude judge: samemerged17
2026-11-19 20:37insertinspections inspections|nyc|50063550 ↔ ny-sla 0423-23-136135same address and nameheld: same-source-conflict17
2026-11-19 20:37insertinspections inspections|nyc|50063550 ↔ ny-sla 0423-23-137252same address and nameheld: same-source-conflict17
2026-11-19 20:37insertinspections inspections|nyc|50063550 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|50063550 ↔ ny-sla 0370-23-136485same address and namemerged17
2026-11-18 18:58insertny-sla 0423-23-136135 ↔ vtinfo 99c52d8283d401ddClaude judge: sameheld: same-source-conflict15
2026-11-16 14:56insertny-sla 0370-23-136485 ↔ vtinfo 99c52d8283d401ddone name contains the other, same addressmerged15
2026-11-13 14:10insertoverture d0b092a2-46d2-4087-adfd-dc3047102726 ↔ vtinfo 99c52d8283d401ddsame address and namemerged15
2026-11-06 18:13insertny-sla 0423-23-136135 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0423-23-137252 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0370-23-136485 ↔ overture 2720c876-30c3-49a8-8439-2ad3b322fdf2same address and namemerged11
2026-11-03 13:33backfillny-sla 0423-23-136135 ↔ ny-sla 0423-23-137252one store listed twicemerged