The Stinking Rose a Garlic Restaurant

SAN FRANCISCO, CA 94133 · O539e6db7d6f3 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
The Stinking Rose a Garlic Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
C P C RESTAURANT INC ca-abc (legal name) ×2
STINKING ROSE A GARLIC RESTAURANT THE ca-abc ×2
The Stinking Rose overturevtinfo ×2
the stinking rose san francisco doordash
Street
430 COLUMBUS AVE
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94133
ca-abcno other value
Pin
37.79905, -122.40816 map
doordashno other value
Phone
4157817673
vtinfono other value
Licences
ca-abc 00343021|47|LIC|0 · ca-abc 00343021|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O87e8858cc442; Ob94f1b7ca090; O90b41dfd7ca2; Ocb055e983fba

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
ca-abcSTINKING ROSE A GARLIC RESTAURANT THE
legal name: C P C RESTAURANT INC
00343021|47|LIC|0
430 COLUMBUS AVE, SAN FRANCISCO, CA, 9413337.79900, -122.408192026-10-082026-11-05
ca-abcSTINKING ROSE A GARLIC RESTAURANT THE
legal name: C P C RESTAURANT INC
00343021|58|LIC|0
430 COLUMBUS AVE, SAN FRANCISCO, CA, 9413337.79900, -122.408192026-10-082026-11-05
doordashthe stinking rose san francisco
46601426
430 Columbus Ave, San Francisco, CA, 9413337.79905, -122.408162026-10-082026-11-11
overtureThe Stinking Rose
e8b013ba-75eb-407a-bca5-c589ce4add8a
430 Columbus Ave, San Francisco, CA, 94133415781767337.79908, -122.408202026-11-092026-11-11
vtinfoTHE STINKING ROSE
a9888a5c065b6d16
430 COLUMBUS AVE, SAN FRANCISCO, CA, 94133415781767337.79903, -122.408152026-11-122026-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
ca-abc STINKING ROSE A GARLIC RESTAURANT THEca-abc STINKING ROSE A GARLIC RESTAURANT THE1.00one licence filemergedfile: 00343021 · same_address
doordash the stinking rose san franciscooverture The Stinking Rose1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash the stinking rose san franciscovtinfo THE STINKING ROSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
overture The Stinking Rosevtinfo THE STINKING ROSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00 · phone: equal
ca-abc STINKING ROSE A GARLIC RESTAURANT THEdoordash the stinking rose san francisco0.48Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
The distinctive name 'The Stinking Rose' appears in both records at the same address, 430 Columbus Ave, San Francisco 94133, and the two coordinates are 7 m apart. Our data holds only one business at
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give 430 Columbus Ave, San Francisco 94133, with coordinates about 7 m apart, and the names match (The Stinking Rose restaurant); the only business at that address is one on-sale eating-place licence, so this is one restaurant listed on DoorDash.
pair b30fab7684acd370513f
ca-abc STINKING ROSE A GARLIC RESTAURANT THEdoordash the stinking rose san francisco0.48Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The names match: 'The Stinking Rose' with the city appended to the DoorDash slug. Both records give 430 Columbus Ave, 94133, the coordinates are 7 m apart, and only one business is known at the addres
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records sit at 430 Columbus Ave, San Francisco 94133 with matching coordinates, the only business at that address, and the name 'The Stinking Rose' matches; the ABC licence is an on-sale eating place restaurant, consistent with the DoorDash storefront being the same restaurant.
pair 9ff8e310aa6b5b73a4dd

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
C P C RESTAURANT INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,984 within 1 mi · 4,923 within 3 mi
Off / on premise
204 / 1,225 within 1 mi · 615 / 3,082 within 3 mi
Selling alcohol
1,201 within 1 mi · 3,050 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (12,406 people per sq mi)
People within 3 mi
350,776 (310,346 adults 21+, 182,414 households) from 119 tract(s), tracts within 3 mi
Income
per capita $106,185 · median household ~$145,423 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 65%
Ethnicity
Hispanic 15% · White 45% · Black 6% · Asian 29%
Adults per alcohol outlet
102
Alcohol spend within 3 mi
$168,877,494 a year ($72,052,383 at home, $96,770,495 away) · $55,352 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-12 14:25insertdoordash 46601426 ↔ vtinfo a9888a5c065b6d16same address and namemerged12
2026-11-12 14:25insertoverture e8b013ba-75eb-407a-bca5-c589ce4add8a ↔ vtinfo a9888a5c065b6d16same address and namemerged12
2026-11-11 12:56insertca-abc 00343021|47|LIC|0 ↔ doordash 46601426Claude judge: samemerged12
2026-11-11 12:56insertca-abc 00343021|58|LIC|0 ↔ doordash 46601426Claude judge: samemerged12
2026-11-09 15:32insertdoordash 46601426 ↔ overture e8b013ba-75eb-407a-bca5-c589ce4add8asame address and namemerged11
2026-10-09 13:59backfillca-abc 00343021|47|LIC|0 ↔ ca-abc 00343021|58|LIC|0one licence filemerged