Trainwreck Saloon

SAINT LOUIS, MO 63144 · O9a5478895ce7 · first seen 2026-11-03
4 sourceson premise · restaurantalcohol: licensed1 licence

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
Trainwreck Saloon 1 other
a source's own spelling of the licence name (record_title.py)
TRAINWRECK 2.0 LLC mo-atc (legal name)
Street
9243 MANCHESTER 1 other
mo-atc
9243 MANCHESTER RD ab-inbevoverturevtinfo ×3
City
ROCK HILL 1 other
mo-atc
SAINT LOUIS ab-inbevvtinfo ×2
State
MO
mo-atcno other value
ZIP
63144
mo-atcno other value
Pin
38.61155, -90.35826 map 1 other
overture
99 m away ab-inbev
Phone
3149628148 1 other
vtinfo
3147492677 mo-atc
Licences
mo-atc MO|319825
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od2da65e7b619; Oe2819807e472; Oe2471ffc98cb

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-inbevTRAINWRECK SALOON
2545645
9243 MANCHESTER RD, SAINT LOUIS, MO, 6314438.61178, -90.357162026-11-112026-11-11
mo-atcTRAINWRECK SALOON
legal name: TRAINWRECK 2.0 LLC
MO|319825
9243 MANCHESTER, ROCK HILL, MO, 63144314749267738.61157, -90.357822026-11-032026-11-06
overtureTrainwreck Saloon
e65b0394-2217-486e-9ad7-5cba359276be
9243 Manchester Rd, Rock Hill, MO, 63144314962814838.61155, -90.358262026-11-062026-11-06
vtinfoTRAINWRECK SALOON
bb7f20c9d1b49b0a
9243 MANCHESTER RD, SAINT LOUIS, MO, 63144314962814838.61163, -90.358132026-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 TRAINWRECK SALOONmo-atc HANSFORD'S TRAIN WRECK SALOON0.61same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 62 m apart · matched through the licence's legal name: TRAIN WRECK SALOON INC. · name similarity 0.61
mo-atc HANSFORD'S TRAIN WRECK SALOONoverture Trainwreck Saloon0.61same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 38 m apart · matched through the licence's legal name: TRAIN WRECK SALOON INC. · name similarity 0.61 · phone: equal
mo-atc HANSFORD'S TRAIN WRECK SALOONvtinfo TRAINWRECK SALOON0.61same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 28 m apart · matched through the licence's legal name: TRAIN WRECK SALOON INC. · name similarity 0.61 · phone: equal
ab-inbev TRAINWRECK SALOONmo-atc TRAINWRECK SALOON1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 62 m apart · name similarity 1.00 · street similarity 0.87
ab-inbev TRAINWRECK SALOONoverture Trainwreck Saloon1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 99 m apart · name similarity 1.00
ab-inbev TRAINWRECK SALOONvtinfo TRAINWRECK SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 85 m apart · name similarity 1.00
mo-atc TRAINWRECK SALOONoverture Trainwreck Saloon1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 38 m apart · name similarity 1.00 · street similarity 0.87
overture Trainwreck Saloonvtinfo TRAINWRECK SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TRAINWRECK 2.0 LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MO Retail by Drink
Rule version 11, computed 2026-11-20 23:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
58 within 1 mi · 567 within 3 mi
Off / on premise
15 / 27 within 1 mi · 147 / 254 within 3 mi
Selling alcohol
32 within 1 mi · 348 within 3 mi
Nearest
same channel 0.20 mi · licensed 0.02 mi
Setting
urban (3,553 people per sq mi)
People within 3 mi
100,466 (76,282 adults 21+, 44,753 households) from 27 tract(s), tracts within 3 mi
Income
per capita $77,737 · median household ~$119,697 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 72%
Ethnicity
Hispanic 3% · White 80% · Black 6% · Asian 5%
Adults per alcohol outlet
219
Alcohol spend within 3 mi
$38,305,301 a year ($16,720,093 at home, $21,573,092 away) · $109,757 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-14 20:23insertmo-atc MO|22986 ↔ vtinfo bb7f20c9d1b49b0asame address and nameheld: same-source-conflict15
2026-11-14 20:23insertoverture e65b0394-2217-486e-9ad7-5cba359276be ↔ vtinfo bb7f20c9d1b49b0asame address and namemerged15
2026-11-12 14:25insertab-inbev 2545645 ↔ vtinfo bb7f20c9d1b49b0asame address and namemerged12
2026-11-11 12:56insertab-inbev 2545645 ↔ mo-atc MO|22986same address and nameheld: same-source-conflict12
2026-11-11 12:56insertab-inbev 2545645 ↔ mo-atc MO|319825street written two waysmerged12
2026-11-11 12:56insertab-inbev 2545645 ↔ overture e65b0394-2217-486e-9ad7-5cba359276besame address and namemerged12
2026-11-06 18:13insertmo-atc MO|22986 ↔ overture e65b0394-2217-486e-9ad7-5cba359276besame address and nameheld: same-source-conflict11
2026-11-06 18:13insertmo-atc MO|319825 ↔ overture e65b0394-2217-486e-9ad7-5cba359276bestreet written two waysmerged11