Friends Cafe

TUSTIN, CA 92780 · O4038780777ed · 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
Friends Cafe 2 other
a source's own spelling of the licence name (record_title.py)
URBAN GRILL LLC ca-abc (legal name) ×2
friends cafe tustin doordash
Street
17391 17TH ST 1 other
ca-abc
17391 17th Street doordash
City
TUSTIN
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92780
ca-abcno other value
Pin
33.76022, -117.82800 map
doordashno other value
Phone
7146174661
overtureno other value
Licences
ca-abc 00639767|41|LIC|0 · ca-abc 00639767|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdbd812f3933; Od557446d7791; O6f07714d6f6d; O721e06fdec7e

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-inbevFRIENDS CAFE
4045069
17391 17TH ST, TUSTIN, CA, 9278033.76063, -117.828112026-11-112026-11-11
ca-abcFRIENDS CAFE
legal name: URBAN GRILL LLC
00639767|41|LIC|0
17391 17TH ST, TUSTIN, CA, 9278033.75997, -117.828072026-10-082026-11-06
ca-abcFRIENDS CAFE
legal name: URBAN GRILL LLC
00639767|58|LIC|0
17391 17TH ST, TUSTIN, CA, 9278033.75997, -117.828072026-10-082026-11-06
doordashfriends cafe tustin
24406037
17391 17th Street, Tustin, CA, 9278033.76022, -117.828002026-10-082026-11-13
overtureFriends Cafe
4eb5df61-8dc0-4a16-bc10-538df7ee2dcd
17391 17th St, Tustin, CA, 92780714617466133.76024, -117.828022026-11-062026-11-06

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 FRIENDS CAFEca-abc FRIENDS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 73 m apart · name similarity 1.00
ab-inbev FRIENDS CAFEca-abc FRIENDS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 73 m apart · name similarity 1.00
ab-inbev FRIENDS CAFEdoordash friends cafe tustin1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 46 m apart · name similarity 1.00
ab-inbev FRIENDS CAFEoverture Friends Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ca-abc FRIENDS CAFEca-abc FRIENDS CAFE1.00one licence filemergedfile: 00639767 · same_address
ca-abc FRIENDS CAFEdoordash friends cafe tustin1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
ca-abc FRIENDS CAFEoverture Friends Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
ca-abc FRIENDS CAFEdoordash friends cafe tustin1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
ca-abc FRIENDS CAFEoverture Friends Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
doordash friends cafe tustinoverture Friends Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
URBAN GRILL LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41; CA 58 (add-on: follows the base licence)
Rule version 11, computed 2026-11-19 21:41.
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
162 within 1 mi · 1,197 within 3 mi
Off / on premise
24 / 114 within 1 mi · 245 / 775 within 3 mi
Selling alcohol
67 within 1 mi · 639 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.04 mi
Setting
urban (8,798 people per sq mi)
People within 3 mi
248,762 (182,254 adults 21+, 79,334 households) from 46 tract(s), tracts within 3 mi
Income
per capita $44,161 · median household ~$109,090 (weighted mean of tract medians)
Age and education
median age ~37.3 · bachelor's or higher 33%
Ethnicity
Hispanic 57% · White 34% · Black 1% · Asian 12%
Adults per alcohol outlet
285
Alcohol spend within 3 mi
$63,693,605 a year ($28,236,424 at home, $35,432,266 away) · $99,521 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:25insertab-inbev 4045069 ↔ doordash 24406037same address and namemerged12
2026-11-12 14:25insertca-abc 00639767|41|LIC|0 ↔ doordash 24406037same address and namemerged12
2026-11-12 14:25insertca-abc 00639767|58|LIC|0 ↔ doordash 24406037same address and namemerged12
2026-11-12 14:25insertdoordash 24406037 ↔ overture 4eb5df61-8dc0-4a16-bc10-538df7ee2dcdsame address and namemerged12
2026-11-11 12:56insertab-inbev 4045069 ↔ ca-abc 00639767|58|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4045069 ↔ ca-abc 00639767|41|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4045069 ↔ overture 4eb5df61-8dc0-4a16-bc10-538df7ee2dcdsame address and namemerged12
2026-11-06 18:13insertca-abc 00639767|58|LIC|0 ↔ overture 4eb5df61-8dc0-4a16-bc10-538df7ee2dcdsame address and namemerged11
2026-11-06 18:13insertca-abc 00639767|41|LIC|0 ↔ overture 4eb5df61-8dc0-4a16-bc10-538df7ee2dcdsame address and namemerged11
2026-10-09 13:59backfillca-abc 00639767|41|LIC|0 ↔ ca-abc 00639767|58|LIC|0one licence filemerged