Happy King Pizza

San Francisco, CA 94107 · O102c7ab338aa · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: licensed1 licence

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
Happy King Pizza 1 other
a licence name in capitals, cleaned (derived; record_title.py)
happy king pizza san francisco doordash
Street
227 KING ST 1 other
ca-abc
227 King Street ubereats ×2
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94107
ca-abcno other value
Pin
37.77714, -122.39251 map
ubereatsno other value
Phone
5109267803
overtureno other value
Licences
ca-abc 00675732|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdefc428d110; Oe670db848da6; O2c9b4343475e; O3b6d9811ce4d

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-abcHAPPY KING PIZZA
00675732|41|LIC|0
227 KING ST, SAN FRANCISCO, CA, 9410737.77748, -122.392262026-10-082026-11-06
doordashhappy king pizza san francisco
29270568
227 King St, San Francisco, CA, 9410737.77703, -122.392712026-10-082026-11-06
overtureHappy king pizza
9dd2622a-fe7e-46c9-8a07-51dd8bb84f34
227 King St, San Francisco, CA, 94107510926780337.77705, -122.392622026-11-062026-11-06
ubereatsHAPPY KING PIZZA
_1voWa9IQ6i59Q2PKQ4WDQ
227 King Street, San Francisco, CA, 9410737.77714, -122.392512026-10-182026-11-06
ubereatsHAPPY KING PIZZA
ZBgwTmUzTDOERRYtq5hl1w
227 King Street, San Francisco, CA, 9410737.77705, -122.392702026-11-092026-11-09

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 HAPPY KING PIZZAdoordash happy king pizza san francisco1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc HAPPY KING PIZZAoverture Happy king pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ca-abc HAPPY KING PIZZAubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc HAPPY KING PIZZAubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00
doordash happy king pizza san franciscooverture Happy king pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
doordash happy king pizza san franciscoubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
doordash happy king pizza san franciscoubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
overture Happy king pizzaubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
overture Happy king pizzaubereats HAPPY KING PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ubereats HAPPY KING PIZZAubereats HAPPY KING PIZZA1.00one store listed twicemergedsame street + ZIP · name: identical

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 — CA 41
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
906 within 1 mi · 5,519 within 3 mi
Off / on premise
90 / 584 within 1 mi · 712 / 3,432 within 3 mi
Selling alcohol
492 within 1 mi · 3,386 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.03 mi
Setting
urban (13,748 people per sq mi)
People within 3 mi
388,707 (341,971 adults 21+, 197,246 households) from 130 tract(s), tracts within 3 mi
Income
per capita $104,306 · median household ~$147,137 (weighted mean of tract medians)
Age and education
median age ~40.0 · bachelor's or higher 64%
Ethnicity
Hispanic 17% · White 44% · Black 6% · Asian 29%
Adults per alcohol outlet
101
Alcohol spend within 3 mi
$183,644,858 a year ($78,272,142 at home, $105,314,622 away) · $54,221 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-09 01:04insertdoordash 29270568 ↔ ubereats ZBgwTmUzTDOERRYtq5hl1wsame address and namemerged11
2026-11-09 01:04insertca-abc 00675732|41|LIC|0 ↔ ubereats ZBgwTmUzTDOERRYtq5hl1wsame address and namemerged11
2026-11-09 01:04insertoverture 9dd2622a-fe7e-46c9-8a07-51dd8bb84f34 ↔ ubereats ZBgwTmUzTDOERRYtq5hl1wsame address and namemerged11
2026-11-09 01:04insertubereats ZBgwTmUzTDOERRYtq5hl1w ↔ ubereats _1voWa9IQ6i59Q2PKQ4WDQone store listed twicemerged11
2026-11-06 18:13insertdoordash 29270568 ↔ overture 9dd2622a-fe7e-46c9-8a07-51dd8bb84f34same address and namemerged11
2026-11-06 18:13insertoverture 9dd2622a-fe7e-46c9-8a07-51dd8bb84f34 ↔ ubereats _1voWa9IQ6i59Q2PKQ4WDQsame address and namemerged11
2026-11-06 18:13insertca-abc 00675732|41|LIC|0 ↔ overture 9dd2622a-fe7e-46c9-8a07-51dd8bb84f34same address and namemerged11
2026-10-27 01:03backfilldoordash 29270568 ↔ ubereats _1voWa9IQ6i59Q2PKQ4WDQsame address and namemerged
2026-10-27 01:03backfillca-abc 00675732|41|LIC|0 ↔ doordash 29270568same address and namemerged
2026-10-18 21:02backfillca-abc 00675732|41|LIC|0 ↔ ubereats _1voWa9IQ6i59Q2PKQ4WDQsame address and namemerged