Celia's

San Francisco, CA 94122 · O05c0c95819d7 · first seen 2026-10-08
6 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
Celia's 6 other
a licence name in capitals, cleaned (derived; record_title.py)
CELIA'S BY THE BEACH ca-abcovertureubereats ×3
CELIAS ab-inbevvtinfo ×2
Celia's Mexican Restaurant overture
CELIA'S RESTAURANTS CORPORATION ca-abc (legal name)
celias by the beach san francisco doordash
Celia’s by the Beach ubereats
Street
4019 JUDAH ST 1 other
ca-abc
4019 Judah Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94122
ca-abcno other value
Pin
37.76031, -122.50521 map
ubereatsno other value
Phone
4155640662 1 other
vtinfo
4157598741 overture
Licences
ca-abc 00575375|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obb0993ccadad; O6c2bd79226ef; O380165c33941; O7cee2bddb619; Of85c28aa7970; Oeacbb25dde16; Obd4807d40fd3

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-inbevCELIAS
2727612
4019 JUDAH ST, SAN FRANCISCO, CA, 9412237.76036, -122.505642026-11-112026-11-19
ca-abcCELIA'S BY THE BEACH
legal name: CELIA'S RESTAURANTS CORPORATION
00575375|47|LIC|0
4019 JUDAH ST, SAN FRANCISCO, CA, 9412237.76040, -122.505102026-10-082026-11-06
doordashcelias by the beach san francisco
207585
4019 Judah Street, San Francisco, CA, 9412237.76033, -122.505132026-10-082026-11-22
overtureCelia's Mexican Restaurant
1e0fae8f-aa75-45c3-800f-6c2feb1c37a4
4019 Judah St, San Francisco, CA, 94122415564066237.76024, -122.505192026-11-132026-11-19
overtureCelia's by the Beach
67b0de2b-3116-4f91-a108-80212529e99a
4019 Judah St, San Francisco, CA, 94122415759874137.76031, -122.505172026-11-062026-11-06
ubereatsCelia's by the Beach
QWw7LIXyRJyPjgXr4vhIHg
4019 Judah St, San Francisco, CA, 9412237.76031, -122.505212026-10-202026-11-06
ubereatsCelia’s by the Beach
RpBmrgrbTRmrOIwe3cci5Q
4019 Judah St, San Francisco, CA, 9412237.76035, -122.505132026-10-142026-11-06
vtinfoCELIAS
c602f0d692c5b67a
4019 JUDAH ST, SAN FRANCISCO, CA, 94122415564066237.76024, -122.505202026-11-122026-11-19

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 CELIASvtinfo CELIAS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
ca-abc CELIA'S BY THE BEACHdoordash celias by the beach san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc CELIA'S BY THE BEACHoverture Celia's by the Beach1.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 CELIA'S BY THE BEACHubereats Celia's by the Beach1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc CELIA'S BY THE BEACHubereats Celia’s by the Beach1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
doordash celias by the beach san franciscooverture Celia's by the Beach1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash celias by the beach san franciscoubereats Celia's by the Beach1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
doordash celias by the beach san franciscoubereats Celia’s by the Beach1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
overture Celia's by the Beachubereats Celia's by the Beach1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
overture Celia's by the Beachubereats Celia’s by the Beach1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ubereats Celia's by the Beachubereats Celia’s by the Beach1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev CELIASdoordash celias by the beach san francisco0.45Claude judge: samemerged department listings of one store
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Celia's same address, matching name
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at the same street address (4019 Judah St, San Francisco 94122) with coordinates about 45 m apart, no other business is listed there, and 'CELIAS' is the short form of the DoorDash listing's 'Celia's by the Beach'.
pair 17a2546eff62862fa032
ab-inbev CELIASoverture Celia's Mexican Restaurant0.36same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.85 · same street + ZIP · pins 42 m apart · name similarity 0.36
overture Celia's Mexican Restaurantvtinfo CELIAS0.36same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.85 · same street + city + state · pins 1 m apart · name similarity 0.36 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CELIA'S RESTAURANTS CORPORATION — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "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
76 within 1 mi · 1,033 within 3 mi
Off / on premise
20 / 45 within 1 mi · 170 / 716 within 3 mi
Selling alcohol
58 within 1 mi · 652 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (7,057 people per sq mi)
People within 3 mi
199,546 (162,852 adults 21+, 79,327 households) from 50 tract(s), tracts within 3 mi
Income
per capita $87,031 · median household ~$155,617 (weighted mean of tract medians)
Age and education
median age ~43.6 · bachelor's or higher 64%
Ethnicity
Hispanic 10% · White 39% · Black 2% · Asian 43%
Adults per alcohol outlet
249
Alcohol spend within 3 mi
$79,851,211 a year ($33,853,955 at home, $45,972,970 away) · $122,284 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-19 20:37insertab-inbev 2727612 ↔ doordash 207585Claude judge: samemerged17
2026-11-13 14:10insertoverture 1e0fae8f-aa75-45c3-800f-6c2feb1c37a4 ↔ vtinfo c602f0d692c5b67asame address and namemerged15
2026-11-13 14:10insertab-inbev 2727612 ↔ overture 1e0fae8f-aa75-45c3-800f-6c2feb1c37a4same address and namemerged15
2026-11-12 14:25insertab-inbev 2727612 ↔ vtinfo c602f0d692c5b67asame address and namemerged12
2026-11-12 14:25insertdoordash 207585 ↔ ubereats RpBmrgrbTRmrOIwe3cci5Qsame address and namemerged12
2026-11-12 14:25insertca-abc 00575375|47|LIC|0 ↔ doordash 207585same address and namemerged12
2026-11-12 14:25insertdoordash 207585 ↔ ubereats QWw7LIXyRJyPjgXr4vhIHgsame address and namemerged12
2026-11-12 14:25insertdoordash 207585 ↔ overture 67b0de2b-3116-4f91-a108-80212529e99asame address and namemerged12
2026-11-06 18:13insertca-abc 00575375|47|LIC|0 ↔ overture 67b0de2b-3116-4f91-a108-80212529e99asame address and namemerged11
2026-11-06 18:13insertoverture 67b0de2b-3116-4f91-a108-80212529e99a ↔ ubereats RpBmrgrbTRmrOIwe3cci5Qsame address and namemerged11
2026-11-06 18:13insertoverture 67b0de2b-3116-4f91-a108-80212529e99a ↔ ubereats QWw7LIXyRJyPjgXr4vhIHgsame address and namemerged11
2026-10-20 21:04backfillca-abc 00575375|47|LIC|0 ↔ ubereats QWw7LIXyRJyPjgXr4vhIHgsame address and namemerged
2026-10-20 21:04backfillubereats QWw7LIXyRJyPjgXr4vhIHg ↔ ubereats RpBmrgrbTRmrOIwe3cci5Qone store listed twicemerged
2026-10-14 18:03backfillca-abc 00575375|47|LIC|0 ↔ ubereats RpBmrgrbTRmrOIwe3cci5Qsame address and namemerged