Chihuahua

SUNNYSIDE, NY 11104 · O06bcb9caca4f · first seen 2026-10-08
4 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
Chihuahua 3 other
a licence name in capitals, cleaned (derived; record_title.py)
CHIHUAHUA INC ny-sla
Chihuahua Restaurante overture
chihuahua sunnyside doordash
Street
47-02 GREENPOINT AVE 2 other
ny-sla
47 02 GREENPOINT AVE vtinfo
47-02 Greenpoint Avenue doordash
City
SUNNYSIDE 1 other
ny-sla
New York overture
State
NY
ny-slano other value
ZIP
11104
ny-slano other value
Pin
40.74244, -73.91777 map 1 other
doordash
906 m away vtinfo
Phone
7187572336 1 other
vtinfo
3475310954 overture
Licences
ny-sla 0340-21-121171
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc670ac36ba89; O7bc6364319ad; O2ed9e5fecd21; O94005ed574b9

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
doordashchihuahua sunnyside
133677
47-02 Greenpoint Avenue, Sunnyside, NY, 1110440.74244, -73.917772026-10-082026-11-13
ny-slaCHIHUAHUA INC
0340-21-121171
47-02 GREENPOINT AVE, SUNNYSIDE, NY, 1110440.74251, -73.917872026-11-022026-11-12
overtureChihuahua Restaurante
4919b512-0a4b-4f0a-a729-9ffbd7d9a310
47-02 Greenpoint Ave, New York, NY, 11104347531095440.74246, -73.917792026-11-132026-11-13
vtinfoCHIHUAHUA
bd7dcf9c774e340a
47 02 GREENPOINT AVE, SUNNYSIDE, NY, 11104718757233640.73859, -73.927242026-11-112026-11-14

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
doordash chihuahua sunnysideny-sla CHIHUAHUA INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
doordash chihuahua sunnysideoverture 24305840-b033-427a-af50-6581c1ca568d1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
ny-sla CHIHUAHUA INCoverture 24305840-b033-427a-af50-6581c1ca568d1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ny-sla CHIHUAHUA INCvtinfo CHIHUAHUA1.00Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “near” pair)
The names match, since 'CHIHUAHUA INC' is the legal entity form of 'CHIHUAHUA', and both records give the same street address (47-02 Greenpoint Ave, Sunnyside); only one business is known at that addr
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records give the same street address (47-02 Greenpoint Ave, Sunnyside, NY 11104) with essentially the same name (CHIHUAHUA INC vs CHIHUAHUA), and only one business is held at that address, so they are one outlet despite the 0.9 km coordinate gap.
pair 0373b21f1d99ff880916
ny-sla CHIHUAHUA INCoverture Chihuahua Restaurante0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurante · name Jaro-Winkler 0.89 · same street + ZIP · pins 9 m apart · name similarity 0.55

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CHIHUAHUA INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
726 within 1 mi · 8,127 within 3 mi
Off / on premise
95 / 341 within 1 mi · 1,025 / 4,231 within 3 mi
Selling alcohol
413 within 1 mi · 4,902 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (37,140 people per sq mi)
People within 3 mi
1,050,119 (853,305 adults 21+, 454,333 households) from 304 tract(s), tracts within 3 mi
Income
per capita $66,355 · median household ~$109,948 (weighted mean of tract medians)
Age and education
median age ~38.8 · bachelor's or higher 51%
Ethnicity
Hispanic 32% · White 43% · Black 5% · Asian 20%
Adults per alcohol outlet
174
Alcohol spend within 3 mi
$365,881,864 a year ($161,390,491 at home, $204,352,740 away) · $74,624 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-13 14:10insertny-sla 0340-21-121171 ↔ overture 4919b512-0a4b-4f0a-a729-9ffbd7d9a310same address and namemerged15
2026-11-12 14:25insertny-sla 0340-21-121171 ↔ vtinfo bd7dcf9c774e340aClaude judge: samemerged12
2026-11-12 14:25insertdoordash 133677 ↔ overture 24305840-b033-427a-af50-6581c1ca568dsame address and namemerged12
2026-11-12 14:25insertdoordash 133677 ↔ ny-sla 0340-21-121171same address and namemerged12
2026-11-06 18:13insertny-sla 0340-21-121171 ↔ overture 24305840-b033-427a-af50-6581c1ca568dsame address and namemerged11