JOHNS GRILL

SAN FRANCISCO, CA 94102 · O02a3e2ac00ef · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed3 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
JOHNS GRILL 3 other
the most common name a source states
John's Grill overture
john's grill san francisco doordash
Johns Grill 63 Ellis St toast
Street
63 ELLIS ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94102
ca-abcno other value
Pin
37.78547, -122.40712 map 1 other
toast
57 m away ca-abc ×3
Phone
4159860069
vtinfono other value
Licences
ca-abc 00528020|47|LIC|0 · ca-abc 00528020|58|LIC|0 · ca-abc 00528020|77|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O787c3ffba91f; Off0a76380c02; O766ea1c416ce; O9fa18022d3c6; O9889636c3473; O839de9f5fb6d; O602b3e174ca4

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-inbevJOHNS GRILL
1884938
63 ELLIS ST, SAN FRANCISCO, CA, 9410237.78550, -122.407192026-11-132026-11-13
ca-abcJOHNS GRILL
00528020|47|LIC|0
63 ELLIS ST, SAN FRANCISCO, CA, 9410237.78545, -122.407772026-10-082026-11-13
ca-abcJOHNS GRILL
00528020|58|LIC|0
63 ELLIS ST, SAN FRANCISCO, CA, 9410237.78545, -122.407772026-10-082026-11-13
ca-abcJOHNS GRILL
00528020|77|LIC|0
63 ELLIS ST, SAN FRANCISCO, CA, 9410237.78545, -122.407772026-10-082026-11-13
doordashjohn's grill san francisco
44600731
63 Ellis St, San Francisco, CA, 9410237.78538, -122.407182026-10-082026-11-13
overtureJohn's Grill
b1098016-e443-47fc-8d6b-090dc3b0d67b
63 Ellis St, San Francisco, CA, 94102415986006937.78546, -122.407232026-11-062026-11-13
toastJohns Grill 63 Ellis St
legal name: Johns Grill
7cbf481c-e0ba-4f78-8b62-7c676f1223c5
63 Ellis St, San Francisco, CA, 94102415986006937.78547, -122.407122026-11-062026-11-13
vtinfoJOHNS GRILL
d8d1104a578c5382
63 ELLIS ST, SAN FRANCISCO, CA, 94102415986006937.78540, -122.407322026-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 JOHNS GRILLca-abc JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · name similarity 1.00
ab-inbev JOHNS GRILLca-abc JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · name similarity 1.00
ab-inbev JOHNS GRILLca-abc JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · name similarity 1.00
ab-inbev JOHNS GRILLdoordash john's grill san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ab-inbev JOHNS GRILLoverture John's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ab-inbev JOHNS GRILLtoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00
ab-inbev JOHNS GRILLvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
ca-abc JOHNS GRILLca-abc JOHNS GRILL1.00one licence filemergedfile: 00528020 · same_address
ca-abc JOHNS GRILLca-abc JOHNS GRILL1.00one licence filemergedfile: 00528020 · same_address
ca-abc JOHNS GRILLdoordash john's grill san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ca-abc JOHNS GRILLoverture John's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc JOHNS GRILLtoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00
ca-abc JOHNS GRILLvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 40 m apart · name similarity 1.00
ca-abc JOHNS GRILLdoordash john's grill san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ca-abc JOHNS GRILLoverture John's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc JOHNS GRILLtoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00
ca-abc JOHNS GRILLvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 40 m apart · name similarity 1.00
ca-abc JOHNS GRILLdoordash john's grill san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ca-abc JOHNS GRILLoverture John's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc JOHNS GRILLtoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00
ca-abc JOHNS GRILLvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 40 m apart · name similarity 1.00
doordash john's grill san franciscooverture John's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
doordash john's grill san franciscotoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00
doordash john's grill san franciscovtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
overture John's Grilltoast Johns Grill 63 Ellis St1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · matched through the licence's legal name: Johns Grill · name similarity 1.00 · phone: equal
overture John's Grillvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00 · phone: equal
toast Johns Grill 63 Ellis Stvtinfo JOHNS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · matched through the licence's legal name: Johns Grill · 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); CA 77
Rule version 9, computed 2026-11-17 18:20.
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
2,627 within 1 mi · 5,614 within 3 mi
Off / on premise
253 / 1,638 within 1 mi · 746 / 3,508 within 3 mi
Selling alcohol
1,453 within 1 mi · 3,506 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (14,839 people per sq mi)
People within 3 mi
419,558 (368,036 adults 21+, 213,677 households) from 140 tract(s), tracts within 3 mi
Income
per capita $108,757 · median household ~$151,521 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 66%
Ethnicity
Hispanic 16% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
105
Alcohol spend within 3 mi
$202,321,721 a year ($86,028,295 at home, $116,230,861 away) · $57,691 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-13 17:47insertab-inbev 1884938 ↔ vtinfo d8d1104a578c5382same address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ ca-abc 00528020|58|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ ca-abc 00528020|47|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ overture b1098016-e443-47fc-8d6b-090dc3b0d67bsame address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ ca-abc 00528020|77|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged15
2026-11-13 17:47insertab-inbev 1884938 ↔ doordash 44600731same address and namemerged15
2026-11-12 14:25insertca-abc 00528020|58|LIC|0 ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|47|LIC|0 ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25insertoverture b1098016-e443-47fc-8d6b-090dc3b0d67b ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|77|LIC|0 ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25inserttoast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5 ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|58|LIC|0 ↔ doordash 44600731same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|47|LIC|0 ↔ doordash 44600731same address and namemerged12
2026-11-12 14:25insertdoordash 44600731 ↔ overture b1098016-e443-47fc-8d6b-090dc3b0d67bsame address and namemerged12
2026-11-12 14:25insertca-abc 00528020|77|LIC|0 ↔ doordash 44600731same address and namemerged12
2026-11-12 14:25insertdoordash 44600731 ↔ vtinfo d8d1104a578c5382same address and namemerged12
2026-11-12 14:25insertdoordash 44600731 ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|58|LIC|0 ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|47|LIC|0 ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged12
2026-11-12 14:25insertoverture b1098016-e443-47fc-8d6b-090dc3b0d67b ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged12
2026-11-12 14:25insertca-abc 00528020|77|LIC|0 ↔ toast 7cbf481c-e0ba-4f78-8b62-7c676f1223c5same address and namemerged12
2026-11-06 18:13insertca-abc 00528020|58|LIC|0 ↔ overture b1098016-e443-47fc-8d6b-090dc3b0d67bsame address and namemerged11
2026-11-06 18:13insertca-abc 00528020|77|LIC|0 ↔ overture b1098016-e443-47fc-8d6b-090dc3b0d67bsame address and namemerged11
2026-11-06 18:13insertca-abc 00528020|47|LIC|0 ↔ overture b1098016-e443-47fc-8d6b-090dc3b0d67bsame address and namemerged11
2026-10-09 13:59backfillca-abc 00528020|47|LIC|0 ↔ ca-abc 00528020|77|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00528020|47|LIC|0 ↔ ca-abc 00528020|58|LIC|0one licence filemerged