Miramar Cash & Carry

San Diego, CA 92126 · O337731877963 · first seen 2026-10-08
4 sourcesoff premisealcohol: 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
Miramar Cash & Carry 1 other
the most common name a source states
SD PIONEER FOOD INC. ca-abc (legal name)
Street
9262 MIRAMAR RD
ca-abcno other value
City
SAN DIEGO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92126
ca-abcno other value
Pin
32.89496, -117.12862 map 3 other
overture
164 m away ca-abc
164 m away inspections
166 m away snap
Phone
8585664819
overtureno other value
Licences
ca-abc 00537525|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O777da6011b95; O44599a0e555b; O9ff71133a8b8

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-abcMIRAMAR CASH & CARRY
legal name: SD PIONEER FOOD INC.
00537525|21|LIC|0
9262 MIRAMAR RD, SAN DIEGO, CA, 9212632.89380, -117.127542026-10-082026-11-19
inspectionsMIRAMAR CASH & CARRY
inspections|sdcounty|DEH2014-FFPP-003285
9262 MIRAMAR RD, San Diego, CA, 9212632.89380, -117.127542026-11-202026-11-22
overtureMiramar Cash & Carry
e3a526f8-7b4c-45c5-b0f0-0842e3e81a2e
9262 Miramar Rd, San Diego, CA, 92126858566481932.89496, -117.128622026-11-062026-11-19
snapMiramar Cash & Carry
snap|us|1026046
9262 Miramar Rd, San Diego, CA, 9212632.89374, -117.127602026-11-192026-11-19

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 MIRAMAR CASH & CARRYinspections MIRAMAR CASH & CARRY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MIRAMAR CASH & CARRYoverture Miramar Cash & Carry1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 164 m apart · name similarity 1.00
ca-abc MIRAMAR CASH & CARRYsnap Miramar Cash & Carry1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections MIRAMAR CASH & CARRYoverture Miramar Cash & Carry1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections MIRAMAR CASH & CARRYsnap Miramar Cash & Carry1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Miramar Cash & Carrysnap Miramar Cash & Carry1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 166 m apart · name similarity 1.00

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SD PIONEER FOOD INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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-20 22:08insertinspections inspections|sdcounty|DEH2014-FFPP-003285 ↔ snap snap|us|1026046same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2014-FFPP-003285 ↔ overture e3a526f8-7b4c-45c5-b0f0-0842e3e81a2esame address and namemerged17
2026-11-20 22:08insertca-abc 00537525|21|LIC|0 ↔ inspections inspections|sdcounty|DEH2014-FFPP-003285same address and namemerged17
2026-11-19 20:37insertoverture e3a526f8-7b4c-45c5-b0f0-0842e3e81a2e ↔ snap snap|us|1026046same address and namemerged17
2026-11-19 20:37insertca-abc 00537525|21|LIC|0 ↔ snap snap|us|1026046same address and namemerged17
2026-11-06 18:13insertca-abc 00537525|21|LIC|0 ↔ overture e3a526f8-7b4c-45c5-b0f0-0842e3e81a2esame address and namemerged11