Little Original Joe's

SAN FRANCISCO, CA 94127 · O043cd43e13f2 · 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
Little Original Joe's 3 other
the most common name a source states
little original joe's san francisco doordash
LITTLE ORIGINAL JOES vtinfo
TRE ROSSO LP ca-abc (legal name)
Street
393 W PORTAL AVE 2 other
ca-abc
393 West Portal Ave overture
393 West Portal Avenue doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94127
ca-abcno other value
Pin
37.73659, -122.47036 map
doordashno other value
Phone
4157591155 1 other
vtinfo
4157121895 overture
Licences
ca-abc 00613086|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of5ca2703babe; O0be852802392; O515357816570

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-abcLITTLE ORIGINAL JOE'S
legal name: TRE ROSSO LP
00613086|41|LIC|0
393 W PORTAL AVE, SAN FRANCISCO, CA, 9412737.73666, -122.470362026-10-082026-11-05
doordashlittle original joe's san francisco
1438706
393 West Portal Avenue, San Francisco, CA, 9412737.73659, -122.470362026-10-082026-11-06
overtureLittle Original Joe's
516c30c3-b16c-413b-b85d-7b4f07c95a2e
393 West Portal Ave, San Francisco, CA, 94127415712189537.73658, -122.470292026-11-062026-11-06
vtinfoLITTLE ORIGINAL JOES
2ce1930c2a48f707
393 W PORTAL AVE, SAN FRANCISCO, CA, 94127415759115537.73656, -122.470252026-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
ca-abc LITTLE ORIGINAL JOE'Sdoordash little original joe's san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
ca-abc LITTLE ORIGINAL JOE'Soverture Little Original Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ca-abc LITTLE ORIGINAL JOE'Svtinfo LITTLE ORIGINAL JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
doordash little original joe's san franciscooverture Little Original Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
doordash little original joe's san franciscovtinfo LITTLE ORIGINAL JOES1.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 Little Original Joe'svtinfo LITTLE ORIGINAL JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TRE ROSSO LP — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 10, computed 2026-11-18 20:34.
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
203 within 1 mi · 1,688 within 3 mi
Off / on premise
36 / 134 within 1 mi · 312 / 1,082 within 3 mi
Selling alcohol
111 within 1 mi · 1,068 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (14,319 people per sq mi)
People within 3 mi
404,849 (333,312 adults 21+, 156,239 households) from 98 tract(s), tracts within 3 mi
Income
per capita $85,773 · median household ~$162,823 (weighted mean of tract medians)
Age and education
median age ~42.3 · bachelor's or higher 60%
Ethnicity
Hispanic 16% · White 37% · Black 3% · Asian 39%
Adults per alcohol outlet
312
Alcohol spend within 3 mi
$158,905,922 a year ($67,216,527 at home, $91,642,246 away) · $148,649 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:25insertdoordash 1438706 ↔ vtinfo 2ce1930c2a48f707same address and namemerged12
2026-11-12 14:25insertoverture 516c30c3-b16c-413b-b85d-7b4f07c95a2e ↔ vtinfo 2ce1930c2a48f707same address and namemerged12
2026-11-12 14:25insertca-abc 00613086|41|LIC|0 ↔ vtinfo 2ce1930c2a48f707same address and namemerged12
2026-11-06 18:13insertca-abc 00613086|41|LIC|0 ↔ overture 516c30c3-b16c-413b-b85d-7b4f07c95a2esame address and namemerged11
2026-11-06 18:13insertdoordash 1438706 ↔ overture 516c30c3-b16c-413b-b85d-7b4f07c95a2esame address and namemerged11
2026-11-05 19:24backfillca-abc 00613086|41|LIC|0 ↔ doordash 1438706same address and namemerged