Certified Oil

COLUMBUS, OH 43228 · O10ea16d36c04 · first seen 2026-11-12
3 sourcesoff premise · conveniencechain: Certified Oilalcohol: alcohol

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
Certified Oil
a source's own spelling of the licence name (record_title.py)no other value
Street
4580 ALKIRE RD
ab-inbevno other value
City
COLUMBUS
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
43228
ab-inbevno other value
Pin
39.91106, -83.11837 map 1 other
overture
120 m away ab-inbev
Phone
6148707628
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaec3f68eacc6; O7df3405bd769

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-inbevCERTIFIED OIL
2639326
4580 ALKIRE RD, COLUMBUS, OH, 4322839.91097, -83.116972026-11-122026-11-13
overtureCertified Oil
7b923bc4-2c4a-4228-9e66-c452158b60c2
4580 Alkire Rd, Columbus, OH, 43228614870762839.91106, -83.118372026-11-132026-11-13
vtinfoCERTIFIED OIL
65c7a5a74261537a
4580 ALKIRE RD, COLUMBUS, OH, 43228614870762839.91089, -83.118202026-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 CERTIFIED OILoverture Certified Oil1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 120 m apart · name similarity 1.00
ab-inbev CERTIFIED OILvtinfo CERTIFIED OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 105 m apart · name similarity 1.00
overture Certified Oilvtinfo CERTIFIED OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · convenience — overture-category
Chain
Certified Oil — overture-brand
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Labatt USA, Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
35 within 1 mi · 286 within 3 mi
Off / on premise
4 / 29 within 1 mi · 77 / 152 within 3 mi
Selling alcohol
12 within 1 mi · 139 within 3 mi
Nearest
same channel 0.53 mi · licensed 1.81 mi
Setting
suburban (2,845 people per sq mi)
People within 3 mi
80,449 (56,757 adults 21+, 32,162 households) from 17 tract(s), tracts within 3 mi
Income
per capita $33,226 · median household ~$66,858 (weighted mean of tract medians)
Age and education
median age ~33.8 · bachelor's or higher 22%
Ethnicity
Hispanic 13% · White 60% · Black 20% · Asian 3%
Adults per alcohol outlet
405
Alcohol spend within 3 mi
$18,024,951 a year ($8,581,660 at home, $9,435,395 away) · $128,750 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-13 14:10insertoverture 7b923bc4-2c4a-4228-9e66-c452158b60c2 ↔ vtinfo 65c7a5a74261537asame address and namemerged15
2026-11-13 14:10insertab-inbev 2639326 ↔ overture 7b923bc4-2c4a-4228-9e66-c452158b60c2same address and namemerged15
2026-11-12 14:25insertab-inbev 2639326 ↔ vtinfo 65c7a5a74261537asame address and namemerged12