Roxie Food Center

SAN FRANCISCO, CA 94112 · O0854abe381d2 · first seen 2026-10-08
5 sourcesoff premisealcohol: 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
Roxie Food Center 2 other
a source's own spelling of the licence name (record_title.py)
MICK & MIKE INC ca-abc (legal name)
roxie food center san francisco doordash
Street
1901 SAN JOSE AVE 1 other
ca-abc
1901 San Jose Avenue doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94112
ca-abcno other value
Pin
37.72678, -122.44140 map 1 other
doordash
70 m away ab-inbev
Phone
4155872345
vtinfono other value
Licences
ca-abc 00619292|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of8fc4324f29b; Oa47d47ba8e8d; O7a87f09961fa; O40f7769bd48c

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-inbevROXIE FOOD CENTER
2017030
1901 SAN JOSE AVE, SAN FRANCISCO, CA, 9411237.72629, -122.441892026-11-112026-11-11
ca-abcROXIE FOOD CENTER
legal name: MICK & MIKE INC
00619292|21|LIC|0
1901 SAN JOSE AVE, SAN FRANCISCO, CA, 9411237.72686, -122.441412026-10-082026-11-11
doordashroxie food center san francisco
1454588
1901 San Jose Avenue, San Francisco, CA, 9411237.72678, -122.441402026-10-082026-11-11
overtureRoxie Food Center
62f22a49-0937-4648-8a8b-e2d20c2882ac
1901 San Jose Ave, San Francisco, CA, 94112415587234537.72676, -122.441382026-11-062026-11-11
vtinfoROXIE FOOD CENTER
0674891ec79e117e
1901 SAN JOSE AVE, SAN FRANCISCO, CA, 94112415587234537.72675, -122.441392026-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 ROXIE FOOD CENTERca-abc ROXIE FOOD CENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 76 m apart · name similarity 1.00
ab-inbev ROXIE FOOD CENTERdoordash roxie food center san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 70 m apart · name similarity 1.00
ab-inbev ROXIE FOOD CENTERoverture Roxie Food Center1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 68 m apart · name similarity 1.00
ab-inbev ROXIE FOOD CENTERvtinfo ROXIE FOOD CENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 67 m apart · name similarity 1.00
ca-abc ROXIE FOOD CENTERdoordash roxie food center san francisco1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc ROXIE FOOD CENTERoverture Roxie Food Center1.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 ROXIE FOOD CENTERvtinfo ROXIE FOOD CENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
doordash roxie food center san franciscooverture Roxie Food Center1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
doordash roxie food center san franciscovtinfo ROXIE FOOD CENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
overture Roxie Food Centervtinfo ROXIE FOOD CENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise — ca-licence conflicting evidence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MICK & MIKE INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
208 within 1 mi · 2,396 within 3 mi
Off / on premise
43 / 140 within 1 mi · 425 / 1,482 within 3 mi
Selling alcohol
121 within 1 mi · 1,471 within 3 mi
Nearest
same channel 0.16 mi · licensed 0.16 mi
Setting
urban (14,800 people per sq mi)
People within 3 mi
418,470 (341,221 adults 21+, 154,459 households) from 107 tract(s), tracts within 3 mi
Income
per capita $80,366 · median household ~$157,356 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 54%
Ethnicity
Hispanic 21% · White 33% · Black 4% · Asian 39%
Adults per alcohol outlet
232
Alcohol spend within 3 mi
$153,509,150 a year ($65,153,737 at home, $88,308,792 away) · $104,286 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 00619292|21|LIC|0 ↔ vtinfo 0674891ec79e117esame address and namemerged12
2026-11-12 14:25insertoverture 62f22a49-0937-4648-8a8b-e2d20c2882ac ↔ vtinfo 0674891ec79e117esame address and namemerged12
2026-11-12 14:25insertab-inbev 2017030 ↔ vtinfo 0674891ec79e117esame address and namemerged12
2026-11-12 14:25insertdoordash 1454588 ↔ vtinfo 0674891ec79e117esame address and namemerged12
2026-11-11 12:56insertab-inbev 2017030 ↔ ca-abc 00619292|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2017030 ↔ doordash 1454588same address and namemerged12
2026-11-11 12:56insertab-inbev 2017030 ↔ overture 62f22a49-0937-4648-8a8b-e2d20c2882acsame address and namemerged12
2026-11-06 18:13insertca-abc 00619292|21|LIC|0 ↔ overture 62f22a49-0937-4648-8a8b-e2d20c2882acsame address and namemerged11
2026-11-06 18:13insertdoordash 1454588 ↔ overture 62f22a49-0937-4648-8a8b-e2d20c2882acsame address and namemerged11
2026-10-16 20:04backfillca-abc 00619292|21|LIC|0 ↔ doordash 1454588same address and namemerged