Ampm

REDWOOD CITY, CA 94063 · O4fad946c40fd · first seen 2026-10-08
4 sourcesoff premise · conveniencechain: AMPMalcohol: 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
Ampm 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ARCO AM/PM GAS STATION ca-abc
VAMS CORPORATION ca-abc (legal name)
Street
1700 MIDDLEFIELD RD
ca-abcno other value
City
REDWOOD CITY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94063
ca-abcno other value
Pin
37.48193, -122.22148 map
overtureno other value
Phone
6503652583 1 other
vtinfo
6503623100 overture
Licences
ca-abc 00645242|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O832bc180e22b; O5458ba3093da; Od3cb2670d80f

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-inbevAMPM
2910442
1700 MIDDLEFIELD RD, REDWOOD CITY, CA, 9406337.48188, -122.221092026-11-112026-11-11
ca-abcARCO AM/PM GAS STATION
legal name: VAMS CORPORATION
00645242|20|LIC|0
1700 MIDDLEFIELD RD, REDWOOD CITY, CA, 9406337.48213, -122.221602026-10-082026-11-16
overtureampm
8452e7ae-9ea3-46d0-92e6-c0ad022ceb39
1700 Middlefield Rd, Redwood City, CA, 94063650362310037.48193, -122.221482026-11-132026-11-13
vtinfoAMPM
b3a42dbb0cf3f608
1700 MIDDLEFIELD RD, REDWOOD CITY, CA, 94063650365258337.48183, -122.221502026-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 AMPMoverture ampm1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ab-inbev AMPMvtinfo AMPM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00
overture ampmvtinfo AMPM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00 · phone: differs
ab-inbev AMPMca-abc ARCO AM/PM GAS STATION0.15one name contains the other, same addressmergedjudge: None · pair_id: 5c091aeeef215fa2e97a · person: None · rule: names contained at one address · stratum: same-address
ca-abc ARCO AM/PM GAS STATIONvtinfo AMPM0.15one name contains the other, same addressmergedjudge: None · pair_id: 277fcdd4ac075e0a90f9 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
off_premise · convenience — ca-licence
Chain
AMPM — name-prefix
Alcohol
licensed — a licence or TTB permit on file
Operator
VAMS CORPORATION — 3 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
305 within 1 mi · 769 within 3 mi
Off / on premise
51 / 206 within 1 mi · 143 / 492 within 3 mi
Selling alcohol
174 within 1 mi · 474 within 3 mi
Nearest
same channel 0.20 mi · licensed 0.20 mi
Setting
urban (3,692 people per sq mi)
People within 3 mi
104,376 (78,191 adults 21+, 36,248 households) from 26 tract(s), tracts within 3 mi
Income
per capita $91,483 · median household ~$170,948 (weighted mean of tract medians)
Age and education
median age ~38.7 · bachelor's or higher 53%
Ethnicity
Hispanic 38% · White 43% · Black 3% · Asian 14%
Adults per alcohol outlet
165
Alcohol spend within 3 mi
$37,545,399 a year ($15,854,726 at home, $21,681,546 away) · $79,043 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-16 14:56insertca-abc 00645242|20|LIC|0 ↔ vtinfo b3a42dbb0cf3f608one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2910442 ↔ ca-abc 00645242|20|LIC|0one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture 8452e7ae-9ea3-46d0-92e6-c0ad022ceb39 ↔ vtinfo b3a42dbb0cf3f608same address and namemerged15
2026-11-13 14:10insertab-inbev 2910442 ↔ overture 8452e7ae-9ea3-46d0-92e6-c0ad022ceb39same address and namemerged15
2026-11-12 14:25insertab-inbev 2910442 ↔ vtinfo b3a42dbb0cf3f608same address and namemerged12