Mesa Market

Oceanside, CA 92058 · O2ca7c02efe60 · first seen 2026-10-08
9 sourcesoff premise · liquor_storealcohol: licensed1 licence6 products on the shelf

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
Mesa Market 3 other
a source's own spelling of the licence name (record_title.py)
Mesa Market Liquor ubereats
mesa market liquor oceanside doordash
SERRA MESA CORP ca-abc (legal name)
Street
2255 MISSION AVE 1 other
ca-abc
2255 Mission Avenue doordash
City
OCEANSIDE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92058 1 other
ca-abc
92054 inspections
Pin
33.20816, -117.35931 map 3 other
ubereats
51 m away ca-abc
51 m away ca-tobacco
51 m away inspections
Phone
7607217494
vtinfono other value
Licences
ca-abc 00612563|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oefdeb4071e7d; O7523b458c94c; O854c0a932313; O80c1dfea7146; O6de29c47ac9a; O5d418fd493f8; O42f12e9cd76c; O552b4dc32dd3

Carries

Products seen on this outlet’s shelf in store-level catalogs.

6products listed now
6products ever
7listings
1listings with no product match yet
doordashfrom
ProductSourcePriceStockSeen
Bic Lighter Fashion Colors
doordash$3.62—2026-11-01
Drinkade Boost
doordash$7.25—2026-11-01
New Belgium Voodoo Ranger Juice Force Hazy Imperial IPA (12 fl oz)
New Belgium Brewing Company · 12 fl oz × 6
doordash$16.93—2026-11-01
Neon Disposable Lighter Red
doordash$2.41—2026-11-01
VMC Tamarindo Tequila Cocktail Cans (12 fl oz x 4 ct)
VMC · 12 fl oz × 4
doordash$15.72—2026-11-01
Rose (15 g)
doordash$6.04—2026-11-01
Fresh Cut Flowers
not matched to a product yet
doordash$18.14—2026-11-01

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevMESA MARKET
3782247
2255 MISSION AVE, OCEANSIDE, CA, 9205833.20829, -117.359812026-11-112026-11-19
ca-abcMESA MARKET
legal name: SERRA MESA CORP
00612563|21|LIC|0
2255 MISSION AVE, OCEANSIDE, CA, 9205833.20827, -117.359832026-10-082026-11-19
ca-tobaccoMESA MARKET
ca-tobacco|229712896
2255 MISSION AVE, Oceanside, CA, 9205833.20827, -117.359832026-11-202026-11-22
doordashmesa market liquor oceanside
24770753
2255 Mission Avenue, Oceanside, CA, 9205833.20812, -117.359372026-10-082026-11-19
inspectionsMESA MARKET
inspections|sdcounty|DEH2023-FFPN-002447
2255 MISSION AVE, Oceanside, CA, 9205433.20827, -117.359832026-11-202026-11-22
overtureMesa Market
8c597445-9424-4477-a0fe-1d62d055de85
2255 Mission Ave, Oceanside, CA, 92058760721749433.20821, -117.359342026-11-062026-11-19
snapMesa Market
snap|us|1208440
2255 Mission Ave, Oceanside, CA, 9205833.20848, -117.359402026-11-192026-11-19
ubereatsMesa Market Liquor
I5aNeDOcW4OdQP78GYhM2Q
2255 Mission Ave., Oceanside, CA, 9205833.20816, -117.359312026-11-202026-11-20
vtinfoMESA MARKET
129d1fc766b31fdb
2255 MISSION AVE, OCEANSIDE, CA, 92058760721749433.20821, -117.359262026-11-122026-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
ab-inbev MESA MARKETca-abc MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ab-inbev MESA MARKETca-tobacco MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev MESA MARKETinspections MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ab-inbev MESA MARKEToverture Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
ab-inbev MESA MARKETsnap Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev MESA MARKETvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ca-abc MESA MARKETca-tobacco MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MESA MARKETinspections MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ca-abc MESA MARKEToverture Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00
ca-abc MESA MARKETsnap Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00
ca-abc MESA MARKETvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 54 m apart · name similarity 1.00
ca-tobacco MESA MARKETinspections MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ca-tobacco MESA MARKEToverture Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco MESA MARKETsnap Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco MESA MARKETvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash mesa market liquor oceansideubereats Mesa Market Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
inspections MESA MARKEToverture Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
inspections MESA MARKETsnap Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
inspections MESA MARKETvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
overture Mesa Marketsnap Mesa Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
overture Mesa Marketvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00 · phone: equal
snap Mesa Marketvtinfo MESA MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ca-abc MESA MARKETdoordash mesa market liquor oceanside0.71Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Same address (2255 Mission Ave, Oceanside 92058), matching name 'Mesa Market' with liquor, single business at address, and an off-sale licence consistent with a market/liquor store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records sit at 2255 Mission Avenue, Oceanside 92058, the only business at that address, and the names align: the California licence is 'MESA MARKET' (legal entity Serra Mesa Corp) with an off-sale liquor licence, matching the DoorDash listing 'mesa market liquor oceanside'.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 2255 Mission Ave, Oceanside 92058, with a matching off-sale liquor licence for Mesa Market and a DoorDash listing named Mesa Market Liquor Oceanside; only one business is at that address and the coordinates agree within about 46 m.
  • Claude Haiku 5.5, prompt v6: same, 90% confident — Both records give the same street address (2255 Mission Ave, Oceanside, ZIP 92058), the name 'Mesa Market' matches the DoorDash slug 'mesa market liquor oceanside', the CA licence is an active off-sale liquor/market licence, and only one business is recorded at that address.
  • Claude Haiku 5.5, prompt v5: same, 90% confident — Both records give the same street address, city and ZIP in Oceanside, CA, and the DoorDash slug 'mesa market liquor oceanside' matches the ABC record's 'MESA MARKET' off-sale liquor store, with only one business at that address in our data.
pair f92cf753a61750bfaa43

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SERRA MESA CORP — 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)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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|DEH2023-FFPN-002447 ↔ snap snap|us|1208440same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|229712896 ↔ inspections inspections|sdcounty|DEH2023-FFPN-002447same address and namemerged17
2026-11-20 22:08insertab-inbev 3782247 ↔ inspections inspections|sdcounty|DEH2023-FFPN-002447same address and namemerged17
2026-11-20 22:08insertca-abc 00612563|21|LIC|0 ↔ inspections inspections|sdcounty|DEH2023-FFPN-002447same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2023-FFPN-002447 ↔ overture 8c597445-9424-4477-a0fe-1d62d055de85same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2023-FFPN-002447 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|229712896 ↔ snap snap|us|1208440same address and namemerged17
2026-11-20 22:08insertab-inbev 3782247 ↔ ca-tobacco ca-tobacco|229712896same address and namemerged17
2026-11-20 22:08insertca-abc 00612563|21|LIC|0 ↔ ca-tobacco ca-tobacco|229712896same address and namemerged17
2026-11-20 22:08insertdoordash 24770753 ↔ ubereats I5aNeDOcW4OdQP78GYhM2Qsame address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|229712896 ↔ overture 8c597445-9424-4477-a0fe-1d62d055de85same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|229712896 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged17
2026-11-19 20:37insertab-inbev 3782247 ↔ snap snap|us|1208440same address and namemerged17
2026-11-19 20:37insertca-abc 00612563|21|LIC|0 ↔ snap snap|us|1208440same address and namemerged17
2026-11-19 20:37insertoverture 8c597445-9424-4477-a0fe-1d62d055de85 ↔ snap snap|us|1208440same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1208440 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged17
2026-11-12 14:25insertab-inbev 3782247 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged12
2026-11-12 14:25insertca-abc 00612563|21|LIC|0 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged12
2026-11-12 14:25insertoverture 8c597445-9424-4477-a0fe-1d62d055de85 ↔ vtinfo 129d1fc766b31fdbsame address and namemerged12
2026-11-11 12:56insertab-inbev 3782247 ↔ ca-abc 00612563|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3782247 ↔ overture 8c597445-9424-4477-a0fe-1d62d055de85same address and namemerged12
2026-11-06 18:13insertca-abc 00612563|21|LIC|0 ↔ overture 8c597445-9424-4477-a0fe-1d62d055de85same address and namemerged11
2026-11-02 23:02backfillca-abc 00612563|21|LIC|0 ↔ doordash 24770753Claude judge: samemerged