CRAFTY FOX ALE HOUSE THE

SAN FRANCISCO, CA 94103 · O2c570bf45314 · 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
CRAFTY FOX ALE HOUSE THE 4 other
the most common name a source states
DERRY PARTNERS LLC ca-abc (legal name) ×2
CRAFTY FOX ALE HOUSE vtinfo
The Crafty Fox Ale House overture
the crafty fox ale house san francisco doordash
Street
1700 MISSION ST 1 other
ca-abc
1700 Mission Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.76990, -122.42032 map
doordashno other value
Phone
4154166602
vtinfono other value
Licences
ca-abc 00550676|41|APP|0 · ca-abc 00550676|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O90b9e147b704; Oe1577e11a3ac; O83a12d0bc630; Of70de02f8994

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-abcCRAFTY FOX ALE HOUSE THE
legal name: DERRY PARTNERS LLC
00550676|41|APP|0
1700 MISSION ST, SAN FRANCISCO, CA, 9410337.76987, -122.420232026-10-082026-11-05
ca-abcCRAFTY FOX ALE HOUSE THE
legal name: DERRY PARTNERS LLC
00550676|41|LIC|0
1700 MISSION ST, SAN FRANCISCO, CA, 9410337.76987, -122.420232026-10-082026-11-05
doordashthe crafty fox ale house san francisco
79012
1700 Mission Street, San Francisco, CA, 9410337.76990, -122.420322026-10-082026-11-13
overtureThe Crafty Fox Ale House
e7228846-d468-461a-bf4c-c61bfd009ecc
1700 Mission St, San Francisco, CA, 94103415416660237.76991, -122.420322026-11-062026-11-06
vtinfoCRAFTY FOX ALE HOUSE
134151f71b31087f
1700 MISSION ST, SAN FRANCISCO, CA, 94103415416660237.76983, -122.420402026-11-142026-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 CRAFTY FOX ALE HOUSE THEca-abc CRAFTY FOX ALE HOUSE THE1.00one licence filemergedfile: 00550676 · same_address
ca-abc CRAFTY FOX ALE HOUSE THEdoordash the crafty fox ale house san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ca-abc CRAFTY FOX ALE HOUSE THEoverture The Crafty Fox Ale House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ca-abc CRAFTY FOX ALE HOUSE THEvtinfo CRAFTY FOX ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ca-abc CRAFTY FOX ALE HOUSE THEdoordash the crafty fox ale house san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ca-abc CRAFTY FOX ALE HOUSE THEoverture The Crafty Fox Ale House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ca-abc CRAFTY FOX ALE HOUSE THEvtinfo CRAFTY FOX ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
doordash the crafty fox ale house san franciscooverture The Crafty Fox Ale House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
doordash the crafty fox ale house san franciscovtinfo CRAFTY FOX ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
overture The Crafty Fox Ale Housevtinfo CRAFTY FOX ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DERRY PARTNERS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 7, computed 2026-11-16 17:16.
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,276 within 1 mi · 6,268 within 3 mi
Off / on premise
168 / 820 within 1 mi · 849 / 3,935 within 3 mi
Selling alcohol
811 within 1 mi · 3,879 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (19,046 people per sq mi)
People within 3 mi
538,513 (464,701 adults 21+, 260,614 households) from 167 tract(s), tracts within 3 mi
Income
per capita $105,393 · median household ~$155,092 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 66%
Ethnicity
Hispanic 16% · White 46% · Black 5% · Asian 29%
Adults per alcohol outlet
120
Alcohol spend within 3 mi
$251,884,535 a year ($106,879,813 at home, $144,928,657 away) · $64,919 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-14 20:23insertca-abc 00550676|41|LIC|0 ↔ vtinfo 134151f71b31087fsame address and namemerged15
2026-11-14 20:23insertoverture e7228846-d468-461a-bf4c-c61bfd009ecc ↔ vtinfo 134151f71b31087fsame address and namemerged15
2026-11-14 20:23insertca-abc 00550676|41|APP|0 ↔ vtinfo 134151f71b31087fsame address and namemerged15
2026-11-14 20:23insertdoordash 79012 ↔ vtinfo 134151f71b31087fsame address and namemerged15
2026-11-06 18:13insertdoordash 79012 ↔ overture e7228846-d468-461a-bf4c-c61bfd009eccsame address and namemerged11
2026-11-06 18:13insertca-abc 00550676|41|APP|0 ↔ overture e7228846-d468-461a-bf4c-c61bfd009eccsame address and namemerged11
2026-11-06 18:13insertca-abc 00550676|41|LIC|0 ↔ overture e7228846-d468-461a-bf4c-c61bfd009eccsame address and namemerged11
2026-11-06 15:27insertca-abc 00550676|41|APP|0 ↔ doordash 79012same address and namemerged11
2026-11-06 15:27insertca-abc 00550676|41|LIC|0 ↔ doordash 79012same address and namemerged11
2026-10-09 13:59backfillca-abc 00550676|41|APP|0 ↔ ca-abc 00550676|41|LIC|0one licence filemerged