Certified Oil

WESTERVILLE, OH 43081 · O833d3034f32a · first seen 2026-11-12
3 sourcesoff premise · conveniencealcohol: 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
131 S SUNBURY 1 other
ab-inbev
131 S Sunbury Rd overture
City
WESTERVILLE
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
43081
ab-inbevno other value
Pin
40.11902, -82.88605 map 1 other
overture
680 m away ab-inbev
Phone
6148394002
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8719c603f91d; Ob32624f80b77

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
3209375
131 S SUNBURY, WESTERVILLE, OH, 4308140.11291, -82.886322026-11-122026-11-13
overtureCertified Oil
5183b093-18a5-46aa-aa20-6b7f33bd7de7
131 S Sunbury Rd, Westerville, OH, 43081614839400240.11902, -82.886052026-11-182026-11-18
vtinfoCERTIFIED OIL
f01295e05eb7506b
131 S SUNBURY, WESTERVILLE, OH, 43081614839400240.11923, -82.886172026-11-132026-11-18

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.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 680 m apart · name similarity 1.00 · street similarity 0.86
ab-inbev CERTIFIED OILvtinfo CERTIFIED OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 703 m apart · name similarity 1.00
overture Certified Oilvtinfo CERTIFIED OIL1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 25 m apart · name similarity 1.00 · street similarity 0.86

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +8 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
2 within 1 mi · 179 within 3 mi
Off / on premise
1 / 0 within 1 mi · 37 / 106 within 3 mi
Selling alcohol
2 within 1 mi · 75 within 3 mi
Nearest
same channel none within 3 mi · licensed 2.52 mi
Setting
suburban (2,390 people per sq mi)
People within 3 mi
67,577 (49,542 adults 21+, 27,942 households) from 14 tract(s), tracts within 3 mi
Income
per capita $48,031 · median household ~$96,913 (weighted mean of tract medians)
Age and education
median age ~38.3 · bachelor's or higher 52%
Ethnicity
Hispanic 4% · White 73% · Black 15% · Asian 4%
Adults per alcohol outlet
652
Alcohol spend within 3 mi
$20,678,266 a year ($9,383,251 at home, $11,286,723 away) · $272,082 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-18 18:58insertoverture 5183b093-18a5-46aa-aa20-6b7f33bd7de7 ↔ vtinfo f01295e05eb7506bstreet written two waysmerged15
2026-11-18 18:58insertab-inbev 3209375 ↔ overture 5183b093-18a5-46aa-aa20-6b7f33bd7de7street written two waysmerged15
2026-11-13 14:10insertab-inbev 3209375 ↔ vtinfo f01295e05eb7506bsame address and namemerged15