Outlets /
Royal Liquors
SAN FRANCISCO, CA 94109 · O08d92dec0bc2 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Royal Liquorsalcohol: licensed1 licence18 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Royal Liquors 3 other | the most common name a source states | ROYAL LIQUOR ca-abc royal liquors san francisco doordash SINGH CHARANJIT ca-abc (legal name) |
| Street | 1400 POLK ST 1 other | ca-abc | 1400 Polk Street doordashubereats ×2 |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94109 | ca-abc | no other value |
| Pin | 37.78977, -122.42030 map | ubereats | no other value |
| Phone | 4154744400 | vtinfo | no other value |
| Licences | ca-abc 00656791|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O63637c8279f0; O77960cb2349d; O173a7773af16; Ob3c7300ec6b7; Od4e128a8b107
Carries
Products seen on this outlet’s shelf in store-level catalogs.
18products placed
792listings
774listings with no product match yet
doordashfrom
| Product | Source | Price | Stock | Seen |
|---|---|---|---|---|
| La Gritona 80 Proof Tequila Reposado Bottle (750 ml) Lagritona · 750 | doordash | $82.99 | — | 2026-11-01 |
| Palomo Espadin Artesanal Mezcal Bottle (750 ml) PALOMO · 750 | doordash | $59.99 | — | 2026-11-01 |
| Adictivo 80 Proof Plata Tequila Bottle (750 ml) Adictivo Tequila · 750 | doordash | $77.99 | — | 2026-11-01 |
| Adictivo 80 Proof Reposado Tequila Bottle (750 ml) Adictivo Tequila · 750 | doordash | $86.99 | — | 2026-11-01 |
| Gran Malo Spicy Tamarind Tequila Shot (50 ml) GRAN MALO · 50 | doordash | $3.99 | — | 2026-11-01 |
| Los Siete Misterios 88 Proof Doba-Yej Joven Mezcal Bottle (750 ml) LOS SIETE MISTERIOS · 750 | doordash | $57.99 | — | 2026-11-01 |
| Mandarine Napoleon Orange Grande Imperiale Liqueur Bottle (750 ml) 750 | doordash | $61.99 | — | 2026-11-01 |
| G4 Tequila 80 Proof Premium Blanco Tequila Bottle (750 ml) G4 · 750 | doordash | $73.99 | — | 2026-11-01 |
| Ojo De Tigre Artesanal 80 Proof Joven Mezcal Bottle (750 ml) Ojo De Tigre Artesanal Mezcal · 750 | doordash | $54.99 | — | 2026-11-01 |
| Don Fulano Reposado Tequila Bottle (750 ml) EJW · 750 | doordash | $86.99 | — | 2026-11-01 |
| Diplomatico Ambassador Diplomatico · 750 | doordash | $369.99 | — | 2026-11-01 |
| Gran Malo Spicy Tamarind Flavored Tequila Bottle (750 ml) GRAN MALO · 750 | doordash | $36.99 | — | 2026-11-01 |
| Adictivo 100% Agave Blue Label Anejo Tequila Bottle (750 ml) Adictivo Tequila · 750 | doordash | $153.99 | — | 2026-11-01 |
| Don Fulano Blanco Tequila (750 ml) EJW · 750 | doordash | $73.99 | — | 2026-11-01 |
| Fortaleza Still Strength Blanco Tequila Bottle (750 ml) 750 | doordash | $79.99 | — | 2026-11-01 |
| G4 Tequila 80 Proof Reposado Tequila Bottle (750 ml) G4 Tequila · 750 | doordash | $86.99 | — | 2026-11-01 |
| Don Fulano Anejo Tequila (750 ml) EJW · 750 | doordash | $110.99 | — | 2026-11-01 |
| Fortaleza 80 Proof Blanco Tequila Bottle (750 ml) Fortaleza · 750 | doordash | $122.99 | — | 2026-11-01 |
| Josh Cellars Rose (750 ml) not matched to a product yet | doordash | $22.99 | — | 2026-11-01 |
| Line 39 Pinot Noir Bottle California, 2018 (750 ml) not matched to a product yet | doordash | $14.99 | — | 2026-11-01 |
| Matua New Zealand Sauvignon Blanc Bottle (750 ml) not matched to a product yet | doordash | $18.99 | — | 2026-11-01 |
| Sutter Home Moscato Plastic Bottles California (187 ml x 4 ct) not matched to a product yet | doordash | $13.99 | — | 2026-11-01 |
| Kim Crawford Marlborough New Zealand Sauvignon Blanc Bottle (750 ml) not matched to a product yet | doordash | $24.99 | — | 2026-11-01 |
| Sutter Home California Sauvignon Blanc Plastic Bottles (187 ml x 4 ct) not matched to a product yet | doordash | $13.99 | — | 2026-11-01 |
| Mumm Napa Brut Prestige Sparkling Wine (1.5 L) not matched to a product yet | doordash | $30.99 | — | 2026-11-01 |
| Bota Box California Pinot Noir Box (3 L) not matched to a product yet | doordash | $28.99 | — | 2026-11-01 |
| Sutter Home California Pink Moscato Bottle (187 ml) not matched to a product yet | doordash | $3.99 | — | 2026-11-01 |
| Sutter Home California Merlot Bottles (187 ml x 4 ct) not matched to a product yet | doordash | $13.99 | — | 2026-11-01 |
| Underwood The Bubbles Sparkling Wine Can (12 fl oz) not matched to a product yet | doordash | $8.99 | — | 2026-11-01 |
| Cupcake Vineyards Sauvignon Blanc White Wine (750 ml) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Josh Cellars Pinot Grigio (750 ml) not matched to a product yet | doordash | $19.99 | — | 2026-11-01 |
| Josh Cellars Cabernet Sauvignon (750 ml) not matched to a product yet | doordash | $28.99 | — | 2026-11-01 |
| Josh Cellars Pinot Noir Bottle Central Coast (750 ml) not matched to a product yet | doordash | $27.99 | — | 2026-11-01 |
| Sutter Home California Pink Moscato Bottles (6.3 fl oz x 4 ct) not matched to a product yet | doordash | $13.99 | — | 2026-11-01 |
| Stella Rosa Peach Italian Semi-Sweet White Wine Bottle (750 ml) not matched to a product yet | doordash | $18.99 | — | 2026-11-01 |
| Bota Box Sauvignon Blanc Box (3 L) not matched to a product yet | doordash | $28.99 | — | 2026-11-01 |
| Ménage à Trois Wines Sweet Collection Moscato Bottle California (750 ml) not matched to a product yet | doordash | $18.99 | — | 2026-11-01 |
| Bogle Vineyards California 2017 Cabernet Sauvignon Bottle (750 ml) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Bogle Petite Sirah Wine Bottle (750 ml) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Stella Rosa Blueberry Italian Semi-Sweet Red Wine Bottle (750 ml) not matched to a product yet | doordash | $18.99 | — | 2026-11-01 |
| Sutter Home White Zinfandel Bottle California (187 ml) not matched to a product yet | doordash | $3.99 | — | 2026-11-01 |
| La Marca Prosecco Sparkling Wine (187 ml) not matched to a product yet | doordash | $10.99 | — | 2026-11-01 |
| La Marca Extra Dry Sparkling Prosecco Bottle Italy DOC (750 ml) not matched to a product yet | doordash | $28.99 | — | 2026-11-01 |
| Chandon Rosé Sparkling Wine (750 ml) not matched to a product yet | doordash | $33.99 | — | 2026-11-01 |
| Menage a Trois Wines Sublime Sauvignon Blanc Bottle California (750 ml) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Ménage à Trois Luscious Pinot Noir California (750 ml) not matched to a product yet | doordash | $17.99 | — | 2026-11-01 |
| Korbel Champagne 24 Proof Natural Champagne Bottle California, 2020 (750 ml) not matched to a product yet | doordash | $27.99 | — | 2026-11-01 |
| Seaglass Pinot Grigio Bottle Central Coast (750 ml) not matched to a product yet | doordash | $19.99 | — | 2026-11-01 |
| Chandon Brut Sparkling Wine (187 ml) not matched to a product yet | doordash | $12.99 | — | 2026-11-01 |
| Modelo Especial Mexican Lager Bottles (12 fl oz x 6 ct) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Corona Extra Pale Lager Longneck Bottles (12 fl oz x 6 ct) not matched to a product yet | doordash | $15.99 | — | 2026-11-01 |
| Coors Light American Lager Beer Cans (12 fl oz × 12 ct) not matched to a product yet | doordash | $20.99 | — | 2026-11-01 |
| Michelob Ultra Light Superior American Lager Slim Cans (12 fl oz x 12 ct) not matched to a product yet | doordash | $24.99 | — | 2026-11-01 |
| Modelo Especial Import Mexican Lager Cans (12 fl oz x 24 ct) not matched to a product yet | doordash | $52.99 | — | 2026-11-01 |
| Michelob Ultra Superior Limited Edition American Light Lager Bottles (12 fl oz x 6 ct) not matched to a product yet | doordash | $11.99 | — | 2026-11-01 |
| Sapporo Premium Beer Can (22 fl oz) not matched to a product yet | doordash | $4.99 | — | 2026-11-01 |
| Guinness Draught Stout Import Beer, 6 pack Bottles, 11.2 fl oz, 4.2% ABV not matched to a product yet | doordash | $14.99 | — | 2026-11-01 |
| Coronita Extra Mexican Lager Mini Longneck Bottles (7 fl oz x 6 ct) not matched to a product yet | doordash | $11.99 | — | 2026-11-01 |
| Bud Light American Lager Beer (12 fl oz × 6 ct) not matched to a product yet | doordash | $12.99 | — | 2026-11-01 |
| Stella Rosa Moscato d'Asti DOCG Semi-Sweet White Wine Bottle (750 ml) not matched to a product yet | doordash | $18.99 | — | 2026-11-01 |
Sources
Every source record folded into this outlet, as the source states it.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | ROYAL LIQUORS 2727516 | 1400 POLK ST, SAN FRANCISCO, CA, 94109 | 37.79011, -122.42052 | 2026-11-13 | 2026-11-13 | |
| ca-abc | ROYAL LIQUOR legal name: SINGH CHARANJIT 00656791|21|LIC|0 | 1400 POLK ST, SAN FRANCISCO, CA, 94109 | 37.78969, -122.42043 | 2026-10-08 | 2026-11-06 | |
| doordash | royal liquors san francisco 93750 | 1400 Polk Street, San Francisco, CA, 94109 | 37.78978, -122.42030 | 2026-10-08 | 2026-11-06 | |
| overture | Royal Liquors e476b427-6025-4e5a-b4ef-4bcca7d019c7 | 1400 Polk St, San Francisco, CA, 94109 | 4154744400 | 37.78977, -122.42029 | 2026-11-06 | 2026-11-06 |
| ubereats | Royal Liquors eyXqoIzyVzmiAym-2H7pLg | 1400 Polk Street, San Francisco, CA, 94109 | 37.78977, -122.42030 | 2026-10-20 | 2026-11-06 | |
| vtinfo | ROYAL LIQUORS 11e938315db359c4 | 1400 POLK ST, SAN FRANCISCO, CA, 94109 | 4154744400 | 37.78977, -122.42030 | 2026-11-11 | 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 ROYAL LIQUORS | doordash royal liquors san francisco | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00 |
| ab-inbev ROYAL LIQUORS | overture Royal Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 43 m apart · name similarity 1.00 |
| ab-inbev ROYAL LIQUORS | ubereats Royal Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00 |
| ab-inbev ROYAL LIQUORS | vtinfo ROYAL LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 m apart · name similarity 1.00 |
| doordash royal liquors san francisco | overture Royal Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00 |
| doordash royal liquors san francisco | ubereats Royal Liquors | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00 |
| doordash royal liquors san francisco | vtinfo ROYAL LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 |
| overture Royal Liquors | ubereats Royal Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00 |
| overture Royal Liquors | vtinfo ROYAL LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal |
| ubereats Royal Liquors | vtinfo ROYAL LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00 |
| ab-inbev ROYAL LIQUORS | ca-abc ROYAL LIQUOR | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 48 m apart · name similarity 0.65 |
| ca-abc ROYAL LIQUOR | doordash royal liquors san francisco | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The names match (Royal Liquor vs royal liquors with the city appended to the slug), the street address and ZIP are the same, and only one business is known at that address, with an off-sale licence. Other Claude answers on this pair:
pair 00b0a0d16790ccd3ccf8 |
| ca-abc ROYAL LIQUOR | overture Royal Liquors | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 16 m apart · name similarity 0.65 |
| ca-abc ROYAL LIQUOR | ubereats Royal Liquors | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The two records share the same street address and ZIP (1400 Polk St, 94109), the names differ only by singular/plural, and the ca-abc off-sale liquor licence matches a liquor store, with only one busi Other Claude answers on this pair:
pair 0272a42a3f7f915da94c |
| ca-abc ROYAL LIQUOR | vtinfo ROYAL LIQUORS | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 15 m apart · name similarity 0.65 |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- Royal Liquors — ubereats-parent
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 16:56.
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",
null
]
]
}Trade area
- Other outlets
- 1,986 within 1 mi · 4,932 within 3 mi
- Off / on premise
- 249 / 1,177 within 1 mi · 694 / 2,961 within 3 mi
- Selling alcohol
- 1,237 within 1 mi · 3,228 within 3 mi
- Nearest
- same channel 0.05 mi · licensed 0.01 mi
- Setting
- urban (15,481 people per sq mi)
- People within 3 mi
- 437,704 (383,764 adults 21+, 222,591 households) from 144 tract(s), tracts within 3 mi
- Income
- per capita $108,910 · median household ~$152,425 (weighted mean of tract medians)
- Age and education
- median age ~39.3 · bachelor's or higher 67%
- Ethnicity
- Hispanic 15% · White 47% · Black 5% · Asian 28%
- Adults per alcohol outlet
- 119
- Alcohol spend within 3 mi
- $212,065,598 a year ($90,129,043 at home, $121,871,387 away) · $65,675 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.
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-13 17:47 | insert | ab-inbev 2727516 ↔ ca-abc 00656791|21|LIC|0 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2727516 ↔ vtinfo 11e938315db359c4 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2727516 ↔ ubereats eyXqoIzyVzmiAym-2H7pLg | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2727516 ↔ overture e476b427-6025-4e5a-b4ef-4bcca7d019c7 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2727516 ↔ doordash 93750 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ca-abc 00656791|21|LIC|0 ↔ vtinfo 11e938315db359c4 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ubereats eyXqoIzyVzmiAym-2H7pLg ↔ vtinfo 11e938315db359c4 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 93750 ↔ vtinfo 11e938315db359c4 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | overture e476b427-6025-4e5a-b4ef-4bcca7d019c7 ↔ vtinfo 11e938315db359c4 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00656791|21|LIC|0 ↔ overture e476b427-6025-4e5a-b4ef-4bcca7d019c7 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture e476b427-6025-4e5a-b4ef-4bcca7d019c7 ↔ ubereats eyXqoIzyVzmiAym-2H7pLg | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 93750 ↔ overture e476b427-6025-4e5a-b4ef-4bcca7d019c7 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00656791|21|LIC|0 ↔ ubereats eyXqoIzyVzmiAym-2H7pLg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00656791|21|LIC|0 ↔ doordash 93750 | Claude judge: same | merged | |
| 2026-10-20 21:04 | backfill | doordash 93750 ↔ ubereats eyXqoIzyVzmiAym-2H7pLg | same address and name | merged |