Outlets /
Friend's Market Liquor
SAN YSIDRO, CA 92173 · O4d27294146dd · first seen 2026-10-08
7 sourcesoff premise · liquor_storealcohol: licensed2 licences
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 | Friend's Market Liquor 5 other | a source's own spelling of the licence name (record_title.py) | FRIENDS MARKET & LIQUOR ca-abcubereats ×3 BJ SPIRITS INC. ca-abc (legal name) ×2 FRIENDS MARKET ab-inbevvtinfo ×2 FRIENDS MARKET AND LIQUOR inspections friends market liquor san diego doordash |
| Street | 125-27 W SAN YSIDRO BLVD 3 other | ca-abc | 125 West San Ysidro Boulevard doordashubereats ×3 125 W SAN YSIDRO BLVD inspectionsoverture ×2 125 W SAN YSIDRO BLVD STE 125-127 ab-inbevvtinfo ×2 |
| City | SAN YSIDRO 1 other | ca-abc | San Diego doordashovertureubereats ×4 |
| State | CA | ca-abc | no other value |
| ZIP | 92173 | ca-abc | no other value |
| Pin | 32.55288, -117.04537 map 1 other | ubereats | 142 m away ab-inbev |
| Phone | 6198165321 | vtinfo | no other value |
| Licences | ca-abc 00594840|21|LIC|0 · ca-abc 00594840|86|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O6839819314c0; Ofcdccc7f69d6; Oe1a3496cca5e; Od0d5e0d48ec1; O8f9b8344db7f; Ob403872d9e68; O5b942aae39c5; O5c1c6e1c3ecf
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 |
|---|---|---|---|---|---|---|
| ab-inbev | FRIENDS MARKET 41656 | 125 W SAN YSIDRO BLVD STE 125-127, SAN YSIDRO, CA, 92173 | 32.55335, -117.04678 | 2026-11-11 | 2026-11-13 | |
| ca-abc | FRIENDS MARKET & LIQUOR legal name: BJ SPIRITS INC. 00594840|21|LIC|0 | 125-27 W SAN YSIDRO BLVD, SAN YSIDRO, CA, 92173 | 32.55271, -117.04534 | 2026-10-08 | 2026-11-13 | |
| ca-abc | FRIENDS MARKET & LIQUOR legal name: BJ SPIRITS INC. 00594840|86|LIC|0 | 125-27 W SAN YSIDRO BLVD, SAN YSIDRO, CA, 92173 | 32.55271, -117.04534 | 2026-10-08 | 2026-11-13 | |
| doordash | friends market liquor san diego 2413380 | 125 West San Ysidro Boulevard, San Diego, CA, 92173 | 32.55280, -117.04541 | 2026-10-08 | 2026-11-13 | |
| inspections | FRIENDS MARKET AND LIQUOR inspections|sdcounty|DEH2019-FFPN-001623 | 125 W SAN YSIDRO BLVD, San Ysidro, CA, 92173 | 32.55271, -117.04534 | 2026-11-20 | 2026-11-22 | |
| overture | Friend's Market Liquor a5ec0d18-4c27-420e-8b27-547a38447735 | 125 W San Ysidro Blvd, San Diego, CA, 92173 | 6198165321 | 32.55278, -117.04539 | 2026-11-06 | 2026-11-13 |
| ubereats | FRIENDS MARKET & LIQUOR GU47dYapRPSeRgV48yUK0Q | 125 West San Ysidro Boulevard, San Diego, CA, 92173 | 32.55288, -117.04537 | 2026-10-14 | 2026-11-13 | |
| ubereats | Friend's Market Liquor xvy2a9KWWoCAC55HzNi1qA | 125 West San Ysidro Boulevard, San Diego, CA, 92173 | 32.55288, -117.04540 | 2026-10-14 | 2026-11-13 | |
| vtinfo | FRIENDS MARKET 76e40af875ea7e71 | 125 W SAN YSIDRO BLVD STE 125-127, SAN YSIDRO, CA, 92173 | 6198165321 | 32.55294, -117.04530 | 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 |
|---|---|---|---|---|---|
| ab-inbev FRIENDS MARKET | vtinfo FRIENDS MARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 146 m apart · name similarity 1.00 |
| ca-abc FRIENDS MARKET & LIQUOR | ca-abc FRIENDS MARKET & LIQUOR | 1.00 | one licence file | merged | file: 00594840 · same_address |
| ca-abc FRIENDS MARKET & LIQUOR | ubereats FRIENDS MARKET & LIQUOR | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “proximity” pair) The name is identical, the address (125 W San Ysidro Blvd, ZIP 92173) matches, the coordinates are 19 m apart, and only one business is listed at the address. San Ysidro is a community within San Dieg Other Claude answers on this pair:
pair 926f16093d9556198bd4 |
| ca-abc FRIENDS MARKET & LIQUOR | ubereats Friend's Market Liquor | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “proximity” pair) The names match (Friends Market & Liquor), the street matches (125 W San Ysidro Blvd, ZIP 92173, San Ysidro being part of San Diego), the coordinates are 0.02 km apart, our data holds only one busines Other Claude answers on this pair:
pair 8e1c54d8f096d16f5442 |
| ca-abc FRIENDS MARKET & LIQUOR | ubereats FRIENDS MARKET & LIQUOR | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “proximity” pair) The name is identical, the street address and ZIP match (125-27 vs 125 W San Ysidro Blvd), the records are 19 m apart, and only one business is known at the address. Other Claude answers on this pair:
pair 351aab6be4eb612698d4 |
| ca-abc FRIENDS MARKET & LIQUOR | ubereats Friend's Market Liquor | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “proximity” pair) The names match ('Friends Market & Liquor' vs 'Friend's Market Liquor'), and both sit at 125 W San Ysidro Blvd, ZIP 92173, 0.02 km apart, with only one business known at the address; San Ysidro is a c Other Claude answers on this pair:
pair dcfc432a56702afc54f4 |
| doordash friends market liquor san diego | overture Friend's Market Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00 |
| doordash friends market liquor san diego | ubereats FRIENDS MARKET & LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| doordash friends market liquor san diego | ubereats Friend's Market Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 |
| inspections FRIENDS MARKET AND LIQUOR | overture Friend's Market Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| inspections FRIENDS MARKET AND LIQUOR | ubereats FRIENDS MARKET & LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| inspections FRIENDS MARKET AND LIQUOR | ubereats Friend's Market Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| overture Friend's Market Liquor | ubereats FRIENDS MARKET & LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| overture Friend's Market Liquor | ubereats Friend's Market Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| ubereats FRIENDS MARKET & LIQUOR | ubereats Friend's Market Liquor | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| ca-abc FRIENDS MARKET & LIQUOR | doordash friends market liquor san diego | 0.81 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “proximity” pair) The names match (the DoorDash slug 'friends market liquor' with the city appended), both records are at 125 W San Ysidro Blvd, ZIP 92173, 12 m apart, and they are the only business at that address; Sa Other Claude answers on this pair:
pair 934c8c03b60a1c563222 |
| ca-abc FRIENDS MARKET & LIQUOR | doordash friends market liquor san diego | 0.81 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “proximity” pair) The names match ('Friends Market & Liquor' against the slug 'friends market liquor' with the city appended), and both records give 125 W San Ysidro Blvd, ZIP 92173, 12 m apart, with only one business Other Claude answers on this pair:
pair 30ae47f1bd85baeb7c43 |
| doordash friends market liquor san diego | inspections FRIENDS MARKET AND LIQUOR | 0.81 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.77 · same street + ZIP · name similarity 0.81 |
| ab-inbev FRIENDS MARKET | ca-abc FRIENDS MARKET & LIQUOR | 0.73 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (93% confident; asked as a “near” pair) The names 'Friends Market' and 'Friends Market & Liquor' match at the same address: 125 W San Ysidro Blvd, suites 125-127, which is written as '125-27'. The California licence is an off-sale store lic Other Claude answers on this pair:
pair 0469c60a1642b33d01de |
| ca-abc FRIENDS MARKET & LIQUOR | vtinfo FRIENDS MARKET | 0.73 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair) Friends Market same suite range 125-127, same street. Other Claude answers on this pair:
pair 1d968a0839c5c344e4cc |
| doordash friends market liquor san diego | vtinfo FRIENDS MARKET | 0.59 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair) Friends Market same address and name Other Claude answers on this pair:
pair 0906105886dbb6aaed07 |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- BJ SPIRITS INC. — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 103 within 1 mi · 257 within 3 mi
- Off / on premise
- 42 / 43 within 1 mi · 90 / 125 within 3 mi
- Selling alcohol
- 43 within 1 mi · 122 within 3 mi
- Nearest
- same channel 0.09 mi · licensed 0.01 mi
- Setting
- urban (3,381 people per sq mi)
- People within 3 mi
- 95,590 (69,037 adults 21+, 27,445 households) from 19 tract(s), tracts within 3 mi
- Income
- per capita $30,691 · median household ~$89,476 (weighted mean of tract medians)
- Age and education
- median age ~37.3 · bachelor's or higher 19%
- Ethnicity
- Hispanic 77% · White 20% · Black 3% · Asian 9%
- Adults per alcohol outlet
- 561
- Alcohol spend within 3 mi
- $18,830,135 a year ($8,612,694 at home, $10,208,175 away) · $153,091 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-20 22:08 | insert | doordash 2413380 ↔ inspections inspections|sdcounty|DEH2019-FFPN-001623 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|sdcounty|DEH2019-FFPN-001623 ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|sdcounty|DEH2019-FFPN-001623 ↔ ubereats GU47dYapRPSeRgV48yUK0Q | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|sdcounty|DEH2019-FFPN-001623 ↔ overture a5ec0d18-4c27-420e-8b27-547a38447735 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | doordash 2413380 ↔ vtinfo 76e40af875ea7e71 | Claude judge: same | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00594840|21|LIC|0 ↔ vtinfo 76e40af875ea7e71 | Claude judge: same | merged | 17 |
| 2026-11-13 14:10 | insert | ab-inbev 41656 ↔ vtinfo 76e40af875ea7e71 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 41656 ↔ ca-abc 00594840|21|LIC|0 | Claude judge: same | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|21|LIC|0 ↔ doordash 2413380 | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|86|LIC|0 ↔ doordash 2413380 | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|86|LIC|0 ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|21|LIC|0 ↔ ubereats GU47dYapRPSeRgV48yUK0Q | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|21|LIC|0 ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00594840|86|LIC|0 ↔ ubereats GU47dYapRPSeRgV48yUK0Q | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | overture a5ec0d18-4c27-420e-8b27-547a38447735 ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture a5ec0d18-4c27-420e-8b27-547a38447735 ↔ ubereats GU47dYapRPSeRgV48yUK0Q | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 2413380 ↔ overture a5ec0d18-4c27-420e-8b27-547a38447735 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | ubereats GU47dYapRPSeRgV48yUK0Q ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | one store listed twice | merged | |
| 2026-11-02 23:02 | backfill | doordash 2413380 ↔ ubereats xvy2a9KWWoCAC55HzNi1qA | same address and name | merged | |
| 2026-10-14 18:03 | backfill | doordash 2413380 ↔ ubereats GU47dYapRPSeRgV48yUK0Q | same address and name | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00594840|21|LIC|0 ↔ ca-abc 00594840|86|LIC|0 | one licence file | merged |