El Tranvia

COACHELLA, CA 92236 · O3562d0a47fd5 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: licensed2 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.

FieldMaster valueTaken fromWhat other sources say
Name
El Tranvia
a source's own spelling of the licence name (record_title.py)no other value
Street
1221 6TH ST
ca-abcno other value
City
COACHELLA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92236
ca-abcno other value
Pin
33.67685, -116.17932 map
overtureno other value
Phone
7603919772
vtinfono other value
Licences
ca-abc 00663285|47|LIC|0 · ca-abc 00663285|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O865ccad0f9a6; Od0351735264a; Of7674cc8e006; O40fbe4405e86

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-inbevEL TRANVIA
4168196
1221 6TH ST, COACHELLA, CA, 9223633.67713, -116.179292026-11-112026-11-11
ca-abcEL TRANVIA
00663285|47|LIC|0
1221 6TH ST, COACHELLA, CA, 922362026-10-082026-11-03
ca-abcEL TRANVIA
00663285|58|LIC|0
1221 6TH ST, COACHELLA, CA, 922362026-10-082026-11-03
overtureEl Tranvia
c11a5c79-acdf-45dd-a844-d250cd7fdb45
1221 6th St, Coachella, CA, 92236760391977233.67685, -116.179322026-11-062026-11-06
vtinfoEL TRANVIA
0b3b12457cb249ec
1221 6TH ST, COACHELLA, CA, 92236760391977233.67677, -116.179222026-11-142026-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 EL TRANVIAca-abc EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev EL TRANVIAca-abc EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev EL TRANVIAoverture El Tranvia1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev EL TRANVIAvtinfo EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ca-abc EL TRANVIAca-abc EL TRANVIA1.00one licence filemergedfile: 00663285 · same_address
ca-abc EL TRANVIAoverture El Tranvia1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc EL TRANVIAvtinfo EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc EL TRANVIAoverture El Tranvia1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc EL TRANVIAvtinfo EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture El Tranviavtinfo EL TRANVIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
81 within 1 mi · 144 within 3 mi
Off / on premise
29 / 43 within 1 mi · 52 / 72 within 3 mi
Selling alcohol
56 within 1 mi · 93 within 3 mi
Nearest
same channel 0.24 mi · licensed 0.14 mi
Setting
suburban (1,807 people per sq mi)
People within 3 mi
51,081 (36,383 adults 21+, 15,476 households) from 10 tract(s), tracts within 3 mi
Income
per capita $26,491 · median household ~$68,665 (weighted mean of tract medians)
Age and education
median age ~35.9 · bachelor's or higher 9%
Ethnicity
Hispanic 92% · White 12% · Black 1% · Asian 0%
Adults per alcohol outlet
387
Alcohol spend within 3 mi
$8,703,873 a year ($4,159,054 at home, $4,541,209 away) · $92,594 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”).
WhenEventPairRuleDecisionRule version
2026-11-14 20:23insertca-abc 00663285|47|LIC|0 ↔ vtinfo 0b3b12457cb249ecsame address and namemerged15
2026-11-14 20:23insertab-inbev 4168196 ↔ vtinfo 0b3b12457cb249ecsame address and namemerged15
2026-11-14 20:23insertoverture c11a5c79-acdf-45dd-a844-d250cd7fdb45 ↔ vtinfo 0b3b12457cb249ecsame address and namemerged15
2026-11-14 20:23insertca-abc 00663285|58|LIC|0 ↔ vtinfo 0b3b12457cb249ecsame address and namemerged15
2026-11-11 12:56insertab-inbev 4168196 ↔ overture c11a5c79-acdf-45dd-a844-d250cd7fdb45same address and namemerged12
2026-11-11 12:56insertab-inbev 4168196 ↔ ca-abc 00663285|58|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4168196 ↔ ca-abc 00663285|47|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00663285|58|LIC|0 ↔ overture c11a5c79-acdf-45dd-a844-d250cd7fdb45same address and namemerged11
2026-11-06 18:13insertca-abc 00663285|47|LIC|0 ↔ overture c11a5c79-acdf-45dd-a844-d250cd7fdb45same address and namemerged11
2026-10-09 13:59backfillca-abc 00663285|47|LIC|0 ↔ ca-abc 00663285|58|LIC|0one licence filemerged