Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94122 | ca-abc | no other value |
| Pin | 37.76031, -122.50521 map | ubereats | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | CELIAS 2727612 | 4019 JUDAH ST, SAN FRANCISCO, CA, 94122 | 37.76036, -122.50564 | 2026-11-11 | 2026-11-19 | |
| ca-abc | CELIA'S BY THE BEACH legal name: CELIA'S RESTAURANTS CORPORATION 00575375|47|LIC|0 | 4019 JUDAH ST, SAN FRANCISCO, CA, 94122 | 37.76040, -122.50510 | 2026-10-08 | 2026-11-06 | |
| doordash | celias by the beach san francisco 207585 | 4019 Judah Street, San Francisco, CA, 94122 | 37.76033, -122.50513 | 2026-10-08 | 2026-11-22 | |
| overture | Celia's Mexican Restaurant 1e0fae8f-aa75-45c3-800f-6c2feb1c37a4 | 4019 Judah St, San Francisco, CA, 94122 | 4155640662 | 37.76024, -122.50519 | 2026-11-13 | 2026-11-19 |
| overture | Celia's by the Beach 67b0de2b-3116-4f91-a108-80212529e99a | 4019 Judah St, San Francisco, CA, 94122 | 4157598741 | 37.76031, -122.50517 | 2026-11-06 | 2026-11-06 |
| ubereats | Celia's by the Beach QWw7LIXyRJyPjgXr4vhIHg | 4019 Judah St, San Francisco, CA, 94122 | 37.76031, -122.50521 | 2026-10-20 | 2026-11-06 | |
| ubereats | Celia’s by the Beach RpBmrgrbTRmrOIwe3cci5Q | 4019 Judah St, San Francisco, CA, 94122 | 37.76035, -122.50513 | 2026-10-14 | 2026-11-06 | |
| vtinfo | CELIAS c602f0d692c5b67a | 4019 JUDAH ST, SAN FRANCISCO, CA, 94122 | 4155640662 | 37.76024, -122.50520 | 2026-11-12 | 2026-11-19 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev CELIAS | vtinfo CELIAS | 1.00 | same address and name | merged | address 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 BEACH | doordash celias by the beach san francisco | 1.00 | same address and name | merged | address 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 BEACH | overture Celia's by the Beach | 1.00 | same address and name | merged | address 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 BEACH | ubereats Celia's by the Beach | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · name similarity 1.00 |
| ca-abc CELIA'S BY THE BEACH | ubereats Celia’s by the Beach | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · name similarity 1.00 |
| doordash celias by the beach san francisco | overture Celia's by the Beach | 1.00 | same address and name | merged | address 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 francisco | ubereats Celia's by the Beach | 1.00 | same address and name | merged | address 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 francisco | ubereats Celia’s by the Beach | 1.00 | same address and name | merged | address 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 Beach | ubereats Celia's by the Beach | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| overture Celia's by the Beach | ubereats Celia’s by the Beach | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 |
| ubereats Celia's by the Beach | ubereats Celia’s by the Beach | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| ab-inbev CELIAS | doordash celias by the beach san francisco | 0.45 | Claude judge: same | merged 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:
pair 17a2546eff62862fa032 |
| ab-inbev CELIAS | overture Celia's Mexican Restaurant | 0.36 | same address and name | merged | address 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 Restaurant | vtinfo CELIAS | 0.36 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | ab-inbev 2727612 ↔ doordash 207585 | Claude judge: same | merged | 17 |
| 2026-11-13 14:10 | insert | overture 1e0fae8f-aa75-45c3-800f-6c2feb1c37a4 ↔ vtinfo c602f0d692c5b67a | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2727612 ↔ overture 1e0fae8f-aa75-45c3-800f-6c2feb1c37a4 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2727612 ↔ vtinfo c602f0d692c5b67a | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 207585 ↔ ubereats RpBmrgrbTRmrOIwe3cci5Q | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00575375|47|LIC|0 ↔ doordash 207585 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 207585 ↔ ubereats QWw7LIXyRJyPjgXr4vhIHg | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 207585 ↔ overture 67b0de2b-3116-4f91-a108-80212529e99a | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00575375|47|LIC|0 ↔ overture 67b0de2b-3116-4f91-a108-80212529e99a | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture 67b0de2b-3116-4f91-a108-80212529e99a ↔ ubereats RpBmrgrbTRmrOIwe3cci5Q | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture 67b0de2b-3116-4f91-a108-80212529e99a ↔ ubereats QWw7LIXyRJyPjgXr4vhIHg | same address and name | merged | 11 |
| 2026-10-20 21:04 | backfill | ca-abc 00575375|47|LIC|0 ↔ ubereats QWw7LIXyRJyPjgXr4vhIHg | same address and name | merged | |
| 2026-10-20 21:04 | backfill | ubereats QWw7LIXyRJyPjgXr4vhIHg ↔ ubereats RpBmrgrbTRmrOIwe3cci5Q | one store listed twice | merged | |
| 2026-10-14 18:03 | backfill | ca-abc 00575375|47|LIC|0 ↔ ubereats RpBmrgrbTRmrOIwe3cci5Q | same address and name | merged |