MAIN ST LIQUOR & GAS

HESPERIA, CA 92345 · Ob797b765ad8c · first seen 2026-10-08
1 sourceoff 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
MAIN ST LIQUOR & GAS 1 other
the most common name a source states
GHOTRA RETAIL MARKET INC ca-abc (legal name)
Street
16400 MAIN ST
ca-abcno other value
City
HESPERIA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92345
ca-abcno other value
Pin
34.42224, -117.30583 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00457978|21|APP|0
every licence and permit record in the outlet
Joined by singleton · absorbed ids: none

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
ca-abcMAIN ST LIQUOR & GAS
legal name: GHOTRA RETAIL MARKET INC
00457978|21|APP|0
16400 MAIN ST, HESPERIA, CA, 9234534.42224, -117.305832026-10-082026-11-05

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 MAIN STREET LIQUOR MARKET & GASca-abc MAIN ST LIQUOR & GAS0.63Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Main St Liquor & Gas same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 16400 Main St, Hesperia 92345, 38 m apart, with no other business at that address, and the names are near-identical abbreviations ('MAIN STREET LIQUOR MARKET & GAS' vs 'MAIN ST LIQUOR & GAS') for an off-sale liquor market; the licence being only an application leaves some doubt about a predecessor or successor.
pair 24c9dfbd115c1c176bf4
ca-abc MAIN ST LIQUOR & GASvtinfo MAIN STREET LIQUOR MARKET & GAS0.63one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 301576fced0e3214c023 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GHOTRA RETAIL MARKET INC — 1 outlets in the master under this operator
Licence privileges
none
Rule version 7, computed 2026-11-16 17:19.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
50 within 1 mi · 125 within 3 mi
Off / on premise
19 / 24 within 1 mi · 52 / 59 within 3 mi
Selling alcohol
42 within 1 mi · 96 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (2,369 people per sq mi)
People within 3 mi
66,992 (44,118 adults 21+, 19,347 households) from 12 tract(s), tracts within 3 mi
Income
per capita $24,808 · median household ~$71,057 (weighted mean of tract medians)
Age and education
median age ~31.9 · bachelor's or higher 10%
Ethnicity
Hispanic 65% · White 42% · Black 6% · Asian 1%
Adults per alcohol outlet
455
Alcohol spend within 3 mi
$11,077,758 a year ($5,245,737 at home, $5,827,842 away) · $114,204 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-16 14:56insertca-abc 00457978|21|APP|0 ↔ vtinfo 5622ac2f3a748a27one name contains the other, same addressheld: same-source-conflict15
2026-11-12 17:29insertab-inbev 536736 ↔ ca-abc 00457978|21|APP|0Claude judge: sameheld: same-source-conflict14