Outlets /
The Irishtimes
SAN FRANCISCO, CA 94111 · O5d2530b6672b · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed3 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | The Irishtimes 6 other | a licence name in capitals, cleaned (derived; record_title.py) | ASHBURY TAVERNS LLC ca-abc (legal name) ×3 IRISHTIMES THE ca-abc ×3 Irish Times overturetoast (legal name) ×2 Irish Times 500 Sacramento St toast THE IRISH TIMES vtinfo the irish times san francisco doordash |
| Street | 500 SACRAMENTO ST 1 other | ca-abc | 500 Sacramento Street doordash |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94111 | ca-abc | no other value |
| Pin | 37.79407, -122.40161 map 1 other | toast | 58 m away ca-abc ×3 |
| Phone | 4152175060 | vtinfo | no other value |
| Licences | ca-abc 00509044|47|APP|0 · ca-abc 00509044|47|APP|1 · ca-abc 00509044|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ob18dcbe09d45; O80931f5003fb; O81b397658cce; O67846e103939; O99c6dec763c4; O9855ea25cbe3
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 |
|---|---|---|---|---|---|---|
| ca-abc | IRISHTIMES THE legal name: ASHBURY TAVERNS LLC 00509044|47|APP|0 | 500 SACRAMENTO ST, SAN FRANCISCO, CA, 94111 | 37.79393, -122.40224 | 2026-10-08 | 2026-11-06 | |
| ca-abc | IRISHTIMES THE legal name: ASHBURY TAVERNS LLC 00509044|47|APP|1 | 500 SACRAMENTO ST, SAN FRANCISCO, CA, 94111 | 37.79393, -122.40224 | 2026-10-08 | 2026-11-06 | |
| ca-abc | IRISHTIMES THE legal name: ASHBURY TAVERNS LLC 00509044|47|LIC|0 | 500 SACRAMENTO ST, SAN FRANCISCO, CA, 94111 | 37.79393, -122.40224 | 2026-10-08 | 2026-11-06 | |
| doordash | the irish times san francisco 26151789 | 500 Sacramento Street, San Francisco, CA, 94111 | 37.79384, -122.40162 | 2026-10-08 | 2026-11-06 | |
| overture | Irish Times 6db70e98-e837-4511-bcde-c0d2fa36c6a9 | 500 Sacramento St, San Francisco, CA, 94111 | 4152175060 | 37.79402, -122.40165 | 2026-11-06 | 2026-11-06 |
| toast | Irish Times 500 Sacramento St legal name: Irish Times d276190e-a27f-43f7-b73f-d133615c10b7 | 500 Sacramento St, San Francisco, CA, 94111 | 4152175060 | 37.79407, -122.40161 | 2026-11-06 | 2026-11-15 |
| vtinfo | THE IRISH TIMES d8c8115b092b8f3e | 500 SACRAMENTO ST, SAN FRANCISCO, CA, 94111 | 4152175060 | 37.79407, -122.40161 | 2026-11-12 | 2026-11-14 |
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 |
|---|---|---|---|---|---|
| ca-abc IRISHTIMES THE | ca-abc IRISHTIMES THE | 1.00 | one licence file | merged | file: 00509044 · same_address |
| ca-abc IRISHTIMES THE | ca-abc IRISHTIMES THE | 1.00 | one licence file | merged | file: 00509044 · same_address |
| doordash the irish times san francisco | overture Irish Times | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00 |
| doordash the irish times san francisco | toast Irish Times 500 Sacramento St | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · matched through the licence's legal name: Irish Times · name similarity 1.00 |
| doordash the irish times san francisco | vtinfo THE IRISH TIMES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00 |
| overture Irish Times | toast Irish Times 500 Sacramento St | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · matched through the licence's legal name: Irish Times · name similarity 1.00 · phone: equal |
| overture Irish Times | vtinfo THE IRISH TIMES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal |
| toast Irish Times 500 Sacramento St | vtinfo THE IRISH TIMES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · matched through the licence's legal name: Irish Times · name similarity 1.00 · phone: equal |
| ca-abc IRISHTIMES THE | doordash the irish times san francisco | 0.48 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The names match: 'IRISHTIMES THE' is 'The Irish Times', and DoorDash's slug appends the city. Both records give the same street address and ZIP, and the restaurant licence fits a DoorDash food listing Other Claude answers on this pair:
pair 98891e40c41f1cea1e94 |
| ca-abc IRISHTIMES THE | overture Irish Times | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 53 m apart · name similarity 0.48 |
| ca-abc IRISHTIMES THE | toast Irish Times 500 Sacramento St | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · matched through the licence's legal name: Irish Times · name similarity 0.48 |
| ca-abc IRISHTIMES THE | vtinfo THE IRISH TIMES | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · name similarity 0.48 |
| ca-abc IRISHTIMES THE | doordash the irish times san francisco | 0.48 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The names agree: 'IRISHTIMES THE' is The Irish Times, the DoorDash slug with its city removed. Both sit at 500 Sacramento St, San Francisco 94111, and the restaurant licence fits a DoorDash listing; t Other Claude answers on this pair:
pair 3f655d9cae13ec08fd14 |
| ca-abc IRISHTIMES THE | overture Irish Times | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 53 m apart · name similarity 0.48 |
| ca-abc IRISHTIMES THE | toast Irish Times 500 Sacramento St | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · matched through the licence's legal name: Irish Times · name similarity 0.48 |
| ca-abc IRISHTIMES THE | vtinfo THE IRISH TIMES | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · name similarity 0.48 |
| ca-abc IRISHTIMES THE | doordash the irish times san francisco | 0.48 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The names agree: 'IRISHTIMES THE' is the same as 'the irish times' once the city appended to the DoorDash slug is dropped, and both records give 500 Sacramento St, San Francisco 94111. The licence sho Other Claude answers on this pair:
pair 63b629a34fb06ed6a695 |
| ca-abc IRISHTIMES THE | overture Irish Times | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 53 m apart · name similarity 0.48 |
| ca-abc IRISHTIMES THE | toast Irish Times 500 Sacramento St | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · matched through the licence's legal name: Irish Times · name similarity 0.48 |
| ca-abc IRISHTIMES THE | vtinfo THE IRISH TIMES | 0.48 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 58 m apart · name similarity 0.48 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- ASHBURY TAVERNS LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"bar"
]
]
}Trade area
- Other outlets
- 1,963 within 1 mi · 5,133 within 3 mi
- Off / on premise
- 197 / 1,209 within 1 mi · 652 / 3,211 within 3 mi
- Selling alcohol
- 1,173 within 1 mi · 3,185 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.01 mi
- Setting
- urban (12,853 people per sq mi)
- People within 3 mi
- 363,419 (320,830 adults 21+, 188,136 households) from 124 tract(s), tracts within 3 mi
- Income
- per capita $106,427 · median household ~$146,955 (weighted mean of tract medians)
- Age and education
- median age ~39.4 · bachelor's or higher 65%
- Ethnicity
- Hispanic 15% · White 45% · Black 6% · Asian 29%
- Adults per alcohol outlet
- 101
- Alcohol spend within 3 mi
- $175,061,294 a year ($74,617,365 at home, $100,388,232 away) · $54,947 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-12 14:25 | insert | ca-abc 00509044|47|APP|0 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00509044|47|LIC|0 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00509044|47|APP|1 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00509044|47|APP|0 ↔ toast d276190e-a27f-43f7-b73f-d133615c10b7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00509044|47|LIC|0 ↔ toast d276190e-a27f-43f7-b73f-d133615c10b7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00509044|47|APP|1 ↔ toast d276190e-a27f-43f7-b73f-d133615c10b7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 26151789 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 ↔ toast d276190e-a27f-43f7-b73f-d133615c10b7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 26151789 ↔ toast d276190e-a27f-43f7-b73f-d133615c10b7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | toast d276190e-a27f-43f7-b73f-d133615c10b7 ↔ vtinfo d8c8115b092b8f3e | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00509044|47|APP|0 ↔ overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00509044|47|LIC|0 ↔ overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00509044|47|APP|1 ↔ overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 26151789 ↔ overture 6db70e98-e837-4511-bcde-c0d2fa36c6a9 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00509044|47|APP|0 ↔ doordash 26151789 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00509044|47|LIC|0 ↔ doordash 26151789 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00509044|47|APP|1 ↔ doordash 26151789 | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00509044|47|APP|0 ↔ ca-abc 00509044|47|LIC|0 | one licence file | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00509044|47|APP|0 ↔ ca-abc 00509044|47|APP|1 | one licence file | merged |