Delfina Restaurant

SAN FRANCISCO, CA 94110 · O33882621726f · 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
Delfina Restaurant 1 other
a source's own spelling of the licence name (record_title.py)
pizzeria delfina san francisco doordash
Street
3611-3621 18TH ST 2 other
ca-abc
3621 18th St overturevtinfo ×2
3621 18th Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94110
ca-abcno other value
Pin
37.76145, -122.42439 map
doordashno other value
Phone
4155524055
vtinfono other value
Licences
ca-abc 00639078|47|LIC|0 · ca-abc 00639078|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaadb938de446; Odf0e94335e1b; Oe81d3761cf87; O99d36f863437; O5af54e1a264d

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-abcDELFINA RESTAURANT
00639078|47|LIC|0
3611-3621 18TH ST, SAN FRANCISCO, CA, 9411037.76148, -122.424342026-10-082026-11-18
ca-abcDELFINA RESTAURANT
00639078|58|LIC|0
3611-3621 18TH ST, SAN FRANCISCO, CA, 9411037.76148, -122.424342026-10-082026-11-18
doordashpizzeria delfina san francisco
33639
3621 18th Street, San Francisco, CA, 9411037.76145, -122.424392026-10-082026-11-09
overtureDelfina Restaurant
1b2779ee-b841-4a70-bd32-7d4c8b2e8152
3621 18th St, San Francisco, CA, 94110415552405537.76140, -122.424352026-11-132026-11-13
vtinfoDELFINA RESTAURANT
e018eb113f582aff
3621 18TH ST, SAN FRANCISCO, CA, 94110415552405537.76139, -122.424302026-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 DELFINA RESTAURANTca-abc DELFINA RESTAURANT1.00one licence filemergedfile: 00639078 · same_address
ca-abc DELFINA RESTAURANTvtinfo DELFINA RESTAURANT1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name, address range includes 3621.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the identical name DELFINA RESTAURANT at 3621 18TH ST in San Francisco ZIP 94110, with coordinates about 10 m apart, and the California record's address range includes 3621; the restaurant licence matches the same-named business, though the building is shared with another business.
pair 2cf46ac5361ba4b9045b
ca-abc DELFINA RESTAURANTvtinfo DELFINA RESTAURANT1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Same name, address within licensed range
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are named DELFINA RESTAURANT in San Francisco 94110, with B's 3621 18TH ST inside A's 3611-3621 18TH ST range and coordinates 0.01 km apart; A's eating-place licence matches a restaurant, so they are one operation at one premises.
pair 214d73aad7383242b2b5
doordash pizzeria delfina san franciscooverture ed44182e-4d1b-4ab8-a50f-32f1f3f1f2641.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
overture Delfina Restaurantvtinfo DELFINA RESTAURANT1.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
doordash pizzeria delfina san franciscooverture Delfina Restaurant0.49same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pizzeria, restaurant · name Jaro-Winkler 0.84 · same street + ZIP · pins 7 m apart · name similarity 0.49
doordash pizzeria delfina san franciscovtinfo DELFINA RESTAURANT0.49same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pizzeria, restaurant · name Jaro-Winkler 0.84 · same street + city + state · pins 10 m apart · name similarity 0.49
overture ed44182e-4d1b-4ab8-a50f-32f1f3f1f264vtinfo DELFINA RESTAURANT0.46same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pizzeria, restaurant · name Jaro-Winkler 0.84 · same street + city + state · pins 5 m apart · name similarity 0.46 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
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",
   "bar"
  ]
 ]
}

Trade area

Other outlets
1,132 within 1 mi · 6,350 within 3 mi
Off / on premise
170 / 733 within 1 mi · 869 / 4,009 within 3 mi
Selling alcohol
773 within 1 mi · 3,894 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (20,563 people per sq mi)
People within 3 mi
581,405 (498,107 adults 21+, 272,721 households) from 174 tract(s), tracts within 3 mi
Income
per capita $101,992 · median household ~$154,117 (weighted mean of tract medians)
Age and education
median age ~40.4 · bachelor's or higher 64%
Ethnicity
Hispanic 17% · White 44% · Black 5% · Asian 30%
Adults per alcohol outlet
128
Alcohol spend within 3 mi
$263,453,186 a year ($111,821,392 at home, $151,552,024 away) · $67,639 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-18 18:58insertca-abc 00639078|47|LIC|0 ↔ vtinfo e018eb113f582affClaude judge: samemerged15
2026-11-18 18:58insertca-abc 00639078|58|LIC|0 ↔ vtinfo e018eb113f582affClaude judge: samemerged15
2026-11-13 14:10insertdoordash 33639 ↔ overture 1b2779ee-b841-4a70-bd32-7d4c8b2e8152same address and namemerged15
2026-11-13 14:10insertoverture 1b2779ee-b841-4a70-bd32-7d4c8b2e8152 ↔ vtinfo e018eb113f582affsame address and namemerged15
2026-11-12 17:29insertoverture ed44182e-4d1b-4ab8-a50f-32f1f3f1f264 ↔ vtinfo e018eb113f582affsame address and namemerged14
2026-11-12 17:29insertdoordash 33639 ↔ vtinfo e018eb113f582affsame address and namemerged14
2026-11-09 15:32insertdoordash 33639 ↔ overture ed44182e-4d1b-4ab8-a50f-32f1f3f1f264same address and namemerged11
2026-10-09 13:59backfillca-abc 00639078|47|LIC|0 ↔ ca-abc 00639078|58|LIC|0one licence filemerged