Certified Oil

COLUMBUS, OH 43223 · O71da7e7b9e43 · first seen 2026-11-11
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
856 FRANK RD
ab-inbevno other value
City
COLUMBUS
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
43223
ab-inbevno other value
Pin
39.91506, -83.02091 map 1 other
overture
353 m away ab-inbev
Phone
6143407031
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obf27f6ca77c4; O8871f9bdc7aa

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
4090769
856 FRANK RD, COLUMBUS, OH, 4322339.91461, -83.025002026-11-122026-11-13
overtureCertified Oil
bf49863d-6221-4c80-93ca-7d655a12ff6d
856 Frank Rd, Columbus, OH, 43223614340703139.91506, -83.020912026-11-132026-11-13
vtinfoCERTIFIED OIL
094fa807904c4e8e
856 FRANK RD, COLUMBUS, OH, 43223614340703139.91509, -83.020792026-11-112026-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 353 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 363 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 + ZIP · pins 11 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 Boston Beer, Bud Light (AB InBev), Diageo Beer Company +4 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
5 within 1 mi · 402 within 3 mi
Off / on premise
2 / 1 within 1 mi · 105 / 204 within 3 mi
Selling alcohol
4 within 1 mi · 229 within 3 mi
Nearest
same channel 0.47 mi · licensed 1.38 mi
Setting
suburban (2,723 people per sq mi)
People within 3 mi
76,986 (59,017 adults 21+, 32,657 households) from 23 tract(s), tracts within 3 mi
Income
per capita $36,776 · median household ~$65,539 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 26%
Ethnicity
Hispanic 9% · White 67% · Black 18% · Asian 2%
Adults per alcohol outlet
257
Alcohol spend within 3 mi
$18,269,661 a year ($8,651,479 at home, $9,609,783 away) · $79,433 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 bf49863d-6221-4c80-93ca-7d655a12ff6d ↔ vtinfo 094fa807904c4e8esame address and namemerged15
2026-11-13 14:10insertab-inbev 4090769 ↔ overture bf49863d-6221-4c80-93ca-7d655a12ff6dsame address and namemerged15
2026-11-12 14:25insertab-inbev 4090769 ↔ vtinfo 094fa807904c4e8esame address and namemerged12