Pancho's Mexican Restaurant

Brunswick, NY 12180 · O7ab94efdfcef · first seen 2026-11-02
3 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
Pancho's Mexican Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
PANCHO AND FRIENDS INC. inspections (legal name)
Pancho's overture
PANCHOS & FRIENDS INC ny-sla (legal name)
PANCHOS MEXICAN RESTAURANT ny-sla
Street
740 HOOSICK RD 2 other
ny-sla
740 Hoosick Rd Ste 6 overture
740 HOOSICK ROAD inspections
City
TROY 1 other
ny-sla
Brunswick overture
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.74480, -73.64112 map 2 other
overture
137 m away inspections
71 m away ny-sla
Phone
5182733673
overtureno other value
Licences
ny-sla 0340-21-219141
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe90a0acda090; Od8d4c19df477

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
inspectionsPANCHO'S MEXICAN RESTAURANT
legal name: PANCHO AND FRIENDS INC.
inspections|nys|533977
740 HOOSICK ROAD, Troy, NY, 1218042.74498, -73.642792026-11-192026-11-19
ny-slaPANCHOS MEXICAN RESTAURANT
legal name: PANCHOS & FRIENDS INC
0340-21-219141
740 HOOSICK RD, TROY, NY, 1218042.74461, -73.641962026-11-022026-11-13
overturePancho's
975ede46-ad37-43e7-ba47-5d3a42b9ab79
740 Hoosick Rd Ste 6, Brunswick, NY, 12180
ZIP lookup: Troy, NY
518273367342.74480, -73.641122026-11-132026-11-13

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 PANCHO'S MEXICAN RESTAURANTny-sla PANCHOS MEXICAN RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 79 m apart · name similarity 1.00
ny-sla PANCHOS MEXICAN RESTAURANToverture Pancho's0.57same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.71 · same street + ZIP · pins 71 m apart · matched through the licence's legal name: PANCHOS & FRIENDS INC · name similarity 0.57
inspections PANCHO'S MEXICAN RESTAURANToverture Pancho's0.38same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.71 · same street + ZIP · pins 137 m apart · name similarity 0.38

Attributes

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

Trade area

Other outlets
42 within 1 mi · 302 within 3 mi
Off / on premise
15 / 16 within 1 mi · 61 / 142 within 3 mi
Selling alcohol
23 within 1 mi · 194 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.12 mi
Setting
suburban (1,806 people per sq mi)
People within 3 mi
51,061 (37,738 adults 21+, 22,233 households) from 15 tract(s), tracts within 3 mi
Income
per capita $40,231 · median household ~$69,379 (weighted mean of tract medians)
Age and education
median age ~35.0 · bachelor's or higher 40%
Ethnicity
Hispanic 8% · White 70% · Black 11% · Asian 5%
Adults per alcohol outlet
194
Alcohol spend within 3 mi
$13,500,447 a year ($6,286,852 at home, $7,207,213 away) · $69,233 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|nys|533977 ↔ overture 975ede46-ad37-43e7-ba47-5d3a42b9ab79same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|533977 ↔ ny-sla 0340-21-219141same address and namemerged17
2026-11-13 14:10insertny-sla 0340-21-219141 ↔ overture 975ede46-ad37-43e7-ba47-5d3a42b9ab79same address and namemerged15