Walgreens

SAN FRANCISCO, CA 94127 · O230391d0391d · first seen 2026-10-08
7 sourcesoff premise · pharmacychain: Walgreensalcohol: 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.

FieldMaster valueTaken fromWhat other sources say
Name
Walgreens 4 other
the most common name a source states
WALGREEN CO ca-abc (legal name) ×2
WALGREENS 13670 ca-abc ×2
Walgreens Pharmacy overture
walgreens san francisco doordash
Street
200 W PORTAL AVE 2 other
walgreens
200 West Portal Ave. ubereats
200 West Portal Avenue doordash
City
San Francisco
walgreensno other value
State
CA
walgreensno other value
ZIP
94127
walgreensno other value
Pin
37.73887, -122.46838 map 1 other
walgreens
56 m away ab-inbev
Phone
4156651008
walgreensno other value
Licences
ca-abc 00478610|21|APP|0 · ca-abc 00478610|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odd6870046553; O7639270cdc80; O503a03d8fcef; Oed214edb1e5d; O7c1d7927d252; O394a54ab859f; Oee15bb1bdbd6; Ob5c265b4726f

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-inbevWALGREENS
3185634
200 W PORTAL AVE, SAN FRANCISCO, CA, 9412737.73841, -122.468662026-11-112026-11-11
ca-abcWALGREENS 13670
legal name: WALGREEN CO
00478610|21|APP|0
200 W PORTAL AVE, SAN FRANCISCO, CA, 941272026-10-082026-11-05
ca-abcWALGREENS 13670
legal name: WALGREEN CO
00478610|21|LIC|0
200 W PORTAL AVE, SAN FRANCISCO, CA, 941272026-10-082026-11-05
doordashwalgreens san francisco
1116640
200 West Portal Avenue, San Francisco, CA, 9412737.73888, -122.468342026-10-082026-11-02
overtureWalgreens Pharmacy
c5bed9a3-24a1-45c1-a39a-2eb282b10e87
200 W Portal Ave, San Francisco, CA, 94127415665100837.73887, -122.468382026-11-132026-11-13
ubereatsWalgreens
JshNEu5JR2qL4xFXMwupFg
200 West Portal Ave., San Francisco, CA, 9412737.73887, -122.468272026-10-102026-11-02
vtinfoWALGREENS
224f59e808fd5913
200 W PORTAL AVE, SAN FRANCISCO, CA, 94127415665100837.73889, -122.468352026-11-122026-11-14
walgreensWalgreens
/locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670
200 W PORTAL AVE, San Francisco, CA, 94127415665100837.73887, -122.468382026-11-062026-11-06

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 WALGREENSdoordash walgreens san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 59 m apart · name similarity 1.00
ab-inbev WALGREENSubereats Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00
ab-inbev WALGREENSvtinfo WALGREENS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00
ab-inbev WALGREENSwalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ca-abc WALGREENS 13670ca-abc WALGREENS 136701.00one licence filemergedfile: 00478610 · same_address
ca-abc WALGREENS 13670overture 5dda137d-0a82-44a5-99a1-b36b4e758ef41.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc WALGREENS 13670overture 5dda137d-0a82-44a5-99a1-b36b4e758ef41.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash walgreens san franciscoubereats Walgreens1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
doordash walgreens san franciscovtinfo WALGREENS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00
doordash walgreens san franciscowalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ubereats Walgreensvtinfo WALGREENS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
ubereats Walgreenswalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
vtinfo WALGREENSwalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: equal
ab-inbev WALGREENSca-abc WALGREENS 136700.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ab-inbev WALGREENSca-abc WALGREENS 136700.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ca-abc WALGREENS 13670doordash walgreens san francisco0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are Walgreens at 200 West Portal Ave, San Francisco 94127, and the only business our data holds at that address is Walgreens; the off-sale licence fits the drug store itself.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Walgreens at 200 West Portal Avenue, San Francisco 94127, with no conflicting suite numbers and only one business at that address; California's rule makes the DoorDash listing the store's own alcohol department, and the ABC licence is an active off-sale licence at that premises.
  • Claude Haiku 5.5, prompt v4: same, 87% confident — Both records are the Walgreens store at 200 W Portal Ave, San Francisco 94127, the only business the data holds at that address, and the ABC off-sale licence sits on that same premises under the store's own name, so this is one outlet listed by two sources.
pair 45eca97591a9abb7f61f
ca-abc WALGREENS 13670ubereats Walgreens0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the same Walgreens chain store at 200 West Portal Ave, San Francisco 94127, and the data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 92% confident — Both records are Walgreens at 200 W Portal Ave, San Francisco 94127, with no conflicting suite and only one business at the address; the CA ABC off-sale licence is the store's own alcohol sales, so the Uber Eats Walgreens listing is the same outlet.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, city and ZIP, and the California record's active off-sale liquor licence sits on a Walgreens store at that address, so the Uber Eats Walgreens listing matches one operation at one premises with no competing business at the address.
pair 6883b9953196430efecc
ca-abc WALGREENS 13670vtinfo WALGREENS0.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ca-abc WALGREENS 13670walgreens Walgreens0.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ca-abc WALGREENS 13670doordash walgreens san francisco0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are a Walgreens at the same street address, 200 W Portal Ave, San Francisco 94127, the only business our data holds there, and the off-sale licence fits a drug store selling alcohol.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Walgreens at 200 West Portal Avenue, San Francisco 94127, with no suite conflict and only one business at that address; the ABC licence for the Walgreens store is its off-sale alcohol licence, and in California the store's alcohol listing is the store's own department, so this is one outlet.
pair f61ed2d7e88af22f896b
ca-abc WALGREENS 13670ubereats Walgreens0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Walgreens chain at the same street address, 200 West Portal Ave, San Francisco 94127, and only one business is recorded at that address; the store number is just the chain's own b
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are the Walgreens store at 200 W Portal Ave, San Francisco 94127 with no conflicting suite or other business at that address, and California's rule makes a chain store's alcohol listing its own department, so the CA ABC off-sale licence and the Uber Eats Walgreens listing are one outlet.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records are at 200 West Portal Ave, San Francisco 94127, and the ABC record shows an active off-sale liquor licence at that premises under the Walgreens trade name, with no other business at the address, so the Uber Eats Walgreens storefront is the same operation.
pair 668930f0a50590ca09ba
ca-abc WALGREENS 13670vtinfo WALGREENS0.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ca-abc WALGREENS 13670walgreens Walgreens0.62same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · matched through the licence's legal name: WALGREEN CO · name similarity 0.62
ab-inbev WALGREENSoverture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + ZIP · pins 56 m apart · name similarity 0.58
doordash walgreens san franciscooverture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.63 · same street + ZIP · pins 4 m apart · name similarity 0.58
overture Walgreens Pharmacyubereats Walgreens0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + ZIP · pins 10 m apart · name similarity 0.58
overture Walgreens Pharmacyvtinfo WALGREENS0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + city + state · pins 4 m apart · name similarity 0.58 · phone: equal
overture Walgreens Pharmacywalgreens Walgreens0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + ZIP · pins 0 m apart · name similarity 0.58 · phone: equal

Attributes

Channel
off_premise · pharmacy — ca-licence
Chain
Walgreens — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
WALGREEN CO — 343 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "pharmacy"
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
206 within 1 mi · 2,097 within 3 mi
Off / on premise
39 / 136 within 1 mi · 379 / 1,368 within 3 mi
Selling alcohol
115 within 1 mi · 1,356 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.02 mi
Setting
urban (14,867 people per sq mi)
People within 3 mi
420,353 (345,050 adults 21+, 162,977 households) from 102 tract(s), tracts within 3 mi
Income
per capita $86,415 · median household ~$162,759 (weighted mean of tract medians)
Age and education
median age ~42.0 · bachelor's or higher 60%
Ethnicity
Hispanic 17% · White 38% · Black 3% · Asian 38%
Adults per alcohol outlet
254
Alcohol spend within 3 mi
$165,487,563 a year ($69,988,541 at home, $95,450,085 away) · $121,951 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 14:10insertoverture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ vtinfo 224f59e808fd5913same address and namemerged15
2026-11-13 14:10insertdoordash 1116640 ↔ overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87same address and namemerged15
2026-11-13 14:10insertab-inbev 3185634 ↔ overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87same address and namemerged15
2026-11-13 14:10insertoverture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged15
2026-11-13 14:10insertoverture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ ubereats JshNEu5JR2qL4xFXMwupFgsame address and namemerged15
2026-11-12 14:25insertca-abc 00478610|21|LIC|0 ↔ vtinfo 224f59e808fd5913same address and namemerged12
2026-11-12 14:25insertca-abc 00478610|21|APP|0 ↔ vtinfo 224f59e808fd5913same address and namemerged12
2026-11-12 14:25insertdoordash 1116640 ↔ vtinfo 224f59e808fd5913same address and namemerged12
2026-11-12 14:25insertab-inbev 3185634 ↔ vtinfo 224f59e808fd5913same address and namemerged12
2026-11-12 14:25insertvtinfo 224f59e808fd5913 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged12
2026-11-12 14:25insertubereats JshNEu5JR2qL4xFXMwupFg ↔ vtinfo 224f59e808fd5913same address and namemerged12
2026-11-11 12:56insertab-inbev 3185634 ↔ ca-abc 00478610|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3185634 ↔ ca-abc 00478610|21|APP|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3185634 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged12
2026-11-11 12:56insertab-inbev 3185634 ↔ ubereats JshNEu5JR2qL4xFXMwupFgsame address and namemerged12
2026-11-11 12:56insertab-inbev 3185634 ↔ doordash 1116640same address and namemerged12
2026-11-06 18:13insertca-abc 00478610|21|LIC|0 ↔ overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4same address and namemerged11
2026-11-06 18:13insertca-abc 00478610|21|APP|0 ↔ overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4same address and namemerged11
2026-11-06 17:13insertca-abc 00478610|21|LIC|0 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged11
2026-11-06 17:13insertca-abc 00478610|21|APP|0 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged11
2026-11-06 17:13insertubereats JshNEu5JR2qL4xFXMwupFg ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged11
2026-11-06 17:13insertdoordash 1116640 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670same address and namemerged11
2026-11-02 23:02backfillca-abc 00478610|21|LIC|0 ↔ doordash 1116640Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00478610|21|APP|0 ↔ ubereats JshNEu5JR2qL4xFXMwupFgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00478610|21|LIC|0 ↔ ubereats JshNEu5JR2qL4xFXMwupFgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00478610|21|APP|0 ↔ doordash 1116640Claude judge: samemerged
2026-10-13 17:02backfilldoordash 1116640 ↔ ubereats JshNEu5JR2qL4xFXMwupFgsame address and namemerged
2026-10-09 13:59backfillca-abc 00478610|21|APP|0 ↔ ca-abc 00478610|21|LIC|0one licence filemerged