Outlets /
Imperial Square Liquors
SAN FRANCISCO, CA 94102 · O30ed0872558c · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Imperial Square Liquors 3 other | a licence name in capitals, cleaned (derived; record_title.py) | IMPERIAL SQ LIQUORS ubereats imperial square liquors san francisco doordash PATEL CHETAN JAYANTI ca-abc (legal name) |
| Street | 251 ELLIS ST 1 other | ca-abc | 251 Ellis Street doordash |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94102 | ca-abc | no other value |
| Pin | 37.78502, -122.41053 map | ubereats | no other value |
| Phone | 4157764588 | vtinfo | no other value |
| Licences | ca-abc 00343634|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe5652f22278e; O85dde07036ff; O3c4907bb82a8; O6510a43aa5cf
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 | IMPERIAL SQUARE LIQUORS 2212493 | 251 ELLIS ST, SAN FRANCISCO, CA, 94102 | 37.78514, -122.41029 | 2026-11-13 | 2026-11-13 | |
| ca-abc | IMPERIAL SQUARE LIQUORS legal name: PATEL CHETAN JAYANTI 00343634|21|LIC|0 | 251 ELLIS ST, SAN FRANCISCO, CA, 94102 | 37.78512, -122.41032 | 2026-10-08 | 2026-11-11 | |
| doordash | imperial square liquors san francisco 24500015 | 251 Ellis Street, San Francisco, CA, 94102 | 37.78489, -122.41026 | 2026-10-08 | 2026-11-11 | |
| ubereats | IMPERIAL SQ LIQUORS md0MjrJMVUutvdO6h7ifbw | 251 Ellis St, San Francisco, CA, 94102 | 37.78502, -122.41053 | 2026-10-14 | 2026-11-11 | |
| vtinfo | IMPERIAL SQUARE LIQUORS f8cd5f7e10bcfcb1 | 251 ELLIS ST, SAN FRANCISCO, CA, 94102 | 4157764588 | 37.78505, -122.41030 | 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 IMPERIAL SQUARE LIQUORS | ca-abc IMPERIAL SQUARE LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| ab-inbev IMPERIAL SQUARE LIQUORS | doordash imperial square liquors san francisco | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 |
| ab-inbev IMPERIAL SQUARE LIQUORS | vtinfo IMPERIAL SQUARE LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00 |
| ca-abc IMPERIAL SQUARE LIQUORS | doordash imperial square liquors san francisco | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · name similarity 1.00 |
| ca-abc IMPERIAL SQUARE LIQUORS | vtinfo IMPERIAL SQUARE LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00 |
| doordash imperial square liquors san francisco | vtinfo IMPERIAL SQUARE LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 |
| ab-inbev IMPERIAL SQUARE LIQUORS | ubereats IMPERIAL SQ LIQUORS | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 25 m apart · name similarity 0.70 |
| ca-abc IMPERIAL SQUARE LIQUORS | ubereats IMPERIAL SQ LIQUORS | 0.70 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) The two names match, with 'SQ' as an abbreviation of 'Square', at the identical street address and ZIP; it is an off-sale liquor store and the only business at that address. Other Claude answers on this pair:
pair d171d3ce4f453bd836b7 |
| doordash imperial square liquors san francisco | ubereats IMPERIAL SQ LIQUORS | 0.70 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) Both records give the same distinctive name (with 'Sq' abbreviating 'Square') at the same street address, 251 Ellis St, San Francisco 94102, and our data holds only one business at that address. Other Claude answers on this pair:
pair 8723d0001e744944f7a7 |
| ubereats IMPERIAL SQ LIQUORS | vtinfo IMPERIAL SQUARE LIQUORS | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + city + state · pins 21 m apart · name similarity 0.70 |
Attributes
- Channel
- off_premise · liquor_store — ca-licence conflicting evidence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
"ue_location": [
"PHYSICAL"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"ubereats-type",
"on_premise",
"restaurant"
],
[
"doordash-url",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 2,609 within 1 mi · 5,709 within 3 mi
- Off / on premise
- 254 / 1,626 within 1 mi · 754 / 3,586 within 3 mi
- Selling alcohol
- 1,456 within 1 mi · 3,563 within 3 mi
- Nearest
- same channel 0.06 mi · licensed 0.05 mi
- Setting
- urban (15,418 people per sq mi)
- People within 3 mi
- 435,940 (382,099 adults 21+, 221,649 households) from 144 tract(s), tracts within 3 mi
- Income
- per capita $109,311 · median household ~$152,663 (weighted mean of tract medians)
- Age and education
- median age ~39.4 · bachelor's or higher 67%
- Ethnicity
- Hispanic 16% · White 47% · Black 5% · Asian 27%
- Adults per alcohol outlet
- 107
- Alcohol spend within 3 mi
- $211,254,100 a year ($89,759,302 at home, $121,429,540 away) · $59,274 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-13 17:47 | insert | ab-inbev 2212493 ↔ ubereats md0MjrJMVUutvdO6h7ifbw | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2212493 ↔ vtinfo f8cd5f7e10bcfcb1 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2212493 ↔ doordash 24500015 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2212493 ↔ ca-abc 00343634|21|LIC|0 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ubereats md0MjrJMVUutvdO6h7ifbw ↔ vtinfo f8cd5f7e10bcfcb1 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 24500015 ↔ vtinfo f8cd5f7e10bcfcb1 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00343634|21|LIC|0 ↔ vtinfo f8cd5f7e10bcfcb1 | same address and name | merged | 12 |
| 2026-11-02 23:02 | backfill | ca-abc 00343634|21|LIC|0 ↔ ubereats md0MjrJMVUutvdO6h7ifbw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 24500015 ↔ ubereats md0MjrJMVUutvdO6h7ifbw | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00343634|21|LIC|0 ↔ doordash 24500015 | same address and name | merged |