Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94903 | ca-abc | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | MI PUEBLO MARIN legal name: P&J FOOD INC 00590520|47|LIC|0 | 5800 NORTHGATE MALL 138, SAN RAFAEL, CA, 94903 | 38.00276, -122.54693 | 2026-10-08 | 2026-11-05 | |
| doordash | mi pueblo marin san rafael 477378 | 5800 Northgate Drive, San Rafael, CA, 94903 | 38.00432, -122.54479 | 2026-10-08 | 2026-11-02 | |
| inspections | MI PUEBLO MARIN inspections|marin|9579 | 5800 NORTHGATE DR 138, San Rafael, CA, 94903 | 38.00276, -122.54693 | 2026-11-19 | 2026-11-20 | |
| overture | Mi Pueblo San Rafael 3c3d1e70-075f-4a04-a140-ab46f5f7a5c3 | 5800 Northgate Dr Ste 138, San Rafael, CA, 94903 | 4152957373 | 38.00429, -122.54487 | 2026-11-06 | 2026-11-06 |
| ubereats | Mi Pueblo vf7naCvcS32hw39c00Jtgw | 5800 Northgate Dr Ste 138, San Rafael, CA, 94903 | 38.00435, -122.54481 | 2026-10-22 | 2026-11-02 | |
| vtinfo | MI PUEBLO MARIN bf96b948fc33a031 | 5800 NORTHGATE DR STE 138, SAN RAFAEL, CA, 94903 | 4154793200 | 38.00321, -122.54672 | 2026-11-13 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc MI PUEBLO MARIN | doordash mi pueblo marin san rafael | 1.00 | Claude judge: same | merged | 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:
pair bc6759bcca9a497948f1 |
| ca-abc MI PUEBLO MARIN | inspections MI PUEBLO MARIN | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.82 |
| doordash mi pueblo marin san rafael | inspections MI PUEBLO MARIN | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.86 |
| doordash mi pueblo marin san rafael | vtinfo MI PUEBLO MARIN | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 209 m apart · name similarity 1.00 |
| inspections MI PUEBLO MARIN | vtinfo MI PUEBLO MARIN | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.86 |
| doordash mi pueblo marin san rafael | overture Mi Pueblo San Rafael | 0.83 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.80 · same street + ZIP · pins 8 m apart · name similarity 0.83 |
| ca-abc MI PUEBLO MARIN | ubereats Mi Pueblo | 0.71 | Claude judge: same | merged | 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:
pair 486ac8bdd1589162c36d |
| doordash mi pueblo marin san rafael | ubereats Mi Pueblo | 0.71 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | doordash 477378 ↔ inspections inspections|marin|9579 | street written two ways | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00590520|47|LIC|0 ↔ inspections inspections|marin|9579 | street written two ways | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|marin|9579 ↔ vtinfo bf96b948fc33a031 | street written two ways | merged | 17 |
| 2026-11-13 14:10 | insert | doordash 477378 ↔ vtinfo bf96b948fc33a031 | same address and name | merged | 15 |
| 2026-11-06 18:13 | insert | doordash 477378 ↔ overture 3c3d1e70-075f-4a04-a140-ab46f5f7a5c3 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00590520|47|LIC|0 ↔ ubereats vf7naCvcS32hw39c00Jtgw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 477378 ↔ ubereats vf7naCvcS32hw39c00Jtgw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00590520|47|LIC|0 ↔ doordash 477378 | Claude judge: same | merged |