PINS MECHANICAL COMPANY

COLUMBUS, OH 43215 · O2c3750221717 · first seen 2026-11-11
3 sourcesunknownalcohol: 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
PINS MECHANICAL COMPANY 1 other
the most common name a source states
Pins Mechanical Co. overture
Street
141 N 4TH ST
ab-inbevno other value
City
COLUMBUS
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
43215
ab-inbevno other value
Pin
39.96580, -82.99702 map
overtureno other value
Phone
6144642255
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O401e50f56650; O421bf90a3feb

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-inbevPINS MECHANICAL COMPANY
3994290
141 N 4TH ST, COLUMBUS, OH, 4321539.96603, -82.996922026-11-132026-11-13
overturePins Mechanical Co.
ae2a6539-aaab-427b-a2e2-b995a6b4fad9
141 N 4th St, Columbus, OH, 43215614464225539.96580, -82.997022026-11-132026-11-13
vtinfoPINS MECHANICAL COMPANY
52b148818a0eec9f
141 N 4TH ST, COLUMBUS, OH, 43215614464225539.96578, -82.997062026-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 PINS MECHANICAL COMPANYoverture Pins Mechanical Co.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ab-inbev PINS MECHANICAL COMPANYvtinfo PINS MECHANICAL COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 31 m apart · name similarity 1.00
overture Pins Mechanical Co.vtinfo PINS MECHANICAL COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
unknown
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +8 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
361 within 1 mi · 1,396 within 3 mi
Off / on premise
21 / 205 within 1 mi · 182 / 772 within 3 mi
Selling alcohol
219 within 1 mi · 699 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
urban (5,283 people per sq mi)
People within 3 mi
149,387 (109,706 adults 21+, 67,889 households) from 50 tract(s), tracts within 3 mi
Income
per capita $41,619 · median household ~$64,719 (weighted mean of tract medians)
Age and education
median age ~31.0 · bachelor's or higher 48%
Ethnicity
Hispanic 7% · White 57% · Black 27% · Asian 5%
Adults per alcohol outlet
157
Alcohol spend within 3 mi
$39,216,937 a year ($18,364,691 at home, $20,832,457 away) · $56,024 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 ae2a6539-aaab-427b-a2e2-b995a6b4fad9 ↔ vtinfo 52b148818a0eec9fsame address and namemerged15
2026-11-13 14:10insertab-inbev 3994290 ↔ vtinfo 52b148818a0eec9fsame address and namemerged15
2026-11-13 14:10insertab-inbev 3994290 ↔ overture ae2a6539-aaab-427b-a2e2-b995a6b4fad9same address and namemerged15