MGA LIQUOR

FRESNO, CA 93703 · O0f244a8c04f2 · 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.

FieldMaster valueTaken fromWhat other sources say
Name
MGA LIQUOR 3 other
the most common name a source states
MGA LIQUOR #9 ca-abcoverture ×2
mga liquor fresno doordash
SINGH GURPREET ca-abc (legal name)
Street
2707 N BLACKSTONE AVE 1 other
ca-abc
2707 North Blackstone Avenue doordash
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93703
ca-abcno other value
Pin
36.77515, -119.79093 map 1 other
doordash
72 m away ab-inbev
Phone
5598400240
vtinfono other value
Licences
ca-abc 00583531|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O84fcf4408907; O4304925a0aa9; Oc60a119de773; O853b0b18858d

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-inbevMGA LIQUOR
4096526
2707 N BLACKSTONE AVE, FRESNO, CA, 9370336.77577, -119.790712026-11-112026-11-11
ca-abcMGA LIQUOR #9
legal name: SINGH GURPREET
00583531|21|LIC|0
2707 N BLACKSTONE AVE, FRESNO, CA, 9370336.77510, -119.790612026-10-082026-11-05
doordashmga liquor fresno
25953672
2707 North Blackstone Avenue, Fresno, CA, 9370336.77515, -119.790932026-10-082026-11-02
overtureMga Liquor #9
bcc3fe90-b329-48e9-8978-5e01ede3ab11
2707 N Blackstone Ave, Fresno, CA, 93703559840024036.77539, -119.790842026-11-062026-11-06
vtinfoMGA LIQUOR
2bc479b7bd51fec0
2707 N BLACKSTONE AVE, FRESNO, CA, 93703559840024036.77539, -119.790842026-11-122026-11-14

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 MGA LIQUORdoordash mga liquor fresno1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev MGA LIQUORvtinfo MGA LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 44 m apart · name similarity 1.00
ca-abc MGA LIQUOR #9overture Mga Liquor #91.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
doordash mga liquor fresnovtinfo MGA LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
ab-inbev MGA LIQUORca-abc MGA LIQUOR #90.79Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
MGA Liquor same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 2707 N Blackstone Ave, Fresno 93703 with a near-identical name 'MGA LIQUOR' (the CA record adds a store number #9), the building has only one business at that address, and the CA licence is an off-sale liquor store matching the AB InBev retail account.
pair 3259eaa8c1af565d6946
ca-abc MGA LIQUOR #9doordash mga liquor fresno0.79Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records give the same street address and ZIP and the same name, MGA Liquor, matching the off-sale licence; our data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 92% confident — Both records give the same street address, city, and ZIP (2707 N Blackstone Ave, Fresno 93703), with only one business at that address and a 0.03 km coordinate gap; the names MGA Liquor #9 and mga liquor fresno match, and the California record is an active off-sale liquor licence, consistent with a liquor store.
pair c0156fb6f14175422271

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:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
62 within 1 mi · 648 within 3 mi
Off / on premise
22 / 29 within 1 mi · 249 / 313 within 3 mi
Selling alcohol
45 within 1 mi · 438 within 3 mi
Nearest
same channel 0.17 mi · licensed 0.08 mi
Setting
urban (6,785 people per sq mi)
People within 3 mi
191,838 (130,470 adults 21+, 64,159 households) from 45 tract(s), tracts within 3 mi
Income
per capita $25,597 · median household ~$57,294 (weighted mean of tract medians)
Age and education
median age ~32.7 · bachelor's or higher 17%
Ethnicity
Hispanic 61% · White 29% · Black 6% · Asian 8%
Adults per alcohol outlet
297
Alcohol spend within 3 mi
$33,191,069 a year ($15,943,743 at home, $17,230,355 away) · $75,606 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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 17:29insertab-inbev 4096526 ↔ ca-abc 00583531|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertdoordash 25953672 ↔ vtinfo 2bc479b7bd51fec0same address and namemerged12
2026-11-12 14:25insertab-inbev 4096526 ↔ vtinfo 2bc479b7bd51fec0same address and namemerged12
2026-11-11 12:56insertab-inbev 4096526 ↔ doordash 25953672same address and namemerged12
2026-11-06 18:13insertca-abc 00583531|21|LIC|0 ↔ overture bcc3fe90-b329-48e9-8978-5e01ede3ab11same address and namemerged11
2026-11-02 23:02backfillca-abc 00583531|21|LIC|0 ↔ doordash 25953672Claude judge: samemerged