Outlets /
BISHOPS LIQUOR
FRESNO, CA 93726 · O23b1e1ea321a · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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 | BISHOPS LIQUOR 4 other | the most common name a source states | BISHOP LIQUOR ca-abc Bishop's Liquor overture bishop's liquor fresno doordash SANGHERA BUTA SINGH ca-abc (legal name) |
| Street | 4182 N 1ST 3 other | ca-abc | 4182 N 1ST ST STE 101 ab-inbevvtinfo ×2 4182 N 1st St doordash 4182 N First St overture |
| City | FRESNO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 93726 | ca-abc | no other value |
| Pin | 36.79369, -119.77099 map 2 other | doordash | 111 m away ca-abc 101 m away vtinfo |
| Phone | 5592291525 | vtinfo | no other value |
| Licences | ca-abc 00569104|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oce0f6ebc12e3; O6d6256ca7ad7; Odc5d51714150; Oc854dcb0773f
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 | BISHOPS LIQUOR 2142456 | 4182 N 1ST ST STE 101, FRESNO, CA, 93726 | 36.79356, -119.77098 | 2026-11-11 | 2026-11-11 | |
| ca-abc | BISHOP LIQUOR legal name: SANGHERA BUTA SINGH 00569104|21|LIC|0 | 4182 N 1ST, FRESNO, CA, 93726 | 36.79376, -119.77223 | 2026-10-08 | 2026-11-05 | |
| doordash | bishop's liquor fresno 52369451 | 4182 N 1st St, Fresno, CA, 93726 | 36.79369, -119.77099 | 2026-10-10 | 2026-11-03 | |
| overture | Bishop's Liquor f9b04fc6-f741-4ef2-b6f6-f83d74c56d11 | 4182 N First St, Fresno, CA, 93726 | 5592291525 | 36.79378, -119.77119 | 2026-11-06 | 2026-11-06 |
| vtinfo | BISHOPS LIQUOR 72cf10e4769b1fda | 4182 N 1ST ST STE 101, FRESNO, CA, 93726 | 5592291525 | 36.79383, -119.77211 | 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 |
|---|---|---|---|---|---|
| ab-inbev BISHOPS LIQUOR | doordash bishop's liquor fresno | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ab-inbev BISHOPS LIQUOR | overture Bishop's Liquor | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 |
| ab-inbev BISHOPS LIQUOR | vtinfo BISHOPS LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 105 m apart · name similarity 1.00 |
| doordash bishop's liquor fresno | overture Bishop's Liquor | 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 bishop's liquor fresno | vtinfo BISHOPS LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 101 m apart · name similarity 1.00 |
| overture Bishop's Liquor | vtinfo BISHOPS LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 82 m apart · name similarity 1.00 · phone: equal |
| ca-abc BISHOP LIQUOR | doordash bishop's liquor fresno | 0.80 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The records share the same street address and ZIP, the names match (Bishop Liquor and bishop's liquor, with the city appended to the DoorDash slug), it is the only business at that address, and the of Other Claude answers on this pair:
pair 9406b026cebb40377bb2 |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 100 within 1 mi · 776 within 3 mi
- Off / on premise
- 52 / 39 within 1 mi · 244 / 432 within 3 mi
- Selling alcohol
- 44 within 1 mi · 424 within 3 mi
- Nearest
- same channel 0.04 mi · licensed 0.04 mi
- Setting
- urban (5,772 people per sq mi)
- People within 3 mi
- 163,192 (111,935 adults 21+, 56,161 households) from 37 tract(s), tracts within 3 mi
- Income
- per capita $26,995 · median household ~$61,444 (weighted mean of tract medians)
- Age and education
- median age ~32.6 · bachelor's or higher 20%
- Ethnicity
- Hispanic 55% · White 33% · Black 6% · Asian 10%
- Adults per alcohol outlet
- 263
- Alcohol spend within 3 mi
- $29,972,121 a year ($14,340,993 at home, $15,616,036 away) · $70,523 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 | overture f9b04fc6-f741-4ef2-b6f6-f83d74c56d11 ↔ vtinfo 72cf10e4769b1fda | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2142456 ↔ vtinfo 72cf10e4769b1fda | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 52369451 ↔ vtinfo 72cf10e4769b1fda | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2142456 ↔ overture f9b04fc6-f741-4ef2-b6f6-f83d74c56d11 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2142456 ↔ doordash 52369451 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 52369451 ↔ overture f9b04fc6-f741-4ef2-b6f6-f83d74c56d11 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00569104|21|LIC|0 ↔ doordash 52369451 | Claude judge: same | merged |