Outlets /
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.
| Field | Master value | Taken from | What 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 | walgreens | no other value |
| State | CA | walgreens | no other value |
| ZIP | 94127 | walgreens | no other value |
| Pin | 37.73887, -122.46838 map 1 other | walgreens | 56 m away ab-inbev |
| Phone | 4156651008 | walgreens | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | WALGREENS 3185634 | 200 W PORTAL AVE, SAN FRANCISCO, CA, 94127 | 37.73841, -122.46866 | 2026-11-11 | 2026-11-11 | |
| ca-abc | WALGREENS 13670 legal name: WALGREEN CO 00478610|21|APP|0 | 200 W PORTAL AVE, SAN FRANCISCO, CA, 94127 | 2026-10-08 | 2026-11-05 | ||
| ca-abc | WALGREENS 13670 legal name: WALGREEN CO 00478610|21|LIC|0 | 200 W PORTAL AVE, SAN FRANCISCO, CA, 94127 | 2026-10-08 | 2026-11-05 | ||
| doordash | walgreens san francisco 1116640 | 200 West Portal Avenue, San Francisco, CA, 94127 | 37.73888, -122.46834 | 2026-10-08 | 2026-11-02 | |
| overture | Walgreens Pharmacy c5bed9a3-24a1-45c1-a39a-2eb282b10e87 | 200 W Portal Ave, San Francisco, CA, 94127 | 4156651008 | 37.73887, -122.46838 | 2026-11-13 | 2026-11-13 |
| ubereats | Walgreens JshNEu5JR2qL4xFXMwupFg | 200 West Portal Ave., San Francisco, CA, 94127 | 37.73887, -122.46827 | 2026-10-10 | 2026-11-02 | |
| vtinfo | WALGREENS 224f59e808fd5913 | 200 W PORTAL AVE, SAN FRANCISCO, CA, 94127 | 4156651008 | 37.73889, -122.46835 | 2026-11-12 | 2026-11-14 |
| walgreens | Walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | 200 W PORTAL AVE, San Francisco, CA, 94127 | 4156651008 | 37.73887, -122.46838 | 2026-11-06 | 2026-11-06 |
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 WALGREENS | doordash walgreens san francisco | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 59 m apart · name similarity 1.00 |
| ab-inbev WALGREENS | ubereats Walgreens | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00 |
| ab-inbev WALGREENS | vtinfo WALGREENS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00 |
| ab-inbev WALGREENS | walgreens Walgreens | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00 |
| ca-abc WALGREENS 13670 | ca-abc WALGREENS 13670 | 1.00 | one licence file | merged | file: 00478610 · same_address |
| ca-abc WALGREENS 13670 | overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ca-abc WALGREENS 13670 | overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| doordash walgreens san francisco | ubereats Walgreens | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 |
| doordash walgreens san francisco | vtinfo WALGREENS | 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 |
| doordash walgreens san francisco | walgreens Walgreens | 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 |
| ubereats Walgreens | vtinfo WALGREENS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 |
| ubereats Walgreens | walgreens Walgreens | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| vtinfo WALGREENS | walgreens Walgreens | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: equal |
| ab-inbev WALGREENS | ca-abc WALGREENS 13670 | 0.62 | same address and name | merged | address 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 WALGREENS | ca-abc WALGREENS 13670 | 0.62 | same address and name | merged | address 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 13670 | doordash walgreens san francisco | 0.62 | Claude judge: same | merged | 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:
pair 45eca97591a9abb7f61f |
| ca-abc WALGREENS 13670 | ubereats Walgreens | 0.62 | Claude judge: same | merged | 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:
pair 6883b9953196430efecc |
| ca-abc WALGREENS 13670 | vtinfo WALGREENS | 0.62 | same address and name | merged | address 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 13670 | walgreens Walgreens | 0.62 | same address and name | merged | address 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 13670 | doordash walgreens san francisco | 0.62 | Claude judge: same | merged | 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:
pair f61ed2d7e88af22f896b |
| ca-abc WALGREENS 13670 | ubereats Walgreens | 0.62 | Claude judge: same | merged | 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:
pair 668930f0a50590ca09ba |
| ca-abc WALGREENS 13670 | vtinfo WALGREENS | 0.62 | same address and name | merged | address 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 13670 | walgreens Walgreens | 0.62 | same address and name | merged | address 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 WALGREENS | overture Walgreens Pharmacy | 0.58 | same address and name | merged | address 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 francisco | overture Walgreens Pharmacy | 0.58 | same address and name | merged | address 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 Pharmacy | ubereats Walgreens | 0.58 | same address and name | merged | address 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 Pharmacy | vtinfo WALGREENS | 0.58 | same address and name | merged | address 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 Pharmacy | walgreens Walgreens | 0.58 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-13 14:10 | insert | overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | doordash 1116640 ↔ overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 3185634 ↔ overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture c5bed9a3-24a1-45c1-a39a-2eb282b10e87 ↔ ubereats JshNEu5JR2qL4xFXMwupFg | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ca-abc 00478610|21|LIC|0 ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00478610|21|APP|0 ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 1116640 ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 3185634 ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | vtinfo 224f59e808fd5913 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ubereats JshNEu5JR2qL4xFXMwupFg ↔ vtinfo 224f59e808fd5913 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3185634 ↔ ca-abc 00478610|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3185634 ↔ ca-abc 00478610|21|APP|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3185634 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3185634 ↔ ubereats JshNEu5JR2qL4xFXMwupFg | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3185634 ↔ doordash 1116640 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00478610|21|LIC|0 ↔ overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00478610|21|APP|0 ↔ overture 5dda137d-0a82-44a5-99a1-b36b4e758ef4 | same address and name | merged | 11 |
| 2026-11-06 17:13 | insert | ca-abc 00478610|21|LIC|0 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 11 |
| 2026-11-06 17:13 | insert | ca-abc 00478610|21|APP|0 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 11 |
| 2026-11-06 17:13 | insert | ubereats JshNEu5JR2qL4xFXMwupFg ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 11 |
| 2026-11-06 17:13 | insert | doordash 1116640 ↔ walgreens /locator/walgreens-200+w+portal+ave-san+francisco-ca-94127/id=13670 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00478610|21|LIC|0 ↔ doordash 1116640 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00478610|21|APP|0 ↔ ubereats JshNEu5JR2qL4xFXMwupFg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00478610|21|LIC|0 ↔ ubereats JshNEu5JR2qL4xFXMwupFg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00478610|21|APP|0 ↔ doordash 1116640 | Claude judge: same | merged | |
| 2026-10-13 17:02 | backfill | doordash 1116640 ↔ ubereats JshNEu5JR2qL4xFXMwupFg | same address and name | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00478610|21|APP|0 ↔ ca-abc 00478610|21|LIC|0 | one licence file | merged |