Mi Rancho Mexican Restaurant

Pennsburg, PA 18073 · O592973e55196 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: alcohol

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
Mi Rancho Mexican Restaurant 1 other
the most common name a source states
mi rancho pennsburg doordash
Street
1275 Quakertown Avenue 1 other
ubereats
1275 Quakertown Ave overture
City
Pennsburg
ubereatsno other value
State
PA
ubereatsno other value
ZIP
18073
ubereatsno other value
Pin
40.40241, -75.49389 map
ubereatsno other value
Phone
2673847674
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6a2659fa6da7; Odaaebd50edb3

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
doordashmi rancho pennsburg
25064557
1275 Quakertown Avenue, Pennsburg, PA, 1807340.40241, -75.493902026-10-082026-10-26
overtureMi Rancho Mexican Restaurant
5f2ec787-ab0c-4463-86e6-e50ba1255205
1275 Quakertown Ave, Pennsburg, PA, 18073267384767440.40231, -75.493942026-11-062026-11-06
ubereatsMi Rancho Mexican Restaurant
Vo3tCCZ-UcOE6bwbKEwhxA
1275 Quakertown Avenue, Pennsburg, PA, 1807340.40241, -75.493892026-10-122026-11-02

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
overture Mi Rancho Mexican Restaurantubereats Mi Rancho Mexican Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
doordash mi rancho pennsburgoverture Mi Rancho Mexican Restaurant0.49same 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 11 m apart · name similarity 0.49
doordash mi rancho pennsburgubereats Mi Rancho Mexican Restaurant0.49Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (94% confident; asked as a “near” pair)
Both records share the name 'Mi Rancho' and the address 1275 Quakertown Avenue, Pennsburg, and only one business is known at that address; the DoorDash slug simply has the city appended.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records sit at the identical street address, ZIP and city in Pennsburg with coordinates under 1 metre apart, and the only address in our data there is this one business, so the DoorDash slug 'mi rancho pennsburg' and the Uber Eats name 'Mi Rancho Mexican Restaurant' describe the same restaurant.
pair bfc29cebaf59b4444fad

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
alcohol — Uber Eats menu sells alcohol: 'Cocktails', 'Cocktails'
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
23 within 1 mi · 39 within 3 mi
Off / on premise
7 / 13 within 1 mi · 12 / 22 within 3 mi
Selling alcohol
10 within 1 mi · 16 within 3 mi
Nearest
same channel 0.31 mi · licensed 0.64 mi
Setting
suburban (647 people per sq mi)
People within 3 mi
18,285 (13,516 adults 21+, 7,089 households) from 4 tract(s), tracts within 3 mi
Income
per capita $46,177 · median household ~$100,180 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 32%
Ethnicity
Hispanic 5% · White 90% · Black 2% · Asian 2%
Adults per alcohol outlet
795
Alcohol spend within 3 mi
$5,373,787 a year ($2,425,392 at home, $2,945,456 away) · $316,105 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-12 17:29insertdoordash 25064557 ↔ overture 5f2ec787-ab0c-4463-86e6-e50ba1255205same address and namemerged14
2026-11-06 18:13insertoverture 5f2ec787-ab0c-4463-86e6-e50ba1255205 ↔ ubereats Vo3tCCZ-UcOE6bwbKEwhxAsame address and namemerged11
2026-11-02 23:02backfilldoordash 25064557 ↔ ubereats Vo3tCCZ-UcOE6bwbKEwhxAClaude judge: samemerged