Certified Oil

COLUMBUS, OH 43223 · O41a1fdeb8b9a · first seen 2026-10-08
4 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 1 other
a source's own spelling of the licence name (record_title.py)
certified oil columbus doordash
Street
1093 Frank Road 1 other
doordash
1093 FRANK RD ab-inbevoverturevtinfo ×3
City
Columbus
doordashno other value
State
OH
doordashno other value
ZIP
43223
doordashno other value
Pin
39.91609, -83.03558 map
doordashno other value
Phone
6143514476
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oab24318986b8; Ofd6150d7bb41; Obf15f0b626a1

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
2639189
1093 FRANK RD, COLUMBUS, OH, 4322339.91644, -83.035662026-11-122026-11-12
doordashcertified oil columbus
23917481
1093 Frank Road, Columbus, OH, 4322339.91609, -83.035582026-10-082026-11-01
overtureCertified Oil
42b20aef-f555-48ee-9fc4-5ca92de50760
1093 Frank Rd, Columbus, OH, 43223614351447639.91617, -83.035442026-11-062026-11-06
vtinfoCERTIFIED OIL
4fe7dd03e6be86be
1093 FRANK RD, COLUMBUS, OH, 43223614351447639.91611, -83.035672026-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 OILdoordash certified oil columbus1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
ab-inbev CERTIFIED OILoverture Certified Oil1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 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 37 m apart · name similarity 1.00
doordash certified oil columbusoverture Certified Oil1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
doordash certified oil columbusvtinfo CERTIFIED OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 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 20 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · convenience — doordash-url
Chain
Certified Oil — overture-brand
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Diageo Beer Company, Heineken USA +5 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
10 within 1 mi · 420 within 3 mi
Off / on premise
1 / 6 within 1 mi · 118 / 217 within 3 mi
Selling alcohol
5 within 1 mi · 227 within 3 mi
Nearest
same channel 0.78 mi · licensed 0.94 mi
Setting
urban (3,204 people per sq mi)
People within 3 mi
90,583 (67,656 adults 21+, 36,443 households) from 24 tract(s), tracts within 3 mi
Income
per capita $34,580 · median household ~$67,278 (weighted mean of tract medians)
Age and education
median age ~35.7 · bachelor's or higher 23%
Ethnicity
Hispanic 10% · White 68% · Black 15% · Asian 2%
Adults per alcohol outlet
297
Alcohol spend within 3 mi
$20,453,749 a year ($9,687,829 at home, $10,756,384 away) · $89,709 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-12 14:25insertdoordash 23917481 ↔ vtinfo 4fe7dd03e6be86besame address and namemerged12
2026-11-12 14:25insertab-inbev 2639189 ↔ vtinfo 4fe7dd03e6be86besame address and namemerged12
2026-11-12 14:25insertoverture 42b20aef-f555-48ee-9fc4-5ca92de50760 ↔ vtinfo 4fe7dd03e6be86besame address and namemerged12
2026-11-12 14:25insertab-inbev 2639189 ↔ doordash 23917481same address and namemerged12
2026-11-12 14:25insertab-inbev 2639189 ↔ overture 42b20aef-f555-48ee-9fc4-5ca92de50760same address and namemerged12
2026-11-06 18:13insertdoordash 23917481 ↔ overture 42b20aef-f555-48ee-9fc4-5ca92de50760same address and namemerged11