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.

FieldMaster valueTaken fromWhat 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-abcno other value
State
CA
ca-abcno other value
ZIP
94102
ca-abcno other value
Pin
37.78502, -122.41053 map
ubereatsno other value
Phone
4157764588
vtinfono 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevIMPERIAL SQUARE LIQUORS
2212493
251 ELLIS ST, SAN FRANCISCO, CA, 9410237.78514, -122.410292026-11-132026-11-13
ca-abcIMPERIAL SQUARE LIQUORS
legal name: PATEL CHETAN JAYANTI
00343634|21|LIC|0
251 ELLIS ST, SAN FRANCISCO, CA, 9410237.78512, -122.410322026-10-082026-11-11
doordashimperial square liquors san francisco
24500015
251 Ellis Street, San Francisco, CA, 9410237.78489, -122.410262026-10-082026-11-11
ubereatsIMPERIAL SQ LIQUORS
md0MjrJMVUutvdO6h7ifbw
251 Ellis St, San Francisco, CA, 9410237.78502, -122.410532026-10-142026-11-11
vtinfoIMPERIAL SQUARE LIQUORS
f8cd5f7e10bcfcb1
251 ELLIS ST, SAN FRANCISCO, CA, 94102415776458837.78505, -122.410302026-11-112026-11-14

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 IMPERIAL SQUARE LIQUORSca-abc IMPERIAL SQUARE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ab-inbev IMPERIAL SQUARE LIQUORSdoordash imperial square liquors san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ab-inbev IMPERIAL SQUARE LIQUORSvtinfo IMPERIAL SQUARE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
ca-abc IMPERIAL SQUARE LIQUORSdoordash imperial square liquors san francisco1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc IMPERIAL SQUARE LIQUORSvtinfo IMPERIAL SQUARE LIQUORS1.00same address and namemergedaddress 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 franciscovtinfo IMPERIAL SQUARE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ab-inbev IMPERIAL SQUARE LIQUORSubereats IMPERIAL SQ LIQUORS0.70same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 25 m apart · name similarity 0.70
ca-abc IMPERIAL SQUARE LIQUORSubereats IMPERIAL SQ LIQUORS0.70Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records sit at 251 Ellis St, San Francisco 94102, with the same distinctive name abbreviated (IMPERIAL SQUARE LIQUORS vs IMPERIAL SQ LIQUORS), the CA record is an active off-sale liquor store licence, and no other business is held at that address.
pair d171d3ce4f453bd836b7
doordash imperial square liquors san franciscoubereats IMPERIAL SQ LIQUORS0.70Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are at 251 Ellis Street, San Francisco 94102 with coordinates about 28 m apart, only one business is held at that address, and the names 'Imperial Square Liquors' and 'IMPERIAL SQ LIQUORS' are the same liquor store written two ways.
pair 8723d0001e744944f7a7
ubereats IMPERIAL SQ LIQUORSvtinfo IMPERIAL SQUARE LIQUORS0.70same address and namemergedaddress 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”).
WhenEventPairRuleDecisionRule version
2026-11-13 17:47insertab-inbev 2212493 ↔ ubereats md0MjrJMVUutvdO6h7ifbwsame address and namemerged15
2026-11-13 17:47insertab-inbev 2212493 ↔ vtinfo f8cd5f7e10bcfcb1same address and namemerged15
2026-11-13 17:47insertab-inbev 2212493 ↔ doordash 24500015same address and namemerged15
2026-11-13 17:47insertab-inbev 2212493 ↔ ca-abc 00343634|21|LIC|0same address and namemerged15
2026-11-11 12:56insertubereats md0MjrJMVUutvdO6h7ifbw ↔ vtinfo f8cd5f7e10bcfcb1same address and namemerged12
2026-11-11 12:56insertdoordash 24500015 ↔ vtinfo f8cd5f7e10bcfcb1same address and namemerged12
2026-11-11 12:56insertca-abc 00343634|21|LIC|0 ↔ vtinfo f8cd5f7e10bcfcb1same address and namemerged12
2026-11-02 23:02backfillca-abc 00343634|21|LIC|0 ↔ ubereats md0MjrJMVUutvdO6h7ifbwClaude judge: samemerged
2026-11-02 23:02backfilldoordash 24500015 ↔ ubereats md0MjrJMVUutvdO6h7ifbwClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00343634|21|LIC|0 ↔ doordash 24500015same address and namemerged