DSW

Costa Mesa, CA 92626 · O8f20dec6fd23 · first seen 2026-10-08
3 sourcesoff premise · retail_otherchain: DSWalcohol: no alcohol retail

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
DSW 1 other
a licence name in capitals, cleaned (derived; record_title.py)
dsw costa mesa doordash
Street
901-B South Coast DriveSuite 100 2 other
ubereats
901 S Coast Dr Ste B100 # Ste doordash
901-B South Coast Drive overture
City
Costa Mesa
ubereatsno other value
State
CA
ubereatsno other value
ZIP
92626
ubereatsno other value
Pin
33.68884, -117.89580 map
ubereatsno other value
Phone
7146689631
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odef13a85957e; Oab2f2122233a

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
doordashdsw costa mesa
32231469
901 S Coast Dr Ste B100 # Ste, Costa Mesa, CA, 9262633.68880, -117.895872026-10-082026-11-02
overtureDSW
c0e32cbe-194c-497e-bc7a-d4fde944c264
901-B South Coast Drive, Costa Mesa, CA, 92626714668963133.68896, -117.895572026-11-182026-11-18
ubereatsDSW
588P16UdWzqTUrU9eR_EyA
901-B South Coast DriveSuite 100, Costa Mesa, CA, 9262633.68884, -117.895802026-10-262026-11-02

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 dsw costa mesaoverture DSW1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 33 m apart · name similarity 1.00 · street similarity 0.91
doordash dsw costa mesaubereats DSW1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records are the DSW chain at 901 S Coast Dr, Suite B100, Costa Mesa, 8 m apart; the unit is written differently but is equivalent (B100 vs 901-B Suite 100), so the names and premises agree despit
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 88% confident — Both records are DSW at 901 S Coast Dr, Suite B100 in Costa Mesa, 8 m apart, with matching ZIP and phone-free but consistent suite information (B100 vs. B-Suite 100); the names agree and the building holds other businesses, but the DSW name and suite match identify one store.
pair aa698c407a8a856568e1

Attributes

Channel
off_premise · retail_other — ubereats-type
Chain
DSW — ubereats-parent
Alcohol
no_alcohol_retail — DSW: licensed at 1 of 257 outlets in licence states
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:35.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "retail_other"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
335 within 1 mi · 1,361 within 3 mi
Off / on premise
71 / 219 within 1 mi · 237 / 833 within 3 mi
Selling alcohol
187 within 1 mi · 661 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.04 mi
Setting
urban (7,078 people per sq mi)
People within 3 mi
200,125 (155,530 adults 21+, 69,173 households) from 37 tract(s), tracts within 3 mi
Income
per capita $49,902 · median household ~$112,555 (weighted mean of tract medians)
Age and education
median age ~36.4 · bachelor's or higher 38%
Ethnicity
Hispanic 50% · White 34% · Black 2% · Asian 15%
Adults per alcohol outlet
235
Alcohol spend within 3 mi
$58,247,911 a year ($25,633,661 at home, $32,590,187 away) · $88,121 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-18 18:58insertdoordash 32231469 ↔ overture c0e32cbe-194c-497e-bc7a-d4fde944c264street written two waysmerged15
2026-11-02 23:02backfilldoordash 32231469 ↔ ubereats 588P16UdWzqTUrU9eR_EyAClaude judge: samemerged