Mad Dog in the Fog

SAN FRANCISCO, CA 94117 · O0991b8544424 · 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
Mad Dog in the Fog 1 other
a source's own spelling of the licence name (record_title.py)
THE MAD DOG IN THE FOG ab-inbevvtinfo ×2
Street
1568 HAIGHT ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94117
ca-abcno other value
Pin
37.77003, -122.44810 map 1 other
overture
77 m away ab-inbev
Phone
4156267279
vtinfono other value
Licences
ca-abc 00632208|47|LIC|0 · ca-abc 00632208|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7a0483587786; Oa57e006def87; O8a2b3507dafd; O290ce2f34a81

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-inbevTHE MAD DOG IN THE FOG
4730534
1568 HAIGHT ST, SAN FRANCISCO, CA, 9411737.77006, -122.447232026-11-112026-11-11
ca-abcMAD DOG IN THE FOG
00632208|47|LIC|0
1568 HAIGHT ST, SAN FRANCISCO, CA, 9411737.76992, -122.448062026-10-082026-11-04
ca-abcMAD DOG IN THE FOG
00632208|58|LIC|0
1568 HAIGHT ST, SAN FRANCISCO, CA, 9411737.76992, -122.448062026-10-082026-11-04
overtureMad Dog in the Fog
6f1beed1-0a35-4569-a2aa-a14027c60518
1568 Haight St, San Francisco, CA, 94117415626727937.77003, -122.448102026-11-062026-11-06
vtinfoTHE MAD DOG IN THE FOG
c12b4feed8cb3cd8
1568 HAIGHT ST, SAN FRANCISCO, CA, 94117415626727937.77001, -122.448092026-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
ab-inbev THE MAD DOG IN THE FOGca-abc MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ab-inbev THE MAD DOG IN THE FOGca-abc MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ab-inbev THE MAD DOG IN THE FOGoverture Mad Dog in the Fog1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
ab-inbev THE MAD DOG IN THE FOGvtinfo THE MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 76 m apart · name similarity 1.00
ca-abc MAD DOG IN THE FOGca-abc MAD DOG IN THE FOG1.00one licence filemergedfile: 00632208 · same_address
ca-abc MAD DOG IN THE FOGoverture Mad Dog in the Fog1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ca-abc MAD DOG IN THE FOGvtinfo THE MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
ca-abc MAD DOG IN THE FOGoverture Mad Dog in the Fog1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ca-abc MAD DOG IN THE FOGvtinfo THE MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
overture Mad Dog in the Fogvtinfo THE MAD DOG IN THE FOG1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 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
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:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
529 within 1 mi · 5,724 within 3 mi
Off / on premise
106 / 336 within 1 mi · 822 / 3,656 within 3 mi
Selling alcohol
379 within 1 mi · 3,611 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (20,104 people per sq mi)
People within 3 mi
568,438 (487,253 adults 21+, 267,632 households) from 168 tract(s), tracts within 3 mi
Income
per capita $102,223 · median household ~$153,694 (weighted mean of tract medians)
Age and education
median age ~41.0 · bachelor's or higher 66%
Ethnicity
Hispanic 15% · White 46% · Black 4% · Asian 29%
Adults per alcohol outlet
135
Alcohol spend within 3 mi
$258,886,595 a year ($109,898,386 at home, $148,909,472 away) · $71,674 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:25insertca-abc 00632208|58|LIC|0 ↔ vtinfo c12b4feed8cb3cd8same address and namemerged12
2026-11-12 14:25insertoverture 6f1beed1-0a35-4569-a2aa-a14027c60518 ↔ vtinfo c12b4feed8cb3cd8same address and namemerged12
2026-11-12 14:25insertca-abc 00632208|47|LIC|0 ↔ vtinfo c12b4feed8cb3cd8same address and namemerged12
2026-11-12 14:25insertab-inbev 4730534 ↔ vtinfo c12b4feed8cb3cd8same address and namemerged12
2026-11-11 12:56insertab-inbev 4730534 ↔ overture 6f1beed1-0a35-4569-a2aa-a14027c60518same address and namemerged12
2026-11-11 12:56insertab-inbev 4730534 ↔ ca-abc 00632208|58|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4730534 ↔ ca-abc 00632208|47|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00632208|58|LIC|0 ↔ overture 6f1beed1-0a35-4569-a2aa-a14027c60518same address and namemerged11
2026-11-06 18:13insertca-abc 00632208|47|LIC|0 ↔ overture 6f1beed1-0a35-4569-a2aa-a14027c60518same address and namemerged11
2026-10-09 13:59backfillca-abc 00632208|47|LIC|0 ↔ ca-abc 00632208|58|LIC|0one licence filemerged