The Little Chihuahua Mexican Restaurant

San Francisco, CA 94117 · O3384f711d39e · first seen 2026-10-08
4 sourceson premise · restaurantchain: The Little Chihuahua Mexican 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
The Little Chihuahua Mexican Restaurant 5 other
a licence name in capitals, cleaned (derived; record_title.py)
LITTLE CHIHUAHUA MEXICAN RESTAURANT THE ca-abc
OTT- (delete) The Little Chihuahua - Lower Haight ubereats
The Little Chihuahua overture
the little chihuahua san francisco doordash
TLC FOODS LLC ca-abc (legal name)
Street
292 DIVISADERO ST 1 other
ca-abc
292 Divisadero Street doordashubereats ×2
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94117
ca-abcno other value
Pin
37.77204, -122.43688 map
ubereatsno other value
Phone
4152558225
overtureno other value
Licences
ca-abc 00480072|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of3c524f702ca; Odcf97f68c731; O4f89706b875e

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
ca-abcLITTLE CHIHUAHUA MEXICAN RESTAURANT THE
legal name: TLC FOODS LLC
00480072|41|LIC|0
292 DIVISADERO ST, SAN FRANCISCO, CA, 9411737.77206, -122.437092026-10-082026-11-05
doordashthe little chihuahua san francisco
4498
292 Divisadero Street, San Francisco, CA, 9411737.77208, -122.437082026-10-082026-11-11
overtureThe Little Chihuahua
59e9ecd8-58a6-48dd-b6e8-16f792916f66
292 Divisadero St, San Francisco, CA, 94117415255822537.77203, -122.437102026-11-092026-11-11
ubereatsOTT- (delete) The Little Chihuahua - Lower Haight
VzxdZH_aT2-N29rmg_mKhg
292 Divisadero Street, San Francisco, CA, 9411737.77204, -122.436882026-10-252026-10-25

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 the little chihuahua san franciscooverture The Little Chihuahua1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ca-abc LITTLE CHIHUAHUA MEXICAN RESTAURANT THEdoordash the little chihuahua san francisco0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name The Little Chihuahua at the same street address, 292 Divisadero St, San Francisco 94117; the DoorDash slug only adds the city, and the ABC restaurant licence fits a Mexican restauran
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — The DoorDash listing 'the little chihuahua san francisco' matches the CA ABC restaurant licence 'LITTLE CHIHUAHUA MEXICAN RESTAURANT THE' at the same street address, ZIP, and coordinates (about 2 m apart), and the restaurant name agrees even though the building holds another business.
pair 7791d8660bac67d54ebd
ca-abc LITTLE CHIHUAHUA MEXICAN RESTAURANT THEoverture The Little Chihuahua0.56same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 3 m apart · name similarity 0.56
doordash the little chihuahua san franciscoubereats OTT- (delete) The Little Chihuahua - Lower Haight0.45Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records name The Little Chihuahua at the identical street address 292 Divisadero St, 94117; the DoorDash slug simply appends the city, and the Uber Eats 'OTT- (delete)' prefix is only a listing a
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records name The Little Chihuahua at 292 Divisadero Street, San Francisco, 94117, with coordinates about 18 m apart, and the names agree despite the shared building (businesses_at_address is 2) and the 'OTT- (delete)' noise in the Uber Eats name.
pair fdc14b9743fa5a61b5c4
ca-abc LITTLE CHIHUAHUA MEXICAN RESTAURANT THEubereats OTT- (delete) The Little Chihuahua - Lower Haight0.41Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “same-address” pair)
Both records name The Little Chihuahua restaurant at 292 Divisadero St, San Francisco 94117, and the names agree despite the Uber Eats listing's 'delete' prefix and the shared-address count.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Little Chihuahua name matches at same address.
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records are at 292 Divisadero St, 94117, and the Uber Eats listing 'The Little Chihuahua - Lower Haight' matches the California restaurant licence for 'Little Chihuahua Mexican Restaurant' (legal TLC Foods LLC), so it is one restaurant's own delivery listing; the other business at the address does not change that name match.
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records are The Little Chihuahua restaurant at 292 Divisadero St, San Francisco 94117, with the Uber Eats listing 18 m from the ABC licensed premises and no conflicting suite numbers. The building holds another business, but the names agree, so the Uber Eats listing is the same restaurant.
  • Claude Haiku 5.5, prompt v4: same, 87% confident — Both records are the Little Chihuahua restaurant at 292 Divisadero St, San Francisco 94117, and the names agree; the ABC record is an eating-place (restaurant) licence, which fits the Uber Eats restaurant listing, though the address is shared with one other business.
pair 2aa732ad1e5cc1cc3b0a

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
The Little Chihuahua Mexican Restaurant — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
TLC FOODS LLC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
934 within 1 mi · 6,501 within 3 mi
Off / on premise
159 / 590 within 1 mi · 884 / 4,112 within 3 mi
Selling alcohol
652 within 1 mi · 4,029 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (20,277 people per sq mi)
People within 3 mi
573,315 (495,035 adults 21+, 277,800 households) from 174 tract(s), tracts within 3 mi
Income
per capita $106,337 · median household ~$155,538 (weighted mean of tract medians)
Age and education
median age ~40.3 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 46% · Black 4% · Asian 29%
Adults per alcohol outlet
123
Alcohol spend within 3 mi
$269,620,512 a year ($114,342,546 at home, $155,196,949 away) · $66,903 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:29insertca-abc 00480072|41|LIC|0 ↔ overture 59e9ecd8-58a6-48dd-b6e8-16f792916f66same address and namemerged14
2026-11-11 12:56insertdoordash 4498 ↔ ubereats VzxdZH_aT2-N29rmg_mKhgClaude judge: samemerged12
2026-11-11 12:56insertca-abc 00480072|41|LIC|0 ↔ doordash 4498Claude judge: samemerged12
2026-11-09 15:32insertdoordash 4498 ↔ overture 59e9ecd8-58a6-48dd-b6e8-16f792916f66same address and namemerged11
2026-11-02 23:02backfillca-abc 00480072|41|LIC|0 ↔ ubereats VzxdZH_aT2-N29rmg_mKhgClaude judge: samemerged