Mi Pueblo Marin

San Rafael, CA 94903 · O3b2d1e0e5070 · first seen 2026-10-08
6 sourceson premise · restaurantchain: Mi Puebloalcohol: 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
Mi Pueblo Marin 4 other
a licence name in capitals, cleaned (derived; record_title.py)
Mi Pueblo ubereats
mi pueblo marin san rafael doordash
Mi Pueblo San Rafael overture
P&J FOOD INC ca-abc (legal name)
Street
5800 NORTHGATE MALL 138 3 other
ca-abc
5800 Northgate Dr Ste 138 overtureubereatsvtinfo ×3
5800 NORTHGATE DR 138 inspections
5800 Northgate Drive doordash
City
SAN RAFAEL
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94903
ca-abcno other value
Pin
38.00435, -122.54481 map 3 other
ubereats
256 m away ca-abc
256 m away inspections
210 m away vtinfo
Phone
4154793200 1 other
vtinfo
4152957373 overture
Licences
ca-abc 00590520|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofe3e4e848382; O865b16344b14; Oc92e04bb51ae; O4637bee24d54; Oabc0b1e459d5

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-abcMI PUEBLO MARIN
legal name: P&J FOOD INC
00590520|47|LIC|0
5800 NORTHGATE MALL 138, SAN RAFAEL, CA, 9490338.00276, -122.546932026-10-082026-11-05
doordashmi pueblo marin san rafael
477378
5800 Northgate Drive, San Rafael, CA, 9490338.00432, -122.544792026-10-082026-11-02
inspectionsMI PUEBLO MARIN
inspections|marin|9579
5800 NORTHGATE DR 138, San Rafael, CA, 9490338.00276, -122.546932026-11-192026-11-20
overtureMi Pueblo San Rafael
3c3d1e70-075f-4a04-a140-ab46f5f7a5c3
5800 Northgate Dr Ste 138, San Rafael, CA, 94903415295737338.00429, -122.544872026-11-062026-11-06
ubereatsMi Pueblo
vf7naCvcS32hw39c00Jtgw
5800 Northgate Dr Ste 138, San Rafael, CA, 9490338.00435, -122.544812026-10-222026-11-02
vtinfoMI PUEBLO MARIN
bf96b948fc33a031
5800 NORTHGATE DR STE 138, SAN RAFAEL, CA, 94903415479320038.00321, -122.546722026-11-132026-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
ca-abc MI PUEBLO MARINdoordash mi pueblo marin san rafael1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The DoorDash slug 'mi pueblo marin' plus its appended city matches the distinctive name 'MI PUEBLO MARIN' at the same 5800 Northgate address in San Rafael, so the names agree even though the mall buil
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records carry the same business name, Mi Pueblo Marin, on the same street number and ZIP in San Rafael, and the ca-abc record's legal entity P&J Food Inc fits a restaurant that also sells through DoorDash. The mall holds 6 businesses and only one record gives suite 138, but the matching names settle it.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The names match (MI PUEBLO MARIN vs. the DoorDash slug 'mi pueblo marin san rafael'), the ZIP and coordinates (about 0.26 km apart) agree, and the ABC licence is an on-sale restaurant, consistent with the same operation. The mall holds three businesses and only the ABC record names suite 138, so the address alone is not decisive, but the name match carries the verdict.
pair bc6759bcca9a497948f1
ca-abc MI PUEBLO MARINinspections MI PUEBLO MARIN1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.82
doordash mi pueblo marin san rafaelinspections MI PUEBLO MARIN1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.86
doordash mi pueblo marin san rafaelvtinfo MI PUEBLO MARIN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 209 m apart · name similarity 1.00
inspections MI PUEBLO MARINvtinfo MI PUEBLO MARIN1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.86
doordash mi pueblo marin san rafaeloverture Mi Pueblo San Rafael0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.80 · same street + ZIP · pins 8 m apart · name similarity 0.83
ca-abc MI PUEBLO MARINubereats Mi Pueblo0.71Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records name Mi Pueblo at suite 138 of 5800 Northgate in San Rafael 94903. A's 'Northgate Mall 138' matches B's 'Ste 138', and A's restaurant licence fits the Uber Eats restaurant listing.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 82% confident — Mi Pueblo, same mall address, suite 138
  • Claude Haiku 5.5, prompt v9: same, 60% confident — Both records carry the Mi Pueblo name at the same street address and ZIP, and the CA licence is a restaurant licence under a Mi Pueblo Marin DBA, so the Uber Eats listing is plausibly that operation's own delivery listing; the shared building (3 businesses) and the unconfirmed suite keep this from being certain.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records place the business at 5800 Northgate, suite 138, in San Rafael 94903 at about 0.26 km apart, and the names match (MI PUEBLO MARIN vs Mi Pueblo), with the ABC licence showing a restaurant on that premises, consistent with the Uber Eats listing; the shared mall building and the one-sided unit leave some doubt.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records name Mi Pueblo at 5800 Northgate with suite 138 in San Rafael 94903, and the California licence is for a restaurant with a full bar, which fits an Uber Eats restaurant listing; the shared building with another business is outweighed by the matching name and suite.
pair 486ac8bdd1589162c36d
doordash mi pueblo marin san rafaelubereats Mi Pueblo0.71Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
Both records name Mi Pueblo at 5800 Northgate Drive, San Rafael, 4 m apart; the shared mall building is offset by the names agreeing, with only the suite missing on one side.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Mi Pueblo same address, names agree
  • Claude Haiku 5.5, prompt v9: same, 82% confident — Both records are Mi Pueblo at 5800 Northgate Drive in San Rafael with coordinates about 4 m apart, and the DoorDash slug 'mi pueblo marin san rafael' matches the Uber Eats name; the shared building (3 businesses) and the suite listed only on one side leave some doubt, but the names agree at the same street address.
  • Claude Haiku 5.5, prompt v7: same, 82% confident — Both records give 5800 Northgate Drive, San Rafael 94903, with coordinates about 4 m apart, and both name Mi Pueblo, the same chain, so the names agree despite the shared building; the suite appears only on record B, which leaves a little doubt.
  • Claude Haiku 5.5, prompt v4: same, 86% confident — Both records give the same street address in San Rafael within about 4 metres, and the names agree (Mi Pueblo, with the city appended in the DoorDash slug); record B's suite 138 is only one-sided evidence, and the shared building is resolved by the matching name.
pair 3fdef6a19d54aa598ba6

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
Mi Pueblo — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
P&J FOOD INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
72 within 1 mi · 411 within 3 mi
Off / on premise
25 / 36 within 1 mi · 115 / 236 within 3 mi
Selling alcohol
50 within 1 mi · 315 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
suburban (2,295 people per sq mi)
People within 3 mi
64,902 (50,809 adults 21+, 26,940 households) from 15 tract(s), tracts within 3 mi
Income
per capita $89,606 · median household ~$143,574 (weighted mean of tract medians)
Age and education
median age ~47.7 · bachelor's or higher 61%
Ethnicity
Hispanic 18% · White 69% · Black 3% · Asian 5%
Adults per alcohol outlet
161
Alcohol spend within 3 mi
$25,922,713 a year ($11,097,941 at home, $14,817,002 away) · $82,034 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:37insertdoordash 477378 ↔ inspections inspections|marin|9579street written two waysmerged17
2026-11-19 20:37insertca-abc 00590520|47|LIC|0 ↔ inspections inspections|marin|9579street written two waysmerged17
2026-11-19 20:37insertinspections inspections|marin|9579 ↔ vtinfo bf96b948fc33a031street written two waysmerged17
2026-11-13 14:10insertdoordash 477378 ↔ vtinfo bf96b948fc33a031same address and namemerged15
2026-11-06 18:13insertdoordash 477378 ↔ overture 3c3d1e70-075f-4a04-a140-ab46f5f7a5c3same address and namemerged11
2026-11-02 23:02backfillca-abc 00590520|47|LIC|0 ↔ ubereats vf7naCvcS32hw39c00JtgwClaude judge: samemerged
2026-11-02 23:02backfilldoordash 477378 ↔ ubereats vf7naCvcS32hw39c00JtgwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00590520|47|LIC|0 ↔ doordash 477378Claude judge: samemerged